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?