How can we log the sequential scan of queries at DB level

Поиск
Список
Период
Сортировка
От badrinadh p
Тема How can we log the sequential scan of queries at DB level
Дата
Msg-id CALzt2sNw13V465GLeZp1WWaZs=ORa2ne1-dFng0gGLFMs2kEtg@mail.gmail.com
обсуждение исходный текст
Ответы Re: How can we log the sequential scan of queries at DB level
Список pgsql-admin
HI Team,
I tried in different ways to get the slow queries and generated explain plan using explain analyze(only select). I generated a PGBadger report and got the Most frequent queries. My request  is there any option to find the list of queries that scan large number of rows regardless of the time they take. I would like to have the log of queries that scan large number of rows regardless of the time they take except for the auto explain option. Is there any tool or extension?

Thanks,
Venkata.

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

Предыдущее
От: Mukesh Rajpurohit
Дата:
Сообщение: DBMS_LDAP equivalent utility in PostgreSQL
Следующее
От: parth ratra
Дата:
Сообщение: facing issues in downloading of packages in pgadmin4