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

Re: Obtaining resource usage statistics from execution? (v 9.1)

From: Ants Aasma <ants(at)cybertec(dot)at>
To: Karl Denninger <karl(at)denninger(dot)net>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Obtaining resource usage statistics from execution? (v 9.1)
Date: 2012-03-16 14:48:25
Message-ID: CA+CSw_unGrX3gO13YxcE0ti7kSf8wqtUjf2ssVitk=kZ=sEn-w@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Fri, Mar 16, 2012 at 4:31 PM, Karl Denninger <karl(at)denninger(dot)net> wrote:
> What I'd
> like to be able to do is have the code track performance all the time and
> raise alerts when it sees "outliers" giving me a continually-improving set
> of targets for reduction of resource consumption (up until I reach the point
> where I don't seem to be able to make it any faster of course :-))

Sounds almost exactly like what the auto_explain contrib module is
designed to do:
http://www.postgresql.org/docs/9.1/static/auto-explain.html

It can run with reasonably low overhead if your system has fast
timing. You can check the timing performance of your system with the
tool attached here:
http://archives.postgresql.org/message-id/4F15B930.50108%402ndQuadrant.com

Anything under 200ns should be ok.

Cheers,
Ants Aasma
-- 
Cybertec Schönig & Schönig GmbH
Gröhrmühlgasse 26
A-2700 Wiener Neustadt
Web: http://www.postgresql-support.de

In response to

pgsql-performance by date

Next:From: Tom LaneDate: 2012-03-16 14:53:45
Subject: Re: Obtaining resource usage statistics from execution? (v 9.1)
Previous:From: Karl DenningerDate: 2012-03-16 14:31:57
Subject: Obtaining resource usage statistics from execution? (v 9.1)

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