The state is 'idle in transaction'. On Tue, Jan 30, 2018 at 12:10 AM, Nikolay Samokhvalov <[email protected] > wrote:
> On Mon, Jan 29, 2018 at 3:06 PM, Jan De Moerloose <[email protected]> > 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? > >
