If a query that has started to execute is blocked by another query for the specified number of minutes, Command Center raises an alert.
Queries that are queued, but have not yet started, do not trigger this alert.
The alert contains the Query ID, database name and user, and run-time details.
Qid":{“Tmid”:1541113373,“Ssid”:6968,“Ccnt”:3},“Database”:“postgres”,“User”:“gpmon”,“SubmitTime”:“2018 -11-02T16:10:04+08:00”,“StartTime”:“2018-11-02T16:10:04+08:00”,“QueryText”:""}
Need alert type specific JSON example to write this out
Use the Query Monitor to locate the blocked query and the query that blocks it.
Determine whether the blocking query is executing properly:
Determine whether you should allow the query to complete, or cancel the query so that the blocked queries can resume.