X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 53830533BD for ; Tue, 29 Mar 2005 16:06:38 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 78500-10 for ; Tue, 29 Mar 2005 15:06:29 +0000 (GMT) Received: from mailhub1.sghms.ac.uk (mailhub1.sghms.ac.uk [194.82.51.7]) by svr1.postgresql.org (Postfix) with ESMTP id 1435C533DF for ; Tue, 29 Mar 2005 16:06:28 +0100 (BST) Received: from [194.82.51.24] (helo=imail) by mailhub1.sghms.ac.uk with esmtp (Exim 4.24) id 1DGIIV-0001VA-AD for pgsql-admin@postgresql.org; Tue, 29 Mar 2005 16:06:27 +0100 Received: from [172.16.20.3] (mrc1-003.sghms.ac.uk [172.16.20.3]) by imail.sghms.ac.uk (iPlanet Messaging Server 5.2 Patch 2 (built Jul 14 2004)) with ESMTPA id <0IE400KA0CMRRC@imail.sghms.ac.uk> for pgsql-admin@postgresql.org; Tue, 29 Mar 2005 16:06:27 +0100 (BST) Date: Tue, 29 Mar 2005 16:03:01 +0100 From: Adam Witney Subject: Determine current running query, but no query in pg_stat_activity To: pgsql-admin Message-id: MIME-version: 1.0 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT User-Agent: Microsoft-Entourage/10.1.1.2418 X-MailScanner-Information: Please contact sysadmin at sghms.ac.uk for more information X-MailScanner-MH1: No virueses detected X-MailScanner-SpamCheck: not spam, SpamAssassin (score=-2.099, required 5, BAYES_00 -2.60, MY_NO_QU 0.50) X-MailScanner-From: awitney@sghms.ac.uk X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200503/461 X-Sequence-Number: 16959 Hi, I have a process running and I am trying to work out what it is doing. Supposedly it is running a SELECT 23093 ? R 6:35 postgres: lubrook bugasbase SELECT However in pg_stat_activity, I get no current_query bugasbase=# SELECT * from pg_stat_activity ; datid | datname | procpid | usesysid | usename | current_query | query_start ----------+-----------+---------+----------+---------+---------------+------ ------- 80573819 | bugasbase | 23117 | 1 | pgsql | | 80573819 | bugasbase | 23093 | 109 | lubrook | | Shouldn't there be something in current_query? Thanks for any advice Adam -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.