Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 80EB0131F6D3 for ; Fri, 16 Mar 2012 11:54:05 -0300 (ADT) Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1S8YXc-0008CI-5U for pgsql-performance@postgresql.org; Fri, 16 Mar 2012 14:54:05 +0000 Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id q2GErj3C011218; Fri, 16 Mar 2012 10:53:45 -0400 (EDT) To: Karl Denninger cc: "pgsql-performance@postgresql.org" Subject: Re: Obtaining resource usage statistics from execution? (v 9.1) In-reply-to: <4F634EDD.2090802@denninger.net> References: <4F634EDD.2090802@denninger.net> Comments: In-reply-to Karl Denninger message dated "Fri, 16 Mar 2012 09:31:57 -0500" Date: Fri, 16 Mar 2012 10:53:45 -0400 Message-ID: <11217.1331909625@sss.pgh.pa.us> From: Tom Lane X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201203/112 X-Sequence-Number: 46562 Karl Denninger 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