From: Jeff Davis <pgsql@j-davis.com>
To: Greg Smith <gsmith@gregsmith.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: pg_stat_* collection
Date: Thu, 03 May 2007 11:21:30 -0700
Message-ID: <1178216490.28383.277.camel@dogma.v10.wvs> (raw)
In-Reply-To: <Pine.GSO.4.64.0705031039390.12098@westnet.com>
References: <Pine.GSO.4.64.0705031039390.12098@westnet.com>
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
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 using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: pgsql@j-davis.com, gsmith@gregsmith.com
Subject: Re: pg_stat_* collection
In-Reply-To: <1178216490.28383.277.camel@dogma.v10.wvs>
* 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