nested queries vs. pg_stat_activity

Поиск
Список
Период
Сортировка
От legrand legrand
Тема nested queries vs. pg_stat_activity
Дата
Msg-id AM6PR0102MB3157EC9857150EF68C65BC7C90440@AM6PR0102MB3157.eurprd01.prod.exchangelabs.com
обсуждение исходный текст
Ответы Re: nested queries vs. pg_stat_activity  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Hello,

An other solution is to expose nested queryid, and to join it with pg_stat_statements.
Actual development trying to add queryid to pg_stat_activity isn't helpfull, because it is only exposing top level one.
Extension pg_stat_sql_plans (github) propose a function called pg_backend_queryid(pid),
that gives the expected queryid (that is stored in shared memory for each backend) ...

Regards
PAscal

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

Предыдущее
От: Shawn Debnath
Дата:
Сообщение: Re: pendingOps table is not cleared with fsync=off
Следующее
От: Anastasia Lubennikova
Дата:
Сообщение: Re: [BUG] Error in BRIN summarization