Is it possible to get
EXPLAIN ANALYZE output (e.g. as a notice) in addition to the regular query output?
I am designing a postgresql client and I would like to add a feature that automatically turns all queries into
EXPLAIN ANALYZE for the purpose of tracking query execution time, seq scan, etc. However, such feature would require that I am able to obtain the regular query output in addition to the
EXPLAIN ANALYZE output.
How to get query output in addition to
EXPLAIN ANALYZE output?
Note: I am aware of
auto_explain. However, there appears to be no way to access logs from the client for the last executed statement.