Re: Query on pg_stat_activity table got stuck

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Query on pg_stat_activity table got stuck
Дата
Msg-id 15877.1557178386@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Query on pg_stat_activity table got stuck  (neeraj kumar <neeru.cse@gmail.com>)
Ответы Re: Query on pg_stat_activity table got stuck  (neeraj kumar <neeru.cse@gmail.com>)
Re: Query on pg_stat_activity table got stuck  (neeraj kumar <neeru.cse@gmail.com>)
Список pgsql-admin
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



В списке pgsql-admin по дате отправления:

Предыдущее
От: Pavan Kumar
Дата:
Сообщение: postgres wal log configuration question
Следующее
От: Siddharth Karandikar
Дата:
Сообщение: Re: Restoring from PostgreSQL 9.5 dump to 10 is super slow