Commit61a9f58

committed

perf: optimize get-queue-position sql query

1 parentf9c9711 commit61a9f58Copy full SHA for 61a9f58

File tree

+14

-8

lines changed

+14

-8

lines changed

Lines changed: 7 additions & 4 deletions

Some generated files are not rendered by default. Learn more aboutcustomizing how changed files appear on GitHub.

Lines changed: 7 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -53,17 +53,20 @@ WHERE`
`53`	`53`	`WITH filtered_provisioner_jobsAS (`
`54`	`54`	`-- Step 1: Filter provisioner_jobs`
`55`	`55`	`SELECT`
`56`		`-*`
	`56`	`+id, created_at`
`57`	`57`	`FROM`
`58`	`58`	`provisioner_jobs`
`59`	`59`	`WHERE`
`60`	`60`	`id= ANY(@ids :: uuid [ ])-- Apply filter early to reduce dataset size before expensive JOIN`
`61`	`61`	`),`
`62`	`62`	`pending_jobsAS (`
`63`	`63`	`-- Step 2: Extract only pending jobs`
`64`		`-SELECT*`
`65`		`-FROM provisioner_jobs`
`66`		`-WHERE job_status='pending'`
	`64`	`+SELECT`
	`65`	`+id, created_at, tags`
	`66`	`+FROM`
	`67`	`+provisioner_jobs`
	`68`	`+WHERE`
	`69`	`+job_status='pending'`
`67`	`70`	`),`
`68`	`71`	`ranked_jobsAS (`
`69`	`72`	`-- Step 3: Rank only pending jobs based on provisioner availability`

Comments

(0)