Join us for our webinar on June 18th, 9:30am Pacific Time: Optimizing slow queries with EXPLAIN to fix bad query plans - register now.

Invalid Indexes

Check Frequency

Every 30 minutes

Default Configuration

Detects indexes that are not recognized as valid in Postgres and creates an issue with severity "info", one for each table (or table hierarchy in case of inheritance or partitioning). These indexes typically are left over when using CREATE INDEX CONCURRENTLY and the command fails or is aborted by the user. Resolves once all invalid indexes on a table have been dropped.

This check is enabled by default.

Guidance

Impact

Invalid indexes take up disk space but are not usable by queries.

Solution

You can safely drop these invalid indexes.


Couldn't find what you were looking for or want to talk about something specific?
Start a conversation with us →