Re: return text from explain
| От | Willy-Bas Loos |
|---|---|
| Тема | Re: return text from explain |
| Дата | |
| Msg-id | CAHnozThGwTJUi6NxynVP8pNWmycidoz2BVtQxBgjv_eqFPVkvQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | return text from explain (Willy-Bas Loos <willybas@gmail.com>) |
| Список | pgsql-general |
correction.
What won't work is:
select y||'--some text'
from
(
explain select *
from (values (1),(2), (3)) foo(x)
where x > 2
) bar(y)
Cheers,
WBL
--
"Quality comes from focus and clarity of purpose" -- Mark Shuttleworth
What won't work is:
select y||'--some text'
from
(
explain select *
from (values (1),(2), (3)) foo(x)
where x > 2
) bar(y)
Cheers,
WBL
On Thu, Sep 6, 2012 at 7:18 PM, Willy-Bas Loos <willybas@gmail.com> wrote:
Hi,
Is it possible to use the output of explain as text values?
This won't work:
explain select *
from (values (1),(2),(3)) foo(x)
where x > 2
What i really want is to explain analyze a dynamic query that i build up in a function.
If it returns a value i can do stuff with it, but i can't find out how to grasp the query plan as a value.
pgAdmin shows it as text values in the data output tab, but that might be a hack outside the database realm.
Cheers,
WBL
--
"Quality comes from focus and clarity of purpose" -- Mark Shuttleworth
--
"Quality comes from focus and clarity of purpose" -- Mark Shuttleworth
В списке pgsql-general по дате отправления: