From 20b470a2e98ede359a81979a8a7a0cc92d7989b2 Mon Sep 17 00:00:00 2001
From: Andreas Brandl <abrandl@gitlab.com>
Date: Wed, 4 Sep 2019 20:53:05 +0200
Subject: Add issue template for query performance

Relates to
https://gitlab.com/gitlab-com/gl-infra/infrastructure/issues/7743#note_212379866
---
 .../Database Query Performance Review.md           | 41 ++++++++++++++++++++++
 1 file changed, 41 insertions(+)
 create mode 100644 .gitlab/issue_templates/Database Query Performance Review.md

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
-- 
cgit v1.2.1