Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 19EF42E0052 for ; Wed, 7 May 2008 11:51:50 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 23408-04 for ; Wed, 7 May 2008 11:51:27 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from n6.bullet.re3.yahoo.com (n6.bullet.re3.yahoo.com [68.142.237.91]) by developer.postgresql.org (Postfix) with SMTP id 67A942E004B for ; Wed, 7 May 2008 11:51:35 -0300 (ADT) Received: from [68.142.237.89] by n6.bullet.re3.yahoo.com with NNFMP; 07 May 2008 14:51:33 -0000 Received: from [66.196.97.146] by t5.bullet.re3.yahoo.com with NNFMP; 07 May 2008 14:51:33 -0000 Received: from [127.0.0.1] by omp204.mail.re3.yahoo.com with NNFMP; 07 May 2008 14:51:33 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 713791.349.bm@omp204.mail.re3.yahoo.com Received: (qmail 51519 invoked by uid 60001); 7 May 2008 14:51:31 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Message-ID; b=NY/RMKXqdC2944HlxV5AOumfEikUETakwJdIpUWy69zapkBFOfcNT+ea2XQDR4c0FbFcnbOvABV4XWCS1IZzXbjZfGmx212pd3+MXGKdrrcuSHc91eImo6kvJ4dohCgYbA2ZZtLgICEmFTKB93lnx7TeRTnsXYm6PT7TYiW2nPs=; X-YMail-OSG: w0E0K78VM1l8R5IHDNBn2G5u6iN6CuJ8rvpzJG5seNoC1u7tqQsn2G.9tjEc4I.yNE1dRJfyobuvAV3_zSwiLQ83h95sBaj9mxElRJUtTyjPOTO4mFxTJ3LPuQ-- Received: from [207.171.180.101] by web55914.mail.re3.yahoo.com via HTTP; Wed, 07 May 2008 07:51:30 PDT X-Mailer: YahooMailRC/975.37 YahooMailWebService/0.7.185 Date: Wed, 7 May 2008 07:51:30 -0700 (PDT) From: bryan castillo Subject: How do I view the parameters of a running query? To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Message-ID: <103519.50713.qm@web55914.mail.re3.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200805/51 X-Sequence-Number: 29135 How can I find out what the parameters are of a running prepared query? If I look at pg_stat_activity I can see the query, however I don't know what parameters the prepared statement is using. -[ RECORD 3 ]-+------------------------------------------------------ datid | 16391 datname | warehouse procpid | 22428 usesysid | 16387 usename | mechturk current_query | select count(*) from hit.assignment where answer = $1 waiting | f xact_start | 2008-05-07 07:38:23.985758-07 query_start | 2008-05-07 07:38:23.989455-07 backend_start | 2008-05-07 07:38:23.828444-07 client_addr | 127.0.0.1 client_port | 43664 Thanks. ____________________________________________________________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ