From: chirag.dave@gmail.com
To: Francisco Reyes <lists@stringsutils.com>
Cc: Pgsql performance <pgsql-performance@postgresql.org>
Subject: Re: Vacuum statistics
Date: Fri, 2 May 2008 10:09:49 -0400
Message-ID: <f1d4f3170805020709r378df971y7dc46490a4c7776d@mail.gmail.com> (raw)
In-Reply-To: <cone.1209471294.326545.71868.1000@zoraida.natserv.net>
References: <cone.1209471294.326545.71868.1000@zoraida.natserv.net>
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@stringsutils.com>
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';
>
> From the output how can I tell the number of dead tuples? Or how effective
> autovacuum is in the particular table..
>
> Recently inheritted several large Postgresql DBs (tables in the hundreds
> of millions and some tables over a billion rows) and I am just starting to
> go over them and see how autovacuum has been performing.
>
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: chirag.dave@gmail.com, lists@stringsutils.com
Subject: Re: Vacuum statistics
In-Reply-To: <f1d4f3170805020709r378df971y7dc46490a4c7776d@mail.gmail.com>
References: <cone.1209471294.326545.71868.1000@zoraida.natserv.net> <f1d4f3170805020709r378df971y7dc46490a4c7776d@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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