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

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Jack Xue <jxue(at)regenstrief(dot)org>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Script for getting a table of reponse-time breakdown
Date: 2005-03-25 18:07:13
Message-ID: 200503251007.13520.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Simon Riggs 2005-03-25 18:24:10 Re: Delete query takes exorbitant amount of time
Previous Message Jack Xue 2005-03-25 18:00:06 Re: Script for getting a table of reponse-time breakdown