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

From Josh Berkus
Subject Re: Script for getting a table of reponse-time breakdown
Date
Msg-id 200503251007.13520.josh@agliodbs.com
Whole thread Raw
In response to Re: Script for getting a table of reponse-time breakdown  (Jack Xue <jxue@regenstrief.org>)
List pgsql-performance
Jack,

> 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 broken down further into sub-categories,
> and the component wait events are shown.

This would be very nice.  And very, very hard to build.

No, we don't have anything similar.  You can, of course, use profiling tools.

--
Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-performance by date:

Previous
From: Jack Xue
Date:
Subject: Re: Script for getting a table of reponse-time breakdown
Next
From: "Otto Blomqvist"
Date:
Subject: Re: pg_autovacuum not having enough suction ?