Re: Hide 'Execution time' in EXPLAIN (COSTS OFF) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Hide 'Execution time' in EXPLAIN (COSTS OFF)
Date
Msg-id 6378.1413476398@sss.pgh.pa.us
Whole thread Raw
In response to Re: Hide 'Execution time' in EXPLAIN (COSTS OFF)  (Ronan Dunklau <ronan.dunklau@dalibo.com>)
List pgsql-hackers
Ronan Dunklau <ronan.dunklau@dalibo.com> writes:
> From my point of view as a FDW implementor, the feature I need is to have 
> EXPLAIN (COSTS ON) with stable output for foreign scan nodes.

Well, as long as the FDW's costing is exactly predictable, you can have
that ...

> In the Multicorn FDW (Python API on top of the C-API), we introduced this 
> commit to make the tests pass on 9.4:

> https://github.com/Kozea/Multicorn/commit/76decb360b822b57bf322892ed6c504ba44a8b28

> Clearly, we've lost the ability to test that the costs as set from the Python 
> API are indeed used. 

We did fix that yesterday.  The remaining argument is about whether it's
practical to get platform-independent output out of EXPLAIN ANALYZE.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Directory/File Access Permissions for COPY and Generic File Access Functions
Next
From: Ryan Johnson
Date:
Subject: Re: WIP: dynahash replacement for buffer table