-
-
Save vinnix/87b698d89ee2d1c81b54 to your computer and use it in GitHub Desktop.
nice!
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
soocial_production=# vacuum analyze verbose _soocial_cluster.sl_log_2; | |
INFO: vacuuming "_soocial_cluster.sl_log_2" | |
INFO: scanned index "sl_log_2_idx1" to remove 41794 row versions | |
DETAIL: CPU 3.35s/7.79u sec elapsed 294.78 sec. | |
INFO: scanned index "PartInd_soocial_cluster_sl_log_2-node-1" to remove 41794 row versions | |
DETAIL: CPU 1.84s/8.09u sec elapsed 118.86 sec. | |
INFO: "sl_log_2": removed 41794 row versions in 2204 pages | |
DETAIL: CPU 0.01s/0.01u sec elapsed 14.64 sec. | |
INFO: index "sl_log_2_idx1" now contains 80162061 row versions in 417346 pages | |
DETAIL: 41794 index row versions were removed. | |
377 index pages have been deleted, 0 are currently reusable. | |
CPU 0.00s/0.00u sec elapsed 1.19 sec. | |
INFO: index "PartInd_soocial_cluster_sl_log_2-node-1" now contains 80164789 row versions in 230597 pages | |
DETAIL: 41794 index row versions were removed. | |
139 index pages have been deleted, 1 are currently reusable. | |
CPU 0.00s/0.00u sec elapsed 0.13 sec. | |
INFO: "sl_log_2": found 41173 removable, 23919586 nonremovable row versions in 1066110 out of 2990935 pages | |
DETAIL: 0 dead row versions cannot be removed yet. | |
There were 0 unused item pointers. | |
0 pages are entirely empty. | |
CPU 29.31s/22.04u sec elapsed 6695.17 sec. | |
INFO: vacuuming "pg_toast.pg_toast_16508068" | |
INFO: scanned index "pg_toast_16508068_index" to remove 123 row versions | |
DETAIL: CPU 0.31s/0.51u sec elapsed 27.11 sec. | |
INFO: "pg_toast_16508068": removed 123 row versions in 35 pages | |
DETAIL: CPU 0.00s/0.00u sec elapsed 1.01 sec. | |
INFO: index "pg_toast_16508068_index" now contains 9330598 row versions in 25746 pages | |
DETAIL: 123 index row versions were removed. | |
0 index pages have been deleted, 0 are currently reusable. | |
CPU 0.00s/0.00u sec elapsed 0.00 sec. | |
INFO: "pg_toast_16508068": found 123 removable, 4102229 nonremovable row versions in 1146015 out of 2403881 pages | |
DETAIL: 0 dead row versions cannot be removed yet. | |
There were 7 unused item pointers. | |
0 pages are entirely empty. | |
CPU 26.11s/5.28u sec elapsed 1297.19 sec. | |
INFO: analyzing "_soocial_cluster.sl_log_2" | |
INFO: "sl_log_2": scanned 30000 of 2997122 pages, containing 802615 live rows and 0 dead rows; 30000 rows in sample, 80184502 estimated total rows | |
VACUUM |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment