cloudberry icon indicating copy to clipboard operation
cloudberry copied to clipboard

Add guc gp_enable_explain_motion_detail to show sender time when Expl…

Open songdongxiaoa2 opened this issue 2 years ago • 1 comments

Show motion sender time when Explain Analyse.

When guc set, Explain Analyse result will be: actual time=<receive_start>..<receive_end>/<sender_start>..<sender_end>

gp_enable_explain_motion_detail defaults to off.


Change logs

QEs will now send Motion Sender instruments to QD. QD will collect two instruments(sender and receiver) to MotionPlanState->instruments[].
Add guc gp_enable_explain_motion_detail to show sender time. Add test cases.

Why are the changes needed?

In plan on QD, Motion is a single node, so we need an array of two to collect both sender and receiver instruments. Add guc to show this information only when needed.

Does this PR introduce any user-facing change?

Yes, the guc gp_enable_explain_motion_detail default to off. Show sending time by: set gp_enable_explain_motion_detail to on in client.

How was this patch tested?

Added icw test case and passed in local.

Contributor's Checklist

songdongxiaoa2 avatar Dec 29 '23 02:12 songdongxiaoa2

CLA assistant check
All committers have signed the CLA.

CLAassistant avatar Dec 29 '23 02:12 CLAassistant

Close the PR since no response for a long time.

my-ship-it avatar Aug 26 '24 06:08 my-ship-it