What monitoring tools for PostgreSQL do you know and have used?

The following tools are often used for monitoring PostgreSQL:

• pg_stat_statements — an extension for collecting statistics on executed queries, helps identify slow and resource-intensive queries.
• pgAdmin — a graphical interface with monitoring and administration capabilities.
• Prometheus + PostgreSQL Exporter — for collecting metrics and building dashboards in Grafana.
• pgBadger — a tool for analyzing PostgreSQL logs and generating performance reports.
• Zabbix or Nagios — monitoring systems with templates for PostgreSQL.

Example of using pg_stat_statements to identify the longest queries:

SELECT query, total_time, calls, mean_time
FROM pg_stat_statements
ORDER BY total_time DESC
LIMIT 10;

These tools allow tracking the database status, load, and identifying bottlenecks.