diff options
author | Stan Hu <stanhu@gmail.com> | 2018-07-30 19:58:31 +0300 |
---|---|---|
committer | Stan Hu <stanhu@gmail.com> | 2018-07-30 20:03:05 +0300 |
commit | 00709a13a4197a8edd4cf9e6529c5d94f01ba012 (patch) | |
tree | 86d532f766bb979f18070d4a0ec11da19523ed38 /changelogs | |
parent | cb2e07309b4e61501a44c3568155bdb73252338f (diff) |
Fix /admin/jobs failing to load due to statement timeout
The `ORDER BY created_at DESC` clause causes a sequential scan because
there is no index on the `created_at` column. We can sort by `id`
or by `updated_at` to make things fast.
Closes #49767
Diffstat (limited to 'changelogs')
-rw-r--r-- | changelogs/unreleased/sh-fix-admin-jobs-controller-timing-out.yml | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/changelogs/unreleased/sh-fix-admin-jobs-controller-timing-out.yml b/changelogs/unreleased/sh-fix-admin-jobs-controller-timing-out.yml new file mode 100644 index 00000000000..e1adebbf076 --- /dev/null +++ b/changelogs/unreleased/sh-fix-admin-jobs-controller-timing-out.yml @@ -0,0 +1,5 @@ +--- +title: Fix /admin/jobs failing to load due to statement timeout +merge_request: 20909 +author: +type: performance |