Skip to content

Instantly share code, notes, and snippets.

CREATE INDEX idx_tasks_group_key ON tasks (group_key, id) WHERE status = 'QUEUED';
CREATE INDEX idx_tasks_status ON tasks (status);
EXPLAIN ANALYZE WITH
ordered_tasks AS (
SELECT
t.id,
t."status",
t."group_key",