Skip to content

Ignore DROP statements from long-running query alert

Igor requested to merge ignore-long-running-drop-queries into master

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

Merge request reports