Re: Obtaining resource usage statistics from execution? (v 9.1) - Mailing list pgsql-performance

From Tom Lane
Subject Re: Obtaining resource usage statistics from execution? (v 9.1)
Date
Msg-id 11217.1331909625@sss.pgh.pa.us
Whole thread Raw
In response to Obtaining resource usage statistics from execution? (v 9.1)  (Karl Denninger <karl@denninger.net>)
Responses Re: Obtaining resource usage statistics from execution? (v 9.1)  (Karl Denninger <karl@denninger.net>)
List pgsql-performance
Karl Denninger <karl@denninger.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

pgsql-performance by date:

Previous
From: Karl Denninger
Date:
Subject: Obtaining resource usage statistics from execution? (v 9.1)
Next
From: "Tomas Vondra"
Date:
Subject: Re: Obtaining resource usage statistics from execution? (v 9.1)