Commit278b666

committed

perf(coderd/database): add index for GetAPIKeysLastUsedAfter

1 parentdf8b3b2 commit278b666Copy full SHA for 278b666

File tree

-0

lines changed

-0

lines changed

Lines changed: 1 addition & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1 @@`
	`1`	`+DROPINDEX api_keys_last_used_idx;`

Lines changed: 2 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,2 @@`
	`1`	`+CREATEINDEXapi_keys_last_used_idxON api_keys (last_usedDESC);`
	`2`	`+COMMENT ON INDEX api_keys_last_used_idx IS'Index for optimizing api_keys queries filtering by last_used';`

Comments

(0)