Can I run an "explain analyze" on a query using JOOQ?

Question

Can I run explain analyze on a query in JOOQ? like:

explain analyse select some, columns from some_table

but do it using JOOQ on PostgreSQL database?

I have found an interface org.jooq.Explain, with a method DSLContext.explain​(Query query) - but it seems just to use EXPLAIN on a query:

@Support({AURORA_MYSQL,AURORA_POSTGRES,H2,HSQLDB,MARIADB,MEMSQL,MYSQL,ORACLE,POSTGRES,SQLITE}) 
Explain explain​(Query query)
Run an EXPLAIN statement in the database to estimate the cardinality of the query.

Is there any sensible way to run an EXPLAIN ANALYZE on the database from the code side?

Answer 1

It's not supported yet: https://github.com/jOOQ/jOOQ/issues/10424. Use plain SQL templating, instead:

ctx.fetch("explain analyze {0}", select);