Home > mailing lists

Re: Logging queries using sequential scans - Mailing list pgsql-performance

From	Pavel Stehule
Subject	Re: Logging queries using sequential scans
Date	August 10, 2016 11:40:04
Msg-id	CAFj8pRAqC+pSBKjWr1z4xgTjYg-E-wcmiFUUnMurPqbuv2ic9g@mail.gmail.com Whole thread Raw
In response to	Logging queries using sequential scans (Ivan Voras <ivoras@gmail.com>)
List	pgsql-performance

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?

Then you can grep the queries with seq scan

Regards

Pavel

From: Ivan Voras
Date: 10 August 2016, 11:14:34
Subject: Logging queries using sequential scans

From: Claudio Freire
Date: 10 August 2016, 18:10:39
Subject: Re: what's the slowest part in the SQL