PostgreSQL is a powerful open-source object-relational database system with over 30 years of active development. Characteristics such as reliability, high performance, and feature robustness make this database very popular. As a result, many applications developed at small to large scale enterprises utilize this database. Moein monitoring system is capable of monitoring and visualizing this database metrics. It can collect performance indicators from databases, DMLs, transactions, locks, indexes, sessions, and executed queries. Performance metrics for this database are:
- Total Sessions
- Idle Sessions
- Active Sessions
- Total Committed Transactions Rate
- Total Rolled Back Transactions Rate
- Average Cache Hit Ratio
- Rows Update Rate
- Rows Delete Rate
- Rows Insert Rate
- Rows Fetched Rate
- Rows Returned Rate
- Deadlocks Rate
- Cancelled Queries
- Index Scans Rate
- Index Reads Rate
- Index Fetches Rate
- Number Of Scheduled Checkpoints
- Number Of Requested Checkpoints
- Number Of Buffers Written
- Buffer Clean
- Maximum Written Clean
- Buffer Written Directly
- Allocated Buffer
- Checkpoint Write Time
- Checkpoint Sync Time
- Locks Held
- Locks Wait
Databases:
- List Of Databases
- Database Size
- Idle Sessions
- Active Sessions
- Total Sessions
- Committed Transactions
- Committed Transactions Rate
- Rolled Back Transactions
- Rolled Back Transactions Rate
- Cache Hit Ratio
- Rows Update Rate
- Rows Delete Rate
- Rows Insert Rate
- Rows Fetched Rate
- Rows Returned Rate
- Deadlocks Rate
- Cancelled Queries
Top Queries:
- Most Frequently Executed Queries
- Top Slow Running Queries
- Top Queries By Effected Rows Count
- Top Queries By Average IO Read Time
- Top Queries By Average IO Write Time
Communication Protocols: