freesound icon indicating copy to clipboard operation
freesound copied to clipboard

Optimize DB indexes

Open ffont opened this issue 7 years ago • 1 comments

Currently we use tons of GB on database indexes. We should check if all of these are necessary and whether we can get rid of some of them. Maybe postgreSQL has a way to report in which indexes are used and which are not...

ffont avatar Mar 21 '18 15:03 ffont

pg_stat_statements lets us see which types of queries are slow and need indexes: https://www.postgresql.org/docs/current/pgstatstatements.html

Unused indexes can be found with https://pgdash.io/blog/finding-unused-indexes-in-postgresql.html

alastair avatar Mar 04 '25 14:03 alastair