You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by se...@apache.org on 2017/01/11 14:54:59 UTC
[1/6] incubator-trafodion git commit: [TRAFODION-2259] Add TopN stats
counter and realign BMO stats.
Repository: incubator-trafodion
Updated Branches:
refs/heads/master 73446d89f -> 8c7ff9a4e
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/271a5d0e/core/sql/regress/core/FILTERRTS
----------------------------------------------------------------------
diff --git a/core/sql/regress/core/FILTERRTS b/core/sql/regress/core/FILTERRTS
index 0e0224b..9c97d13 100755
--- a/core/sql/regress/core/FILTERRTS
+++ b/core/sql/regress/core/FILTERRTS
@@ -86,6 +86,9 @@ s/8 EX_HASH_GRBY[A-Z ]*\n[0-9, -]*/8 #ex_hash_grby bmoStats/
/bmoStats[ ]*/{N
s/bmoStats[ ]*\n[0-9, -]*/@bmoStats@/
}
+/6 EX_HASH_GRBY[A-Z ]*/{N
+s/6 EX_HASH_GRBY[A-Z ]*[0-9, -]*\n[0-9, -]*/6 #ex_hash_grby bmoStats/
+}
s/EX_ROOT[ ]*[0-9, |]*/EX_ROOT @exRootCounters@/
s/EX_SPLIT_TOP[ ]*[0-9, |]*/EX_SPLIT_TOP @exSplitTopCounters@/
s/EX_SPLIT_BOTTOM[ ]*[0-9, |]*/EX_SPLIT_BOTTOM @exSplitBottomCounters@/
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/271a5d0e/core/sql/sort/CommonStructs.h
----------------------------------------------------------------------
diff --git a/core/sql/sort/CommonStructs.h b/core/sql/sort/CommonStructs.h
index d400286..51f7e6e 100644
--- a/core/sql/sort/CommonStructs.h
+++ b/core/sql/sort/CommonStructs.h
@@ -113,6 +113,11 @@ enum ScratchOverflowMode
SCRATCH_MMAP
};
+enum SortMode
+{
+ SORTMODE_HEAP = 0,
+ SORTMODE_TOPN = 1
+};
#endif
[3/6] incubator-trafodion git commit: [TRAFODION-2259] Add TopN stats
counter and realign BMO stats.
Posted by se...@apache.org.
[TRAFODION-2259] Add TopN stats counter and realign BMO stats.
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/271a5d0e
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/271a5d0e
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/271a5d0e
Branch: refs/heads/master
Commit: 271a5d0e656dc467453381416c261dda5c3411b0
Parents: 548a193
Author: Prashant Vasudev <pr...@esgyn.com>
Authored: Mon Jan 9 21:07:18 2017 +0000
Committer: Prashant Vasudev <pr...@esgyn.com>
Committed: Mon Jan 9 21:07:18 2017 +0000
----------------------------------------------------------------------
core/sql/cli/sqlcli.h | 3 +-
core/sql/executor/ExExeUtilGetStats.cpp | 133 ++-
core/sql/executor/ExStats.cpp | 39 +-
core/sql/executor/ExStats.h | 9 +-
core/sql/executor/ex_sort.cpp | 6 +
core/sql/regress/core/EXPECTEDRTS | 1407 +++++++++++++-------------
core/sql/regress/core/FILTERRTS | 3 +
core/sql/sort/CommonStructs.h | 5 +
8 files changed, 859 insertions(+), 746 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/271a5d0e/core/sql/cli/sqlcli.h
----------------------------------------------------------------------
diff --git a/core/sql/cli/sqlcli.h b/core/sql/cli/sqlcli.h
index fe13abd..342348e 100644
--- a/core/sql/cli/sqlcli.h
+++ b/core/sql/cli/sqlcli.h
@@ -1231,7 +1231,8 @@ enum SQLSTATS_ITEM_ID {
SQLSTATS_REPL_TOTAL_UNCOMPRESS_BYTES = 241,
SQLSTATS_REPL_CONCURRENCY = 242,
SQLSTATS_REPL_COMPLETED_PARTNS = 243,
- SQLSTATS_REPL_BLOCKS_READ = 244
+ SQLSTATS_REPL_BLOCKS_READ = 244,
+ SQLSTATS_TOPN = 245
};
typedef struct {
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/271a5d0e/core/sql/executor/ExExeUtilGetStats.cpp
----------------------------------------------------------------------
diff --git a/core/sql/executor/ExExeUtilGetStats.cpp b/core/sql/executor/ExExeUtilGetStats.cpp
index 4b6c698..76b605b 100644
--- a/core/sql/executor/ExExeUtilGetStats.cpp
+++ b/core/sql/executor/ExExeUtilGetStats.cpp
@@ -2351,8 +2351,8 @@ short ExExeUtilGetRTSStatisticsTcb::work()
measStatsItems_[22].statsItem_id = SQLSTATS_SCRATCH_BUFFER_BLOCKS_WRITTEN;
measStatsItems_[23].statsItem_id = SQLSTATS_SCRATCH_READ_COUNT;
measStatsItems_[24].statsItem_id = SQLSTATS_SCRATCH_WRITE_COUNT;
-
- // maxMeasStatsItems_ is set to 25
+ measStatsItems_[25].statsItem_id = SQLSTATS_TOPN;
+ // maxMeasStatsItems_ is set to 26
}
else
initSqlStatsItems(measStatsItems_, maxMeasStatsItems_, TRUE);
@@ -2496,6 +2496,12 @@ short ExExeUtilGetRTSStatisticsTcb::work()
str_sprintf(statsBuf_, "%25s%s", "Scr. Overflow Mode",
ExBMOStats::getScratchOverflowMode((Int16)measStatsItems_[i].int64_value));
break;
+ case SQLSTATS_TOPN:
+ str_sprintf(Int64Val, "%Ld", measStatsItems_[i].int64_value);
+ intSize = str_len(Int64Val);
+ AddCommas(Int64Val,intSize);
+ str_sprintf(statsBuf_, "%25s%s", "Sort TopN", Int64Val);
+ break;
case SQLSTATS_SCRATCH_FILE_COUNT:
str_sprintf(Int64Val, "%Ld", measStatsItems_[i].int64_value);
intSize = str_len(Int64Val);
@@ -2546,7 +2552,7 @@ short ExExeUtilGetRTSStatisticsTcb::work()
{
if (rootOperStatsItems_ == NULL)
{
- maxRootOperStatsItems_ = 23;
+ maxRootOperStatsItems_ = 24;
rootOperStatsItems_ = new (getGlobals()->getDefaultHeap())
SQLSTATS_ITEM[maxRootOperStatsItems_];
initSqlStatsItems(rootOperStatsItems_, maxRootOperStatsItems_, FALSE);
@@ -2573,7 +2579,8 @@ short ExExeUtilGetRTSStatisticsTcb::work()
rootOperStatsItems_[20].statsItem_id = SQLSTATS_SCRATCH_BUFFER_BLOCKS_WRITTEN;
rootOperStatsItems_[21].statsItem_id = SQLSTATS_SCRATCH_READ_COUNT;
rootOperStatsItems_[22].statsItem_id = SQLSTATS_SCRATCH_WRITE_COUNT;
- // maxRootOperStatsItems_ is set to 23
+ rootOperStatsItems_[23].statsItem_id = SQLSTATS_TOPN;
+ // maxRootOperStatsItems_ is set to 24
}
else
initSqlStatsItems(rootOperStatsItems_, maxRootOperStatsItems_, TRUE);
@@ -2690,6 +2697,15 @@ short ExExeUtilGetRTSStatisticsTcb::work()
else
continue;
break;
+ case SQLSTATS_TOPN:
+ if (statsMergeType != SQLCLI_PROGRESS_STATS)
+ {
+ formatWInt64( rootOperStatsItems_[i], Int64Val);
+ str_sprintf(statsBuf_, "%25s%s", "Sort TopN", Int64Val);
+ }
+ else
+ continue;
+ break;
case SQLSTATS_SCRATCH_FILE_COUNT:
if (statsMergeType != SQLCLI_PROGRESS_STATS)
{
@@ -3198,28 +3214,30 @@ short ExExeUtilGetRTSStatisticsTcb::work()
{
if (bmoStatsItems_ == NULL)
{
- maxBMOStatsItems_ = 15;
+ maxBMOStatsItems_ = 16;
bmoStatsItems_ = new (getGlobals()->getDefaultHeap())
SQLSTATS_ITEM[maxBMOStatsItems_];
initSqlStatsItems(bmoStatsItems_, maxBMOStatsItems_, FALSE);
bmoStatsItems_[0].statsItem_id = SQLSTATS_TDB_ID;
bmoStatsItems_[1].statsItem_id = SQLSTATS_TDB_NAME;
bmoStatsItems_[2].statsItem_id = SQLSTATS_SCRATCH_OVERFLOW_MODE;
+ bmoStatsItems_[3].statsItem_id = SQLSTATS_TOPN;
//bmoStatsItems_[3].statsItem_id = SQLSTATS_OVERFLOW_PHASE;
//bmoStatsItems_[4].statsItem_id = SQLSTATS_OVEFLOW_PHASE_STARTTIME;
- bmoStatsItems_[3].statsItem_id = SQLSTATS_OPER_CPU_TIME;
- bmoStatsItems_[4].statsItem_id = SQLSTATS_BMO_HEAP_USED;
- bmoStatsItems_[5].statsItem_id = SQLSTATS_BMO_HEAP_ALLOC;
- bmoStatsItems_[6].statsItem_id = SQLSTATS_BMO_HEAP_WM;
- bmoStatsItems_[7].statsItem_id = SQLSTATS_BMO_SPACE_BUFFER_SIZE;
- bmoStatsItems_[8].statsItem_id = SQLSTATS_BMO_SPACE_BUFFER_COUNT;
- bmoStatsItems_[9].statsItem_id = SQLSTATS_SCRATCH_FILE_COUNT;
- bmoStatsItems_[10].statsItem_id = SQLSTATS_SCRATCH_BUFFER_BLOCK_SIZE;
- bmoStatsItems_[11].statsItem_id = SQLSTATS_SCRATCH_BUFFER_BLOCKS_READ;
- bmoStatsItems_[12].statsItem_id = SQLSTATS_SCRATCH_BUFFER_BLOCKS_WRITTEN;
- bmoStatsItems_[13].statsItem_id = SQLSTATS_SCRATCH_READ_COUNT;
- bmoStatsItems_[14].statsItem_id = SQLSTATS_SCRATCH_WRITE_COUNT;
- // maxBMOStatsItems_ is set to 15
+ bmoStatsItems_[4].statsItem_id = SQLSTATS_OPER_CPU_TIME;
+ bmoStatsItems_[5].statsItem_id = SQLSTATS_SCRATCH_FILE_COUNT;
+ bmoStatsItems_[6].statsItem_id = SQLSTATS_BMO_HEAP_USED;
+ bmoStatsItems_[7].statsItem_id = SQLSTATS_BMO_HEAP_ALLOC;
+ bmoStatsItems_[8].statsItem_id = SQLSTATS_BMO_HEAP_WM;
+ bmoStatsItems_[9].statsItem_id = SQLSTATS_BMO_SPACE_BUFFER_SIZE;
+ bmoStatsItems_[10].statsItem_id = SQLSTATS_BMO_SPACE_BUFFER_COUNT;
+ bmoStatsItems_[11].statsItem_id = SQLSTATS_SCRATCH_BUFFER_BLOCK_SIZE;
+ bmoStatsItems_[12].statsItem_id = SQLSTATS_SCRATCH_BUFFER_BLOCKS_READ;
+ bmoStatsItems_[13].statsItem_id = SQLSTATS_SCRATCH_BUFFER_BLOCKS_WRITTEN;
+ bmoStatsItems_[14].statsItem_id = SQLSTATS_SCRATCH_READ_COUNT;
+ bmoStatsItems_[15].statsItem_id = SQLSTATS_SCRATCH_WRITE_COUNT;
+
+ // maxBMOStatsItems_ is set to 16
// TDB_NAME
bmoStatsItems_[1].str_value = new (getGlobals()->getDefaultHeap())
char[MAX_TDB_NAME_LEN+1];
@@ -3255,11 +3273,20 @@ short ExExeUtilGetRTSStatisticsTcb::work()
if ((qparent_.up->getSize() - qparent_.up->getLength()) < 4)
return WORK_CALL_AGAIN;
moveRowToUpQueue(" ");
- str_sprintf(statsBuf_, "%5s %35s%5s%-19s%-15s%-15s%-15s%-17s%-17s%-12s%-45s %s",
- " Id", "TDB Name", "Mode", "CPU Time",
- "BMO Heap Used", "BMO Heap Total", "BMO Heap WM", "BMO Space BufSz","BMO Space BufCnt",
- "File Count", "Scratch Buffer Block Size/Read/Written",
- "Scratch IO Count Read/Written");
+
+ str_sprintf(statsBuf_, "%-5s%-17s%-20s%-20s%-20s%-20s%",
+ "Id", "TDB Name", "Mode", "TopN", "CPU Time","File Count");
+ moveRowToUpQueue(statsBuf_);
+
+ str_sprintf(statsBuf_, "%-22s%-20s%-20s%-20s%-20s%",
+ "BMO Heap Used", "BMO Heap Total", "BMO Heap WM",
+ "BMO Space BufSz","BMO Space BufCnt");
+ moveRowToUpQueue(statsBuf_);
+
+ str_sprintf(statsBuf_, "%-22s%-20s%-20s%-20s%-20s%",
+ "ScrBlk Size",
+ "ScrBlk Read", "ScrBlk Written", "ScrIO Read", "ScrIO Written");
+
moveRowToUpQueue(statsBuf_);
isBMOHeadingDisplayed_ = TRUE;
step_ = FORMAT_AND_RETURN_BMO_STATS_;
@@ -3275,16 +3302,37 @@ short ExExeUtilGetRTSStatisticsTcb::work()
switch (bmoStatsItems_[i].statsItem_id)
{
case SQLSTATS_TDB_ID:
- str_sprintf(statsBuf_, "%5Ld", bmoStatsItems_[i].int64_value);
+ str_sprintf(statsBuf_, "%-5Ld", bmoStatsItems_[i].int64_value);
break;
case SQLSTATS_TDB_NAME:
bmoStatsItems_[i].str_value[bmoStatsItems_[i].str_ret_len] = '\0';
- str_sprintf(&statsBuf_[strlen(statsBuf_)], " %35s", bmoStatsItems_[i].str_value);
+ str_sprintf(&statsBuf_[strlen(statsBuf_)], "%-17s", bmoStatsItems_[i].str_value);
break;
case SQLSTATS_SCRATCH_OVERFLOW_MODE:
- str_sprintf(&statsBuf_[strlen(statsBuf_)], "%5s",
+ str_sprintf(&statsBuf_[strlen(statsBuf_)], "%-20s",
ExBMOStats::getScratchOverflowMode((Int16) bmoStatsItems_[i].int64_value));
break;
+ case SQLSTATS_TOPN:
+ str_sprintf(Int64Val, "%Ld", bmoStatsItems_[i].int64_value);
+ intSize = str_len(Int64Val);
+ AddCommas(Int64Val,intSize);
+ str_sprintf(&statsBuf_[strlen(statsBuf_)], "%-20s", Int64Val);
+ break;
+ case SQLSTATS_OPER_CPU_TIME:
+ str_sprintf(Int64Val, "%Ld", bmoStatsItems_[i].int64_value);
+ intSize = str_len(Int64Val);
+ AddCommas(Int64Val,intSize);
+ str_sprintf(&statsBuf_[strlen(statsBuf_)], "%-20s", Int64Val);
+ break;
+ case SQLSTATS_SCRATCH_FILE_COUNT:
+ str_sprintf(Int64Val, "%Ld", bmoStatsItems_[i].int64_value);
+ intSize = str_len(Int64Val);
+ AddCommas(Int64Val,intSize);
+ str_sprintf(&statsBuf_[strlen(statsBuf_)], "%-20s", Int64Val);
+ if (moveRowToUpQueue(statsBuf_, strlen(statsBuf_), &rc) == -1)
+ return rc;
+ break;
+/*
case SQLSTATS_OVERFLOW_PHASE:
bmoStatsItems_[i].str_value[bmoStatsItems_[i].str_ret_len] = '\0';
str_sprintf(&statsBuf_[strlen(statsBuf_)], "%12s", bmoStatsItems_[i].str_value);
@@ -3303,72 +3351,63 @@ short ExExeUtilGetRTSStatisticsTcb::work()
timestamp[3], timestamp[4], timestamp[5]);
}
break;
+*/
case SQLSTATS_BMO_HEAP_USED:
str_sprintf(Int64Val, "%Ld", bmoStatsItems_[i].int64_value);
intSize = str_len(Int64Val);
AddCommas(Int64Val,intSize);
- str_sprintf(&statsBuf_[strlen(statsBuf_)], "%-15s", Int64Val);
+ str_sprintf(statsBuf_, "%-22s", Int64Val);
break;
case SQLSTATS_BMO_HEAP_ALLOC:
case SQLSTATS_BMO_HEAP_WM:
str_sprintf(Int64Val, "%Ld", bmoStatsItems_[i].int64_value);
intSize = str_len(Int64Val);
AddCommas(Int64Val,intSize);
- str_sprintf(&statsBuf_[strlen(statsBuf_)], "%-15s", Int64Val);
+ str_sprintf(&statsBuf_[strlen(statsBuf_)], "%-20s", Int64Val);
break;
case SQLSTATS_BMO_SPACE_BUFFER_SIZE:
str_sprintf(Int64Val, "%Ld", bmoStatsItems_[i].int64_value);
intSize = str_len(Int64Val);
AddCommas(Int64Val,intSize);
- str_sprintf(&statsBuf_[strlen(statsBuf_)], "%-17s", Int64Val);
+ str_sprintf(&statsBuf_[strlen(statsBuf_)], "%-20s", Int64Val);
break;
case SQLSTATS_BMO_SPACE_BUFFER_COUNT:
str_sprintf(Int64Val, "%Ld", bmoStatsItems_[i].int64_value);
intSize = str_len(Int64Val);
AddCommas(Int64Val,intSize);
- str_sprintf(&statsBuf_[strlen(statsBuf_)], "%-17s", Int64Val);
- break;
- case SQLSTATS_SCRATCH_FILE_COUNT:
- str_sprintf(Int64Val, "%Ld", bmoStatsItems_[i].int64_value);
- intSize = str_len(Int64Val);
- AddCommas(Int64Val,intSize);
- str_sprintf(&statsBuf_[strlen(statsBuf_)], "%-12s", Int64Val);
+ str_sprintf(&statsBuf_[strlen(statsBuf_)], "%-20s", Int64Val);
+ if (moveRowToUpQueue(statsBuf_, strlen(statsBuf_), &rc) == -1)
+ return rc;
break;
case SQLSTATS_SCRATCH_BUFFER_BLOCK_SIZE:
str_sprintf(Int64Val, "%Ld", bmoStatsItems_[i].int64_value);
intSize = str_len(Int64Val);
AddCommas(Int64Val,intSize);
- str_sprintf(&statsBuf_[strlen(statsBuf_)], "%-10s", Int64Val);
+ str_sprintf(statsBuf_, "%-22s", Int64Val);
break;
case SQLSTATS_SCRATCH_BUFFER_BLOCKS_READ:
str_sprintf(Int64Val, "%Ld", bmoStatsItems_[i].int64_value);
intSize = str_len(Int64Val);
AddCommas(Int64Val,intSize);
- str_sprintf(&statsBuf_[strlen(statsBuf_)], "%-19s", Int64Val);
+ str_sprintf(&statsBuf_[strlen(statsBuf_)], "%-20s", Int64Val);
break;
case SQLSTATS_SCRATCH_BUFFER_BLOCKS_WRITTEN:
str_sprintf(Int64Val, "%Ld", bmoStatsItems_[i].int64_value);
intSize = str_len(Int64Val);
AddCommas(Int64Val,intSize);
- str_sprintf(&statsBuf_[strlen(statsBuf_)], "%-19s", Int64Val);
- break;
- case SQLSTATS_OPER_CPU_TIME:
- str_sprintf(Int64Val, "%Ld", bmoStatsItems_[i].int64_value);
- intSize = str_len(Int64Val);
- AddCommas(Int64Val,intSize);
- str_sprintf(&statsBuf_[strlen(statsBuf_)], "%-19s", Int64Val);
+ str_sprintf(&statsBuf_[strlen(statsBuf_)], "%-20s", Int64Val);
break;
case SQLSTATS_SCRATCH_READ_COUNT:
str_sprintf(Int64Val, "%Ld", bmoStatsItems_[i].int64_value);
intSize = str_len(Int64Val);
AddCommas(Int64Val,intSize);
- str_sprintf(&statsBuf_[strlen(statsBuf_)], "%-19s", Int64Val);
+ str_sprintf(&statsBuf_[strlen(statsBuf_)], "%-20s", Int64Val);
break;
case SQLSTATS_SCRATCH_WRITE_COUNT:
str_sprintf(Int64Val, "%Ld", bmoStatsItems_[i].int64_value);
intSize = str_len(Int64Val);
AddCommas(Int64Val,intSize);
- str_sprintf(&statsBuf_[strlen(statsBuf_)], "%-19s", Int64Val);
+ str_sprintf(&statsBuf_[strlen(statsBuf_)], "%-20s", Int64Val);
if (moveRowToUpQueue(statsBuf_, strlen(statsBuf_), &rc) == -1)
return rc;
break;
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/271a5d0e/core/sql/executor/ExStats.cpp
----------------------------------------------------------------------
diff --git a/core/sql/executor/ExStats.cpp b/core/sql/executor/ExStats.cpp
index 43d2b50..6031198 100644
--- a/core/sql/executor/ExStats.cpp
+++ b/core/sql/executor/ExStats.cpp
@@ -1585,6 +1585,7 @@ void ExFragRootOperStats::init()
scratchWriteCount_ = 0;
scratchReadCount_ = 0;
udrCpuTime_ = 0;
+ topN_ = -1;
waitTime_ = 0;
maxWaitTime_ = 0;
diffCpuTime_ = 0;
@@ -1773,6 +1774,8 @@ void ExFragRootOperStats::merge(ExFragRootOperStats* other)
scratchReadCount_ += other->scratchReadCount_;
scratchWriteCount_ += other->scratchWriteCount_;
udrCpuTime_ += other->udrCpuTime_;
+ if(topN_ == -1 && other->topN_ > 0)
+ topN_ = other->topN_;
// Remember, don't merge or copy executionCount_ !
waitTime_ += other->waitTime_;
if (other->maxWaitTime_ > maxWaitTime_)
@@ -1810,6 +1813,9 @@ void ExFragRootOperStats::merge(ExBMOStats *other)
scratchReadCount_ += other->scratchReadCount_;
scratchWriteCount_ += other->scratchWriteCount_;
+ if(topN_ == -1 && other->topN_ > 0)
+ topN_ = other->topN_;
+
#endif
}
@@ -1945,7 +1951,7 @@ void ExFragRootOperStats::getVariableStatsInfo(char * dataBuffer,
"SpaceUsed: %u SpaceTotal: %u HeapUsed: %u HeapTotal: %u "
"Newprocess: %u NewprocessTime: %Ld reqMsgCnt: %Ld "
"regMsgBytes: %Ld replyMsgCnt: %Ld replyMsgBytes: %Ld "
- "PMemUsed: %Ld scrOverFlowMode: %d "
+ "PMemUsed: %Ld scrOverFlowMode: %d sortMode: %d"
"scrFileCount: %d scrBufferBlockSize: %d scrBuffferRead: %Ld scrBufferWritten: %Ld "
"scrWriteCount:%Ld scrReadCount: %Ld udrCpuTime: %Ld "
"maxWaitTime: %Ld avgWaitTime: %Ld "
@@ -1973,6 +1979,7 @@ void ExFragRootOperStats::getVariableStatsInfo(char * dataBuffer,
scratchWriteCount_,
scratchReadCount_,
udrCpuTime_,
+ topN_,
maxWaitTime_,
getAvgWaitTime(),
(hdfsAccess() ? 1 : 0)
@@ -2053,6 +2060,9 @@ Lng32 ExFragRootOperStats::getStatsItem(SQLSTATS_ITEM* sqlStats_item)
case SQLSTATS_SCRATCH_OVERFLOW_MODE:
sqlStats_item->int64_value = scratchOverflowMode_;
break;
+ case SQLSTATS_TOPN:
+ sqlStats_item->int64_value = topN_;
+ break;
case SQLSTATS_SCRATCH_BUFFER_BLOCK_SIZE:
sqlStats_item->int64_value = scratchBufferBlockSize_;
break;
@@ -4820,6 +4830,7 @@ void ExMeasStats::init()
scratchWriteCount_ = 0;
scratchReadCount_ = 0;
udrCpuTime_ = 0;
+ topN_ = -1;
#endif
}
@@ -4831,7 +4842,7 @@ void ExMeasStats::merge(ExFragRootOperStats* other)
maxHeapUsage_ += other -> maxHeapUsage_;
maxHeapAlloc_ += other -> maxHeapAlloc_;
if (scratchOverflowMode_ == -1)
- scratchOverflowMode_ = other->scratchOverflowMode_;
+ scratchOverflowMode_ = other->scratchOverflowMode_;
#ifndef __EID
cpuTime_ += other -> cpuTime_;
newprocess_ += other -> newprocess_;
@@ -4864,7 +4875,6 @@ void ExMeasStats::merge(ExBMOStats *other)
#ifndef __EID
scratchFileCount_ += other->scratchFileCount_;
scratchOverflowMode_ = other->scratchOverflowMode_;
-
if (scratchBufferBlockSize_ == 0 &&
other->scratchBufferBlockSize_ > 0)
scratchBufferBlockSize_ = other->scratchBufferBlockSize_;
@@ -4876,6 +4886,9 @@ void ExMeasStats::merge(ExBMOStats *other)
scratchReadCount_ += other->scratchReadCount_;
scratchWriteCount_ += other->scratchWriteCount_;
+ if (topN_ == -1 && other->topN_ > 0)
+ topN_ = other->topN_;
+
#endif
}
@@ -4936,6 +4949,9 @@ void ExMeasStats::merge(ExMeasStats* other)
scratchReadCount_ += other->scratchReadCount_;
scratchWriteCount_ += other->scratchWriteCount_;
udrCpuTime_ += other->udrCpuTime_;
+ if (topN_ == -1 && other->topN_ > 0)
+ topN_ = other->topN_;
+
#endif
}
@@ -5044,6 +5060,7 @@ void ExMeasStats::copyContents(ExMeasStats *other)
scratchReadCount_ = other->scratchReadCount_;
scratchWriteCount_ = other->scratchWriteCount_;
udrCpuTime_ = other->udrCpuTime_;
+ topN_ = other->topN_;
#endif
}
}
@@ -5108,7 +5125,7 @@ void ExMeasStats::getVariableStatsInfo(char * dataBuffer, char * datalen,
"reqMsgCnt: %Ld reqMsgBytes: %Ld replyMsgCnt: %Ld "
"replyMsgBytes: %Ld scrOverflowMode: %d "
"scrFileCount: %d scrBufferBlockSize: %d scrBufferRead: %Ld scrBufferWritten: %Ld "
- "scrWriteCount: %Ld scrReadCount: %Ld udrCpuTime: %Ld ",
+ "scrWriteCount: %Ld scrReadCount: %Ld udrCpuTime: %Ld topN: %Ld",
statType(),
getNewprocess(),
getNewprocessTime(),
@@ -5131,7 +5148,8 @@ void ExMeasStats::getVariableStatsInfo(char * dataBuffer, char * datalen,
scratchBufferBlockWritten_,
scratchWriteCount_,
scratchReadCount_,
- udrCpuTime_
+ udrCpuTime_,
+ topN_
);
}
buf += str_len(buf);
@@ -10663,6 +10681,7 @@ void ExBMOStats::init()
scratchBufferBlockWritten_ = 0;
scratchReadCount_ = 0;
scratchWriteCount_ = 0;
+ topN_ = -1;
}
UInt32 ExBMOStats::packedLength()
@@ -10760,7 +10779,7 @@ void ExBMOStats::getVariableStatsInfo(char * dataBuffer,
"statsRowType: %d explainTdbId: %d bmoHeapUsed: %d bmoHeapTotal: %d bmoHeapWM: %d "
"bmoSpaceBufferSize: %d bmoSpaceBufferCount: %d OFPhase: %s OFPhaseStartTime: %Ld "
"scrOverFlowMode: %d scrFileCount: %d scrBufferBlockSize: %d scrBuffferRead: %d scrBufferWritten: %d "
- "scrWriteCount: %Ld scrReadCount: %Ld ",
+ "scrWriteCount: %Ld scrReadCount: %Ld topN: %Ld",
statType(),
getExplainNodeId(),
bmoHeapUsage_,
@@ -10776,7 +10795,8 @@ void ExBMOStats::getVariableStatsInfo(char * dataBuffer,
scratchBufferBlockRead_,
scratchBufferBlockWritten_,
scratchWriteCount_,
- scratchReadCount_
+ scratchReadCount_,
+ topN_
);
buf += str_len(buf);
*(short*)dataLen = (short) (buf - dataBuffer);
@@ -10801,6 +10821,8 @@ void ExBMOStats::merge(ExBMOStats* other)
str_cpy_all(overflowPhase_, other->overflowPhase_, str_len(other->overflowPhase_)+1);
if (other->scratchBufferBlockSize_ != -1)
scratchBufferBlockSize_ = other->scratchBufferBlockSize_;
+ if (other->topN_ != -1)
+ topN_ = other->topN_;
scratchOverflowMode_ = other->scratchOverflowMode_;
scratchFileCount_ += other->scratchFileCount_;
scratchBufferBlockRead_ += other->scratchBufferBlockRead_;
@@ -10851,6 +10873,9 @@ Lng32 ExBMOStats::getStatsItem(SQLSTATS_ITEM* sqlStats_item)
case SQLSTATS_SCRATCH_OVERFLOW_MODE:
sqlStats_item->int64_value = scratchOverflowMode_;
break;
+ case SQLSTATS_TOPN:
+ sqlStats_item->int64_value = topN_;
+ break;
case SQLSTATS_SCRATCH_FILE_COUNT:
sqlStats_item->int64_value = scratchFileCount_;
break;
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/271a5d0e/core/sql/executor/ExStats.h
----------------------------------------------------------------------
diff --git a/core/sql/executor/ExStats.h b/core/sql/executor/ExStats.h
index 6581ffc..00e6e5e 100644
--- a/core/sql/executor/ExStats.h
+++ b/core/sql/executor/ExStats.h
@@ -1211,6 +1211,10 @@ public:
{
scratchOverflowMode_ = overflowMode;
}
+ inline void setTopN(Int32 size)
+ {
+ topN_ = size;
+ }
inline Int64 getScratchReadCount(void) { return scratchReadCount_; }
static const char *getScratchOverflowMode(Int16 overflowMode);
private:
@@ -1228,7 +1232,8 @@ private:
Int64 scratchReadCount_;
Int64 scratchWriteCount_;
Int16 scratchOverflowMode_; // 0 - disk 1 - SSD
- char bmoFiller_[6]; // For versioning with old dp2
+ Int16 topN_; // TOPN value
+ char bmoFiller_[4]; // For versioning with old dp2
};
@@ -1487,6 +1492,7 @@ private:
Int64 scratchReadCount_;
Int64 scratchWriteCount_;
Int64 udrCpuTime_;
+ Int64 topN_;
// process id of this fragment instance (to correlate it with MEASURE data)
// Also used by logic on runtimestats/CancelBroker.cpp
SB_Phandle_Type phandle_;
@@ -2882,6 +2888,7 @@ private:
Int64 scratchReadCount_;
Int64 scratchWriteCount_;
Int64 udrCpuTime_;
+ Int64 topN_;
#endif
};
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/271a5d0e/core/sql/executor/ex_sort.cpp
----------------------------------------------------------------------
diff --git a/core/sql/executor/ex_sort.cpp b/core/sql/executor/ex_sort.cpp
index 3b2b15a..c304750 100644
--- a/core/sql/executor/ex_sort.cpp
+++ b/core/sql/executor/ex_sort.cpp
@@ -174,6 +174,12 @@ void ExSortTcb::setupPoolBuffers(ex_queue_entry *pentry_down)
defragTd_ = sortPool_->addDefragTuppDescriptor(sortTdb().sortRecLen_);
}
+ if(bmoStats_)
+ {
+ if(topNSortPool_)
+ bmoStats_->setTopN(pentry_down->downState.requestValue);
+ }
+
}
//
[5/6] incubator-trafodion git commit: additional minor cleanup.
Posted by se...@apache.org.
additional minor cleanup.
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/c71ebdc4
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/c71ebdc4
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/c71ebdc4
Branch: refs/heads/master
Commit: c71ebdc464a148de0ed8da7e693e92933c35d06f
Parents: e9785bb
Author: Prashant Vasudev <pr...@esgyn.com>
Authored: Mon Jan 9 22:43:54 2017 +0000
Committer: Prashant Vasudev <pr...@esgyn.com>
Committed: Mon Jan 9 22:43:54 2017 +0000
----------------------------------------------------------------------
core/sql/executor/ExStats.cpp | 17 +++++++----------
core/sql/executor/ExStats.h | 5 ++---
core/sql/sort/CommonStructs.h | 6 ------
3 files changed, 9 insertions(+), 19 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/c71ebdc4/core/sql/executor/ExStats.cpp
----------------------------------------------------------------------
diff --git a/core/sql/executor/ExStats.cpp b/core/sql/executor/ExStats.cpp
index 6031198..198147d 100644
--- a/core/sql/executor/ExStats.cpp
+++ b/core/sql/executor/ExStats.cpp
@@ -1951,7 +1951,7 @@ void ExFragRootOperStats::getVariableStatsInfo(char * dataBuffer,
"SpaceUsed: %u SpaceTotal: %u HeapUsed: %u HeapTotal: %u "
"Newprocess: %u NewprocessTime: %Ld reqMsgCnt: %Ld "
"regMsgBytes: %Ld replyMsgCnt: %Ld replyMsgBytes: %Ld "
- "PMemUsed: %Ld scrOverFlowMode: %d sortMode: %d"
+ "PMemUsed: %Ld scrOverFlowMode: %d sortTopN: %Ld"
"scrFileCount: %d scrBufferBlockSize: %d scrBuffferRead: %Ld scrBufferWritten: %Ld "
"scrWriteCount:%Ld scrReadCount: %Ld udrCpuTime: %Ld "
"maxWaitTime: %Ld avgWaitTime: %Ld "
@@ -1972,6 +1972,7 @@ void ExFragRootOperStats::getVariableStatsInfo(char * dataBuffer,
replyMsgBytes_,
pagesInUse_ * 16,
scratchOverflowMode_,
+ topN_,
scratchFileCount_,
scratchBufferBlockSize_,
scratchBufferBlockRead_,
@@ -1979,7 +1980,6 @@ void ExFragRootOperStats::getVariableStatsInfo(char * dataBuffer,
scratchWriteCount_,
scratchReadCount_,
udrCpuTime_,
- topN_,
maxWaitTime_,
getAvgWaitTime(),
(hdfsAccess() ? 1 : 0)
@@ -5123,9 +5123,9 @@ void ExMeasStats::getVariableStatsInfo(char * dataBuffer, char * datalen,
"statsRowType: %d Newprocess: %u NewprocessTime: %Ld Timeouts: %u NumSorts: %u SortElapsedTime: %Ld "
"SpaceTotal: %d SpaceUsed: %d HeapTotal: %d HeapUsed: %d CpuTime: %Ld "
"reqMsgCnt: %Ld reqMsgBytes: %Ld replyMsgCnt: %Ld "
- "replyMsgBytes: %Ld scrOverflowMode: %d "
+ "replyMsgBytes: %Ld scrOverflowMode: %d sortTopN: %Ld"
"scrFileCount: %d scrBufferBlockSize: %d scrBufferRead: %Ld scrBufferWritten: %Ld "
- "scrWriteCount: %Ld scrReadCount: %Ld udrCpuTime: %Ld topN: %Ld",
+ "scrWriteCount: %Ld scrReadCount: %Ld udrCpuTime: %Ld",
statType(),
getNewprocess(),
getNewprocessTime(),
@@ -5142,14 +5142,14 @@ void ExMeasStats::getVariableStatsInfo(char * dataBuffer, char * datalen,
replyMsgCnt_,
replyMsgBytes_,
scratchOverflowMode_,
+ topN_,
scratchFileCount_,
scratchBufferBlockSize_,
scratchBufferBlockRead_,
scratchBufferBlockWritten_,
scratchWriteCount_,
scratchReadCount_,
- udrCpuTime_,
- topN_
+ udrCpuTime_
);
}
buf += str_len(buf);
@@ -10712,10 +10712,7 @@ void ExBMOStats::unpack(const char* &buffer)
if (getVersion() >= _STATS_RTS_VERSION_R25)
{
alignBufferForNextObj(buffer);
- if (getVersion() == _STATS_RTS_VERSION_R25)
- srcLen = sizeof(ExBMOStats)-sizeof(scratchOverflowMode_)-sizeof(bmoFiller_)-sizeof(ExOperStats);
- else
- srcLen = sizeof(ExBMOStats)-sizeof(ExOperStats);
+ srcLen = sizeof(ExBMOStats)-sizeof(ExOperStats);
char * srcPtr = (char *)this+sizeof(ExOperStats);
memcpy((void *)srcPtr, buffer, srcLen);
buffer += srcLen;
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/c71ebdc4/core/sql/executor/ExStats.h
----------------------------------------------------------------------
diff --git a/core/sql/executor/ExStats.h b/core/sql/executor/ExStats.h
index 00e6e5e..f461af0 100644
--- a/core/sql/executor/ExStats.h
+++ b/core/sql/executor/ExStats.h
@@ -1211,7 +1211,7 @@ public:
{
scratchOverflowMode_ = overflowMode;
}
- inline void setTopN(Int32 size)
+ inline void setTopN(Int64 size)
{
topN_ = size;
}
@@ -1232,8 +1232,7 @@ private:
Int64 scratchReadCount_;
Int64 scratchWriteCount_;
Int16 scratchOverflowMode_; // 0 - disk 1 - SSD
- Int16 topN_; // TOPN value
- char bmoFiller_[4]; // For versioning with old dp2
+ Int64 topN_; // TOPN value
};
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/c71ebdc4/core/sql/sort/CommonStructs.h
----------------------------------------------------------------------
diff --git a/core/sql/sort/CommonStructs.h b/core/sql/sort/CommonStructs.h
index 51f7e6e..5d42a53 100644
--- a/core/sql/sort/CommonStructs.h
+++ b/core/sql/sort/CommonStructs.h
@@ -113,12 +113,6 @@ enum ScratchOverflowMode
SCRATCH_MMAP
};
-enum SortMode
-{
- SORTMODE_HEAP = 0,
- SORTMODE_TOPN = 1
-};
-
#endif
[6/6] incubator-trafodion git commit: Merge [TRAFODION-2259] PR 907
Add TopN stats counter and realign BMO stats
Posted by se...@apache.org.
Merge [TRAFODION-2259] PR 907 Add TopN stats counter and realign BMO stats
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/8c7ff9a4
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/8c7ff9a4
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/8c7ff9a4
Branch: refs/heads/master
Commit: 8c7ff9a4ed14ac4eb1fc245a3e4dde98da0dc71a
Parents: 73446d8 c71ebdc
Author: selvaganesang <se...@apache.org>
Authored: Wed Jan 11 14:53:33 2017 +0000
Committer: selvaganesang <se...@apache.org>
Committed: Wed Jan 11 14:53:33 2017 +0000
----------------------------------------------------------------------
core/sql/cli/sqlcli.h | 3 +-
core/sql/executor/ExExeUtilGetStats.cpp | 135 ++-
core/sql/executor/ExStats.cpp | 44 +-
core/sql/executor/ExStats.h | 8 +-
core/sql/executor/ex_sort.cpp | 6 +
core/sql/regress/core/EXPECTEDRTS | 1407 +++++++++++++-------------
core/sql/regress/core/FILTERRTS | 3 +
core/sql/sort/CommonStructs.h | 1 -
8 files changed, 855 insertions(+), 752 deletions(-)
----------------------------------------------------------------------
[4/6] incubator-trafodion git commit: Merge branch 'master' of
git://git.apache.org/incubator-trafodion into topn
Posted by se...@apache.org.
Merge branch 'master' of git://git.apache.org/incubator-trafodion into topn
Conflicts:
core/sql/executor/ExExeUtilGetStats.cpp
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/e9785bba
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/e9785bba
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/e9785bba
Branch: refs/heads/master
Commit: e9785bba4baf9a7158b4236a7c9aac99208f3037
Parents: 271a5d0 6046c6e
Author: Prashant Vasudev <pr...@esgyn.com>
Authored: Mon Jan 9 21:42:28 2017 +0000
Committer: Prashant Vasudev <pr...@esgyn.com>
Committed: Mon Jan 9 21:42:28 2017 +0000
----------------------------------------------------------------------
core/sql/clitest/blobtest.cpp | 12 ++--
core/sql/executor/ExExeUtilGetStats.cpp | 12 ++--
core/sql/executor/ExExeUtilLoad.cpp | 9 +--
core/sql/exp/ExpLOB.cpp | 8 ++-
core/sql/exp/ExpLOBaccess.cpp | 15 +---
core/sql/regress/core/EXPECTEDRTS | 12 ++++
core/sql/regress/executor/EXPECTED130 | 100 +++++++++++++--------------
core/sql/regress/executor/TEST130 | 4 +-
8 files changed, 87 insertions(+), 85 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/e9785bba/core/sql/executor/ExExeUtilGetStats.cpp
----------------------------------------------------------------------
diff --cc core/sql/executor/ExExeUtilGetStats.cpp
index 76b605b,9545a7a..696e1d9
--- a/core/sql/executor/ExExeUtilGetStats.cpp
+++ b/core/sql/executor/ExExeUtilGetStats.cpp
@@@ -2321,7 -2321,7 +2321,7 @@@ short ExExeUtilGetRTSStatisticsTcb::wor
{
if (measStatsItems_ == NULL)
{
-- maxMeasStatsItems_ = 26;
++ maxMeasStatsItems_ = 27;
measStatsItems_ = new (getGlobals()->getDefaultHeap())
SQLSTATS_ITEM[maxMeasStatsItems_];
initSqlStatsItems(measStatsItems_, maxMeasStatsItems_, FALSE);
@@@ -2348,11 -2348,11 +2348,11 @@@
measStatsItems_[20].statsItem_id = SQLSTATS_SCRATCH_FILE_COUNT;
measStatsItems_[21].statsItem_id = SQLSTATS_SCRATCH_BUFFER_BLOCK_SIZE;
measStatsItems_[22].statsItem_id = SQLSTATS_SCRATCH_BUFFER_BLOCKS_READ;
- measStatsItems_[22].statsItem_id = SQLSTATS_SCRATCH_BUFFER_BLOCKS_WRITTEN;
- measStatsItems_[23].statsItem_id = SQLSTATS_SCRATCH_READ_COUNT;
- measStatsItems_[24].statsItem_id = SQLSTATS_SCRATCH_WRITE_COUNT;
- measStatsItems_[25].statsItem_id = SQLSTATS_TOPN;
- // maxMeasStatsItems_ is set to 26
+ measStatsItems_[23].statsItem_id = SQLSTATS_SCRATCH_BUFFER_BLOCKS_WRITTEN;
+ measStatsItems_[24].statsItem_id = SQLSTATS_SCRATCH_READ_COUNT;
+ measStatsItems_[25].statsItem_id = SQLSTATS_SCRATCH_WRITE_COUNT;
-
- // maxMeasStatsItems_ is set to 26
++ measStatsItems_[26].statsItem_id = SQLSTATS_TOPN;
++ // maxMeasStatsItems_ is set to 27
}
else
initSqlStatsItems(measStatsItems_, maxMeasStatsItems_, TRUE);
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/e9785bba/core/sql/regress/core/EXPECTEDRTS
----------------------------------------------------------------------
[2/6] incubator-trafodion git commit: [TRAFODION-2259] Add TopN stats
counter and realign BMO stats.
Posted by se...@apache.org.
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/271a5d0e/core/sql/regress/core/EXPECTEDRTS
----------------------------------------------------------------------
diff --git a/core/sql/regress/core/EXPECTEDRTS b/core/sql/regress/core/EXPECTEDRTS
index 88b0f6d..98617ae 100755
--- a/core/sql/regress/core/EXPECTEDRTS
+++ b/core/sql/regress/core/EXPECTEDRTS
@@ -56,10 +56,10 @@ LC RC OP OPERATOR OPT DESCRIPTION CARD
--- SQL operation complete.
>>log LOGRTS;
>>get statistics for qid current ;
-Qid MXID11000017900212349877028870002000000000206U3333300_303_S1
-Compile Start Time 2016/12/30 16:57:24.673224
-Compile End Time 2016/12/30 16:57:24.704816
-Compile Elapsed Time 0:00:00.031592
+Qid MXID11000008082212350752509978000000000000206U3333300_303_S1
+Compile Start Time 2017/01/09 20:08:43.285350
+Compile End Time 2017/01/09 20:08:43.355507
+Compile Elapsed Time 0:00:00.070157
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -94,11 +94,11 @@ Stats Collection Type ACCUMULATED_STATS
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000017900212349877028870002000000000206U3333300_303_S1 ;
-Qid MXID11000017900212349877028870002000000000206U3333300_303_S1
-Compile Start Time 2016/12/30 16:57:24.673224
-Compile End Time 2016/12/30 16:57:24.704816
-Compile Elapsed Time 0:00:00.031592
+>>display statistics for QID MXID11000008082212350752509978000000000000206U3333300_303_S1 ;
+Qid MXID11000008082212350752509978000000000000206U3333300_303_S1
+Compile Start Time 2017/01/09 20:08:43.285350
+Compile End Time 2017/01/09 20:08:43.355507
+Compile Elapsed Time 0:00:00.070157
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -129,11 +129,11 @@ Last Suspend Time -1
Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
->>get statistics for QID MXID11000017900212349877028870002000000000206U3333300_303_S1 ;
-Qid MXID11000017900212349877028870002000000000206U3333300_303_S1
-Compile Start Time 2016/12/30 16:57:24.673224
-Compile End Time 2016/12/30 16:57:24.704816
-Compile Elapsed Time 0:00:00.031592
+>>get statistics for QID MXID11000008082212350752509978000000000000206U3333300_303_S1 ;
+Qid MXID11000008082212350752509978000000000000206U3333300_303_S1
+Compile Start Time 2017/01/09 20:08:43.285350
+Compile End Time 2017/01/09 20:08:43.355507
+Compile Elapsed Time 0:00:00.070157
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -166,10 +166,10 @@ Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
>>log;
>>display statistics for qid current;
-Qid MXID11000017900212349877028870002000000000206U3333300_303_S1
-Compile Start Time 2016/12/30 16:57:24.673224
-Compile End Time 2016/12/30 16:57:24.704816
-Compile Elapsed Time 0:00:00.031592
+Qid MXID11000008082212350752509978000000000000206U3333300_303_S1
+Compile Start Time 2017/01/09 20:08:43.285350
+Compile End Time 2017/01/09 20:08:43.355507
+Compile Elapsed Time 0:00:00.070157
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -201,10 +201,10 @@ Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
>>get statistics for qid current ;
-Qid MXID11000017900212349877028870002000000000206U3333300_303_S1
-Compile Start Time 2016/12/30 16:57:24.673224
-Compile End Time 2016/12/30 16:57:24.704816
-Compile Elapsed Time 0:00:00.031592
+Qid MXID11000008082212350752509978000000000000206U3333300_303_S1
+Compile Start Time 2017/01/09 20:08:43.285350
+Compile End Time 2017/01/09 20:08:43.355507
+Compile Elapsed Time 0:00:00.070157
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -240,24 +240,24 @@ Stats Collection Type ACCUMULATED_STATS
D
-----------
- 12
11
21
22
+ 12
--- 4 row(s) selected.
>>log;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000017900212349877028870002000000000206U3333300_303_S1 ;
-Qid MXID11000017900212349877028870002000000000206U3333300_303_S1
-Compile Start Time 2016/12/30 16:57:24.673224
-Compile End Time 2016/12/30 16:57:24.704816
-Compile Elapsed Time 0:00:00.031592
-Execute Start Time 2016/12/30 16:57:31.113405
-Execute End Time 2016/12/30 16:57:34.551840
-Execute Elapsed Time 0:00:03.438435
+>>display statistics for QID MXID11000008082212350752509978000000000000206U3333300_303_S1 ;
+Qid MXID11000008082212350752509978000000000000206U3333300_303_S1
+Compile Start Time 2017/01/09 20:08:43.285350
+Compile End Time 2017/01/09 20:08:43.355507
+Compile Elapsed Time 0:00:00.070157
+Execute Start Time 2017/01/09 20:09:49.582511
+Execute End Time 2017/01/09 20:09:52.475038
+Execute Elapsed Time 0:00:02.892527
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -275,7 +275,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2016/12/30 16:57:34.549853
+First Row Returned Time 2017/01/09 20:09:52.472998
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -287,19 +287,19 @@ Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 730,569
-SQL Process Busy Time 4,486,351
+SE IO MAX Time 521,867
+SQL Process Busy Time 4,010,959
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 16 KB
+SQL Heap Used 17 KB
Processes Created 2
-Process Create Time 171,206
+Process Create Time 187,585
Request Message Count 26
-Request Message Bytes 39,376
+Request Message Bytes 39,664
Reply Message Count 15
-Reply Message Bytes 38,664
+Reply Message Bytes 38,696
Scr. Overflow Mode DISK
Scr. File Count 0
Scr. Buffer Blk Size 0
@@ -308,14 +308,14 @@ Scr. Read Count 0
Scr. Write Count 0
--- SQL operation complete.
->>get statistics for QID MXID11000017900212349877028870002000000000206U3333300_303_S1 ;
-Qid MXID11000017900212349877028870002000000000206U3333300_303_S1
-Compile Start Time 2016/12/30 16:57:24.673224
-Compile End Time 2016/12/30 16:57:24.704816
-Compile Elapsed Time 0:00:00.031592
-Execute Start Time 2016/12/30 16:57:31.113405
-Execute End Time 2016/12/30 16:57:34.551840
-Execute Elapsed Time 0:00:03.438435
+>>get statistics for QID MXID11000008082212350752509978000000000000206U3333300_303_S1 ;
+Qid MXID11000008082212350752509978000000000000206U3333300_303_S1
+Compile Start Time 2017/01/09 20:08:43.285350
+Compile End Time 2017/01/09 20:08:43.355507
+Compile Elapsed Time 0:00:00.070157
+Execute Start Time 2017/01/09 20:09:49.582511
+Execute End Time 2017/01/09 20:09:52.475038
+Execute Elapsed Time 0:00:02.892527
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -333,7 +333,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2016/12/30 16:57:34.549853
+First Row Returned Time 2017/01/09 20:09:52.472998
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -345,19 +345,19 @@ Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 730,569
-SQL Process Busy Time 4,486,351
+SE IO MAX Time 521,867
+SQL Process Busy Time 4,010,959
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 16 KB
+SQL Heap Used 17 KB
Processes Created 2
-Process Create Time 171,206
+Process Create Time 187,585
Request Message Count 26
-Request Message Bytes 39,376
+Request Message Bytes 39,664
Reply Message Count 15
-Reply Message Bytes 38,664
+Reply Message Bytes 38,696
Scr. Overflow Mode DISK
Scr. File Count 0
Scr. Buffer Blk Size 0
@@ -368,13 +368,13 @@ Scr. Write Count 0
--- SQL operation complete.
>>log;
>>display statistics for qid current;
-Qid MXID11000017900212349877028870002000000000206U3333300_303_S1
-Compile Start Time 2016/12/30 16:57:24.673224
-Compile End Time 2016/12/30 16:57:24.704816
-Compile Elapsed Time 0:00:00.031592
-Execute Start Time 2016/12/30 16:57:31.113405
-Execute End Time 2016/12/30 16:57:34.551840
-Execute Elapsed Time 0:00:03.438435
+Qid MXID11000008082212350752509978000000000000206U3333300_303_S1
+Compile Start Time 2017/01/09 20:08:43.285350
+Compile End Time 2017/01/09 20:08:43.355507
+Compile Elapsed Time 0:00:00.070157
+Execute Start Time 2017/01/09 20:09:49.582511
+Execute End Time 2017/01/09 20:09:52.475038
+Execute Elapsed Time 0:00:02.892527
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -392,7 +392,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2016/12/30 16:57:34.549853
+First Row Returned Time 2017/01/09 20:09:52.472998
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -404,19 +404,19 @@ Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 730,569
-SQL Process Busy Time 4,486,351
+SE IO MAX Time 521,867
+SQL Process Busy Time 4,010,959
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 16 KB
+SQL Heap Used 17 KB
Processes Created 2
-Process Create Time 171,206
+Process Create Time 187,585
Request Message Count 26
-Request Message Bytes 39,376
+Request Message Bytes 39,664
Reply Message Count 15
-Reply Message Bytes 38,664
+Reply Message Bytes 38,696
Scr. Overflow Mode DISK
Scr. File Count 0
Scr. Buffer Blk Size 0
@@ -426,13 +426,13 @@ Scr. Write Count 0
--- SQL operation complete.
>>get statistics for qid current ;
-Qid MXID11000017900212349877028870002000000000206U3333300_303_S1
-Compile Start Time 2016/12/30 16:57:24.673224
-Compile End Time 2016/12/30 16:57:24.704816
-Compile Elapsed Time 0:00:00.031592
-Execute Start Time 2016/12/30 16:57:31.113405
-Execute End Time 2016/12/30 16:57:34.551840
-Execute Elapsed Time 0:00:03.438435
+Qid MXID11000008082212350752509978000000000000206U3333300_303_S1
+Compile Start Time 2017/01/09 20:08:43.285350
+Compile End Time 2017/01/09 20:08:43.355507
+Compile Elapsed Time 0:00:00.070157
+Execute Start Time 2017/01/09 20:09:49.582511
+Execute End Time 2017/01/09 20:09:52.475038
+Execute Elapsed Time 0:00:02.892527
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -450,7 +450,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2016/12/30 16:57:34.549853
+First Row Returned Time 2017/01/09 20:09:52.472998
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -462,19 +462,19 @@ Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 730,569
-SQL Process Busy Time 4,486,351
+SE IO MAX Time 521,867
+SQL Process Busy Time 4,010,959
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 16 KB
+SQL Heap Used 17 KB
Processes Created 2
-Process Create Time 171,206
+Process Create Time 187,585
Request Message Count 26
-Request Message Bytes 39,376
+Request Message Bytes 39,664
Reply Message Count 15
-Reply Message Bytes 38,664
+Reply Message Bytes 38,696
Scr. Overflow Mode DISK
Scr. File Count 0
Scr. Buffer Blk Size 0
@@ -490,25 +490,25 @@ Scr. Write Count 0
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000017900212349877028870002000000000206U3333300_303_S1 ;
+>>display statistics for QID MXID11000008082212350752509978000000000000206U3333300_303_S1 ;
-*** ERROR[8923] The given Query Id MXID11000017900212349877028870002000000000206U3333300_303_S1 is not found.
+*** ERROR[8923] The given Query Id MXID11000008082212350752509978000000000000206U3333300_303_S1 is not found.
--- SQL operation failed with errors.
->>get statistics for QID MXID11000017900212349877028870002000000000206U3333300_303_S1 ;
+>>get statistics for QID MXID11000008082212350752509978000000000000206U3333300_303_S1 ;
-*** ERROR[8923] The given Query Id MXID11000017900212349877028870002000000000206U3333300_303_S1 is not found.
+*** ERROR[8923] The given Query Id MXID11000008082212350752509978000000000000206U3333300_303_S1 is not found.
--- SQL operation failed with errors.
>>log;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000017900212349877028870002000000000206U3333300_312_S1 ;
-Qid MXID11000017900212349877028870002000000000206U3333300_312_S1
-Compile Start Time 2016/12/30 16:57:38.095304
-Compile End Time 2016/12/30 16:57:38.095785
-Compile Elapsed Time 0:00:00.000481
+>>display statistics for QID MXID11000008082212350752509978000000000000206U3333300_312_S1 ;
+Qid MXID11000008082212350752509978000000000000206U3333300_312_S1
+Compile Start Time 2017/01/09 20:09:55.468228
+Compile End Time 2017/01/09 20:09:55.470745
+Compile Elapsed Time 0:00:00.002517
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -539,11 +539,11 @@ Last Suspend Time -1
Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
->>get statistics for QID MXID11000017900212349877028870002000000000206U3333300_312_S1 ;
-Qid MXID11000017900212349877028870002000000000206U3333300_312_S1
-Compile Start Time 2016/12/30 16:57:38.095304
-Compile End Time 2016/12/30 16:57:38.095785
-Compile Elapsed Time 0:00:00.000481
+>>get statistics for QID MXID11000008082212350752509978000000000000206U3333300_312_S1 ;
+Qid MXID11000008082212350752509978000000000000206U3333300_312_S1
+Compile Start Time 2017/01/09 20:09:55.468228
+Compile End Time 2017/01/09 20:09:55.470745
+Compile Elapsed Time 0:00:00.002517
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -576,10 +576,10 @@ Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
>>log;
>>display statistics for qid current;
-Qid MXID11000017900212349877028870002000000000206U3333300_312_S1
-Compile Start Time 2016/12/30 16:57:38.095304
-Compile End Time 2016/12/30 16:57:38.095785
-Compile Elapsed Time 0:00:00.000481
+Qid MXID11000008082212350752509978000000000000206U3333300_312_S1
+Compile Start Time 2017/01/09 20:09:55.468228
+Compile End Time 2017/01/09 20:09:55.470745
+Compile Elapsed Time 0:00:00.002517
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -611,10 +611,10 @@ Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
>>get statistics for qid current ;
-Qid MXID11000017900212349877028870002000000000206U3333300_312_S1
-Compile Start Time 2016/12/30 16:57:38.095304
-Compile End Time 2016/12/30 16:57:38.095785
-Compile Elapsed Time 0:00:00.000481
+Qid MXID11000008082212350752509978000000000000206U3333300_312_S1
+Compile Start Time 2017/01/09 20:09:55.468228
+Compile End Time 2017/01/09 20:09:55.470745
+Compile Elapsed Time 0:00:00.002517
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -658,10 +658,10 @@ Stats Collection Type ACCUMULATED_STATS
--- SQL command prepared.
>>log;
>>get statistics for qid current ;
-Qid MXID11000017900212349877028870002000000000206U3333300_317_S1
-Compile Start Time 2016/12/30 16:57:48.141928
-Compile End Time 2016/12/30 16:57:48.183097
-Compile Elapsed Time 0:00:00.041169
+Qid MXID11000008082212350752509978000000000000206U3333300_317_S1
+Compile Start Time 2017/01/09 20:10:01.640865
+Compile End Time 2017/01/09 20:10:01.709896
+Compile Elapsed Time 0:00:00.069031
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -696,11 +696,11 @@ Stats Collection Type PERTABLE_STATS
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000017900212349877028870002000000000206U3333300_317_S1 ;
-Qid MXID11000017900212349877028870002000000000206U3333300_317_S1
-Compile Start Time 2016/12/30 16:57:48.141928
-Compile End Time 2016/12/30 16:57:48.183097
-Compile Elapsed Time 0:00:00.041169
+>>display statistics for QID MXID11000008082212350752509978000000000000206U3333300_317_S1 ;
+Qid MXID11000008082212350752509978000000000000206U3333300_317_S1
+Compile Start Time 2017/01/09 20:10:01.640865
+Compile End Time 2017/01/09 20:10:01.709896
+Compile Elapsed Time 0:00:00.069031
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -731,11 +731,11 @@ Last Suspend Time -1
Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
->>get statistics for QID MXID11000017900212349877028870002000000000206U3333300_317_S1 ;
-Qid MXID11000017900212349877028870002000000000206U3333300_317_S1
-Compile Start Time 2016/12/30 16:57:48.141928
-Compile End Time 2016/12/30 16:57:48.183097
-Compile Elapsed Time 0:00:00.041169
+>>get statistics for QID MXID11000008082212350752509978000000000000206U3333300_317_S1 ;
+Qid MXID11000008082212350752509978000000000000206U3333300_317_S1
+Compile Start Time 2017/01/09 20:10:01.640865
+Compile End Time 2017/01/09 20:10:01.709896
+Compile Elapsed Time 0:00:00.069031
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -770,11 +770,11 @@ Stats Collection Type PERTABLE_STATS
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000017900212349877028870002000000000206U3333300_317_S1 ACCUMULATED;
-Qid MXID11000017900212349877028870002000000000206U3333300_317_S1
-Compile Start Time 2016/12/30 16:57:48.141928
-Compile End Time 2016/12/30 16:57:48.183097
-Compile Elapsed Time 0:00:00.041169
+>>display statistics for QID MXID11000008082212350752509978000000000000206U3333300_317_S1 ACCUMULATED;
+Qid MXID11000008082212350752509978000000000000206U3333300_317_S1
+Compile Start Time 2017/01/09 20:10:01.640865
+Compile End Time 2017/01/09 20:10:01.709896
+Compile Elapsed Time 0:00:00.069031
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -805,11 +805,11 @@ Last Suspend Time -1
Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
->>get statistics for QID MXID11000017900212349877028870002000000000206U3333300_317_S1 ACCUMULATED;
-Qid MXID11000017900212349877028870002000000000206U3333300_317_S1
-Compile Start Time 2016/12/30 16:57:48.141928
-Compile End Time 2016/12/30 16:57:48.183097
-Compile Elapsed Time 0:00:00.041169
+>>get statistics for QID MXID11000008082212350752509978000000000000206U3333300_317_S1 ACCUMULATED;
+Qid MXID11000008082212350752509978000000000000206U3333300_317_S1
+Compile Start Time 2017/01/09 20:10:01.640865
+Compile End Time 2017/01/09 20:10:01.709896
+Compile Elapsed Time 0:00:00.069031
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -842,10 +842,10 @@ Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
>>log;
>>display statistics for qid current;
-Qid MXID11000017900212349877028870002000000000206U3333300_317_S1
-Compile Start Time 2016/12/30 16:57:48.141928
-Compile End Time 2016/12/30 16:57:48.183097
-Compile Elapsed Time 0:00:00.041169
+Qid MXID11000008082212350752509978000000000000206U3333300_317_S1
+Compile Start Time 2017/01/09 20:10:01.640865
+Compile End Time 2017/01/09 20:10:01.709896
+Compile Elapsed Time 0:00:00.069031
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -877,10 +877,10 @@ Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
>>get statistics for qid current ;
-Qid MXID11000017900212349877028870002000000000206U3333300_317_S1
-Compile Start Time 2016/12/30 16:57:48.141928
-Compile End Time 2016/12/30 16:57:48.183097
-Compile Elapsed Time 0:00:00.041169
+Qid MXID11000008082212350752509978000000000000206U3333300_317_S1
+Compile Start Time 2017/01/09 20:10:01.640865
+Compile End Time 2017/01/09 20:10:01.709896
+Compile Elapsed Time 0:00:00.069031
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -912,10 +912,10 @@ Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
>>display statistics for qid current accumulated ;
-Qid MXID11000017900212349877028870002000000000206U3333300_317_S1
-Compile Start Time 2016/12/30 16:57:48.141928
-Compile End Time 2016/12/30 16:57:48.183097
-Compile Elapsed Time 0:00:00.041169
+Qid MXID11000008082212350752509978000000000000206U3333300_317_S1
+Compile Start Time 2017/01/09 20:10:01.640865
+Compile End Time 2017/01/09 20:10:01.709896
+Compile Elapsed Time 0:00:00.069031
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -947,10 +947,10 @@ Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
>>get statistics for qid current accumulated ;
-Qid MXID11000017900212349877028870002000000000206U3333300_317_S1
-Compile Start Time 2016/12/30 16:57:48.141928
-Compile End Time 2016/12/30 16:57:48.183097
-Compile Elapsed Time 0:00:00.041169
+Qid MXID11000008082212350752509978000000000000206U3333300_317_S1
+Compile Start Time 2017/01/09 20:10:01.640865
+Compile End Time 2017/01/09 20:10:01.709896
+Compile Elapsed Time 0:00:00.069031
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -996,14 +996,14 @@ D
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000017900212349877028870002000000000206U3333300_317_S1 ;
-Qid MXID11000017900212349877028870002000000000206U3333300_317_S1
-Compile Start Time 2016/12/30 16:57:48.141928
-Compile End Time 2016/12/30 16:57:48.183097
-Compile Elapsed Time 0:00:00.041169
-Execute Start Time 2016/12/30 16:58:00.942589
-Execute End Time 2016/12/30 16:58:00.968296
-Execute Elapsed Time 0:00:00.025707
+>>display statistics for QID MXID11000008082212350752509978000000000000206U3333300_317_S1 ;
+Qid MXID11000008082212350752509978000000000000206U3333300_317_S1
+Compile Start Time 2017/01/09 20:10:01.640865
+Compile End Time 2017/01/09 20:10:01.709896
+Compile Elapsed Time 0:00:00.069031
+Execute Start Time 2017/01/09 20:10:07.923088
+Execute End Time 2017/01/09 20:10:07.942935
+Execute Elapsed Time 0:00:00.019847
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1021,7 +1021,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2016/12/30 16:58:00.965091
+First Row Returned Time 2017/01/09 20:10:07.940066
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1029,18 +1029,18 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
Stats Collection Type PERTABLE_STATS
-SQL Process Busy Time 16,751
+SQL Process Busy Time 9,754
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 14 KB
+SQL Heap Used 15 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,536
+Request Message Bytes 39,824
Reply Message Count 15
-Reply Message Bytes 39,048
+Reply Message Bytes 39,080
Scr. Overflow Mode UNKNOWN
Scr File Count 0
Scr. Buffer Blk Size 0
@@ -1048,23 +1048,24 @@ Scr. Buffer Blks Read 0
Scr. Buffer Blks Written 0
Scr. Read Count 0
Scr. Write Count 0
+Sort TopN -1
Table Name
Records Accessed Records Used HBase/Hive HBase/Hive HBase/Hive IO HBase/Hive IO
Estimated/Actual Estimated/Actual IOs IO MBytes Sum Time Max Time
TRAFODION.SCH.TSTAT
0 100
- 4 4 4 0 13,024 7,038
+ 4 4 4 0 9,099 4,678
--- SQL operation complete.
->>get statistics for QID MXID11000017900212349877028870002000000000206U3333300_317_S1 ;
-Qid MXID11000017900212349877028870002000000000206U3333300_317_S1
-Compile Start Time 2016/12/30 16:57:48.141928
-Compile End Time 2016/12/30 16:57:48.183097
-Compile Elapsed Time 0:00:00.041169
-Execute Start Time 2016/12/30 16:58:00.942589
-Execute End Time 2016/12/30 16:58:00.968296
-Execute Elapsed Time 0:00:00.025707
+>>get statistics for QID MXID11000008082212350752509978000000000000206U3333300_317_S1 ;
+Qid MXID11000008082212350752509978000000000000206U3333300_317_S1
+Compile Start Time 2017/01/09 20:10:01.640865
+Compile End Time 2017/01/09 20:10:01.709896
+Compile Elapsed Time 0:00:00.069031
+Execute Start Time 2017/01/09 20:10:07.923088
+Execute End Time 2017/01/09 20:10:07.942935
+Execute Elapsed Time 0:00:00.019847
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1082,7 +1083,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2016/12/30 16:58:00.965091
+First Row Returned Time 2017/01/09 20:10:07.940066
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1090,18 +1091,18 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
Stats Collection Type PERTABLE_STATS
-SQL Process Busy Time 16,751
+SQL Process Busy Time 9,754
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 14 KB
+SQL Heap Used 15 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,536
+Request Message Bytes 39,824
Reply Message Count 15
-Reply Message Bytes 39,048
+Reply Message Bytes 39,080
Scr. Overflow Mode UNKNOWN
Scr File Count 0
Scr. Buffer Blk Size 0
@@ -1109,27 +1110,28 @@ Scr. Buffer Blks Read 0
Scr. Buffer Blks Written 0
Scr. Read Count 0
Scr. Write Count 0
+Sort TopN -1
Table Name
Records Accessed Records Used HBase/Hive HBase/Hive HBase/Hive IO HBase/Hive IO
Estimated/Actual Estimated/Actual IOs IO MBytes Sum Time Max Time
TRAFODION.SCH.TSTAT
0 100
- 4 4 4 0 13,024 7,038
+ 4 4 4 0 9,099 4,678
--- SQL operation complete.
>>log;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000017900212349877028870002000000000206U3333300_317_S1 ACCUMULATED;
-Qid MXID11000017900212349877028870002000000000206U3333300_317_S1
-Compile Start Time 2016/12/30 16:57:48.141928
-Compile End Time 2016/12/30 16:57:48.183097
-Compile Elapsed Time 0:00:00.041169
-Execute Start Time 2016/12/30 16:58:00.942589
-Execute End Time 2016/12/30 16:58:00.968296
-Execute Elapsed Time 0:00:00.025707
+>>display statistics for QID MXID11000008082212350752509978000000000000206U3333300_317_S1 ACCUMULATED;
+Qid MXID11000008082212350752509978000000000000206U3333300_317_S1
+Compile Start Time 2017/01/09 20:10:01.640865
+Compile End Time 2017/01/09 20:10:01.709896
+Compile Elapsed Time 0:00:00.069031
+Execute Start Time 2017/01/09 20:10:07.923088
+Execute End Time 2017/01/09 20:10:07.942935
+Execute Elapsed Time 0:00:00.019847
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1147,7 +1149,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2016/12/30 16:58:00.965091
+First Row Returned Time 2017/01/09 20:10:07.940066
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1159,19 +1161,19 @@ Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 7,038
-SQL Process Busy Time 16,751
+SE IO MAX Time 4,678
+SQL Process Busy Time 9,754
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 14 KB
+SQL Heap Used 15 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,536
+Request Message Bytes 39,824
Reply Message Count 15
-Reply Message Bytes 39,048
+Reply Message Bytes 39,080
Scr. Overflow Mode UNKNOWN
Scr. File Count 0
Scr. Buffer Blk Size 0
@@ -1180,14 +1182,14 @@ Scr. Read Count 0
Scr. Write Count 0
--- SQL operation complete.
->>get statistics for QID MXID11000017900212349877028870002000000000206U3333300_317_S1 ACCUMULATED;
-Qid MXID11000017900212349877028870002000000000206U3333300_317_S1
-Compile Start Time 2016/12/30 16:57:48.141928
-Compile End Time 2016/12/30 16:57:48.183097
-Compile Elapsed Time 0:00:00.041169
-Execute Start Time 2016/12/30 16:58:00.942589
-Execute End Time 2016/12/30 16:58:00.968296
-Execute Elapsed Time 0:00:00.025707
+>>get statistics for QID MXID11000008082212350752509978000000000000206U3333300_317_S1 ACCUMULATED;
+Qid MXID11000008082212350752509978000000000000206U3333300_317_S1
+Compile Start Time 2017/01/09 20:10:01.640865
+Compile End Time 2017/01/09 20:10:01.709896
+Compile Elapsed Time 0:00:00.069031
+Execute Start Time 2017/01/09 20:10:07.923088
+Execute End Time 2017/01/09 20:10:07.942935
+Execute Elapsed Time 0:00:00.019847
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1205,7 +1207,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2016/12/30 16:58:00.965091
+First Row Returned Time 2017/01/09 20:10:07.940066
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1217,19 +1219,19 @@ Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 7,038
-SQL Process Busy Time 16,751
+SE IO MAX Time 4,678
+SQL Process Busy Time 9,754
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 14 KB
+SQL Heap Used 15 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,536
+Request Message Bytes 39,824
Reply Message Count 15
-Reply Message Bytes 39,048
+Reply Message Bytes 39,080
Scr. Overflow Mode UNKNOWN
Scr. File Count 0
Scr. Buffer Blk Size 0
@@ -1240,13 +1242,13 @@ Scr. Write Count 0
--- SQL operation complete.
>>log;
>>display statistics for qid current;
-Qid MXID11000017900212349877028870002000000000206U3333300_317_S1
-Compile Start Time 2016/12/30 16:57:48.141928
-Compile End Time 2016/12/30 16:57:48.183097
-Compile Elapsed Time 0:00:00.041169
-Execute Start Time 2016/12/30 16:58:00.942589
-Execute End Time 2016/12/30 16:58:00.968296
-Execute Elapsed Time 0:00:00.025707
+Qid MXID11000008082212350752509978000000000000206U3333300_317_S1
+Compile Start Time 2017/01/09 20:10:01.640865
+Compile End Time 2017/01/09 20:10:01.709896
+Compile Elapsed Time 0:00:00.069031
+Execute Start Time 2017/01/09 20:10:07.923088
+Execute End Time 2017/01/09 20:10:07.942935
+Execute Elapsed Time 0:00:00.019847
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1264,7 +1266,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2016/12/30 16:58:00.965091
+First Row Returned Time 2017/01/09 20:10:07.940066
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1272,18 +1274,18 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
Stats Collection Type PERTABLE_STATS
-SQL Process Busy Time 16,751
+SQL Process Busy Time 9,754
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 14 KB
+SQL Heap Used 15 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,536
+Request Message Bytes 39,824
Reply Message Count 15
-Reply Message Bytes 39,048
+Reply Message Bytes 39,080
Scr. Overflow Mode UNKNOWN
Scr File Count 0
Scr. Buffer Blk Size 0
@@ -1291,23 +1293,24 @@ Scr. Buffer Blks Read 0
Scr. Buffer Blks Written 0
Scr. Read Count 0
Scr. Write Count 0
+Sort TopN -1
Table Name
Records Accessed Records Used HBase/Hive HBase/Hive HBase/Hive IO HBase/Hive IO
Estimated/Actual Estimated/Actual IOs IO MBytes Sum Time Max Time
TRAFODION.SCH.TSTAT
0 100
- 4 4 4 0 13,024 7,038
+ 4 4 4 0 9,099 4,678
--- SQL operation complete.
>>get statistics for qid current ;
-Qid MXID11000017900212349877028870002000000000206U3333300_317_S1
-Compile Start Time 2016/12/30 16:57:48.141928
-Compile End Time 2016/12/30 16:57:48.183097
-Compile Elapsed Time 0:00:00.041169
-Execute Start Time 2016/12/30 16:58:00.942589
-Execute End Time 2016/12/30 16:58:00.968296
-Execute Elapsed Time 0:00:00.025707
+Qid MXID11000008082212350752509978000000000000206U3333300_317_S1
+Compile Start Time 2017/01/09 20:10:01.640865
+Compile End Time 2017/01/09 20:10:01.709896
+Compile Elapsed Time 0:00:00.069031
+Execute Start Time 2017/01/09 20:10:07.923088
+Execute End Time 2017/01/09 20:10:07.942935
+Execute Elapsed Time 0:00:00.019847
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1325,7 +1328,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2016/12/30 16:58:00.965091
+First Row Returned Time 2017/01/09 20:10:07.940066
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1333,18 +1336,18 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
Stats Collection Type PERTABLE_STATS
-SQL Process Busy Time 16,751
+SQL Process Busy Time 9,754
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 14 KB
+SQL Heap Used 15 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,536
+Request Message Bytes 39,824
Reply Message Count 15
-Reply Message Bytes 39,048
+Reply Message Bytes 39,080
Scr. Overflow Mode UNKNOWN
Scr File Count 0
Scr. Buffer Blk Size 0
@@ -1352,23 +1355,24 @@ Scr. Buffer Blks Read 0
Scr. Buffer Blks Written 0
Scr. Read Count 0
Scr. Write Count 0
+Sort TopN -1
Table Name
Records Accessed Records Used HBase/Hive HBase/Hive HBase/Hive IO HBase/Hive IO
Estimated/Actual Estimated/Actual IOs IO MBytes Sum Time Max Time
TRAFODION.SCH.TSTAT
0 100
- 4 4 4 0 13,024 7,038
+ 4 4 4 0 9,099 4,678
--- SQL operation complete.
>>display statistics for qid current accumulated;
-Qid MXID11000017900212349877028870002000000000206U3333300_317_S1
-Compile Start Time 2016/12/30 16:57:48.141928
-Compile End Time 2016/12/30 16:57:48.183097
-Compile Elapsed Time 0:00:00.041169
-Execute Start Time 2016/12/30 16:58:00.942589
-Execute End Time 2016/12/30 16:58:00.968296
-Execute Elapsed Time 0:00:00.025707
+Qid MXID11000008082212350752509978000000000000206U3333300_317_S1
+Compile Start Time 2017/01/09 20:10:01.640865
+Compile End Time 2017/01/09 20:10:01.709896
+Compile Elapsed Time 0:00:00.069031
+Execute Start Time 2017/01/09 20:10:07.923088
+Execute End Time 2017/01/09 20:10:07.942935
+Execute Elapsed Time 0:00:00.019847
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1386,7 +1390,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2016/12/30 16:58:00.965091
+First Row Returned Time 2017/01/09 20:10:07.940066
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1398,19 +1402,19 @@ Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 7,038
-SQL Process Busy Time 16,751
+SE IO MAX Time 4,678
+SQL Process Busy Time 9,754
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 14 KB
+SQL Heap Used 15 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,536
+Request Message Bytes 39,824
Reply Message Count 15
-Reply Message Bytes 39,048
+Reply Message Bytes 39,080
Scr. Overflow Mode UNKNOWN
Scr. File Count 0
Scr. Buffer Blk Size 0
@@ -1420,13 +1424,13 @@ Scr. Write Count 0
--- SQL operation complete.
>>get statistics for qid current accumulated;
-Qid MXID11000017900212349877028870002000000000206U3333300_317_S1
-Compile Start Time 2016/12/30 16:57:48.141928
-Compile End Time 2016/12/30 16:57:48.183097
-Compile Elapsed Time 0:00:00.041169
-Execute Start Time 2016/12/30 16:58:00.942589
-Execute End Time 2016/12/30 16:58:00.968296
-Execute Elapsed Time 0:00:00.025707
+Qid MXID11000008082212350752509978000000000000206U3333300_317_S1
+Compile Start Time 2017/01/09 20:10:01.640865
+Compile End Time 2017/01/09 20:10:01.709896
+Compile Elapsed Time 0:00:00.069031
+Execute Start Time 2017/01/09 20:10:07.923088
+Execute End Time 2017/01/09 20:10:07.942935
+Execute Elapsed Time 0:00:00.019847
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1444,7 +1448,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2016/12/30 16:58:00.965091
+First Row Returned Time 2017/01/09 20:10:07.940066
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1456,19 +1460,19 @@ Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 7,038
-SQL Process Busy Time 16,751
+SE IO MAX Time 4,678
+SQL Process Busy Time 9,754
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 14 KB
+SQL Heap Used 15 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,536
+Request Message Bytes 39,824
Reply Message Count 15
-Reply Message Bytes 39,048
+Reply Message Bytes 39,080
Scr. Overflow Mode UNKNOWN
Scr. File Count 0
Scr. Buffer Blk Size 0
@@ -1479,7 +1483,7 @@ Scr. Write Count 0
--- SQL operation complete.
>>log;
>>obey PQIDOUT;
->>SET SESSION DEFAULT PARENT_QID 'MXID11000017900212349877028870002000000000206U3333300_317_S1';
+>>SET SESSION DEFAULT PARENT_QID 'MXID11000008082212350752509978000000000000206U3333300_317_S1';
--- SQL operation complete.
>>prepare s1 from select distinct d from tstat ;
@@ -1489,11 +1493,11 @@ Scr. Write Count 0
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000017900212349877028870002000000000206U3333300_331_S1 ;
-Qid MXID11000017900212349877028870002000000000206U3333300_331_S1
-Compile Start Time 2016/12/30 16:58:07.757708
-Compile End Time 2016/12/30 16:58:07.758439
-Compile Elapsed Time 0:00:00.000731
+>>display statistics for QID MXID11000008082212350752509978000000000000206U3333300_331_S1 ;
+Qid MXID11000008082212350752509978000000000000206U3333300_331_S1
+Compile Start Time 2017/01/09 20:10:14.157278
+Compile End Time 2017/01/09 20:10:14.159949
+Compile Elapsed Time 0:00:00.002671
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1505,7 +1509,7 @@ Query Type SQL_SELECT_NON_UNIQUE
Sub Query Type SQL_STMT_NA
Estimated Accessed Rows 0
Estimated Used Rows 0
-Parent Qid MXID11000017900212349877028870002000000000206U3333300_317_S1
+Parent Qid MXID11000008082212350752509978000000000000206U3333300_317_S1
Parent Query System SAME
Child Qid NONE
Number of SQL Processes 0
@@ -1524,11 +1528,11 @@ Last Suspend Time -1
Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
->>get statistics for QID MXID11000017900212349877028870002000000000206U3333300_331_S1 ;
-Qid MXID11000017900212349877028870002000000000206U3333300_331_S1
-Compile Start Time 2016/12/30 16:58:07.757708
-Compile End Time 2016/12/30 16:58:07.758439
-Compile Elapsed Time 0:00:00.000731
+>>get statistics for QID MXID11000008082212350752509978000000000000206U3333300_331_S1 ;
+Qid MXID11000008082212350752509978000000000000206U3333300_331_S1
+Compile Start Time 2017/01/09 20:10:14.157278
+Compile End Time 2017/01/09 20:10:14.159949
+Compile Elapsed Time 0:00:00.002671
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1540,7 +1544,7 @@ Query Type SQL_SELECT_NON_UNIQUE
Sub Query Type SQL_STMT_NA
Estimated Accessed Rows 0
Estimated Used Rows 0
-Parent Qid MXID11000017900212349877028870002000000000206U3333300_317_S1
+Parent Qid MXID11000008082212350752509978000000000000206U3333300_317_S1
Parent Query System SAME
Child Qid NONE
Number of SQL Processes 0
@@ -1570,11 +1574,11 @@ Stats Collection Type PERTABLE_STATS
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000017900212349877028870002000000000206U3333300_333_S1 ;
-Qid MXID11000017900212349877028870002000000000206U3333300_333_S1
-Compile Start Time 2016/12/30 16:58:14.448081
-Compile End Time 2016/12/30 16:58:14.448720
-Compile Elapsed Time 0:00:00.000639
+>>display statistics for QID MXID11000008082212350752509978000000000000206U3333300_333_S1 ;
+Qid MXID11000008082212350752509978000000000000206U3333300_333_S1
+Compile Start Time 2017/01/09 20:10:20.557111
+Compile End Time 2017/01/09 20:10:20.558991
+Compile Elapsed Time 0:00:00.001880
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1605,11 +1609,11 @@ Last Suspend Time -1
Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
->>get statistics for QID MXID11000017900212349877028870002000000000206U3333300_333_S1 ;
-Qid MXID11000017900212349877028870002000000000206U3333300_333_S1
-Compile Start Time 2016/12/30 16:58:14.448081
-Compile End Time 2016/12/30 16:58:14.448720
-Compile Elapsed Time 0:00:00.000639
+>>get statistics for QID MXID11000008082212350752509978000000000000206U3333300_333_S1 ;
+Qid MXID11000008082212350752509978000000000000206U3333300_333_S1
+Compile Start Time 2017/01/09 20:10:20.557111
+Compile End Time 2017/01/09 20:10:20.558991
+Compile Elapsed Time 0:00:00.001880
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1656,11 +1660,11 @@ Stats Collection Type PERTABLE_STATS
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000017900212349877028870002000000000206U3333300_336_S1 ;
-Qid MXID11000017900212349877028870002000000000206U3333300_336_S1
-Compile Start Time 2016/12/30 16:58:17.901889
-Compile End Time 2016/12/30 16:58:17.934090
-Compile Elapsed Time 0:00:00.032201
+>>display statistics for QID MXID11000008082212350752509978000000000000206U3333300_336_S1 ;
+Qid MXID11000008082212350752509978000000000000206U3333300_336_S1
+Compile Start Time 2017/01/09 20:10:26.602817
+Compile End Time 2017/01/09 20:10:26.667823
+Compile Elapsed Time 0:00:00.065006
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1691,11 +1695,11 @@ Last Suspend Time -1
Stats Collection Type OPERATOR_STATS
--- SQL operation complete.
->>get statistics for QID MXID11000017900212349877028870002000000000206U3333300_336_S1 ;
-Qid MXID11000017900212349877028870002000000000206U3333300_336_S1
-Compile Start Time 2016/12/30 16:58:17.901889
-Compile End Time 2016/12/30 16:58:17.934090
-Compile Elapsed Time 0:00:00.032201
+>>get statistics for QID MXID11000008082212350752509978000000000000206U3333300_336_S1 ;
+Qid MXID11000008082212350752509978000000000000206U3333300_336_S1
+Compile Start Time 2017/01/09 20:10:26.602817
+Compile End Time 2017/01/09 20:10:26.667823
+Compile Elapsed Time 0:00:00.065006
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1742,14 +1746,14 @@ D
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000017900212349877028870002000000000206U3333300_336_S1 ;
-Qid MXID11000017900212349877028870002000000000206U3333300_336_S1
-Compile Start Time 2016/12/30 16:58:17.901889
-Compile End Time 2016/12/30 16:58:17.934090
-Compile Elapsed Time 0:00:00.032201
-Execute Start Time 2016/12/30 16:58:24.336267
-Execute End Time 2016/12/30 16:58:24.354444
-Execute Elapsed Time 0:00:00.018177
+>>display statistics for QID MXID11000008082212350752509978000000000000206U3333300_336_S1 ;
+Qid MXID11000008082212350752509978000000000000206U3333300_336_S1
+Compile Start Time 2017/01/09 20:10:26.602817
+Compile End Time 2017/01/09 20:10:26.667823
+Compile Elapsed Time 0:00:00.065006
+Execute Start Time 2017/01/09 20:10:32.694186
+Execute End Time 2017/01/09 20:10:32.714103
+Execute Elapsed Time 0:00:00.019917
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1767,7 +1771,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2016/12/30 16:58:24.352424
+First Row Returned Time 2017/01/09 20:10:32.710668
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1778,27 +1782,27 @@ Stats Collection Type OPERATOR_STATS
LC RC Id PaId ExId Frag TDB Name DOP Dispatches Oper CPU Time Est. Records Used Act. Records Used Details
-10 . 11 . 5 0 EX_ROOT 1 5 28 0 4 1452
-9 . 10 11 4 0 EX_SPLIT_TOP 1 5 7 2 4
-8 . 9 10 4 0 EX_SEND_TOP 2 10 1,417 2 4
-7 . 8 9 4 2 EX_SEND_BOTTOM 2 17 149 2 4
-6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 10 2 4 5048
-5 . 6 7 3 2 EX_HASH_GRBY 2 6 3,370 1 4 0|0|0
-4 . 5 6 2 2 EX_SPLIT_TOP 2 11 14 100 4
-3 . 4 5 2 2 EX_SEND_TOP 4 18 1,505 100 4
-2 . 3 4 2 3 EX_SEND_BOTTOM 4 28 227 100 4
-1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 8 17 100 4 5183
-. . 1 2 1 3 EX_TRAF_KEY_SELECT 6 12 14,817 100 4 TRAFODION.SCH.TSTAT|4|176
-
---- SQL operation complete.
->>get statistics for QID MXID11000017900212349877028870002000000000206U3333300_336_S1 ;
-Qid MXID11000017900212349877028870002000000000206U3333300_336_S1
-Compile Start Time 2016/12/30 16:58:17.901889
-Compile End Time 2016/12/30 16:58:17.934090
-Compile Elapsed Time 0:00:00.032201
-Execute Start Time 2016/12/30 16:58:24.336267
-Execute End Time 2016/12/30 16:58:24.354444
-Execute Elapsed Time 0:00:00.018177
+10 . 11 . 5 0 EX_ROOT 1 5 18 0 4 1941
+9 . 10 11 4 0 EX_SPLIT_TOP 1 5 32 2 4
+8 . 9 10 4 0 EX_SEND_TOP 2 10 1,891 2 4
+7 . 8 9 4 2 EX_SEND_BOTTOM 2 17 282 2 4
+6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 83 2 4 5468
+5 . 6 7 3 2 EX_HASH_GRBY 2 6 3,491 1 4 0|0|0
+4 . 5 6 2 2 EX_SPLIT_TOP 2 9 71 100 4
+3 . 4 5 2 2 EX_SEND_TOP 4 18 1,541 100 4
+2 . 3 4 2 3 EX_SEND_BOTTOM 4 24 388 100 4
+1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 8 50 100 4 3814
+. . 1 2 1 3 EX_TRAF_KEY_SELECT 6 12 10,128 100 4 TRAFODION.SCH.TSTAT|4|176
+
+--- SQL operation complete.
+>>get statistics for QID MXID11000008082212350752509978000000000000206U3333300_336_S1 ;
+Qid MXID11000008082212350752509978000000000000206U3333300_336_S1
+Compile Start Time 2017/01/09 20:10:26.602817
+Compile End Time 2017/01/09 20:10:26.667823
+Compile Elapsed Time 0:00:00.065006
+Execute Start Time 2017/01/09 20:10:32.694186
+Execute End Time 2017/01/09 20:10:32.714103
+Execute Elapsed Time 0:00:00.019917
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1816,7 +1820,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2016/12/30 16:58:24.352424
+First Row Returned Time 2017/01/09 20:10:32.710668
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1827,31 +1831,31 @@ Stats Collection Type OPERATOR_STATS
LC RC Id PaId ExId Frag TDB Name DOP Dispatches Oper CPU Time Est. Records Used Act. Records Used Details
-10 . 11 . 5 0 EX_ROOT 1 5 28 0 4 1452
-9 . 10 11 4 0 EX_SPLIT_TOP 1 5 7 2 4
-8 . 9 10 4 0 EX_SEND_TOP 2 10 1,417 2 4
-7 . 8 9 4 2 EX_SEND_BOTTOM 2 17 149 2 4
-6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 10 2 4 5048
-5 . 6 7 3 2 EX_HASH_GRBY 2 6 3,370 1 4 0|0|0
-4 . 5 6 2 2 EX_SPLIT_TOP 2 11 14 100 4
-3 . 4 5 2 2 EX_SEND_TOP 4 18 1,505 100 4
-2 . 3 4 2 3 EX_SEND_BOTTOM 4 28 227 100 4
-1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 8 17 100 4 5183
-. . 1 2 1 3 EX_TRAF_KEY_SELECT 6 12 14,817 100 4 TRAFODION.SCH.TSTAT|4|176
+10 . 11 . 5 0 EX_ROOT 1 5 18 0 4 1941
+9 . 10 11 4 0 EX_SPLIT_TOP 1 5 32 2 4
+8 . 9 10 4 0 EX_SEND_TOP 2 10 1,891 2 4
+7 . 8 9 4 2 EX_SEND_BOTTOM 2 17 282 2 4
+6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 83 2 4 5468
+5 . 6 7 3 2 EX_HASH_GRBY 2 6 3,491 1 4 0|0|0
+4 . 5 6 2 2 EX_SPLIT_TOP 2 9 71 100 4
+3 . 4 5 2 2 EX_SEND_TOP 4 18 1,541 100 4
+2 . 3 4 2 3 EX_SEND_BOTTOM 4 24 388 100 4
+1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 8 50 100 4 3814
+. . 1 2 1 3 EX_TRAF_KEY_SELECT 6 12 10,128 100 4 TRAFODION.SCH.TSTAT|4|176
--- SQL operation complete.
>>log;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000017900212349877028870002000000000206U3333300_336_S1 ACCUMULATED;
-Qid MXID11000017900212349877028870002000000000206U3333300_336_S1
-Compile Start Time 2016/12/30 16:58:17.901889
-Compile End Time 2016/12/30 16:58:17.934090
-Compile Elapsed Time 0:00:00.032201
-Execute Start Time 2016/12/30 16:58:24.336267
-Execute End Time 2016/12/30 16:58:24.354444
-Execute Elapsed Time 0:00:00.018177
+>>display statistics for QID MXID11000008082212350752509978000000000000206U3333300_336_S1 ACCUMULATED;
+Qid MXID11000008082212350752509978000000000000206U3333300_336_S1
+Compile Start Time 2017/01/09 20:10:26.602817
+Compile End Time 2017/01/09 20:10:26.667823
+Compile Elapsed Time 0:00:00.065006
+Execute Start Time 2017/01/09 20:10:32.694186
+Execute End Time 2017/01/09 20:10:32.714103
+Execute Elapsed Time 0:00:00.019917
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1869,7 +1873,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2016/12/30 16:58:24.352424
+First Row Returned Time 2017/01/09 20:10:32.710668
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1881,19 +1885,19 @@ Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 6,357
-SQL Process Busy Time 11,683
+SE IO MAX Time 4,705
+SQL Process Busy Time 11,223
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 14 KB
+SQL Heap Used 15 KB
Processes Created 0
Process Create Time 0
Request Message Count 28
-Request Message Bytes 39,696
+Request Message Bytes 39,984
Reply Message Count 15
-Reply Message Bytes 42,200
+Reply Message Bytes 42,240
Scr. Overflow Mode DISK
Scr. File Count 0
Scr. Buffer Blk Size 0
@@ -1902,14 +1906,14 @@ Scr. Read Count 0
Scr. Write Count 0
--- SQL operation complete.
->>get statistics for QID MXID11000017900212349877028870002000000000206U3333300_336_S1 ACCUMULATED;
-Qid MXID11000017900212349877028870002000000000206U3333300_336_S1
-Compile Start Time 2016/12/30 16:58:17.901889
-Compile End Time 2016/12/30 16:58:17.934090
-Compile Elapsed Time 0:00:00.032201
-Execute Start Time 2016/12/30 16:58:24.336267
-Execute End Time 2016/12/30 16:58:24.354444
-Execute Elapsed Time 0:00:00.018177
+>>get statistics for QID MXID11000008082212350752509978000000000000206U3333300_336_S1 ACCUMULATED;
+Qid MXID11000008082212350752509978000000000000206U3333300_336_S1
+Compile Start Time 2017/01/09 20:10:26.602817
+Compile End Time 2017/01/09 20:10:26.667823
+Compile Elapsed Time 0:00:00.065006
+Execute Start Time 2017/01/09 20:10:32.694186
+Execute End Time 2017/01/09 20:10:32.714103
+Execute Elapsed Time 0:00:00.019917
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1927,7 +1931,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2016/12/30 16:58:24.352424
+First Row Returned Time 2017/01/09 20:10:32.710668
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1939,19 +1943,19 @@ Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 6,357
-SQL Process Busy Time 11,683
+SE IO MAX Time 4,705
+SQL Process Busy Time 11,223
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 14 KB
+SQL Heap Used 15 KB
Processes Created 0
Process Create Time 0
Request Message Count 28
-Request Message Bytes 39,696
+Request Message Bytes 39,984
Reply Message Count 15
-Reply Message Bytes 42,200
+Reply Message Bytes 42,240
Scr. Overflow Mode DISK
Scr. File Count 0
Scr. Buffer Blk Size 0
@@ -1964,14 +1968,14 @@ Scr. Write Count 0
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000017900212349877028870002000000000206U3333300_336_S1 PERTABLE;
-Qid MXID11000017900212349877028870002000000000206U3333300_336_S1
-Compile Start Time 2016/12/30 16:58:17.901889
-Compile End Time 2016/12/30 16:58:17.934090
-Compile Elapsed Time 0:00:00.032201
-Execute Start Time 2016/12/30 16:58:24.336267
-Execute End Time 2016/12/30 16:58:24.354444
-Execute Elapsed Time 0:00:00.018177
+>>display statistics for QID MXID11000008082212350752509978000000000000206U3333300_336_S1 PERTABLE;
+Qid MXID11000008082212350752509978000000000000206U3333300_336_S1
+Compile Start Time 2017/01/09 20:10:26.602817
+Compile End Time 2017/01/09 20:10:26.667823
+Compile Elapsed Time 0:00:00.065006
+Execute Start Time 2017/01/09 20:10:32.694186
+Execute End Time 2017/01/09 20:10:32.714103
+Execute Elapsed Time 0:00:00.019917
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1989,7 +1993,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2016/12/30 16:58:24.352424
+First Row Returned Time 2017/01/09 20:10:32.710668
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1997,18 +2001,18 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
Stats Collection Type OPERATOR_STATS
-SQL Process Busy Time 11,683
+SQL Process Busy Time 11,223
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 14 KB
+SQL Heap Used 15 KB
Processes Created 0
Process Create Time 0
Request Message Count 28
-Request Message Bytes 39,696
+Request Message Bytes 39,984
Reply Message Count 15
-Reply Message Bytes 42,200
+Reply Message Bytes 42,240
Scr. Overflow Mode DISK
Scr File Count 0
Scr. Buffer Blk Size 0
@@ -2016,23 +2020,24 @@ Scr. Buffer Blks Read 0
Scr. Buffer Blks Written 0
Scr. Read Count 0
Scr. Write Count 0
+Sort TopN -1
Table Name
Records Accessed Records Used HBase/Hive HBase/Hive HBase/Hive IO HBase/Hive IO
Estimated/Actual Estimated/Actual IOs IO MBytes Sum Time Max Time
TRAFODION.SCH.TSTAT
0 100
- 4 4 4 0 12,435 6,357
+ 4 4 4 0 8,692 4,705
--- SQL operation complete.
->>get statistics for QID MXID11000017900212349877028870002000000000206U3333300_336_S1 PERTABLE;
-Qid MXID11000017900212349877028870002000000000206U3333300_336_S1
-Compile Start Time 2016/12/30 16:58:17.901889
-Compile End Time 2016/12/30 16:58:17.934090
-Compile Elapsed Time 0:00:00.032201
-Execute Start Time 2016/12/30 16:58:24.336267
-Execute End Time 2016/12/30 16:58:24.354444
-Execute Elapsed Time 0:00:00.018177
+>>get statistics for QID MXID11000008082212350752509978000000000000206U3333300_336_S1 PERTABLE;
+Qid MXID11000008082212350752509978000000000000206U3333300_336_S1
+Compile Start Time 2017/01/09 20:10:26.602817
+Compile End Time 2017/01/09 20:10:26.667823
+Compile Elapsed Time 0:00:00.065006
+Execute Start Time 2017/01/09 20:10:32.694186
+Execute End Time 2017/01/09 20:10:32.714103
+Execute Elapsed Time 0:00:00.019917
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -2050,7 +2055,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2016/12/30 16:58:24.352424
+First Row Returned Time 2017/01/09 20:10:32.710668
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -2058,18 +2063,18 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
Stats Collection Type OPERATOR_STATS
-SQL Process Busy Time 11,683
+SQL Process Busy Time 11,223
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 14 KB
+SQL Heap Used 15 KB
Processes Created 0
Process Create Time 0
Request Message Count 28
-Request Message Bytes 39,696
+Request Message Bytes 39,984
Reply Message Count 15
-Reply Message Bytes 42,200
+Reply Message Bytes 42,240
Scr. Overflow Mode DISK
Scr File Count 0
Scr. Buffer Blk Size 0
@@ -2077,27 +2082,28 @@ Scr. Buffer Blks Read 0
Scr. Buffer Blks Written 0
Scr. Read Count 0
Scr. Write Count 0
+Sort TopN -1
Table Name
Records Accessed Records Used HBase/Hive HBase/Hive HBase/Hive IO HBase/Hive IO
Estimated/Actual Estimated/Actual IOs IO MBytes Sum Time Max Time
TRAFODION.SCH.TSTAT
0 100
- 4 4 4 0 12,435 6,357
+ 4 4 4 0 8,692 4,705
--- SQL operation complete.
>>log;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000017900212349877028870002000000000206U3333300_336_S1 PROGRESS;
-Qid MXID11000017900212349877028870002000000000206U3333300_336_S1
-Compile Start Time 2016/12/30 16:58:17.901889
-Compile End Time 2016/12/30 16:58:17.934090
-Compile Elapsed Time 0:00:00.032201
-Execute Start Time 2016/12/30 16:58:24.336267
-Execute End Time 2016/12/30 16:58:24.354444
-Execute Elapsed Time 0:00:00.018177
+>>display statistics for QID MXID11000008082212350752509978000000000000206U3333300_336_S1 PROGRESS;
+Qid MXID11000008082212350752509978000000000000206U3333300_336_S1
+Compile Start Time 2017/01/09 20:10:26.602817
+Compile End Time 2017/01/09 20:10:26.667823
+Compile Elapsed Time 0:00:00.065006
+Execute Start Time 2017/01/09 20:10:32.694186
+Execute End Time 2017/01/09 20:10:32.714103
+Execute Elapsed Time 0:00:00.019917
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -2115,7 +2121,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2016/12/30 16:58:24.352424
+First Row Returned Time 2017/01/09 20:10:32.710668
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -2123,37 +2129,41 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
Stats Collection Type OPERATOR_STATS
-SQL Process Busy Time 11,683
+SQL Process Busy Time 11,223
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 14 KB
+SQL Heap Used 15 KB
Processes Created 0
Process Create Time 0
Request Message Count 28
-Request Message Bytes 39,696
+Request Message Bytes 39,984
Reply Message Count 15
-Reply Message Bytes 42,200
+Reply Message Bytes 42,240
Table Name
Records Accessed Records Used HBase/Hive HBase/Hive HBase/Hive IO HBase/Hive IO
Estimated/Actual Estimated/Actual IOs IO MBytes Sum Time Max Time
TRAFODION.SCH.TSTAT
0 100
- 4 4 4 0 12,435 6,357
-
- Id TDB Name Mode CPU Time BMO Heap Used BMO Heap Total BMO Heap WM BMO Space BufSz BMO Space BufCnt File Count Scratch Buffer Block Size/Read/Written Scratch IO Count Read/Written
- 6 EX_HASH_GRBY DISK 3,370 4 1,024 7,687 256 0 0 -1 0 0 0 0
-
---- SQL operation complete.
->>get statistics for QID MXID11000017900212349877028870002000000000206U3333300_336_S1 PROGRESS;
-Qid MXID11000017900212349877028870002000000000206U3333300_336_S1
-Compile Start Time 2016/12/30 16:58:17.901889
-Compile End Time 2016/12/30 16:58:17.934090
-Compile Elapsed Time 0:00:00.032201
-Execute Start Time 2016/12/30 16:58:24.336267
-Execute End Time 2016/12/30 16:58:24.354444
-Execute Elapsed Time 0:00:00.018177
+ 4 4 4 0 8,692 4,705
+
+ Id TDB Name Mode TopN CPU Time File Count
+ BMO Heap Used BMO Heap Total BMO Heap WM BMO Space BufSz BMO Space BufCnt
+ ScrBlk Size ScrBlk Read ScrBlk Written ScrIO Read ScrIO Written
+ 6 EX_HASH_GRBY DISK -1 3,491 0
+ 4 1,024 7,687 256 0
+ -1 0 0 0 0
+
+--- SQL operation complete.
+>>get statistics for QID MXID11000008082212350752509978000000000000206U3333300_336_S1 PROGRESS;
+Qid MXID11000008082212350752509978000000000000206U3333300_336_S1
+Compile Start Time 2017/01/09 20:10:26.602817
+Compile End Time 2017/01/09 20:10:26.667823
+Compile Elapsed Time 0:00:00.065006
+Execute Start Time 2017/01/09 20:10:32.694186
+Execute End Time 2017/01/09 20:10:32.714103
+Execute Elapsed Time 0:00:00.019917
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -2171,7 +2181,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2016/12/30 16:58:24.352424
+First Row Returned Time 2017/01/09 20:10:32.710668
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -2179,41 +2189,45 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
Stats Collection Type OPERATOR_STATS
-SQL Process Busy Time 11,683
+SQL Process Busy Time 11,223
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 14 KB
+SQL Heap Used 15 KB
Processes Created 0
Process Create Time 0
Request Message Count 28
-Request Message Bytes 39,696
+Request Message Bytes 39,984
Reply Message Count 15
-Reply Message Bytes 42,200
+Reply Message Bytes 42,240
Table Name
Records Accessed Records Used HBase/Hive HBase/Hive HBase/Hive IO HBase/Hive IO
Estimated/Actual Estimated/Actual IOs IO MBytes Sum Time Max Time
TRAFODION.SCH.TSTAT
0 100
- 4 4 4 0 12,435 6,357
+ 4 4 4 0 8,692 4,705
- Id TDB Name Mode CPU Time BMO Heap Used BMO Heap Total BMO Heap WM BMO Space BufSz BMO Space BufCnt File Count Scratch Buffer Block Size/Read/Written Scratch IO Count Read/Written
- 6 EX_HASH_GRBY DISK 3,370 4 1,024 7,687 256 0 0 -1 0 0 0 0
+ Id TDB Name Mode TopN CPU Time File Count
+ BMO Heap Used BMO Heap Total BMO Heap WM BMO Space BufSz BMO Space BufCnt
+ ScrBlk Size ScrBlk Read ScrBlk Written ScrIO Read ScrIO Written
+ 6 EX_HASH_GRBY DISK -1 3,491 0
+ 4 1,024 7,687 256 0
+ -1 0 0 0 0
--- SQL operation complete.
>>log;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000017900212349877028870002000000000206U3333300_336_S1 DEFAULT;
-Qid MXID11000017900212349877028870002000000000206U3333300_336_S1
-Compile Start Time 2016/12/30 16:58:17.901889
-Compile End Time 2016/12/30 16:58:17.934090
-Compile Elapsed Time 0:00:00.032201
-Execute Start Time 2016/12/30 16:58:24.336267
-Execute End Time 2016/12/30 16:58:24.354444
-Execute Elapsed Time 0:00:00.018177
+>>display statistics for QID MXID11000008082212350752509978000000000000206U3333300_336_S1 DEFAULT;
+Qid MXID11000008082212350752509978000000000000206U3333300_336_S1
+Compile Start Time 2017/01/09 20:10:26.602817
+Compile End Time 2017/01/09 20:10:26.667823
+Compile Elapsed Time 0:00:00.065006
+Execute Start Time 2017/01/09 20:10:32.694186
+Execute End Time 2017/01/09 20:10:32.714103
+Execute Elapsed Time 0:00:00.019917
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -2231,7 +2245,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2016/12/30 16:58:24.352424
+First Row Returned Time 2017/01/09 20:10:32.710668
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -2242,27 +2256,27 @@ Stats Collection Type OPERATOR_STATS
LC RC Id PaId ExId Frag TDB Name DOP Dispatches Oper CPU Time Est. Records Used Act. Records Used Details
-10 . 11 . 5 0 EX_ROOT 1 5 28 0 4 1452
-9 . 10 11 4 0 EX_SPLIT_TOP 1 5 7 2 4
-8 . 9 10 4 0 EX_SEND_TOP 2 10 1,417 2 4
-7 . 8 9 4 2 EX_SEND_BOTTOM 2 17 149 2 4
-6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 10 2 4 5048
-5 . 6 7 3 2 EX_HASH_GRBY 2 6 3,370 1 4 0|0|0
-4 . 5 6 2 2 EX_SPLIT_TOP 2 11 14 100 4
-3 . 4 5 2 2 EX_SEND_TOP 4 18 1,505 100 4
-2 . 3 4 2 3 EX_SEND_BOTTOM 4 28 227 100 4
-1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 8 17 100 4 5183
-. . 1 2 1 3 EX_TRAF_KEY_SELECT 6 12 14,817 100 4 TRAFODION.SCH.TSTAT|4|176
-
---- SQL operation complete.
->>get statistics for QID MXID11000017900212349877028870002000000000206U3333300_336_S1 DEFAULT;
-Qid MXID11000017900212349877028870002000000000206U3333300_336_S1
-Compile Start Time 2016/12/30 16:58:17.901889
-Compile End Time 2016/12/30 16:58:17.934090
-Compile Elapsed Time 0:00:00.032201
-Execute Start Time 2016/12/30 16:58:24.336267
-Execute End Time 2016/12/30 16:58:24.354444
-Execute Elapsed Time 0:00:00.018177
+10 . 11 . 5 0 EX_ROOT 1 5 18 0 4 1941
+9 . 10 11 4 0 EX_SPLIT_TOP 1 5 32 2 4
+8 . 9 10 4 0 EX_SEND_TOP 2 10 1,891 2 4
+7 . 8 9 4 2 EX_SEND_BOTTOM 2 17 282 2 4
+6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 83 2 4 5468
+5 . 6 7 3 2 EX_HASH_GRBY 2 6 3,491 1 4 0|0|0
+4 . 5 6 2 2 EX_SPLIT_TOP 2 9 71 100 4
+3 . 4 5 2 2 EX_SEND_TOP 4 18 1,541 100 4
+2 . 3 4 2 3 EX_SEND_BOTTOM 4 24 388 100 4
+1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 8 50 100 4 3814
+. . 1 2 1 3 EX_TRAF_KEY_SELECT 6 12 10,128 100 4 TRAFODION.SCH.TSTAT|4|176
+
+--- SQL operation complete.
+>>get statistics for QID MXID11000008082212350752509978000000000000206U3333300_336_S1 DEFAULT;
+Qid MXID11000008082212350752509978000000000000206U3333300_336_S1
+Compile Start Time 2017/01/09 20:10:26.602817
+Compile End Time 2017/01/09 20:10:26.667823
+Compile Elapsed Time 0:00:00.065006
+Execute Start Time 2017/01/09 20:10:32.694186
+Execute End Time 2017/01/09 20:10:32.714103
+Execute Elapsed Time 0:00:00.019917
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -2280,7 +2294,7 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2016/12/30 16:58:24.352424
+First Row Returned Time 2017/01/09 20:10:32.710668
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -2291,28 +2305,28 @@ Stats Collection Type OPERATOR_STATS
LC RC Id PaId ExId Frag TDB Name DOP Dispatches Oper CPU Time Est. Records Used Act. Records Used Details
-10 . 11 . 5 0 EX_ROOT 1 5 28 0 4
-9 . 10 11 4 0 EX_SPLIT_TOP 1 5 7 2 4
-8 . 9 10 4 0 EX_SEND_TOP 2 10 1,417 2 4
-7 . 8 9 4 2 EX_SEND_BOTTOM 2 17 149 2 4
-6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 10 2 4 5048
-5 . 6
<TRUNCATED>