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