|Managing and Monitoring GemFire XD / Evaluating Query Execution Plans|
As an alternative to using the EXPLAIN command, you can use built-in system procedures to enable and disable query execution plan and statistics capture for all statements that you execute on a connection.
gfxd> connect peer 'host-data=false;mcast-port=12777';
gfxd> call SYSCS_UTIL.SET_EXPLAIN_CONNECTION(1);
gfxd> call SYSCS_UTIL.SET_STATISTICS_TIMING(1);
gfxd> call SYSCS_UTIL.SET_EXPLAIN_CONNECTION(0); gfxd> call SYSCS_UTIL.SET_STATISTICS_TIMING(0);
After you have captured query execution plans, you can use a peer client connection to query the captured plans.