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 1070C52900 for ; Mon, 15 Aug 2005 22:33:09 -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 94312-04 for ; Tue, 16 Aug 2005 01:33:07 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 2F2BB5287C for ; Mon, 15 Aug 2005 22:33:06 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j7G1XAcP020101; Mon, 15 Aug 2005 21:33:10 -0400 (EDT) To: Chris Hoover Cc: pgsql-admin@postgresql.org Subject: Re: Any way to see what queries are currently running? In-reply-to: <1d219a6f05081513546f6458b6@mail.gmail.com> References: <1d219a6f05081513546f6458b6@mail.gmail.com> Comments: In-reply-to Chris Hoover message dated "Mon, 15 Aug 2005 16:54:20 -0400" Date: Mon, 15 Aug 2005 21:33:10 -0400 Message-ID: <20100.1124155990@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 required=5 tests=[AWL=0.006] X-Spam-Level: X-Archive-Number: 200508/187 X-Sequence-Number: 18506 Chris Hoover writes: > 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. > I am only getting the select clause (and I'm not sure if it's all of > it) but no from or where clause. That seems exceedingly improbable. Are you sure you are reading the log correctly? If the source queries are formatted as multiple lines, the log output will be broken across lines too ... regards, tom lane