Locks
Queries with active exclusive locks
Showing 1 entries
Pid
Relname Transactionid Granted Query snippet Mode Age
71298 true SELECT count(s0."id") FROM "ssl_endpoints" AS s0 WHERE (s0."deactivated_at" IS NULL) AND (NOT (s0."id" IN (SELECT (so0."args"->>'ssl_endpoint_id')::integer FROM "oban_jobs" AS so0 WHERE (so0."worker" = $1) AND (so0."state" = ANY($2))))) AND (NOT (s0."id" IN (SELECT ss0."ssl_endpoint_id" FROM "ssl_certificates" AS ss0 WHERE (ss0."replaced_by_certificate_id" IS NULL) AND (ss0."valid_until" > $3)))) ExclusiveLock 0.073655 seconds