This documentation contains a list of metrics and alerts that are available when monitoring PostgreSQL on Linux instances.  Send us feedback if there are additional metrics or alerts you'd find valuable. 

Metrics

The following lists the metrics SQL Monitor collects and exposes on the Analysis page:

Host Linux machine metrics

• Machine: processor time
• Avg. CPU queue length
• Machine: memory used
• Memory pages/sec
• Network utilization
• Disk used
• Disk free
• Disk avg. read time
• Disk avg. write time
• Disk read bytes/sec
• Disk write bytes/sec
• Disk transfers/sec
• Avg. disk queue length

PostgreSQL on Linux metrics 

Available at the instance level as an aggregate, and at the individual database level:

• Number of connections
• Transactions committed / rolled back 
• Query overflow to temp data bytes sec
• Block write time
• Block read time
• Transactions committed / second 
• Transactions rolled back / second 
• Deadlocks / sec
• Cache hit ratio 

Alerts

The following is a list of alerts available for PostgreSQL on Linux:

• PostgreSQL specific alerts
  • Configuration change
  • Database unavailable
  • Internal SQL Monitor error (PostgreSQL)
  • Long-running query
  • Long-running transaction
  • Long-running idle transaction
  • Monitoring error (data collection)
  • Monitoring stopped (credentials)
  • Instance unreachable
• Host machine alerts
  • Disk average read time
  • Disk average write time
  • Disk space
  • Internal SQL Monitor error (host)
  • Machine unreachable
  • Monitoring error (host machine data collection)
  • Monitoring stopped (host machine credentials)
  • Physical memory
  • Processor under-utilization
  • Processor utilization