Postgres Pro
Downloads
Home   >   mailing lists

Aggregate of blocks written to a database - Mailing list pgsql-general

From Tim Knowles
Subject Aggregate of blocks written to a database
Date
Msg-id NGBBIAKALHHLLCHKLBONEEPBCAAA.tim@ametco.co.uk
Whole thread Raw
Responses Re: Aggregate of blocks written to a database  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Tim Knowles"
Date:
Subject: Postmaster Uptime
Next
From: "Shridhar Daithankar"
Date:
Subject: Re: Aggregate of blocks written to a database