Significance of queries listed under server activity items - Mailing list pgadmin-support

From Adam Manwaring
Subject Significance of queries listed under server activity items
Date
Msg-id CALgfX7Xx5doaWr30h+W_+K=MR-3=Ot5ARnKuAqY90zKYNUv16A@mail.gmail.com
Whole thread Raw
Responses Re: Significance of queries listed under server activity items
List pgadmin-support
When viewing the details on a row on the "Server Activity" table an sql query is listed along with a few timestamps. I've been assuming that the query shown is the last active query for that session. What I don't know is whether it is the last one committed or the last one begun. I've had some trouble with sessions stuck in "idle in transaction" status. I need to know if the query is the query that has not been committed or if it is the previous query (committed prior to one that is stuck). 

I can't seem to find anything that says specifically what this query is, so I don't know whether I should be looking at the query shown to figure out what is going wrong or if I need to look elsewhere. 

Thanks for any help,
Adam

pgadmin-support by date:

Previous
From: JaeWon Lee
Date:
Subject: .pgpass not working (CentOS7, pgAgent_96 )
Next
From: Dave Page
Date:
Subject: Re: Significance of queries listed under server activity items