Re: pg_stat_* collection - Mailing list pgsql-performance

From Jeff Davis
Subject Re: pg_stat_* collection
Date
Msg-id 1178216490.28383.277.camel@dogma.v10.wvs
Whole thread Raw
In response to pg_stat_* collection  (Greg Smith <gsmith@gregsmith.com>)
List pgsql-performance
On Thu, 2007-05-03 at 10:45 -0400, Greg Smith wrote:
> Today's survey is:  just what are *you* doing to collect up the
> information about your system made available by the various pg_stat views?
> I have this hacked together script that dumps them into a file, imports
> them into another database, and then queries against some of the more
> interesting data.  You would thing there would be an organized project
> addressing this need around to keep everyone from reinventing that wheel,
> but I'm not aware of one.
>

Is anyone out there collecting their own statistics? What's the easiest
way to take statistical samples of the data in a table without reading
the entire thing?

Regards,
    Jeff Davis


pgsql-performance by date:

Previous
From: Tobias Brox
Date:
Subject: Re: pg_stat_* collection
Next
From: Ron
Date:
Subject: Re: Feature Request --- was: PostgreSQL Performance Tuning