PostgreSQL Diagnostics from the standpoint of a system administrator (not a DBA)
Co-founder of the monitoring service okmeter.io, formerly leader of the hh.ru maintenance department.
It often happens that you already have PosgtreSQL in production, but you don’t have a DBA. To demystify the PostgreSQL database, I’ll tell you how to troubleshoot various problems while working with PosgtreSQL. We will try to understand how to answer "routine" questions of a typical system administrator: - Is everything OK with the database? - What consumes DB server resources? - What to optimize first to reduce resource consumption?