Query based investigation in Query based Analytics

Hi Team,

I would like to request further exploration and analysis on the following aspects related to query-based investigation:

Query Investigation for PostgreSQL.
For example, identifying the top ten most resource-intensive running queries or last top query taken more time for execution for PostgreSQL DB. would provide better visibility into potential performance bottlenecks, how can we find in graph…?.

Locking Queries and Query CPU Utilization for PostgreSQL.
More detailed analysis is needed to pinpoint queries causing locking issues, as well as those contributing to high CPU utilization. It would be beneficial to have additional findings in these areas to optimize overall system performance how can we find in graph.