On Mon, Jan 29, 2018 at 9:52 PM, Nikolay Samokhvalov <samokhvalov@xxxxxxxxx> wrote:
On Mon, Jan 29, 2018 at 3:45 PM, Jan De Moerloose <jan@xxxxxxxxxxxx> wrote:So the query is just the latest query and the time is the transaction time since this query, i suppose ?Thanks for your answer, i will try to make the transaction shorter as you suggest.Yep. This is a very common confusion, however it usually happens regarding records with "state" = 'idle'– notice that they also have something in "query" column while they are actually doing nothing.
One correction:
"the time is the transaction time since this query" is not an accurate statement.
You mentioned query_start – it reflects the last query's starting time, not transaction's.
There are other timestamps:
backend_start, xact_start, and state_change.
All of them are useful in different contexts.
