Re: Logging queries using sequential scans

[Pavel Stehule <pavel.stehule@xxxxxxxxx>]

Hi

2016-08-10 13:13 GMT+02:00 Ivan Voras <ivoras@xxxxxxxxx>:

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