Re: [PERFORM] Script for getting a table of reponse-time breakdown

2005-03-25 Thread Jack Xue
Josh, The description of the Oracle script is: This script can be used to focus tuning attention on the most important issues. It reports a breakdown of total foreground response time into four major categories: CPU usage, disk I/O, resource waits, and routine latencies. These categories are brok

[PERFORM] Script for getting a table of reponse-time breakdown

2005-03-25 Thread Jack Xue
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 teac