QAN does not show the PostgreSQL queries with Full Table scan

Percona Monitoring and Management (PMM) PMM 2.x
1

Hi Team,

We just did a few load tests on the PostgresDB server. During the load test, the CPU utilization went up to 99%. For example, following the load test, we conducted our own analysis and discovered a few queries that do a full table scan but are not shown in the QAN.

Could you please assist us in identifying the queries which are doing the full table scan?

2

@Roma_Novikov @nurlan Can you please help me on this?

3

Hello @Naresh9999, sorry currently I’m a bit busy and can’t assist with this problem. Could you please add more details on how did you perform load test and share how did you compare results.