X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id E4A1FD1B973 for ; Mon, 23 Feb 2004 21:27:31 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 48370-08 for ; Mon, 23 Feb 2004 17:27:30 -0400 (AST) Received: from rtp-iport-2.cisco.com (rtp-iport-2.cisco.com [64.102.122.149]) by svr1.postgresql.org (Postfix) with ESMTP id 763C8D1B904 for ; Mon, 23 Feb 2004 17:27:28 -0400 (AST) Received: from rtp-core-2.cisco.com (64.102.124.13) by rtp-iport-2.cisco.com with ESMTP; 23 Feb 2004 13:24:50 -0800 Received: from ddiltsw2k01 (rtp-vpn2-215.cisco.com [10.82.240.215]) by rtp-core-2.cisco.com (8.12.10/8.12.6) with ESMTP id i1NLRO0K011038 for ; Mon, 23 Feb 2004 16:27:26 -0500 (EST) From: "Derek Dilts" To: Subject: psql command to find open statements Date: Mon, 23 Feb 2004 15:27:22 -0600 Message-ID: <000001c3fa53$d5216130$ec24b442@amer.cisco.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0001_01C3FA21.8A86F130" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.4024 Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4927.1200 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.2 tagged_above=0.0 required=5.0 tests=BAYES_44, HTML_50_60, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200402/369 X-Sequence-Number: 12542 This is a multi-part message in MIME format. ------=_NextPart_000_0001_01C3FA21.8A86F130 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit To whom it may concern: I am trying to find the command to execute against Postgres to determine how many open statements/queries/updates there at a given time in order to verify my JDBC statements are being closed. Thanks, Derek Cisco Systems ddilts@cisco.com 972-813-1574 ------=_NextPart_000_0001_01C3FA21.8A86F130 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Message
To whom i= t may=20 concern:
 
I am tryi= ng to find=20 the command to execute against Postgres to determine how many open=20 statements/queries/updates there at a given time in order to verify my JDBC= =20 statements are being closed.
 
Thanks,
Derek
 
Cisco=20 Systems
ddilts@cisco.com
972-813-1574
 
------=_NextPart_000_0001_01C3FA21.8A86F130--