CODEWITHSUNDEEP
sqlsql-execution-planexasolution
Arezoo
Arezoo

Reputation: 472

EXASOL Explain Analyse Query

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.

  1. Is there any way to get the query plan like explain analyze in PostgreSQL or any other simple way?
  2. Please explain how to read the query plan in Exasol without executing the query?

Upvotes: 2

Views: 1889

Answers (3)

Naor Bar
Naor Bar

Reputation: 2209

In Exasol, you can use set profile='ON', this will record your query's steps (plus CPU, Memory, Output Records etc.) in exa_user_profile_last_day table.

For more details, read this Exasol user guide - Profiling section

Upvotes: 0

Olga
Olga

Reputation: 1

Maybe it will be useful for someone who will try to use EXASOL Explain. There is a script with one missed field in select statement in exasol-explain/scripts/sqlprofile.lua, after temp_db_ram_peak field should follow:

max(PERSISTENT_DB_RAM_PEAK) as PERSISTENT_DB_RAM_PEAK

Otherwise "explain" and "explain_this" return an error "incorrect numbers of result column"

Upvotes: 0

mucio
mucio

Reputation: 7119

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

Upvotes: 1

Related Questions