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

1

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
image1475×292 13 KB

image

2

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

3

Hi @nurlan

Thanks for the update.

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