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-29 23:10:37
Message-ID: CANNMO+JQx9SLapE3iJ3yk=hH-zXeOsrpeqxTpwu63s2r0AJx-w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Jan 29, 2018 at 3:06 PM, Jan De Moerloose <jan(at)sensolus(dot)com> wrote:
...

> SELECT pid, age(clock_timestamp(),query_start) as age, usename, query,
> state from pg_stat_activity order by age;
>
> When the cpu is 100% and the app slowing down, i can see that some queries
> have a long age.
>

What is the value of "state" column for those queries?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2018-01-29 23:11:44 Re: Meaning of query age in pg_stat_activity
Previous Message Jan De Moerloose 2018-01-29 23:06:36 Meaning of query age in pg_stat_activity