Understanding teiid Query Plan

[varun09]

Hello All,

I am analyzing the the query plan generated in teiid, is there a way in which I can get the timing taken for the execution of the entire query

-Varun

[shawkins]

Getting the query plan at the end of execution will show the various node timings - have you seen Query Plans · Teiid Documentation ?

The root node will contain Node Cumulative Process Time and other stats that may be of interest.

Node Cumulative Process Time

[varun09]

Hie Steven,

Thanks for the answer !!!

I have gone through the query plan documentation and also generated a query plan for my query.

However in my query plan I did not get a root node, but I got the below nodes;

ProjectNode

GroupingNode

JoinNode

UnionAllNode

Access Node

Can you help me understand as to why I am not able to get the root node in my query plan ?

-Varun

[shawkins]

> Can you help me understand as to why I am not able to get the root node in my query plan ?

The root node is not a type of node, but the first one / top of the plan.  That contains the overall timings for the plan.