Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 307614759CF for ; Fri, 10 May 2002 06:27:18 -0400 (EDT) Received: from mail-relay.trade-india.com (mail-relay.trade-india.com [203.196.129.235]) by postgresql.org (Postfix) with SMTP id 4554F475958 for ; Fri, 10 May 2002 06:27:14 -0400 (EDT) Received: (qmail 10910 invoked from network); 10 May 2002 10:20:02 -0000 Received: from system29.trade-india-local.com (HELO server) (192.168.0.29) by ptil-236-129-del.primus-india.net with SMTP; 10 May 2002 10:20:02 -0000 Content-Type: text/plain; charset="us-ascii" From: "Rajesh Kumar Mallah." Organization: Infocom Network Limited. To: pgsql-sql@postgresql.org Subject: pg_stat_get_backend_pid seems to be listing non existant pids !! Date: Fri, 10 May 2002 15:56:40 +0530 X-Mailer: KMail [version 1.4] MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200205101556.40047.mallah@trade-india.com> X-Archive-Number: 200205/86 X-Sequence-Number: 7722 Hi Folks, please help , therse seems to be too much lag between the access collector=20 and system status. even the pids of backend does not seems to be matching. tradein_clients=3D# SELECT pg_stat_get_backend_pid(s.backendid) AS procpid,= =20 pg_stat_get_backend_activity(s.backendid) AS current_query FROM (SELECT=20 pg_stat_get_backend_idset() AS backendid) s; procpid | current_query ---------+------------------------------- 27134 | in transaction 26958 | in transaction 26953 | in transaction 26960 | in transaction 27008 | in transaction 12839 | 26977 | in transaction 27012 | in transaction 31354 | 27014 | in transaction 27015 | in transaction 26978 | in transaction 26985 | in transaction 27135 | select count(*) from ( select distinct on (email_id)=20 email_id,email,contact from email_bank a join (select email_id from=20 email_export_category where category_id in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10,= =20 12, 14, 16, 17, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 1 12262 | SELECT source_id , cnt from (SELECT source_id,count(source_id) = as=20 cnt from email_source group by source_id ) subsel join sources=20 using(source_id) order by source_id 27136 | in transaction (16 rows) tradein_clients=3D# why does the above not match with the "top" output at=20 the same time: =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D 4:10pm up 2 days, 23:06, 2 users, load average: 6.21, 6.06, 5.60 69 processes: 66 sleeping, 3 running, 0 zombie, 0 stopped CPU states: 55.6% user, 2.0% system, 0.0% nice, 42.3% idle Mem: 1028484K av, 980320K used, 48164K free, 0K shrd, 3744K bu= ff Swap: 971004K av, 102532K used, 868472K free 912724K=20 cached PID USER PRI NI SIZE RSS SHARE STAT LIB %CPU %MEM TIME COMMAND 5456 postgres 17 0 59456 57M 57156 R 0 99.1 5.7 3:12 postmast= er 6601 postgres 9 0 79964 77M 78328 S 0 3.3 7.7 0:01 postmast= er 6779 postgres 9 0 88412 86M 86752 S 0 1.9 8.5 0:00 postmast= er 6703 postgres 9 0 81668 79M 80276 S 0 1.7 7.9 0:01 postmast= er 6943 postgres 9 0 78732 76M 77520 S 0 1.7 7.6 0:01 postmast= er 6940 postgres 9 0 44180 42M 42668 S 0 0.5 4.2 0:00 postmast= er 6776 postgres 9 0 121M 121M 119M S 0 0.3 12.0 0:01 postmast= er 5597 postgres 8 0 624 248 216 S 0 0.0 0.0 0:24 postmast= er 5598 postgres 9 0 1440 4 4 D 0 0.0 0.0 2:31 postmast= er 5599 postgres 9 0 2052 4 4 S 0 0.0 0.0 28:05 postmast= er 12262 postgres 9 0 88564 4 4 D 0 0.0 0.0 0:19 postmast= er 13039 postgres 9 0 656 4 4 D 0 0.0 0.0 0:00 postmast= er 29440 postgres 9 0 20928 19M 20332 S 0 0.0 1.9 0:01 postmast= er 1652 postgres 9 0 3356 2324 2144 S 0 0.0 0.2 3:21 postmast= er 2219 postgres 9 0 2744 2120 2068 S 0 0.0 0.2 0:00 postmast= er 6772 postgres 9 0 100M 100M 99.3M S 0 0.0 9.9 0:00 postmast= er 6805 postgres 9 0 4440 4168 3532 S 0 0.0 0.4 0:00 postmast= er 6809 postgres 9 0 35280 34M 33948 S 0 0.0 3.4 0:00 postmast= er 6846 postgres 9 0 98.9M 98M 99804 S 0 0.0 9.8 0:01 postmast= er 6931 postgres 9 0 21744 20M 20428 S 0 0.0 2.0 0:02 postmast= er 6934 postgres 9 0 19020 18M 17868 S 0 0.0 1.8 0:00 postmast= er 6941 postgres 9 0 63280 61M 61756 S 0 0.0 6.1 0:01 postmast= er =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D [root@linux10320 root2]# kill -INT 27135 bash: kill: (27135) - No such pid [root@linux10320 root2]# and # kill -INT 12262 does not actually kills it ?? regds mallah. --=20 Rajesh Kumar Mallah, Project Manager (Development) Infocom Network Limited, New Delhi phone: +91(11)6152172 (221) (L) ,9811255597 (M) Visit http://www.trade-india.com , India's Leading B2B eMarketplace.