Add observability for Praefect database on gitlab.com
This might need to move to another project, but adding it here until we know what we actually have to do
On gitlab.com we use GCP Cloud SQL to host the database for Gitaly Cluster.
To get some insight on the database usage, it would be great if you can monitor things like:
- which queries run most often
- which queries are the slowest
- which indexes are the biggest
- etc.
For the main database used on gitlab.com we use postgres-checkup. It creates a very thorough report on the database usage: example. It would be nice if we can create a similar report for the Praefect database.
Edited by Toon Claes