Re: Is there a way to get both the plan and the results?

François Beausoleil wrote
> Hi all!
>
> Building a small tool, and it would be super useful if I could get both
> the query results and the plan at the same time. At the moment, the tool
> accepts a SQL query, drops it into a file and call psql
> --file=whatever.sql. I can change to use a lower-level API if necessary.
>
> Ideally, I’d like to do something like EXLAIN (ANALYZE, RESULTS) SELECT
> ...
>
> I’m talking about multi-minute queries, so it’s less than ideal if I have
> to run the query twice: once for EXPLAIN ANALYZE, once for the actual
> results.
>
> Looking around,
> https://duckduckgo.com/?q=postgresql+get+query+results+and+query+plan+in+single+call
> doesn’t return anything useful. Google neither, for that matter. The PG
> mailing list archives seem to not have any results on that.
>
> I’m specifically using 9.1. Not opposed to upgrade if necessary.

See:

http://www.postgresql.org/docs/9.1/static/auto-explain.html

There is no way to do so from a client interface.

David J.




--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Is-there-a-way-to-get-both-the-plan-and-the-results-tp5821313p5821315.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.