#38 Support in EXPLAIN to show the plan of a data node

[Abbas Butt]

Currently in XC EXPLAIN shows the plan created by the coordinator. However some test cases in create_index.sql need to see plan created on data nodes. For example

SET enable_seqscan = OFF;
SET enable_indexscan = ON;
SET enable_bitmapscan = ON;
EXPLAIN (num_nodes off, nodes off, verbose on, COSTS OFF)
SELECT * FROM fast_emp4000
WHERE home_base @ '(200,200),(2000,1000)'::box
ORDER BY (home_base[0])[0];

Disabling sequence scan has no impact on the coordinator, however by being able to check the plan on the data nodes, we need to make sure the set parameters worked correctly.

[Koichi Suzuki]

Alternative is to use autoexplain.

[Koichi Suzuki]

EXECUTE DIRECT could be another workaround.