diff options
| author | GitLab Bot <gitlab-bot@gitlab.com> | 2020-07-20 00:09:26 +0000 |
|---|---|---|
| committer | GitLab Bot <gitlab-bot@gitlab.com> | 2020-07-20 00:09:26 +0000 |
| commit | 08746f36b03da058cc1c792c03043f878066e1ed (patch) | |
| tree | 5a279a751245714fc678ee240eff4a50c5dc90e4 | |
| parent | 42537f50b6d57319efdce4d6dbaf75ac8d5346ab (diff) | |
| download | gitlab-ce-08746f36b03da058cc1c792c03043f878066e1ed.tar.gz | |
Add latest changes from gitlab-org/gitlab@master
| -rw-r--r-- | doc/development/telemetry/usage_ping.md | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/doc/development/telemetry/usage_ping.md b/doc/development/telemetry/usage_ping.md index ff9acce8479..d1e9ef96085 100644 --- a/doc/development/telemetry/usage_ping.md +++ b/doc/development/telemetry/usage_ping.md @@ -313,10 +313,11 @@ In order to have an understanding of the query's execution we add in the MR desc We also use `#database-lab` and [explain.depesz.com](https://explain.depesz.com/). For more details, see the [database review guide](../database_review.md#preparation-when-adding-or-modifying-queries). -Examples of query optimization work: +#### Optimization recommendations and examples -- [Example 1](https://gitlab.com/gitlab-org/gitlab/-/merge_requests/26445) -- [Example 2](https://gitlab.com/gitlab-org/gitlab/-/merge_requests/26871) +- Use specialized indexes [example 1](https://gitlab.com/gitlab-org/gitlab/-/merge_requests/26871), [example 2](https://gitlab.com/gitlab-org/gitlab/-/merge_requests/26445). +- Use defined `start` and `finish`, and simple queries, because these values can be memoized and reused, [example](https://gitlab.com/gitlab-org/gitlab/-/merge_requests/37155). +- Avoid joins and write the queries as simply as possible, [example](https://gitlab.com/gitlab-org/gitlab/-/merge_requests/36316). ### 4. Add the metric definition |