Обсуждение: Logging queries using sequential scans

Поиск
Список
Период
Сортировка

Logging queries using sequential scans

От
Ivan Voras
Дата:
Hello,

Is it possible to log queries using sequential scans? Or possibly every query in a way which allows grepping for those with sequential scans?


Re: Logging queries using sequential scans

От
Pavel Stehule
Дата:
Hi

2016-08-10 13:13 GMT+02:00 Ivan Voras <ivoras@gmail.com>:
Hello,

Is it possible to log queries using sequential scans? Or possibly every query in a way which allows grepping for those with sequential scans?



you can log execution plan with auto_explain extension

 https://www.postgresql.org/docs/current/static/auto-explain.html

Then you can grep the queries with seq scan

Regards

Pavel