diff options
author | Toon Claes <toon@gitlab.com> | 2019-05-27 15:15:05 +0200 |
---|---|---|
committer | Toon Claes <toon@gitlab.com> | 2019-05-27 15:15:05 +0200 |
commit | a1e88b62ce0d5eaf8b17e46bcc9575b188fd3d59 (patch) | |
tree | 24cdb117930e4b89c1e1b6e50ecd95d09c47d366 | |
parent | ae1d81661d6b0d609cea0d5e3d0e8af547e33ead (diff) | |
download | gitlab-ce-tc-db-docs.tar.gz |
Add some more database docstc-db-docs
Add a few useful links for those who want to learn more about
databases and database performance.
-rw-r--r-- | doc/development/README.md | 1 | ||||
-rw-r--r-- | doc/development/understanding_explain_plans.md | 11 |
2 files changed, 10 insertions, 2 deletions
diff --git a/doc/development/README.md b/doc/development/README.md index 624665a42d1..20cf48ce4e3 100644 --- a/doc/development/README.md +++ b/doc/development/README.md @@ -105,6 +105,7 @@ description: 'Learn how to contribute to GitLab.' - [Database Debugging and Troubleshooting](database_debugging.md) - [Query Count Limits](query_count_limits.md) - [Database helper modules](database_helpers.md) +- ["What every developer should know about SQL performance"](https://use-the-index-luke.com/sql/table-of-contents) ## Integration guides diff --git a/doc/development/understanding_explain_plans.md b/doc/development/understanding_explain_plans.md index 01a0044f096..0abd86d4b4c 100644 --- a/doc/development/understanding_explain_plans.md +++ b/doc/development/understanding_explain_plans.md @@ -80,8 +80,9 @@ Planning time: 2.861 ms Execution time: 3428.596 ms ``` -For more information, refer to the official [EXPLAIN -documentation](https://www.postgresql.org/docs/current/static/sql-explain.html). +For more information, refer to the official +[`EXPLAIN` documentation](https://www.postgresql.org/docs/current/sql-explain.html) +and [using `EXPLAIN` guide](https://www.postgresql.org/docs/current/using-explain.html). ## Nodes @@ -674,3 +675,9 @@ For more information about the available options, run: ``` /chatops run explain --help ``` + +## Further reading + +A more extensive guide on understanding query plans can be found in +the [presentation](https://www.dalibo.org/_media/understanding_explain.pdf) +from [Dalibo.org](https://www.dalibo.org/en/). |