Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 934369FB7AF; Wed, 21 Mar 2007 18:49:52 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 69576-01-4; Wed, 21 Mar 2007 18:49:48 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from bay0-omc3-s8.bay0.hotmail.com (bay0-omc3-s8.bay0.hotmail.com [65.54.246.208]) by postgresql.org (Postfix) with ESMTP id B86CE9FB72C; Wed, 21 Mar 2007 18:49:47 -0300 (ADT) Received: from hotmail.com ([65.55.136.96]) by bay0-omc3-s8.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.2668); Wed, 21 Mar 2007 14:49:46 -0700 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Wed, 21 Mar 2007 14:49:46 -0700 Message-ID: Received: from 65.55.136.123 by by131fd.bay131.hotmail.msn.com with HTTP; Wed, 21 Mar 2007 21:49:43 GMT X-Originating-IP: [67.116.31.14] X-Originating-Email: [skarthi98@hotmail.com] X-Sender: skarthi98@hotmail.com In-Reply-To: From: "Karthikeyan Sundaram" To: pgsql-admin@postgresql.org, pgsql-sql@postgresql.org Subject: Monitor what command is executing at the backend Date: Wed, 21 Mar 2007 14:49:43 -0700 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 21 Mar 2007 21:49:46.0130 (UTC) FILETIME=[D74E0F20:01C76C02] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.514 tagged_above=0 required=5 tests=AWL, BAYES_20, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, MSGID_FROM_MTA_HEADER, SPF_PASS X-Spam-Level: X-Archive-Number: 200703/152 X-Sequence-Number: 24976 Hi everybody, Is there a way to see from the log files on what sql statement is currently by which user? In other words, I want to monitor the DB activity. How can I find it? Regards skarthi _________________________________________________________________ Get a FREE Web site, company branded e-mail and more from Microsoft Office Live! http://clk.atdmt.com/MRT/go/mcrssaub0050001411mrt/direct/01/