Pastebin

Paste #1699: pgsql vacuum vebose

< previous paste - next paste>

Pasted by tdn

Download View as text

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


Do not write anything in this field if you're a human.

Go to most recent paste.