3 lines
231 B
SQL
3 lines
231 B
SQL
-- create partial index on non-deleted queue items as we always query for non-deleted entries
|
|
CREATE INDEX CONCURRENTLY IF NOT EXISTS idx_queue_created_at_non_deleted ON queue (queue_name, created_at)
|
|
WHERE is_deleted = false;
|