Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Xm2gR-0006wD-Nt for pgsql-admin@arkaria.postgresql.org; Wed, 05 Nov 2014 15:39:43 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Xm2gQ-0000Ka-Hq for pgsql-admin@arkaria.postgresql.org; Wed, 05 Nov 2014 15:39:42 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1Xm2gP-0000KT-FY for pgsql-admin@postgresql.org; Wed, 05 Nov 2014 15:39:41 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1Xm2gM-0003sO-I8 for pgsql-admin@postgresql.org; Wed, 05 Nov 2014 15:39:39 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id sA5Fdair003375; Wed, 5 Nov 2014 10:39:36 -0500 From: Tom Lane To: "Campbell, Lance" cc: "pgsql-admin@postgresql.org" Subject: Re: Possible request for new feature In-reply-to: References: Comments: In-reply-to "Campbell, Lance" message dated "Wed, 05 Nov 2014 15:25:49 +0000" Date: Wed, 05 Nov 2014 10:39:36 -0500 Message-ID: <3374.1415201976@sss.pgh.pa.us> X-Pg-Spam-Score: -2.5 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org "Campbell, Lance" writes: > I develop web application for the University of Illinois. We use PostgreSQL on the backend to provide our web application with data for around 3 million pages of dynamic web content per month. A nice feature would be the ability to do something just like EXPLAIN ANALYZE on queries with the slight difference of actually returning the results from the query and appending the QUERY PLAN to the end of the query. Such a behavior would break just about every client application. Have you looked into using the auto_explain module, which instead logs query plans to the postmaster log? That's a far less invasive way of collecting plans for queries of live applications. pg_stat_statements would be worth a look too. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin