I want to get the query plan in Exasol database to check the total execution time, memory and cpu usage. Profiling in Exasol is so complex and difficult to understand.
- Is there any way to get the query plan like
explain analyze
in PostgreSQL or any other simple way? - Please explain how to read the query plan in Exasol without executing the query?
You can check the EXASOL User Manual about profiling a query. I agree it's a bit cumbersome :)
Or you can use the scripts I wrote to have an
explain
like command: exasol-explain