Re: Meaning of query age in pg_stat_activity

From: Nikolay Samokhvalov <samokhvalov(at)gmail(dot)com>
To: Jan De Moerloose <jan(at)sensolus(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Meaning of query age in pg_stat_activity
Date: 2018-01-30 05:52:00
Message-ID: CANNMO+LCGYXsBtCOS6+q2FoCbm9Ad98eqd2=KcZJQSfEQCyNkw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Jan 29, 2018 at 3:45 PM, Jan De Moerloose <jan(at)sensolus(dot)com> 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Nikolay Samokhvalov 2018-01-30 06:04:14 Re: Meaning of query age in pg_stat_activity
Previous Message Pritam Barhate 2018-01-30 04:25:45 Re: Using AWS ephemeral SSD storage for production database workload?