12:07 a.m.
Date: 2024-08-28 00:00:00
The total memory size is: 32861736.
A cleanup has been performed on the following partitions:
Partition: hpco_gdb.job_cluster_gpsc5
hpco_gdb.job_cluster_gpsc5 size is: 637919232 bytes.
It exceeds the threshold of 27932475 bytes.
Backup created for hpco_gdb.job_cluster_gpsc5:
/gpfs/fs5/ssc/ssc_hpco/gdb_operation/gdb/warehouse/ofelia_memory_check/backup_2024-08-28_hpco_gdb.job_cluster_gpsc5.sql
Average row size for hpco_gdb.job_cluster_gpsc5: 838 bytes per row.
Total number of rows before cleanup: 643959.
Number of rows to be deleted: 628274.
Total number of rows after clean-up: 15685.
Partition size after cleanup: 234283008 bytes.
Partition: hpco_gdb.job_cluster_gpsc6
hpco_gdb.job_cluster_gpsc6 size is: 488161280 bytes.
It exceeds the threshold of 27932475 bytes.
Backup created for hpco_gdb.job_cluster_gpsc6:
/gpfs/fs5/ssc/ssc_hpco/gdb_operation/gdb/warehouse/ofelia_memory_check/backup_2024-08-28_hpco_gdb.job_cluster_gpsc6.sql
Average row size for hpco_gdb.job_cluster_gpsc6: 934 bytes per row.
Total number of rows before cleanup: 476719.
Number of rows to be deleted: 462646.
Total number of rows after clean-up: 14073.
Partition size after cleanup: 11231232 bytes.
Partition: hpco_gdb.job_cluster_gpsc7
hpco_gdb.job_cluster_gpsc7 size is: 2963611648 bytes.
It exceeds the threshold of 27932475 bytes.
Backup created for hpco_gdb.job_cluster_gpsc7:
/gpfs/fs5/ssc/ssc_hpco/gdb_operation/gdb/warehouse/ofelia_memory_check/backup_2024-08-28_hpco_gdb.job_cluster_gpsc7.sql
Average row size for hpco_gdb.job_cluster_gpsc7: 756 bytes per row.
Total number of rows before cleanup: 2584113.
Number of rows to be deleted: 2566726.
Total number of rows after clean-up: 17387.
Partition size after cleanup: 11427840 bytes.
Partition: hpco_gdb.job_cluster_gpsc8
hpco_gdb.job_cluster_gpsc8 size is: 2276794368 bytes.
It exceeds the threshold of 27932475 bytes.
Backup created for hpco_gdb.job_cluster_gpsc8:
/gpfs/fs5/ssc/ssc_hpco/gdb_operation/gdb/warehouse/ofelia_memory_check/backup_2024-08-28_hpco_gdb.job_cluster_gpsc8.sql
Average row size for hpco_gdb.job_cluster_gpsc8: 662 bytes per row.
Total number of rows before cleanup: 2130562.
Number of rows to be deleted: 2110706.
Total number of rows after clean-up: 19856.
Partition size after cleanup: 14737408 bytes.
Partition: hpco_gdb.job_cluster_gpscc3
hpco_gdb.job_cluster_gpscc3 size is: 232464384 bytes.
It exceeds the threshold of 27932475 bytes.
Backup created for hpco_gdb.job_cluster_gpscc3:
/gpfs/fs5/ssc/ssc_hpco/gdb_operation/gdb/warehouse/ofelia_memory_check/backup_2024-08-28_hpco_gdb.job_cluster_gpscc3.sql
Average row size for hpco_gdb.job_cluster_gpscc3: 898 bytes per row.
Total number of rows before cleanup: 176670.
Number of rows to be deleted: 162033.
Total number of rows after clean-up: 14637.
Partition size after cleanup: 10051584 bytes.
Partition: hpco_gdb.job_cluster_ppp5
hpco_gdb.job_cluster_ppp5 size is: 1133346816 bytes.
It exceeds the threshold of 27932475 bytes.
Backup created for hpco_gdb.job_cluster_ppp5:
/gpfs/fs5/ssc/ssc_hpco/gdb_operation/gdb/warehouse/ofelia_memory_check/backup_2024-08-28_hpco_gdb.job_cluster_ppp5.sql
Average row size for hpco_gdb.job_cluster_ppp5: 0 bytes per row.
Total number of rows before cleanup: 0.
Number of rows to be deleted: .
Total number of rows after clean-up: 0.
Partition size after cleanup: 57344 bytes.
Partition: hpco_gdb.job_cluster_ppp6
hpco_gdb.job_cluster_ppp6 size is: 525516800 bytes.
It exceeds the threshold of 27932475 bytes.
Backup created for hpco_gdb.job_cluster_ppp6:
/gpfs/fs5/ssc/ssc_hpco/gdb_operation/gdb/warehouse/ofelia_memory_check/backup_2024-08-28_hpco_gdb.job_cluster_ppp6.sql
Average row size for hpco_gdb.job_cluster_ppp6: 0 bytes per row.
Total number of rows before cleanup: 0.
Number of rows to be deleted: .
Total number of rows after clean-up: 0.
Partition size after cleanup: 57344 bytes.
Partition: hpco_gdb.job_cluster_robert
hpco_gdb.job_cluster_robert size is: 3449520128 bytes.
It exceeds the threshold of 27932475 bytes.
Backup created for hpco_gdb.job_cluster_robert:
/gpfs/fs5/ssc/ssc_hpco/gdb_operation/gdb/warehouse/ofelia_memory_check/backup_2024-08-28_hpco_gdb.job_cluster_robert.sql
Average row size for hpco_gdb.job_cluster_robert: 553 bytes per row.
Total number of rows before cleanup: 3668353.
Number of rows to be deleted: 3644584.
Total number of rows after clean-up: 23778.
Partition size after cleanup: 7307264 bytes.
Partition: hpco_gdb.job_cluster_underhill
hpco_gdb.job_cluster_underhill size is: 1893154816 bytes.
It exceeds the threshold of 27932475 bytes.
Backup created for hpco_gdb.job_cluster_underhill:
/gpfs/fs5/ssc/ssc_hpco/gdb_operation/gdb/warehouse/ofelia_memory_check/backup_2024-08-28_hpco_gdb.job_cluster_underhill.sql
Average row size for hpco_gdb.job_cluster_underhill: 554 bytes per row.
Total number of rows before cleanup: 2829083.
Number of rows to be deleted: 2805357.
Total number of rows after clean-up: 23732.
Partition size after cleanup: 8134656 bytes.