apache / cloudberry

Intro

File size measurements show the distribution of size of files.
Files are classified in four categories based on their size (lines of code): 1-100 (very small files), 101-200 (small files), 201-500 (medium size files), 501-1000 (long files), 1001+(very long files).
It is a good practice to keep files small. Long files may become "bloaters", code that have increased to such gargantuan proportions that they are hard to work with.

Learn more...

File Size Overall

There are 6,235 files with 1,446,295 lines of code.

327 very long files (675,336 lines of code)
374 long files (263,662 lines of code)
716 medium size files (226,826 lines of codeclsfd_ftr_w_mp_ins)
880 small files (123,420 lines of code)
3,938 very small files (157,051 lines of code)

Legend:

1001+

501-1000

201-500

101-200

1-100

explore: grouped by folders | grouped by size | sunburst | 3D view

File Size per Extension

1001+

501-1000

201-500

101-200

1-100

File Size per Logical Decomposition

primary

1001+

501-1000

201-500

101-200

1-100

Longest Files (Top 50)

File	# lines	# units
unicode_norm_table.h in src/include/common	8910	-
unicode_normprops_table.h in src/include/common	7748	-
stem_UTF_8_serbian.c in src/backend/snowball/libstemmer	6509	8
createplan.c in src/backend/optimizer/plan	5755	2
copyfuncs.c in src/backend/nodes	5535	-
objectaddress.c in src/backend/catalog	5308	1
planner.c in src/backend/optimizer/plan	5183	1
CTranslatorExprToDXL.cpp in src/backend/gporca/libgpopt/src/translate	5170	1
pl_exec.c in src/pl/plpgsql/src	5019	3
guc_gp.c in src/backend/utils/misc	5008	3
formatting.c in src/backend/utils/adt	4803	2
fe-connect.c in src/interfaces/libpq	4757	3
aclchk.c in src/backend/catalog	4689	1
CTranslatorDXLToPlStmt.cpp in src/backend/gpopt/translate	4578	-
arrayfuncs.c in src/backend/utils/adt	4577	1
ic_udpifc.c in contrib/interconnect/udp	4549	7
selfuncs.c in src/backend/utils/adt	4543	2
timestamp.c in src/backend/utils/adt	4482	4
outfuncs.c in src/backend/nodes	4464	-
explain.c in src/backend/commands	4455	1
datumstreamblock.c in src/backend/utils/datumstream	4245	1
postgres_fdw.c in contrib/postgres_fdw	4238	1
postmaster.c in src/backend/postmaster	4181	3
varlena.c in src/backend/utils/adt	4031	1
xact.c in src/backend/access/transam	4014	2
jsonfuncs.c in src/backend/utils/adt	3917	1
pathnode.c in src/backend/optimizer/util	3916	1
trigger.c in src/backend/commands	3862	2
CUtils.cpp in src/backend/gporca/libgpopt/src/base	3842	-
md.xml in src/backend/gporca/data/dxl/metadata	3728	-
equalfuncs.c in src/backend/nodes	3716	-
y pl_gram.y in src/pl/plpgsql/src	3672	-
pg_hint_plan.c in gpcontrib/pg_hint_plan	3664	2
parse_utilcmd.c in src/backend/parser	3633	1
postgres.c in src/backend/tcop	3580	2
pgstat.c in src/backend/postmaster	3568	-
stem_UTF_8_greek.c in src/backend/snowball/libstemmer	3522	35
geo_ops.c in src/backend/utils/adt	3503	1
costsize.c in src/backend/optimizer/path	3411	4
nodeFuncs.c in src/backend/nodes	3392	1
zic.c in src/timezone	3380	1
CTranslatorQueryToDXL.cpp in src/backend/gpopt/translate	3372	-
utility.c in src/backend/tcop	3319	1
datetime.c in src/backend/utils/adt	3317	2
analyze.c in src/backend/commands	3269	2
elog.c in src/backend/utils/error	3265	1
clauses.c in src/backend/optimizer/util	3258	3
xml.c in src/backend/utils/adt	3223	3
procarray.c in src/backend/storage/ipc	3212	1
acl.c in src/backend/utils/adt	3211	1

Files With Most Units (Top 50)

File	# lines	# units
pax_oper.cc in contrib/pax_storage/src/cpp/storage/oper	1763	244
cbdb_wrappers.cc in contrib/pax_storage/src/cpp/comm	515	57
pax_access_handle.cc in contrib/pax_storage/src/cpp/access	942	55
parse.c in gpcontrib/gpmapreduce/src	1686	52
pax_column.cc in contrib/pax_storage/src/cpp/storage/columns	381	47
postgres.h in src/include	277	41
stem_UTF_8_turkish.c in src/backend/snowball/libstemmer	1987	41
micro_partition_stats.cc in contrib/pax_storage/src/cpp/storage	1294	39
sqlscan.c in gpcontrib/orafce	2243	36
s3exception.h in gpcontrib/gpcloud/include	186	36
stem_UTF_8_greek.c in src/backend/snowball/libstemmer	3522	35
bitmap.h in contrib/pax_storage/src/cpp/comm	265	34
pax_manifest.cc in contrib/pax_storage/src/cpp/catalog	812	33
pax_rlev2_decoding.cc in contrib/pax_storage/src/cpp/storage/columns	836	32
pax_buffer.h in contrib/pax_storage/src/cpp/storage	198	31
pax_aux_table.cc in contrib/pax_storage/src/cpp/catalog	587	31
pax_vec_column.cc in contrib/pax_storage/src/cpp/storage/columns	253	30
utilities.c in src/backend/snowball/libstemmer	426	28
pax.cc in contrib/pax_storage/src/cpp/storage	541	26
vcregress.pl in src/tools/msvc	665	25
pax_vec_adapter.cc in contrib/pax_storage/src/cpp/storage/vec	953	25
pax_columns.cc in contrib/pax_storage/src/cpp/storage/columns	615	24
s3params.h in gpcontrib/gpcloud/include	137	24
li_extras.py in src/include/catalog	231	22
regc_lex.c in src/backend/regex	895	22
stem_UTF_8_arabic.c in src/backend/snowball/libstemmer	1594	22
pax_manifest_impl.cc in contrib/pax_storage/src/cpp/catalog	374	22
Project.pm in src/tools/msvc	381	21
manifest.c in contrib/pax_storage/src/cpp/manifest	544	21
pax_access_method_internal.cc in contrib/pax_storage/src/cpp/access	423	21
paxc_wal.cc in contrib/pax_storage/src/cpp/storage/wal	347	21
pax_compress.cc in contrib/pax_storage/src/cpp/storage/columns	176	21
s3key_reader.h in gpcontrib/gpcloud/include	182	21
mapred.c in gpcontrib/gpmapreduce/src	2815	21
orc_writer.cc in contrib/pax_storage/src/cpp/storage/orc	822	20
pax_rlev2_encoding.cc in contrib/pax_storage/src/cpp/storage/columns	746	20
operators.c in gpcontrib/gp_sparse_vector	1069	20
s3utils.cpp in gpcontrib/gpcloud/src	340	20
Solution.pm in src/tools/msvc	1165	18
pax_sparse_filter.cc in contrib/pax_storage/src/cpp/storage/filter	1001	18
local_file_system.cc in contrib/pax_storage/src/cpp/storage	210	18
fstream.c in src/backend/utils/misc/fstream	765	17
cbdb_wrappers.h in contrib/pax_storage/src/cpp/comm	190	17
pax_column.h in contrib/pax_storage/src/cpp/storage/columns	199	17
s3interface.cpp in gpcontrib/gpcloud/src	451	17
Install.pm in src/tools/msvc	687	16
MSBuildProject.pm in src/tools/msvc	445	16
stem_UTF_8_english.c in src/backend/snowball/libstemmer	1019	16
stem_ISO_8859_1_english.c in src/backend/snowball/libstemmer	1007	16
gpsegstart.py in gpMgmt/sbin	196	16

Files With Long Lines (Top 50)

There are 689 files with lines longer than 120 characters. In total, there are 4797 long lines.

File	# lines	# units	# long lines
d2s_full_table.h in src/common	316	-	297
wxs greenplum-clients.wxs in gpAux/client/install/src/windows	1079	-	271
md.xml in src/backend/gporca/data/dxl/metadata	3728	-	154
gp2pg_postgres_fdw.sql in contrib/postgres_fdw/sql	1694	-	153
postgres_fdw.sql in contrib/postgres_fdw/sql	2360	-	123
ut-L.sql in gpcontrib/pg_hint_plan/sql	386	-	97
ut-S.sql in gpcontrib/pg_hint_plan/sql	541	-	82
orafce.sql in gpcontrib/orafce/sql	878	-	77
ut-J.sql in gpcontrib/pg_hint_plan/sql	381	-	76
ut-R.sql in gpcontrib/pg_hint_plan/sql	717	-	75
ic_udpifc.c in contrib/interconnect/udp	4549	7	74
pg_hint_plan.sql in gpcontrib/pg_hint_plan/sql	399	-	72
stem_UTF_8_greek.c in src/backend/snowball/libstemmer	3522	35	71
datumstreamblock.c in src/backend/utils/datumstream	4245	1	64
orafce--4.9.sql in gpcontrib/orafce	3188	-	60
vcxproj orafce.2010.vcxproj in gpcontrib/orafce/msvc	522	-	52
Numeric-Output-2-LTE-MaxBoundary.xml in src/backend/gporca/data/dxl/statistics	109	-	50
Numeric-Output-2-GTE-MinBoundary.xml in src/backend/gporca/data/dxl/statistics	109	-	50
Numeric-Output-2-LT-MaxBoundary.xml in src/backend/gporca/data/dxl/statistics	109	-	50
Numeric-Output-2-GT-MinBoundary.xml in src/backend/gporca/data/dxl/statistics	109	-	50
orafce--3.13.sql in gpcontrib/orafce	2572	-	50
guc_gp.c in src/backend/utils/misc	5008	3	47
pg_hint_plan-ja.html in gpcontrib/pg_hint_plan/doc	652	-	47
cdbappendonlystorage_int.h in src/include/cdb	146	-	42
gp_sparse_vector--1.0.1.sql in gpcontrib/gp_sparse_vector	317	-	38
WinFunc-OuterRef-Partition-Order-Query.xml in src/backend/gporca/data/dxl/expressiontests	742	-	37
WinFunc-OuterRef-Partition-Query.xml in src/backend/gporca/data/dxl/expressiontests	726	-	36
pg_hint_plan.html in gpcontrib/pg_hint_plan/doc	437	-	36
wchar.c in src/common	1496	-	35
WinFunc-OuterRef-Partition-Order-Frames-Query.xml in src/backend/gporca/data/dxl/expressiontests	745	-	35
q26-Metadata.xml in src/backend/gporca/data/dxl/parse_tests	303	-	29
createas.c in src/backend/commands	1222	1	29
LOJ-TO-InnerJoin-Q11.xml in src/backend/gporca/data/dxl/expressiontests	574	-	28
LOJ-TO-InnerJoin-Q15.xml in src/backend/gporca/data/dxl/expressiontests	363	-	28
LOJ-TO-InnerJoin-Q3.xml in src/backend/gporca/data/dxl/expressiontests	574	-	28
LOJ-TO-InnerJoin-Q1.xml in src/backend/gporca/data/dxl/expressiontests	569	-	28
LOJ-TO-InnerJoin-Q2.xml in src/backend/gporca/data/dxl/expressiontests	569	-	28
LOJ-TO-InnerJoin-Q10.xml in src/backend/gporca/data/dxl/expressiontests	561	-	28
LOJ-TO-InnerJoin-Q13.xml in src/backend/gporca/data/dxl/expressiontests	574	-	28
LOJ-TO-InnerJoin-Q16.xml in src/backend/gporca/data/dxl/expressiontests	381	-	28
LOJ-TO-InnerJoin-Q9.xml in src/backend/gporca/data/dxl/expressiontests	574	-	28
LOJ-TO-InnerJoin-Q8.xml in src/backend/gporca/data/dxl/expressiontests	574	-	28
LOJ-TO-InnerJoin-Q4.xml in src/backend/gporca/data/dxl/expressiontests	574	-	28
LOJ-TO-InnerJoin-Q12.xml in src/backend/gporca/data/dxl/expressiontests	574	-	28
LOJ-TO-InnerJoin-Q7.xml in src/backend/gporca/data/dxl/expressiontests	573	-	28
LOJ-TO-InnerJoin-Q14.xml in src/backend/gporca/data/dxl/expressiontests	574	-	28
execute.c in src/interfaces/ecpg/ecpglib	1719	-	26
stem_UTF_8_tamil.c in src/backend/snowball/libstemmer	1789	15	26
cdbappendonlystorageread.c in src/backend/cdb	862	-	24
information_schema.sql in src/backend/catalog	2009	-	23

Correlations

File Size vs. Commits (all time): 6236 points

		8910.0	lines of code min: 1.0 average: 231.93 25th percentile: 30.0 median: 62.0 75th percentile: 176.0 max: 8910.0
0	1435.0
commits (all time) min: 1.0 \| average: 31.94 \| 25th percentile: 5.0 \| median: 9.0 \| 75th percentile: 24.0 \| max: 1435.0

File Size vs. Contributors (all time): 6236 points

		8910.0	lines of code min: 1.0 average: 231.93 25th percentile: 30.0 median: 62.0 75th percentile: 176.0 max: 8910.0
0	117.0
contributors (all time) min: 1.0 \| average: 8.64 \| 25th percentile: 4.0 \| median: 5.0 \| 75th percentile: 10.0 \| max: 117.0

File Size vs. Commits (30 days): 29 points

		5170.0	lines of code min: 30.0 average: 1264.03 25th percentile: 166.0 median: 692.0 75th percentile: 2437.5 max: 5170.0
0	1.0
commits (30d) min: 1.0 \| average: 1.0 \| 25th percentile: 1.0 \| median: 1.0 \| 75th percentile: 1.0 \| max: 1.0

File Size vs. Contributors (30 days): 29 points

		5170.0	lines of code min: 30.0 average: 1264.03 25th percentile: 166.0 median: 692.0 75th percentile: 2437.5 max: 5170.0
0	1.0
contributors (30d) min: 1.0 \| average: 1.0 \| 25th percentile: 1.0 \| median: 1.0 \| 75th percentile: 1.0 \| max: 1.0

File Size vs. Commits (90 days): 817 points

		5755.0	lines of code min: 1.0 average: 609.52 25th percentile: 54.0 median: 187.0 75th percentile: 716.0 max: 5755.0
0	6.0
commits (90d) min: 1.0 \| average: 1.35 \| 25th percentile: 1.0 \| median: 1.0 \| 75th percentile: 2.0 \| max: 6.0

File Size vs. Contributors (90 days): 817 points

		5755.0	lines of code min: 1.0 average: 609.52 25th percentile: 54.0 median: 187.0 75th percentile: 716.0 max: 5755.0
0	5.0
contributors (90d) min: 1.0 \| average: 1.22 \| 25th percentile: 1.0 \| median: 1.0 \| 75th percentile: 1.0 \| max: 5.0