autovacuum check

We are using postgres 8.4.x on a few boxes.

Is there a way to check if autovac vacuumed a particular table?

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Anj Adu [ Mi, 18 August 2010 17:30 ] [ ID #2046256 ]

Re: autovacuum check

See pg_stat_user_tables table.

--
Devrim G=C3=9CND=C3=9CZ
PostgreSQL DBA [at] Akinon/Markafoni, Red Hat Certified Engineer
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz

18.A=C4=9Fu.2010 tarihinde 18:30 saatinde, Anj Adu <fotographs [at] gmail.com>=

=C5=9Funlar=C4=B1 yazd=C4=B1:

> We are using postgres 8.4.x on a few boxes.
>
> Is there a way to check if autovac vacuumed a particular table?
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
devrim [ Mi, 18 August 2010 17:50 ] [ ID #2046257 ]

Re: autovacuum check

Thanks..all the info is present in the table

2010/8/18 Devrim G=C3=9CND=C3=9CZ <devrim [at] gunduz.org>:
> See pg_stat_user_tables table.
>
> --
> Devrim G=C3=9CND=C3=9CZ
> PostgreSQL DBA [at] Akinon/Markafoni, Red Hat Certified Engineer
> devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
> http://www.gunduz.org =C2=A0Twitter: http://twitter.com/devrimgunduz
>
> 18.A=C4=9Fu.2010 tarihinde 18:30 saatinde, Anj Adu <fotographs [at] gmail.com>=
=C5=9Funlar=C4=B1
> yazd=C4=B1:
>
>> We are using postgres 8.4.x on a few boxes.
>>
>> Is there a way to check if autovac vacuumed a particular table?
>>
>> --
>> Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-admin
>

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Anj Adu [ Mi, 18 August 2010 18:18 ] [ ID #2046258 ]
Datenbanken » gmane.comp.db.postgresql.admin » autovacuum check

Vorheriges Thema: query fine in psql/pgAdmin III but error message when within plpgsqlfunction
Nächstes Thema: Error: missing chunk number for toast value