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 91D2552EC4 for ; Mon, 15 Aug 2005 17:54:21 -0300 (ADT) 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 22985-03 for ; Mon, 15 Aug 2005 20:54:20 +0000 (GMT) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.195]) by svr1.postgresql.org (Postfix) with ESMTP id C677F52EDE for ; Mon, 15 Aug 2005 17:54:18 -0300 (ADT) Received: by zproxy.gmail.com with SMTP id 8so727565nzo for ; Mon, 15 Aug 2005 13:54:21 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=IpaleB+53j9Hb8qn5UW/Q0nzwo5D4+Nl9WxCRkx9bNLAKkBL1EzGWvuyWZH2wSX+OF4bRa/WbXZVKxJ8Qmy/GQsXWumrO6uKUeR18ouZ6T1lRoyJwWPAPtXNHEmXNnodHl6D+vVz79PP0D2QxyPlEYgIyDHuSJETK6LE/4eF07I= Received: by 10.36.216.6 with SMTP id o6mr577234nzg; Mon, 15 Aug 2005 13:54:20 -0700 (PDT) Received: by 10.36.24.2 with HTTP; Mon, 15 Aug 2005 13:54:20 -0700 (PDT) Message-ID: <1d219a6f05081513546f6458b6@mail.gmail.com> Date: Mon, 15 Aug 2005 16:54:20 -0400 From: Chris Hoover To: pgsql-admin@postgresql.org Subject: Any way to see what queries are currently running? Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.024 required=5 tests=[RCVD_BY_IP=0.024] X-Spam-Level: X-Archive-Number: 200508/184 X-Sequence-Number: 18503 I'm running 7.3.4. Is there anyway to see the actual sql being run by the database via a query? I am having some problems with long running load causing querires from our reporting system. I have sql logging turned on to log the sql statements to my postgres.log file. However, these reporting queries do not appear to be logging the entire query.=20 I am only getting the select clause (and I'm not sure if it's all of it) but no from or where clause. Can I pull these queries out from postgres? Thanks, Chris