Should you investigate a Dremio issue, you can enable Support Key
planner.verbose_profile for example, in order to provide more details on planning steps.
Instead of enabling it for the full cluster, you can run in a session via the ui by running an alter session command before your run the query you want to investigate.
The profile generated for investigation will have verbose enabled, but if you opt to download the data within the same ui framework, it will not have verbose enabled.
All versions post Dremio 23
Run the following ALTER SESSION in a later Dremio release where multi statement is possible:
alter session set planner.verbose_profile=true;
select * from sys.options;
Now, if you choose to download the data within the SQL Runner, you will find that Dremio re-runs the query, with no ALTER SESSION being applied.
This is being reported in Jira DX-67228