Files
windmill/backend/migrations/20240727103951_min_started_at_index.up.sql
2024-07-27 12:41:01 +02:00

2 lines
235 B
SQL

CREATE INDEX IF NOT EXISTS queue_concurrency_started_at ON queue (workspace_id, script_path, started_at) WHERE concurrent_limit > 0 AND running = true AND job_kind != 'dependencies' AND canceled = false;-- Add up migration script here