pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedhow to tell what tables have been vacuumed ?
3+ messages / 2 participants
[nested] [flat]
* how to tell what tables have been vacuumed ?
@ 2007-08-28 03:33 Kevin Kempter <kevin@kevinkempterllc.com>
0 siblings, 1 reply; 3+ messages in thread
From: Kevin Kempter @ 2007-08-28 03:33 UTC (permalink / raw)
To: pgsql-admin
Hi List;
How do I check to see which tables have been vacuumed recently and when they
were last vacuumed?
Thanks in advance...
/Kevin
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: how to tell what tables have been vacuumed ?
@ 2007-08-28 03:44 Tom Lane <tgl@sss.pgh.pa.us>
parent: Kevin Kempter <kevin@kevinkempterllc.com>
0 siblings, 1 reply; 3+ messages in thread
From: Tom Lane @ 2007-08-28 03:44 UTC (permalink / raw)
To: Kevin Kempter <kevin@kevinkempterllc.com>; +Cc: pgsql-admin
Kevin Kempter <kevin@kevinkempterllc.com> writes:
> How do I check to see which tables have been vacuumed recently and when they
> were last vacuumed?
As of 8.2, there are columns about this in the pg_stat views, assuming
you have the right stats collection options turned on.
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: how to tell what tables have been vacuumed ?
@ 2007-08-28 03:52 Kevin Kempter <kevin@kevinkempterllc.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 3+ messages in thread
From: Kevin Kempter @ 2007-08-28 03:52 UTC (permalink / raw)
To: pgsql-admin
On Monday 27 August 2007 21:44:29 Tom Lane wrote:
> Kevin Kempter <kevin@kevinkempterllc.com> writes:
> > How do I check to see which tables have been vacuumed recently and when
> > they were last vacuumed?
>
> As of 8.2, there are columns about this in the pg_stat views, assuming
> you have the right stats collection options turned on.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
Anything in the system catalogs in 8.1.4 ? (we're moving to 8.2.4 soon)
Thanks
/Kevin
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2007-08-28 03:52 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-08-28 03:33 how to tell what tables have been vacuumed ? Kevin Kempter <kevin@kevinkempterllc.com>
2007-08-28 03:44 ` Tom Lane <tgl@sss.pgh.pa.us>
2007-08-28 03:52 ` Kevin Kempter <kevin@kevinkempterllc.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox