# QAN does not show the PostgreSQL queries with Full Table scan
**URL:** https://forums.percona.com/t/qan-does-not-show-the-postgresql-queries-with-full-table-scan/34819
**Category:** PMM 2.x
**Created:** [November 6, 2024, 5:00pm UTC](https://forums.percona.com/t/qan-does-not-show-the-postgresql-queries-with-full-table-scan/34819 "2024-11-06T17:00:32Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@Naresh9999](https://forums.percona.com/u/Naresh9999)
#### Post date: [November 6, 2024, 5:00pm UTC](https://forums.percona.com/t/qan-does-not-show-the-postgresql-queries-with-full-table-scan/34819/1 "2024-11-06T17:00:32Z")
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?
---
### Author:  [@Naresh9999](https://forums.percona.com/u/Naresh9999)
#### Post date: [November 7, 2024, 1:51pm UTC](https://forums.percona.com/t/qan-does-not-show-the-postgresql-queries-with-full-table-scan/34819/2 "2024-11-07T13:51:50Z")
@Roma_Novikov @nurlan Can you please help me on this?
---
### Author:  [@nurlan](https://forums.percona.com/u/nurlan)
#### Post date: [November 8, 2024, 9:24am UTC](https://forums.percona.com/t/qan-does-not-show-the-postgresql-queries-with-full-table-scan/34819/3 "2024-11-08T09:24:39Z")
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.
---
### Author:  [@Naresh9999](https://forums.percona.com/u/Naresh9999)
#### Post date: [May 2, 2025, 6:43pm UTC](https://forums.percona.com/t/qan-does-not-show-the-postgresql-queries-with-full-table-scan/34819/4 "2025-05-02T18:43:34Z")
@nurlan Can you please guide me on where I can check or which columns we can consider for a PostgreSQL table full scan?
Can you please help me with the columns that we check for the table full scan using pmm.metrics table?
> **[Advanced Query Analysis in Percona Monitoring and Management with Direct...](https://www.percona.com/blog/advanced-query-analysis-in-percona-monitoring-and-management-with-direct-clickhouse-access/)**
>
> Using ClickHouse for advanced MySQL query analysis tasks in Percona Monitoring and Management.
---
### Author:  [@nurlan](https://forums.percona.com/u/nurlan)
#### Post date: [May 2, 2025, 8:01pm UTC](https://forums.percona.com/t/qan-does-not-show-the-postgresql-queries-with-full-table-scan/34819/5 "2025-05-02T20:01:35Z")
Hi, we don’t collect information about fullscan for PostgreSQL as this information doesn’t exist in pg\_stat\_statements.
---
### Author:  [@Naresh9999](https://forums.percona.com/u/Naresh9999)
#### Post date: [May 3, 2025, 5:12am UTC](https://forums.percona.com/t/qan-does-not-show-the-postgresql-queries-with-full-table-scan/34819/6 "2025-05-03T05:12:31Z")
@nurlan Actually my query source is pg\_stat\_monitor and postgresql version 16.
Pmm version: 3.1.0
---
### Author:  [@nurlan](https://forums.percona.com/u/nurlan)
#### Post date: [May 3, 2025, 6:04am UTC](https://forums.percona.com/t/qan-does-not-show-the-postgresql-queries-with-full-table-scan/34819/7 "2025-05-03T06:04:48Z")
We don’t collect full scan from pgsm as well
---
### Author:  [@Naresh9999](https://forums.percona.com/u/Naresh9999)
#### Post date: [May 3, 2025, 6:27am UTC](https://forums.percona.com/t/qan-does-not-show-the-postgresql-queries-with-full-table-scan/34819/8 "2025-05-03T06:27:22Z")
Okay @nurlan got it.
Thanks for the update.