Hi, all,
We have running some complex queries using Trafodion, and need to analyze the
performance. One question is, if we want to know which part of the plan take
longest time, is there any good tool/skills to answer this?
I can use 'get statistics for qid <qid> default' to get runtime stats. But it
is rather hard to interpret the output. I assume the "Oper CPU Time" is the
best one we can trust? But I am not sure it is the pure CPU time, or it also
include 'waiting time'? If I want to know the whole time an operation from
start to end, is there any way?
And if it is CPU time, is it ns or something else, or just a relative number?
Here is an example output of 'get statistics'
LC RC Id PaId ExId Frag TDB Name DOP Dispatches
Oper CPU Time Est. Records Used Act. Records Used Details
12 . 13 . 7 0 EX_ROOT 1 1
69 0 0 1945
11 . 12 13 6 0 EX_SPLIT_TOP 1 1
32 99,550,560 0
10 . 11 12 6 0 EX_SEND_TOP 10 32
1,844 99,550,560 0
9 . 10 11 6 2 EX_SEND_BOTTOM 10 20
666 99,550,560 0
8 . 9 10 6 2 EX_SPLIT_BOTTOM 10 40
411 99,550,560 0 53670501
6 7 8 9 5 2 EX_TUPLE_FLOW 10 10
57 99,550,560 0
. . 7 8 4 2 EX_TRAF_LOAD_PREPARATION 10 0
0 1 0 TRAFODION.SEABASE.BLTEST|0|0
5 . 6 8 3 2 EX_SORT 10 316,410
40,033,167 99,550,560 0 0|15880|10
4 . 5 6 2 2 EX_SPLIT_TOP 10 316,411
559,691 99,550,560 5,690,184
3 . 4 5 2 2 EX_SEND_TOP 160 474,849
13,076,509 99,550,560 5,690,196
2 . 3 4 2 3 EX_SEND_BOTTOM 160 919,425
90,107,363 99,550,560 5,695,235
1 . 2 3 2 3 EX_SPLIT_BOTTOM 16 94,836
4,236,816 99,550,560 5,698,863 350792654
. . 1 2 1 3 EX_HDFS_SCAN 16 48,227
256,448,475 0 5,715,193
HIVE.BLTEST|5715193|1664264993
Thanks in advance.
Thanks,
Ming
