pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
how 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