2 ms·
Which is why you should monitor DDL, manually or automatically, and alert you to invalid indices. This can be as simple as a cron that runs something like this:
by sgarland 2y ago
Which is why you should monitor DDL, manually or automatically, and alert you to invalid indices. This can be as simple as a cron that runs something like this:
SELECT indrelid::regclass tbl, indexrelid::regclass idx FROM pg_index WHERE NOT indisvalid;
And then sends that to Slack or whatever if it returns a result.