neeraj kumar <neeru.cse@gmail.com> writes:
> We are using PG 10.6. We have one cron job that queries pg_stat_activity
> table to find out how many queries are running longer than X minutes and
> generate metrics.
> Query look like this :
> SELECT * FROM pg_stat_activity WHERE state='active'
> After some days, this query get stuck and doesn't finish. We tried to run
> this query manually and same result.
> We looked into pg_locks table and there this query is not blocked on any
> lock :
> https://justpaste.it/48rpe
Interesting. Can you get a stack trace to show where in the code it's
stuck?
https://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend
regards, tom lane