Re: Planner debug views - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Planner debug views
Date
Msg-id [email protected]
Whole thread Raw
In response to Re: Planner debug views  (Qingqing Zhou <[email protected]>)
List pgsql-hackers
Qingqing Zhou wrote:
> On Thu, Jul 30, 2015 at 2:42 PM, Jim Nasby <[email protected]> wrote:
> >
> > I think a better option would be shoving it into a backend tuplestore and
> > just leaving it there (maybe with a command to clear it for the paranoid).
> > That gives a relation you can query against, insert into another table, etc.
> 
> This is something I don't know how to do it: in my understanding, a
> tuplestore is an internal store, which means it has no name exposed.
> Thus we can't reference it later.

Yeah, that doesn't sound the kind of project you should attempt here.
EXPLAIN already knows to return tuples, so I was assuming you would
return your stuff using that mechanism.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-hackers by date:

Previous
From: Geoff Winkless
Date:
Subject: ON CONFLICT DO UPDATE using EXCLUDED.column gives an error about mismatched types
Next
From: Geoff Winkless
Date:
Subject: Re: ON CONFLICT DO UPDATE using EXCLUDED.column gives an error about mismatched types