From: | David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Is there a way to get both the plan and the results? |
Date: | 2014-10-01 18:40:18 |
Message-ID: | 1412188818430-5821315.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Melvin Davidson | 2014-10-01 19:52:36 | Re: Extract especific text from a sql statement |
Previous Message | François Beausoleil | 2014-10-01 17:46:30 | Is there a way to get both the plan and the results? |