Skip to content
PERCONA MONITORING AND MANAGEMENT DOCUMENTATION

For help, click the link below to get free database assistance or contact our experts for personalized support.

Get help from Percona

Check for relations with high number of indexes

Description

This check will scan all databases in the cluster and list relations with more than 10 indexes.

Resolution

Connect to the database and run the following query:

SELECT current_database() AS datname, relname, count(*) AS idxcount FROM pg_stat_user_indexes GROUP BY 1,2 ORDER BY 3 DESC
Relations with a high number of indexes may or not be needed. Therefore, we recommend checking if the indexes are in use. Unnecessary indexes can cause performance issues and overhead due to index maintenance.  

Need more support from Percona?

Percona experts bring years of experience in tackling tough database performance issues and design challenges.