Re: [PERFORM] what's the slowest part in the SQL

On Tue, Aug 9, 2016 at 10:46 PM, Suya Huang wrote: > Hi Claudio, > > Here is the index definition > "idx_data_3" gin (name gin_trgm_ops), tablespace "tbs_data" > "idx_data_4" gin (displayname gin_trgm_ops), tablespace "tbs_data" GIN indexes are quite big, they can

[PERFORM] Logging queries using sequential scans

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: [PERFORM] Logging queries using sequential scans

Hi 2016-08-10 13:13 GMT+02:00 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? > > > you can log execution plan with auto_explain extension