3 ms·
I would prefer they worked on something much simpler for now: the ability to mark a table as "log all full table scans on this table unless the SQL query contai
by silvestrov 9y ago
I would prefer they worked on something much simpler for now: the ability to mark a table as "log all full table scans on this table unless the SQL query contains the string xxxxx".
This would make it easy to catch missing indexes without logging all queries and without the nightly batch updates which are expected to do full table scans.
- thom 9y agoI'm sure you're aware of this, but apart from the filtering, you _can_ get a count of sequential scans for a table from pg_stat_all_tables.