Skip to content

Instantly share code, notes, and snippets.

@vinnix
Created October 24, 2010 00:14
Show Gist options
  • Save vinnix/87b698d89ee2d1c81b54 to your computer and use it in GitHub Desktop.
Save vinnix/87b698d89ee2d1c81b54 to your computer and use it in GitHub Desktop.
nice!
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