Thread: Logging queries using sequential scans

Logging queries using sequential scans

From
Ivan Voras
Date:
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

From
Pavel Stehule
Date:
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