The state is 'idle in transaction'. On Tue, Jan 30, 2018 at 12:10 AM, Nikolay Samokhvalov <samokhva...@gmail.com > wrote:
> On Mon, Jan 29, 2018 at 3:06 PM, Jan De Moerloose <j...@sensolus.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? > >
