Skip site navigation (1) Skip section navigation (2)

Understanding ps -ef "command" column

From: "David Jaquay" <djaquay(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Understanding ps -ef "command" column
Date: 2008-02-22 16:18:22
Message-ID: ad4aa5a80802220818p54412028r9205f49601492326@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
When I do a ps -ef, in the command column, I see:

postgres: postgres dbname 10.170.1.60(57413) idle

I get all of this, except the "57413".  What does this mean, and more
importantly, how can I tie that number back to a connection that I've
acquired via JDBC?

In my case, I've got a connection that's hanging around after my code should
have closed it, which means almost certainly that I've got problems in my
code, but I'd love to be able to get that "57413" number from my jdbc object
and write it to my logs to troubleshoot this.  Any ideas?

Thanks,
Dave

Responses

pgsql-general by date

Next:From: Douglas McNaughtDate: 2008-02-22 16:28:34
Subject: Re: Understanding ps -ef "command" column
Previous:From: JustinDate: 2008-02-22 16:10:20
Subject: Re: need some help on figuring out how to write a query

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group