Expose the connected DB EXPLAIN results

[iziks]

In the company I work in, we connect trino to Postgres operational DBs (replicas) in order to let developers and analysts access the data (some of it is masked).
There is a need (especially from developers who wants to optimize their queries) to view in the trino the out of EXPLAIN (ANALYZE) result of a query as if it was running directly on the Postgres.
Any chance to develop it or any hack you kbnow how to implement it already?
Thanks :)

[guyco33]

Maybe it can be implemented as a new table function or be supported in the current system.query function

[iziks]

Actually, that was my thought too :)