proposal - log_full_scan - Mailing list pgsql-hackers

From Pavel Stehule
Subject proposal - log_full_scan
Date
Msg-id CAFj8pRBeP78aLc5Psd2cpbso8mY4bmTvHfayJ+yqrpoOF0v0Fw@mail.gmail.com
Whole thread Raw
Responses Re: proposal - log_full_scan  (Justin Pryzby <pryzby@telsasoft.com>)
List pgsql-hackers
Hi

today I worked on postgres's server used for critical service. Because the application is very specific, we had to do final tuning on production server. I fix lot of queries, but I am not able to detect fast queries that does full scan of middle size tables - to 1M rows. Surely I wouldn't log all queries. Now, there are these queries with freq 10 per sec.

Can be nice to have a possibility to set a log of  queries that do full scan and read more tuples than is specified limit or that does full scan of specified tables.

What do you think about the proposed feature?

Regards

Pavel

pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: File truncation within PostgresNode::issues_sql_like() wrong on Windows
Next
From: Justin Pryzby
Date:
Subject: Re: proposal - log_full_scan