Horton

Re: Process list in PostgreSQL 8.0

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Ericson Smith <eric@did-it.com>
Cc: pgsql-general@postgresql.org
Date: 2005-03-10T18:15:45Z
Lists: pgsql-general 
Ericson Smith <eric@did-it.com> writes:
> 11679 ? S 0:00 postgres: iacm didit 216.187.113.78(56640) idle
> 11680 ? S 0:07 postgres: iacm didit 216.187.113.78(56641) idle
> 11863 ? S 0:00 postgres: iacm didit 216.187.113.89(41860) idle
> 11864 ? R 0:09 postgres: iacm didit 216.187.113.89(41861) INSERT
> 11906 ? S 0:00 postgres: iacm didit 24.189.251.57(49023) idle

> Just wondering what the values in parenthesis are and how can we use 'em.

Client-side port numbers, IIRC.  So you can figure out which connection
is which ...

			regards, tom lane