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/07/18 18:06:54 UTC
[1/4] incubator-trafodion git commit: [TRAFODION-2420] RMS
enhancements
Repository: incubator-trafodion
Updated Branches:
refs/heads/master 457e20636 -> a815716ba
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/419c843a/core/sql/regress/core/FILTERRTS
----------------------------------------------------------------------
diff --git a/core/sql/regress/core/FILTERRTS b/core/sql/regress/core/FILTERRTS
index 328732c..a4c6fbc 100755
--- a/core/sql/regress/core/FILTERRTS
+++ b/core/sql/regress/core/FILTERRTS
@@ -53,6 +53,7 @@ s/Number of Cpus[ ]*[0-9,]*/Number of Cpus @numberofcpus@/
s/Number of SQL Processes[ ]*[0-9,]*/Number of SQL Processes @numberofsqlprocesses@/
s/Execution Priority[ ]*[0-9,-]*/Execution Priority @executionpriority@/
s/Transaction Id[ ]*[\0-9A-Z().-]*/Transaction Id @transactionId@/
+s/Execute Time[ ]*[0-9,.]*/Execution Time@executionTime@/
s/Node name[ ]*[\0-9A-Za-z().:-]*/Node name @nodeName@/
s/RMS Version[ ]*[0-9,]*/RMS Version @rmsVersion@/
s/SSCP PID[ ]*[0-9,]*/SSCP PID @sscpPID@/
[4/4] incubator-trafodion git commit: Merge PR 1184 [TRAFODION-2420]
RMS enhancements
Posted by se...@apache.org.
Merge PR 1184 [TRAFODION-2420] RMS enhancements
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/a815716b
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/a815716b
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/a815716b
Branch: refs/heads/master
Commit: a815716ba805d26276d7342770945228ed5d0f6d
Parents: 457e206 419c843
Author: selvaganesang <se...@apache.org>
Authored: Tue Jul 18 18:06:26 2017 +0000
Committer: selvaganesang <se...@apache.org>
Committed: Tue Jul 18 18:06:26 2017 +0000
----------------------------------------------------------------------
core/sql/cli/sqlcli.h | 4 +
core/sql/executor/ExExeUtilGetStats.cpp | 36 +-
core/sql/executor/ExStats.cpp | 17 +
core/sql/executor/ExStats.h | 4 +-
core/sql/regress/core/EXPECTEDRTS | 1820 +++++++++++++++-----------
core/sql/regress/core/FILTERRTS | 1 +
6 files changed, 1103 insertions(+), 779 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/a815716b/core/sql/cli/sqlcli.h
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/a815716b/core/sql/executor/ExStats.cpp
----------------------------------------------------------------------
[2/4] incubator-trafodion git commit: [TRAFODION-2420] RMS
enhancements
Posted by se...@apache.org.
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/419c843a/core/sql/regress/core/EXPECTEDRTS
----------------------------------------------------------------------
diff --git a/core/sql/regress/core/EXPECTEDRTS b/core/sql/regress/core/EXPECTEDRTS
old mode 100755
new mode 100644
index b6273bb..a12f581
--- 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 MXID11000004343212360895605883001000000000206U3333300_279_S1
-Compile Start Time 2017/05/07 05:40:25.200093
-Compile End Time 2017/05/07 05:40:25.230566
-Compile Elapsed Time 0:00:00.030473
+Qid MXID11000024709212367027407408000000000000206U3333300_302_S1
+Compile Start Time 2017/07/17 04:57:16.975498
+Compile End Time 2017/07/17 04:57:17.007581
+Compile Elapsed Time 0:00:00.032083
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -87,6 +87,10 @@ Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 0
+Min. Execute Time 0.000000 secs
+Max. Execute Time 0.000000 secs
+Avg. Execute Time 0.000000 secs
Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
@@ -94,11 +98,11 @@ Stats Collection Type ACCUMULATED_STATS
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000004343212360895605883001000000000206U3333300_279_S1 ;
-Qid MXID11000004343212360895605883001000000000206U3333300_279_S1
-Compile Start Time 2017/05/07 05:40:25.200093
-Compile End Time 2017/05/07 05:40:25.230566
-Compile Elapsed Time 0:00:00.030473
+>>display statistics for QID MXID11000024709212367027407408000000000000206U3333300_302_S1 ;
+Qid MXID11000024709212367027407408000000000000206U3333300_302_S1
+Compile Start Time 2017/07/17 04:57:16.975498
+Compile End Time 2017/07/17 04:57:17.007581
+Compile Elapsed Time 0:00:00.032083
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -126,14 +130,18 @@ Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 0
+Min. Execute Time 0.000000 secs
+Max. Execute Time 0.000000 secs
+Avg. Execute Time 0.000000 secs
Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
->>get statistics for QID MXID11000004343212360895605883001000000000206U3333300_279_S1 ;
-Qid MXID11000004343212360895605883001000000000206U3333300_279_S1
-Compile Start Time 2017/05/07 05:40:25.200093
-Compile End Time 2017/05/07 05:40:25.230566
-Compile Elapsed Time 0:00:00.030473
+>>get statistics for QID MXID11000024709212367027407408000000000000206U3333300_302_S1 ;
+Qid MXID11000024709212367027407408000000000000206U3333300_302_S1
+Compile Start Time 2017/07/17 04:57:16.975498
+Compile End Time 2017/07/17 04:57:17.007581
+Compile Elapsed Time 0:00:00.032083
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -161,15 +169,19 @@ Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 0
+Min. Execute Time 0.000000 secs
+Max. Execute Time 0.000000 secs
+Avg. Execute Time 0.000000 secs
Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
>>log;
>>display statistics for qid current;
-Qid MXID11000004343212360895605883001000000000206U3333300_279_S1
-Compile Start Time 2017/05/07 05:40:25.200093
-Compile End Time 2017/05/07 05:40:25.230566
-Compile Elapsed Time 0:00:00.030473
+Qid MXID11000024709212367027407408000000000000206U3333300_302_S1
+Compile Start Time 2017/07/17 04:57:16.975498
+Compile End Time 2017/07/17 04:57:17.007581
+Compile Elapsed Time 0:00:00.032083
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -197,14 +209,18 @@ Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 0
+Min. Execute Time 0.000000 secs
+Max. Execute Time 0.000000 secs
+Avg. Execute Time 0.000000 secs
Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
>>get statistics for qid current ;
-Qid MXID11000004343212360895605883001000000000206U3333300_279_S1
-Compile Start Time 2017/05/07 05:40:25.200093
-Compile End Time 2017/05/07 05:40:25.230566
-Compile Elapsed Time 0:00:00.030473
+Qid MXID11000024709212367027407408000000000000206U3333300_302_S1
+Compile Start Time 2017/07/17 04:57:16.975498
+Compile End Time 2017/07/17 04:57:17.007581
+Compile Elapsed Time 0:00:00.032083
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -232,6 +248,10 @@ Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 0
+Min. Execute Time 0.000000 secs
+Max. Execute Time 0.000000 secs
+Avg. Execute Time 0.000000 secs
Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
@@ -250,14 +270,14 @@ D
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000004343212360895605883001000000000206U3333300_279_S1 ;
-Qid MXID11000004343212360895605883001000000000206U3333300_279_S1
-Compile Start Time 2017/05/07 05:40:25.200093
-Compile End Time 2017/05/07 05:40:25.230566
-Compile Elapsed Time 0:00:00.030473
-Execute Start Time 2017/05/07 05:40:29.596727
-Execute End Time 2017/05/07 05:40:34.141843
-Execute Elapsed Time 0:00:04.545116
+>>display statistics for QID MXID11000024709212367027407408000000000000206U3333300_302_S1 ;
+Qid MXID11000024709212367027407408000000000000206U3333300_302_S1
+Compile Start Time 2017/07/17 04:57:16.975498
+Compile End Time 2017/07/17 04:57:17.007581
+Compile Elapsed Time 0:00:00.032083
+Execute Start Time 2017/07/17 04:57:23.613254
+Execute End Time 2017/07/17 04:57:26.843039
+Execute Elapsed Time 0:00:03.229785
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -275,32 +295,36 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/05/07 05:40:34.139345
+First Row Returned Time 2017/07/17 04:57:26.841272
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 1
+Min. Execute Time 3.229785 secs
+Max. Execute Time 3.229785 secs
+Avg. Execute Time 3.229785 secs
Stats Collection Type ACCUMULATED_STATS
Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 725,870
-SQL Process Busy Time 5,717,075
+SE IO MAX Time 689,510
+SQL Process Busy Time 4,385,817
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
-SQL Heap Allocated 10,472 KB
+SQL Heap Allocated 10,471 KB
SQL Heap Used 80 KB
SQL Heap WM 67 KB
Processes Created 2
-Process Create Time 150,942
+Process Create Time 141,744
Request Message Count 26
-Request Message Bytes 39,808
+Request Message Bytes 39,392
Reply Message Count 15
-Reply Message Bytes 38,840
+Reply Message Bytes 38,792
BMO Space Buffer Size 0
BMO Space Buffer Count 0
BMO Interim Row Count 0
@@ -313,14 +337,14 @@ Scr. IO Max Time 0
Sort TopN -1
--- SQL operation complete.
->>get statistics for QID MXID11000004343212360895605883001000000000206U3333300_279_S1 ;
-Qid MXID11000004343212360895605883001000000000206U3333300_279_S1
-Compile Start Time 2017/05/07 05:40:25.200093
-Compile End Time 2017/05/07 05:40:25.230566
-Compile Elapsed Time 0:00:00.030473
-Execute Start Time 2017/05/07 05:40:29.596727
-Execute End Time 2017/05/07 05:40:34.141843
-Execute Elapsed Time 0:00:04.545116
+>>get statistics for QID MXID11000024709212367027407408000000000000206U3333300_302_S1 ;
+Qid MXID11000024709212367027407408000000000000206U3333300_302_S1
+Compile Start Time 2017/07/17 04:57:16.975498
+Compile End Time 2017/07/17 04:57:17.007581
+Compile Elapsed Time 0:00:00.032083
+Execute Start Time 2017/07/17 04:57:23.613254
+Execute End Time 2017/07/17 04:57:26.843039
+Execute Elapsed Time 0:00:03.229785
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -338,32 +362,36 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/05/07 05:40:34.139345
+First Row Returned Time 2017/07/17 04:57:26.841272
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 1
+Min. Execute Time 3.229785 secs
+Max. Execute Time 3.229785 secs
+Avg. Execute Time 3.229785 secs
Stats Collection Type ACCUMULATED_STATS
Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 725,870
-SQL Process Busy Time 5,717,075
+SE IO MAX Time 689,510
+SQL Process Busy Time 4,385,817
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
-SQL Heap Allocated 10,472 KB
+SQL Heap Allocated 10,471 KB
SQL Heap Used 80 KB
SQL Heap WM 67 KB
Processes Created 2
-Process Create Time 150,942
+Process Create Time 141,744
Request Message Count 26
-Request Message Bytes 39,808
+Request Message Bytes 39,392
Reply Message Count 15
-Reply Message Bytes 38,840
+Reply Message Bytes 38,792
BMO Space Buffer Size 0
BMO Space Buffer Count 0
BMO Interim Row Count 0
@@ -378,13 +406,13 @@ Sort TopN -1
--- SQL operation complete.
>>log;
>>display statistics for qid current;
-Qid MXID11000004343212360895605883001000000000206U3333300_279_S1
-Compile Start Time 2017/05/07 05:40:25.200093
-Compile End Time 2017/05/07 05:40:25.230566
-Compile Elapsed Time 0:00:00.030473
-Execute Start Time 2017/05/07 05:40:29.596727
-Execute End Time 2017/05/07 05:40:34.141843
-Execute Elapsed Time 0:00:04.545116
+Qid MXID11000024709212367027407408000000000000206U3333300_302_S1
+Compile Start Time 2017/07/17 04:57:16.975498
+Compile End Time 2017/07/17 04:57:17.007581
+Compile Elapsed Time 0:00:00.032083
+Execute Start Time 2017/07/17 04:57:23.613254
+Execute End Time 2017/07/17 04:57:26.843039
+Execute Elapsed Time 0:00:03.229785
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -402,32 +430,36 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/05/07 05:40:34.139345
+First Row Returned Time 2017/07/17 04:57:26.841272
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 1
+Min. Execute Time 3.229785 secs
+Max. Execute Time 3.229785 secs
+Avg. Execute Time 3.229785 secs
Stats Collection Type ACCUMULATED_STATS
Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 725,870
-SQL Process Busy Time 5,717,075
+SE IO MAX Time 689,510
+SQL Process Busy Time 4,385,817
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
-SQL Heap Allocated 10,472 KB
+SQL Heap Allocated 10,471 KB
SQL Heap Used 80 KB
SQL Heap WM 67 KB
Processes Created 2
-Process Create Time 150,942
+Process Create Time 141,744
Request Message Count 26
-Request Message Bytes 39,808
+Request Message Bytes 39,392
Reply Message Count 15
-Reply Message Bytes 38,840
+Reply Message Bytes 38,792
BMO Space Buffer Size 0
BMO Space Buffer Count 0
BMO Interim Row Count 0
@@ -441,13 +473,13 @@ Sort TopN -1
--- SQL operation complete.
>>get statistics for qid current ;
-Qid MXID11000004343212360895605883001000000000206U3333300_279_S1
-Compile Start Time 2017/05/07 05:40:25.200093
-Compile End Time 2017/05/07 05:40:25.230566
-Compile Elapsed Time 0:00:00.030473
-Execute Start Time 2017/05/07 05:40:29.596727
-Execute End Time 2017/05/07 05:40:34.141843
-Execute Elapsed Time 0:00:04.545116
+Qid MXID11000024709212367027407408000000000000206U3333300_302_S1
+Compile Start Time 2017/07/17 04:57:16.975498
+Compile End Time 2017/07/17 04:57:17.007581
+Compile Elapsed Time 0:00:00.032083
+Execute Start Time 2017/07/17 04:57:23.613254
+Execute End Time 2017/07/17 04:57:26.843039
+Execute Elapsed Time 0:00:03.229785
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -465,32 +497,36 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/05/07 05:40:34.139345
+First Row Returned Time 2017/07/17 04:57:26.841272
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 1
+Min. Execute Time 3.229785 secs
+Max. Execute Time 3.229785 secs
+Avg. Execute Time 3.229785 secs
Stats Collection Type ACCUMULATED_STATS
Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 725,870
-SQL Process Busy Time 5,717,075
+SE IO MAX Time 689,510
+SQL Process Busy Time 4,385,817
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
-SQL Heap Allocated 10,472 KB
+SQL Heap Allocated 10,471 KB
SQL Heap Used 80 KB
SQL Heap WM 67 KB
Processes Created 2
-Process Create Time 150,942
+Process Create Time 141,744
Request Message Count 26
-Request Message Bytes 39,808
+Request Message Bytes 39,392
Reply Message Count 15
-Reply Message Bytes 38,840
+Reply Message Bytes 38,792
BMO Space Buffer Size 0
BMO Space Buffer Count 0
BMO Interim Row Count 0
@@ -510,25 +546,25 @@ Sort TopN -1
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000004343212360895605883001000000000206U3333300_279_S1 ;
+>>display statistics for QID MXID11000024709212367027407408000000000000206U3333300_302_S1 ;
-*** ERROR[8923] The given Query Id MXID11000004343212360895605883001000000000206U3333300_279_S1 is not found.
+*** ERROR[8923] The given Query Id MXID11000024709212367027407408000000000000206U3333300_302_S1 is not found.
--- SQL operation failed with errors.
->>get statistics for QID MXID11000004343212360895605883001000000000206U3333300_279_S1 ;
+>>get statistics for QID MXID11000024709212367027407408000000000000206U3333300_302_S1 ;
-*** ERROR[8923] The given Query Id MXID11000004343212360895605883001000000000206U3333300_279_S1 is not found.
+*** ERROR[8923] The given Query Id MXID11000024709212367027407408000000000000206U3333300_302_S1 is not found.
--- SQL operation failed with errors.
>>log;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000004343212360895605883001000000000206U3333300_288_S1 ;
-Qid MXID11000004343212360895605883001000000000206U3333300_288_S1
-Compile Start Time 2017/05/07 05:40:41.529514
-Compile End Time 2017/05/07 05:40:41.530838
-Compile Elapsed Time 0:00:00.001324
+>>display statistics for QID MXID11000024709212367027407408000000000000206U3333300_311_S1 ;
+Qid MXID11000024709212367027407408000000000000206U3333300_311_S1
+Compile Start Time 2017/07/17 04:57:33.096199
+Compile End Time 2017/07/17 04:57:33.096764
+Compile Elapsed Time 0:00:00.000565
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -556,14 +592,18 @@ Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 0
+Min. Execute Time 0.000000 secs
+Max. Execute Time 0.000000 secs
+Avg. Execute Time 0.000000 secs
Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
->>get statistics for QID MXID11000004343212360895605883001000000000206U3333300_288_S1 ;
-Qid MXID11000004343212360895605883001000000000206U3333300_288_S1
-Compile Start Time 2017/05/07 05:40:41.529514
-Compile End Time 2017/05/07 05:40:41.530838
-Compile Elapsed Time 0:00:00.001324
+>>get statistics for QID MXID11000024709212367027407408000000000000206U3333300_311_S1 ;
+Qid MXID11000024709212367027407408000000000000206U3333300_311_S1
+Compile Start Time 2017/07/17 04:57:33.096199
+Compile End Time 2017/07/17 04:57:33.096764
+Compile Elapsed Time 0:00:00.000565
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -591,15 +631,19 @@ Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 0
+Min. Execute Time 0.000000 secs
+Max. Execute Time 0.000000 secs
+Avg. Execute Time 0.000000 secs
Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
>>log;
>>display statistics for qid current;
-Qid MXID11000004343212360895605883001000000000206U3333300_288_S1
-Compile Start Time 2017/05/07 05:40:41.529514
-Compile End Time 2017/05/07 05:40:41.530838
-Compile Elapsed Time 0:00:00.001324
+Qid MXID11000024709212367027407408000000000000206U3333300_311_S1
+Compile Start Time 2017/07/17 04:57:33.096199
+Compile End Time 2017/07/17 04:57:33.096764
+Compile Elapsed Time 0:00:00.000565
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -627,14 +671,18 @@ Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 0
+Min. Execute Time 0.000000 secs
+Max. Execute Time 0.000000 secs
+Avg. Execute Time 0.000000 secs
Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
>>get statistics for qid current ;
-Qid MXID11000004343212360895605883001000000000206U3333300_288_S1
-Compile Start Time 2017/05/07 05:40:41.529514
-Compile End Time 2017/05/07 05:40:41.530838
-Compile Elapsed Time 0:00:00.001324
+Qid MXID11000024709212367027407408000000000000206U3333300_311_S1
+Compile Start Time 2017/07/17 04:57:33.096199
+Compile End Time 2017/07/17 04:57:33.096764
+Compile Elapsed Time 0:00:00.000565
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -662,6 +710,10 @@ Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 0
+Min. Execute Time 0.000000 secs
+Max. Execute Time 0.000000 secs
+Avg. Execute Time 0.000000 secs
Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
@@ -678,10 +730,10 @@ Stats Collection Type ACCUMULATED_STATS
--- SQL command prepared.
>>log;
>>get statistics for qid current ;
-Qid MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time 2017/05/07 05:40:49.935790
-Compile End Time 2017/05/07 05:40:49.977030
-Compile Elapsed Time 0:00:00.041240
+Qid MXID11000024709212367027407408000000000000206U3333300_316_S1
+Compile Start Time 2017/07/17 04:57:39.632898
+Compile End Time 2017/07/17 04:57:39.665467
+Compile Elapsed Time 0:00:00.032569
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -709,6 +761,10 @@ Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 0
+Min. Execute Time 0.000000 secs
+Max. Execute Time 0.000000 secs
+Avg. Execute Time 0.000000 secs
Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
@@ -716,11 +772,11 @@ Stats Collection Type PERTABLE_STATS
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000004343212360895605883001000000000206U3333300_293_S1 ;
-Qid MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time 2017/05/07 05:40:49.935790
-Compile End Time 2017/05/07 05:40:49.977030
-Compile Elapsed Time 0:00:00.041240
+>>display statistics for QID MXID11000024709212367027407408000000000000206U3333300_316_S1 ;
+Qid MXID11000024709212367027407408000000000000206U3333300_316_S1
+Compile Start Time 2017/07/17 04:57:39.632898
+Compile End Time 2017/07/17 04:57:39.665467
+Compile Elapsed Time 0:00:00.032569
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -748,14 +804,18 @@ Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 0
+Min. Execute Time 0.000000 secs
+Max. Execute Time 0.000000 secs
+Avg. Execute Time 0.000000 secs
Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
->>get statistics for QID MXID11000004343212360895605883001000000000206U3333300_293_S1 ;
-Qid MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time 2017/05/07 05:40:49.935790
-Compile End Time 2017/05/07 05:40:49.977030
-Compile Elapsed Time 0:00:00.041240
+>>get statistics for QID MXID11000024709212367027407408000000000000206U3333300_316_S1 ;
+Qid MXID11000024709212367027407408000000000000206U3333300_316_S1
+Compile Start Time 2017/07/17 04:57:39.632898
+Compile End Time 2017/07/17 04:57:39.665467
+Compile Elapsed Time 0:00:00.032569
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -783,6 +843,10 @@ Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 0
+Min. Execute Time 0.000000 secs
+Max. Execute Time 0.000000 secs
+Avg. Execute Time 0.000000 secs
Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
@@ -790,11 +854,11 @@ Stats Collection Type PERTABLE_STATS
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000004343212360895605883001000000000206U3333300_293_S1 ACCUMULATED;
-Qid MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time 2017/05/07 05:40:49.935790
-Compile End Time 2017/05/07 05:40:49.977030
-Compile Elapsed Time 0:00:00.041240
+>>display statistics for QID MXID11000024709212367027407408000000000000206U3333300_316_S1 ACCUMULATED;
+Qid MXID11000024709212367027407408000000000000206U3333300_316_S1
+Compile Start Time 2017/07/17 04:57:39.632898
+Compile End Time 2017/07/17 04:57:39.665467
+Compile Elapsed Time 0:00:00.032569
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -822,14 +886,18 @@ Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 0
+Min. Execute Time 0.000000 secs
+Max. Execute Time 0.000000 secs
+Avg. Execute Time 0.000000 secs
Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
->>get statistics for QID MXID11000004343212360895605883001000000000206U3333300_293_S1 ACCUMULATED;
-Qid MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time 2017/05/07 05:40:49.935790
-Compile End Time 2017/05/07 05:40:49.977030
-Compile Elapsed Time 0:00:00.041240
+>>get statistics for QID MXID11000024709212367027407408000000000000206U3333300_316_S1 ACCUMULATED;
+Qid MXID11000024709212367027407408000000000000206U3333300_316_S1
+Compile Start Time 2017/07/17 04:57:39.632898
+Compile End Time 2017/07/17 04:57:39.665467
+Compile Elapsed Time 0:00:00.032569
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -857,15 +925,19 @@ Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 0
+Min. Execute Time 0.000000 secs
+Max. Execute Time 0.000000 secs
+Avg. Execute Time 0.000000 secs
Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
>>log;
>>display statistics for qid current;
-Qid MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time 2017/05/07 05:40:49.935790
-Compile End Time 2017/05/07 05:40:49.977030
-Compile Elapsed Time 0:00:00.041240
+Qid MXID11000024709212367027407408000000000000206U3333300_316_S1
+Compile Start Time 2017/07/17 04:57:39.632898
+Compile End Time 2017/07/17 04:57:39.665467
+Compile Elapsed Time 0:00:00.032569
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -893,14 +965,18 @@ Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 0
+Min. Execute Time 0.000000 secs
+Max. Execute Time 0.000000 secs
+Avg. Execute Time 0.000000 secs
Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
>>get statistics for qid current ;
-Qid MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time 2017/05/07 05:40:49.935790
-Compile End Time 2017/05/07 05:40:49.977030
-Compile Elapsed Time 0:00:00.041240
+Qid MXID11000024709212367027407408000000000000206U3333300_316_S1
+Compile Start Time 2017/07/17 04:57:39.632898
+Compile End Time 2017/07/17 04:57:39.665467
+Compile Elapsed Time 0:00:00.032569
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -928,14 +1004,18 @@ Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 0
+Min. Execute Time 0.000000 secs
+Max. Execute Time 0.000000 secs
+Avg. Execute Time 0.000000 secs
Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
>>display statistics for qid current accumulated ;
-Qid MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time 2017/05/07 05:40:49.935790
-Compile End Time 2017/05/07 05:40:49.977030
-Compile Elapsed Time 0:00:00.041240
+Qid MXID11000024709212367027407408000000000000206U3333300_316_S1
+Compile Start Time 2017/07/17 04:57:39.632898
+Compile End Time 2017/07/17 04:57:39.665467
+Compile Elapsed Time 0:00:00.032569
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -963,14 +1043,18 @@ Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 0
+Min. Execute Time 0.000000 secs
+Max. Execute Time 0.000000 secs
+Avg. Execute Time 0.000000 secs
Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
>>get statistics for qid current accumulated ;
-Qid MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time 2017/05/07 05:40:49.935790
-Compile End Time 2017/05/07 05:40:49.977030
-Compile Elapsed Time 0:00:00.041240
+Qid MXID11000024709212367027407408000000000000206U3333300_316_S1
+Compile Start Time 2017/07/17 04:57:39.632898
+Compile End Time 2017/07/17 04:57:39.665467
+Compile Elapsed Time 0:00:00.032569
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -998,6 +1082,10 @@ Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 0
+Min. Execute Time 0.000000 secs
+Max. Execute Time 0.000000 secs
+Avg. Execute Time 0.000000 secs
Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
@@ -1006,24 +1094,24 @@ Stats Collection Type PERTABLE_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 MXID11000004343212360895605883001000000000206U3333300_293_S1 ;
-Qid MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time 2017/05/07 05:40:49.935790
-Compile End Time 2017/05/07 05:40:49.977030
-Compile Elapsed Time 0:00:00.041240
-Execute Start Time 2017/05/07 05:40:58.496745
-Execute End Time 2017/05/07 05:40:58.522185
-Execute Elapsed Time 0:00:00.025440
+>>display statistics for QID MXID11000024709212367027407408000000000000206U3333300_316_S1 ;
+Qid MXID11000024709212367027407408000000000000206U3333300_316_S1
+Compile Start Time 2017/07/17 04:57:39.632898
+Compile End Time 2017/07/17 04:57:39.665467
+Compile Elapsed Time 0:00:00.032569
+Execute Start Time 2017/07/17 04:57:49.683630
+Execute End Time 2017/07/17 04:57:49.695340
+Execute Elapsed Time 0:00:00.011710
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1041,15 +1129,19 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/05/07 05:40:58.520309
+First Row Returned Time 2017/07/17 04:57:49.693689
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 1
+Min. Execute Time 0.011710 secs
+Max. Execute Time 0.011710 secs
+Avg. Execute Time 0.011710 secs
Stats Collection Type PERTABLE_STATS
-SQL Process Busy Time 15,419
+SQL Process Busy Time 5,776
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
@@ -1059,9 +1151,9 @@ SQL Heap WM 10,338 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,968
+Request Message Bytes 39,552
Reply Message Count 15
-Reply Message Bytes 39,264
+Reply Message Bytes 39,208
BMO Space Buffer Size 0
BMO Space Buffer Count 0
BMO Interim Row Count 0
@@ -1074,19 +1166,19 @@ Scr. IO Max Time 0
Sort TopN -1
Id DOP Table Name
- EstRowsAccess ActRowsAccess EstRowsUsed ActRowsUsed SE_IOs SE_IO_KBytes SE_IO_SumTime SE_IO_MaxTime
+ EstRowsAccess ActRowsAccess EstRowsUsed ActRowsUsed SE_IOs SE_IO_KBytes SE_IO_SumTime SE_IO_MaxTime
1 2 TRAFODION.SCH.TSTAT
- 0 4 100 4 4 0 20,398 10,610
+ 0 4 100 4 4 0 5,738 2,914
--- SQL operation complete.
->>get statistics for QID MXID11000004343212360895605883001000000000206U3333300_293_S1 ;
-Qid MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time 2017/05/07 05:40:49.935790
-Compile End Time 2017/05/07 05:40:49.977030
-Compile Elapsed Time 0:00:00.041240
-Execute Start Time 2017/05/07 05:40:58.496745
-Execute End Time 2017/05/07 05:40:58.522185
-Execute Elapsed Time 0:00:00.025440
+>>get statistics for QID MXID11000024709212367027407408000000000000206U3333300_316_S1 ;
+Qid MXID11000024709212367027407408000000000000206U3333300_316_S1
+Compile Start Time 2017/07/17 04:57:39.632898
+Compile End Time 2017/07/17 04:57:39.665467
+Compile Elapsed Time 0:00:00.032569
+Execute Start Time 2017/07/17 04:57:49.683630
+Execute End Time 2017/07/17 04:57:49.695340
+Execute Elapsed Time 0:00:00.011710
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1104,15 +1196,19 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/05/07 05:40:58.520309
+First Row Returned Time 2017/07/17 04:57:49.693689
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 1
+Min. Execute Time 0.011710 secs
+Max. Execute Time 0.011710 secs
+Avg. Execute Time 0.011710 secs
Stats Collection Type PERTABLE_STATS
-SQL Process Busy Time 15,419
+SQL Process Busy Time 5,776
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
@@ -1122,9 +1218,9 @@ SQL Heap WM 10,338 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,968
+Request Message Bytes 39,552
Reply Message Count 15
-Reply Message Bytes 39,264
+Reply Message Bytes 39,208
BMO Space Buffer Size 0
BMO Space Buffer Count 0
BMO Interim Row Count 0
@@ -1137,23 +1233,23 @@ Scr. IO Max Time 0
Sort TopN -1
Id DOP Table Name
- EstRowsAccess ActRowsAccess EstRowsUsed ActRowsUsed SE_IOs SE_IO_KBytes SE_IO_SumTime SE_IO_MaxTime
+ EstRowsAccess ActRowsAccess EstRowsUsed ActRowsUsed SE_IOs SE_IO_KBytes SE_IO_SumTime SE_IO_MaxTime
1 2 TRAFODION.SCH.TSTAT
- 0 4 100 4 4 0 20,398 10,610
+ 0 4 100 4 4 0 5,738 2,914
--- SQL operation complete.
>>log;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000004343212360895605883001000000000206U3333300_293_S1 ACCUMULATED;
-Qid MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time 2017/05/07 05:40:49.935790
-Compile End Time 2017/05/07 05:40:49.977030
-Compile Elapsed Time 0:00:00.041240
-Execute Start Time 2017/05/07 05:40:58.496745
-Execute End Time 2017/05/07 05:40:58.522185
-Execute Elapsed Time 0:00:00.025440
+>>display statistics for QID MXID11000024709212367027407408000000000000206U3333300_316_S1 ACCUMULATED;
+Qid MXID11000024709212367027407408000000000000206U3333300_316_S1
+Compile Start Time 2017/07/17 04:57:39.632898
+Compile End Time 2017/07/17 04:57:39.665467
+Compile Elapsed Time 0:00:00.032569
+Execute Start Time 2017/07/17 04:57:49.683630
+Execute End Time 2017/07/17 04:57:49.695340
+Execute Elapsed Time 0:00:00.011710
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1171,20 +1267,24 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/05/07 05:40:58.520309
+First Row Returned Time 2017/07/17 04:57:49.693689
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 1
+Min. Execute Time 0.011710 secs
+Max. Execute Time 0.011710 secs
+Avg. Execute Time 0.011710 secs
Stats Collection Type PERTABLE_STATS
Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 10,610
-SQL Process Busy Time 15,419
+SE IO MAX Time 2,914
+SQL Process Busy Time 5,776
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
@@ -1194,9 +1294,9 @@ SQL Heap WM 10,338 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,968
+Request Message Bytes 39,552
Reply Message Count 15
-Reply Message Bytes 39,264
+Reply Message Bytes 39,208
BMO Space Buffer Size 0
BMO Space Buffer Count 0
BMO Interim Row Count 0
@@ -1209,14 +1309,14 @@ Scr. IO Max Time 0
Sort TopN -1
--- SQL operation complete.
->>get statistics for QID MXID11000004343212360895605883001000000000206U3333300_293_S1 ACCUMULATED;
-Qid MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time 2017/05/07 05:40:49.935790
-Compile End Time 2017/05/07 05:40:49.977030
-Compile Elapsed Time 0:00:00.041240
-Execute Start Time 2017/05/07 05:40:58.496745
-Execute End Time 2017/05/07 05:40:58.522185
-Execute Elapsed Time 0:00:00.025440
+>>get statistics for QID MXID11000024709212367027407408000000000000206U3333300_316_S1 ACCUMULATED;
+Qid MXID11000024709212367027407408000000000000206U3333300_316_S1
+Compile Start Time 2017/07/17 04:57:39.632898
+Compile End Time 2017/07/17 04:57:39.665467
+Compile Elapsed Time 0:00:00.032569
+Execute Start Time 2017/07/17 04:57:49.683630
+Execute End Time 2017/07/17 04:57:49.695340
+Execute Elapsed Time 0:00:00.011710
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1234,20 +1334,24 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/05/07 05:40:58.520309
+First Row Returned Time 2017/07/17 04:57:49.693689
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 1
+Min. Execute Time 0.011710 secs
+Max. Execute Time 0.011710 secs
+Avg. Execute Time 0.011710 secs
Stats Collection Type PERTABLE_STATS
Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 10,610
-SQL Process Busy Time 15,419
+SE IO MAX Time 2,914
+SQL Process Busy Time 5,776
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
@@ -1257,9 +1361,9 @@ SQL Heap WM 10,338 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,968
+Request Message Bytes 39,552
Reply Message Count 15
-Reply Message Bytes 39,264
+Reply Message Bytes 39,208
BMO Space Buffer Size 0
BMO Space Buffer Count 0
BMO Interim Row Count 0
@@ -1274,13 +1378,13 @@ Sort TopN -1
--- SQL operation complete.
>>log;
>>display statistics for qid current;
-Qid MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time 2017/05/07 05:40:49.935790
-Compile End Time 2017/05/07 05:40:49.977030
-Compile Elapsed Time 0:00:00.041240
-Execute Start Time 2017/05/07 05:40:58.496745
-Execute End Time 2017/05/07 05:40:58.522185
-Execute Elapsed Time 0:00:00.025440
+Qid MXID11000024709212367027407408000000000000206U3333300_316_S1
+Compile Start Time 2017/07/17 04:57:39.632898
+Compile End Time 2017/07/17 04:57:39.665467
+Compile Elapsed Time 0:00:00.032569
+Execute Start Time 2017/07/17 04:57:49.683630
+Execute End Time 2017/07/17 04:57:49.695340
+Execute Elapsed Time 0:00:00.011710
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1298,15 +1402,19 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/05/07 05:40:58.520309
+First Row Returned Time 2017/07/17 04:57:49.693689
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 1
+Min. Execute Time 0.011710 secs
+Max. Execute Time 0.011710 secs
+Avg. Execute Time 0.011710 secs
Stats Collection Type PERTABLE_STATS
-SQL Process Busy Time 15,419
+SQL Process Busy Time 5,776
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
@@ -1316,9 +1424,9 @@ SQL Heap WM 10,338 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,968
+Request Message Bytes 39,552
Reply Message Count 15
-Reply Message Bytes 39,264
+Reply Message Bytes 39,208
BMO Space Buffer Size 0
BMO Space Buffer Count 0
BMO Interim Row Count 0
@@ -1331,19 +1439,19 @@ Scr. IO Max Time 0
Sort TopN -1
Id DOP Table Name
- EstRowsAccess ActRowsAccess EstRowsUsed ActRowsUsed SE_IOs SE_IO_KBytes SE_IO_SumTime SE_IO_MaxTime
+ EstRowsAccess ActRowsAccess EstRowsUsed ActRowsUsed SE_IOs SE_IO_KBytes SE_IO_SumTime SE_IO_MaxTime
1 2 TRAFODION.SCH.TSTAT
- 0 4 100 4 4 0 20,398 10,610
+ 0 4 100 4 4 0 5,738 2,914
--- SQL operation complete.
>>get statistics for qid current ;
-Qid MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time 2017/05/07 05:40:49.935790
-Compile End Time 2017/05/07 05:40:49.977030
-Compile Elapsed Time 0:00:00.041240
-Execute Start Time 2017/05/07 05:40:58.496745
-Execute End Time 2017/05/07 05:40:58.522185
-Execute Elapsed Time 0:00:00.025440
+Qid MXID11000024709212367027407408000000000000206U3333300_316_S1
+Compile Start Time 2017/07/17 04:57:39.632898
+Compile End Time 2017/07/17 04:57:39.665467
+Compile Elapsed Time 0:00:00.032569
+Execute Start Time 2017/07/17 04:57:49.683630
+Execute End Time 2017/07/17 04:57:49.695340
+Execute Elapsed Time 0:00:00.011710
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1361,15 +1469,19 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/05/07 05:40:58.520309
+First Row Returned Time 2017/07/17 04:57:49.693689
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 1
+Min. Execute Time 0.011710 secs
+Max. Execute Time 0.011710 secs
+Avg. Execute Time 0.011710 secs
Stats Collection Type PERTABLE_STATS
-SQL Process Busy Time 15,419
+SQL Process Busy Time 5,776
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
@@ -1379,9 +1491,9 @@ SQL Heap WM 10,338 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,968
+Request Message Bytes 39,552
Reply Message Count 15
-Reply Message Bytes 39,264
+Reply Message Bytes 39,208
BMO Space Buffer Size 0
BMO Space Buffer Count 0
BMO Interim Row Count 0
@@ -1394,19 +1506,19 @@ Scr. IO Max Time 0
Sort TopN -1
Id DOP Table Name
- EstRowsAccess ActRowsAccess EstRowsUsed ActRowsUsed SE_IOs SE_IO_KBytes SE_IO_SumTime SE_IO_MaxTime
+ EstRowsAccess ActRowsAccess EstRowsUsed ActRowsUsed SE_IOs SE_IO_KBytes SE_IO_SumTime SE_IO_MaxTime
1 2 TRAFODION.SCH.TSTAT
- 0 4 100 4 4 0 20,398 10,610
+ 0 4 100 4 4 0 5,738 2,914
--- SQL operation complete.
>>display statistics for qid current accumulated;
-Qid MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time 2017/05/07 05:40:49.935790
-Compile End Time 2017/05/07 05:40:49.977030
-Compile Elapsed Time 0:00:00.041240
-Execute Start Time 2017/05/07 05:40:58.496745
-Execute End Time 2017/05/07 05:40:58.522185
-Execute Elapsed Time 0:00:00.025440
+Qid MXID11000024709212367027407408000000000000206U3333300_316_S1
+Compile Start Time 2017/07/17 04:57:39.632898
+Compile End Time 2017/07/17 04:57:39.665467
+Compile Elapsed Time 0:00:00.032569
+Execute Start Time 2017/07/17 04:57:49.683630
+Execute End Time 2017/07/17 04:57:49.695340
+Execute Elapsed Time 0:00:00.011710
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1424,20 +1536,24 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/05/07 05:40:58.520309
+First Row Returned Time 2017/07/17 04:57:49.693689
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 1
+Min. Execute Time 0.011710 secs
+Max. Execute Time 0.011710 secs
+Avg. Execute Time 0.011710 secs
Stats Collection Type PERTABLE_STATS
Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 10,610
-SQL Process Busy Time 15,419
+SE IO MAX Time 2,914
+SQL Process Busy Time 5,776
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
@@ -1447,9 +1563,9 @@ SQL Heap WM 10,338 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,968
+Request Message Bytes 39,552
Reply Message Count 15
-Reply Message Bytes 39,264
+Reply Message Bytes 39,208
BMO Space Buffer Size 0
BMO Space Buffer Count 0
BMO Interim Row Count 0
@@ -1463,13 +1579,13 @@ Sort TopN -1
--- SQL operation complete.
>>get statistics for qid current accumulated;
-Qid MXID11000004343212360895605883001000000000206U3333300_293_S1
-Compile Start Time 2017/05/07 05:40:49.935790
-Compile End Time 2017/05/07 05:40:49.977030
-Compile Elapsed Time 0:00:00.041240
-Execute Start Time 2017/05/07 05:40:58.496745
-Execute End Time 2017/05/07 05:40:58.522185
-Execute Elapsed Time 0:00:00.025440
+Qid MXID11000024709212367027407408000000000000206U3333300_316_S1
+Compile Start Time 2017/07/17 04:57:39.632898
+Compile End Time 2017/07/17 04:57:39.665467
+Compile Elapsed Time 0:00:00.032569
+Execute Start Time 2017/07/17 04:57:49.683630
+Execute End Time 2017/07/17 04:57:49.695340
+Execute Elapsed Time 0:00:00.011710
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1487,20 +1603,24 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/05/07 05:40:58.520309
+First Row Returned Time 2017/07/17 04:57:49.693689
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 1
+Min. Execute Time 0.011710 secs
+Max. Execute Time 0.011710 secs
+Avg. Execute Time 0.011710 secs
Stats Collection Type PERTABLE_STATS
Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 10,610
-SQL Process Busy Time 15,419
+SE IO MAX Time 2,914
+SQL Process Busy Time 5,776
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
@@ -1510,9 +1630,9 @@ SQL Heap WM 10,338 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,968
+Request Message Bytes 39,552
Reply Message Count 15
-Reply Message Bytes 39,264
+Reply Message Bytes 39,208
BMO Space Buffer Size 0
BMO Space Buffer Count 0
BMO Interim Row Count 0
@@ -1527,7 +1647,7 @@ Sort TopN -1
--- SQL operation complete.
>>log;
>>obey PQIDOUT;
->>SET SESSION DEFAULT PARENT_QID 'MXID11000004343212360895605883001000000000206U3333300_293_S1';
+>>SET SESSION DEFAULT PARENT_QID 'MXID11000024709212367027407408000000000000206U3333300_316_S1';
--- SQL operation complete.
>>prepare s1 from select distinct d from tstat ;
@@ -1537,11 +1657,11 @@ Sort TopN -1
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000004343212360895605883001000000000206U3333300_307_S1 ;
-Qid MXID11000004343212360895605883001000000000206U3333300_307_S1
-Compile Start Time 2017/05/07 05:41:07.096980
-Compile End Time 2017/05/07 05:41:07.097700
-Compile Elapsed Time 0:00:00.000720
+>>display statistics for QID MXID11000024709212367027407408000000000000206U3333300_330_S1 ;
+Qid MXID11000024709212367027407408000000000000206U3333300_330_S1
+Compile Start Time 2017/07/17 04:57:56.670883
+Compile End Time 2017/07/17 04:57:56.671315
+Compile Elapsed Time 0:00:00.000432
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1553,7 +1673,7 @@ Query Type SQL_SELECT_NON_UNIQUE
Sub Query Type SQL_STMT_NA
Estimated Accessed Rows 0
Estimated Used Rows 0
-Parent Qid MXID11000004343212360895605883001000000000206U3333300_293_S1
+Parent Qid MXID11000024709212367027407408000000000000206U3333300_316_S1
Parent Query System SAME
Child Qid NONE
Number of SQL Processes 1
@@ -1569,14 +1689,18 @@ Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 0
+Min. Execute Time 0.000000 secs
+Max. Execute Time 0.000000 secs
+Avg. Execute Time 0.000000 secs
Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
->>get statistics for QID MXID11000004343212360895605883001000000000206U3333300_307_S1 ;
-Qid MXID11000004343212360895605883001000000000206U3333300_307_S1
-Compile Start Time 2017/05/07 05:41:07.096980
-Compile End Time 2017/05/07 05:41:07.097700
-Compile Elapsed Time 0:00:00.000720
+>>get statistics for QID MXID11000024709212367027407408000000000000206U3333300_330_S1 ;
+Qid MXID11000024709212367027407408000000000000206U3333300_330_S1
+Compile Start Time 2017/07/17 04:57:56.670883
+Compile End Time 2017/07/17 04:57:56.671315
+Compile Elapsed Time 0:00:00.000432
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1588,7 +1712,7 @@ Query Type SQL_SELECT_NON_UNIQUE
Sub Query Type SQL_STMT_NA
Estimated Accessed Rows 0
Estimated Used Rows 0
-Parent Qid MXID11000004343212360895605883001000000000206U3333300_293_S1
+Parent Qid MXID11000024709212367027407408000000000000206U3333300_316_S1
Parent Query System SAME
Child Qid NONE
Number of SQL Processes 1
@@ -1604,6 +1728,10 @@ Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 0
+Min. Execute Time 0.000000 secs
+Max. Execute Time 0.000000 secs
+Avg. Execute Time 0.000000 secs
Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
@@ -1618,11 +1746,11 @@ Stats Collection Type PERTABLE_STATS
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000004343212360895605883001000000000206U3333300_309_S1 ;
-Qid MXID11000004343212360895605883001000000000206U3333300_309_S1
-Compile Start Time 2017/05/07 05:41:17.587174
-Compile End Time 2017/05/07 05:41:17.588229
-Compile Elapsed Time 0:00:00.001055
+>>display statistics for QID MXID11000024709212367027407408000000000000206U3333300_332_S1 ;
+Qid MXID11000024709212367027407408000000000000206U3333300_332_S1
+Compile Start Time 2017/07/17 04:57:59.906249
+Compile End Time 2017/07/17 04:57:59.906902
+Compile Elapsed Time 0:00:00.000653
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1650,14 +1778,18 @@ Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 0
+Min. Execute Time 0.000000 secs
+Max. Execute Time 0.000000 secs
+Avg. Execute Time 0.000000 secs
Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
->>get statistics for QID MXID11000004343212360895605883001000000000206U3333300_309_S1 ;
-Qid MXID11000004343212360895605883001000000000206U3333300_309_S1
-Compile Start Time 2017/05/07 05:41:17.587174
-Compile End Time 2017/05/07 05:41:17.588229
-Compile Elapsed Time 0:00:00.001055
+>>get statistics for QID MXID11000024709212367027407408000000000000206U3333300_332_S1 ;
+Qid MXID11000024709212367027407408000000000000206U3333300_332_S1
+Compile Start Time 2017/07/17 04:57:59.906249
+Compile End Time 2017/07/17 04:57:59.906902
+Compile Elapsed Time 0:00:00.000653
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1685,6 +1817,10 @@ Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 0
+Min. Execute Time 0.000000 secs
+Max. Execute Time 0.000000 secs
+Avg. Execute Time 0.000000 secs
Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
@@ -1704,11 +1840,11 @@ Stats Collection Type PERTABLE_STATS
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000004343212360895605883001000000000206U3333300_312_S1 ;
-Qid MXID11000004343212360895605883001000000000206U3333300_312_S1
-Compile Start Time 2017/05/07 05:41:21.930615
-Compile End Time 2017/05/07 05:41:21.967829
-Compile Elapsed Time 0:00:00.037214
+>>display statistics for QID MXID11000024709212367027407408000000000000206U3333300_335_S1 ;
+Qid MXID11000024709212367027407408000000000000206U3333300_335_S1
+Compile Start Time 2017/07/17 04:58:06.342753
+Compile End Time 2017/07/17 04:58:06.391558
+Compile Elapsed Time 0:00:00.048805
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1736,14 +1872,18 @@ Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 0
+Min. Execute Time 0.000000 secs
+Max. Execute Time 0.000000 secs
+Avg. Execute Time 0.000000 secs
Stats Collection Type OPERATOR_STATS
--- SQL operation complete.
->>get statistics for QID MXID11000004343212360895605883001000000000206U3333300_312_S1 ;
-Qid MXID11000004343212360895605883001000000000206U3333300_312_S1
-Compile Start Time 2017/05/07 05:41:21.930615
-Compile End Time 2017/05/07 05:41:21.967829
-Compile Elapsed Time 0:00:00.037214
+>>get statistics for QID MXID11000024709212367027407408000000000000206U3333300_335_S1 ;
+Qid MXID11000024709212367027407408000000000000206U3333300_335_S1
+Compile Start Time 2017/07/17 04:58:06.342753
+Compile End Time 2017/07/17 04:58:06.391558
+Compile Elapsed Time 0:00:00.048805
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1771,6 +1911,10 @@ Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 0
+Min. Execute Time 0.000000 secs
+Max. Execute Time 0.000000 secs
+Avg. Execute Time 0.000000 secs
Stats Collection Type OPERATOR_STATS
--- SQL operation complete.
@@ -1790,14 +1934,14 @@ D
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000004343212360895605883001000000000206U3333300_312_S1 ;
-Qid MXID11000004343212360895605883001000000000206U3333300_312_S1
-Compile Start Time 2017/05/07 05:41:21.930615
-Compile End Time 2017/05/07 05:41:21.967829
-Compile Elapsed Time 0:00:00.037214
-Execute Start Time 2017/05/07 05:41:26.529910
-Execute End Time 2017/05/07 05:41:26.567047
-Execute Elapsed Time 0:00:00.037137
+>>display statistics for QID MXID11000024709212367027407408000000000000206U3333300_335_S1 ;
+Qid MXID11000024709212367027407408000000000000206U3333300_335_S1
+Compile Start Time 2017/07/17 04:58:06.342753
+Compile End Time 2017/07/17 04:58:06.391558
+Compile Elapsed Time 0:00:00.048805
+Execute Start Time 2017/07/17 04:58:09.741408
+Execute End Time 2017/07/17 04:58:09.757985
+Execute Elapsed Time 0:00:00.016577
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1815,38 +1959,42 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/05/07 05:41:26.564755
+First Row Returned Time 2017/07/17 04:58:09.756320
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 1
+Min. Execute Time 0.016577 secs
+Max. Execute Time 0.016577 secs
+Avg. Execute Time 0.016577 secs
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 10 0 4 24 1975
-9 . 10 11 4 0 EX_SPLIT_TOP 1 5 19 2 4 24
-8 . 9 10 4 0 EX_SEND_TOP 2 10 1,946 2 4 32
-7 . 8 9 4 2 EX_SEND_BOTTOM 2 21 135 2 4 32
-6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 9 2 4 24 5956
-5 . 6 7 3 2 EX_HASH_GRBY 2 6 3,978 1 4 24 0|0|0
-4 . 5 6 2 2 EX_SPLIT_TOP 2 11 22 100 4 24
-3 . 4 5 2 2 EX_SEND_TOP 4 18 1,812 100 4 32
-2 . 3 4 2 3 EX_SEND_BOTTOM 4 42 237 100 4 32
-1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 8 60 100 4 24 11007
-. . 1 2 1 3 EX_TRAF_KEY_SELECT 2 4 10,710 100 4 24 TRAFODION.SCH.TSTAT|4|176
+10 . 11 . 5 0 EX_ROOT 1 5 10 0 4 1694
+9 . 10 11 4 0 EX_SPLIT_TOP 1 5 10 2 4
+8 . 9 10 4 0 EX_SEND_TOP 2 10 1,674 2 4
+7 . 8 9 4 2 EX_SEND_BOTTOM 2 17 119 2 4
+6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 7 2 4 3201
+5 . 6 7 3 2 EX_HASH_GRBY 2 6 2,283 1 4 0|0|0
+4 . 5 6 2 2 EX_SPLIT_TOP 2 11 11 100 4
+3 . 4 5 2 2 EX_SEND_TOP 4 18 781 100 4
+2 . 3 4 2 3 EX_SEND_BOTTOM 4 31 154 100 4
+1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 8 13 100 4 3346
+. . 1 2 1 3 EX_TRAF_KEY_SELECT 2 4 3,179 100 4 TRAFODION.SCH.TSTAT|4|176
--- SQL operation complete.
->>get statistics for QID MXID11000004343212360895605883001000000000206U3333300_312_S1 ;
-Qid MXID11000004343212360895605883001000000000206U3333300_312_S1
-Compile Start Time 2017/05/07 05:41:21.930615
-Compile End Time 2017/05/07 05:41:21.967829
-Compile Elapsed Time 0:00:00.037214
-Execute Start Time 2017/05/07 05:41:26.529910
-Execute End Time 2017/05/07 05:41:26.567047
-Execute Elapsed Time 0:00:00.037137
+>>get statistics for QID MXID11000024709212367027407408000000000000206U3333300_335_S1 ;
+Qid MXID11000024709212367027407408000000000000206U3333300_335_S1
+Compile Start Time 2017/07/17 04:58:06.342753
+Compile End Time 2017/07/17 04:58:06.391558
+Compile Elapsed Time 0:00:00.048805
+Execute Start Time 2017/07/17 04:58:09.741408
+Execute End Time 2017/07/17 04:58:09.757985
+Execute Elapsed Time 0:00:00.016577
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1864,42 +2012,46 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/05/07 05:41:26.564755
+First Row Returned Time 2017/07/17 04:58:09.756320
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 1
+Min. Execute Time 0.016577 secs
+Max. Execute Time 0.016577 secs
+Avg. Execute Time 0.016577 secs
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 10 0 4 24 1975
-9 . 10 11 4 0 EX_SPLIT_TOP 1 5 19 2 4 24
-8 . 9 10 4 0 EX_SEND_TOP 2 10 1,946 2 4 32
-7 . 8 9 4 2 EX_SEND_BOTTOM 2 21 135 2 4 32
-6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 9 2 4 24 5956
-5 . 6 7 3 2 EX_HASH_GRBY 2 6 3,978 1 4 24 0|0|0
-4 . 5 6 2 2 EX_SPLIT_TOP 2 11 22 100 4 24
-3 . 4 5 2 2 EX_SEND_TOP 4 18 1,812 100 4 32
-2 . 3 4 2 3 EX_SEND_BOTTOM 4 42 237 100 4 32
-1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 8 60 100 4 24 11007
-. . 1 2 1 3 EX_TRAF_KEY_SELECT 2 4 10,710 100 4 24 TRAFODION.SCH.TSTAT|4|176
+10 . 11 . 5 0 EX_ROOT 1 5 10 0 4 1694
+9 . 10 11 4 0 EX_SPLIT_TOP 1 5 10 2 4
+8 . 9 10 4 0 EX_SEND_TOP 2 10 1,674 2 4
+7 . 8 9 4 2 EX_SEND_BOTTOM 2 17 119 2 4
+6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 7 2 4 3201
+5 . 6 7 3 2 EX_HASH_GRBY 2 6 2,283 1 4 0|0|0
+4 . 5 6 2 2 EX_SPLIT_TOP 2 11 11 100 4
+3 . 4 5 2 2 EX_SEND_TOP 4 18 781 100 4
+2 . 3 4 2 3 EX_SEND_BOTTOM 4 31 154 100 4
+1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 8 13 100 4 3346
+. . 1 2 1 3 EX_TRAF_KEY_SELECT 2 4 3,179 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 MXID11000004343212360895605883001000000000206U3333300_312_S1 ACCUMULATED;
-Qid MXID11000004343212360895605883001000000000206U3333300_312_S1
-Compile Start Time 2017/05/07 05:41:21.930615
-Compile End Time 2017/05/07 05:41:21.967829
-Compile Elapsed Time 0:00:00.037214
-Execute Start Time 2017/05/07 05:41:26.529910
-Execute End Time 2017/05/07 05:41:26.567047
-Execute Elapsed Time 0:00:00.037137
+>>display statistics for QID MXID11000024709212367027407408000000000000206U3333300_335_S1 ACCUMULATED;
+Qid MXID11000024709212367027407408000000000000206U3333300_335_S1
+Compile Start Time 2017/07/17 04:58:06.342753
+Compile End Time 2017/07/17 04:58:06.391558
+Compile Elapsed Time 0:00:00.048805
+Execute Start Time 2017/07/17 04:58:09.741408
+Execute End Time 2017/07/17 04:58:09.757985
+Execute Elapsed Time 0:00:00.016577
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1917,20 +2069,24 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/05/07 05:41:26.564755
+First Row Returned Time 2017/07/17 04:58:09.756320
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 1
+Min. Execute Time 0.016577 secs
+Max. Execute Time 0.016577 secs
+Avg. Execute Time 0.016577 secs
Stats Collection Type OPERATOR_STATS
Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 12,163
-SQL Process Busy Time 18,938
+SE IO MAX Time 5,606
+SQL Process Busy Time 8,241
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
@@ -1940,9 +2096,9 @@ SQL Heap WM 10,341 KB
Processes Created 0
Process Create Time 0
Request Message Count 28
-Request Message Bytes 40,128
+Request Message Bytes 39,712
Reply Message Count 15
-Reply Message Bytes 42,696
+Reply Message Bytes 42,528
BMO Space Buffer Size 256
BMO Space Buffer Count 0
BMO Interim Row Count 0
@@ -1955,14 +2111,14 @@ Scr. IO Max Time 0
Sort TopN -1
--- SQL operation complete.
->>get statistics for QID MXID11000004343212360895605883001000000000206U3333300_312_S1 ACCUMULATED;
-Qid MXID11000004343212360895605883001000000000206U3333300_312_S1
-Compile Start Time 2017/05/07 05:41:21.930615
-Compile End Time 2017/05/07 05:41:21.967829
-Compile Elapsed Time 0:00:00.037214
-Execute Start Time 2017/05/07 05:41:26.529910
-Execute End Time 2017/05/07 05:41:26.567047
-Execute Elapsed Time 0:00:00.037137
+>>get statistics for QID MXID11000024709212367027407408000000000000206U3333300_335_S1 ACCUMULATED;
+Qid MXID11000024709212367027407408000000000000206U3333300_335_S1
+Compile Start Time 2017/07/17 04:58:06.342753
+Compile End Time 2017/07/17 04:58:06.391558
+Compile Elapsed Time 0:00:00.048805
+Execute Start Time 2017/07/17 04:58:09.741408
+Execute End Time 2017/07/17 04:58:09.757985
+Execute Elapsed Time 0:00:00.016577
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1980,20 +2136,24 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/05/07 05:41:26.564755
+First Row Returned Time 2017/07/17 04:58:09.756320
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 1
+Min. Execute Time 0.016577 secs
+Max. Execute Time 0.016577 secs
+Avg. Execute Time 0.016577 secs
Stats Collection Type OPERATOR_STATS
Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 12,163
-SQL Process Busy Time 18,938
+SE IO MAX Time 5,606
+SQL Process Busy Time 8,241
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
@@ -2003,9 +2163,9 @@ SQL Heap WM 10,341 KB
Processes Created 0
Process Create Time 0
Request Message Count 28
-Request Message Bytes 40,128
+Request Message Bytes 39,712
Reply Message Count 15
-Reply Message Bytes 42,696
+Reply Message Bytes 42,528
BMO Space Buffer Size 256
BMO Space Buffer Count 0
BMO Interim Row Count 0
@@ -2022,14 +2182,14 @@ Sort TopN -1
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000004343212360895605883001000000000206U3333300_312_S1 PERTABLE;
-Qid MXID11000004343212360895605883001000000000206U3333300_312_S1
-Compile Start Time 2017/05/07 05:41:21.930615
-Compile End Time 2017/05/07 05:41:21.967829
-Compile Elapsed Time 0:00:00.037214
-Execute Start Time 2017/05/07 05:41:26.529910
-Execute End Time 2017/05/07 05:41:26.567047
-Execute Elapsed Time 0:00:00.037137
+>>display statistics for QID MXID11000024709212367027407408000000000000206U3333300_335_S1 PERTABLE;
+Qid MXID11000024709212367027407408000000000000206U3333300_335_S1
+Compile Start Time 2017/07/17 04:58:06.342753
+Compile End Time 2017/07/17 04:58:06.391558
+Compile Elapsed Time 0:00:00.048805
+Execute Start Time 2017/07/17 04:58:09.741408
+Execute End Time 2017/07/17 04:58:09.757985
+Execute Elapsed Time 0:00:00.016577
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -2047,15 +2207,19 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/05/07 05:41:26.564755
+First Row Returned Time 2017/07/17 04:58:09.756320
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 1
+Min. Execute Time 0.016577 secs
+Max. Execute Time 0.016577 secs
+Avg. Execute Time 0.016577 secs
Stats Collection Type OPERATOR_STATS
-SQL Process Busy Time 18,938
+SQL Process Busy Time 8,241
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
@@ -2065,9 +2229,9 @@ SQL Heap WM 10,341 KB
Processes Created 0
Process Create Time 0
Request Message Count 28
-Request Message Bytes 40,128
+Request Message Bytes 39,712
Reply Message Count 15
-Reply Message Bytes 42,696
+Reply Message Bytes 42,528
BMO Space Buffer Size 256
BMO Space Buffer Count 0
BMO Interim Row Count 0
@@ -2080,19 +2244,19 @@ Scr. IO Max Time 0
Sort TopN -1
Id DOP Table Name
- EstRowsAccess ActRowsAccess EstRowsUsed ActRowsUsed SE_IOs SE_IO_KBytes SE_IO_SumTime SE_IO_MaxTime
+ EstRowsAccess ActRowsAccess EstRowsUsed ActRowsUsed SE_IOs SE_IO_KBytes SE_IO_SumTime SE_IO_MaxTime
1 2 TRAFODION.SCH.TSTAT
- 0 4 100 4 4 0 22,124 12,163
+ 0 4 100 4 4 0 9,682 5,606
--- SQL operation complete.
->>get statistics for QID MXID11000004343212360895605883001000000000206U3333300_312_S1 PERTABLE;
-Qid MXID11000004343212360895605883001000000000206U3333300_312_S1
-Compile Start Time 2017/05/07 05:41:21.930615
-Compile End Time 2017/05/07 05:41:21.967829
-Compile Elapsed Time 0:00:00.037214
-Execute Start Time 2017/05/07 05:41:26.529910
-Execute End Time 2017/05/07 05:41:26.567047
-Execute Elapsed Time 0:00:00.037137
+>>get statistics for QID MXID11000024709212367027407408000000000000206U3333300_335_S1 PERTABLE;
+Qid MXID11000024709212367027407408000000000000206U3333300_335_S1
+Compile Start Time 2017/07/17 04:58:06.342753
+Compile End Time 2017/07/17 04:58:06.391558
+Compile Elapsed Time 0:00:00.048805
+Execute Start Time 2017/07/17 04:58:09.741408
+Execute End Time 2017/07/17 04:58:09.757985
+Execute Elapsed Time 0:00:00.016577
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -2110,15 +2274,19 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/05/07 05:41:26.564755
+First Row Returned Time 2017/07/17 04:58:09.756320
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 1
+Min. Execute Time 0.016577 secs
+Max. Execute Time 0.016577 secs
+Avg. Execute Time 0.016577 secs
Stats Collection Type OPERATOR_STATS
-SQL Process Busy Time 18,938
+SQL Process Busy Time 8,241
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
@@ -2128,9 +2296,9 @@ SQL Heap WM 10,341 KB
Processes Created 0
Process Create Time 0
Request Message Count 28
-Request Message Bytes 40,128
+Request Message Bytes 39,712
Reply Message Count 15
-Reply Message Bytes 42,696
+Reply Message Bytes 42,528
BMO Space Buffer Size 256
BMO Space Buffer Count 0
BMO Interim Row Count 0
@@ -2143,23 +2311,23 @@ Scr. IO Max Time 0
Sort TopN -1
Id DOP Table Name
- EstRowsAccess ActRowsAccess EstRowsUsed ActRowsUsed SE_IOs SE_IO_KBytes SE_IO_SumTime SE_IO_MaxTime
+ EstRowsAccess ActRowsAccess EstRowsUsed ActRowsUsed SE_IOs SE_IO_KBytes SE_IO_SumTime SE_IO_MaxTime
1 2 TRAFODION.SCH.TSTAT
- 0 4 100 4 4 0 22,124 12,163
+ 0 4 100 4 4 0 9,682 5,606
--- SQL operation complete.
>>log;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000004343212360895605883001000000000206U3333300_312_S1 PROGRESS;
-Qid MXID11000004343212360895605883001000000000206U3333300_312_S1
-Compile Start Time 2017/05/07 05:41:21.930615
-Compile End Time 2017/05/07 05:41:21.967829
-Compile Elapsed Time 0:00:00.037214
-Execute Start Time 2017/05/07 05:41:26.529910
-Execute End Time 2017/05/07 05:41:26.567047
-Execute Elapsed Time 0:00:00.037137
+>>display statistics for QID MXID11000024709212367027407408000000000000206U3333300_335_S1 PROGRESS;
+Qid MXID11000024709212367027407408000000000000206U3333300_335_S1
+Compile Start Time 2017/07/17 04:58:06.342753
+Compile End Time 2017/07/17 04:58:06.391558
+Compile Elapsed Time 0:00:00.048805
+Execute Start Time 2017/07/17 04:58:09.741408
+Execute End Time 2017/07/17 04:58:09.757985
+Execute Elapsed Time 0:00:00.016577
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -2177,15 +2345,19 @@ Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/05/07 05:41:26.564755
+First Row Returned Time 2017/07/17 04:58:09.756320
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
+No. of times executed 1
+Min. Execute Time 0.016577 secs
+Max. Execute Time 0.016577 secs
+Avg. Execute Time 0.016577 secs
Stats Collection Type OPERATOR_STATS
-SQL Process Busy Time 18,938
+SQL Process Busy Time 8,241
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 200 KB
@@ -2194,31 +2366,31 @@ SQL Heap WM 10,341 KB
Processes Created 0
Process Create Time 0
Request Message Count 28
-Request Message Bytes 40,128
+Request Message Bytes 39,712
Reply Message Count 15
-Reply Message Bytes 42,696
+Reply Message Bytes 42,528
Id DOP Table Name
- EstRowsAccess ActRowsAccess EstRowsUsed ActRowsUsed SE_IOs SE_IO_KBytes SE_IO_SumTime SE_IO_MaxTime
+ EstRowsAccess ActRowsAccess EstRowsUsed ActRowsUsed SE_IOs SE_IO_KBytes SE_IO_SumTime SE_IO_MaxTime
1 2 TRAFODION.SCH.TSTAT
- 0 4 100 4 4 0 22,124 12,163
+ 0 4 100 4 4 0 9,682 5,606
Id TDBName Mode DOP TopN BMOPhase InterimRowCount CPUTime
BMOHeapUsed BMOHeapAllocated BMOHeapWM BMOSpaceBufSz BMOSpaceBufCnt
ScrFileCnt ScrIOSize ScrIORead ScrIOWritten ScrIOTime ScrIOMaxTime
- 6 EX_HASH_GRBY DISK 2 -1 READ_ROWS 0 3,978
+ 6 EX_HASH_GRBY DISK 2 -1 READ_ROWS 0 2,283
4 1,024 7,687 256 0
0 -1 0 0 0 0
--- SQL operation complete.
->>get statistics for QID MXID11000004343212360895605883001000000000206U3333300_312_S1 PROGRESS;
-Qid MXID11000004343212360895605883001000000000206U3333300_312_S1
-Comp
<TRUNCATED>
[3/4] incubator-trafodion git commit: [TRAFODION-2420] RMS
enhancements
Posted by se...@apache.org.
[TRAFODION-2420] RMS enhancements
Added four new counters to provide information about multiple executes
of a prepared statement.
No. of times executed
Min. Execute Time
Max. Execute Time
Avg. Execute Time
Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/419c843a
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/419c843a
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/419c843a
Branch: refs/heads/master
Commit: 419c843aeb71b9912112067251b5574f1d6b05da
Parents: a3e19b4
Author: selvaganesang <se...@esgyn.com>
Authored: Mon Jul 17 05:13:32 2017 +0000
Committer: selvaganesang <se...@esgyn.com>
Committed: Mon Jul 17 05:13:32 2017 +0000
----------------------------------------------------------------------
core/sql/cli/sqlcli.h | 4 +
core/sql/executor/ExExeUtilGetStats.cpp | 36 +-
core/sql/executor/ExStats.cpp | 17 +
core/sql/executor/ExStats.h | 4 +-
core/sql/regress/core/EXPECTEDRTS | 1820 +++++++++++++++-----------
core/sql/regress/core/FILTERRTS | 1 +
6 files changed, 1103 insertions(+), 779 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/419c843a/core/sql/cli/sqlcli.h
----------------------------------------------------------------------
diff --git a/core/sql/cli/sqlcli.h b/core/sql/cli/sqlcli.h
index 19d2f1b..b0e68aa 100644
--- a/core/sql/cli/sqlcli.h
+++ b/core/sql/cli/sqlcli.h
@@ -1068,6 +1068,10 @@ enum SQLSTATS_ITEM_ID {
SQLSTATS_RECLAIM_SPACE_COUNT = 201,
SQLSTATS_SUBQUERY_TYPE = 202,
SQLSTATS_PARENT_QUERY_SYSTEM = 203,
+ SQLSTATS_EXECUTE_COUNT = 204,
+ SQLSTATS_EXECUTE_TIME_MIN = 205,
+ SQLSTATS_EXECUTE_TIME_MAX = 206,
+ SQLSTATS_EXECUTE_TIME_AVG = 207,
/* The following 3 enums are moved from operator level stats
to here, however, the enum values are not changed to provide
backward compatibility */
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/419c843a/core/sql/executor/ExExeUtilGetStats.cpp
----------------------------------------------------------------------
diff --git a/core/sql/executor/ExExeUtilGetStats.cpp b/core/sql/executor/ExExeUtilGetStats.cpp
index aee22dc..847985e 100644
--- a/core/sql/executor/ExExeUtilGetStats.cpp
+++ b/core/sql/executor/ExExeUtilGetStats.cpp
@@ -1781,6 +1781,7 @@ short ExExeUtilGetRTSStatisticsTcb::work()
Lng32 intSize = 0;
Lng32 valSize = 0;
char timestampVal[50];
+ Lng32 microSecs;
// if no parent request, return
if (qparent_.down->isEmpty())
@@ -1979,7 +1980,7 @@ short ExExeUtilGetRTSStatisticsTcb::work()
{
if (masterStatsItems_ == NULL)
{
- maxMasterStatsItems_ = 32;
+ maxMasterStatsItems_ = 36;
masterStatsItems_ = new (getGlobals()->getDefaultHeap())
SQLSTATS_ITEM[maxMasterStatsItems_];
initSqlStatsItems(masterStatsItems_, maxMasterStatsItems_, FALSE);
@@ -2015,7 +2016,11 @@ short ExExeUtilGetRTSStatisticsTcb::work()
masterStatsItems_[29].statsItem_id = SQLSTATS_RECLAIM_SPACE_COUNT;
masterStatsItems_[30].statsItem_id = SQLSTATS_CANCEL_TIME_ID;
masterStatsItems_[31].statsItem_id = SQLSTATS_SUSPEND_TIME_ID;
- // maxMasterStatsItems_ is set to 32
+ masterStatsItems_[32].statsItem_id = SQLSTATS_EXECUTE_COUNT;
+ masterStatsItems_[33].statsItem_id = SQLSTATS_EXECUTE_TIME_MIN;
+ masterStatsItems_[34].statsItem_id = SQLSTATS_EXECUTE_TIME_MAX;
+ masterStatsItems_[35].statsItem_id = SQLSTATS_EXECUTE_TIME_AVG;
+ // maxMasterStatsItems_ is set to 36
masterStatsItems_[0].str_value = new (getGlobals()->getDefaultHeap())
char[ComSqlId::MAX_QUERY_ID_LEN+1];
masterStatsItems_[0].str_max_len = ComSqlId::MAX_QUERY_ID_LEN;
@@ -2304,6 +2309,33 @@ short ExExeUtilGetRTSStatisticsTcb::work()
str_sprintf(statsBuf_, "%25s%-d", "No. of times reclaimed",
(Lng32)masterStatsItems_[i].int64_value);
break;
+ case SQLSTATS_EXECUTE_COUNT:
+ str_sprintf(Int64Val, "%Ld", masterStatsItems_[i].int64_value);
+ intSize = str_len(Int64Val);
+ AddCommas(Int64Val,intSize);
+ str_sprintf(statsBuf_, "%25s%s", "No. of times executed", Int64Val);
+ break;
+ case SQLSTATS_EXECUTE_TIME_MIN:
+ microSecs = masterStatsItems_[i].int64_value % 1000000L;
+ str_sprintf(Int64Val, "%Ld", masterStatsItems_[i].int64_value/1000000);
+ intSize = str_len(Int64Val);
+ AddCommas(Int64Val,intSize);
+ str_sprintf(statsBuf_, "%25s%0s.%06d secs", "Min. Execute Time", Int64Val,microSecs);
+ break;
+ case SQLSTATS_EXECUTE_TIME_MAX:
+ microSecs = masterStatsItems_[i].int64_value % 1000000L;
+ str_sprintf(Int64Val, "%Ld", masterStatsItems_[i].int64_value/1000000);
+ intSize = str_len(Int64Val);
+ AddCommas(Int64Val,intSize);
+ str_sprintf(statsBuf_, "%25s%0s.%06d secs", "Max. Execute Time", Int64Val,microSecs);
+ break;
+ case SQLSTATS_EXECUTE_TIME_AVG:
+ microSecs = masterStatsItems_[i].int64_value % 1000000L;
+ str_sprintf(Int64Val, "%Ld", masterStatsItems_[i].int64_value/1000000);
+ intSize = str_len(Int64Val);
+ AddCommas(Int64Val,intSize);
+ str_sprintf(statsBuf_, "%25s%0s.%06d secs", "Avg. Execute Time", Int64Val,microSecs);
+ break;
default:
statsBuf_[0] = '\0';
break;
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/419c843a/core/sql/executor/ExStats.cpp
----------------------------------------------------------------------
diff --git a/core/sql/executor/ExStats.cpp b/core/sql/executor/ExStats.cpp
index e97e5ef..6aa02e0 100644
--- a/core/sql/executor/ExStats.cpp
+++ b/core/sql/executor/ExStats.cpp
@@ -8881,6 +8881,7 @@ void ExMasterStats::getVariableStatsInfo(char * dataBuffer,
"exePriority: %d transId: %Ld suspended: %s lastSuspendTime: %Ld "
"LastErrorBeforeAQR: %d AQRNumRetries: %d DelayBeforeAQR: %d reclaimSpaceCnt: %d "
"blockedInSQL: %d blockedInClient: %d lastActivity: %d "
+ "exeCount: %Ld, exeTimeMin: %Ld exeTimeMax: %Ld exeTimeAvg: %Ld "
"sqlSrcLen: %d sqlSrc: \"%s\"",
statType(),
((queryId_ != NULL) ? queryId_ : "NULL"),
@@ -8919,6 +8920,10 @@ void ExMasterStats::getVariableStatsInfo(char * dataBuffer,
timeSinceBlocking(0),
timeSinceUnblocking(0),
lastActivity_,
+ exeTimes_.entryCnt(),
+ exeTimes_.min(),
+ exeTimes_.max(),
+ exeTimes_.mean(),
originalSqlTextLen_,
((sourceStr_ != NULL) ? sourceStr_ : ""));
}
@@ -9263,6 +9268,18 @@ Lng32 ExMasterStats::getStatsItem(SQLSTATS_ITEM* sqlStats_item)
case SQLSTATS_RECLAIM_SPACE_COUNT:
sqlStats_item->int64_value = reclaimSpaceCount_;
break;
+ case SQLSTATS_EXECUTE_COUNT:
+ sqlStats_item->int64_value = exeTimes_.entryCnt();
+ break;
+ case SQLSTATS_EXECUTE_TIME_MIN:
+ sqlStats_item->int64_value = exeTimes_.min();
+ break;
+ case SQLSTATS_EXECUTE_TIME_MAX:
+ sqlStats_item->int64_value = exeTimes_.max();
+ break;
+ case SQLSTATS_EXECUTE_TIME_AVG:
+ sqlStats_item->int64_value = exeTimes_.mean();
+ break;
default:
sqlStats_item->error_code = -EXE_STAT_NOT_FOUND;
break;
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/419c843a/core/sql/executor/ExStats.h
----------------------------------------------------------------------
diff --git a/core/sql/executor/ExStats.h b/core/sql/executor/ExStats.h
index c437750..f2128f7 100644
--- a/core/sql/executor/ExStats.h
+++ b/core/sql/executor/ExStats.h
@@ -188,7 +188,7 @@ protected:
// a generic counter used in ExOperStats (and deerived classes).
// ExStatsCounter provides cnt, min, max, avg, sum, and var
//////////////////////////////////////////////////////////////////
-class ExStatsCounter : public ExStatsBase {
+class ExStatsCounter {
public:
NA_EIDPROC
ExStatsCounter();
@@ -3622,6 +3622,7 @@ NA_EIDPROC
void setExeEndTime(Int64 exeEndTime)
{
exeEndTime_ = exeEndTime;
+ exeTimes_.addEntry(exeEndTime_-exeStartTime_);
}
NA_EIDPROC
@@ -3964,6 +3965,7 @@ private:
Int32 numObjUIDs_;
Int64 *objUIDs_;
Int64 preallocdObjUIDs_[PreAllocatedObjUIDs];
+ ExStatsCounter exeTimes_;
};