Pastebin
Paste #1699: pgsql vacuum vebose
< previous paste - next paste>
Pasted by tdn
sohostingdev=# VACUUM VERBOSE maillogamavis; INFO: vacuuming "public.maillogamavis" INFO: index "pkmaillogamavis" now contains 0 row versions in 839 pages DETAIL: 0 index row versions were removed. 835 index pages have been deleted, 835 are currently reusable. CPU 0.00s/0.00u sec elapsed 0.06 sec. INFO: index "maillogamavis_logdate_idx" now contains 0 row versions in 151 pages DETAIL: 0 index row versions were removed. 148 index pages have been deleted, 148 are currently reusable. CPU 0.00s/0.00u sec elapsed 0.01 sec. INFO: index "maillogamavis_messageid_idx" now contains 0 row versions in 749 pages DETAIL: 0 index row versions were removed. 745 index pages have been deleted, 745 are currently reusable. CPU 0.00s/0.00u sec elapsed 0.05 sec. INFO: "maillogamavis": found 0 removable, 0 nonremovable row versions in 0 pages DETAIL: 0 dead row versions cannot be removed yet. There were 0 unused item pointers. 0 pages contain useful free space. 0 pages are entirely empty. CPU 0.00s/0.00u sec elapsed 0.12 sec. INFO: vacuuming "pg_toast.pg_toast_179946" INFO: index "pg_toast_179946_index" now contains 0 row versions in 1 pages DETAIL: 0 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_179946": found 0 removable, 0 nonremovable row versions in 0 pages DETAIL: 0 dead row versions cannot be removed yet. There were 0 unused item pointers. 0 pages contain useful free space. 0 pages are entirely empty. CPU 0.00s/0.00u sec elapsed 0.00 sec. VACUUM sohostingdev=# VACUUM VERBOSE maillogautoreply; INFO: vacuuming "public.maillogautoreply" INFO: index "pkmaillogautoreply" now contains 0 row versions in 1 pages DETAIL: 0 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 "maillogautoreply_logdate_idx" now contains 0 row versions in 1 pages DETAIL: 0 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 "maillogautoreply_mailid_idx" now contains 0 row versions in 1 pages DETAIL: 0 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: "maillogautoreply": found 0 removable, 0 nonremovable row versions in 0 pages DETAIL: 0 dead row versions cannot be removed yet. There were 0 unused item pointers. 0 pages contain useful free space. 0 pages are entirely empty. CPU 0.00s/0.00u sec elapsed 0.00 sec. VACUUM sohostingdev=# VACUUM VERBOSE maillogbounce; INFO: vacuuming "public.maillogbounce" INFO: index "pkmaillogbounce" now contains 0 row versions in 7 pages DETAIL: 0 index row versions were removed. 4 index pages have been deleted, 4 are currently reusable. CPU 0.00s/0.00u sec elapsed 0.00 sec. INFO: index "maillogbounce_logdate_idx" now contains 0 row versions in 4 pages DETAIL: 0 index row versions were removed. 1 index pages have been deleted, 1 are currently reusable. CPU 0.00s/0.00u sec elapsed 0.00 sec. INFO: index "maillogbounce_mailid_idx" now contains 0 row versions in 5 pages DETAIL: 0 index row versions were removed. 2 index pages have been deleted, 2 are currently reusable. CPU 0.00s/0.00u sec elapsed 0.00 sec. INFO: "maillogbounce": found 0 removable, 0 nonremovable row versions in 0 pages DETAIL: 0 dead row versions cannot be removed yet. There were 0 unused item pointers. 0 pages contain useful free space. 0 pages are entirely empty. CPU 0.00s/0.00u sec elapsed 0.00 sec. VACUUM sohostingdev=# VACUUM VERBOSE maillogcleanup; INFO: vacuuming "public.maillogcleanup" INFO: index "pkmaillogcleanup" now contains 0 row versions in 668 pages DETAIL: 0 index row versions were removed. 664 index pages have been deleted, 664 are currently reusable. CPU 0.00s/0.00u sec elapsed 0.05 sec. INFO: index "maillogcleanup_logdate_idx" now contains 0 row versions in 287 pages DETAIL: 0 index row versions were removed. 284 index pages have been deleted, 284 are currently reusable. CPU 0.00s/0.00u sec elapsed 0.02 sec. INFO: index "maillogcleanup_mailid_idx" now contains 0 row versions in 535 pages DETAIL: 0 index row versions were removed. 531 index pages have been deleted, 531 are currently reusable. CPU 0.00s/0.00u sec elapsed 0.04 sec. INFO: "maillogcleanup": found 0 removable, 0 nonremovable row versions in 0 pages DETAIL: 0 dead row versions cannot be removed yet. There were 0 unused item pointers. 0 pages contain useful free space. 0 pages are entirely empty. CPU 0.00s/0.00u sec elapsed 0.11 sec. INFO: vacuuming "pg_toast.pg_toast_179976" INFO: index "pg_toast_179976_index" now contains 0 row versions in 1 pages DETAIL: 0 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_179976": found 0 removable, 0 nonremovable row versions in 0 pages DETAIL: 0 dead row versions cannot be removed yet. There were 0 unused item pointers. 0 pages contain useful free space. 0 pages are entirely empty. CPU 0.00s/0.00u sec elapsed 0.00 sec. VACUUM sohostingdev=# VACUUM VERBOSE maillogqmgr; INFO: vacuuming "public.maillogqmgr" INFO: index "pkmaillogqmgr" now contains 0 row versions in 817 pages DETAIL: 0 index row versions were removed. 813 index pages have been deleted, 813 are currently reusable. CPU 0.00s/0.00u sec elapsed 0.06 sec. INFO: index "maillogqmgr_logdate_idx" now contains 0 row versions in 438 pages DETAIL: 0 index row versions were removed. 434 index pages have been deleted, 434 are currently reusable. CPU 0.00s/0.00u sec elapsed 0.03 sec. INFO: index "maillogqmgr_mailid_idx" now contains 0 row versions in 588 pages DETAIL: 0 index row versions were removed. 584 index pages have been deleted, 584 are currently reusable. CPU 0.00s/0.00u sec elapsed 0.04 sec. INFO: "maillogqmgr": found 0 removable, 0 nonremovable row versions in 0 pages DETAIL: 0 dead row versions cannot be removed yet. There were 0 unused item pointers. 0 pages contain useful free space. 0 pages are entirely empty. CPU 0.01s/0.00u sec elapsed 0.14 sec. INFO: vacuuming "pg_toast.pg_toast_179988" INFO: index "pg_toast_179988_index" now contains 0 row versions in 1 pages DETAIL: 0 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_179988": found 0 removable, 0 nonremovable row versions in 0 pages DETAIL: 0 dead row versions cannot be removed yet. There were 0 unused item pointers. 0 pages contain useful free space. 0 pages are entirely empty. CPU 0.00s/0.00u sec elapsed 0.00 sec. VACUUM sohostingdev=# VACUUM VERBOSE maillogsmtp; INFO: vacuuming "public.maillogsmtp" INFO: index "pkmaillogsmtp" now contains 0 row versions in 217 pages DETAIL: 0 index row versions were removed. 213 index pages have been deleted, 213 are currently reusable. CPU 0.00s/0.00u sec elapsed 0.01 sec. INFO: index "maillogsmtp_logdate_idx" now contains 0 row versions in 54 pages DETAIL: 0 index row versions were removed. 51 index pages have been deleted, 51 are currently reusable. CPU 0.00s/0.00u sec elapsed 0.00 sec. INFO: index "maillogsmtp_mailid_idx" now contains 0 row versions in 100 pages DETAIL: 0 index row versions were removed. 97 index pages have been deleted, 97 are currently reusable. CPU 0.00s/0.00u sec elapsed 0.00 sec. INFO: index "maillogto_maildomain_idx" now contains 0 row versions in 103 pages DETAIL: 0 index row versions were removed. 100 index pages have been deleted, 100 are currently reusable. CPU 0.00s/0.00u sec elapsed 0.00 sec. INFO: "maillogsmtp": found 0 removable, 0 nonremovable row versions in 0 pages DETAIL: 0 dead row versions cannot be removed yet. There were 0 unused item pointers. 0 pages contain useful free space. 0 pages are entirely empty. CPU 0.00s/0.00u sec elapsed 0.03 sec. INFO: vacuuming "pg_toast.pg_toast_180000" INFO: index "pg_toast_180000_index" now contains 0 row versions in 1 pages DETAIL: 0 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_180000": found 0 removable, 0 nonremovable row versions in 0 pages DETAIL: 0 dead row versions cannot be removed yet. There were 0 unused item pointers. 0 pages contain useful free space. 0 pages are entirely empty. CPU 0.00s/0.00u sec elapsed 0.00 sec. VACUUM sohostingdev=# VACUUM VERBOSE maillogsmtpdaccepted; INFO: vacuuming "public.maillogsmtpdaccepted" INFO: index "pkmaillogsmtpdaccepted" now contains 0 row versions in 518 pages DETAIL: 0 index row versions were removed. 514 index pages have been deleted, 514 are currently reusable. CPU 0.00s/0.00u sec elapsed 0.04 sec. INFO: index "maillogsmtpdaccepted_logdate_idx" now contains 0 row versions in 278 pages DETAIL: 0 index row versions were removed. 275 index pages have been deleted, 275 are currently reusable. CPU 0.00s/0.00u sec elapsed 0.02 sec. INFO: index "maillogsmtpdaccepted_mailid_idx" now contains 0 row versions in 356 pages DETAIL: 0 index row versions were removed. 353 index pages have been deleted, 353 are currently reusable. CPU 0.00s/0.00u sec elapsed 0.02 sec. INFO: "maillogsmtpdaccepted": found 0 removable, 0 nonremovable row versions in 0 pages DETAIL: 0 dead row versions cannot be removed yet. There were 0 unused item pointers. 0 pages contain useful free space. 0 pages are entirely empty. CPU 0.00s/0.00u sec elapsed 0.08 sec. INFO: vacuuming "pg_toast.pg_toast_180013" INFO: index "pg_toast_180013_index" now contains 0 row versions in 1 pages DETAIL: 0 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_180013": found 0 removable, 0 nonremovable row versions in 0 pages DETAIL: 0 dead row versions cannot be removed yet. There were 0 unused item pointers. 0 pages contain useful free space. 0 pages are entirely empty. CPU 0.00s/0.00u sec elapsed 0.00 sec. VACUUM sohostingdev=# VACUUM VERBOSE maillogsmtpdrejected; INFO: vacuuming "public.maillogsmtpdrejected" INFO: index "pkmaillogsmtpdrejected" now contains 0 row versions in 6758 pages DETAIL: 0 index row versions were removed. 6753 index pages have been deleted, 6753 are currently reusable. CPU 0.00s/0.00u sec elapsed 0.49 sec. INFO: index "maillogsmtpdrejected_logdate_idx" now contains 0 row versions in 1350 pages DETAIL: 0 index row versions were removed. 1346 index pages have been deleted, 1346 are currently reusable. CPU 0.00s/0.00u sec elapsed 0.08 sec. INFO: "maillogsmtpdrejected": found 0 removable, 0 nonremovable row versions in 0 pages DETAIL: 0 dead row versions cannot be removed yet. There were 0 unused item pointers. 0 pages contain useful free space. 0 pages are entirely empty. CPU 0.00s/0.00u sec elapsed 0.57 sec. INFO: vacuuming "pg_toast.pg_toast_180025" INFO: index "pg_toast_180025_index" now contains 0 row versions in 1 pages DETAIL: 0 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_180025": found 0 removable, 0 nonremovable row versions in 0 pages DETAIL: 0 dead row versions cannot be removed yet. There were 0 unused item pointers. 0 pages contain useful free space. 0 pages are entirely empty. CPU 0.00s/0.00u sec elapsed 0.00 sec. VACUUM sohostingdev=# VACUUM VERBOSE maillogvirtual; INFO: vacuuming "public.maillogvirtual" INFO: index "pkmaillogvirtual" now contains 0 row versions in 345 pages DETAIL: 0 index row versions were removed. 341 index pages have been deleted, 341 are currently reusable. CPU 0.00s/0.00u sec elapsed 0.02 sec. INFO: index "maillogvirtual_logdate_idx" now contains 0 row versions in 108 pages DETAIL: 0 index row versions were removed. 105 index pages have been deleted, 105 are currently reusable. CPU 0.00s/0.00u sec elapsed 0.01 sec. INFO: index "maillogvirtual_mailid_idx" now contains 0 row versions in 136 pages DETAIL: 0 index row versions were removed. 133 index pages have been deleted, 133 are currently reusable. CPU 0.00s/0.00u sec elapsed 0.00 sec. INFO: "maillogvirtual": found 0 removable, 0 nonremovable row versions in 0 pages DETAIL: 0 dead row versions cannot be removed yet. There were 0 unused item pointers. 0 pages contain useful free space. 0 pages are entirely empty. CPU 0.00s/0.00u sec elapsed 0.04 sec. INFO: vacuuming "pg_toast.pg_toast_180036" INFO: index "pg_toast_180036_index" now contains 0 row versions in 1 pages DETAIL: 0 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_180036": found 0 removable, 0 nonremovable row versions in 0 pages DETAIL: 0 dead row versions cannot be removed yet. There were 0 unused item pointers. 0 pages contain useful free space. 0 pages are entirely empty. CPU 0.00s/0.00u sec elapsed 0.00 sec. VACUUM sohostingdev=#
New Paste
Go to most recent paste.