Re: Convert query plan to sql query - Mailing list pgsql-hackers

From Antonin Houska
Subject Re: Convert query plan to sql query
Date
Msg-id 29579.1415174311@localhost
Whole thread Raw
In response to Convert query plan to sql query  (mariem <mariem.benfadhel@gmail.com>)
Responses Re: Convert query plan to sql query  (mariem <mariem.benfadhel@gmail.com>)
List pgsql-hackers
mariem <mariem.benfadhel@gmail.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



pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: WAL format and API changes (9.5)
Next
From: Anssi Kääriäinen
Date:
Subject: Re: tracking commit timestamps