Key Ideas

• We aim to collect detailed information about the master and all its replicas (user must provide all the hostnames).
• All items in the list are structure using 3 subsections:
  • "Observations": automatically collected data. This is to be consumed by an expert DBA.
  • "Conclusions": what we conclude from the Observations, what is good, what is bad (right now, it is to be manually filled for most checks).
  • "Recommendations": actions items, what to do to fix issues found. Both "Conclusions" and "Recommendations" are to be consumed by an engineers who will make decisions what, how and when to optimize, how to react to the findings.
• Only Postgres 9.6+ is to be supported (might be changed in future if we adjust code snippets to support older versions).
• Internally, all reports have JSON format, ready to be consumed by machines. Using templates, JSON reports are translated to markdown (.md) files, for humans. Markdown easily converts to anything else (HTML, PDF, etc).

The Full List of Checks

MIGRATED, PLEASE FIND IT HERE: https://gitlab.com/postgres-ai-team/postgres-checkup#the-full-list-of-checks