Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group