# QAN PostgreSQL explain plan is not user friendly like MySQL or MariaDB

**URL:** <https://forums.percona.com/t/qan-postgresql-explain-plan-is-not-user-friendly-like-mysql-or-mariadb/31330>\
**Category:** Uncategorized\
**Created:** [July 1, 2024, 11:34am UTC](https://forums.percona.com/t/qan-postgresql-explain-plan-is-not-user-friendly-like-mysql-or-mariadb/31330 "2024-07-01T11:34:08Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Naresh9999](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/naresh9999/32/5568_2.png) [@Naresh9999](https://forums.percona.com/u/Naresh9999)\
**Post date:** [July 1, 2024, 11:34am UTC](https://forums.percona.com/t/qan-postgresql-explain-plan-is-not-user-friendly-like-mysql-or-mariadb/31330/1 "2024-07-01T11:34:08Z")

</div>

Hi Team,

We are only seeing the below in the PostgreSQL query to explain plan TAB. And Table not found error. Can we get explain plan like MariaDB, how many rows scanning whether index is being used or not.

 ![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/3X/7/7/772c3bbf10bec855d8fa812ace717e097e647d61.png)

![image](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/3X/6/e/6e710d521d426942ac45f9007e6cc2290be72e78.png)

---

<div class="post-metadata">

**Author:** ![nurlan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/nurlan/32/1523_2.png) [@nurlan](https://forums.percona.com/u/nurlan)\
**Post date:** [July 1, 2024, 12:47pm UTC](https://forums.percona.com/t/qan-postgresql-explain-plan-is-not-user-friendly-like-mysql-or-mariadb/31330/2 "2024-07-01T12:47:49Z")

</div>

Hello @Naresh9999,  
in both cases we are just returning the result we get from DB, that’s why they are different from each other.

Regards,  
Nurlan

---

<div class="post-metadata">

**Author:** ![Naresh9999](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/naresh9999/32/5568_2.png) [@Naresh9999](https://forums.percona.com/u/Naresh9999)\
**Post date:** [July 1, 2024, 3:34pm UTC](https://forums.percona.com/t/qan-postgresql-explain-plan-is-not-user-friendly-like-mysql-or-mariadb/31330/3 "2024-07-01T15:34:55Z")

</div>

Hi @nurlan

Thanks for the update.

Is there any better way that we can get that detailed information?