awslabs / amazon-redshift-utils
File Age

File age measurements show the distribution of file ages (days since the first commit) and the recency of file updates (days since the latest commit).

Summary
  • Number of files: 59
  • Daily file updates (only one update per file and date counted): 1409
  • First update: 2014-12-09
  • Latest update: 2022-01-19
  • Days between first and latest update: 2599 (371 weeks, estimated 1855 working days)
  • Active days (at least one file change): 472
  • Data:
File Change History Overall
File Age Distribution Overall
Days since first update
  • There are 59 files with 11,588 lines of code in files.
    • 50 files that are 366+ days old (6,635 lines of code)
    • 9 files that are 181-365 days old (4,953 lines of code)
    • 0 files that are 91-180 days old (0 lines of code)
    • 0 files that are 31-90 days old (0 lines of code)
    • 0 files that are 1-30 days old (0 lines of code)
57% | 42% | 0% | 0% | 0%
Legend:
366+
181-365
91-180
31-90
1-30
Latest Change Distribution Overall
Days since last update
  • There are 59 files with 11,588 lines of code in files.
    • 40 files have been last changed 366+ days ago (4,563 lines of code)
    • 15 files have been last changed 181-365 days ago (4,611 lines of code)
    • 4 files have been last changed 91-180 days ago (2,414 lines of code)
    • 0 files have been last changed 31-90 days ago (0 lines of code)
    • 0 files have been last changed 1-30 days ago (0 lines of code)
39% | 39% | 20% | 0% | 0%
Legend:
366+
181-365
91-180
31-90
1-30
File Change History per File Extension
sql, py, sh, md, txt, json, yaml, gitignore, js, ini, project, html
File Age Distribution per Extension
Days since first update
366+
181-365
91-180
31-90
1-30
py64% | 35% | 0% | 0% | 0%
yaml32% | 67% | 0% | 0% | 0%
js100% | 0% | 0% | 0% | 0%
html100% | 0% | 0% | 0% | 0%
Latest Change Distribution per Extension
Days since last update
366+
181-365
91-180
31-90
1-30
py42% | 27% | 30% | 0% | 0%
yaml31% | 67% | <1% | 0% | 0%
html100% | 0% | 0% | 0% | 0%
js5% | 94% | 0% | 0% | 0%
File Change History per Logical Decomposition
primary
primary (file age distribution)
Days since first update
366+
181-365
91-180
31-90
1-30
src/UnloadCopyUtility100% | 0% | 0% | 0% | 0%
src/ColumnEncodingUtility100% | 0% | 0% | 0% | 0%
src/RedshiftAutomation100% | 0% | 0% | 0% | 0%
src/AnalyzeVacuumUtility100% | 0% | 0% | 0% | 0%
src/SnapshotManager100% | 0% | 0% | 0% | 0%
src/MetadataTransfer100% | 0% | 0% | 0% | 0%
src/QMRNotificationUtility100% | 0% | 0% | 0% | 0%
src/SystemTablePersistence100% | 0% | 0% | 0% | 0%
src100% | 0% | 0% | 0% | 0%
src/SimpleReplay3% | 96% | 0% | 0% | 0%
src/UnloadAutoPartitions100% | 0% | 0% | 0% | 0%
src/MultipleTableRestoreUtility100% | 0% | 0% | 0% | 0%
src/UserLastLogin100% | 0% | 0% | 0% | 0%
src/WorkloadManagementScheduler100% | 0% | 0% | 0% | 0%
src/BlogContent0% | 100% | 0% | 0% | 0%
primary (latest change distribution)
Days since last update
366+
181-365
91-180
31-90
1-30
src/UnloadCopyUtility91% | 8% | 0% | 0% | 0%
src/RedshiftAutomation100% | 0% | 0% | 0% | 0%
src/AnalyzeVacuumUtility84% | 15% | 0% | 0% | 0%
src/MetadataTransfer100% | 0% | 0% | 0% | 0%
src/QMRNotificationUtility70% | 29% | 0% | 0% | 0%
src/SnapshotManager45% | 54% | 0% | 0% | 0%
src100% | 0% | 0% | 0% | 0%
src/UnloadAutoPartitions100% | 0% | 0% | 0% | 0%
src/SystemTablePersistence41% | 58% | 0% | 0% | 0%
src/UserLastLogin100% | 0% | 0% | 0% | 0%
src/WorkloadManagementScheduler100% | 0% | 0% | 0% | 0%
src/SimpleReplay<1% | 51% | 47% | 0% | 0%
src/ColumnEncodingUtility0% | 100% | 0% | 0% | 0%
src/MultipleTableRestoreUtility0% | 100% | 0% | 0% | 0%
src/BlogContent0% | 100% | 0% | 0% | 0%
Oldest Files (Top 20)
File# lines# unitslast modified
(days ago)
created
(days ago)
# changes
analyze-schema-compression.py
in src/ColumnEncodingUtility
943 20 215 2546 97
analyze-vacuum-schema.py
in src/AnalyzeVacuumUtility
109 1 215 2371 60
redshift-unload-copy.py
in src/UnloadCopyUtility
7 - 215 2360 14
snapshotManager.js
in src/SnapshotManager
263 18 215 2057 16
constants.js
in src/SnapshotManager
9 - 1968 2057 6
index.js
in src/SnapshotManager
6 1 1968 2057 4
schedule.py
in src/SnapshotManager
46 1 1425 2052 12
multitablerestore.py
in src/MultipleTableRestoreUtility
145 7 215 1753 11
qmr-action-notification-utility.yaml
in src/QMRNotificationUtility/cloudformation
250 - 1425 1680 4
lambda_function.py
in src/QMRNotificationUtility/lambda
105 5 215 1680 4
analyze_vacuum.py
in src/AnalyzeVacuumUtility/lib
592 10 440 1539 47
deploy.yaml
in src/RedshiftAutomation
299 - 440 1504 24
ConfigurationForm.html
in src/RedshiftAutomation
160 - 440 1504 15
config_constants.py
in src
130 2 440 1504 21
lambda_function.py
in src/RedshiftAutomation
120 2 965 1504 18
deploy-function-and-schedule.yaml
in src/RedshiftAutomation
104 - 440 1504 18
encrypt_password.py
in src/RedshiftAutomation
64 2 1425 1504 5
deploy-schedule.yaml
in src/RedshiftAutomation
52 - 440 1504 13
test.py
in src
2 - 1425 1502 4
snapshot_system_stats.py
in src/SystemTablePersistence
188 7 215 1469 13
Files Not Recently Changed (Top 20)
File# lines# unitslast modified
(days ago)
created
(days ago)
# changes
index.js
in src/SnapshotManager
6 1 1968 2057 4
constants.js
in src/SnapshotManager
9 - 1968 2057 6
test.py
in src
2 - 1425 1502 4
schedule.py
in src/SnapshotManager
46 1 1425 2052 12
encrypt_password.py
in src/RedshiftAutomation
64 2 1425 1504 5
qmr-action-notification-utility.yaml
in src/QMRNotificationUtility/cloudformation
250 - 1425 1680 4
__init__.py
in src/UnloadCopyUtility/util
1 - 1350 1466 5
__init__.py
in src/UnloadCopyUtility/util/sql
1 - 1350 1466 5
sql_queries.py
in src/UnloadCopyUtility/util
4 - 1350 1466 5
child_object.py
in src/UnloadCopyUtility/util
13 3 1350 1466 5
kms_helper.py
in src/UnloadCopyUtility/util
25 4 1350 1466 5
pgpass.py
in src/UnloadCopyUtility/util
65 13 1350 1466 5
sql_text_helpers.py
in src/UnloadCopyUtility/util/sql
158 15 1350 1466 5
tasks.py
in src/UnloadCopyUtility/util
177 33 1350 1466 5
ddl_generators.py
in src/UnloadCopyUtility/util/sql
189 27 1350 1466 5
global_config.py
in src/UnloadCopyUtility
275 42 1350 1466 5
wlm_scheduler.py
in src/WorkloadManagementScheduler
104 6 1343 1413 4
queries.py
in src/MetadataTransfer
18 - 965 1337 3
dbconstring.py
in src/MetadataTransfer
29 3 965 1337 3
common.py
in src/RedshiftAutomation
58 2 965 1462 10
Most Recently Created Files (Top 20)
File# lines# unitslast modified
(days ago)
created
(days ago)
# changes
ParallelExecute.py
in src/BlogContent/SyntheticMixedBenchmark
79 1 195 195 1
util.py
in src/SimpleReplay
80 7 159 224 2
ra3-migration-replay.yaml
in src/SimpleReplay/cloudformation
1294 - 242 265 2
ra3-migration-extract.yaml
in src/SimpleReplay/cloudformation
857 - 265 265 1
LambdaReplay.py
in src/SimpleReplay/cloudformation
204 11 265 265 1
LambdaSimpleReplayExtract.py
in src/SimpleReplay/cloudformation
121 8 265 265 1
replay.py
in src/SimpleReplay
1303 47 159 363 7
extract.py
in src/SimpleReplay
1003 35 159 363 8
extract.yaml
in src/SimpleReplay
12 - 224 363 3
ParseUserActivityLog.py
in src/SimpleReplay/PreviousVersion
136 9 215 470 3
replay.yaml
in src/SimpleReplay
28 - 159 470 6
extract_template.yaml
in src/SimpleReplay
10 - 440 470 2
redshift_utils_helper.py
in src
54 3 440 517 2
genunload.py
in src/UnloadAutoPartitions
157 6 440 964 2
user_last_login.py
in src/UserLastLogin
84 1 440 1165 6
utils.py
in src/UserLastLogin/lib
18 1 440 1165 6
queries.py
in src/UserLastLogin/lib
8 - 440 1165 6
deploy-systable-standalone.yaml
in src/SystemTablePersistence
131 - 440 1211 4
userprivs.py
in src/MetadataTransfer
160 4 965 1337 3
metadatacopy.py
in src/MetadataTransfer
159 4 965 1337 3
Most Recently Changed Files (Top 20)
File# lines# unitslast modified
(days ago)
created
(days ago)
# changes
replay.py
in src/SimpleReplay
1303 47 159 363 7
extract.py
in src/SimpleReplay
1003 35 159 363 8
util.py
in src/SimpleReplay
80 7 159 224 2
replay.yaml
in src/SimpleReplay
28 - 159 470 6
ParallelExecute.py
in src/BlogContent/SyntheticMixedBenchmark
79 1 195 195 1
analyze-schema-compression.py
in src/ColumnEncodingUtility
943 20 215 2546 97
snapshotManager.js
in src/SnapshotManager
263 18 215 2057 16
snapshot_system_stats.py
in src/SystemTablePersistence
188 7 215 1469 13
redshift_unload_copy.py
in src/UnloadCopyUtility
148 7 215 1466 18
multitablerestore.py
in src/MultipleTableRestoreUtility
145 7 215 1753 11
ParseUserActivityLog.py
in src/SimpleReplay/PreviousVersion
136 9 215 470 3
analyze-vacuum-schema.py
in src/AnalyzeVacuumUtility
109 1 215 2371 60
lambda_function.py
in src/QMRNotificationUtility/lambda
105 5 215 1680 4
redshift-unload-copy.py
in src/UnloadCopyUtility
7 - 215 2360 14
extract.yaml
in src/SimpleReplay
12 - 224 363 3
ra3-migration-replay.yaml
in src/SimpleReplay/cloudformation
1294 - 242 265 2
ra3-migration-extract.yaml
in src/SimpleReplay/cloudformation
857 - 265 265 1
LambdaReplay.py
in src/SimpleReplay/cloudformation
204 11 265 265 1
LambdaSimpleReplayExtract.py
in src/SimpleReplay/cloudformation
121 8 265 265 1
analyze_vacuum.py
in src/AnalyzeVacuumUtility/lib
592 10 440 1539 47