Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings
forked fromANT0071/coder

Commit21402c7

Browse files
authored
perf(coderd/database): optimize GetAPIKeysLastUsedAfter (coder#19725)
This change adds a support-index for `GetAPIKeysLastUsedAfter`.On dogfood (24h): called 4.4k times, 380ms average.Change for tested time range: `170ms` -> `3.3ms`.
1 parentfb9753e commit21402c7

File tree

3 files changed

+7
-0
lines changed

3 files changed

+7
-0
lines changed

‎coderd/database/dump.sql‎

Lines changed: 4 additions & 0 deletions
Some generated files are not rendered by default. Learn more aboutcustomizing how changed files appear on GitHub.
Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1 @@
1+
DROPINDEX api_keys_last_used_idx;
Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff 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';

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp