| From: | Karl Denninger <karl(at)denninger(dot)net> |
|---|---|
| To: | Stephen Frost <sfrost(at)snowman(dot)net> |
| Cc: | Rick Otten <rotten(at)manta(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: average query performance measuring |
| Date: | 2012-08-21 19:48:26 |
| Message-ID: | 5033E60A.1030808@denninger.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On 8/21/2012 1:53 PM, Stephen Frost wrote:
> * Rick Otten (rotten(at)manta(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2012-08-21 20:03:38 | Re: Does setval(nextval()+N) generate unique blocks of IDs? |
| Previous Message | Stephen Frost | 2012-08-21 18:53:16 | Re: average query performance measuring |