ob2=# VACUUM VERBOSE ANALYZE _comment ;
INFO: vacuuming "ob2._comment"
INFO: scanned index "_comment_pkey" to remove 2368 row versions
DETAIL: CPU 0.23s/0.68u sec elapsed 44.96 sec.
INFO: scanned index "gist_idx_comment_path" to remove 2368 row versions
DETAIL: CPU 1.04s/0.74u sec elapsed 129.87 sec.
INFO: scanned index "idx_comment_date_creation" to remove 2368 row versions
DETAIL: CPU 0.11s/0.46u sec elapsed 30.60 sec.
INFO: scanned index "idx_comment_date_modification" to remove 2368 row versions
DETAIL: CPU 0.12s/0.53u sec elapsed 25.73 sec.
INFO: scanned index "idx_comment_date_publishing" to remove 2368 row versions
DETAIL: CPU 0.12s/0.39u sec elapsed 36.36 sec.
INFO: scanned index "idx_comment_parent_id" to remove 2368 row versions
DETAIL: CPU 0.22s/0.57u sec elapsed 14.74 sec.
INFO: scanned index "idx_comment_reference" to remove 2368 row versions
DETAIL: CPU 0.09s/0.33u sec elapsed 40.66 sec.
INFO: "_comment": removed 2368 row versions in 1513 pages
DETAIL: CPU 0.25s/0.25u sec elapsed 64.83 sec.
INFO: index "_comment_pkey" now contains 3825889 row versions in 19134 pages
DETAIL: 2324 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: index "gist_idx_comment_path" now contains 3826008 row versions in 74018 pages
DETAIL: 2368 index row versions were removed.
0 index pages have been deleted, 0 are currently reusable.
CPU 0.59s/0.19u sec elapsed 7.72 sec.
INFO: index "idx_comment_date_creation" now contains 3825889 row versions in 13488 pages
DETAIL: 2368 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: index "idx_comment_date_modification" now contains 3825889 row versions in 13399 pages
DETAIL: 2368 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: index "idx_comment_date_publishing" now contains 3825889 row versions in 13458 pages
DETAIL: 2368 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: index "idx_comment_parent_id" now contains 3825889 row versions in 19123 pages
DETAIL: 2276 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: index "idx_comment_reference" now contains 3825889 row versions in 11850 pages
DETAIL: 2368 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: "_comment": found 2368 removable, 3825889 nonremovable row versions in 262463 pages
DETAIL: 2 dead row versions cannot be removed yet.
There were 52840 unused item pointers.
1024 pages contain useful free space.
0 pages are entirely empty.
CPU 5.55s/5.18u sec elapsed 720.23 sec.
INFO: vacuuming "pg_toast.pg_toast_17153"
INFO: scanned index "pg_toast_17153_index" to remove 6 row versions
DETAIL: CPU 0.01s/0.00u sec elapsed 0.29 sec.
INFO: "pg_toast_17153": removed 6 row versions in 3 pages
DETAIL: CPU 0.00s/0.00u sec elapsed 0.21 sec.
INFO: index "pg_toast_17153_index" now contains 23521 row versions in 69 pages
DETAIL: 6 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_17153": found 6 removable, 23521 nonremovable row versions in 4882 pages
DETAIL: 0 dead row versions cannot be removed yet.
There were 118 unused item pointers.
129 pages contain useful free space.
0 pages are entirely empty.
CPU 0.11s/0.02u sec elapsed 8.50 sec.
INFO: analyzing "ob2._comment"
INFO: "_comment": scanned 30000 of 262476 pages, containing 436946 live rows and 0 dead rows; 30000 rows in sample, 3822928 estimated total rows
VACUUM