How to determine which are "idle in transaction"

From: Mike Bridge <mike(at)bridgecanada(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How to determine which are "idle in transaction"
Date: 2002-01-15 17:44:59
Message-ID: 3C446A99.25BB5606@bridgecanada.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-01-15 20:08:16 Re: troubleshoot error when creating index
Previous Message Johnson, Shaunn 2002-01-15 17:04:11 troubleshoot error when creating index