Thread: How to map columns in pg_stat_activity to windows PID
Hello, Postgresql 8.3.2 on Windows server 2003 R2 standard I have a client program connecting to postgresql database. The purpose is to find its session information in the pg_stat_activity table. But the PID value from the windows' task manager doesn't equal to any value in the output of select * from pg_stat_activity; For example, the windows task manager shows PID = 2760 but the procpid column shows: 2820 (I idenfied it by the username/databasename/tcp port number) Appreciate your inputs! __________________________________________________ 赶快注册雅虎超大容量免费邮箱? http://cn.mail.yahoo.com
i wonder if its threads rather than individual processes.
2009/4/24 chen shan <chenshan_1999@yahoo.com>
Hello,
Postgresql 8.3.2 on Windows server 2003 R2 standard
I have a client program connecting to postgresql
database.
The purpose is to find its session information in the
pg_stat_activity table.
But the PID value from the windows' task manager
doesn't equal to any value in the output of
select * from pg_stat_activity;
For example, the windows task manager shows PID = 2760
but the procpid column shows: 2820
(I idenfied it by the username/databasename/tcp port
number)
Appreciate your inputs!
__________________________________________________
赶快注册雅虎超大容量免费邮箱?
http://cn.mail.yahoo.com
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin