5:08 PM
To: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] average query performance measuring
On 21.8.2012 20:35, Rick Otten wrote:
> I have a PostgreSQL 9.1 cluster. Each node is serving around 1,000
> queries per second when we are at a 'steady state'.
>
> W
On 21 August 2012 22:08, Tomas Vondra wrote:
> As others already mentioned, the improvements in pg_stat_statements by
> Peter Geoghean in 9.2 is the first thing you should look into I guess.
> Especially if you're looking for per-query stats.
If people would like to know about a better way to mon
On 21.8.2012 20:35, Rick Otten wrote:
> I have a PostgreSQL 9.1 cluster. Each node is serving around 1,000
> queries per second when we are at a ‘steady state’.
>
> What I’d like to know is the average query time. I’d like to see if
> query performance is consistent, or if environmental changes,
Karl,
* Karl Denninger (k...@denninger.net) wrote:
> 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 sin
On 8/21/2012 1:53 PM, Stephen Frost wrote:
> * Rick Otten (rot...@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 tim
* Rick Otten (rot...@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
I have a PostgreSQL 9.1 cluster. Each node is serving around 1,000 queries per
second when we are at a 'steady state'.
What I'd like to know is the average query time. I'd like to see if query
performance is consistent, or if environmental changes, or code releases, are
causing it to drift, s
