PostgreSQL Individual 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.
Learn about Site24x7's PostgreSQL server monitoring and the performance metrics that will help you optimize your PostgreSQL instances for enhanced efficiency.
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