GoogleCloudPlatform / database-assessment
File Change Frequency

File change frequency (churn) shows the distribution of file updates (days with at least one commit).

Overview
File Change Frequency Overall
  • There are 241 files with 23,396 lines of code.
    • 0 files changed more than 100 times (0 lines of code)
    • 0 files changed 51-100 times (0 lines of code)
    • 2 files changed 21-50 times (1,132 lines of code)
    • 91 files changed 6-20 times (11,670 lines of code)
    • 148 files changed 1-5 times (10,594 lines of code)
0% | 0% | 4% | 49% | 45%
Legend:
101+
51-100
21-50
6-20
1-5

explore: grouped by folders | grouped by update frequency | data
Contributors Count Frequency Overall
  • There are 241 files with 23,396 lines of code.
    • 0 files changed by more than 25 contributors (0 lines of code)
    • 0 files changed by 11-25 contributors (0 lines of code)
    • 0 files changed by 6-10 contributors (0 lines of code)
    • 155 files changed by 2-5 contributors (18,233 lines of code)
    • 86 files changed by 1 contributor (5,163 lines of code)
0% | 0% | 0% | 77% | 22%
Legend:
26+
11-25
6-10
2-5
1

explore: grouped by folders | grouped by contributors count | data
File Change Frequency per File Extension
sql, py, md, yaml, sh, ps1, txt, bat, json, cfg, gitignore, toml, psm1, sed, editorconfig, prettierignore
File Change Frequency per Extension
The number of recorded file updates
101+
51-100
21-50
6-20
1-5
ps10% | 0% | 36% | 55% | 7%
toml0% | 0% | 100% | 0% | 0%
sql0% | 0% | 0% | 57% | 42%
py0% | 0% | 0% | 26% | 73%
psm10% | 0% | 0% | 0% | 100%
sed0% | 0% | 0% | 0% | 100%
File Change Frequency per Logical Decomposition
primary
primary (file change frequency)
The number of recorded file updates
101+
51-100
21-50
6-20
1-5
scripts0% | 0% | 4% | 69% | 25%
ROOT0% | 0% | 100% | 0% | 0%
src0% | 0% | 0% | 22% | 77%
Most Frequently Changed Files (Top 50)

See data for all files...

File# lines# unitscreatedlast modified# changes
(days)		# contributorsfirst
contributor		latest
contributor
instanceReview.ps1
in scripts/collector/sqlserver
 651 - 2023-08-07 2025-04-23 42 5 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
481 - 2022-11-04 2025-04-23 27 5 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
objectList.sql
in scripts/collector/sqlserver/sql
 198 - 2023-03-15 2024-08-08 20 3 sborden76@gmail.com sborden76@gmail.com
op_collect_init.sql
in scripts/collector/oracle/sql
 390 - 2022-11-14 2024-06-05 19 2 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
userConnectionInfo.sql
in scripts/collector/sqlserver/sql
 110 - 2023-03-15 2024-08-08 18 3 sborden76@gmail.com sborden76@gmail.com
columnDatatypes.sql
in scripts/collector/sqlserver/sql
 170 - 2023-03-15 2024-08-08 18 3 sborden76@gmail.com sborden76@gmail.com
indexList.sql
in scripts/collector/sqlserver/sql
 179 - 2023-03-15 2024-08-08 18 4 sborden76@gmail.com sborden76@gmail.com
dbServerFeatures.sql
in scripts/collector/sqlserver/sql
 692 - 2023-08-07 2025-04-22 18 3 sborden76@gmail.com sborden76@gmail.com
op_collect.sql
in scripts/collector/oracle/sql
 74 - 2022-11-14 2024-06-05 17 2 35240389+wpuziewicz@users.n... 204685+cofin@users.noreply....
serverProperties.sql
in scripts/collector/sqlserver/sql
 347 - 2023-08-07 2025-04-22 17 3 sborden76@gmail.com sborden76@gmail.com
tableList.sql
in scripts/collector/sqlserver/sql
 481 - 2023-03-15 2024-08-08 17 3 sborden76@gmail.com sborden76@gmail.com
dbSizes.sql
in scripts/collector/sqlserver/sql
 78 - 2023-03-15 2024-08-08 16 3 sborden76@gmail.com sborden76@gmail.com
columntypes.sql
in scripts/collector/oracle/sql/extracts
 185 - 2022-11-14 2024-06-05 14 2 35240389+wpuziewicz@users.n... 204685+cofin@users.noreply....
dmaSQLServerPerfmonDataset.ps1
in scripts/collector/sqlserver
 679 - 2023-08-07 2024-10-29 14 5 sborden76@gmail.com trivikram.2991@gmail.com
diskVolumeInfo.sql
in scripts/collector/sqlserver/sql
 70 - 2023-04-10 2024-05-15 13 3 sborden76@gmail.com sborden76@gmail.com
dbClusterNodes.sql
in scripts/collector/sqlserver/sql
 53 - 2023-03-15 2024-05-15 12 3 sborden76@gmail.com sborden76@gmail.com
lobsizing.sql
in scripts/collector/oracle/sql/extracts
 181 - 2022-11-14 2024-06-05 12 2 35240389+wpuziewicz@users.n... 204685+cofin@users.noreply....
dbobjects.sql
in scripts/collector/oracle/sql/extracts
 45 - 2022-11-14 2024-06-05 11 2 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
dataguard.sql
in scripts/collector/oracle/sql/extracts
 52 - 2022-11-14 2024-06-05 11 2 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
pdbsinfo.sql
in scripts/collector/oracle/sql/extracts
 61 - 2022-11-14 2024-06-05 11 2 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
dbsummary.sql
in scripts/collector/oracle/sql/extracts
 98 - 2022-11-14 2024-06-05 11 2 35240389+wpuziewicz@users.n... 204685+cofin@users.noreply....
createCollectionUser.sql
in scripts/collector/sqlserver/sql
 161 - 2023-08-07 2025-03-20 11 2 sborden76@gmail.com 204685+cofin@users.noreply....
datatypes.sql
in scripts/collector/oracle/sql/extracts
 30 - 2022-11-14 2024-06-05 10 2 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
dbobjectnames.sql
in scripts/collector/oracle/sql/extracts
 63 - 2023-03-16 2024-06-05 10 2 35240389+wpuziewicz@users.n... 204685+cofin@users.noreply....
tabletypes.sql
in scripts/collector/oracle/sql/extracts
 142 - 2022-11-14 2024-06-05 10 2 35240389+wpuziewicz@users.n... 204685+cofin@users.noreply....
main.py
in src/dma/collector/workflows/readiness_check/_postgres
 698 32 2024-05-14 2025-03-28 10 2 204685+cofin@users.noreply.... trivikram.2991@gmail.com
dbparameters.sql
in scripts/collector/oracle/sql/extracts
 18 - 2022-11-14 2024-06-05 9 2 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
foldername.sql
in scripts/collector/sqlserver/sql
 20 - 2023-03-15 2024-05-15 9 2 sborden76@gmail.com sborden76@gmail.com
indextypes.sql
in scripts/collector/oracle/sql/extracts
 64 - 2022-11-14 2024-06-05 9 2 35240389+wpuziewicz@users.n... 204685+cofin@users.noreply....
compressbytype.sql
in scripts/collector/oracle/sql/extracts
 79 - 2022-11-14 2024-06-05 9 2 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
tabletypedtl.sql
in scripts/collector/oracle/sql/extracts
 137 - 2023-03-16 2024-06-05 9 2 35240389+wpuziewicz@users.n... 204685+cofin@users.noreply....
iofunction.sql
in scripts/collector/oracle/sql/extracts/awr
 174 - 2023-02-10 2024-06-05 9 2 35240389+wpuziewicz@users.n... 204685+cofin@users.noreply....
main.py
in src/dma/cli
 327 6 2024-04-22 2025-03-21 9 2 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
componentsInstalled.sql
in scripts/collector/sqlserver/sql
 545 - 2023-08-07 2024-05-15 9 3 sborden76@gmail.com sborden76@gmail.com
ddls-postgres-collection.sql
in src/dma/collector/sql/canonical
 860 - 2024-05-08 2025-03-21 9 2 204685+cofin@users.noreply.... trivikram.2991@gmail.com
opkeylog.sql
in scripts/collector/oracle/sql/extracts
 16 - 2022-11-14 2024-06-05 8 2 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
idxpertable.sql
in scripts/collector/oracle/sql/extracts
 21 - 2022-11-14 2024-06-05 8 2 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
dbccTraceFlags.sql
in scripts/collector/sqlserver/sql
 28 - 2023-04-10 2024-05-15 8 3 sborden76@gmail.com sborden76@gmail.com
opatch.sql
in scripts/collector/oracle/sql/extracts
 42 - 2023-03-16 2024-06-05 8 2 35240389+wpuziewicz@users.n... 204685+cofin@users.noreply....
sourceconn.sql
in scripts/collector/oracle/sql/extracts/awr
 42 - 2023-02-21 2024-06-05 8 2 35240389+wpuziewicz@users.n... 204685+cofin@users.noreply....
defines.sql
in scripts/collector/oracle/sql/extracts
 48 - 2023-02-10 2024-06-05 8 2 35240389+wpuziewicz@users.n... 204685+cofin@users.noreply....
tablesnopk.sql
in scripts/collector/oracle/sql/extracts
 53 - 2022-11-14 2024-06-05 8 2 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
indextypedtl.sql
in scripts/collector/oracle/sql/extracts
 54 - 2023-03-16 2024-06-05 8 2 35240389+wpuziewicz@users.n... 204685+cofin@users.noreply....
awrsnapdetails.sql
in scripts/collector/oracle/sql/extracts/statspack
 57 - 2023-02-10 2024-06-05 8 2 35240389+wpuziewicz@users.n... 204685+cofin@users.noreply....
awrhistsysmetrichist.sql
in scripts/collector/oracle/sql/extracts/statspack
 60 - 2023-02-10 2024-06-05 8 2 35240389+wpuziewicz@users.n... 204685+cofin@users.noreply....
dbServerUnsupportedFlags.sql
in scripts/collector/sqlserver/sql
 61 - 2023-06-02 2024-05-15 8 3 sborden76@gmail.com sborden76@gmail.com
ioevents.sql
in scripts/collector/oracle/sql/extracts/awr
 85 - 2023-02-10 2024-06-05 8 2 35240389+wpuziewicz@users.n... 204685+cofin@users.noreply....
awrhistosstat.sql
in scripts/collector/oracle/sql/extracts/statspack
 85 - 2023-02-10 2024-06-05 8 2 35240389+wpuziewicz@users.n... 204685+cofin@users.noreply....
awrhistsysmetricsumm.sql
in scripts/collector/oracle/sql/extracts/statspack
 97 - 2023-02-10 2024-06-05 8 2 35240389+wpuziewicz@users.n... 204685+cofin@users.noreply....
createUserWithSQLAuth.ps1
in scripts/collector/sqlserver
 112 - 2023-08-07 2025-01-16 8 2 sborden76@gmail.com sborden76@gmail.com
Files With Most Contributors (Top 50)
Based on the number of unique email addresses found in commits.

See data for all files...

File# lines# unitscreatedlast modified# changes
(days)		# contributorsfirst
contributor		latest
contributor
instanceReview.ps1
in scripts/collector/sqlserver
 651 - 2023-08-07 2025-04-23 42 5 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
481 - 2022-11-04 2025-04-23 27 5 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
dmaSQLServerPerfmonDataset.ps1
in scripts/collector/sqlserver
 679 - 2023-08-07 2024-10-29 14 5 sborden76@gmail.com trivikram.2991@gmail.com
indexList.sql
in scripts/collector/sqlserver/sql
 179 - 2023-03-15 2024-08-08 18 4 sborden76@gmail.com sborden76@gmail.com
dmaSQLServerHWSpecs.ps1
in scripts/collector/sqlserver
 122 - 2023-11-09 2024-05-21 7 4 149305222+liozme@users.nore... sborden76@gmail.com
objectList.sql
in scripts/collector/sqlserver/sql
 198 - 2023-03-15 2024-08-08 20 3 sborden76@gmail.com sborden76@gmail.com
userConnectionInfo.sql
in scripts/collector/sqlserver/sql
 110 - 2023-03-15 2024-08-08 18 3 sborden76@gmail.com sborden76@gmail.com
columnDatatypes.sql
in scripts/collector/sqlserver/sql
 170 - 2023-03-15 2024-08-08 18 3 sborden76@gmail.com sborden76@gmail.com
dbServerFeatures.sql
in scripts/collector/sqlserver/sql
 692 - 2023-08-07 2025-04-22 18 3 sborden76@gmail.com sborden76@gmail.com
serverProperties.sql
in scripts/collector/sqlserver/sql
 347 - 2023-08-07 2025-04-22 17 3 sborden76@gmail.com sborden76@gmail.com
tableList.sql
in scripts/collector/sqlserver/sql
 481 - 2023-03-15 2024-08-08 17 3 sborden76@gmail.com sborden76@gmail.com
dbSizes.sql
in scripts/collector/sqlserver/sql
 78 - 2023-03-15 2024-08-08 16 3 sborden76@gmail.com sborden76@gmail.com
diskVolumeInfo.sql
in scripts/collector/sqlserver/sql
 70 - 2023-04-10 2024-05-15 13 3 sborden76@gmail.com sborden76@gmail.com
dbClusterNodes.sql
in scripts/collector/sqlserver/sql
 53 - 2023-03-15 2024-05-15 12 3 sborden76@gmail.com sborden76@gmail.com
componentsInstalled.sql
in scripts/collector/sqlserver/sql
 545 - 2023-08-07 2024-05-15 9 3 sborden76@gmail.com sborden76@gmail.com
dbccTraceFlags.sql
in scripts/collector/sqlserver/sql
 28 - 2023-04-10 2024-05-15 8 3 sborden76@gmail.com sborden76@gmail.com
dbServerUnsupportedFlags.sql
in scripts/collector/sqlserver/sql
 61 - 2023-06-02 2024-05-15 8 3 sborden76@gmail.com sborden76@gmail.com
database_details.sql
in scripts/collector/postgres/sql/base
 122 - 2024-02-28 2024-08-07 6 3 35240389+wpuziewicz@users.n... 35240389+wpuziewicz@users.n...
exclude_schemas.sql
in scripts/collector/oracle/sql/extracts
 10 - 2022-11-21 2024-06-05 5 3 35240389+wpuziewicz@users.n... 204685+cofin@users.noreply....
database_details.sql
in scripts/collector/postgres/sql/12
 110 - 2024-02-28 2024-06-12 5 3 35240389+wpuziewicz@users.n... 35240389+wpuziewicz@users.n...
database_details.sql
in scripts/collector/postgres/sql/13
 110 - 2024-02-28 2024-06-12 5 3 35240389+wpuziewicz@users.n... 35240389+wpuziewicz@users.n...
getDmaSourceId.sql
in scripts/collector/sqlserver/sql
 16 - 2023-08-22 2024-05-15 4 3 35240389+wpuziewicz@users.n... sborden76@gmail.com
replication_slots.sql
in scripts/collector/postgres/sql/12
 34 - 2024-02-28 2024-05-31 3 3 35240389+wpuziewicz@users.n... 204685+cofin@users.noreply....
replication_slots.sql
in scripts/collector/postgres/sql/13
 36 - 2024-02-28 2024-05-31 3 3 35240389+wpuziewicz@users.n... 204685+cofin@users.noreply....
op_collect_init.sql
in scripts/collector/oracle/sql
 390 - 2022-11-14 2024-06-05 19 2 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
op_collect.sql
in scripts/collector/oracle/sql
 74 - 2022-11-14 2024-06-05 17 2 35240389+wpuziewicz@users.n... 204685+cofin@users.noreply....
columntypes.sql
in scripts/collector/oracle/sql/extracts
 185 - 2022-11-14 2024-06-05 14 2 35240389+wpuziewicz@users.n... 204685+cofin@users.noreply....
lobsizing.sql
in scripts/collector/oracle/sql/extracts
 181 - 2022-11-14 2024-06-05 12 2 35240389+wpuziewicz@users.n... 204685+cofin@users.noreply....
createCollectionUser.sql
in scripts/collector/sqlserver/sql
 161 - 2023-08-07 2025-03-20 11 2 sborden76@gmail.com 204685+cofin@users.noreply....
dbsummary.sql
in scripts/collector/oracle/sql/extracts
 98 - 2022-11-14 2024-06-05 11 2 35240389+wpuziewicz@users.n... 204685+cofin@users.noreply....
dataguard.sql
in scripts/collector/oracle/sql/extracts
 52 - 2022-11-14 2024-06-05 11 2 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
dbobjects.sql
in scripts/collector/oracle/sql/extracts
 45 - 2022-11-14 2024-06-05 11 2 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
pdbsinfo.sql
in scripts/collector/oracle/sql/extracts
 61 - 2022-11-14 2024-06-05 11 2 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
tabletypes.sql
in scripts/collector/oracle/sql/extracts
 142 - 2022-11-14 2024-06-05 10 2 35240389+wpuziewicz@users.n... 204685+cofin@users.noreply....
dbobjectnames.sql
in scripts/collector/oracle/sql/extracts
 63 - 2023-03-16 2024-06-05 10 2 35240389+wpuziewicz@users.n... 204685+cofin@users.noreply....
datatypes.sql
in scripts/collector/oracle/sql/extracts
 30 - 2022-11-14 2024-06-05 10 2 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
main.py
in src/dma/collector/workflows/readiness_check/_postgres
 698 32 2024-05-14 2025-03-28 10 2 204685+cofin@users.noreply.... trivikram.2991@gmail.com
foldername.sql
in scripts/collector/sqlserver/sql
 20 - 2023-03-15 2024-05-15 9 2 sborden76@gmail.com sborden76@gmail.com
indextypes.sql
in scripts/collector/oracle/sql/extracts
 64 - 2022-11-14 2024-06-05 9 2 35240389+wpuziewicz@users.n... 204685+cofin@users.noreply....
iofunction.sql
in scripts/collector/oracle/sql/extracts/awr
 174 - 2023-02-10 2024-06-05 9 2 35240389+wpuziewicz@users.n... 204685+cofin@users.noreply....
tabletypedtl.sql
in scripts/collector/oracle/sql/extracts
 137 - 2023-03-16 2024-06-05 9 2 35240389+wpuziewicz@users.n... 204685+cofin@users.noreply....
dbparameters.sql
in scripts/collector/oracle/sql/extracts
 18 - 2022-11-14 2024-06-05 9 2 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
compressbytype.sql
in scripts/collector/oracle/sql/extracts
 79 - 2022-11-14 2024-06-05 9 2 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
ddls-postgres-collection.sql
in src/dma/collector/sql/canonical
 860 - 2024-05-08 2025-03-21 9 2 204685+cofin@users.noreply.... trivikram.2991@gmail.com
main.py
in src/dma/cli
 327 6 2024-04-22 2025-03-21 9 2 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
createUserWithSQLAuth.ps1
in scripts/collector/sqlserver
 112 - 2023-08-07 2025-01-16 8 2 sborden76@gmail.com sborden76@gmail.com
grants_wrapper.sql
in scripts/collector/oracle/sql/setup
 252 - 2023-02-10 2024-06-05 8 2 35240389+wpuziewicz@users.n... 204685+cofin@users.noreply....
idxpertable.sql
in scripts/collector/oracle/sql/extracts
 21 - 2022-11-14 2024-06-05 8 2 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
tablesnopk.sql
in scripts/collector/oracle/sql/extracts
 53 - 2022-11-14 2024-06-05 8 2 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
defines.sql
in scripts/collector/oracle/sql/extracts
 48 - 2023-02-10 2024-06-05 8 2 35240389+wpuziewicz@users.n... 204685+cofin@users.noreply....
Files With Least Contributors (Top 50)
Based on the number of unique email addresses found in commits.

See data for all files...

File# lines# unitscreatedlast modified# changes
(days)		# contributorsfirst
contributor		latest
contributor
collection-config.sql
in src/dma/collector/sql/sources/mysql
 554 - 2024-05-08 2024-05-31 3 1 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
aws_extension_dependency.sql
in scripts/collector/postgres/sql
 390 - 2024-01-16 2024-05-31 2 1 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
collection-aws_extension_dependency.sql
in src/dma/collector/sql/sources/postgres
 390 - 2024-05-08 2024-05-31 2 1 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
calculated_metrics.sql
in scripts/collector/postgres/sql
 229 - 2024-01-16 2024-05-31 4 1 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
collection-calculated_metrics.sql
in src/dma/collector/sql/sources/postgres
 229 - 2024-05-08 2024-05-31 2 1 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
ddls-mysql-collection.sql
in src/dma/collector/sql/canonical
 224 - 2024-05-24 2024-05-31 2 1 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
base.py
in src/dma/collector/query_managers
 195 12 2025-03-28 2025-03-28 1 1 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
collection-schema_objects.sql
in src/dma/collector/sql/sources/postgres
 188 - 2024-05-08 2024-05-31 2 1 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
schema_objects.sql
in scripts/collector/mysql/sql
 181 - 2023-11-14 2024-05-31 4 1 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
collection-schema_objects.sql
in src/dma/collector/sql/sources/mysql
 181 - 2024-05-08 2024-05-31 2 1 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
database_details.sql
in scripts/collector/mysql/sql
 165 - 2023-12-18 2024-05-31 3 1 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
collection-database_details.sql
in src/dma/collector/sql/sources/mysql
 165 - 2024-05-08 2024-05-31 2 1 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
main.py
in src/dma/collector/workflows/readiness_check/_mysql
 133 8 2024-05-24 2024-05-31 2 1 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
table_details.sql
in scripts/collector/mysql/sql
 117 - 2023-11-14 2024-05-31 5 1 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
collection-table_details.sql
in src/dma/collector/sql/sources/mysql
 117 - 2024-05-08 2024-05-31 2 1 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
collection-replication_slots.sql
in src/dma/collector/sql/sources/postgres
 107 - 2024-05-08 2024-05-31 2 1 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
postgres.py
in src/dma/collector/query_managers
 99 4 2025-03-28 2025-03-28 1 1 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
oracledb.py
in src/dma/lib/db/adapters
 91 4 2024-05-08 2024-05-31 2 1 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
aioodbc.py
in src/dma/lib/db/adapters
 89 4 2024-05-08 2024-05-31 2 1 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
dependencies.py
in src/dma/collector
 72 2 2024-05-08 2025-03-28 5 1 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
collection-schema_details.sql
in src/dma/collector/sql/sources/postgres
 61 - 2024-05-08 2024-05-31 2 1 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
collection-index_details.sql
in src/dma/collector/sql/sources/postgres
 59 - 2024-05-08 2024-05-31 2 1 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
mysql.py
in src/dma/collector/query_managers
 59 3 2025-03-28 2025-03-28 1 1 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
data_types.sql
in scripts/collector/postgres/sql
 56 - 2024-01-16 2024-05-31 2 1 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
collection-data_types.sql
in src/dma/collector/sql/sources/postgres
 56 - 2024-05-08 2024-05-31 2 1 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
asyncmy.py
in src/dma/lib/db/adapters
 49 1 2024-05-08 2024-12-10 4 1 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
replication_stats.sql
in scripts/collector/postgres/sql
 47 - 2024-01-16 2024-05-31 2 1 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
collection-source_details.sql
in src/dma/collector/sql/sources/postgres
 47 - 2024-05-08 2024-05-31 2 1 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
collection-settings.sql
in src/dma/collector/sql/sources/postgres
 40 - 2024-05-08 2024-05-31 2 1 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
users.sql
in scripts/collector/mysql/sql
 36 - 2023-11-14 2024-05-31 4 1 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
base.py
in src/dma/collector/workflows
 36 4 2024-05-08 2025-03-28 6 1 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
collection-users.sql
in src/dma/collector/sql/sources/mysql
 36 - 2024-05-08 2024-05-31 2 1 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
local.py
in src/dma/lib/db
 34 1 2024-05-08 2025-03-21 3 1 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
__init__.py
in src/dma
 32 - 2024-04-22 2025-03-28 5 1 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
collection-resource-groups.sql
in src/dma/collector/sql/sources/mysql
 32 - 2024-05-24 2024-05-31 2 1 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
_mysql.py
in src/dma/collector/workflows/collection_extractor
 31 2 2024-05-08 2025-03-28 3 1 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
_postgres.py
in src/dma/collector/workflows/collection_extractor
 31 2 2024-05-08 2025-03-28 3 1 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
bg_writer_stats.sql
in scripts/collector/postgres/sql
 29 - 2024-01-16 2024-05-31 2 1 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
collection-plugins.sql
in src/dma/collector/sql/sources/mysql
 28 - 2024-05-08 2024-05-31 2 1 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
helpers.py
in src/dma/collector/workflows/readiness_check/_mysql
 27 2 2024-05-24 2024-05-31 2 1 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
helpers.py
in src/dma/collector/util/postgres
 27 2 2024-10-02 2024-10-02 1 1 trivikram.2991@gmail.com trivikram.2991@gmail.com
collection-data_types.sql
in src/dma/collector/sql/sources/mysql
 26 - 2024-05-08 2024-05-31 2 1 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
collection-extensions.sql
in src/dma/collector/sql/sources/postgres
 25 - 2024-05-08 2024-05-31 2 1 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
oracle.py
in src/dma/collector/query_managers
 22 1 2025-03-28 2025-03-28 1 1 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
mssql.py
in src/dma/collector/query_managers
 22 1 2025-03-28 2025-03-28 1 1 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
collection-process_list.sql
in src/dma/collector/sql/sources/mysql
 20 - 2024-05-08 2024-05-31 3 1 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
extended-collection-all-databases.sql
in src/dma/collector/sql/sources/postgres
 20 - 2024-05-14 2024-05-31 2 1 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
init.sql
in src/dma/collector/sql/sources/mysql
 19 - 2024-05-08 2024-05-31 3 1 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
exceptions.py
in src/dma/lib
 19 3 2024-05-08 2025-03-20 3 1 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
readiness-check.sql
in src/dma/collector/sql/canonical
 18 - 2024-05-14 2025-03-20 4 1 204685+cofin@users.noreply.... 204685+cofin@users.noreply....
Correlations

File Size vs. Number of Changes: 245 points

pyproject.toml x: 481 lines of code y: 27 # changes scripts/collector/sqlserver/instanceReview.ps1 x: 651 lines of code y: 42 # changes scripts/collector/sqlserver/sql/dbServerFeatures.sql x: 692 lines of code y: 18 # changes scripts/collector/sqlserver/sql/serverProperties.sql x: 347 lines of code y: 17 # changes src/dma/__init__.py x: 32 lines of code y: 5 # changes src/dma/collector/dependencies.py x: 72 lines of code y: 5 # changes src/dma/collector/query_managers/__init__.py x: 1 lines of code y: 1 # changes src/dma/collector/query_managers/base.py x: 195 lines of code y: 1 # changes src/dma/collector/query_managers/mssql.py x: 22 lines of code y: 1 # changes src/dma/collector/query_managers/mysql.py x: 59 lines of code y: 1 # changes src/dma/collector/query_managers/postgres.py x: 99 lines of code y: 1 # changes src/dma/collector/workflows/base.py x: 36 lines of code y: 6 # changes src/dma/collector/workflows/collection_extractor/_mysql.py x: 31 lines of code y: 3 # changes src/dma/collector/workflows/collection_extractor/base.py x: 91 lines of code y: 6 # changes src/dma/lib/db/__init__.py x: 15 lines of code y: 3 # changes src/dma/lib/db/adapters/__init__.py x: 1 lines of code y: 3 # changes src/dma/collector/workflows/readiness_check/_postgres/constants.py x: 1813 lines of code y: 4 # changes src/dma/collector/workflows/readiness_check/_postgres/main.py x: 698 lines of code y: 10 # changes src/dma/cli/_utils.py x: 4 lines of code y: 4 # changes src/dma/cli/main.py x: 327 lines of code y: 9 # changes src/dma/lib/db/local.py x: 34 lines of code y: 3 # changes src/dma/collector/sql/canonical/ddls-postgres-collection.sql x: 860 lines of code y: 9 # changes src/dma/collector/sql/sources/postgres/collection-privileges.sql x: 124 lines of code y: 4 # changes src/dma/collector/sql/sources/postgres/collection-table_details.sql x: 469 lines of code y: 5 # changes scripts/collector/sqlserver/sql/createCollectionUser.sql x: 161 lines of code y: 11 # changes src/dma/collector/sql/canonical/readiness-check.sql x: 18 lines of code y: 4 # changes src/dma/collector/workflows/readiness_check/base.py x: 120 lines of code y: 5 # changes src/dma/lib/db/query_manager.py x: 55 lines of code y: 4 # changes src/dma/lib/exceptions.py x: 19 lines of code y: 3 # changes src/dma/types.py x: 9 lines of code y: 4 # changes src/dma/collector/sql/sources/postgres/collection-bg_writer_stats.sql x: 45 lines of code y: 3 # changes scripts/collector/sqlserver/createUserWithSQLAuth.ps1 x: 112 lines of code y: 8 # changes scripts/collector/sqlserver/sql/addCollectionUserToDatabase.sql x: 29 lines of code y: 4 # changes src/dma/lib/db/adapters/asyncmy.py x: 49 lines of code y: 4 # changes src/dma/utils.py x: 83 lines of code y: 4 # changes scripts/collector/sqlserver/dmaSQLServerPerfmonDataset.ps1 x: 679 lines of code y: 14 # changes src/dma/collector/sql/sources/postgres/collection-replication_stats.sql x: 47 lines of code y: 3 # changes src/dma/collector/sql/sources/postgres/init.sql x: 4 lines of code y: 3 # changes scripts/collector/oracle/sql/op_set_sql_env.sql x: 55 lines of code y: 5 # changes src/dma/collector/sql/sources/postgres/collection-pglogical-details.sql x: 12 lines of code y: 1 # changes src/dma/collector/util/postgres/helpers.py x: 27 lines of code y: 1 # changes scripts/collector/sqlserver/sql/addCollectionUserPermissions.sql x: 118 lines of code y: 6 # changes scripts/collector/sqlserver/sql/checkValidDatabase.sql x: 12 lines of code y: 4 # changes scripts/collector/sqlserver/sql/columnDatatypes.sql x: 170 lines of code y: 18 # changes scripts/collector/sqlserver/sql/dbSizes.sql x: 78 lines of code y: 16 # changes scripts/collector/sqlserver/sql/dropCollectionUser.sql x: 38 lines of code y: 4 # changes scripts/collector/sqlserver/sql/getDBList.sql x: 35 lines of code y: 7 # changes scripts/collector/sqlserver/sql/indexList.sql x: 179 lines of code y: 18 # changes scripts/collector/sqlserver/sql/objectList.sql x: 198 lines of code y: 20 # changes scripts/collector/sqlserver/sql/tableList.sql x: 481 lines of code y: 17 # changes scripts/collector/sqlserver/sql/userConnectionInfo.sql x: 110 lines of code y: 18 # changes scripts/collector/postgres/sql/base/database_details.sql x: 122 lines of code y: 6 # changes scripts/collector/postgres/sql/12/database_details.sql x: 110 lines of code y: 5 # changes src/dma/collector/sql/sources/postgres/collection-database_details.sql x: 342 lines of code y: 3 # changes scripts/collector/oracle/sql/extracts/9i_backups.sql x: 1 lines of code y: 2 # changes scripts/collector/oracle/sql/extracts/app_schemas.sql x: 70 lines of code y: 3 # changes scripts/collector/oracle/sql/extracts/archlogs.sql x: 15 lines of code y: 7 # changes scripts/collector/oracle/sql/extracts/awr/awrhistcmdtypes.sql x: 42 lines of code y: 6 # changes scripts/collector/oracle/sql/extracts/awr/awrhistosstat.sql x: 88 lines of code y: 6 # changes scripts/collector/oracle/sql/extracts/awr/awrhistsysmetrichist.sql x: 48 lines of code y: 6 # changes scripts/collector/oracle/sql/extracts/awr/awrhistsysmetricsumm.sql x: 65 lines of code y: 7 # changes scripts/collector/oracle/sql/extracts/awr/awrsnapdetails.sql x: 41 lines of code y: 7 # changes scripts/collector/oracle/sql/extracts/awr/dbahistsysstat.sql x: 82 lines of code y: 6 # changes scripts/collector/oracle/sql/extracts/awr/dbahistsystimemodel.sql x: 62 lines of code y: 6 # changes scripts/collector/oracle/sql/extracts/awr/ioevents.sql x: 85 lines of code y: 8 # changes scripts/collector/oracle/sql/extracts/awr/iofunction.sql x: 174 lines of code y: 9 # changes scripts/collector/oracle/sql/extracts/awr/sourceconn.sql x: 42 lines of code y: 8 # changes scripts/collector/oracle/sql/extracts/awr/sqlcmd10.sql x: 168 lines of code y: 3 # changes scripts/collector/oracle/sql/extracts/awr/sqlstats.sql x: 52 lines of code y: 6 # changes scripts/collector/oracle/sql/extracts/awr/sqlstats111.sql x: 53 lines of code y: 7 # changes scripts/collector/oracle/sql/extracts/columntypes.sql x: 185 lines of code y: 14 # changes scripts/collector/oracle/sql/extracts/compressbytype.sql x: 79 lines of code y: 9 # changes scripts/collector/oracle/sql/extracts/cpucoresusage.sql x: 14 lines of code y: 6 # changes scripts/collector/oracle/sql/extracts/data_type_col_9i.sql x: 20 lines of code y: 2 # changes scripts/collector/oracle/sql/extracts/dataguard.sql x: 52 lines of code y: 11 # changes scripts/collector/oracle/sql/extracts/datatypes.sql x: 30 lines of code y: 10 # changes scripts/collector/oracle/sql/extracts/dbfeatures.sql x: 20 lines of code y: 7 # changes scripts/collector/oracle/sql/extracts/dbinstances.sql x: 17 lines of code y: 6 # changes scripts/collector/oracle/sql/extracts/dbobjectnames.sql x: 63 lines of code y: 10 # changes scripts/collector/oracle/sql/extracts/dbobjects.sql x: 45 lines of code y: 11 # changes scripts/collector/oracle/sql/extracts/dbparameters.sql x: 18 lines of code y: 9 # changes scripts/collector/oracle/sql/extracts/dbsummary.sql x: 98 lines of code y: 11 # changes scripts/collector/oracle/sql/extracts/defines.sql x: 48 lines of code y: 8 # changes scripts/collector/oracle/sql/extracts/dtlsourcecode.sql x: 57 lines of code y: 7 # changes scripts/collector/oracle/sql/extracts/exclude_schemas.sql x: 10 lines of code y: 5 # changes scripts/collector/oracle/sql/extracts/exttab.sql x: 11 lines of code y: 7 # changes scripts/collector/oracle/sql/extracts/idxpertable.sql x: 21 lines of code y: 8 # changes scripts/collector/oracle/sql/extracts/indextypedtl.sql x: 54 lines of code y: 8 # changes scripts/collector/oracle/sql/extracts/indextypes.sql x: 64 lines of code y: 9 # changes scripts/collector/oracle/sql/extracts/lobsizing.sql x: 181 lines of code y: 12 # changes scripts/collector/oracle/sql/extracts/opkeylog.sql x: 16 lines of code y: 8 # changes scripts/collector/oracle/sql/extracts/pdbsinfo.sql x: 61 lines of code y: 11 # changes scripts/collector/oracle/sql/extracts/statspack/awrhistcmdtypes.sql x: 162 lines of code y: 8 # changes scripts/collector/oracle/sql/extracts/statspack/awrhistsysmetrichist.sql x: 60 lines of code y: 8 # changes scripts/collector/oracle/sql/extracts/statspack/awrhistsysmetricsumm.sql x: 97 lines of code y: 8 # changes scripts/collector/oracle/sql/extracts/statspack/awrsnapdetails.sql x: 57 lines of code y: 8 # changes scripts/collector/oracle/sql/extracts/statspack/dbahistsysstat.sql x: 77 lines of code y: 7 # changes scripts/collector/oracle/sql/extracts/statspack/dbahistsystimemodel.sql x: 66 lines of code y: 7 # changes scripts/collector/oracle/sql/extracts/statspack/ioevents.sql x: 86 lines of code y: 7 # changes scripts/collector/oracle/sql/extracts/statspack/iofunction.sql x: 177 lines of code y: 8 # changes scripts/collector/oracle/sql/extracts/statspack/sqlstats.sql x: 193 lines of code y: 8 # changes scripts/collector/oracle/sql/extracts/tabletypedtl.sql x: 137 lines of code y: 9 # changes scripts/collector/oracle/sql/extracts/tabletypes.sql x: 142 lines of code y: 10 # changes scripts/collector/oracle/sql/extracts/triggers.sql x: 47 lines of code y: 7 # changes scripts/collector/oracle/sql/extracts/usedspacedetails.sql x: 18 lines of code y: 7 # changes scripts/collector/oracle/sql/op_collect.sql x: 74 lines of code y: 17 # changes scripts/collector/oracle/sql/op_collect_init.sql x: 390 lines of code y: 19 # changes scripts/collector/oracle/sql/op_collect_statspack.sql x: 11 lines of code y: 3 # changes scripts/collector/oracle/sql/setup/grants_wrapper.sql x: 252 lines of code y: 8 # changes scripts/collector/sqlserver/dmaSQLServerCorrectPerfmonDataset.ps1 x: 128 lines of code y: 3 # changes scripts/collector/mysql/sql/_base_path_lookup.sql x: 8 lines of code y: 2 # changes scripts/collector/mysql/sql/config.sql x: 554 lines of code y: 7 # changes scripts/collector/mysql/sql/data_types.sql x: 26 lines of code y: 5 # changes scripts/collector/mysql/sql/database_details.sql x: 165 lines of code y: 3 # changes scripts/collector/mysql/sql/engines.sql x: 18 lines of code y: 5 # changes scripts/collector/mysql/sql/plugins.sql x: 28 lines of code y: 5 # changes scripts/collector/mysql/sql/schema_objects.sql x: 181 lines of code y: 4 # changes scripts/collector/mysql/sql/table_details.sql x: 117 lines of code y: 5 # changes scripts/collector/postgres/sql/12/table_details.sql x: 137 lines of code y: 4 # changes scripts/collector/postgres/sql/13/replication_slots.sql x: 36 lines of code y: 3 # changes scripts/collector/postgres/sql/13/table_details.sql x: 139 lines of code y: 4 # changes scripts/collector/postgres/sql/aws_extension_dependency.sql x: 390 lines of code y: 2 # changes scripts/collector/postgres/sql/aws_oracle_version.sql x: 5 lines of code y: 2 # changes scripts/collector/postgres/sql/base/replication_slots.sql x: 37 lines of code y: 2 # changes scripts/collector/postgres/sql/bg_writer_stats.sql x: 29 lines of code y: 2 # changes scripts/collector/postgres/sql/calculated_metrics.sql x: 229 lines of code y: 4 # changes scripts/collector/postgres/sql/data_types.sql x: 56 lines of code y: 2 # changes scripts/collector/postgres/sql/index_details.sql x: 59 lines of code y: 3 # changes scripts/collector/postgres/sql/op_collect.sql x: 52 lines of code y: 5 # changes scripts/collector/postgres/sql/replication_stats.sql x: 47 lines of code y: 2 # changes scripts/collector/postgres/sql/schema_objects.sql x: 188 lines of code y: 3 # changes scripts/collector/postgres/sql/settings.sql x: 40 lines of code y: 5 # changes src/dma/__about__.py x: 11 lines of code y: 2 # changes src/dma/collector/sql/canonical/ddls-mysql-collection.sql x: 224 lines of code y: 2 # changes src/dma/collector/sql/sources/mysql/collection-config.sql x: 554 lines of code y: 3 # changes src/dma/collector/sql/sources/mysql/collection-data_types.sql x: 26 lines of code y: 2 # changes src/dma/collector/sql/sources/mysql/collection-database_details.sql x: 165 lines of code y: 2 # changes src/dma/collector/sql/sources/mysql/collection-engines.sql x: 18 lines of code y: 2 # changes src/dma/collector/sql/sources/mysql/collection-process_list.sql x: 20 lines of code y: 3 # changes src/dma/collector/sql/sources/mysql/collection-resource-groups.sql x: 32 lines of code y: 2 # changes src/dma/collector/sql/sources/mysql/collection-schema_objects.sql x: 181 lines of code y: 2 # changes src/dma/collector/sql/sources/mysql/collection-table_details.sql x: 117 lines of code y: 2 # changes src/dma/collector/sql/sources/postgres/collection-calculated_metrics.sql x: 229 lines of code y: 2 # changes src/dma/collector/sql/sources/postgres/collection-index_details.sql x: 59 lines of code y: 2 # changes src/dma/collector/sql/sources/postgres/collection-replication_slots.sql x: 107 lines of code y: 2 # changes src/dma/collector/sql/sources/postgres/collection-schema_objects.sql x: 188 lines of code y: 2 # changes src/dma/collector/sql/sources/postgres/collection-settings.sql x: 40 lines of code y: 2 # changes src/dma/collector/workflows/readiness_check/_mysql/main.py x: 133 lines of code y: 2 # changes src/dma/lib/db/adapters/aioodbc.py x: 89 lines of code y: 2 # changes scripts/collector/sqlserver/dmaSQLServerHWSpecs.ps1 x: 122 lines of code y: 7 # changes scripts/collector/sqlserver/sql/checkValidInstanceVersion.sql x: 31 lines of code y: 4 # changes scripts/collector/sqlserver/sql/componentsInstalled.sql x: 545 lines of code y: 9 # changes scripts/collector/sqlserver/sql/dbClusterNodes.sql x: 53 lines of code y: 12 # changes scripts/collector/sqlserver/sql/dbServerConfigurationSettings.sql x: 25 lines of code y: 6 # changes scripts/collector/sqlserver/sql/dbServerDmvPerfmon.sql x: 184 lines of code y: 7 # changes scripts/collector/sqlserver/sql/dbServerTranLogBackupCountByDayByHour.sql x: 58 lines of code y: 5 # changes scripts/collector/sqlserver/sql/dbccTraceFlags.sql x: 28 lines of code y: 8 # changes scripts/collector/sqlserver/sql/diskVolumeInfo.sql x: 70 lines of code y: 13 # changes scripts/collector/sqlserver/sql/foldername.sql x: 20 lines of code y: 9 # changes scripts/collector/sqlserver/sql/getDmaSourceId.sql x: 16 lines of code y: 4 # changes scripts/collector/sqlserver/sql/linkedServersDetail.sql x: 37 lines of code y: 5 # changes scripts/collector/sqlserver/dmaCollectorCommonFunctions.psm1 x: 92 lines of code y: 5 # changes scripts/collector/sqlserver/InstanceReview.ps1 x: 651 lines of code y: 15 # changes scripts/collector/sqlserver/sql/ServerProperties.sql x: 347 lines of code y: 11 # changes scripts/collector/sqlserver/createuserwithwindowsauth.ps1 x: 76 lines of code y: 6 # changes scripts/collector/sqlserver/sql/ComponentsInstalled.sql x: 545 lines of code y: 5 # changes
42.0
# changes
  min: 1.0
  average: 5.57
  25th percentile: 2.0
  median: 4.0
  75th percentile: 7.0
  max: 42.0
0 1813.0
lines of code
min: 1.0 | average: 102.1 | 25th percentile: 15.0 | median: 47.0 | 75th percentile: 110.0 | max: 1813.0

Number of Contributors vs. Number of Changes: 245 points

pyproject.toml x: 5 # contributors y: 27 # changes scripts/collector/sqlserver/instanceReview.ps1 x: 5 # contributors y: 42 # changes scripts/collector/sqlserver/sql/dbServerFeatures.sql x: 3 # contributors y: 18 # changes scripts/collector/sqlserver/sql/serverProperties.sql x: 3 # contributors y: 17 # changes src/dma/__init__.py x: 1 # contributors y: 5 # changes src/dma/collector/query_managers/__init__.py x: 1 # contributors y: 1 # changes src/dma/collector/workflows/base.py x: 1 # contributors y: 6 # changes src/dma/collector/workflows/collection_extractor/_mysql.py x: 1 # contributors y: 3 # changes src/dma/collector/workflows/collection_extractor/base.py x: 2 # contributors y: 6 # changes src/dma/collector/workflows/readiness_check/_postgres/constants.py x: 2 # contributors y: 4 # changes src/dma/collector/workflows/readiness_check/_postgres/main.py x: 2 # contributors y: 10 # changes src/dma/cli/_utils.py x: 1 # contributors y: 4 # changes src/dma/cli/main.py x: 2 # contributors y: 9 # changes src/dma/collector/sql/sources/postgres/collection-table_details.sql x: 2 # contributors y: 5 # changes scripts/collector/sqlserver/sql/createCollectionUser.sql x: 2 # contributors y: 11 # changes src/dma/collector/sql/sources/postgres/collection-bg_writer_stats.sql x: 2 # contributors y: 3 # changes scripts/collector/sqlserver/createUserWithSQLAuth.ps1 x: 2 # contributors y: 8 # changes scripts/collector/sqlserver/dmaSQLServerPerfmonDataset.ps1 x: 5 # contributors y: 14 # changes scripts/collector/sqlserver/sql/dbSizes.sql x: 3 # contributors y: 16 # changes scripts/collector/sqlserver/sql/getDBList.sql x: 2 # contributors y: 7 # changes scripts/collector/sqlserver/sql/indexList.sql x: 4 # contributors y: 18 # changes scripts/collector/sqlserver/sql/objectList.sql x: 3 # contributors y: 20 # changes scripts/collector/postgres/sql/base/database_details.sql x: 3 # contributors y: 6 # changes scripts/collector/postgres/sql/12/database_details.sql x: 3 # contributors y: 5 # changes scripts/collector/oracle/sql/extracts/9i_backups.sql x: 2 # contributors y: 2 # changes scripts/collector/oracle/sql/extracts/columntypes.sql x: 2 # contributors y: 14 # changes scripts/collector/oracle/sql/extracts/lobsizing.sql x: 2 # contributors y: 12 # changes scripts/collector/oracle/sql/op_collect.sql x: 2 # contributors y: 17 # changes scripts/collector/oracle/sql/op_collect_init.sql x: 2 # contributors y: 19 # changes scripts/collector/oracle/sql/op_collect_nopluggable_info.sql x: 1 # contributors y: 2 # changes scripts/collector/postgres/sql/12/replication_slots.sql x: 3 # contributors y: 3 # changes scripts/collector/sqlserver/dmaSQLServerHWSpecs.ps1 x: 4 # contributors y: 7 # changes scripts/collector/sqlserver/sql/componentsInstalled.sql x: 3 # contributors y: 9 # changes scripts/collector/sqlserver/sql/dbClusterNodes.sql x: 3 # contributors y: 12 # changes scripts/collector/sqlserver/sql/dbServerUnsupportedFlags.sql x: 3 # contributors y: 8 # changes scripts/collector/sqlserver/sql/diskVolumeInfo.sql x: 3 # contributors y: 13 # changes scripts/collector/sqlserver/sql/getDmaSourceId.sql x: 3 # contributors y: 4 # changes scripts/collector/sqlserver/InstanceReview.ps1 x: 3 # contributors y: 15 # changes
42.0
# changes
  min: 1.0
  average: 5.57
  25th percentile: 2.0
  median: 4.0
  75th percentile: 7.0
  max: 42.0
0 5.0
# contributors
min: 1.0 | average: 1.78 | 25th percentile: 1.0 | median: 2.0 | 75th percentile: 2.0 | max: 5.0

Number of Contributors vs. File Size: 245 points

pyproject.toml x: 5 # contributors y: 481 lines of code scripts/collector/sqlserver/instanceReview.ps1 x: 5 # contributors y: 651 lines of code scripts/collector/sqlserver/sql/dbServerFeatures.sql x: 3 # contributors y: 692 lines of code scripts/collector/sqlserver/sql/serverProperties.sql x: 3 # contributors y: 347 lines of code src/dma/__init__.py x: 1 # contributors y: 32 lines of code src/dma/collector/dependencies.py x: 1 # contributors y: 72 lines of code src/dma/collector/query_managers/__init__.py x: 1 # contributors y: 1 lines of code src/dma/collector/query_managers/base.py x: 1 # contributors y: 195 lines of code src/dma/collector/query_managers/mssql.py x: 1 # contributors y: 22 lines of code src/dma/collector/query_managers/mysql.py x: 1 # contributors y: 59 lines of code src/dma/collector/query_managers/postgres.py x: 1 # contributors y: 99 lines of code src/dma/collector/workflows/base.py x: 1 # contributors y: 36 lines of code src/dma/collector/workflows/collection_extractor/base.py x: 2 # contributors y: 91 lines of code src/dma/lib/db/__init__.py x: 1 # contributors y: 15 lines of code src/dma/collector/workflows/readiness_check/_postgres/constants.py x: 2 # contributors y: 1813 lines of code src/dma/collector/workflows/readiness_check/_postgres/main.py x: 2 # contributors y: 698 lines of code src/dma/cli/main.py x: 2 # contributors y: 327 lines of code src/dma/collector/sql/canonical/ddls-postgres-collection.sql x: 2 # contributors y: 860 lines of code src/dma/collector/sql/sources/postgres/collection-privileges.sql x: 2 # contributors y: 124 lines of code src/dma/collector/sql/sources/postgres/collection-table_details.sql x: 2 # contributors y: 469 lines of code scripts/collector/sqlserver/sql/createCollectionUser.sql x: 2 # contributors y: 161 lines of code src/dma/collector/workflows/readiness_check/base.py x: 2 # contributors y: 120 lines of code src/dma/lib/db/base.py x: 2 # contributors y: 75 lines of code src/dma/lib/db/query_manager.py x: 2 # contributors y: 55 lines of code src/dma/types.py x: 1 # contributors y: 9 lines of code src/dma/collector/sql/sources/postgres/collection-bg_writer_stats.sql x: 2 # contributors y: 45 lines of code scripts/collector/sqlserver/createUserWithSQLAuth.ps1 x: 2 # contributors y: 112 lines of code scripts/collector/sqlserver/sql/addCollectionUserToDatabase.sql x: 2 # contributors y: 29 lines of code src/dma/lib/db/adapters/asyncmy.py x: 1 # contributors y: 49 lines of code src/dma/utils.py x: 2 # contributors y: 83 lines of code scripts/collector/sqlserver/dmaSQLServerPerfmonDataset.ps1 x: 5 # contributors y: 679 lines of code src/dma/collector/sql/sources/postgres/init.sql x: 2 # contributors y: 4 lines of code scripts/collector/sqlserver/sql/checkValidDatabase.sql x: 2 # contributors y: 12 lines of code scripts/collector/sqlserver/sql/columnDatatypes.sql x: 3 # contributors y: 170 lines of code scripts/collector/sqlserver/sql/dbSizes.sql x: 3 # contributors y: 78 lines of code scripts/collector/sqlserver/sql/dropCollectionUser.sql x: 2 # contributors y: 38 lines of code scripts/collector/sqlserver/sql/indexList.sql x: 4 # contributors y: 179 lines of code scripts/collector/sqlserver/sql/objectList.sql x: 3 # contributors y: 198 lines of code scripts/collector/sqlserver/sql/tableList.sql x: 3 # contributors y: 481 lines of code scripts/collector/sqlserver/sql/userConnectionInfo.sql x: 3 # contributors y: 110 lines of code scripts/collector/postgres/sql/base/database_details.sql x: 3 # contributors y: 122 lines of code src/dma/collector/sql/sources/postgres/collection-database_details.sql x: 2 # contributors y: 342 lines of code scripts/collector/oracle/sql/extracts/app_schemas.sql x: 2 # contributors y: 70 lines of code scripts/collector/oracle/sql/extracts/archlogs.sql x: 2 # contributors y: 15 lines of code scripts/collector/oracle/sql/extracts/awr/dbahistsystimemodel.sql x: 2 # contributors y: 62 lines of code scripts/collector/oracle/sql/extracts/awr/iofunction.sql x: 2 # contributors y: 174 lines of code scripts/collector/oracle/sql/extracts/awr/sqlcmd10.sql x: 2 # contributors y: 168 lines of code scripts/collector/oracle/sql/extracts/columntypes.sql x: 2 # contributors y: 185 lines of code scripts/collector/oracle/sql/extracts/dbsummary.sql x: 2 # contributors y: 98 lines of code scripts/collector/oracle/sql/extracts/exclude_schemas.sql x: 3 # contributors y: 10 lines of code scripts/collector/oracle/sql/extracts/statspack/sqlstats.sql x: 2 # contributors y: 193 lines of code scripts/collector/oracle/sql/extracts/tabletypedtl.sql x: 2 # contributors y: 137 lines of code scripts/collector/oracle/sql/op_collect_init.sql x: 2 # contributors y: 390 lines of code scripts/collector/oracle/sql/setup/grants_wrapper.sql x: 2 # contributors y: 252 lines of code scripts/collector/mysql/sql/config.sql x: 2 # contributors y: 554 lines of code scripts/collector/mysql/sql/data_types.sql x: 2 # contributors y: 26 lines of code scripts/collector/mysql/sql/database_details.sql x: 1 # contributors y: 165 lines of code scripts/collector/mysql/sql/schema_objects.sql x: 1 # contributors y: 181 lines of code scripts/collector/mysql/sql/table_details.sql x: 1 # contributors y: 117 lines of code scripts/collector/postgres/sql/12/replication_slots.sql x: 3 # contributors y: 34 lines of code scripts/collector/postgres/sql/13/replication_slots.sql x: 3 # contributors y: 36 lines of code scripts/collector/postgres/sql/aws_extension_dependency.sql x: 1 # contributors y: 390 lines of code scripts/collector/postgres/sql/calculated_metrics.sql x: 1 # contributors y: 229 lines of code scripts/collector/postgres/sql/data_types.sql x: 1 # contributors y: 56 lines of code scripts/collector/postgres/sql/schema_objects.sql x: 2 # contributors y: 188 lines of code src/dma/collector/sql/canonical/ddls-mysql-collection.sql x: 1 # contributors y: 224 lines of code src/dma/collector/sql/sources/mysql/collection-config.sql x: 1 # contributors y: 554 lines of code src/dma/collector/sql/sources/postgres/collection-replication_slots.sql x: 1 # contributors y: 107 lines of code src/dma/collector/sql/sources/postgres/collection-schema_objects.sql x: 1 # contributors y: 188 lines of code src/dma/collector/workflows/readiness_check/_mysql/main.py x: 1 # contributors y: 133 lines of code src/dma/lib/db/adapters/aioodbc.py x: 1 # contributors y: 89 lines of code scripts/collector/sqlserver/dmaSQLServerHWSpecs.ps1 x: 4 # contributors y: 122 lines of code scripts/collector/sqlserver/sql/componentsInstalled.sql x: 3 # contributors y: 545 lines of code scripts/collector/sqlserver/sql/dbClusterNodes.sql x: 3 # contributors y: 53 lines of code scripts/collector/sqlserver/sql/dbServerUnsupportedFlags.sql x: 3 # contributors y: 61 lines of code scripts/collector/sqlserver/sql/dbccTraceFlags.sql x: 3 # contributors y: 28 lines of code scripts/collector/sqlserver/sql/diskVolumeInfo.sql x: 3 # contributors y: 70 lines of code scripts/collector/sqlserver/sql/getDmaSourceId.sql x: 3 # contributors y: 16 lines of code scripts/collector/sqlserver/InstanceReview.ps1 x: 3 # contributors y: 651 lines of code scripts/collector/sqlserver/sql/ServerProperties.sql x: 2 # contributors y: 347 lines of code scripts/collector/sqlserver/sql/ComponentsInstalled.sql x: 2 # contributors y: 545 lines of code
1813.0
lines of code
  min: 1.0
  average: 102.1
  25th percentile: 15.0
  median: 47.0
  75th percentile: 110.0
  max: 1813.0
0 5.0
# contributors
min: 1.0 | average: 1.78 | 25th percentile: 1.0 | median: 2.0 | 75th percentile: 2.0 | max: 5.0