On Wed, 2021-04-28 at 18:41 -0400, Ayub M wrote: > There is a table in the db, whose index_scan count from pg_stat_all_tables > for this > table seems to be too high, there are not that many queries being executed > against > this table. Wondering how this count can be too high.
The table contains cumulative statistics. So you should remember the value, look again in a day or a week and calculate the difference to see how often index scans have been used in that time. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
