pg_stat_activity.current_query explanation? - Mailing list pgsql-performance

From Pat Chan
Subject pg_stat_activity.current_query explanation?
Date
Msg-id COL111-W2768B59E6D67C82390211FE1F00@phx.gbl
Whole thread Raw
Responses Re: pg_stat_activity.current_query explanation?  (Joshua Tolley <eggyknap@gmail.com>)
List pgsql-performance
Hello,

I'm using postgresql 8.1.5. Sorry if this is not the right area to ask this. I already have command string turned on at the postgresql.conf , and am currently trying to troubleshoot some connection problem at a server that is causing performance issues. Apart from "<IDLE>" and the specific SQL commands that the clients have issued, I'm seeing two things that I cannot seem to explain:

One is '<IDLE in transaction>' and the other is simply the word 'end'. 

I googled everywhere about this but to not avail. If you could shed some light on this subject that would be great!

Thank you in advance.


Faster Hotmail access now on the new MSN homepage.

pgsql-performance by date:

Previous
From: astro77
Date:
Subject: Slow select times on select with xpath
Next
From: Wei Zheng
Date:
Subject: Looking for real configuration data