Postgres Pro
Downloads
Home   >   mailing lists

[SQL] commit not completing - how to investigate? - Mailing list pgsql-sql

From Tim Dudgeon
Subject [SQL] commit not completing - how to investigate?
Date
Msg-id 5e59f5e0-7168-fb80-d038-7fe9adad4aa9@gmail.com
Whole thread Raw
Responses Re: [SQL] commit not completing - how to investigate?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
I have a situation where the pg_stat_activity view shows that can have 
some processes that are idle and not completing. In some cases the 
statement being executed is COMMIT.

How can I investigate WHY these processes are not completing. Presumably 
they are waiting on something, but I'm not sure how to work out what 
this is.

Thanks
Tim

pgsql-sql by date:

Previous
From: "Maddali, Srinivas"
Date:
Subject: [SQL] Re: [EXTERNAL] Re: [pgus-general] Steps to place standby database inread write
Next
From: Tom Lane
Date:
Subject: Re: [SQL] commit not completing - how to investigate?