summaryrefslogtreecommitdiff
path: root/doc/development/understanding_explain_plans.md
Commit message (Collapse)AuthorAgeFilesLines
* Links: switch from GitHub to GitLab Postgres mirror repoNikolay Samokhvalov2019-08-131-2/+2
| | | | GitLab.com also has an up-to-date Postgres mirror.
* Remove extra whitespaces in docsMarcel Amirault2019-07-091-1/+0
| | | | | Removes all the extra whitespaces at end of lines, inside tags, and removes extra newlines
* Add section to dev docs on accessing chatopsLucas Charles2019-06-071-3/+4
| | | | closes 62127
* Add activerecord-explain-analyze gemToon Claes2019-06-031-0/+29
| | | | | | | | | | | | | | | | | | | This gem allows you to get the `EXPLAIN ANALYZE` query plan, directly from the Rails console. The gem is installed with `require: false`, but if it was loaded on launch, this would be it's memory load: ``` TOP: 145.3086 MiB rails/all: 22.4844 MiB ... activerecord-explain-analyze: 2.9648 MiB active_record/connection_adapters/postgresql_adapter: 2.9648 MiB pg: 2.9648 MiB pg_ext: 2.9648 MiB ... ```
* Add some more database docsToon Claes2019-06-031-2/+9
| | | | | Add a few useful links for those who want to learn more about databases and database performance.
* Make unordered lists conform to styleguidedocs/fix-unordered-list-styleEvan Read2019-01-081-5/+5
| | | | - Also makes other minor Markdown fixes that were near the main fixes.
* Add documentation about reading query plansdocs/document-query-plansYorick Peterse2018-08-171-0/+676
This adds a database guide on how to read the output of "EXPLAIN" and "EXPLAIN ANALYZE", and how to use this output to understand a query's performance and optimise it.