Re: weird long time query

2019-12-17 Thread Kaijiang Chen
I think I should also report it as a bug since logically, it couldn't exist. On Wed, Dec 18, 2019 at 1:04 AM Tom Lane wrote: > Kaijiang Chen writes: > > I'm using postgres 9.4.17 on centos 7. > > I check the running queries with the following SQL: > > SELECT > > procpid, > > start, > >

Re: weird long time query

2019-12-17 Thread Tom Lane
Kaijiang Chen writes: > I'm using postgres 9.4.17 on centos 7. > I check the running queries with the following SQL: > SELECT > procpid, > start, > now() - start AS lap, > current_query > FROM > (SELECT > backendid, > pg_stat_get_backend_pid(S.backendid) AS proc

Re: weird long time query

2019-12-17 Thread Pavel Stehule
út 17. 12. 2019 v 11:45 odesílatel Kaijiang Chen napsal: > I'm using postgres 9.4.17 on centos 7. > I check the running queries with the following SQL: > SELECT > procpid, > start, > now() - start AS lap, > current_query > FROM > (SELECT > backendid, > pg_stat_

weird long time query

2019-12-17 Thread Kaijiang Chen
I'm using postgres 9.4.17 on centos 7. I check the running queries with the following SQL: SELECT procpid, start, now() - start AS lap, current_query FROM (SELECT backendid, pg_stat_get_backend_pid(S.backendid) AS procpid, pg_stat_get_backend_activity_sta