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