Postgres Pro
Downloads
Home   >   mailing lists

Script for getting a table of reponse-time breakdown - Mailing list pgsql-performance

From Jack Xue
Subject Script for getting a table of reponse-time breakdown
Date
Msg-id 1111763525.18036.15.camel@localhost.localdomain
Whole thread Raw
In response to PostgreSQL on Solaris 8 and ufs  ("Brandon Metcalf" <bmetcalf@nortel.com>)
Responses Re: Script for getting a table of reponse-time breakdown
List pgsql-performance
Tree view 
Hi,

I am thinking about how to continuously monitor the performance of a
PostgreSQL 8 database. I am interested in two things: (1) the growth of
tables with TOAST and indexes; and (2) the respond time breakdown for a
query.

In Chapters 23 and 24 of the big manual, I found enough materials to
teach me how to do the 1st job. But I have difficulty with the 2nd one.
I found some script for Oracle
(http://www.ixora.com.au/scripts/waits.htm).

Do we have something that can do the same job for PostgreSQL 8?

Thanks.

-Jack

pgsql-performance by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Delete query takes exorbitant amount of time
Next
From: Tom Lane
Date:
Subject: Re: Delete query takes exorbitant amount of time