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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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