Query optimizations - Tips, Tools and Links on what to look for

A question was raised on what tips and tools can we use in support of the initiative - Priority - identify and address underperforming SQL queries. This issue is intended to provide that guidance and information. All submissions are welcome.

• Add documentation for using Elasticsearch with PostgreSQL slow logs (!3361 (closed)) - gitlab-com/runbooks!3361 (diffs)
• This runbook was created to detail how we create our database peak performance. If you have the appropriate permissions you can tune this runbook to different days and monitoring windows.
• Database Review Guidelines | GitLab - https://docs.gitlab.com/ee/development/database_review.html