Collecting metrics with PostgreSQL monitoring tools

This text discusses how to access key metrics from PostgreSQL using the statistics collector and other native sources, as well as an open source dedicated monitoring tool called PgHero. It covers various statistics views such as pg_stat_database, pg_stat_user_tables, pg_statio_user_tables, pg_stat_user_indexes, and pg_stat_bgwriter. The text also explains how to configure the PostgreSQL statistics collector and provides examples of queries for each statistics view. Additionally, it mentions other types of metrics that need to be accessed through system administration functions and other native sources, such as tracking replication delay, connection metrics, locks, and disk usage. Finally, it introduces PgHero, an open source PostgreSQL monitoring tool, and demonstrates how to install and use it for monitoring the health and performance of PostgreSQL servers.