Re: Convert query plan to sql query

From: Antonin Houska <ah(at)cybertec(dot)at>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Convert query plan to sql query
Date: 2014-11-05 07:58:31
Message-ID: 29579.1415174311@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

mariem <mariem(dot)benfadhel(at)gmail(dot)com> wrote:

> Hello,
>
> I would like to transform the query plan (output of the planner,
> debug_print_plan) into an sql query.

I don't think SQL can express the information the plan contains. For example,
join methods (hash, nest loop, merge).

--
Antonin Houska
Cybertec Schönig & Schönig GmbH
Gröhrmühlgasse 26
A-2700 Wiener Neustadt
Web: http://www.postgresql-support.de, http://www.cybertec.at

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kyotaro HORIGUCHI 2014-11-05 08:19:58 Re: alter user/role CURRENT_USER
Previous Message Amit Kapila 2014-11-05 07:06:17 Re: WAL format and API changes (9.5)