Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TkWtT-000622-KA for pgsql-performance@arkaria.postgresql.org; Mon, 17 Dec 2012 09:21:51 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1TkWtT-00017n-4m for pgsql-performance@arkaria.postgresql.org; Mon, 17 Dec 2012 09:21:51 +0000 Received: from magus.postgresql.org ([87.238.57.229]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TkWtS-00017i-Cy for pgsql-performance@postgresql.org; Mon, 17 Dec 2012 09:21:50 +0000 Received: from sam.nabble.com ([216.139.236.26]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TkWtN-0003O4-KF for pgsql-performance@postgresql.org; Mon, 17 Dec 2012 09:21:50 +0000 Received: from [192.168.236.26] (helo=sam.nabble.com) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1TkWtL-0001fv-LH for pgsql-performance@postgresql.org; Mon, 17 Dec 2012 01:21:43 -0800 Date: Mon, 17 Dec 2012 01:21:43 -0800 (PST) From: "suhas.basavaraj12" To: pgsql-performance@postgresql.org Message-ID: <1355736103646-5736865.post@n5.nabble.com> In-Reply-To: <1355731390542-5736854.post@n5.nabble.com> References: <1355731390542-5736854.post@n5.nabble.com> Subject: Re: How can i find out top high load sql queries in PostgreSQL. MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -0.8 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org There is a tool called pg Fouine . I am sure this will help you.. http://pgfouine.projects.pgfoundry.org/tutorial.html Rgrds Suhas -- View this message in context: http://postgresql.1045698.n5.nabble.com/How-can-i-find-out-top-high-load-sql-queries-in-PostgreSQL-tp5736854p5736865.html Sent from the PostgreSQL - performance mailing list archive at Nabble.com. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance