Ignore DROP statements from long-running query alert
This is a fix for gitlab-com/gl-infra/production#6821 (closed).
We got alerted for a long-running DROP INDEX CONCURRENTLY
statement. The threshold is 9 minutes. We are already ignoring CREATE
, ANALYZE
, REINDEX
, ALTER
, DROP
.
This patch adds DROP
to the list, since we may have some long-running post-deploy migrations on large tables that we want to run to completion.
Edited by Igor