[GENERAL] Generalized pg_stat_statements?

Поиск
Список
Период
Сортировка
От Jacob Scott
Тема [GENERAL] Generalized pg_stat_statements?
Дата
Msg-id CA+yM-qa7QXh3vpFqSV8n4DMjmg-EVBAjyZY1=ywRThkxroGtcw@mail.gmail.com
обсуждение исходный текст
Ответы Re: [GENERAL] Generalized pg_stat_statements?
Список pgsql-general
Дерево обсуждения
When reviewing execution statistics, I am frequently interested in the behavior of "classes" of queries, rather than individual queries, for example queries which
  • Contain a join
  • Touch a specific column
  • Use POSIX regular expressions
AFAIK this sort of summary/rollup information can't be computed reliably from pg_stat_statements because of rows being discarded in the face of a large number of (post normalization/jumble) distinct statements.

Is there a way to retrieve these kinds of statistics in Postgres today?

Thanks,

Jacob

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

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: [GENERAL] [PERFORM] Questionaire: Common WAL write rates on busy servers.
Следующее
От: Andres Freund
Дата:
Сообщение: Re: [GENERAL] [PERFORM] Questionaire: Common WAL write rates on busy servers.