neeraj kumar <neeru.cse@xxxxxxxxx> 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
