interpret vacuum verbose output

From: Shankar K <shan0075(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: interpret vacuum verbose output
Date: 2003-06-04 16:45:57
Message-ID: 20030604164557.24757.qmail@web21102.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

hi all,

I'm trying to evaluate the frequecy to run vacuum
analyze on key tables. so if anyone could help me to
interpret the output of vacuum analyze verbose output
that would be great. below is the output of one of our
major indexes.

INFO: --Relation public.accounts--
INFO: Index accounts_u1: Pages 1503; Tuples 231:
Deleted 55448.
CPU 0.01s/0.14u sec elapsed 0.15 sec.
INFO: Index account_u1: Pages 1997; Tuples 231:
Deleted 55448.
CPU 0.01s/0.13u sec elapsed 0.15 sec.
INFO: Index account_u2: Pages 2415; Tuples 231:
Deleted 55448.
CPU 0.00s/0.14u sec elapsed 0.30 sec.
INFO: Removed 55448 tuples in 2367 pages.
CPU 0.04s/0.11u sec elapsed 0.41 sec.
INFO: Pages 11266: Changed 4, Empty 0; Tup 231: Vac
55448, Keep 0, UnUsed 205434.
Total CPU 0.12s/0.56u sec elapsed 1.08 sec.

thanks
Shankar

__________________________________
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Eko Pranoto 2003-06-05 01:04:18 (OOT) test only
Previous Message Jonathan Gardner 2003-06-04 15:24:26 Re: capture vacuumdb verbose output