Aggregate of blocks written to a database

From: "Tim Knowles" <tim(at)ametco(dot)co(dot)uk>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Aggregate of blocks written to a database
Date: 2002-09-24 12:25:24
Message-ID: NGBBIAKALHHLLCHKLBONEEPBCAAA.tim@ametco.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hello All,

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.

Best Regards,

Tim Knowles

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shridhar Daithankar 2002-09-24 12:30:55 Re: Aggregate of blocks written to a database
Previous Message Tim Knowles 2002-09-24 12:25:09 Postmaster Uptime