Re: Is it possible to log long running recursive/internal postgresql queries?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Is it possible to log long running recursive/internal postgresql queries?
Дата
Msg-id 2713826.1676658480@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Is it possible to log long running recursive/internal postgresql queries?  (Hotmail <crajac66@hotmail.com>)
Ответы Re: Is it possible to log long running recursive/internal postgresql queries?  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-admin
Дерево обсуждения 
Hotmail <crajac66@hotmail.com> writes:
> If it is possible to log long running internal queries as outlined above any guidance would be appreciated.

Either auto_explain or pg_stat_statements could have helped you
with that, I think.  I believe (without having tested) that if
configured to track nested statements they would perceive the
FK enforcement query as a separate statement to track.

            regards, tom lane

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

Предыдущее
От: Hotmail
Дата:
Сообщение: Is it possible to log long running recursive/internal postgresql queries?
Следующее
От: Lucio Chiessi
Дата:
Сообщение: Re: EOL of Pglogical replication support