| From: | "Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Aggregate of blocks written to a database |
| Date: | 2002-09-24 12:30:55 |
| Message-ID: | 3D90A857.30014.9C4B2C5@localhost |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 24 Sep 2002 at 13:25, Tim Knowles wrote:
> I'm trying to profile the performance/usage of my PostgreSQL system and I'm
> wondering if their is an easy way to find out the numbers of blocks being
> received (inserts/updates) by the postmaster for each database. I've
> written a view which generates this info using the table based pg_stat
> functions e.g. pg_stat_get_tuples_inserted, but I was hoping their may be
> an easier way. Any pointers greatly appreciated.
That's already done in PG metadata in view pg_stat_qll_tables. Check PG
metadata documentation. There are lot of things that one can discover in
there..
HTH
Bye
Shridhar
--
fenderberg, n.: The large glacial deposits that form on the insides of car
fenders during snowstorms. -- "Sniglets", Rich Hall & Friends
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tourtounis Sotiris | 2002-09-24 12:56:25 | Number of disk pages obtained by explain analyze |
| Previous Message | Tim Knowles | 2002-09-24 12:25:24 | Aggregate of blocks written to a database |