How to map columns in pg_stat_activity to windows PID

From: chen shan <chenshan_1999(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: How to map columns in pg_stat_activity to windows PID
Date: 2009-04-24 14:04:56
Message-ID: 241408.97564.qm@web32106.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Grittner 2009-04-24 14:23:39 Re: Updating a very large table
Previous Message Kevin Grittner 2009-04-24 14:04:36 Re: Updating a very large table