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

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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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:53:45
Message-ID: 11217.1331909625@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
Karl Denninger <karl(at)denninger(dot)net> writes:
> I am trying to continue profiling which in turn feeds query and index
> tuning changes for the AKCS-WWW forum software, and appear to have no
> good way to do what I need to do -- or I've missed something obvious.

Do you really want the application involved in this?  Usually, when
people try to profile a workload, they want everything to just get
logged on the server side.  There are some contrib modules to help
with that approach --- see auto_explain and pg_stat_statements.

			regards, tom lane

In response to

Responses

pgsql-performance by date

Next:From: Tomas VondraDate: 2012-03-16 15:08:25
Subject: Re: Obtaining resource usage statistics from execution? (v 9.1)
Previous:From: Ants AasmaDate: 2012-03-16 14:48:25
Subject: Re: Obtaining resource usage statistics from execution? (v 9.1)

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