EXPLAIN/ANALYZE on Virtual Data Tables

Is there a possibility to get EXPLAIN/ ANALYZE output when defining VDT SQL queries based on POSTGRESQL Data Tables (OD’s internal PG, not via connection)? These would help to optimize Queries. Unfortunately, wrapping my SQL in an EXPLAIN results in an error in the preview. Since I have no direct access to the DB, I have no possibility to obtain performance data otherwise.

Hi Flogge, this is not possible. The SQL is executed as a subquery of another query that is generated by onedata-backend. What you would like to do would have to be implemented as a new feature.

1 Like