GoogleCloudPlatform / database-assessment
File Size

The distribution of size of files (measured in lines of code).

Intro
Learn more...
File Size Overall
7% | 22% | 19% | 25% | 25%
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
py41% | 15% | 7% | 10% | 25%
sql0% | 19% | 22% | 30% | 27%
ps10% | 75% | 0% | 20% | 4%
toml0% | 0% | 100% | 0% | 0%
psm10% | 0% | 0% | 0% | 100%
sed0% | 0% | 0% | 0% | 100%
File Size per Logical Decomposition
primary
1001+
501-1000
201-500
101-200
1-100
src20% | 23% | 22% | 14% | 19%
scripts0% | 22% | 15% | 32% | 30%
ROOT0% | 0% | 100% | 0% | 0%
Longest Files (Top 50)
File# lines# units
constants.py
in src/dma/collector/workflows/readiness_check/_postgres
 1813 -
ddls-postgres-collection.sql
in src/dma/collector/sql/canonical
 860 -
main.py
in src/dma/collector/workflows/readiness_check/_postgres
 698 32
dbServerFeatures.sql
in scripts/collector/sqlserver/sql
 692 -
dmaSQLServerPerfmonDataset.ps1
in scripts/collector/sqlserver
 679 -
instanceReview.ps1
in scripts/collector/sqlserver
 651 -
config.sql
in scripts/collector/mysql/sql
 554 -
collection-config.sql
in src/dma/collector/sql/sources/mysql
 554 -
componentsInstalled.sql
in scripts/collector/sqlserver/sql
 545 -
tableList.sql
in scripts/collector/sqlserver/sql
 481 -
481 -
collection-table_details.sql
in src/dma/collector/sql/sources/postgres
 469 -
op_collect_init.sql
in scripts/collector/oracle/sql
 390 -
aws_extension_dependency.sql
in scripts/collector/postgres/sql
 390 -
collection-aws_extension_dependency.sql
in src/dma/collector/sql/sources/postgres
 390 -
serverProperties.sql
in scripts/collector/sqlserver/sql
 347 -
collection-database_details.sql
in src/dma/collector/sql/sources/postgres
 342 -
main.py
in src/dma/cli
 327 6
grants_wrapper.sql
in scripts/collector/oracle/sql/setup
 252 -
calculated_metrics.sql
in scripts/collector/postgres/sql
 229 -
collection-calculated_metrics.sql
in src/dma/collector/sql/sources/postgres
 229 -
ddls-mysql-collection.sql
in src/dma/collector/sql/canonical
 224 -
objectList.sql
in scripts/collector/sqlserver/sql
 198 -
base.py
in src/dma/collector/query_managers
 195 12
sqlstats.sql
in scripts/collector/oracle/sql/extracts/statspack
 193 -
schema_objects.sql
in scripts/collector/postgres/sql
 188 -
collection-schema_objects.sql
in src/dma/collector/sql/sources/postgres
 188 -
columntypes.sql
in scripts/collector/oracle/sql/extracts
 185 -
dbServerDmvPerfmon.sql
in scripts/collector/sqlserver/sql
 184 -
schema_objects.sql
in scripts/collector/mysql/sql
 181 -
lobsizing.sql
in scripts/collector/oracle/sql/extracts
 181 -
collection-schema_objects.sql
in src/dma/collector/sql/sources/mysql
 181 -
indexList.sql
in scripts/collector/sqlserver/sql
 179 -
iofunction.sql
in scripts/collector/oracle/sql/extracts/statspack
 177 -
iofunction.sql
in scripts/collector/oracle/sql/extracts/awr
 174 -
columnDatatypes.sql
in scripts/collector/sqlserver/sql
 170 -
sqlcmd10.sql
in scripts/collector/oracle/sql/extracts/awr
 168 -
database_details.sql
in scripts/collector/mysql/sql
 165 -
collection-database_details.sql
in src/dma/collector/sql/sources/mysql
 165 -
awrhistcmdtypes.sql
in scripts/collector/oracle/sql/extracts/statspack
 162 -
createCollectionUser.sql
in scripts/collector/sqlserver/sql
 161 -
tabletypes.sql
in scripts/collector/oracle/sql/extracts
 142 -
table_details.sql
in scripts/collector/postgres/sql/base
 139 -
table_details.sql
in scripts/collector/postgres/sql/13
 139 -
tabletypedtl.sql
in scripts/collector/oracle/sql/extracts
 137 -
table_details.sql
in scripts/collector/postgres/sql/12
 137 -
main.py
in src/dma/collector/workflows/readiness_check/_mysql
 133 8
dmaSQLServerCorrectPerfmonDataset.ps1
in scripts/collector/sqlserver
 128 -
collection-privileges.sql
in src/dma/collector/sql/sources/postgres
 124 -
dmaSQLServerHWSpecs.ps1
in scripts/collector/sqlserver
 122 -
Files With Most Units (Top 24)
File# lines# units
main.py
in src/dma/collector/workflows/readiness_check/_postgres
 698 32
base.py
in src/dma/collector/query_managers
 195 12
query_manager.py
in src/dma/lib/db
 55 11
base.py
in src/dma/collector/workflows/readiness_check
 120 10
base.py
in src/dma/collector/workflows/collection_extractor
 91 10
main.py
in src/dma/collector/workflows/readiness_check/_mysql
 133 8
main.py
in src/dma/cli
 327 6
utils.py
in src/dma
 83 5
base.py
in src/dma/collector/workflows
 36 4
postgres.py
in src/dma/collector/query_managers
 99 4
aioodbc.py
in src/dma/lib/db/adapters
 89 4
oracledb.py
in src/dma/lib/db/adapters
 91 4
mysql.py
in src/dma/collector/query_managers
 59 3
exceptions.py
in src/dma/lib
 19 3
helpers.py
in src/dma/collector/workflows/readiness_check/_mysql
 27 2
_mysql.py
in src/dma/collector/workflows/collection_extractor
 31 2
_postgres.py
in src/dma/collector/workflows/collection_extractor
 31 2
helpers.py
in src/dma/collector/util/postgres
 27 2
dependencies.py
in src/dma/collector
 72 2
oracle.py
in src/dma/collector/query_managers
 22 1
mssql.py
in src/dma/collector/query_managers
 22 1
base.py
in src/dma/lib/db
 75 1
local.py
in src/dma/lib/db
 34 1
asyncmy.py
in src/dma/lib/db/adapters
 49 1
Files With Long Lines (Top 50)

There are 74 files with lines longer than 120 characters. In total, there are 712 long lines.

File# lines# units# long lines
instanceReview.ps1
in scripts/collector/sqlserver
 651 - 149
dmaSQLServerPerfmonDataset.ps1
in scripts/collector/sqlserver
 679 - 65
serverProperties.sql
in scripts/collector/sqlserver/sql
 347 - 49
main.py
in src/dma/collector/workflows/readiness_check/_postgres
 698 32 42
columntypes.sql
in scripts/collector/oracle/sql/extracts
 185 - 35
sqlstats.sql
in scripts/collector/oracle/sql/extracts/statspack
 193 - 34
tableList.sql
in scripts/collector/sqlserver/sql
 481 - 31
awrhistcmdtypes.sql
in scripts/collector/oracle/sql/extracts/statspack
 162 - 31
dbServerTranLogBackupSizeByDayByHour.sql
in scripts/collector/sqlserver/sql
 58 - 26
iofunction.sql
in scripts/collector/oracle/sql/extracts/statspack
 177 - 20
iofunction.sql
in scripts/collector/oracle/sql/extracts/awr
 174 - 20
dbServerDmvPerfmon.sql
in scripts/collector/sqlserver/sql
 184 - 16
op_collect_init.sql
in scripts/collector/oracle/sql
 390 - 16
createUserWithSQLAuth.ps1
in scripts/collector/sqlserver
 112 - 14
dmaSQLServerCorrectPerfmonDataset.ps1
in scripts/collector/sqlserver
 128 - 13
createUserWithWindowsAuth.ps1
in scripts/collector/sqlserver
 76 - 9
dmaSQLServerHWSpecs.ps1
in scripts/collector/sqlserver
 122 - 8
ioevents.sql
in scripts/collector/oracle/sql/extracts/statspack
 86 - 7
ioevents.sql
in scripts/collector/oracle/sql/extracts/awr
 85 - 7
indexList.sql
in scripts/collector/sqlserver/sql
 179 - 6
lobsizing.sql
in scripts/collector/oracle/sql/extracts
 181 - 6
userConnectionInfo.sql
in scripts/collector/sqlserver/sql
 110 - 5
dbServerFeatures.sql
in scripts/collector/sqlserver/sql
 692 - 5
sqlstats.sql
in scripts/collector/oracle/sql/extracts/awr
 52 - 5
diskVolumeInfo.sql
in scripts/collector/sqlserver/sql
 70 - 4
app_schemas.sql
in scripts/collector/oracle/sql/extracts
 70 - 4
sqlstats111.sql
in scripts/collector/oracle/sql/extracts/awr
 53 - 4
foldername.sql
in scripts/collector/sqlserver/sql
 20 - 3
dbSizes.sql
in scripts/collector/sqlserver/sql
 78 - 3
dmaCollectorCommonFunctions.psm1
in scripts/collector/sqlserver
 92 - 3
grants_wrapper.sql
in scripts/collector/oracle/sql/setup
 252 - 3
awrhistosstat.sql
in scripts/collector/oracle/sql/extracts/statspack
 85 - 3
awrhistsysmetricsumm.sql
in scripts/collector/oracle/sql/extracts/statspack
 97 - 3
awrhistosstat.sql
in scripts/collector/oracle/sql/extracts/awr
 88 - 3
pdbsinfo.sql
in scripts/collector/oracle/sql/extracts
 61 - 3
dbobjectnames.sql
in scripts/collector/oracle/sql/extracts
 63 - 3
componentsInstalled.sql
in scripts/collector/sqlserver/sql
 545 - 2
getDmaSourceId.sql
in scripts/collector/sqlserver/sql
 16 - 2
getDBList.sql
in scripts/collector/sqlserver/sql
 35 - 2
checkValidInstanceVersion.sql
in scripts/collector/sqlserver/sql
 31 - 2
sourcecode.sql
in scripts/collector/oracle/sql/extracts
 55 - 2
dbsummary.sql
in scripts/collector/oracle/sql/extracts
 98 - 2
dbahistsystimemodel.sql
in scripts/collector/oracle/sql/extracts/statspack
 66 - 2
awrhistsysmetrichist.sql
in scripts/collector/oracle/sql/extracts/statspack
 60 - 2
dbahistsysstat.sql
in scripts/collector/oracle/sql/extracts/statspack
 77 - 2
sourceconn.sql
in scripts/collector/oracle/sql/extracts/awr
 42 - 2
dbahistsystimemodel.sql
in scripts/collector/oracle/sql/extracts/awr
 62 - 2
dbahistsysstat.sql
in scripts/collector/oracle/sql/extracts/awr
 82 - 2
dtlsourcecode.sql
in scripts/collector/oracle/sql/extracts
 57 - 2
dbobjects.sql
in scripts/collector/oracle/sql/extracts
 45 - 2
Correlations

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

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

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

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

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

pyproject.toml x: 1 commits (30d) y: 481 lines of code scripts/collector/sqlserver/instanceReview.ps1 x: 1 commits (30d) y: 651 lines of code scripts/collector/sqlserver/sql/dbServerFeatures.sql x: 1 commits (30d) y: 692 lines of code scripts/collector/sqlserver/sql/serverProperties.sql x: 1 commits (30d) y: 347 lines of code
692.0
lines of code
  min: 347.0
  average: 542.75
  25th percentile: 380.5
  median: 566.0
  75th percentile: 681.75
  max: 692.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): 4 points

pyproject.toml x: 1 contributors (30d) y: 481 lines of code scripts/collector/sqlserver/instanceReview.ps1 x: 1 contributors (30d) y: 651 lines of code scripts/collector/sqlserver/sql/dbServerFeatures.sql x: 1 contributors (30d) y: 692 lines of code scripts/collector/sqlserver/sql/serverProperties.sql x: 1 contributors (30d) y: 347 lines of code
692.0
lines of code
  min: 347.0
  average: 542.75
  25th percentile: 380.5
  median: 566.0
  75th percentile: 681.75
  max: 692.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): 34 points

pyproject.toml x: 4 commits (90d) y: 481 lines of code scripts/collector/sqlserver/instanceReview.ps1 x: 4 commits (90d) y: 651 lines of code scripts/collector/sqlserver/sql/dbServerFeatures.sql x: 2 commits (90d) y: 692 lines of code scripts/collector/sqlserver/sql/serverProperties.sql x: 1 commits (90d) y: 347 lines of code src/dma/__init__.py x: 2 commits (90d) y: 32 lines of code src/dma/collector/dependencies.py x: 3 commits (90d) y: 72 lines of code src/dma/collector/query_managers/__init__.py x: 1 commits (90d) y: 1 lines of code src/dma/collector/query_managers/base.py x: 1 commits (90d) y: 195 lines of code src/dma/collector/query_managers/mssql.py x: 1 commits (90d) y: 22 lines of code src/dma/collector/query_managers/mysql.py x: 1 commits (90d) y: 59 lines of code src/dma/collector/query_managers/postgres.py x: 1 commits (90d) y: 99 lines of code src/dma/collector/workflows/base.py x: 2 commits (90d) y: 36 lines of code src/dma/collector/workflows/collection_extractor/_mysql.py x: 1 commits (90d) y: 31 lines of code src/dma/collector/workflows/collection_extractor/base.py x: 2 commits (90d) y: 91 lines of code src/dma/lib/db/__init__.py x: 1 commits (90d) y: 15 lines of code src/dma/collector/workflows/readiness_check/_postgres/constants.py x: 1 commits (90d) y: 1813 lines of code src/dma/collector/workflows/readiness_check/_postgres/main.py x: 4 commits (90d) y: 698 lines of code src/dma/cli/main.py x: 2 commits (90d) y: 327 lines of code src/dma/collector/sql/canonical/ddls-postgres-collection.sql x: 3 commits (90d) y: 860 lines of code src/dma/collector/sql/sources/postgres/collection-privileges.sql x: 2 commits (90d) y: 124 lines of code src/dma/collector/sql/sources/postgres/collection-table_details.sql x: 2 commits (90d) y: 469 lines of code scripts/collector/sqlserver/sql/createCollectionUser.sql x: 1 commits (90d) y: 161 lines of code src/dma/collector/workflows/readiness_check/base.py x: 1 commits (90d) y: 120 lines of code src/dma/lib/db/base.py x: 1 commits (90d) y: 75 lines of code src/dma/lib/db/query_manager.py x: 1 commits (90d) y: 55 lines of code src/dma/types.py x: 1 commits (90d) y: 9 lines of code src/dma/collector/sql/sources/postgres/collection-bg_writer_stats.sql x: 1 commits (90d) y: 45 lines of code
1813.0
lines of code
  min: 1.0
  average: 226.74
  25th percentile: 22.0
  median: 65.5
  75th percentile: 332.0
  max: 1813.0
0 4.0
commits (90d)
min: 1.0 | average: 1.59 | 25th percentile: 1.0 | median: 1.0 | 75th percentile: 2.0 | max: 4.0

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

pyproject.toml x: 2 contributors (90d) y: 481 lines of code scripts/collector/sqlserver/instanceReview.ps1 x: 2 contributors (90d) y: 651 lines of code scripts/collector/sqlserver/sql/dbServerFeatures.sql x: 2 contributors (90d) y: 692 lines of code scripts/collector/sqlserver/sql/serverProperties.sql x: 1 contributors (90d) y: 347 lines of code src/dma/__init__.py x: 1 contributors (90d) y: 32 lines of code src/dma/collector/dependencies.py x: 1 contributors (90d) y: 72 lines of code src/dma/collector/query_managers/__init__.py x: 1 contributors (90d) y: 1 lines of code src/dma/collector/query_managers/base.py x: 1 contributors (90d) y: 195 lines of code src/dma/collector/query_managers/mssql.py x: 1 contributors (90d) y: 22 lines of code src/dma/collector/query_managers/mysql.py x: 1 contributors (90d) y: 59 lines of code src/dma/collector/query_managers/postgres.py x: 1 contributors (90d) y: 99 lines of code src/dma/collector/workflows/base.py x: 1 contributors (90d) y: 36 lines of code src/dma/collector/workflows/collection_extractor/base.py x: 1 contributors (90d) y: 91 lines of code src/dma/lib/db/__init__.py x: 1 contributors (90d) y: 15 lines of code src/dma/collector/workflows/readiness_check/_postgres/constants.py x: 1 contributors (90d) y: 1813 lines of code src/dma/collector/workflows/readiness_check/_postgres/main.py x: 2 contributors (90d) y: 698 lines of code src/dma/cli/main.py x: 1 contributors (90d) y: 327 lines of code src/dma/collector/sql/canonical/ddls-postgres-collection.sql x: 2 contributors (90d) y: 860 lines of code src/dma/collector/sql/sources/postgres/collection-privileges.sql x: 2 contributors (90d) y: 124 lines of code src/dma/collector/sql/sources/postgres/collection-table_details.sql x: 2 contributors (90d) y: 469 lines of code scripts/collector/sqlserver/sql/createCollectionUser.sql x: 1 contributors (90d) y: 161 lines of code src/dma/collector/workflows/readiness_check/base.py x: 1 contributors (90d) y: 120 lines of code src/dma/lib/db/query_manager.py x: 1 contributors (90d) y: 55 lines of code src/dma/types.py x: 1 contributors (90d) y: 9 lines of code src/dma/collector/sql/sources/postgres/collection-bg_writer_stats.sql x: 1 contributors (90d) y: 45 lines of code
1813.0
lines of code
  min: 1.0
  average: 226.74
  25th percentile: 22.0
  median: 65.5
  75th percentile: 332.0
  max: 1813.0
0 2.0
contributors (90d)
min: 1.0 | average: 1.21 | 25th percentile: 1.0 | median: 1.0 | 75th percentile: 1.0 | max: 2.0