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.

Guidance

Impact

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

Solution

You can safely drop these invalid indexes.

This check is enabled by default.

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