epam / edp-ddm-registry-postgresFile Size

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 107 files with 3,516 lines of code.

0 very long files (0 lines of code)
1 long files (501 lines of code)
1 medium size files (400 lines of codeclsfd_ftr_w_mp_ins)
3 small files (378 lines of code)
102 very small files (2,237 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
00010_create-engine.sql in platform-db/changesets/camunda	501	-
00020_create-history.sql in platform-db/changesets/camunda	400	-
postgres.yaml in deploy-templates/templates	146	-
values.yaml in deploy-templates	125	-
run-db-scripts-job.yaml in deploy-templates/templates	107	-
00040_create-case-engine.sql in platform-db/changesets/camunda	94	-
p_load_table_from_csv.sql in platform-db/changesets/registry/procedures	91	-
tpl _helpers.tpl in deploy-templates/templates	91	-
podmonitor.yaml in deploy-templates/templates	86	-
00070_create-decision-history.sql in platform-db/changesets/camunda	82	-
00030_create-identity.sql in platform-db/changesets/camunda	80	-
operational-pool-deploy.yaml in deploy-templates/templates	74	-
p_format_sys_columns.sql in platform-db/changesets/registry/procedures	73	-
p_row_update.sql in platform-db/changesets/registry/procedures	66	-
f_check_permissions_dcm.sql in platform-db/changesets/registry/procedures	65	-
audit-clean-cron-job.yaml in deploy-templates/templates	61	-
f_row_insert.sql in platform-db/changesets/registry/procedures	54	-
f_check_permissions.sql in platform-db/changesets/registry/procedures	51	-
p_row_delete.sql in platform-db/changesets/registry/procedures	48	-
operational-pool-configmap.yaml in deploy-templates/templates	48	-
00010_initial-db-setup.sql in platform-db/changesets/audit	47	-
00060_create-tables.sql in platform-db/changesets/registry	46	-
00050_create-case-history.sql in platform-db/changesets/camunda	42	-
00010_initial-db-setup.sql in platform-db/changesets/process_history	42	-
00060_create-decision-engine.sql in platform-db/changesets/camunda	37	-
audit_event_system_event_v.sql in platform-db/changesets/audit/views	36	-
p_version_control.sql in platform-db/changesets/registry/procedures	36	-
00010_initial-db-setup.sql in platform-db/changesets/excerpt	34	-
p_grant_analytics_user.sql in platform-db/changesets/registry/procedures	33	-
f_trg_check_m2m_integrity.sql in platform-db/changesets/registry/procedures	32	-
p_revoke_analytics_user.sql in platform-db/changesets/registry/procedures	31	-
00130_change-owner.sql in platform-db/changesets/registry	30	-
audit_event_user_action_v.sql in platform-db/changesets/audit/views	27	-
f_get_tables_to_replicate.sql in platform-db/changesets/registry/procedures	27	-
p_init_new_hist_table.sql in platform-db/changesets/registry/procedures	24	-
roles-secrets-env.yaml in deploy-templates/templates	24	-
00020_notification-channels.sql in platform-db/changesets/settings	23	-
audit_event_security_event_v.sql in platform-db/changesets/audit/views	23	-
f_get_id_from_ref_array_table.sql in platform-db/changesets/registry/procedures	22	-
f_get_source_data_id.sql in platform-db/changesets/registry/procedures	22	-
00050_create-types.sql in platform-db/changesets/registry	22	-
f_get_id_from_ref_table.sql in platform-db/changesets/registry/procedures	21	-
UpdateReleaseName.groovy in upgrade-scripts/pre-install/one-time	19	1
p_delete_analytics_user.sql in platform-db/changesets/registry/procedures	19	-
00020_add-template-attributes.sql in platform-db/changesets/notifications	19	-
f_get_id_name.sql in platform-db/changesets/registry/procedures	18	-
f_get_ref_record.sql in platform-db/changesets/registry/procedures	17	-
00010_initial_db-setup.sql in platform-db/changesets/notifications	15	-
CreateMinioSecret.groovy in upgrade-scripts/pre-install/one-time	14	1
CreateMinioSecretUpgrade.groovy in upgrade-scripts/pre-upgrade/one-time	14	1

Files With Most Units (Top 3)

File	# lines	# units
CreateMinioSecret.groovy in upgrade-scripts/pre-install/one-time	14	1
UpdateReleaseName.groovy in upgrade-scripts/pre-install/one-time	19	1
CreateMinioSecretUpgrade.groovy in upgrade-scripts/pre-upgrade/one-time	14	1

Files With Long Lines (Top 36)

There are 36 files with lines longer than 120 characters. In total, there are 96 long lines.

File	# lines	# units	# long lines
p_format_sys_columns.sql in platform-db/changesets/registry/procedures	73	-	13
f_check_permissions.sql in platform-db/changesets/registry/procedures	51	-	10
p_load_table_from_csv.sql in platform-db/changesets/registry/procedures	91	-	9
UpdateReleaseName.groovy in upgrade-scripts/pre-install/one-time	19	1	7
f_check_permissions_dcm.sql in platform-db/changesets/registry/procedures	65	-	6
postgres.yaml in deploy-templates/templates	146	-	6
p_row_update.sql in platform-db/changesets/registry/procedures	66	-	3
f_get_source_data_id.sql in platform-db/changesets/registry/procedures	22	-	3
audit-clean-cron-job.yaml in deploy-templates/templates	61	-	3
CreateMinioSecret.groovy in upgrade-scripts/pre-install/one-time	14	1	2
CreateMinioSecretUpgrade.groovy in upgrade-scripts/pre-upgrade/one-time	14	1	2
f_trg_check_m2m_integrity.sql in platform-db/changesets/registry/procedures	32	-	2
p_row_delete.sql in platform-db/changesets/registry/procedures	48	-	2
p_version_control.sql in platform-db/changesets/registry/procedures	36	-	2
f_get_id_from_ref_table.sql in platform-db/changesets/registry/procedures	21	-	2
00070_publication.sql in platform-db/changesets/registry	3	-	2
00060_create-tables.sql in platform-db/changesets/registry	46	-	2
run-db-scripts-job.yaml in deploy-templates/templates	107	-	2
settings-changelog.xml in platform-db/changesets	9	-	1
audit-changelog.xml in platform-db/changesets	9	-	1
worker-postgres-changelog.xml in platform-db/changesets	9	-	1
worker-registry-changelog.xml in platform-db/changesets	9	-	1
process_history-changelog.xml in platform-db/changesets	9	-	1
00020_create-history.sql in platform-db/changesets/camunda	400	-	1
notifications-changelog.xml in platform-db/changesets	9	-	1
registry-changelog.xml in platform-db/changesets	9	-	1
postgres-changelog.xml in platform-db/changesets	9	-	1
0020_extend-audit-type-constraint.sql in platform-db/changesets/audit	2	-	1
p_init_new_hist_table.sql in platform-db/changesets/registry/procedures	24	-	1
f_get_id_from_ref_array_table.sql in platform-db/changesets/registry/procedures	22	-	1
f_get_id_name.sql in platform-db/changesets/registry/procedures	18	-	1
f_row_insert.sql in platform-db/changesets/registry/procedures	54	-	1
00080_subscription.sql in platform-db/changesets/registry	1	-	1
excerpt-changelog.xml in platform-db/changesets	9	-	1
00020_update-index.sql in platform-db/changesets/process_history	2	-	1
Chart.yaml in deploy-templates	6	-	1

Correlations

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

		501.0	lines of code min: 1.0 average: 51.42 25th percentile: 6.5 median: 14.0 75th percentile: 67.5 max: 501.0
0	17.0
commits (all time) min: 1.0 \| average: 2.04 \| 25th percentile: 1.0 \| median: 1.0 \| 75th percentile: 2.0 \| max: 17.0

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

		501.0	lines of code min: 1.0 average: 51.42 25th percentile: 6.5 median: 14.0 75th percentile: 67.5 max: 501.0
0	7.0
contributors (all time) min: 1.0 \| average: 1.38 \| 25th percentile: 1.0 \| median: 1.0 \| 75th percentile: 1.0 \| max: 7.0

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

No data for "commits (30d)" vs. "lines of code".

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

No data for "contributors (30d)" vs. "lines of code".

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

No data for "commits (90d)" vs. "lines of code".

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

No data for "contributors (90d)" vs. "lines of code".