DocsUser GuideActivity monitoring

Activity monitoring

Activity monitoring works by periodically sampling the running sessions. PostgreSQL reports classifies session activity according to a set of detailed wait events, which AutoDBA uses to understand bottlenecks and suggest improvements or optimizations.

  • What is the average number of queries per second that my database is handling?
  • What is the average execution time of queries in my database?
  • Did the database experience any bottlenecks or slowdowns during the past 24 hours? If so, what was happening at the time?
  • Which hosts are sending the most expensive queries to my database?
  • Which hosts have the most underutilized connections to the database?
  • Which queries are consuming CPU resources most intensively?
  • My customer reported poor performance at around 2:30 pm on Tuesday afternoon. Was anything unusual happening on the database around that time?