Listing all open sessions/connections/XAs ? - Mailing list pgsql-admin

From
Subject Listing all open sessions/connections/XAs ?
Date
Msg-id 20040616193851.95910.qmail@web12704.mail.yahoo.com
Whole thread Raw
Responses Re: Listing all open sessions/connections/XAs ?
List pgsql-admin
Hello,

Occasionally I see that my (web) app leaves some DB connections open,
so they look like this to `ps':

  postgres: username dbname 127.0.0.1 idle in transaction

This results in my DB connection pool getting exhausted every so often.
I need to track the source of this problem.

Is there a way to see the SQL (or any other information) associated
with a connection/session/transaction that caused my DB connection to
remain open?

I know MS SQL Server has something like that, and so does Oracle, but I
haven't seen this mentioned in the PostgreSQL Admin Guide.

I have PG 7.3.4.

Thanks,
Otis


pgsql-admin by date:

Previous
From: Jeff Keller
Date:
Subject: Capacity Planning
Next
From: "David F. Skoll"
Date:
Subject: Re: [Support i5GKDLjR008723] PGRES_FATAL_ERROR: out of free buffers: