Postgres Pro
Downloads
Home   >   mailing lists

How to determine which are "idle in transaction" - Mailing list pgsql-general

From Mike Bridge
Subject How to determine which are "idle in transaction"
Date
Msg-id 3C446A99.25BB5606@bridgecanada.com
Whole thread Raw
List pgsql-general
Tree view 
When I do a "ps ax" I have 7 processes originating from my application
that are permamently "idle in transaction".   First off, is this
something to be concerned about?  It appears to be a vendor library
that's causing it.  Second, how can I tell what these stuck transactions
are?  Is there a way to list them?
(I'm using postgresql  7.1.3)

Thanks,

-Mike

--
Mike Bridge

pgsql-general by date:

Previous
From: "Gregory Wood"
Date:
Subject: Re: "IS NOT NULL" != "NOT NULL"
Next
From: "Harald Armin Massa"
Date:
Subject: Different views with same name for different users