PostgreSQL Monitoring: A Practical Guide to Metrics, Tools, and Alerts
https://rivestack.io/blog/postgresql-monitoring-guide
PostgreSQL tells you everything through plain SQL views. pg_stat_statements for query performance, pg_stat_activity for connections, pg_stat_user_tables for bloat. The hard part is knowing which metrics matter and what to alert on.
