Re: postgres index usage count too high

2021-04-28 Thread Laurenz Albe
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 cont

postgres index usage count too high

2021-04-28 Thread Ayub M
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. 1. The db is up since 80 days so I assume these are cumulative stats si