Re: Vacuum explained - Mailing list pgsql-admin

From Robert Treat
Subject Re: Vacuum explained
Date
Msg-id 1041884632.15455.112.camel@camel
Whole thread Raw
In response to Vacuum explained  ("Gaetano Mendola" <mendola@bigfoot.com>)
Responses Re: Vacuum explained  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
This is a rough description, should anyone see a need to correct it
please do so.

On Sat, 2003-01-04 at 09:42, Gaetano Mendola wrote:
> NOTICE:  Pages 2518: Changed 38, Empty 0; Tup 75489: Vac 447, Keep 68661,
> UnUsed 144574.
>         Total CPU 1.31s/0.25u sec elapsed 48.23 sec.

Pages = the # of pages being used to store your data.

Changed = the # of pages that have been modified as a result of your
most recent vacuum.

Empty = pages containing no "live" tuples

Tup = # of "rows" in your table

Vac = # of dead tuples recovered

Keep = # of tuples that the db did not feel it could safely mark/remove
(probably envolved in some type of transaction)

Unused = # of tuples awaiting being reused

elapsed time is the amount of time it took to deal with the given table

Robert Treat



pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: restore/dup OIDs HELP!
Next
From: Robert Treat
Date:
Subject: Re: Get client's IP