What is equivalent of v$sesstat and v$sql_plan in postgres?

Поиск
Список
Период
Сортировка
От kunwar singh
Тема What is equivalent of v$sesstat and v$sql_plan in postgres?
Дата
Msg-id CAJSrDUrSbhRDkk3w7zxz6=DOZ=Lv9qff2aWzFOWfXphfaC+Hkg@mail.gmail.com
обсуждение исходный текст
Ответы Re: What is equivalent of v$sesstat and v$sql_plan in postgres?  (MichaelDBA <MichaelDBA@sqlexec.com>)
Список pgsql-performance
Дерево обсуждения
If not , how can I get the same functionality by writing a query/job/procedure?

Something which doesn't require me to install a plugin , it is RDS PostgreSQL so cannot install /enable plugin without downtime to a critical production database

v$sesstat use case - I run a query , I would like to see what all metrics in postgres change for my session

v$sql_plan use case - I want to capture all operations for all plans and do analysis on those.

--
Cheers,
Kunwar

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

Предыдущее
От: Clemens Eisserer
Дата:
Сообщение: Re: speeding up grafana sensor-data query on raspberry pi 3
Следующее
От: MichaelDBA
Дата:
Сообщение: Re: What is equivalent of v$sesstat and v$sql_plan in postgres?