Thread: 8.1 display in top

Quick question.

I am looking at top on my RH AS 4.0 server that runs my PG 8.1 database.  When I see a db process in top, it says postgres: user db ipaddr(number) condition (i.e. postgres: user1 db1 10.4.10.10(23456) SELECT).

What does the number after the ip address represent (the (23456)]?

Thanks,

Chris

"Chris Hoover" <revoohc@gmail.com> writes:
> What does the number after the ip address represent (the (23456)]?

It's the TCP port number on the client end.  Some people requested that
so they could tell apart multiple connections from the same client
machine (you can use lsof or equivalent on the client side to identify
the particular process that has a given port open).

            regards, tom lane