Help Docs

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 
Cache hit ratio = (Blocks hit/(Blocks hit + Blocks read)) * 100

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.

Database monitoring: MySQL | MSSQL | MySQL NDB Clusters
Server monitoring: Linux | Windows

Was this document helpful?

Would you like to help us improve our documents? Tell us what you think we could do better.


We're sorry to hear that you're not satisfied with the document. We'd love to learn what we could do to improve the experience.


Thanks for taking the time to share your feedback. We'll use your feedback to improve our online help resources.

Shortlink has been copied!