|
On 8/21/2012 1:53 PM, Stephen Frost
wrote:
* Rick Otten (rotten@xxxxxxxxx) 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.) |
Attachment:
signature.asc
Description: OpenPGP digital signature
