Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 84BB51337BC1 for ; Mon, 6 Dec 2010 16:04:10 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 81687-03-5 for ; Mon, 6 Dec 2010 20:04:04 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from nrccenhts1.nrc.ca (nrccenhts1.nrc.ca [132.246.15.88]) by mail.postgresql.org (Postfix) with ESMTP id D828A1337BF6 for ; Mon, 6 Dec 2010 16:04:02 -0400 (AST) Received: from NRCWSTHCM1.NRC.CA (132.246.216.66) by nrccenhts1.nrc.ca (132.246.15.88) with Microsoft SMTP Server (TLS) id 8.1.436.0; Mon, 6 Dec 2010 15:04:00 -0500 Received: from [132.246.194.17] (132.246.216.202) by WSTMAIL.NRC.CA (132.246.216.66) with Microsoft SMTP Server (TLS) id 8.1.436.0; Mon, 6 Dec 2010 12:03:59 -0800 Message-ID: <4CFD41AE.2040303@nrc-cnrc.gc.ca> Date: Mon, 6 Dec 2010 12:03:58 -0800 From: Isabella Ghiurea Reply-To: isabella.ghiurea@nrc-cnrc.gc.ca Organization: CADC -NRC User-Agent: Thunderbird 2.0.0.19 (X11/20090105) MIME-Version: 1.0 To: "pgsql-admin@postgresql.org" Subject: monitor SQL activity in db Content-Type: text/plain; charset="ISO-8859-1"; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.001 tagged_above=-10 required=5 tests=BAYES_20=-0.001 X-Spam-Level: X-Archive-Number: 201012/47 X-Sequence-Number: 36276 Hi Gurus, I'm running PG 9.0.1 and have some issues with some SQL, I would like to know if are other system views/tables beside the pg_stat_activity from where I can get details about a running transactions / SQL at given time. Thank you Isabella -- ----------------------------------------------------------- Isabella A. Ghiurea Isabella.Ghiurea@nrc-cnrc.gc.ca Canadian Astronomy Data Centre |http://www.nrc-cnrc.gc.ca/eng/services/hia/data-centre.html National Research Council of Canada, Herzberg Institute of Astrophysics 5071 West Saanich Road, Victoria BC V9E 2E7, Canada Phone: 250 363-3446 fax: 250 363-0045