Re: Vacuum statistics

[chirag.dave@xxxxxxxxx]

What version of Postgres you are running ?

If you are using 8.3, you can use pg_stat_all_tables.If Not you can use http://www.postgresql.org/docs/current/static/pgstattuple.html

Chirag

On Tue, Apr 29, 2008 at 8:14 AM, Francisco Reyes <lists@xxxxxxxxxxxxxxxx> wrote:

I recall reading posts in the past where one could query the stat tables and see how well autovacuum was performing. Not finding the posts.


I found this query:
SELECT relname, relkind, reltuples, relpages FROM pg_class where relkind = 'r';