| From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
|---|---|
| To: | Gaetano Mendola <mendola(at)bigfoot(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Vacuum explained |
| Date: | 2003-01-06 20:23:52 |
| Message-ID: | 1041884632.15455.112.camel@camel |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Treat | 2003-01-06 20:27:32 | Re: Get client's IP |
| Previous Message | Tom Lane | 2003-01-06 19:56:54 | Re: restore/dup OIDs HELP! |