You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by su...@apache.org on 2017/02/16 16:22:52 UTC
[2/4] incubator-trafodion git commit: [TRAFODION-2854] Improve SET
STATISTICS command to display the information in new format
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/6973d3a1/core/sql/regress/core/EXPECTEDRTS
----------------------------------------------------------------------
diff --git a/core/sql/regress/core/EXPECTEDRTS b/core/sql/regress/core/EXPECTEDRTS
index aa54988..c75fae3 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 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
+Qid MXID11000027092212353966950645999000000000206U3333300_303_S1
+Compile Start Time 2017/02/16 01:02:45.193696
+Compile End Time 2017/02/16 01:02:45.225119
+Compile Elapsed Time 0:00:00.031423
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -74,7 +74,7 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 0
+Number of SQL Processes 1
Number of Cpus 0
Transaction Id -1
Source String select distinct d from tstat ;
@@ -94,11 +94,11 @@ Stats Collection Type ACCUMULATED_STATS
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>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
+>>display statistics for QID MXID11000027092212353966950645999000000000206U3333300_303_S1 ;
+Qid MXID11000027092212353966950645999000000000206U3333300_303_S1
+Compile Start Time 2017/02/16 01:02:45.193696
+Compile End Time 2017/02/16 01:02:45.225119
+Compile Elapsed Time 0:00:00.031423
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -113,7 +113,7 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 0
+Number of SQL Processes 1
Number of Cpus 0
Transaction Id -1
Source String select distinct d from tstat ;
@@ -129,11 +129,11 @@ Last Suspend Time -1
Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
->>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
+>>get statistics for QID MXID11000027092212353966950645999000000000206U3333300_303_S1 ;
+Qid MXID11000027092212353966950645999000000000206U3333300_303_S1
+Compile Start Time 2017/02/16 01:02:45.193696
+Compile End Time 2017/02/16 01:02:45.225119
+Compile Elapsed Time 0:00:00.031423
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -148,7 +148,7 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 0
+Number of SQL Processes 1
Number of Cpus 0
Transaction Id -1
Source String select distinct d from tstat ;
@@ -166,10 +166,10 @@ Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
>>log;
>>display statistics for qid current;
-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
+Qid MXID11000027092212353966950645999000000000206U3333300_303_S1
+Compile Start Time 2017/02/16 01:02:45.193696
+Compile End Time 2017/02/16 01:02:45.225119
+Compile Elapsed Time 0:00:00.031423
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -184,7 +184,7 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 0
+Number of SQL Processes 1
Number of Cpus 0
Transaction Id -1
Source String select distinct d from tstat ;
@@ -201,10 +201,10 @@ Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
>>get statistics for qid current ;
-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
+Qid MXID11000027092212353966950645999000000000206U3333300_303_S1
+Compile Start Time 2017/02/16 01:02:45.193696
+Compile End Time 2017/02/16 01:02:45.225119
+Compile Elapsed Time 0:00:00.031423
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -219,7 +219,7 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 0
+Number of SQL Processes 1
Number of Cpus 0
Transaction Id -1
Source String select distinct d from tstat ;
@@ -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 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
+>>display statistics for QID MXID11000027092212353966950645999000000000206U3333300_303_S1 ;
+Qid MXID11000027092212353966950645999000000000206U3333300_303_S1
+Compile Start Time 2017/02/16 01:02:45.193696
+Compile End Time 2017/02/16 01:02:45.225119
+Compile Elapsed Time 0:00:00.031423
+Execute Start Time 2017/02/16 01:02:48.212804
+Execute End Time 2017/02/16 01:02:51.350916
+Execute Elapsed Time 0:00:03.138112
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -269,13 +269,13 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 5
+Number of SQL Processes 3
Number of Cpus 2
Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/01/09 20:09:52.472998
+First Row Returned Time 2017/02/16 01:02:51.349044
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 521,867
-SQL Process Busy Time 4,010,959
+SE IO MAX Time 708,700
+SQL Process Busy Time 4,139,515
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 17 KB
+SQL Heap Used 16 KB
Processes Created 2
-Process Create Time 187,585
+Process Create Time 120,844
Request Message Count 26
-Request Message Bytes 39,664
-Reply Message Count 15
-Reply Message Bytes 38,696
+Request Message Bytes 39,392
+Reply Message Count 14
+Reply Message Bytes 32,184
Scr. Overflow Mode DISK
Scr. File Count 0
Scr. Buffer Blk Size 0
@@ -309,14 +309,14 @@ Scr. Read Count 0
Scr. Write Count 0
--- SQL operation complete.
->>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
+>>get statistics for QID MXID11000027092212353966950645999000000000206U3333300_303_S1 ;
+Qid MXID11000027092212353966950645999000000000206U3333300_303_S1
+Compile Start Time 2017/02/16 01:02:45.193696
+Compile End Time 2017/02/16 01:02:45.225119
+Compile Elapsed Time 0:00:00.031423
+Execute Start Time 2017/02/16 01:02:48.212804
+Execute End Time 2017/02/16 01:02:51.350916
+Execute Elapsed Time 0:00:03.138112
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -328,13 +328,13 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 5
+Number of SQL Processes 3
Number of Cpus 2
Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/01/09 20:09:52.472998
+First Row Returned Time 2017/02/16 01:02:51.349044
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -346,19 +346,19 @@ Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 521,867
-SQL Process Busy Time 4,010,959
+SE IO MAX Time 708,700
+SQL Process Busy Time 4,139,515
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 17 KB
+SQL Heap Used 16 KB
Processes Created 2
-Process Create Time 187,585
+Process Create Time 120,844
Request Message Count 26
-Request Message Bytes 39,664
-Reply Message Count 15
-Reply Message Bytes 38,696
+Request Message Bytes 39,392
+Reply Message Count 14
+Reply Message Bytes 32,184
Scr. Overflow Mode DISK
Scr. File Count 0
Scr. Buffer Blk Size 0
@@ -370,13 +370,13 @@ Scr. Write Count 0
--- SQL operation complete.
>>log;
>>display statistics for qid current;
-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
+Qid MXID11000027092212353966950645999000000000206U3333300_303_S1
+Compile Start Time 2017/02/16 01:02:45.193696
+Compile End Time 2017/02/16 01:02:45.225119
+Compile Elapsed Time 0:00:00.031423
+Execute Start Time 2017/02/16 01:02:48.212804
+Execute End Time 2017/02/16 01:02:51.350916
+Execute Elapsed Time 0:00:03.138112
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -388,13 +388,13 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 5
+Number of SQL Processes 3
Number of Cpus 1
Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/01/09 20:09:52.472998
+First Row Returned Time 2017/02/16 01:02:51.349044
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -406,19 +406,19 @@ Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 521,867
-SQL Process Busy Time 4,010,959
+SE IO MAX Time 708,700
+SQL Process Busy Time 4,139,515
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 17 KB
+SQL Heap Used 16 KB
Processes Created 2
-Process Create Time 187,585
+Process Create Time 120,844
Request Message Count 26
-Request Message Bytes 39,664
-Reply Message Count 15
-Reply Message Bytes 38,696
+Request Message Bytes 39,392
+Reply Message Count 14
+Reply Message Bytes 32,184
Scr. Overflow Mode DISK
Scr. File Count 0
Scr. Buffer Blk Size 0
@@ -429,13 +429,13 @@ Scr. Write Count 0
--- SQL operation complete.
>>get statistics for qid current ;
-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
+Qid MXID11000027092212353966950645999000000000206U3333300_303_S1
+Compile Start Time 2017/02/16 01:02:45.193696
+Compile End Time 2017/02/16 01:02:45.225119
+Compile Elapsed Time 0:00:00.031423
+Execute Start Time 2017/02/16 01:02:48.212804
+Execute End Time 2017/02/16 01:02:51.350916
+Execute Elapsed Time 0:00:03.138112
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -447,13 +447,13 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 5
+Number of SQL Processes 3
Number of Cpus 1
Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/01/09 20:09:52.472998
+First Row Returned Time 2017/02/16 01:02:51.349044
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -465,19 +465,19 @@ Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 521,867
-SQL Process Busy Time 4,010,959
+SE IO MAX Time 708,700
+SQL Process Busy Time 4,139,515
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 17 KB
+SQL Heap Used 16 KB
Processes Created 2
-Process Create Time 187,585
+Process Create Time 120,844
Request Message Count 26
-Request Message Bytes 39,664
-Reply Message Count 15
-Reply Message Bytes 38,696
+Request Message Bytes 39,392
+Reply Message Count 14
+Reply Message Bytes 32,184
Scr. Overflow Mode DISK
Scr. File Count 0
Scr. Buffer Blk Size 0
@@ -494,25 +494,25 @@ Scr. Write Count 0
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>display statistics for QID MXID11000008082212350752509978000000000000206U3333300_303_S1 ;
+>>display statistics for QID MXID11000027092212353966950645999000000000206U3333300_303_S1 ;
-*** ERROR[8923] The given Query Id MXID11000008082212350752509978000000000000206U3333300_303_S1 is not found.
+*** ERROR[8923] The given Query Id MXID11000027092212353966950645999000000000206U3333300_303_S1 is not found.
--- SQL operation failed with errors.
->>get statistics for QID MXID11000008082212350752509978000000000000206U3333300_303_S1 ;
+>>get statistics for QID MXID11000027092212353966950645999000000000206U3333300_303_S1 ;
-*** ERROR[8923] The given Query Id MXID11000008082212350752509978000000000000206U3333300_303_S1 is not found.
+*** ERROR[8923] The given Query Id MXID11000027092212353966950645999000000000206U3333300_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 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
+>>display statistics for QID MXID11000027092212353966950645999000000000206U3333300_312_S1 ;
+Qid MXID11000027092212353966950645999000000000206U3333300_312_S1
+Compile Start Time 2017/02/16 01:02:54.344766
+Compile End Time 2017/02/16 01:02:54.345294
+Compile Elapsed Time 0:00:00.000528
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -527,7 +527,7 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 0
+Number of SQL Processes 1
Number of Cpus 0
Transaction Id -1
Source String select distinct d from tstat ;
@@ -543,11 +543,11 @@ Last Suspend Time -1
Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
->>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
+>>get statistics for QID MXID11000027092212353966950645999000000000206U3333300_312_S1 ;
+Qid MXID11000027092212353966950645999000000000206U3333300_312_S1
+Compile Start Time 2017/02/16 01:02:54.344766
+Compile End Time 2017/02/16 01:02:54.345294
+Compile Elapsed Time 0:00:00.000528
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -562,7 +562,7 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 0
+Number of SQL Processes 1
Number of Cpus 0
Transaction Id -1
Source String select distinct d from tstat ;
@@ -580,10 +580,10 @@ Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
>>log;
>>display statistics for qid current;
-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
+Qid MXID11000027092212353966950645999000000000206U3333300_312_S1
+Compile Start Time 2017/02/16 01:02:54.344766
+Compile End Time 2017/02/16 01:02:54.345294
+Compile Elapsed Time 0:00:00.000528
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -598,7 +598,7 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 0
+Number of SQL Processes 1
Number of Cpus 0
Transaction Id -1
Source String select distinct d from tstat ;
@@ -615,10 +615,10 @@ Stats Collection Type ACCUMULATED_STATS
--- SQL operation complete.
>>get statistics for qid current ;
-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
+Qid MXID11000027092212353966950645999000000000206U3333300_312_S1
+Compile Start Time 2017/02/16 01:02:54.344766
+Compile End Time 2017/02/16 01:02:54.345294
+Compile Elapsed Time 0:00:00.000528
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -633,7 +633,7 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 0
+Number of SQL Processes 1
Number of Cpus 0
Transaction Id -1
Source String select distinct d from tstat ;
@@ -662,10 +662,10 @@ Stats Collection Type ACCUMULATED_STATS
--- SQL command prepared.
>>log;
>>get statistics for qid current ;
-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
+Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
+Compile Start Time 2017/02/16 01:03:00.271828
+Compile End Time 2017/02/16 01:03:00.308827
+Compile Elapsed Time 0:00:00.036999
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -680,7 +680,7 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 0
+Number of SQL Processes 1
Number of Cpus 0
Transaction Id -1
Source String select distinct d from tstat ;
@@ -700,11 +700,11 @@ Stats Collection Type PERTABLE_STATS
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>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
+>>display statistics for QID MXID11000027092212353966950645999000000000206U3333300_317_S1 ;
+Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
+Compile Start Time 2017/02/16 01:03:00.271828
+Compile End Time 2017/02/16 01:03:00.308827
+Compile Elapsed Time 0:00:00.036999
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -719,7 +719,7 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 0
+Number of SQL Processes 1
Number of Cpus 0
Transaction Id -1
Source String select distinct d from tstat ;
@@ -735,11 +735,11 @@ Last Suspend Time -1
Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
->>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
+>>get statistics for QID MXID11000027092212353966950645999000000000206U3333300_317_S1 ;
+Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
+Compile Start Time 2017/02/16 01:03:00.271828
+Compile End Time 2017/02/16 01:03:00.308827
+Compile Elapsed Time 0:00:00.036999
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -754,7 +754,7 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 0
+Number of SQL Processes 1
Number of Cpus 0
Transaction Id -1
Source String select distinct d from tstat ;
@@ -774,11 +774,11 @@ Stats Collection Type PERTABLE_STATS
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>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
+>>display statistics for QID MXID11000027092212353966950645999000000000206U3333300_317_S1 ACCUMULATED;
+Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
+Compile Start Time 2017/02/16 01:03:00.271828
+Compile End Time 2017/02/16 01:03:00.308827
+Compile Elapsed Time 0:00:00.036999
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -793,7 +793,7 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 0
+Number of SQL Processes 1
Number of Cpus 0
Transaction Id -1
Source String select distinct d from tstat ;
@@ -809,11 +809,11 @@ Last Suspend Time -1
Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
->>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
+>>get statistics for QID MXID11000027092212353966950645999000000000206U3333300_317_S1 ACCUMULATED;
+Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
+Compile Start Time 2017/02/16 01:03:00.271828
+Compile End Time 2017/02/16 01:03:00.308827
+Compile Elapsed Time 0:00:00.036999
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -828,7 +828,7 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 0
+Number of SQL Processes 1
Number of Cpus 0
Transaction Id -1
Source String select distinct d from tstat ;
@@ -846,10 +846,10 @@ Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
>>log;
>>display statistics for qid current;
-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
+Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
+Compile Start Time 2017/02/16 01:03:00.271828
+Compile End Time 2017/02/16 01:03:00.308827
+Compile Elapsed Time 0:00:00.036999
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -864,7 +864,7 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 0
+Number of SQL Processes 1
Number of Cpus 0
Transaction Id -1
Source String select distinct d from tstat ;
@@ -881,10 +881,10 @@ Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
>>get statistics for qid current ;
-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
+Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
+Compile Start Time 2017/02/16 01:03:00.271828
+Compile End Time 2017/02/16 01:03:00.308827
+Compile Elapsed Time 0:00:00.036999
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -899,7 +899,7 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 0
+Number of SQL Processes 1
Number of Cpus 0
Transaction Id -1
Source String select distinct d from tstat ;
@@ -916,10 +916,10 @@ Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
>>display statistics for qid current 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
+Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
+Compile Start Time 2017/02/16 01:03:00.271828
+Compile End Time 2017/02/16 01:03:00.308827
+Compile Elapsed Time 0:00:00.036999
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -934,7 +934,7 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 0
+Number of SQL Processes 1
Number of Cpus 0
Transaction Id -1
Source String select distinct d from tstat ;
@@ -951,10 +951,10 @@ Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
>>get statistics for qid current 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
+Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
+Compile Start Time 2017/02/16 01:03:00.271828
+Compile End Time 2017/02/16 01:03:00.308827
+Compile Elapsed Time 0:00:00.036999
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -969,7 +969,7 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 0
+Number of SQL Processes 1
Number of Cpus 0
Transaction Id -1
Source String select distinct d from tstat ;
@@ -1000,14 +1000,14 @@ D
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>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
+>>display statistics for QID MXID11000027092212353966950645999000000000206U3333300_317_S1 ;
+Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
+Compile Start Time 2017/02/16 01:03:00.271828
+Compile End Time 2017/02/16 01:03:00.308827
+Compile Elapsed Time 0:00:00.036999
+Execute Start Time 2017/02/16 01:03:06.512541
+Execute End Time 2017/02/16 01:03:06.522982
+Execute Elapsed Time 0:00:00.010441
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1019,13 +1019,13 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 5
+Number of SQL Processes 3
Number of Cpus 2
Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/01/09 20:10:07.940066
+First Row Returned Time 2017/02/16 01:03:06.521253
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1033,18 +1033,18 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
Stats Collection Type PERTABLE_STATS
-SQL Process Busy Time 9,754
+SQL Process Busy Time 6,176
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 15 KB
+SQL Heap Used 14 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,824
-Reply Message Count 15
-Reply Message Bytes 39,080
+Request Message Bytes 39,552
+Reply Message Count 14
+Reply Message Bytes 32,568
Scr. Overflow Mode UNKNOWN
Scr File Count 0
Scr. Buffer Blk Size 0
@@ -1059,17 +1059,17 @@ Table Name
Estimated/Actual Estimated/Actual IOs IO MBytes Sum Time Max Time
TRAFODION.SCH.TSTAT
0 100
- 4 4 4 0 9,099 4,678
+ 4 4 4 0 4,755 2,404
--- SQL operation complete.
->>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
+>>get statistics for QID MXID11000027092212353966950645999000000000206U3333300_317_S1 ;
+Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
+Compile Start Time 2017/02/16 01:03:00.271828
+Compile End Time 2017/02/16 01:03:00.308827
+Compile Elapsed Time 0:00:00.036999
+Execute Start Time 2017/02/16 01:03:06.512541
+Execute End Time 2017/02/16 01:03:06.522982
+Execute Elapsed Time 0:00:00.010441
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1081,13 +1081,13 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 5
+Number of SQL Processes 3
Number of Cpus 2
Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/01/09 20:10:07.940066
+First Row Returned Time 2017/02/16 01:03:06.521253
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1095,18 +1095,18 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
Stats Collection Type PERTABLE_STATS
-SQL Process Busy Time 9,754
+SQL Process Busy Time 6,176
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 15 KB
+SQL Heap Used 14 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,824
-Reply Message Count 15
-Reply Message Bytes 39,080
+Request Message Bytes 39,552
+Reply Message Count 14
+Reply Message Bytes 32,568
Scr. Overflow Mode UNKNOWN
Scr File Count 0
Scr. Buffer Blk Size 0
@@ -1121,21 +1121,21 @@ Table Name
Estimated/Actual Estimated/Actual IOs IO MBytes Sum Time Max Time
TRAFODION.SCH.TSTAT
0 100
- 4 4 4 0 9,099 4,678
+ 4 4 4 0 4,755 2,404
--- SQL operation complete.
>>log;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>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
+>>display statistics for QID MXID11000027092212353966950645999000000000206U3333300_317_S1 ACCUMULATED;
+Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
+Compile Start Time 2017/02/16 01:03:00.271828
+Compile End Time 2017/02/16 01:03:00.308827
+Compile Elapsed Time 0:00:00.036999
+Execute Start Time 2017/02/16 01:03:06.512541
+Execute End Time 2017/02/16 01:03:06.522982
+Execute Elapsed Time 0:00:00.010441
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1147,13 +1147,13 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 5
+Number of SQL Processes 3
Number of Cpus 2
Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/01/09 20:10:07.940066
+First Row Returned Time 2017/02/16 01:03:06.521253
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1165,19 +1165,19 @@ Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 4,678
-SQL Process Busy Time 9,754
+SE IO MAX Time 2,404
+SQL Process Busy Time 6,176
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 15 KB
+SQL Heap Used 14 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,824
-Reply Message Count 15
-Reply Message Bytes 39,080
+Request Message Bytes 39,552
+Reply Message Count 14
+Reply Message Bytes 32,568
Scr. Overflow Mode UNKNOWN
Scr. File Count 0
Scr. Buffer Blk Size 0
@@ -1187,14 +1187,14 @@ Scr. Read Count 0
Scr. Write Count 0
--- SQL operation complete.
->>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
+>>get statistics for QID MXID11000027092212353966950645999000000000206U3333300_317_S1 ACCUMULATED;
+Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
+Compile Start Time 2017/02/16 01:03:00.271828
+Compile End Time 2017/02/16 01:03:00.308827
+Compile Elapsed Time 0:00:00.036999
+Execute Start Time 2017/02/16 01:03:06.512541
+Execute End Time 2017/02/16 01:03:06.522982
+Execute Elapsed Time 0:00:00.010441
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1206,13 +1206,13 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 5
+Number of SQL Processes 3
Number of Cpus 2
Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/01/09 20:10:07.940066
+First Row Returned Time 2017/02/16 01:03:06.521253
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1224,19 +1224,19 @@ Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 4,678
-SQL Process Busy Time 9,754
+SE IO MAX Time 2,404
+SQL Process Busy Time 6,176
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 15 KB
+SQL Heap Used 14 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,824
-Reply Message Count 15
-Reply Message Bytes 39,080
+Request Message Bytes 39,552
+Reply Message Count 14
+Reply Message Bytes 32,568
Scr. Overflow Mode UNKNOWN
Scr. File Count 0
Scr. Buffer Blk Size 0
@@ -1248,13 +1248,13 @@ Scr. Write Count 0
--- SQL operation complete.
>>log;
>>display statistics for qid current;
-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
+Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
+Compile Start Time 2017/02/16 01:03:00.271828
+Compile End Time 2017/02/16 01:03:00.308827
+Compile Elapsed Time 0:00:00.036999
+Execute Start Time 2017/02/16 01:03:06.512541
+Execute End Time 2017/02/16 01:03:06.522982
+Execute Elapsed Time 0:00:00.010441
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1266,13 +1266,13 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 5
+Number of SQL Processes 3
Number of Cpus 1
Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/01/09 20:10:07.940066
+First Row Returned Time 2017/02/16 01:03:06.521253
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1280,18 +1280,18 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
Stats Collection Type PERTABLE_STATS
-SQL Process Busy Time 9,754
+SQL Process Busy Time 6,176
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 15 KB
+SQL Heap Used 14 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,824
-Reply Message Count 15
-Reply Message Bytes 39,080
+Request Message Bytes 39,552
+Reply Message Count 14
+Reply Message Bytes 32,568
Scr. Overflow Mode UNKNOWN
Scr File Count 0
Scr. Buffer Blk Size 0
@@ -1306,17 +1306,17 @@ Table Name
Estimated/Actual Estimated/Actual IOs IO MBytes Sum Time Max Time
TRAFODION.SCH.TSTAT
0 100
- 4 4 4 0 9,099 4,678
+ 4 4 4 0 4,755 2,404
--- SQL operation complete.
>>get statistics for qid current ;
-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
+Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
+Compile Start Time 2017/02/16 01:03:00.271828
+Compile End Time 2017/02/16 01:03:00.308827
+Compile Elapsed Time 0:00:00.036999
+Execute Start Time 2017/02/16 01:03:06.512541
+Execute End Time 2017/02/16 01:03:06.522982
+Execute Elapsed Time 0:00:00.010441
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1328,13 +1328,13 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 5
+Number of SQL Processes 3
Number of Cpus 1
Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/01/09 20:10:07.940066
+First Row Returned Time 2017/02/16 01:03:06.521253
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1342,18 +1342,18 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
Stats Collection Type PERTABLE_STATS
-SQL Process Busy Time 9,754
+SQL Process Busy Time 6,176
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 15 KB
+SQL Heap Used 14 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,824
-Reply Message Count 15
-Reply Message Bytes 39,080
+Request Message Bytes 39,552
+Reply Message Count 14
+Reply Message Bytes 32,568
Scr. Overflow Mode UNKNOWN
Scr File Count 0
Scr. Buffer Blk Size 0
@@ -1368,17 +1368,17 @@ Table Name
Estimated/Actual Estimated/Actual IOs IO MBytes Sum Time Max Time
TRAFODION.SCH.TSTAT
0 100
- 4 4 4 0 9,099 4,678
+ 4 4 4 0 4,755 2,404
--- SQL operation complete.
>>display statistics for qid current 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
+Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
+Compile Start Time 2017/02/16 01:03:00.271828
+Compile End Time 2017/02/16 01:03:00.308827
+Compile Elapsed Time 0:00:00.036999
+Execute Start Time 2017/02/16 01:03:06.512541
+Execute End Time 2017/02/16 01:03:06.522982
+Execute Elapsed Time 0:00:00.010441
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1390,13 +1390,13 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 5
+Number of SQL Processes 3
Number of Cpus 1
Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/01/09 20:10:07.940066
+First Row Returned Time 2017/02/16 01:03:06.521253
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1408,19 +1408,19 @@ Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 4,678
-SQL Process Busy Time 9,754
+SE IO MAX Time 2,404
+SQL Process Busy Time 6,176
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 15 KB
+SQL Heap Used 14 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,824
-Reply Message Count 15
-Reply Message Bytes 39,080
+Request Message Bytes 39,552
+Reply Message Count 14
+Reply Message Bytes 32,568
Scr. Overflow Mode UNKNOWN
Scr. File Count 0
Scr. Buffer Blk Size 0
@@ -1431,13 +1431,13 @@ Scr. Write Count 0
--- SQL operation complete.
>>get statistics for qid current 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
+Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
+Compile Start Time 2017/02/16 01:03:00.271828
+Compile End Time 2017/02/16 01:03:00.308827
+Compile Elapsed Time 0:00:00.036999
+Execute Start Time 2017/02/16 01:03:06.512541
+Execute End Time 2017/02/16 01:03:06.522982
+Execute Elapsed Time 0:00:00.010441
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1449,13 +1449,13 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 5
+Number of SQL Processes 3
Number of Cpus 1
Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/01/09 20:10:07.940066
+First Row Returned Time 2017/02/16 01:03:06.521253
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1467,19 +1467,19 @@ Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 4,678
-SQL Process Busy Time 9,754
+SE IO MAX Time 2,404
+SQL Process Busy Time 6,176
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 15 KB
+SQL Heap Used 14 KB
Processes Created 0
Process Create Time 0
Request Message Count 27
-Request Message Bytes 39,824
-Reply Message Count 15
-Reply Message Bytes 39,080
+Request Message Bytes 39,552
+Reply Message Count 14
+Reply Message Bytes 32,568
Scr. Overflow Mode UNKNOWN
Scr. File Count 0
Scr. Buffer Blk Size 0
@@ -1491,7 +1491,7 @@ Scr. Write Count 0
--- SQL operation complete.
>>log;
>>obey PQIDOUT;
->>SET SESSION DEFAULT PARENT_QID 'MXID11000008082212350752509978000000000000206U3333300_317_S1';
+>>SET SESSION DEFAULT PARENT_QID 'MXID11000027092212353966950645999000000000206U3333300_317_S1';
--- SQL operation complete.
>>prepare s1 from select distinct d from tstat ;
@@ -1501,11 +1501,11 @@ Scr. Write Count 0
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>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
+>>display statistics for QID MXID11000027092212353966950645999000000000206U3333300_331_S1 ;
+Qid MXID11000027092212353966950645999000000000206U3333300_331_S1
+Compile Start Time 2017/02/16 01:03:16.005126
+Compile End Time 2017/02/16 01:03:16.005736
+Compile Elapsed Time 0:00:00.000610
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1517,10 +1517,10 @@ Query Type SQL_SELECT_NON_UNIQUE
Sub Query Type SQL_STMT_NA
Estimated Accessed Rows 0
Estimated Used Rows 0
-Parent Qid MXID11000008082212350752509978000000000000206U3333300_317_S1
+Parent Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
Parent Query System SAME
Child Qid NONE
-Number of SQL Processes 0
+Number of SQL Processes 1
Number of Cpus 0
Transaction Id -1
Source String select distinct d from tstat ;
@@ -1536,11 +1536,11 @@ Last Suspend Time -1
Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
->>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
+>>get statistics for QID MXID11000027092212353966950645999000000000206U3333300_331_S1 ;
+Qid MXID11000027092212353966950645999000000000206U3333300_331_S1
+Compile Start Time 2017/02/16 01:03:16.005126
+Compile End Time 2017/02/16 01:03:16.005736
+Compile Elapsed Time 0:00:00.000610
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1552,10 +1552,10 @@ Query Type SQL_SELECT_NON_UNIQUE
Sub Query Type SQL_STMT_NA
Estimated Accessed Rows 0
Estimated Used Rows 0
-Parent Qid MXID11000008082212350752509978000000000000206U3333300_317_S1
+Parent Qid MXID11000027092212353966950645999000000000206U3333300_317_S1
Parent Query System SAME
Child Qid NONE
-Number of SQL Processes 0
+Number of SQL Processes 1
Number of Cpus 0
Transaction Id -1
Source String select distinct d from tstat ;
@@ -1582,11 +1582,11 @@ Stats Collection Type PERTABLE_STATS
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>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
+>>display statistics for QID MXID11000027092212353966950645999000000000206U3333300_333_S1 ;
+Qid MXID11000027092212353966950645999000000000206U3333300_333_S1
+Compile Start Time 2017/02/16 01:03:19.022446
+Compile End Time 2017/02/16 01:03:19.022986
+Compile Elapsed Time 0:00:00.000540
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1601,7 +1601,7 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 0
+Number of SQL Processes 1
Number of Cpus 0
Transaction Id -1
Source String select distinct d from tstat ;
@@ -1617,11 +1617,11 @@ Last Suspend Time -1
Stats Collection Type PERTABLE_STATS
--- SQL operation complete.
->>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
+>>get statistics for QID MXID11000027092212353966950645999000000000206U3333300_333_S1 ;
+Qid MXID11000027092212353966950645999000000000206U3333300_333_S1
+Compile Start Time 2017/02/16 01:03:19.022446
+Compile End Time 2017/02/16 01:03:19.022986
+Compile Elapsed Time 0:00:00.000540
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1636,7 +1636,7 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 0
+Number of SQL Processes 1
Number of Cpus 0
Transaction Id -1
Source String select distinct d from tstat ;
@@ -1668,11 +1668,11 @@ Stats Collection Type PERTABLE_STATS
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>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
+>>display statistics for QID MXID11000027092212353966950645999000000000206U3333300_336_S1 ;
+Qid MXID11000027092212353966950645999000000000206U3333300_336_S1
+Compile Start Time 2017/02/16 01:03:25.061984
+Compile End Time 2017/02/16 01:03:25.102150
+Compile Elapsed Time 0:00:00.040166
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1687,7 +1687,7 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 0
+Number of SQL Processes 1
Number of Cpus 0
Transaction Id -1
Source String select distinct d from tstat ;
@@ -1703,11 +1703,11 @@ Last Suspend Time -1
Stats Collection Type OPERATOR_STATS
--- 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
+>>get statistics for QID MXID11000027092212353966950645999000000000206U3333300_336_S1 ;
+Qid MXID11000027092212353966950645999000000000206U3333300_336_S1
+Compile Start Time 2017/02/16 01:03:25.061984
+Compile End Time 2017/02/16 01:03:25.102150
+Compile Elapsed Time 0:00:00.040166
Execute Start Time -1
Execute End Time -1
Execute Elapsed Time 0:00:00.000000
@@ -1722,7 +1722,7 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 0
+Number of SQL Processes 1
Number of Cpus 0
Transaction Id -1
Source String select distinct d from tstat ;
@@ -1754,14 +1754,14 @@ D
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>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
+>>display statistics for QID MXID11000027092212353966950645999000000000206U3333300_336_S1 ;
+Qid MXID11000027092212353966950645999000000000206U3333300_336_S1
+Compile Start Time 2017/02/16 01:03:25.061984
+Compile End Time 2017/02/16 01:03:25.102150
+Compile Elapsed Time 0:00:00.040166
+Execute Start Time 2017/02/16 01:03:28.196863
+Execute End Time 2017/02/16 01:03:28.208332
+Execute Elapsed Time 0:00:00.011469
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1773,13 +1773,13 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 5
+Number of SQL Processes 3
Number of Cpus 2
Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/01/09 20:10:32.710668
+First Row Returned Time 2017/02/16 01:03:28.206366
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1790,27 +1790,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 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
+10 . 11 . 5 0 EX_ROOT 1 5 17 0 4 1049
+9 . 10 11 4 0 EX_SPLIT_TOP 1 5 7 2 4
+8 . 9 10 4 0 EX_SEND_TOP 2 10 1,025 2 4
+7 . 8 9 4 2 EX_SEND_BOTTOM 2 21 77 2 4
+6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 7 2 4 3223
+5 . 6 7 3 2 EX_HASH_GRBY 2 6 2,559 1 4 0|0|0
+4 . 5 6 2 2 EX_SPLIT_TOP 2 11 8 100 4
+3 . 4 5 2 2 EX_SEND_TOP 4 18 572 100 4
+2 . 3 4 2 3 EX_SEND_BOTTOM 4 35 136 100 4
+1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 8 11 100 4 1377
+. . 1 2 1 3 EX_TRAF_KEY_SELECT 6 12 3,690 100 4 TRAFODION.SCH.TSTAT|4|176
+
+--- SQL operation complete.
+>>get statistics for QID MXID11000027092212353966950645999000000000206U3333300_336_S1 ;
+Qid MXID11000027092212353966950645999000000000206U3333300_336_S1
+Compile Start Time 2017/02/16 01:03:25.061984
+Compile End Time 2017/02/16 01:03:25.102150
+Compile Elapsed Time 0:00:00.040166
+Execute Start Time 2017/02/16 01:03:28.196863
+Execute End Time 2017/02/16 01:03:28.208332
+Execute Elapsed Time 0:00:00.011469
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1822,13 +1822,13 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 5
+Number of SQL Processes 3
Number of Cpus 2
Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/01/09 20:10:32.710668
+First Row Returned Time 2017/02/16 01:03:28.206366
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1839,31 +1839,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 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
+10 . 11 . 5 0 EX_ROOT 1 5 17 0 4 1049
+9 . 10 11 4 0 EX_SPLIT_TOP 1 5 7 2 4
+8 . 9 10 4 0 EX_SEND_TOP 2 10 1,025 2 4
+7 . 8 9 4 2 EX_SEND_BOTTOM 2 21 77 2 4
+6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 7 2 4 3223
+5 . 6 7 3 2 EX_HASH_GRBY 2 6 2,559 1 4 0|0|0
+4 . 5 6 2 2 EX_SPLIT_TOP 2 11 8 100 4
+3 . 4 5 2 2 EX_SEND_TOP 4 18 572 100 4
+2 . 3 4 2 3 EX_SEND_BOTTOM 4 35 136 100 4
+1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 8 11 100 4 1377
+. . 1 2 1 3 EX_TRAF_KEY_SELECT 6 12 3,690 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 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
+>>display statistics for QID MXID11000027092212353966950645999000000000206U3333300_336_S1 ACCUMULATED;
+Qid MXID11000027092212353966950645999000000000206U3333300_336_S1
+Compile Start Time 2017/02/16 01:03:25.061984
+Compile End Time 2017/02/16 01:03:25.102150
+Compile Elapsed Time 0:00:00.040166
+Execute Start Time 2017/02/16 01:03:28.196863
+Execute End Time 2017/02/16 01:03:28.208332
+Execute Elapsed Time 0:00:00.011469
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1875,13 +1875,13 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 5
+Number of SQL Processes 3
Number of Cpus 2
Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/01/09 20:10:32.710668
+First Row Returned Time 2017/02/16 01:03:28.206366
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1893,19 +1893,19 @@ Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 4,705
-SQL Process Busy Time 11,223
+SE IO MAX Time 2,387
+SQL Process Busy Time 5,649
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 15 KB
+SQL Heap Used 14 KB
Processes Created 0
Process Create Time 0
Request Message Count 28
-Request Message Bytes 39,984
+Request Message Bytes 39,712
Reply Message Count 15
-Reply Message Bytes 42,240
+Reply Message Bytes 42,256
Scr. Overflow Mode DISK
Scr. File Count 0
Scr. Buffer Blk Size 0
@@ -1915,14 +1915,14 @@ Scr. Read Count 0
Scr. Write Count 0
--- SQL operation complete.
->>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
+>>get statistics for QID MXID11000027092212353966950645999000000000206U3333300_336_S1 ACCUMULATED;
+Qid MXID11000027092212353966950645999000000000206U3333300_336_S1
+Compile Start Time 2017/02/16 01:03:25.061984
+Compile End Time 2017/02/16 01:03:25.102150
+Compile Elapsed Time 0:00:00.040166
+Execute Start Time 2017/02/16 01:03:28.196863
+Execute End Time 2017/02/16 01:03:28.208332
+Execute Elapsed Time 0:00:00.011469
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1934,13 +1934,13 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 5
+Number of SQL Processes 3
Number of Cpus 2
Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/01/09 20:10:32.710668
+First Row Returned Time 2017/02/16 01:03:28.206366
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -1952,19 +1952,19 @@ Accessed Rows 4
Used Rows 4
SE IOs 4
SE IO Bytes 176
-SE IO MAX Time 4,705
-SQL Process Busy Time 11,223
+SE IO MAX Time 2,387
+SQL Process Busy Time 5,649
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 15 KB
+SQL Heap Used 14 KB
Processes Created 0
Process Create Time 0
Request Message Count 28
-Request Message Bytes 39,984
+Request Message Bytes 39,712
Reply Message Count 15
-Reply Message Bytes 42,240
+Reply Message Bytes 42,256
Scr. Overflow Mode DISK
Scr. File Count 0
Scr. Buffer Blk Size 0
@@ -1978,14 +1978,14 @@ Scr. Write Count 0
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>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
+>>display statistics for QID MXID11000027092212353966950645999000000000206U3333300_336_S1 PERTABLE;
+Qid MXID11000027092212353966950645999000000000206U3333300_336_S1
+Compile Start Time 2017/02/16 01:03:25.061984
+Compile End Time 2017/02/16 01:03:25.102150
+Compile Elapsed Time 0:00:00.040166
+Execute Start Time 2017/02/16 01:03:28.196863
+Execute End Time 2017/02/16 01:03:28.208332
+Execute Elapsed Time 0:00:00.011469
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -1997,13 +1997,13 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 5
+Number of SQL Processes 3
Number of Cpus 2
Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/01/09 20:10:32.710668
+First Row Returned Time 2017/02/16 01:03:28.206366
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -2011,18 +2011,18 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
Stats Collection Type OPERATOR_STATS
-SQL Process Busy Time 11,223
+SQL Process Busy Time 5,649
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 15 KB
+SQL Heap Used 14 KB
Processes Created 0
Process Create Time 0
Request Message Count 28
-Request Message Bytes 39,984
+Request Message Bytes 39,712
Reply Message Count 15
-Reply Message Bytes 42,240
+Reply Message Bytes 42,256
Scr. Overflow Mode DISK
Scr File Count 0
Scr. Buffer Blk Size 0
@@ -2037,17 +2037,17 @@ Table Name
Estimated/Actual Estimated/Actual IOs IO MBytes Sum Time Max Time
TRAFODION.SCH.TSTAT
0 100
- 4 4 4 0 8,692 4,705
+ 4 4 4 0 4,503 2,387
--- SQL operation complete.
->>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
+>>get statistics for QID MXID11000027092212353966950645999000000000206U3333300_336_S1 PERTABLE;
+Qid MXID11000027092212353966950645999000000000206U3333300_336_S1
+Compile Start Time 2017/02/16 01:03:25.061984
+Compile End Time 2017/02/16 01:03:25.102150
+Compile Elapsed Time 0:00:00.040166
+Execute Start Time 2017/02/16 01:03:28.196863
+Execute End Time 2017/02/16 01:03:28.208332
+Execute Elapsed Time 0:00:00.011469
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -2059,13 +2059,13 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 5
+Number of SQL Processes 3
Number of Cpus 2
Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/01/09 20:10:32.710668
+First Row Returned Time 2017/02/16 01:03:28.206366
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -2073,18 +2073,18 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
Stats Collection Type OPERATOR_STATS
-SQL Process Busy Time 11,223
+SQL Process Busy Time 5,649
UDR Process Busy Time 0
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 15 KB
+SQL Heap Used 14 KB
Processes Created 0
Process Create Time 0
Request Message Count 28
-Request Message Bytes 39,984
+Request Message Bytes 39,712
Reply Message Count 15
-Reply Message Bytes 42,240
+Reply Message Bytes 42,256
Scr. Overflow Mode DISK
Scr File Count 0
Scr. Buffer Blk Size 0
@@ -2099,21 +2099,21 @@ Table Name
Estimated/Actual Estimated/Actual IOs IO MBytes Sum Time Max Time
TRAFODION.SCH.TSTAT
0 100
- 4 4 4 0 8,692 4,705
+ 4 4 4 0 4,503 2,387
--- SQL operation complete.
>>log;
>>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ;
--- SQL operation complete.
->>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
+>>display statistics for QID MXID11000027092212353966950645999000000000206U3333300_336_S1 PROGRESS;
+Qid MXID11000027092212353966950645999000000000206U3333300_336_S1
+Compile Start Time 2017/02/16 01:03:25.061984
+Compile End Time 2017/02/16 01:03:25.102150
+Compile Elapsed Time 0:00:00.040166
+Execute Start Time 2017/02/16 01:03:28.196863
+Execute End Time 2017/02/16 01:03:28.208332
+Execute Elapsed Time 0:00:00.011469
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -2125,13 +2125,13 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 5
+Number of SQL Processes 3
Number of Cpus 2
Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/01/09 20:10:32.710668
+First Row Returned Time 2017/02/16 01:03:28.206366
Last Error before AQR 0
Number of AQR retries 0
Delay before AQR 0
@@ -2139,41 +2139,41 @@ No. of times reclaimed 0
Cancel Time -1
Last Suspend Time -1
Stats Collection Type OPERATOR_STATS
-SQL Process Busy Time 11,223
+SQL Process Busy Time 5,649
SQL Space Allocated 896 KB
SQL Space Used 766 KB
SQL Heap Allocated 135 KB
-SQL Heap Used 15 KB
+SQL Heap Used 14 KB
Processes Created 0
Process Create Time 0
Request Message Count 28
-Request Message Bytes 39,984
+Request Message Bytes 39,712
Reply Message Count 15
-Reply Message Bytes 42,240
+Reply Message Bytes 42,256
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 8,692 4,705
+ 4 4 4 0 4,503 2,387
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
+ 6 EX_HASH_GRBY DISK -1 2,559 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
+>>get statistics for QID MXID11000027092212353966950645999000000000206U3333300_336_S1 PROGRESS;
+Qid MXID11000027092212353966950645999000000000206U3333300_336_S1
+Compile Start Time 2017/02/16 01:03:25.061984
+Compile End Time 2017/02/16 01:03:25.102150
+Compile Elapsed Time 0:00:00.040166
+Execute Start Time 2017/02/16 01:03:28.196863
+Execute End Time 2017/02/16 01:03:28.208332
+Execute Elapsed Time 0:00:00.011469
State CLOSE
Rows Affected 0
SQL Error Code 100
@@ -2185,13 +2185,13 @@ Estimated Used Rows 0
Parent Qid NONE
Parent Query System NONE
Child Qid NONE
-Number of SQL Processes 5
+Number of SQL Processes 3
Number of Cpus 2
Transaction Id -1
Source String select distinct d from tstat ;
SQL Source Length 30
Rows Returned 4
-First Row Returned Time 2017/01/09
<TRUNCATED>