Search Postgresql Archives

Re: Meaning of query age in pg_stat_activity

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





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. 

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux