Document running ANALYSE through `gitlab-psql`

Overview

Customers with large databases encountered problems with high CPU usage after upgrading to PG11. This was caused by the analyze_new_cluster.sh script failing to run but not giving the appropriate error code. !4227 (merged) bypasses this script and calls vacuumdb directly. With this change, the user is at least aware if the VACUUM and ANALYZE fail.

Problem

A customer reported still running into statement timeout issues when running vacuumdb directly. e.g. #5456 (closed)

Proposal

One solution to avoid the timeouts might be to run ANALYSE through gitlab-psql with the statement timeout set to zero. (Related discussion here). We should test this and add it in a troubleshooting section of the docs.

Edited by Ben Bodenmiller