X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A43BADA6F8 for ; Mon, 17 Oct 2005 02:01:05 -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 32464-06 for ; Mon, 17 Oct 2005 05:01:03 +0000 (GMT) Received: from qproxy.gmail.com (qproxy.gmail.com [72.14.204.196]) by svr1.postgresql.org (Postfix) with ESMTP id 7DAD7DA6F1 for ; Mon, 17 Oct 2005 02:01:03 -0300 (ADT) Received: by qproxy.gmail.com with SMTP id u24so131946qbh for ; Sun, 16 Oct 2005 22:01:03 -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=RNvTWbWh3FkFqBDhyXMHjCl6sbxXJ2Fp8oI9E6/h3v3vXxoAeX5q9rcE8yrCOlCr4MqDcCUE2im55T/a15cLIyVVqCuW+/+6ID6tXWIxxv7dyoNUA75faN3QTYe8HTrBS0Yo6rejZPaSq9lKDINtnMqVVLAaLcVnPPiSVKRC+DI= Received: by 10.65.188.18 with SMTP id q18mr1661622qbp; Sun, 16 Oct 2005 22:01:03 -0700 (PDT) Received: by 10.64.156.9 with HTTP; Sun, 16 Oct 2005 22:01:03 -0700 (PDT) Message-ID: Date: Mon, 17 Oct 2005 10:31:03 +0530 From: Rajesh Kumar Mallah To: pgsql-admin@postgresql.org Subject: possibly outdated info in pg_stat_activity 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: 200510/185 X-Sequence-Number: 19257 Hi, PID 3533 does not exists in the system but its still in pg_stat_activity. This is PostgreSQL 8.0.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.3 20030502 (Red Hat Linux 3.2.3-49). Not sure if its already known issue , advance apologies if so. tradein_clients=3D# SELECT procpid,query_start, substring(btrim(current_query),0,50) from pg_stat_activity order by query_start limit 20; +---------+----------------------------------+-----------------------------= ----------------------+ | procpid | query_start | =20 substring | +---------+----------------------------------+-----------------------------= ----------------------+ | 3533 | 2005-10-16 22:26:21.981728+05:30 | select prod_serv,memb_affil,eyp,pacode,estd,entry | | 3649 | 2005-10-16 22:26:33.168702+05:30 | in transaction =20 | | 31579 | 2005-10-17 10:19:21.185764+05:30 | =20 | | 32142 | 2005-10-17 10:21:46.696032+05:30 | =20 | | 31715 | 2005-10-17 10:21:57.676293+05:30 | =20 | | 3508 | 2005-10-17 10:22:12.500686+05:30 | =20 | | 830 | 2005-10-17 10:23:04.34449+05:30 | =20 | | 32197 | 2005-10-17 10:23:05.458473+05:30 | =20 | | 31210 | 2005-10-17 10:23:20.55451+05:30 | =20 | | 751 | 2005-10-17 10:24:33.519166+05:30 | =20 | | 31908 | 2005-10-17 10:24:51.839088+05:30 | =20 | | 31651 | 2005-10-17 10:24:53.896042+05:30 | =20 | | 8777 | 2005-10-17 10:24:54.074668+05:30 | =20 | | 31338 | 2005-10-17 10:25:28.248292+05:30 | =20 | | 7547 | 2005-10-17 10:25:36.473533+05:30 | =20 | | 10387 | 2005-10-17 10:26:00.250297+05:30 | =20 | | 1399 | 2005-10-17 10:26:02.775205+05:30 | =20 | | 867 | 2005-10-17 10:26:13.393084+05:30 | =20 | | 10543 | 2005-10-17 10:26:14.258694+05:30 | =20 | | 8680 | 2005-10-17 10:26:19.020959+05:30 | =20 | +---------+----------------------------------+-----------------------------= ----------------------+ (20 rows)