From: Karl Denninger <karl@denninger.net>
To: Stephen Frost <sfrost@snowman.net>
Cc: Rick Otten <rotten@manta.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: average query performance measuring
Date: Tue, 21 Aug 2012 14:48:26 -0500
Message-ID: <5033E60A.1030808@denninger.net> (raw)
In-Reply-To: <20120821185316.GN1267@tamriel.snowman.net>
References: <362605510214004CB3313A03D3D697DE5508FF27@cmhvm005>
<20120821185316.GN1267@tamriel.snowman.net>
On 8/21/2012 1:53 PM, Stephen Frost wrote:
> * Rick Otten (rotten@manta.com) wrote:
>> It seems like we almost have everything we need to track this in the stats tables, but not quite. I was hoping the folks on this list would have some tips on how to get query performance trends over time out of each node in my cluster.
> I'm afraid the best answer to this is, honestly, "upgrade to 9.2 once
> it's out"..
>
> http://pgeoghegan.blogspot.com/2012/03/much-improved-statement-statistics.html
>
> If what's described there doesn't match what you're looking for, then
> please let us know what else you'd like, so we can further improve
> things in that area..
>
> Thanks,
>
> Stephen
That looks EXTREMELY useful and I'm looking forward to checking it out
in 9.2; I have asked a similar question about profiling actual queries
in the past and basically it came down to "turn on explain or run a
separate explain yourself since the app knows what's similar and what's
not", which of course has hideous performance implications (as the query
basically executes twice.)
--
-- Karl Denninger
/The Market Ticker ®/ <http://market-ticker.org;
Cuda Systems LLC
Attachments:
signature.asc (application/pgp-signature, 550B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: karl@denninger.net, sfrost@snowman.net, rotten@manta.com
Subject: Re: average query performance measuring
In-Reply-To: <5033E60A.1030808@denninger.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox