Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id E06162E2F84 for ; Sun, 16 Dec 2007 19:57:14 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 92166-01-5 for ; Sun, 16 Dec 2007 19:57:12 -0400 (AST) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 83E502E322C for ; Sun, 16 Dec 2007 19:57:11 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id lBGNv7Lh000736; Sun, 16 Dec 2007 18:57:07 -0500 (EST) To: "Usama Dar" cc: "Tena Sakai" , "Scott Marlowe" , pgsql-admin@postgresql.org Subject: Re: reading pg_stat_activity view In-reply-to: References: Comments: In-reply-to "Usama Dar" message dated "Mon, 17 Dec 2007 00:37:19 +0500" Date: Sun, 16 Dec 2007 18:57:07 -0500 Message-ID: <735.1197849427@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/133 X-Sequence-Number: 27650 "Usama Dar" writes: > I think it will be a useful feature to add to postgres, for the benefit of > DBAs, the ability to log slow queries, the queries which take more than x > amount of time, maybe in a separate slow query log. i am sure it sounds > familiar to a lot of people ;) See log_min_duration_statement regards, tom lane