Vacuum Verbose output

From: "Subbiah, Stalin" <SSubbiah(at)netopia(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Vacuum Verbose output
Date: 2005-10-31 20:13:27
Message-ID: 6B26A56846293C4488B54CF3E440335403E2F77A@mxca2.corp.netopia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi All,

We vacuum busy tables in different frequencies depending on how busy the
table is. Today I noticed that one of the task that was suppose to
delete rows from a busy table was running for a long time. And below is
the output of vacuum verbose after the task was stopped from running.
Trying to understand if the table/index has been bloated or not.

INFO: vacuuming "public.eventlog"
INFO: index "ix_eventlog_eventtime" now contains 11465395 row versions
in 77113 pages
DETAIL: 8737797 index row versions were removed.

Does it mean ix_eventlog_ index had 11.4mil row versions out of which
8.7mil were removed cause of deletes?

33189 index pages have been deleted, 0 are currently reusable.

Does it mean out of 77113 index pages, 33189 were deleted?

CPU 5.24s/13.76u sec elapsed 67.05 sec.

INFO: "eventlog": removed 8737797 row versions in 361856 pages
DETAIL: CPU 14.53s/22.00u sec elapsed 122.13 sec.
INFO: index "ix_eventlog_eventtime" now contains 8023399 row versions
in 77116 pages
DETAIL: 3442698 index row versions were removed.
46439 index pages have been deleted, 0 are currently reusable.
CPU 3.18s/5.35u sec elapsed 22.85 sec.
INFO: "eventlog": removed 3442698 row versions in 143144 pages
DETAIL: CPU 5.64s/8.74u sec elapsed 69.15 sec.
INFO: "eventlog": found 12180495 removable, 8022620 nonremovable row
versions in 837938 pages
DETAIL: 0 dead row versions cannot be removed yet.

There were 154716 unused item pointers.
0 pages are entirely empty.
CPU 44.37s/54.07u sec elapsed 357.04 sec.

Why does index and table INFO reported twice with different row version
numbers on a vacuum run.

Thanks,
Subbiah
Postgres v7.4.7

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2005-10-31 21:22:59 Re: Vacuum Verbose output
Previous Message Ng Pheng Siong 2005-10-31 18:02:34 filesystem permissions and security