PostgreSQL database monitoring
Site24x7 PostgreSQL Database Monitoring offers real-time performance tracking, instant alerts, and auto-discovery for your PostgreSQL databases. Ensure high availability, optimal performance, and database health with customizable alerts.
Get real-time insights into critical performance indicators—like cache hit ratio, database size, rows fetched/returned, transaction details, and so on—to manage and optimize your PostgreSQL database instances effectively.
Supported PostgreSQL flavors
-
PostgreSQL version 10.23 and above
Supported database metrics
|
Metric name |
Description |
Unit |
|---|---|---|
|
Summary |
||
|
Cache Hit Ratio |
The percentage of blocks read from cache |
Percentage |
|
Rows Fetched by Returned |
The percentage of rows fetched by rows returned Rows fetched by returned = (Rows fetched / Rows returned)*100 |
Percentage |
|
Deadlocks |
The number of deadlocks detected in the database |
Count |
|
Database Size |
The size of the database |
Bytes |
|
Tables |
The total number of tables present in the database |
Count |
|
Rows Returned |
The total number of rows scanned by the queries executed against the database instance |
Count |
|
No. of Backend Processes |
The number of backend processes connected to the database |
Count |
|
Rows Inserted |
The number of rows inserted by the queries in the database |
Count |
|
Rows Updated |
The number of rows updated by the queries in the database |
Count |
|
Rows Deleted |
The number of rows deleted by the queries in the database |
Count |
|
Capacity Planning |
||
|
Temp Bytes |
The total amount of data written to the temporary files by the queries in the database |
Bytes |
|
Temp Files |
The number of temporary files created by the queries in the database |
Count |
|
Live Rows |
The number of live rows |
Count |
|
Dead Rows |
The number of dead rows |
Count |
|
Hot Updated Rows |
The number of rows HOT (Heap-Only Tuples) updated |
Count |
|
DevOps |
||
|
Locks |
The total number of locks present in the database |
Count |
|
Transactions Committed |
The number of committed transactions in the database |
Count |
|
Transactions Rollback |
The number of rolled back transactions in this database |
Count |
|
Sequential Scans |
The number of sequential scans initiated |
Count |
|
Index Scans |
The number of index scans initiated |
Count |
|
Buffer Hits |
The number of buffer hits |
Count |
|
Disk Blocks Read |
The number of disk blocks read |
Count |
Licensing
Each PostgreSQL Instance consumes one advanced monitor license and includes monitoring for twenty-five databases. For each additional database, one basic monitor license will be consumed.
Related content
Database monitoring: MySQL | MSSQL | MySQL NDB Clusters
Server monitoring: Linux | Windows