pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedVacuum statistics
4+ messages / 3 participants
[nested] [flat]
* Vacuum statistics
@ 2008-04-29 12:14 Francisco Reyes <lists@stringsutils.com>
0 siblings, 1 reply; 4+ messages in thread
From: Francisco Reyes @ 2008-04-29 12:14 UTC (permalink / raw)
To: pgsql-performance
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';
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Vacuum statistics
@ 2008-05-02 14:09 chirag.dave@gmail.com
parent: Francisco Reyes <lists@stringsutils.com>
0 siblings, 1 reply; 4+ messages in thread
From: chirag.dave@gmail.com @ 2008-05-02 14:09 UTC (permalink / raw)
To: Francisco Reyes <lists@stringsutils.com>; +Cc: pgsql-performance
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
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Vacuum statistics
@ 2008-05-04 02:15 Francisco Reyes <lists@stringsutils.com>
parent: chirag.dave@gmail.com
0 siblings, 1 reply; 4+ messages in thread
From: Francisco Reyes @ 2008-05-04 02:15 UTC (permalink / raw)
To: chirag.dave@gmail.com; +Cc: pgsql-performance
chirag.dave@gmail.com writes:
> What version of Postgres you are running ?
8.2
> If you are using 8.3, you can use pg_stat_all_tables.If Not you can use
> <URL:http://www.postgresql.org/docs/current/static/pgstattuple.html>http://
> www.postgresql.org/docs/current/static/pgstattuple.html
pgstattuple is also a 8.3 function. Anything simmilar to it in 8.2?
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Vacuum statistics
@ 2008-05-04 04:43 Mark Kirkwood <markir@paradise.net.nz>
parent: Francisco Reyes <lists@stringsutils.com>
0 siblings, 0 replies; 4+ messages in thread
From: Mark Kirkwood @ 2008-05-04 04:43 UTC (permalink / raw)
To: Francisco Reyes <lists@stringsutils.com>; +Cc: pgsql-performance
Francisco Reyes wrote:
> chirag.dave@gmail.com writes:
>
>> What version of Postgres you are running ?
>
> 8.2
>
>> If you are using 8.3, you can use pg_stat_all_tables.If Not you can
>> use
>> <URL:http://www.postgresql.org/docs/current/static/pgstattuple.html>http://
>> www.postgresql.org/docs/current/static/pgstattuple.html
>
> pgstattuple is also a 8.3 function. Anything simmilar to it in 8.2?
>
It is available as a contrib module in 8.2, but needs to be installed
(see contrib/pgstattuple).
regards
Mark
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2008-05-04 04:43 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-04-29 12:14 Vacuum statistics Francisco Reyes <lists@stringsutils.com>
2008-05-02 14:09 ` chirag.dave@gmail.com
2008-05-04 02:15 ` Francisco Reyes <lists@stringsutils.com>
2008-05-04 04:43 ` Mark Kirkwood <markir@paradise.net.nz>
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