Re: postgres index usage count too high

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