PostgreSQL Monitoring

Iotellect Network Manager includes out-of-the-box PostgreSQL monitoring dashboards. It provides before-the-fact warnings about potential problems and collects comprehensive statistics reducing your bottleneck search time. The collected data allows you to plan resource leveling and hardware extension before a trouble arises. The Manager’s strong point is its ability to monitor DBMS together with hardware, OS performance and communication channels equally well. Moreover, it provides massive opportunities to create custom PostgreSQL diagnostic queries.

PostgreSQL monitoring needs read permission for these tables:

• pg_stat_activity
• pg_stat_database
• pg_indexes
• pg_locks
• pg_stat_database
• pg_stat_all_tables
• pg_trigger

PostgreSQL monitoring metrics include:

• User activity
• Tabular data
• Lock statistics
• Index information
• Trigger statistics
• Database size
• Database operation statistics
• Buffer utilization efficiency
• And more

Was this page helpful?

Tell us more

Send

Thank you!