diff options
-rw-r--r-- | .gitlab/issue_templates/Database Query Performance Review.md | 41 |
1 files changed, 41 insertions, 0 deletions
diff --git a/.gitlab/issue_templates/Database Query Performance Review.md b/.gitlab/issue_templates/Database Query Performance Review.md new file mode 100644 index 00000000000..a34ee687619 --- /dev/null +++ b/.gitlab/issue_templates/Database Query Performance Review.md @@ -0,0 +1,41 @@ +### Query + +<!-- +Ideally format the query, e.g. with http://sqlformat.darold.net + +Please obtain a query plan through ChatOps or otherwise from production. +Please use representative query parameter values. +Please post a link to https://explain.depesz.com below if the plan is +large. +--> + +```sql +SELECT 1 +``` + +Plan: <!-- link to https://explain.depesz.com/ --> + +### Statistics + +| | | +| --- | ------ | +| Observation range | <!-- time or date range --> | +| Frequency (calls per minute) | | +| Average execution time (ms) | | +| Total database time during range (s) | | + + +### Analysis + +<!-- +Suggestion, proposed change, analysis of query plan and similar +--> + +### Code + +<!-- +Where is this query used? Link to code base. This can be added later upon investigation, too. +--> + +/label ~Database ~"Database Engineering" ~performance ~"needs investigation" +cc @gl-database |