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

Re: average query performance measuring

From: Peter Geoghegan <peter(at)2ndquadrant(dot)com>
To: Tomas Vondra <tv(at)fuzzy(dot)cz>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: average query performance measuring
Date: 2012-08-21 21:51:12
Message-ID: CAEYLb_WCpm1LAaJaxrz8gx9pT1ggXsO0Tv733wyKo_CBCjxxXQ@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On 21 August 2012 22:08, Tomas Vondra <tv(at)fuzzy(dot)cz> 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 monitor query
execution costs on earlier versions, I think that I'll probably have
new information about that for my talk at Postgres Open.

-- 
Peter Geoghegan       http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training and Services


In response to

pgsql-performance by date

Next:From: Matt DawDate: 2012-08-21 22:57:13
Subject: Performance of Seq Scan from buffer cache
Previous:From: Tomas VondraDate: 2012-08-21 21:08:09
Subject: Re: average query performance measuring

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