Every 30 minutes
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.
Invalid indexes take up disk space but are not usable by queries.
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 →