> 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;

This is queryable from the system tables, if you don't mind an approximate.  

> and (2) the respond time breakdown for a 
> query.

The what?  You mean EXPLAIN ANALYZE?

> 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).

Life's too short for reading Oracle docs.   Can you just explain, in 
step-by-step detail, what you want?

Josh Berkus
Aglio Database Solutions
San Francisco

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?


Reply via email to