Re: Planner debug views - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Planner debug views
Date
Msg-id 20150803160043.GI2441@postgresql.org
Whole thread Raw
In response to Re: Planner debug views  (Qingqing Zhou <zhouqq.postgres@gmail.com>)
List pgsql-hackers
Qingqing Zhou wrote:
> On Thu, Jul 30, 2015 at 2:42 PM, Jim Nasby <Jim.Nasby@bluetreble.com> 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