| >> |
| >>create table tstat (a char(5) not null , |
| +> b smallint not null , |
| +> c char(4), |
| +> d integer, |
| +> primary key (a,b) ) |
| +> salt using 2 partitions ; |
| |
| --- SQL operation complete. |
| >>insert into tstat values ('AAAA ',11,'AAAA',11); |
| |
| --- 1 row(s) inserted. |
| >>insert into tstat values ('BBBB ',12,'BBBB',12); |
| |
| --- 1 row(s) inserted. |
| >>insert into tstat values ('MMMM ',21,'MMMM',21); |
| |
| --- 1 row(s) inserted. |
| >>insert into tstat values ('XXXXX',22,'XXXX', 22); |
| |
| --- 1 row(s) inserted. |
| >> |
| >>control query default attempt_esp_parallelism 'on' ; |
| |
| --- SQL operation complete. |
| >>control query default parallel_num_esps '2' ; |
| |
| --- SQL operation complete. |
| >>control query default detailed_statistics 'ACCUMULATED' ; |
| |
| --- SQL operation complete. |
| >>set session default statistics_view_type 'default' ; |
| |
| --- SQL operation complete. |
| >>control query shape esp_exchange(hash_groupby(esp_exchange(scan))); |
| |
| --- SQL operation complete. |
| >> |
| >>-- ACCUMULATED Stats Test |
| >>-- Also tests to mimic ODBC by calling explain options 'f' |
| >>-- and ensure qid current returns the qid user prepared statement |
| >>prepare s1 from select distinct d from tstat ; |
| |
| --- SQL command prepared. |
| >>explain options 'f' s1 ; |
| |
| LC RC OP OPERATOR OPT DESCRIPTION CARD |
| ---- ---- ---- -------------------- -------- -------------------- --------- |
| |
| 4 . 5 root 2.00E+000 |
| 3 . 4 esp_exchange 1:2(hash2) 2.00E+000 |
| 2 . 3 hash_groupby 2.00E+000 |
| 1 . 2 esp_exchange 2(hash2):2(hash2) 1.00E+002 |
| . . 1 trafodion_scan TSTAT 1.00E+002 |
| |
| --- SQL operation complete. |
| >>log LOGRTS; |
| >>get statistics for qid current ; |
| Qid MXID11000011701212378219753251307000000000206U3333300_303_S1 |
| Compile Start Time 2017/11/23 17:56:10.510027 |
| Compile End Time 2017/11/23 17:56:10.581329 |
| Compile Elapsed Time 0:00:00.071302 |
| Execute Start Time -1 |
| Execute End Time -1 |
| Execute Elapsed Time 0:00:00.000000 |
| State CLOSE |
| Rows Affected -1 |
| SQL Error Code 0 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| Number of SQL Processes 1 |
| Number of Cpus 0 |
| Transaction Id -1 |
| Source String select distinct d from tstat ; |
| SQL Source Length 30 |
| Rows Returned 0 |
| First Row Returned Time -1 |
| 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 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; |
| >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ; |
| |
| --- SQL operation complete. |
| >>display statistics for QID MXID11000011701212378219753251307000000000206U3333300_303_S1 ; |
| Qid MXID11000011701212378219753251307000000000206U3333300_303_S1 |
| Compile Start Time 2017/11/23 17:56:10.510027 |
| Compile End Time 2017/11/23 17:56:10.581329 |
| Compile Elapsed Time 0:00:00.071302 |
| Execute Start Time -1 |
| Execute End Time -1 |
| Execute Elapsed Time 0:00:00.000000 |
| State CLOSE |
| Rows Affected -1 |
| SQL Error Code 0 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| Number of SQL Processes 1 |
| Number of Cpus 0 |
| Transaction Id -1 |
| Source String select distinct d from tstat ; |
| SQL Source Length 30 |
| Rows Returned 0 |
| First Row Returned Time -1 |
| 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 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 MXID11000011701212378219753251307000000000206U3333300_303_S1 ; |
| Qid MXID11000011701212378219753251307000000000206U3333300_303_S1 |
| Compile Start Time 2017/11/23 17:56:10.510027 |
| Compile End Time 2017/11/23 17:56:10.581329 |
| Compile Elapsed Time 0:00:00.071302 |
| Execute Start Time -1 |
| Execute End Time -1 |
| Execute Elapsed Time 0:00:00.000000 |
| State CLOSE |
| Rows Affected -1 |
| SQL Error Code 0 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| Number of SQL Processes 1 |
| Number of Cpus 0 |
| Transaction Id -1 |
| Source String select distinct d from tstat ; |
| SQL Source Length 30 |
| Rows Returned 0 |
| First Row Returned Time -1 |
| 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 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 MXID11000011701212378219753251307000000000206U3333300_303_S1 |
| Compile Start Time 2017/11/23 17:56:10.510027 |
| Compile End Time 2017/11/23 17:56:10.581329 |
| Compile Elapsed Time 0:00:00.071302 |
| Execute Start Time -1 |
| Execute End Time -1 |
| Execute Elapsed Time 0:00:00.000000 |
| State CLOSE |
| Rows Affected -1 |
| SQL Error Code 0 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| Number of SQL Processes 1 |
| Number of Cpus 0 |
| Transaction Id -1 |
| Source String select distinct d from tstat ; |
| SQL Source Length 30 |
| Rows Returned 0 |
| First Row Returned Time -1 |
| 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 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 MXID11000011701212378219753251307000000000206U3333300_303_S1 |
| Compile Start Time 2017/11/23 17:56:10.510027 |
| Compile End Time 2017/11/23 17:56:10.581329 |
| Compile Elapsed Time 0:00:00.071302 |
| Execute Start Time -1 |
| Execute End Time -1 |
| Execute Elapsed Time 0:00:00.000000 |
| State CLOSE |
| Rows Affected -1 |
| SQL Error Code 0 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| Number of SQL Processes 1 |
| Number of Cpus 0 |
| Transaction Id -1 |
| Source String select distinct d from tstat ; |
| SQL Source Length 30 |
| Rows Returned 0 |
| First Row Returned Time -1 |
| 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 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. |
| >>execute s1; |
| |
| D |
| ----------- |
| |
| 12 |
| 11 |
| 21 |
| 22 |
| |
| --- 4 row(s) selected. |
| >>log; |
| >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ; |
| |
| --- SQL operation complete. |
| >>display statistics for QID MXID11000011701212378219753251307000000000206U3333300_303_S1 ; |
| Qid MXID11000011701212378219753251307000000000206U3333300_303_S1 |
| Compile Start Time 2017/11/23 17:56:10.510027 |
| Compile End Time 2017/11/23 17:56:10.581329 |
| Compile Elapsed Time 0:00:00.071302 |
| Execute Start Time 2017/11/23 17:56:18.062665 |
| Execute End Time 2017/11/23 17:56:21.535598 |
| Execute Elapsed Time 0:00:03.472933 |
| State CLOSE |
| Rows Affected 0 |
| SQL Error Code 100 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| 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/11/23 17:56:21.533164 |
| 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.472933 secs |
| Max. Execute Time 3.472933 secs |
| Avg. Execute Time 3.472933 secs |
| Stats Collection Type ACCUMULATED_STATS |
| Accessed Rows 4 |
| Used Rows 4 |
| SE IOs 4 |
| SE IO Bytes 176 |
| SE IO MAX Time 699,617 |
| SQL Process Busy Time 4,836,770 |
| UDR Process Busy Time 0 |
| SQL Space Allocated 896 KB |
| SQL Space Used 766 KB |
| SQL Heap Allocated 12,138 KB |
| SQL Heap Used 917 KB |
| SQL Heap WM 68 KB |
| Processes Created 2 |
| Process Create Time 203,095 |
| Request Message Count 26 |
| Request Message Bytes 39,696 |
| Reply Message Count 15 |
| Reply Message Bytes 38,792 |
| BMO Space Buffer Size 0 |
| BMO Space Buffer Count 0 |
| BMO Interim Row Count 0 |
| Scr. Overflow Mode DISK |
| Scr. File Count 0 |
| Scr. IO Size 0 |
| Scr. Read Count 0 |
| Scr. Write Count 0 |
| Scr. IO Max Time 0 |
| Sort TopN -1 |
| |
| --- SQL operation complete. |
| >>get statistics for QID MXID11000011701212378219753251307000000000206U3333300_303_S1 ; |
| Qid MXID11000011701212378219753251307000000000206U3333300_303_S1 |
| Compile Start Time 2017/11/23 17:56:10.510027 |
| Compile End Time 2017/11/23 17:56:10.581329 |
| Compile Elapsed Time 0:00:00.071302 |
| Execute Start Time 2017/11/23 17:56:18.062665 |
| Execute End Time 2017/11/23 17:56:21.535598 |
| Execute Elapsed Time 0:00:03.472933 |
| State CLOSE |
| Rows Affected 0 |
| SQL Error Code 100 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| 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/11/23 17:56:21.533164 |
| 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.472933 secs |
| Max. Execute Time 3.472933 secs |
| Avg. Execute Time 3.472933 secs |
| Stats Collection Type ACCUMULATED_STATS |
| Accessed Rows 4 |
| Used Rows 4 |
| SE IOs 4 |
| SE IO Bytes 176 |
| SE IO MAX Time 699,617 |
| SQL Process Busy Time 4,836,770 |
| UDR Process Busy Time 0 |
| SQL Space Allocated 896 KB |
| SQL Space Used 766 KB |
| SQL Heap Allocated 12,138 KB |
| SQL Heap Used 917 KB |
| SQL Heap WM 68 KB |
| Processes Created 2 |
| Process Create Time 203,095 |
| Request Message Count 26 |
| Request Message Bytes 39,696 |
| Reply Message Count 15 |
| Reply Message Bytes 38,792 |
| BMO Space Buffer Size 0 |
| BMO Space Buffer Count 0 |
| BMO Interim Row Count 0 |
| Scr. Overflow Mode DISK |
| Scr. File Count 0 |
| Scr. IO Size 0 |
| Scr. Read Count 0 |
| Scr. Write Count 0 |
| Scr. IO Max Time 0 |
| Sort TopN -1 |
| |
| --- SQL operation complete. |
| >>log; |
| >>display statistics for qid current; |
| Qid MXID11000011701212378219753251307000000000206U3333300_303_S1 |
| Compile Start Time 2017/11/23 17:56:10.510027 |
| Compile End Time 2017/11/23 17:56:10.581329 |
| Compile Elapsed Time 0:00:00.071302 |
| Execute Start Time 2017/11/23 17:56:18.062665 |
| Execute End Time 2017/11/23 17:56:21.535598 |
| Execute Elapsed Time 0:00:03.472933 |
| State CLOSE |
| Rows Affected 0 |
| SQL Error Code 100 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| 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/11/23 17:56:21.533164 |
| 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.472933 secs |
| Max. Execute Time 3.472933 secs |
| Avg. Execute Time 3.472933 secs |
| Stats Collection Type ACCUMULATED_STATS |
| Accessed Rows 4 |
| Used Rows 4 |
| SE IOs 4 |
| SE IO Bytes 176 |
| SE IO MAX Time 699,617 |
| SQL Process Busy Time 4,836,770 |
| UDR Process Busy Time 0 |
| SQL Space Allocated 896 KB |
| SQL Space Used 766 KB |
| SQL Heap Allocated 12,138 KB |
| SQL Heap Used 917 KB |
| SQL Heap WM 68 KB |
| Processes Created 2 |
| Process Create Time 203,095 |
| Request Message Count 26 |
| Request Message Bytes 39,696 |
| Reply Message Count 15 |
| Reply Message Bytes 38,792 |
| BMO Space Buffer Size 0 |
| BMO Space Buffer Count 0 |
| BMO Interim Row Count 0 |
| Scr. Overflow Mode DISK |
| Scr. File Count 0 |
| Scr. IO Size 0 |
| Scr. Read Count 0 |
| Scr. Write Count 0 |
| Scr. IO Max Time 0 |
| Sort TopN -1 |
| |
| --- SQL operation complete. |
| >>get statistics for qid current ; |
| Qid MXID11000011701212378219753251307000000000206U3333300_303_S1 |
| Compile Start Time 2017/11/23 17:56:10.510027 |
| Compile End Time 2017/11/23 17:56:10.581329 |
| Compile Elapsed Time 0:00:00.071302 |
| Execute Start Time 2017/11/23 17:56:18.062665 |
| Execute End Time 2017/11/23 17:56:21.535598 |
| Execute Elapsed Time 0:00:03.472933 |
| State CLOSE |
| Rows Affected 0 |
| SQL Error Code 100 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| 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/11/23 17:56:21.533164 |
| 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.472933 secs |
| Max. Execute Time 3.472933 secs |
| Avg. Execute Time 3.472933 secs |
| Stats Collection Type ACCUMULATED_STATS |
| Accessed Rows 4 |
| Used Rows 4 |
| SE IOs 4 |
| SE IO Bytes 176 |
| SE IO MAX Time 699,617 |
| SQL Process Busy Time 4,836,770 |
| UDR Process Busy Time 0 |
| SQL Space Allocated 896 KB |
| SQL Space Used 766 KB |
| SQL Heap Allocated 12,138 KB |
| SQL Heap Used 917 KB |
| SQL Heap WM 68 KB |
| Processes Created 2 |
| Process Create Time 203,095 |
| Request Message Count 26 |
| Request Message Bytes 39,696 |
| Reply Message Count 15 |
| Reply Message Bytes 38,792 |
| BMO Space Buffer Size 0 |
| BMO Space Buffer Count 0 |
| BMO Interim Row Count 0 |
| Scr. Overflow Mode DISK |
| Scr. File Count 0 |
| Scr. IO Size 0 |
| Scr. Read Count 0 |
| Scr. Write Count 0 |
| Scr. IO Max Time 0 |
| Sort TopN -1 |
| |
| --- SQL operation complete. |
| >>prepare s1 from select distinct d from tstat ; |
| |
| --- SQL command prepared. |
| >>log; |
| >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ; |
| |
| --- SQL operation complete. |
| >>display statistics for QID MXID11000011701212378219753251307000000000206U3333300_303_S1 ; |
| |
| *** ERROR[8923] The given Query Id MXID11000011701212378219753251307000000000206U3333300_303_S1 is not found. |
| |
| --- SQL operation failed with errors. |
| >>get statistics for QID MXID11000011701212378219753251307000000000206U3333300_303_S1 ; |
| |
| *** ERROR[8923] The given Query Id MXID11000011701212378219753251307000000000206U3333300_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 MXID11000011701212378219753251307000000000206U3333300_312_S1 ; |
| Qid MXID11000011701212378219753251307000000000206U3333300_312_S1 |
| Compile Start Time 2017/11/23 17:56:25.831881 |
| Compile End Time 2017/11/23 17:56:25.834511 |
| Compile Elapsed Time 0:00:00.002630 |
| Execute Start Time -1 |
| Execute End Time -1 |
| Execute Elapsed Time 0:00:00.000000 |
| State CLOSE |
| Rows Affected -1 |
| SQL Error Code 0 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| Number of SQL Processes 1 |
| Number of Cpus 0 |
| Transaction Id -1 |
| Source String select distinct d from tstat ; |
| SQL Source Length 30 |
| Rows Returned 0 |
| First Row Returned Time -1 |
| 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 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 MXID11000011701212378219753251307000000000206U3333300_312_S1 ; |
| Qid MXID11000011701212378219753251307000000000206U3333300_312_S1 |
| Compile Start Time 2017/11/23 17:56:25.831881 |
| Compile End Time 2017/11/23 17:56:25.834511 |
| Compile Elapsed Time 0:00:00.002630 |
| Execute Start Time -1 |
| Execute End Time -1 |
| Execute Elapsed Time 0:00:00.000000 |
| State CLOSE |
| Rows Affected -1 |
| SQL Error Code 0 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| Number of SQL Processes 1 |
| Number of Cpus 0 |
| Transaction Id -1 |
| Source String select distinct d from tstat ; |
| SQL Source Length 30 |
| Rows Returned 0 |
| First Row Returned Time -1 |
| 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 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 MXID11000011701212378219753251307000000000206U3333300_312_S1 |
| Compile Start Time 2017/11/23 17:56:25.831881 |
| Compile End Time 2017/11/23 17:56:25.834511 |
| Compile Elapsed Time 0:00:00.002630 |
| Execute Start Time -1 |
| Execute End Time -1 |
| Execute Elapsed Time 0:00:00.000000 |
| State CLOSE |
| Rows Affected -1 |
| SQL Error Code 0 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| Number of SQL Processes 1 |
| Number of Cpus 0 |
| Transaction Id -1 |
| Source String select distinct d from tstat ; |
| SQL Source Length 30 |
| Rows Returned 0 |
| First Row Returned Time -1 |
| 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 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 MXID11000011701212378219753251307000000000206U3333300_312_S1 |
| Compile Start Time 2017/11/23 17:56:25.831881 |
| Compile End Time 2017/11/23 17:56:25.834511 |
| Compile Elapsed Time 0:00:00.002630 |
| Execute Start Time -1 |
| Execute End Time -1 |
| Execute Elapsed Time 0:00:00.000000 |
| State CLOSE |
| Rows Affected -1 |
| SQL Error Code 0 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| Number of SQL Processes 1 |
| Number of Cpus 0 |
| Transaction Id -1 |
| Source String select distinct d from tstat ; |
| SQL Source Length 30 |
| Rows Returned 0 |
| First Row Returned Time -1 |
| 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 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. |
| >> |
| >>-- PERTABLE stats |
| >>control query default detailed_statistics 'pertable' ; |
| |
| --- SQL operation complete. |
| >>set session default statistics_view_type 'default' ; |
| |
| --- SQL operation complete. |
| >>prepare s1 from select distinct d from tstat ; |
| |
| --- SQL command prepared. |
| >>log; |
| >>get statistics for qid current ; |
| Qid MXID11000011701212378219753251307000000000206U3333300_317_S1 |
| Compile Start Time 2017/11/23 17:56:33.591183 |
| Compile End Time 2017/11/23 17:56:33.657895 |
| Compile Elapsed Time 0:00:00.066712 |
| Execute Start Time -1 |
| Execute End Time -1 |
| Execute Elapsed Time 0:00:00.000000 |
| State CLOSE |
| Rows Affected -1 |
| SQL Error Code 0 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| Number of SQL Processes 1 |
| Number of Cpus 0 |
| Transaction Id -1 |
| Source String select distinct d from tstat ; |
| SQL Source Length 30 |
| Rows Returned 0 |
| First Row Returned Time -1 |
| 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 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; |
| >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ; |
| |
| --- SQL operation complete. |
| >>display statistics for QID MXID11000011701212378219753251307000000000206U3333300_317_S1 ; |
| Qid MXID11000011701212378219753251307000000000206U3333300_317_S1 |
| Compile Start Time 2017/11/23 17:56:33.591183 |
| Compile End Time 2017/11/23 17:56:33.657895 |
| Compile Elapsed Time 0:00:00.066712 |
| Execute Start Time -1 |
| Execute End Time -1 |
| Execute Elapsed Time 0:00:00.000000 |
| State CLOSE |
| Rows Affected -1 |
| SQL Error Code 0 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| Number of SQL Processes 1 |
| Number of Cpus 0 |
| Transaction Id -1 |
| Source String select distinct d from tstat ; |
| SQL Source Length 30 |
| Rows Returned 0 |
| First Row Returned Time -1 |
| 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 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 MXID11000011701212378219753251307000000000206U3333300_317_S1 ; |
| Qid MXID11000011701212378219753251307000000000206U3333300_317_S1 |
| Compile Start Time 2017/11/23 17:56:33.591183 |
| Compile End Time 2017/11/23 17:56:33.657895 |
| Compile Elapsed Time 0:00:00.066712 |
| Execute Start Time -1 |
| Execute End Time -1 |
| Execute Elapsed Time 0:00:00.000000 |
| State CLOSE |
| Rows Affected -1 |
| SQL Error Code 0 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| Number of SQL Processes 1 |
| Number of Cpus 0 |
| Transaction Id -1 |
| Source String select distinct d from tstat ; |
| SQL Source Length 30 |
| Rows Returned 0 |
| First Row Returned Time -1 |
| 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 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; |
| >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ; |
| |
| --- SQL operation complete. |
| >>display statistics for QID MXID11000011701212378219753251307000000000206U3333300_317_S1 ACCUMULATED; |
| Qid MXID11000011701212378219753251307000000000206U3333300_317_S1 |
| Compile Start Time 2017/11/23 17:56:33.591183 |
| Compile End Time 2017/11/23 17:56:33.657895 |
| Compile Elapsed Time 0:00:00.066712 |
| Execute Start Time -1 |
| Execute End Time -1 |
| Execute Elapsed Time 0:00:00.000000 |
| State CLOSE |
| Rows Affected -1 |
| SQL Error Code 0 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| Number of SQL Processes 1 |
| Number of Cpus 0 |
| Transaction Id -1 |
| Source String select distinct d from tstat ; |
| SQL Source Length 30 |
| Rows Returned 0 |
| First Row Returned Time -1 |
| 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 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 MXID11000011701212378219753251307000000000206U3333300_317_S1 ACCUMULATED; |
| Qid MXID11000011701212378219753251307000000000206U3333300_317_S1 |
| Compile Start Time 2017/11/23 17:56:33.591183 |
| Compile End Time 2017/11/23 17:56:33.657895 |
| Compile Elapsed Time 0:00:00.066712 |
| Execute Start Time -1 |
| Execute End Time -1 |
| Execute Elapsed Time 0:00:00.000000 |
| State CLOSE |
| Rows Affected -1 |
| SQL Error Code 0 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| Number of SQL Processes 1 |
| Number of Cpus 0 |
| Transaction Id -1 |
| Source String select distinct d from tstat ; |
| SQL Source Length 30 |
| Rows Returned 0 |
| First Row Returned Time -1 |
| 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 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 MXID11000011701212378219753251307000000000206U3333300_317_S1 |
| Compile Start Time 2017/11/23 17:56:33.591183 |
| Compile End Time 2017/11/23 17:56:33.657895 |
| Compile Elapsed Time 0:00:00.066712 |
| Execute Start Time -1 |
| Execute End Time -1 |
| Execute Elapsed Time 0:00:00.000000 |
| State CLOSE |
| Rows Affected -1 |
| SQL Error Code 0 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| Number of SQL Processes 1 |
| Number of Cpus 0 |
| Transaction Id -1 |
| Source String select distinct d from tstat ; |
| SQL Source Length 30 |
| Rows Returned 0 |
| First Row Returned Time -1 |
| 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 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 MXID11000011701212378219753251307000000000206U3333300_317_S1 |
| Compile Start Time 2017/11/23 17:56:33.591183 |
| Compile End Time 2017/11/23 17:56:33.657895 |
| Compile Elapsed Time 0:00:00.066712 |
| Execute Start Time -1 |
| Execute End Time -1 |
| Execute Elapsed Time 0:00:00.000000 |
| State CLOSE |
| Rows Affected -1 |
| SQL Error Code 0 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| Number of SQL Processes 1 |
| Number of Cpus 0 |
| Transaction Id -1 |
| Source String select distinct d from tstat ; |
| SQL Source Length 30 |
| Rows Returned 0 |
| First Row Returned Time -1 |
| 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 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 MXID11000011701212378219753251307000000000206U3333300_317_S1 |
| Compile Start Time 2017/11/23 17:56:33.591183 |
| Compile End Time 2017/11/23 17:56:33.657895 |
| Compile Elapsed Time 0:00:00.066712 |
| Execute Start Time -1 |
| Execute End Time -1 |
| Execute Elapsed Time 0:00:00.000000 |
| State CLOSE |
| Rows Affected -1 |
| SQL Error Code 0 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| Number of SQL Processes 1 |
| Number of Cpus 0 |
| Transaction Id -1 |
| Source String select distinct d from tstat ; |
| SQL Source Length 30 |
| Rows Returned 0 |
| First Row Returned Time -1 |
| 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 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 MXID11000011701212378219753251307000000000206U3333300_317_S1 |
| Compile Start Time 2017/11/23 17:56:33.591183 |
| Compile End Time 2017/11/23 17:56:33.657895 |
| Compile Elapsed Time 0:00:00.066712 |
| Execute Start Time -1 |
| Execute End Time -1 |
| Execute Elapsed Time 0:00:00.000000 |
| State CLOSE |
| Rows Affected -1 |
| SQL Error Code 0 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| Number of SQL Processes 1 |
| Number of Cpus 0 |
| Transaction Id -1 |
| Source String select distinct d from tstat ; |
| SQL Source Length 30 |
| Rows Returned 0 |
| First Row Returned Time -1 |
| 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 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. |
| >>execute s1; |
| |
| D |
| ----------- |
| |
| 12 |
| 11 |
| 21 |
| 22 |
| |
| --- 4 row(s) selected. |
| >>log; |
| >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ; |
| |
| --- SQL operation complete. |
| >>display statistics for QID MXID11000011701212378219753251307000000000206U3333300_317_S1 ; |
| Qid MXID11000011701212378219753251307000000000206U3333300_317_S1 |
| Compile Start Time 2017/11/23 17:56:33.591183 |
| Compile End Time 2017/11/23 17:56:33.657895 |
| Compile Elapsed Time 0:00:00.066712 |
| Execute Start Time 2017/11/23 17:56:41.333784 |
| Execute End Time 2017/11/23 17:56:41.377591 |
| Execute Elapsed Time 0:00:00.043807 |
| State CLOSE |
| Rows Affected 0 |
| SQL Error Code 100 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| 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/11/23 17:56:41.375158 |
| 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.043807 secs |
| Max. Execute Time 0.043807 secs |
| Avg. Execute Time 0.043807 secs |
| Stats Collection Type PERTABLE_STATS |
| SQL Process Busy Time 23,792 |
| UDR Process Busy Time 0 |
| SQL Space Allocated 896 KB |
| SQL Space Used 766 KB |
| SQL Heap Allocated 1,032 KB |
| SQL Heap Used 913 KB |
| SQL Heap WM 11,171 KB |
| Processes Created 0 |
| Process Create Time 0 |
| Request Message Count 27 |
| Request Message Bytes 39,856 |
| Reply Message Count 15 |
| Reply Message Bytes 39,208 |
| BMO Space Buffer Size 0 |
| BMO Space Buffer Count 0 |
| BMO Interim Row Count 0 |
| Scr. Overflow Mode UNKNOWN |
| Scr. File Count 0 |
| Scr. IO Size 0 |
| Scr. Read Count 0 |
| Scr. Write Count 0 |
| 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 |
| 1 2 TRAFODION.SCH.TSTAT |
| 0 4 100 4 4 0 13,543 7,340 |
| |
| --- SQL operation complete. |
| >>get statistics for QID MXID11000011701212378219753251307000000000206U3333300_317_S1 ; |
| Qid MXID11000011701212378219753251307000000000206U3333300_317_S1 |
| Compile Start Time 2017/11/23 17:56:33.591183 |
| Compile End Time 2017/11/23 17:56:33.657895 |
| Compile Elapsed Time 0:00:00.066712 |
| Execute Start Time 2017/11/23 17:56:41.333784 |
| Execute End Time 2017/11/23 17:56:41.377591 |
| Execute Elapsed Time 0:00:00.043807 |
| State CLOSE |
| Rows Affected 0 |
| SQL Error Code 100 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| 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/11/23 17:56:41.375158 |
| 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.043807 secs |
| Max. Execute Time 0.043807 secs |
| Avg. Execute Time 0.043807 secs |
| Stats Collection Type PERTABLE_STATS |
| SQL Process Busy Time 23,792 |
| UDR Process Busy Time 0 |
| SQL Space Allocated 896 KB |
| SQL Space Used 766 KB |
| SQL Heap Allocated 1,032 KB |
| SQL Heap Used 913 KB |
| SQL Heap WM 11,171 KB |
| Processes Created 0 |
| Process Create Time 0 |
| Request Message Count 27 |
| Request Message Bytes 39,856 |
| Reply Message Count 15 |
| Reply Message Bytes 39,208 |
| BMO Space Buffer Size 0 |
| BMO Space Buffer Count 0 |
| BMO Interim Row Count 0 |
| Scr. Overflow Mode UNKNOWN |
| Scr. File Count 0 |
| Scr. IO Size 0 |
| Scr. Read Count 0 |
| Scr. Write Count 0 |
| 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 |
| 1 2 TRAFODION.SCH.TSTAT |
| 0 4 100 4 4 0 13,543 7,340 |
| |
| --- SQL operation complete. |
| >>log; |
| >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ; |
| |
| --- SQL operation complete. |
| >>display statistics for QID MXID11000011701212378219753251307000000000206U3333300_317_S1 ACCUMULATED; |
| Qid MXID11000011701212378219753251307000000000206U3333300_317_S1 |
| Compile Start Time 2017/11/23 17:56:33.591183 |
| Compile End Time 2017/11/23 17:56:33.657895 |
| Compile Elapsed Time 0:00:00.066712 |
| Execute Start Time 2017/11/23 17:56:41.333784 |
| Execute End Time 2017/11/23 17:56:41.377591 |
| Execute Elapsed Time 0:00:00.043807 |
| State CLOSE |
| Rows Affected 0 |
| SQL Error Code 100 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| 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/11/23 17:56:41.375158 |
| 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.043807 secs |
| Max. Execute Time 0.043807 secs |
| Avg. Execute Time 0.043807 secs |
| Stats Collection Type PERTABLE_STATS |
| Accessed Rows 4 |
| Used Rows 4 |
| SE IOs 4 |
| SE IO Bytes 176 |
| SE IO MAX Time 7,340 |
| SQL Process Busy Time 23,792 |
| UDR Process Busy Time 0 |
| SQL Space Allocated 896 KB |
| SQL Space Used 766 KB |
| SQL Heap Allocated 1,032 KB |
| SQL Heap Used 913 KB |
| SQL Heap WM 11,171 KB |
| Processes Created 0 |
| Process Create Time 0 |
| Request Message Count 27 |
| Request Message Bytes 39,856 |
| Reply Message Count 15 |
| Reply Message Bytes 39,208 |
| BMO Space Buffer Size 0 |
| BMO Space Buffer Count 0 |
| BMO Interim Row Count 0 |
| Scr. Overflow Mode UNKNOWN |
| Scr. File Count 0 |
| Scr. IO Size 0 |
| Scr. Read Count 0 |
| Scr. Write Count 0 |
| Scr. IO Max Time 0 |
| Sort TopN -1 |
| |
| --- SQL operation complete. |
| >>get statistics for QID MXID11000011701212378219753251307000000000206U3333300_317_S1 ACCUMULATED; |
| Qid MXID11000011701212378219753251307000000000206U3333300_317_S1 |
| Compile Start Time 2017/11/23 17:56:33.591183 |
| Compile End Time 2017/11/23 17:56:33.657895 |
| Compile Elapsed Time 0:00:00.066712 |
| Execute Start Time 2017/11/23 17:56:41.333784 |
| Execute End Time 2017/11/23 17:56:41.377591 |
| Execute Elapsed Time 0:00:00.043807 |
| State CLOSE |
| Rows Affected 0 |
| SQL Error Code 100 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| 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/11/23 17:56:41.375158 |
| 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.043807 secs |
| Max. Execute Time 0.043807 secs |
| Avg. Execute Time 0.043807 secs |
| Stats Collection Type PERTABLE_STATS |
| Accessed Rows 4 |
| Used Rows 4 |
| SE IOs 4 |
| SE IO Bytes 176 |
| SE IO MAX Time 7,340 |
| SQL Process Busy Time 23,792 |
| UDR Process Busy Time 0 |
| SQL Space Allocated 896 KB |
| SQL Space Used 766 KB |
| SQL Heap Allocated 1,032 KB |
| SQL Heap Used 913 KB |
| SQL Heap WM 11,171 KB |
| Processes Created 0 |
| Process Create Time 0 |
| Request Message Count 27 |
| Request Message Bytes 39,856 |
| Reply Message Count 15 |
| Reply Message Bytes 39,208 |
| BMO Space Buffer Size 0 |
| BMO Space Buffer Count 0 |
| BMO Interim Row Count 0 |
| Scr. Overflow Mode UNKNOWN |
| Scr. File Count 0 |
| Scr. IO Size 0 |
| Scr. Read Count 0 |
| Scr. Write Count 0 |
| Scr. IO Max Time 0 |
| Sort TopN -1 |
| |
| --- SQL operation complete. |
| >>log; |
| >>display statistics for qid current; |
| Qid MXID11000011701212378219753251307000000000206U3333300_317_S1 |
| Compile Start Time 2017/11/23 17:56:33.591183 |
| Compile End Time 2017/11/23 17:56:33.657895 |
| Compile Elapsed Time 0:00:00.066712 |
| Execute Start Time 2017/11/23 17:56:41.333784 |
| Execute End Time 2017/11/23 17:56:41.377591 |
| Execute Elapsed Time 0:00:00.043807 |
| State CLOSE |
| Rows Affected 0 |
| SQL Error Code 100 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| 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/11/23 17:56:41.375158 |
| 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.043807 secs |
| Max. Execute Time 0.043807 secs |
| Avg. Execute Time 0.043807 secs |
| Stats Collection Type PERTABLE_STATS |
| SQL Process Busy Time 23,792 |
| UDR Process Busy Time 0 |
| SQL Space Allocated 896 KB |
| SQL Space Used 766 KB |
| SQL Heap Allocated 1,032 KB |
| SQL Heap Used 913 KB |
| SQL Heap WM 11,171 KB |
| Processes Created 0 |
| Process Create Time 0 |
| Request Message Count 27 |
| Request Message Bytes 39,856 |
| Reply Message Count 15 |
| Reply Message Bytes 39,208 |
| BMO Space Buffer Size 0 |
| BMO Space Buffer Count 0 |
| BMO Interim Row Count 0 |
| Scr. Overflow Mode UNKNOWN |
| Scr. File Count 0 |
| Scr. IO Size 0 |
| Scr. Read Count 0 |
| Scr. Write Count 0 |
| 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 |
| 1 2 TRAFODION.SCH.TSTAT |
| 0 4 100 4 4 0 13,543 7,340 |
| |
| --- SQL operation complete. |
| >>get statistics for qid current ; |
| Qid MXID11000011701212378219753251307000000000206U3333300_317_S1 |
| Compile Start Time 2017/11/23 17:56:33.591183 |
| Compile End Time 2017/11/23 17:56:33.657895 |
| Compile Elapsed Time 0:00:00.066712 |
| Execute Start Time 2017/11/23 17:56:41.333784 |
| Execute End Time 2017/11/23 17:56:41.377591 |
| Execute Elapsed Time 0:00:00.043807 |
| State CLOSE |
| Rows Affected 0 |
| SQL Error Code 100 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| 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/11/23 17:56:41.375158 |
| 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.043807 secs |
| Max. Execute Time 0.043807 secs |
| Avg. Execute Time 0.043807 secs |
| Stats Collection Type PERTABLE_STATS |
| SQL Process Busy Time 23,792 |
| UDR Process Busy Time 0 |
| SQL Space Allocated 896 KB |
| SQL Space Used 766 KB |
| SQL Heap Allocated 1,032 KB |
| SQL Heap Used 913 KB |
| SQL Heap WM 11,171 KB |
| Processes Created 0 |
| Process Create Time 0 |
| Request Message Count 27 |
| Request Message Bytes 39,856 |
| Reply Message Count 15 |
| Reply Message Bytes 39,208 |
| BMO Space Buffer Size 0 |
| BMO Space Buffer Count 0 |
| BMO Interim Row Count 0 |
| Scr. Overflow Mode UNKNOWN |
| Scr. File Count 0 |
| Scr. IO Size 0 |
| Scr. Read Count 0 |
| Scr. Write Count 0 |
| 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 |
| 1 2 TRAFODION.SCH.TSTAT |
| 0 4 100 4 4 0 13,543 7,340 |
| |
| --- SQL operation complete. |
| >>display statistics for qid current accumulated; |
| Qid MXID11000011701212378219753251307000000000206U3333300_317_S1 |
| Compile Start Time 2017/11/23 17:56:33.591183 |
| Compile End Time 2017/11/23 17:56:33.657895 |
| Compile Elapsed Time 0:00:00.066712 |
| Execute Start Time 2017/11/23 17:56:41.333784 |
| Execute End Time 2017/11/23 17:56:41.377591 |
| Execute Elapsed Time 0:00:00.043807 |
| State CLOSE |
| Rows Affected 0 |
| SQL Error Code 100 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| 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/11/23 17:56:41.375158 |
| 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.043807 secs |
| Max. Execute Time 0.043807 secs |
| Avg. Execute Time 0.043807 secs |
| Stats Collection Type PERTABLE_STATS |
| Accessed Rows 4 |
| Used Rows 4 |
| SE IOs 4 |
| SE IO Bytes 176 |
| SE IO MAX Time 7,340 |
| SQL Process Busy Time 23,792 |
| UDR Process Busy Time 0 |
| SQL Space Allocated 896 KB |
| SQL Space Used 766 KB |
| SQL Heap Allocated 1,032 KB |
| SQL Heap Used 913 KB |
| SQL Heap WM 11,171 KB |
| Processes Created 0 |
| Process Create Time 0 |
| Request Message Count 27 |
| Request Message Bytes 39,856 |
| Reply Message Count 15 |
| Reply Message Bytes 39,208 |
| BMO Space Buffer Size 0 |
| BMO Space Buffer Count 0 |
| BMO Interim Row Count 0 |
| Scr. Overflow Mode UNKNOWN |
| Scr. File Count 0 |
| Scr. IO Size 0 |
| Scr. Read Count 0 |
| Scr. Write Count 0 |
| Scr. IO Max Time 0 |
| Sort TopN -1 |
| |
| --- SQL operation complete. |
| >>get statistics for qid current accumulated; |
| Qid MXID11000011701212378219753251307000000000206U3333300_317_S1 |
| Compile Start Time 2017/11/23 17:56:33.591183 |
| Compile End Time 2017/11/23 17:56:33.657895 |
| Compile Elapsed Time 0:00:00.066712 |
| Execute Start Time 2017/11/23 17:56:41.333784 |
| Execute End Time 2017/11/23 17:56:41.377591 |
| Execute Elapsed Time 0:00:00.043807 |
| State CLOSE |
| Rows Affected 0 |
| SQL Error Code 100 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| 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/11/23 17:56:41.375158 |
| 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.043807 secs |
| Max. Execute Time 0.043807 secs |
| Avg. Execute Time 0.043807 secs |
| Stats Collection Type PERTABLE_STATS |
| Accessed Rows 4 |
| Used Rows 4 |
| SE IOs 4 |
| SE IO Bytes 176 |
| SE IO MAX Time 7,340 |
| SQL Process Busy Time 23,792 |
| UDR Process Busy Time 0 |
| SQL Space Allocated 896 KB |
| SQL Space Used 766 KB |
| SQL Heap Allocated 1,032 KB |
| SQL Heap Used 913 KB |
| SQL Heap WM 11,171 KB |
| Processes Created 0 |
| Process Create Time 0 |
| Request Message Count 27 |
| Request Message Bytes 39,856 |
| Reply Message Count 15 |
| Reply Message Bytes 39,208 |
| BMO Space Buffer Size 0 |
| BMO Space Buffer Count 0 |
| BMO Interim Row Count 0 |
| Scr. Overflow Mode UNKNOWN |
| Scr. File Count 0 |
| Scr. IO Size 0 |
| Scr. Read Count 0 |
| Scr. Write Count 0 |
| Scr. IO Max Time 0 |
| Sort TopN -1 |
| |
| --- SQL operation complete. |
| >>log; |
| >>obey PQIDOUT; |
| >>SET SESSION DEFAULT PARENT_QID 'MXID11000011701212378219753251307000000000206U3333300_317_S1'; |
| |
| --- SQL operation complete. |
| >>prepare s1 from select distinct d from tstat ; |
| |
| --- SQL command prepared. |
| >>log; |
| >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ; |
| |
| --- SQL operation complete. |
| >>display statistics for QID MXID11000011701212378219753251307000000000206U3333300_331_S1 ; |
| Qid MXID11000011701212378219753251307000000000206U3333300_331_S1 |
| Compile Start Time 2017/11/23 17:56:49.393860 |
| Compile End Time 2017/11/23 17:56:49.395625 |
| Compile Elapsed Time 0:00:00.001765 |
| Execute Start Time -1 |
| Execute End Time -1 |
| Execute Elapsed Time 0:00:00.000000 |
| State CLOSE |
| Rows Affected -1 |
| SQL Error Code 0 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid MXID11000011701212378219753251307000000000206U3333300_317_S1 |
| Parent Query System SAME |
| Child Qid NONE |
| Number of SQL Processes 1 |
| Number of Cpus 0 |
| Transaction Id -1 |
| Source String select distinct d from tstat ; |
| SQL Source Length 30 |
| Rows Returned 0 |
| First Row Returned Time -1 |
| 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 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 MXID11000011701212378219753251307000000000206U3333300_331_S1 ; |
| Qid MXID11000011701212378219753251307000000000206U3333300_331_S1 |
| Compile Start Time 2017/11/23 17:56:49.393860 |
| Compile End Time 2017/11/23 17:56:49.395625 |
| Compile Elapsed Time 0:00:00.001765 |
| Execute Start Time -1 |
| Execute End Time -1 |
| Execute Elapsed Time 0:00:00.000000 |
| State CLOSE |
| Rows Affected -1 |
| SQL Error Code 0 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid MXID11000011701212378219753251307000000000206U3333300_317_S1 |
| Parent Query System SAME |
| Child Qid NONE |
| Number of SQL Processes 1 |
| Number of Cpus 0 |
| Transaction Id -1 |
| Source String select distinct d from tstat ; |
| SQL Source Length 30 |
| Rows Returned 0 |
| First Row Returned Time -1 |
| 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 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; |
| >>SET SESSION DEFAULT PARENT_QID 'NONE' ; |
| |
| --- SQL operation complete. |
| >>prepare s1 from select distinct d from tstat ; |
| |
| --- SQL command prepared. |
| >>log; |
| >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ; |
| |
| --- SQL operation complete. |
| >>display statistics for QID MXID11000011701212378219753251307000000000206U3333300_333_S1 ; |
| Qid MXID11000011701212378219753251307000000000206U3333300_333_S1 |
| Compile Start Time 2017/11/23 17:56:53.100908 |
| Compile End Time 2017/11/23 17:56:53.102456 |
| Compile Elapsed Time 0:00:00.001548 |
| Execute Start Time -1 |
| Execute End Time -1 |
| Execute Elapsed Time 0:00:00.000000 |
| State CLOSE |
| Rows Affected -1 |
| SQL Error Code 0 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| Number of SQL Processes 1 |
| Number of Cpus 0 |
| Transaction Id -1 |
| Source String select distinct d from tstat ; |
| SQL Source Length 30 |
| Rows Returned 0 |
| First Row Returned Time -1 |
| 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 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 MXID11000011701212378219753251307000000000206U3333300_333_S1 ; |
| Qid MXID11000011701212378219753251307000000000206U3333300_333_S1 |
| Compile Start Time 2017/11/23 17:56:53.100908 |
| Compile End Time 2017/11/23 17:56:53.102456 |
| Compile Elapsed Time 0:00:00.001548 |
| Execute Start Time -1 |
| Execute End Time -1 |
| Execute Elapsed Time 0:00:00.000000 |
| State CLOSE |
| Rows Affected -1 |
| SQL Error Code 0 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| Number of SQL Processes 1 |
| Number of Cpus 0 |
| Transaction Id -1 |
| Source String select distinct d from tstat ; |
| SQL Source Length 30 |
| Rows Returned 0 |
| First Row Returned Time -1 |
| 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 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; |
| >> |
| >>-- TEST for OPERATOR stats |
| >>control query default detailed_statistics 'system' ; |
| |
| --- SQL operation complete. |
| >>set session default statistics_view_type 'default' ; |
| |
| --- SQL operation complete. |
| >>prepare s1 from select distinct d from tstat ; |
| |
| --- SQL command prepared. |
| >>log ; |
| >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ; |
| |
| --- SQL operation complete. |
| >>display statistics for QID MXID11000011701212378219753251307000000000206U3333300_336_S1 ; |
| Qid MXID11000011701212378219753251307000000000206U3333300_336_S1 |
| Compile Start Time 2017/11/23 17:56:56.513528 |
| Compile End Time 2017/11/23 17:56:56.575220 |
| Compile Elapsed Time 0:00:00.061692 |
| Execute Start Time -1 |
| Execute End Time -1 |
| Execute Elapsed Time 0:00:00.000000 |
| State CLOSE |
| Rows Affected -1 |
| SQL Error Code 0 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| Number of SQL Processes 1 |
| Number of Cpus 0 |
| Transaction Id -1 |
| Source String select distinct d from tstat ; |
| SQL Source Length 30 |
| Rows Returned 0 |
| First Row Returned Time -1 |
| 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 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 MXID11000011701212378219753251307000000000206U3333300_336_S1 ; |
| Qid MXID11000011701212378219753251307000000000206U3333300_336_S1 |
| Compile Start Time 2017/11/23 17:56:56.513528 |
| Compile End Time 2017/11/23 17:56:56.575220 |
| Compile Elapsed Time 0:00:00.061692 |
| Execute Start Time -1 |
| Execute End Time -1 |
| Execute Elapsed Time 0:00:00.000000 |
| State CLOSE |
| Rows Affected -1 |
| SQL Error Code 0 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| Number of SQL Processes 1 |
| Number of Cpus 0 |
| Transaction Id -1 |
| Source String select distinct d from tstat ; |
| SQL Source Length 30 |
| Rows Returned 0 |
| First Row Returned Time -1 |
| 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 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. |
| >>log; |
| >>execute s1 ; |
| |
| D |
| ----------- |
| |
| 12 |
| 11 |
| 21 |
| 22 |
| |
| --- 4 row(s) selected. |
| >>log ; |
| >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ; |
| |
| --- SQL operation complete. |
| >>display statistics for QID MXID11000011701212378219753251307000000000206U3333300_336_S1 ; |
| Qid MXID11000011701212378219753251307000000000206U3333300_336_S1 |
| Compile Start Time 2017/11/23 17:56:56.513528 |
| Compile End Time 2017/11/23 17:56:56.575220 |
| Compile Elapsed Time 0:00:00.061692 |
| Execute Start Time 2017/11/23 17:57:00.313805 |
| Execute End Time 2017/11/23 17:57:00.341117 |
| Execute Elapsed Time 0:00:00.027312 |
| State CLOSE |
| Rows Affected 0 |
| SQL Error Code 100 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| 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/11/23 17:57:00.337861 |
| 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.027312 secs |
| Max. Execute Time 0.027312 secs |
| Avg. Execute Time 0.027312 secs |
| Stats Collection Type OPERATOR_STATS |
| |
| LC RC Id PaId ExId Frag TDBName DOP Dispatches OperCPUTime EstRowsUsed ActRowsUsed Details |
| |
| 10 . 11 . 5 0 EX_ROOT 1 5 16 0 4 1683 |
| 9 . 10 11 4 0 EX_SPLIT_TOP 1 5 46 2 4 |
| 8 . 9 10 4 0 EX_SEND_TOP 2 10 1,621 2 4 |
| 7 . 8 9 4 2 EX_SEND_BOTTOM 2 17 240 2 4 |
| 6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 52 2 4 5674 |
| 5 . 6 7 3 2 EX_HASH_GRBY 2 6 3,392 1 4 0|0|0 |
| 4 . 5 6 2 2 EX_SPLIT_TOP 2 9 52 100 4 |
| 3 . 4 5 2 2 EX_SEND_TOP 4 18 1,938 100 4 |
| 2 . 3 4 2 3 EX_SEND_BOTTOM 4 26 395 100 4 |
| 1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 8 80 100 4 8565 |
| . . 1 2 1 3 EX_TRAF_KEY_SELECT 2 4 8,090 100 4 TRAFODION.SCH.TSTAT|4|176 |
| |
| --- SQL operation complete. |
| >>get statistics for QID MXID11000011701212378219753251307000000000206U3333300_336_S1 ; |
| Qid MXID11000011701212378219753251307000000000206U3333300_336_S1 |
| Compile Start Time 2017/11/23 17:56:56.513528 |
| Compile End Time 2017/11/23 17:56:56.575220 |
| Compile Elapsed Time 0:00:00.061692 |
| Execute Start Time 2017/11/23 17:57:00.313805 |
| Execute End Time 2017/11/23 17:57:00.341117 |
| Execute Elapsed Time 0:00:00.027312 |
| State CLOSE |
| Rows Affected 0 |
| SQL Error Code 100 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| 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/11/23 17:57:00.337861 |
| 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.027312 secs |
| Max. Execute Time 0.027312 secs |
| Avg. Execute Time 0.027312 secs |
| Stats Collection Type OPERATOR_STATS |
| |
| LC RC Id PaId ExId Frag TDBName DOP Dispatches OperCPUTime EstRowsUsed ActRowsUsed Details |
| |
| 10 . 11 . 5 0 EX_ROOT 1 5 16 0 4 1683 |
| 9 . 10 11 4 0 EX_SPLIT_TOP 1 5 46 2 4 |
| 8 . 9 10 4 0 EX_SEND_TOP 2 10 1,621 2 4 |
| 7 . 8 9 4 2 EX_SEND_BOTTOM 2 17 240 2 4 |
| 6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 52 2 4 5674 |
| 5 . 6 7 3 2 EX_HASH_GRBY 2 6 3,392 1 4 0|0|0 |
| 4 . 5 6 2 2 EX_SPLIT_TOP 2 9 52 100 4 |
| 3 . 4 5 2 2 EX_SEND_TOP 4 18 1,938 100 4 |
| 2 . 3 4 2 3 EX_SEND_BOTTOM 4 26 395 100 4 |
| 1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 8 80 100 4 8565 |
| . . 1 2 1 3 EX_TRAF_KEY_SELECT 2 4 8,090 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 MXID11000011701212378219753251307000000000206U3333300_336_S1 ACCUMULATED; |
| Qid MXID11000011701212378219753251307000000000206U3333300_336_S1 |
| Compile Start Time 2017/11/23 17:56:56.513528 |
| Compile End Time 2017/11/23 17:56:56.575220 |
| Compile Elapsed Time 0:00:00.061692 |
| Execute Start Time 2017/11/23 17:57:00.313805 |
| Execute End Time 2017/11/23 17:57:00.341117 |
| Execute Elapsed Time 0:00:00.027312 |
| State CLOSE |
| Rows Affected 0 |
| SQL Error Code 100 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| 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/11/23 17:57:00.337861 |
| 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.027312 secs |
| Max. Execute Time 0.027312 secs |
| Avg. Execute Time 0.027312 secs |
| Stats Collection Type OPERATOR_STATS |
| Accessed Rows 4 |
| Used Rows 4 |
| SE IOs 4 |
| SE IO Bytes 176 |
| SE IO MAX Time 9,595 |
| SQL Process Busy Time 15,922 |
| UDR Process Busy Time 0 |
| SQL Space Allocated 896 KB |
| SQL Space Used 766 KB |
| SQL Heap Allocated 1,032 KB |
| SQL Heap Used 913 KB |
| SQL Heap WM 11,175 KB |
| Processes Created 0 |
| Process Create Time 0 |
| Request Message Count 28 |
| Request Message Bytes 40,016 |
| Reply Message Count 15 |
| Reply Message Bytes 42,528 |
| BMO Space Buffer Size 256 |
| BMO Space Buffer Count 0 |
| BMO Interim Row Count 0 |
| Scr. Overflow Mode DISK |
| Scr. File Count 0 |
| Scr. IO Size 0 |
| Scr. Read Count 0 |
| Scr. Write Count 0 |
| Scr. IO Max Time 0 |
| Sort TopN -1 |
| |
| --- SQL operation complete. |
| >>get statistics for QID MXID11000011701212378219753251307000000000206U3333300_336_S1 ACCUMULATED; |
| Qid MXID11000011701212378219753251307000000000206U3333300_336_S1 |
| Compile Start Time 2017/11/23 17:56:56.513528 |
| Compile End Time 2017/11/23 17:56:56.575220 |
| Compile Elapsed Time 0:00:00.061692 |
| Execute Start Time 2017/11/23 17:57:00.313805 |
| Execute End Time 2017/11/23 17:57:00.341117 |
| Execute Elapsed Time 0:00:00.027312 |
| State CLOSE |
| Rows Affected 0 |
| SQL Error Code 100 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| 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/11/23 17:57:00.337861 |
| 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.027312 secs |
| Max. Execute Time 0.027312 secs |
| Avg. Execute Time 0.027312 secs |
| Stats Collection Type OPERATOR_STATS |
| Accessed Rows 4 |
| Used Rows 4 |
| SE IOs 4 |
| SE IO Bytes 176 |
| SE IO MAX Time 9,595 |
| SQL Process Busy Time 15,922 |
| UDR Process Busy Time 0 |
| SQL Space Allocated 896 KB |
| SQL Space Used 766 KB |
| SQL Heap Allocated 1,032 KB |
| SQL Heap Used 913 KB |
| SQL Heap WM 11,175 KB |
| Processes Created 0 |
| Process Create Time 0 |
| Request Message Count 28 |
| Request Message Bytes 40,016 |
| Reply Message Count 15 |
| Reply Message Bytes 42,528 |
| BMO Space Buffer Size 256 |
| BMO Space Buffer Count 0 |
| BMO Interim Row Count 0 |
| Scr. Overflow Mode DISK |
| Scr. File Count 0 |
| Scr. IO Size 0 |
| Scr. Read Count 0 |
| Scr. Write Count 0 |
| Scr. IO Max Time 0 |
| Sort TopN -1 |
| |
| --- SQL operation complete. |
| >>log; |
| >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ; |
| |
| --- SQL operation complete. |
| >>display statistics for QID MXID11000011701212378219753251307000000000206U3333300_336_S1 PERTABLE; |
| Qid MXID11000011701212378219753251307000000000206U3333300_336_S1 |
| Compile Start Time 2017/11/23 17:56:56.513528 |
| Compile End Time 2017/11/23 17:56:56.575220 |
| Compile Elapsed Time 0:00:00.061692 |
| Execute Start Time 2017/11/23 17:57:00.313805 |
| Execute End Time 2017/11/23 17:57:00.341117 |
| Execute Elapsed Time 0:00:00.027312 |
| State CLOSE |
| Rows Affected 0 |
| SQL Error Code 100 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| 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/11/23 17:57:00.337861 |
| 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.027312 secs |
| Max. Execute Time 0.027312 secs |
| Avg. Execute Time 0.027312 secs |
| Stats Collection Type OPERATOR_STATS |
| SQL Process Busy Time 15,922 |
| UDR Process Busy Time 0 |
| SQL Space Allocated 896 KB |
| SQL Space Used 766 KB |
| SQL Heap Allocated 1,032 KB |
| SQL Heap Used 913 KB |
| SQL Heap WM 11,175 KB |
| Processes Created 0 |
| Process Create Time 0 |
| Request Message Count 28 |
| Request Message Bytes 40,016 |
| Reply Message Count 15 |
| Reply Message Bytes 42,528 |
| BMO Space Buffer Size 256 |
| BMO Space Buffer Count 0 |
| BMO Interim Row Count 0 |
| Scr. Overflow Mode DISK |
| Scr. File Count 0 |
| Scr. IO Size 0 |
| Scr. Read Count 0 |
| Scr. Write Count 0 |
| 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 |
| 1 2 TRAFODION.SCH.TSTAT |
| 0 4 100 4 4 0 17,013 9,595 |
| |
| --- SQL operation complete. |
| >>get statistics for QID MXID11000011701212378219753251307000000000206U3333300_336_S1 PERTABLE; |
| Qid MXID11000011701212378219753251307000000000206U3333300_336_S1 |
| Compile Start Time 2017/11/23 17:56:56.513528 |
| Compile End Time 2017/11/23 17:56:56.575220 |
| Compile Elapsed Time 0:00:00.061692 |
| Execute Start Time 2017/11/23 17:57:00.313805 |
| Execute End Time 2017/11/23 17:57:00.341117 |
| Execute Elapsed Time 0:00:00.027312 |
| State CLOSE |
| Rows Affected 0 |
| SQL Error Code 100 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| 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/11/23 17:57:00.337861 |
| 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.027312 secs |
| Max. Execute Time 0.027312 secs |
| Avg. Execute Time 0.027312 secs |
| Stats Collection Type OPERATOR_STATS |
| SQL Process Busy Time 15,922 |
| UDR Process Busy Time 0 |
| SQL Space Allocated 896 KB |
| SQL Space Used 766 KB |
| SQL Heap Allocated 1,032 KB |
| SQL Heap Used 913 KB |
| SQL Heap WM 11,175 KB |
| Processes Created 0 |
| Process Create Time 0 |
| Request Message Count 28 |
| Request Message Bytes 40,016 |
| Reply Message Count 15 |
| Reply Message Bytes 42,528 |
| BMO Space Buffer Size 256 |
| BMO Space Buffer Count 0 |
| BMO Interim Row Count 0 |
| Scr. Overflow Mode DISK |
| Scr. File Count 0 |
| Scr. IO Size 0 |
| Scr. Read Count 0 |
| Scr. Write Count 0 |
| 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 |
| 1 2 TRAFODION.SCH.TSTAT |
| 0 4 100 4 4 0 17,013 9,595 |
| |
| --- SQL operation complete. |
| >>log; |
| >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ; |
| |
| --- SQL operation complete. |
| >>display statistics for QID MXID11000011701212378219753251307000000000206U3333300_336_S1 PROGRESS; |
| Qid MXID11000011701212378219753251307000000000206U3333300_336_S1 |
| Compile Start Time 2017/11/23 17:56:56.513528 |
| Compile End Time 2017/11/23 17:56:56.575220 |
| Compile Elapsed Time 0:00:00.061692 |
| Execute Start Time 2017/11/23 17:57:00.313805 |
| Execute End Time 2017/11/23 17:57:00.341117 |
| Execute Elapsed Time 0:00:00.027312 |
| State CLOSE |
| Rows Affected 0 |
| SQL Error Code 100 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| 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/11/23 17:57:00.337861 |
| 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.027312 secs |
| Max. Execute Time 0.027312 secs |
| Avg. Execute Time 0.027312 secs |
| Stats Collection Type OPERATOR_STATS |
| SQL Process Busy Time 15,922 |
| SQL Space Allocated 896 KB |
| SQL Space Used 766 KB |
| SQL Heap Allocated 1,032 KB |
| SQL Heap Used 913 KB |
| SQL Heap WM 11,175 KB |
| Processes Created 0 |
| Process Create Time 0 |
| Request Message Count 28 |
| Request Message Bytes 40,016 |
| Reply Message Count 15 |
| Reply Message Bytes 42,528 |
| |
| Id DOP Table Name |
| 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 17,013 9,595 |
| |
| Id TDBName Mode DOP TopN BMOPhase InterimRowCount CPUTime |
| BMOHeapUsed BMOHeapAllocated BMOHeapWM EstMemory BMOSpaceBufSz BMOSpaceBufCnt |
| ScrFileCnt ScrIOSize ScrIORead ScrIOWritten ScrIOTime ScrIOMaxTime |
| 6 EX_HASH_GRBY DISK 2 -1 READ_ROWS 0 3,392 |
| 4 1,024 7,6870.07 256 0 |
| 0 -1 0 0 0 0 |
| |
| --- SQL operation complete. |
| >>get statistics for QID MXID11000011701212378219753251307000000000206U3333300_336_S1 PROGRESS; |
| Qid MXID11000011701212378219753251307000000000206U3333300_336_S1 |
| Compile Start Time 2017/11/23 17:56:56.513528 |
| Compile End Time 2017/11/23 17:56:56.575220 |
| Compile Elapsed Time 0:00:00.061692 |
| Execute Start Time 2017/11/23 17:57:00.313805 |
| Execute End Time 2017/11/23 17:57:00.341117 |
| Execute Elapsed Time 0:00:00.027312 |
| State CLOSE |
| Rows Affected 0 |
| SQL Error Code 100 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| 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/11/23 17:57:00.337861 |
| 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.027312 secs |
| Max. Execute Time 0.027312 secs |
| Avg. Execute Time 0.027312 secs |
| Stats Collection Type OPERATOR_STATS |
| SQL Process Busy Time 15,922 |
| SQL Space Allocated 896 KB |
| SQL Space Used 766 KB |
| SQL Heap Allocated 1,032 KB |
| SQL Heap Used 913 KB |
| SQL Heap WM 11,175 KB |
| Processes Created 0 |
| Process Create Time 0 |
| Request Message Count 28 |
| Request Message Bytes 40,016 |
| Reply Message Count 15 |
| Reply Message Bytes 42,528 |
| |
| Id DOP Table Name |
| 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 17,013 9,595 |
| |
| Id TDBName Mode DOP TopN BMOPhase InterimRowCount CPUTime |
| BMOHeapUsed BMOHeapAllocated BMOHeapWM EstMemory BMOSpaceBufSz BMOSpaceBufCnt |
| ScrFileCnt ScrIOSize ScrIORead ScrIOWritten ScrIOTime ScrIOMaxTime |
| 6 EX_HASH_GRBY DISK 2 -1 READ_ROWS 0 3,392 |
| 4 1,024 7,6870.07 256 0 |
| 0 -1 0 0 0 0 |
| |
| --- SQL operation complete. |
| >>log; |
| >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ; |
| |
| --- SQL operation complete. |
| >>display statistics for QID MXID11000011701212378219753251307000000000206U3333300_336_S1 DEFAULT; |
| Qid MXID11000011701212378219753251307000000000206U3333300_336_S1 |
| Compile Start Time 2017/11/23 17:56:56.513528 |
| Compile End Time 2017/11/23 17:56:56.575220 |
| Compile Elapsed Time 0:00:00.061692 |
| Execute Start Time 2017/11/23 17:57:00.313805 |
| Execute End Time 2017/11/23 17:57:00.341117 |
| Execute Elapsed Time 0:00:00.027312 |
| State CLOSE |
| Rows Affected 0 |
| SQL Error Code 100 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| 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/11/23 17:57:00.337861 |
| 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.027312 secs |
| Max. Execute Time 0.027312 secs |
| Avg. Execute Time 0.027312 secs |
| Stats Collection Type OPERATOR_STATS |
| |
| LC RC Id PaId ExId Frag TDBName DOP Dispatches OperCPUTime EstRowsUsed ActRowsUsed Details |
| |
| 10 . 11 . 5 0 EX_ROOT 1 5 16 0 4 1683 |
| 9 . 10 11 4 0 EX_SPLIT_TOP 1 5 46 2 4 |
| 8 . 9 10 4 0 EX_SEND_TOP 2 10 1,621 2 4 |
| 7 . 8 9 4 2 EX_SEND_BOTTOM 2 17 240 2 4 |
| 6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 52 2 4 5674 |
| 5 . 6 7 3 2 EX_HASH_GRBY 2 6 3,392 1 4 0|0|0 |
| 4 . 5 6 2 2 EX_SPLIT_TOP 2 9 52 100 4 |
| 3 . 4 5 2 2 EX_SEND_TOP 4 18 1,938 100 4 |
| 2 . 3 4 2 3 EX_SEND_BOTTOM 4 26 395 100 4 |
| 1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 8 80 100 4 8565 |
| . . 1 2 1 3 EX_TRAF_KEY_SELECT 2 4 8,090 100 4 TRAFODION.SCH.TSTAT|4|176 |
| |
| --- SQL operation complete. |
| >>get statistics for QID MXID11000011701212378219753251307000000000206U3333300_336_S1 DEFAULT; |
| Qid MXID11000011701212378219753251307000000000206U3333300_336_S1 |
| Compile Start Time 2017/11/23 17:56:56.513528 |
| Compile End Time 2017/11/23 17:56:56.575220 |
| Compile Elapsed Time 0:00:00.061692 |
| Execute Start Time 2017/11/23 17:57:00.313805 |
| Execute End Time 2017/11/23 17:57:00.341117 |
| Execute Elapsed Time 0:00:00.027312 |
| State CLOSE |
| Rows Affected 0 |
| SQL Error Code 100 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| 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/11/23 17:57:00.337861 |
| 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.027312 secs |
| Max. Execute Time 0.027312 secs |
| Avg. Execute Time 0.027312 secs |
| Stats Collection Type OPERATOR_STATS |
| |
| LC RC Id PaId ExId Frag TDBName DOP Dispatches OperCPUTime EstRowsUsed ActRowsUsed Details |
| |
| 10 . 11 . 5 0 EX_ROOT 1 5 16 0 4 1683 |
| 9 . 10 11 4 0 EX_SPLIT_TOP 1 5 46 2 4 |
| 8 . 9 10 4 0 EX_SEND_TOP 2 10 1,621 2 4 |
| 7 . 8 9 4 2 EX_SEND_BOTTOM 2 17 240 2 4 |
| 6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 52 2 4 5674 |
| 5 . 6 7 3 2 EX_HASH_GRBY 2 6 3,392 1 4 0|0|0 |
| 4 . 5 6 2 2 EX_SPLIT_TOP 2 9 52 100 4 |
| 3 . 4 5 2 2 EX_SEND_TOP 4 18 1,938 100 4 |
| 2 . 3 4 2 3 EX_SEND_BOTTOM 4 26 395 100 4 |
| 1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 8 80 100 4 8565 |
| . . 1 2 1 3 EX_TRAF_KEY_SELECT 2 4 8,090 100 4 TRAFODION.SCH.TSTAT|4|176 |
| |
| --- SQL operation complete. |
| >>log; |
| >>get statistics for qid current ; |
| Qid MXID11000011701212378219753251307000000000206U3333300_336_S1 |
| Compile Start Time 2017/11/23 17:56:56.513528 |
| Compile End Time 2017/11/23 17:56:56.575220 |
| Compile Elapsed Time 0:00:00.061692 |
| Execute Start Time 2017/11/23 17:57:00.313805 |
| Execute End Time 2017/11/23 17:57:00.341117 |
| Execute Elapsed Time 0:00:00.027312 |
| State CLOSE |
| Rows Affected 0 |
| SQL Error Code 100 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| 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/11/23 17:57:00.337861 |
| 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.027312 secs |
| Max. Execute Time 0.027312 secs |
| Avg. Execute Time 0.027312 secs |
| Stats Collection Type OPERATOR_STATS |
| |
| LC RC Id PaId ExId Frag TDBName DOP Dispatches OperCPUTime EstRowsUsed ActRowsUsed Details |
| |
| 10 . 11 . 5 0 EX_ROOT 1 5 16 0 4 1683 |
| 9 . 10 11 4 0 EX_SPLIT_TOP 1 5 46 2 4 |
| 8 . 9 10 4 0 EX_SEND_TOP 2 10 1,621 2 4 |
| 7 . 8 9 4 2 EX_SEND_BOTTOM 2 7 240 2 4 |
| 6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 5 52 2 4 5674 |
| 5 . 6 7 3 2 EX_HASH_GRBY 2 6 3,392 1 4 0|0|0 |
| 4 . 5 6 2 2 EX_SPLIT_TOP 2 9 52 100 4 |
| 3 . 4 5 2 2 EX_SEND_TOP 4 18 1,938 100 4 |
| 2 . 3 4 2 3 EX_SEND_BOTTOM 4 10 395 100 4 |
| 1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 6 80 100 4 8565 |
| . . 1 2 1 3 EX_TRAF_KEY_SELECT 2 4 8,090 100 4 TRAFODION.SCH.TSTAT|4|176 |
| |
| --- SQL operation complete. |
| >>get statistics for qid current accumulated ; |
| Qid MXID11000011701212378219753251307000000000206U3333300_336_S1 |
| Compile Start Time 2017/11/23 17:56:56.513528 |
| Compile End Time 2017/11/23 17:56:56.575220 |
| Compile Elapsed Time 0:00:00.061692 |
| Execute Start Time 2017/11/23 17:57:00.313805 |
| Execute End Time 2017/11/23 17:57:00.341117 |
| Execute Elapsed Time 0:00:00.027312 |
| State CLOSE |
| Rows Affected 0 |
| SQL Error Code 100 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| 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/11/23 17:57:00.337861 |
| 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.027312 secs |
| Max. Execute Time 0.027312 secs |
| Avg. Execute Time 0.027312 secs |
| Stats Collection Type OPERATOR_STATS |
| Accessed Rows 4 |
| Used Rows 4 |
| SE IOs 4 |
| SE IO Bytes 176 |
| SE IO MAX Time 9,595 |
| SQL Process Busy Time 15,922 |
| UDR Process Busy Time 0 |
| SQL Space Allocated 896 KB |
| SQL Space Used 766 KB |
| SQL Heap Allocated 1,032 KB |
| SQL Heap Used 913 KB |
| SQL Heap WM 11,175 KB |
| Processes Created 0 |
| Process Create Time 0 |
| Request Message Count 28 |
| Request Message Bytes 40,016 |
| Reply Message Count 15 |
| Reply Message Bytes 42,528 |
| BMO Space Buffer Size 256 |
| BMO Space Buffer Count 0 |
| BMO Interim Row Count 0 |
| Scr. Overflow Mode DISK |
| Scr. File Count 0 |
| Scr. IO Size 0 |
| Scr. Read Count 0 |
| Scr. Write Count 0 |
| Scr. IO Max Time 0 |
| Sort TopN -1 |
| |
| --- SQL operation complete. |
| >>get statistics for qid current pertable ; |
| Qid MXID11000011701212378219753251307000000000206U3333300_336_S1 |
| Compile Start Time 2017/11/23 17:56:56.513528 |
| Compile End Time 2017/11/23 17:56:56.575220 |
| Compile Elapsed Time 0:00:00.061692 |
| Execute Start Time 2017/11/23 17:57:00.313805 |
| Execute End Time 2017/11/23 17:57:00.341117 |
| Execute Elapsed Time 0:00:00.027312 |
| State CLOSE |
| Rows Affected 0 |
| SQL Error Code 100 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| 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/11/23 17:57:00.337861 |
| 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.027312 secs |
| Max. Execute Time 0.027312 secs |
| Avg. Execute Time 0.027312 secs |
| Stats Collection Type OPERATOR_STATS |
| SQL Process Busy Time 15,922 |
| UDR Process Busy Time 0 |
| SQL Space Allocated 896 KB |
| SQL Space Used 766 KB |
| SQL Heap Allocated 1,032 KB |
| SQL Heap Used 913 KB |
| SQL Heap WM 11,175 KB |
| Processes Created 0 |
| Process Create Time 0 |
| Request Message Count 28 |
| Request Message Bytes 40,016 |
| Reply Message Count 15 |
| Reply Message Bytes 42,528 |
| BMO Space Buffer Size 256 |
| BMO Space Buffer Count 0 |
| BMO Interim Row Count 0 |
| Scr. Overflow Mode DISK |
| Scr. File Count 0 |
| Scr. IO Size 0 |
| Scr. Read Count 0 |
| Scr. Write Count 0 |
| 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 |
| 1 2 TRAFODION.SCH.TSTAT |
| 0 4 100 4 4 0 17,013 9,595 |
| |
| --- SQL operation complete. |
| >>get statistics for qid current progress ; |
| Qid MXID11000011701212378219753251307000000000206U3333300_336_S1 |
| Compile Start Time 2017/11/23 17:56:56.513528 |
| Compile End Time 2017/11/23 17:56:56.575220 |
| Compile Elapsed Time 0:00:00.061692 |
| Execute Start Time 2017/11/23 17:57:00.313805 |
| Execute End Time 2017/11/23 17:57:00.341117 |
| Execute Elapsed Time 0:00:00.027312 |
| State CLOSE |
| Rows Affected 0 |
| SQL Error Code 100 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| 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/11/23 17:57:00.337861 |
| 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.027312 secs |
| Max. Execute Time 0.027312 secs |
| Avg. Execute Time 0.027312 secs |
| Stats Collection Type OPERATOR_STATS |
| SQL Process Busy Time 15,922 |
| SQL Space Allocated 896 KB |
| SQL Space Used 766 KB |
| SQL Heap Allocated 1,032 KB |
| SQL Heap Used 913 KB |
| SQL Heap WM 11,175 KB |
| Processes Created 0 |
| Process Create Time 0 |
| Request Message Count 28 |
| Request Message Bytes 40,016 |
| Reply Message Count 15 |
| Reply Message Bytes 42,528 |
| |
| Id DOP Table Name |
| 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 17,013 9,595 |
| |
| Id TDBName Mode DOP TopN BMOPhase InterimRowCount CPUTime |
| BMOHeapUsed BMOHeapAllocated BMOHeapWM EstMemory BMOSpaceBufSz BMOSpaceBufCnt |
| ScrFileCnt ScrIOSize ScrIORead ScrIOWritten ScrIOTime ScrIOMaxTime |
| 6 EX_HASH_GRBY DISK 2 -1 READ_ROWS 0 3,392 |
| 4 1,024 7,6870.07 256 0 |
| 0 -1 0 0 0 0 |
| |
| --- SQL operation complete. |
| >>get statistics for qid current progress, options 'sl' ; |
| Qid MXID11000011701212378219753251307000000000206U3333300_336_S1 |
| Compile Start Time 2017/11/23 17:56:56.513528 |
| Compile End Time 2017/11/23 17:56:56.575220 |
| Compile Elapsed Time 0:00:00.061692 |
| Execute Start Time 2017/11/23 17:57:00.313805 |
| Execute End Time 2017/11/23 17:57:00.341117 |
| Execute Elapsed Time 0:00:00.027312 |
| State CLOSE |
| Rows Affected 0 |
| SQL Error Code 100 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| 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/11/23 17:57:00.337861 |
| 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.027312 secs |
| Max. Execute Time 0.027312 secs |
| Avg. Execute Time 0.027312 secs |
| Stats Collection Type OPERATOR_STATS |
| SQL Process Busy Time 15,922 |
| SQL Space Allocated 896 KB |
| SQL Space Used 766 KB |
| SQL Heap Allocated 1,032 KB |
| SQL Heap Used 913 KB |
| SQL Heap WM 11,175 KB |
| Processes Created 0 |
| Process Create Time 0 |
| Request Message Count 28 |
| Request Message Bytes 40,016 |
| Reply Message Count 15 |
| Reply Message Bytes 42,528 |
| |
| Id DOP EstRowsAccess ActRowsAccess EstRowUsed ActRowsUsed SE_IOs SE_IO_KBytes SE_IO_SumTime SE_IO_MaxTime TableName |
| 1 2 0 4 100 4 4 0 17,013 9,595 TRAFODION.SCH.TSTAT |
| |
| Id TDBName Mode DOP TopN BMOPhase InterimRowCount CPUTime BMOHeapUsed BMOHeapAllocated BMOHeapWM EstMemory BMOSpaceBufSz BMOSpaceBufCnt FileCnt ScrIOSize ScrIORead ScrIOWritten ScrIOTime ScrIOMaxTime |
| 6 EX_HASH_GRBY DISK 2 -1 READ_ROWS 0 3,392 4 1,024 7,6870.07 256 0 0 -1 0 0 0 0 |
| |
| --- SQL operation complete. |
| >>get statistics for qid current default ; |
| Qid MXID11000011701212378219753251307000000000206U3333300_336_S1 |
| Compile Start Time 2017/11/23 17:56:56.513528 |
| Compile End Time 2017/11/23 17:56:56.575220 |
| Compile Elapsed Time 0:00:00.061692 |
| Execute Start Time 2017/11/23 17:57:00.313805 |
| Execute End Time 2017/11/23 17:57:00.341117 |
| Execute Elapsed Time 0:00:00.027312 |
| State CLOSE |
| Rows Affected 0 |
| SQL Error Code 100 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| 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/11/23 17:57:00.337861 |
| 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.027312 secs |
| Max. Execute Time 0.027312 secs |
| Avg. Execute Time 0.027312 secs |
| Stats Collection Type OPERATOR_STATS |
| |
| LC RC Id PaId ExId Frag TDBName DOP Dispatches OperCPUTime EstRowsUsed ActRowsUsed Details |
| |
| 10 . 11 . 5 0 EX_ROOT 1 5 16 0 4 1683 |
| 9 . 10 11 4 0 EX_SPLIT_TOP 1 5 46 2 4 |
| 8 . 9 10 4 0 EX_SEND_TOP 2 10 1,621 2 4 |
| 7 . 8 9 4 2 EX_SEND_BOTTOM 2 7 240 2 4 |
| 6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 5 52 2 4 5674 |
| 5 . 6 7 3 2 EX_HASH_GRBY 2 6 3,392 1 4 0|0|0 |
| 4 . 5 6 2 2 EX_SPLIT_TOP 2 9 52 100 4 |
| 3 . 4 5 2 2 EX_SEND_TOP 4 18 1,938 100 4 |
| 2 . 3 4 2 3 EX_SEND_BOTTOM 4 10 395 100 4 |
| 1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 6 80 100 4 8565 |
| . . 1 2 1 3 EX_TRAF_KEY_SELECT 2 4 8,090 100 4 TRAFODION.SCH.TSTAT|4|176 |
| |
| --- SQL operation complete. |
| >>set session default statistics_view_type 'default' ; |
| |
| --- SQL operation complete. |
| >>get statistics for qid current ; |
| Qid MXID11000011701212378219753251307000000000206U3333300_336_S1 |
| Compile Start Time 2017/11/23 17:56:56.513528 |
| Compile End Time 2017/11/23 17:56:56.575220 |
| Compile Elapsed Time 0:00:00.061692 |
| Execute Start Time 2017/11/23 17:57:00.313805 |
| Execute End Time 2017/11/23 17:57:00.341117 |
| Execute Elapsed Time 0:00:00.027312 |
| State CLOSE |
| Rows Affected 0 |
| SQL Error Code 100 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| 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/11/23 17:57:00.337861 |
| 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.027312 secs |
| Max. Execute Time 0.027312 secs |
| Avg. Execute Time 0.027312 secs |
| Stats Collection Type OPERATOR_STATS |
| |
| LC RC Id PaId ExId Frag TDBName DOP Dispatches OperCPUTime EstRowsUsed ActRowsUsed Details |
| |
| 10 . 11 . 5 0 EX_ROOT 1 5 16 0 4 1683 |
| 9 . 10 11 4 0 EX_SPLIT_TOP 1 5 46 2 4 |
| 8 . 9 10 4 0 EX_SEND_TOP 2 10 1,621 2 4 |
| 7 . 8 9 4 2 EX_SEND_BOTTOM 2 7 240 2 4 |
| 6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 5 52 2 4 5674 |
| 5 . 6 7 3 2 EX_HASH_GRBY 2 6 3,392 1 4 0|0|0 |
| 4 . 5 6 2 2 EX_SPLIT_TOP 2 9 52 100 4 |
| 3 . 4 5 2 2 EX_SEND_TOP 4 18 1,938 100 4 |
| 2 . 3 4 2 3 EX_SEND_BOTTOM 4 10 395 100 4 |
| 1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 6 80 100 4 8565 |
| . . 1 2 1 3 EX_TRAF_KEY_SELECT 2 4 8,090 100 4 TRAFODION.SCH.TSTAT|4|176 |
| |
| --- SQL operation complete. |
| >>set session default statistics_view_type 'accumulated' ; |
| |
| --- SQL operation complete. |
| >>get statistics for qid current ; |
| Qid MXID11000011701212378219753251307000000000206U3333300_336_S1 |
| Compile Start Time 2017/11/23 17:56:56.513528 |
| Compile End Time 2017/11/23 17:56:56.575220 |
| Compile Elapsed Time 0:00:00.061692 |
| Execute Start Time 2017/11/23 17:57:00.313805 |
| Execute End Time 2017/11/23 17:57:00.341117 |
| Execute Elapsed Time 0:00:00.027312 |
| State CLOSE |
| Rows Affected 0 |
| SQL Error Code 100 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| 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/11/23 17:57:00.337861 |
| 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.027312 secs |
| Max. Execute Time 0.027312 secs |
| Avg. Execute Time 0.027312 secs |
| Stats Collection Type OPERATOR_STATS |
| Accessed Rows 4 |
| Used Rows 4 |
| SE IOs 4 |
| SE IO Bytes 176 |
| SE IO MAX Time 9,595 |
| SQL Process Busy Time 15,922 |
| UDR Process Busy Time 0 |
| SQL Space Allocated 896 KB |
| SQL Space Used 766 KB |
| SQL Heap Allocated 1,032 KB |
| SQL Heap Used 913 KB |
| SQL Heap WM 11,175 KB |
| Processes Created 0 |
| Process Create Time 0 |
| Request Message Count 28 |
| Request Message Bytes 40,016 |
| Reply Message Count 15 |
| Reply Message Bytes 42,528 |
| BMO Space Buffer Size 256 |
| BMO Space Buffer Count 0 |
| BMO Interim Row Count 0 |
| Scr. Overflow Mode DISK |
| Scr. File Count 0 |
| Scr. IO Size 0 |
| Scr. Read Count 0 |
| Scr. Write Count 0 |
| Scr. IO Max Time 0 |
| Sort TopN -1 |
| |
| --- SQL operation complete. |
| >>set session default statistics_view_type 'pertable' ; |
| |
| --- SQL operation complete. |
| >>get statistics for qid current ; |
| Qid MXID11000011701212378219753251307000000000206U3333300_336_S1 |
| Compile Start Time 2017/11/23 17:56:56.513528 |
| Compile End Time 2017/11/23 17:56:56.575220 |
| Compile Elapsed Time 0:00:00.061692 |
| Execute Start Time 2017/11/23 17:57:00.313805 |
| Execute End Time 2017/11/23 17:57:00.341117 |
| Execute Elapsed Time 0:00:00.027312 |
| State CLOSE |
| Rows Affected 0 |
| SQL Error Code 100 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| 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/11/23 17:57:00.337861 |
| 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.027312 secs |
| Max. Execute Time 0.027312 secs |
| Avg. Execute Time 0.027312 secs |
| Stats Collection Type OPERATOR_STATS |
| SQL Process Busy Time 15,922 |
| UDR Process Busy Time 0 |
| SQL Space Allocated 896 KB |
| SQL Space Used 766 KB |
| SQL Heap Allocated 1,032 KB |
| SQL Heap Used 913 KB |
| SQL Heap WM 11,175 KB |
| Processes Created 0 |
| Process Create Time 0 |
| Request Message Count 28 |
| Request Message Bytes 40,016 |
| Reply Message Count 15 |
| Reply Message Bytes 42,528 |
| BMO Space Buffer Size 256 |
| BMO Space Buffer Count 0 |
| BMO Interim Row Count 0 |
| Scr. Overflow Mode DISK |
| Scr. File Count 0 |
| Scr. IO Size 0 |
| Scr. Read Count 0 |
| Scr. Write Count 0 |
| 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 |
| 1 2 TRAFODION.SCH.TSTAT |
| 0 4 100 4 4 0 17,013 9,595 |
| |
| --- SQL operation complete. |
| >>set session default statistics_view_type 'progress' ; |
| |
| --- SQL operation complete. |
| >>get statistics for qid current ; |
| Qid MXID11000011701212378219753251307000000000206U3333300_336_S1 |
| Compile Start Time 2017/11/23 17:56:56.513528 |
| Compile End Time 2017/11/23 17:56:56.575220 |
| Compile Elapsed Time 0:00:00.061692 |
| Execute Start Time 2017/11/23 17:57:00.313805 |
| Execute End Time 2017/11/23 17:57:00.341117 |
| Execute Elapsed Time 0:00:00.027312 |
| State CLOSE |
| Rows Affected 0 |
| SQL Error Code 100 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| 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/11/23 17:57:00.337861 |
| 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.027312 secs |
| Max. Execute Time 0.027312 secs |
| Avg. Execute Time 0.027312 secs |
| Stats Collection Type OPERATOR_STATS |
| SQL Process Busy Time 15,922 |
| SQL Space Allocated 896 KB |
| SQL Space Used 766 KB |
| SQL Heap Allocated 1,032 KB |
| SQL Heap Used 913 KB |
| SQL Heap WM 11,175 KB |
| Processes Created 0 |
| Process Create Time 0 |
| Request Message Count 28 |
| Request Message Bytes 40,016 |
| Reply Message Count 15 |
| Reply Message Bytes 42,528 |
| |
| Id DOP Table Name |
| 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 17,013 9,595 |
| |
| Id TDBName Mode DOP TopN BMOPhase InterimRowCount CPUTime |
| BMOHeapUsed BMOHeapAllocated BMOHeapWM EstMemory BMOSpaceBufSz BMOSpaceBufCnt |
| ScrFileCnt ScrIOSize ScrIORead ScrIOWritten ScrIOTime ScrIOMaxTime |
| 6 EX_HASH_GRBY DISK 2 -1 READ_ROWS 0 3,392 |
| 4 1,024 7,6870.07 256 0 |
| 0 -1 0 0 0 0 |
| |
| --- SQL operation complete. |
| >>set session default statistics_view_type 'pertable' ; |
| |
| --- SQL operation complete. |
| >> |
| >>-- TEST for set session settings |
| >>set statistics pertable ; |
| >>execute s1 ; |
| |
| D |
| ----------- |
| |
| 12 |
| 11 |
| 21 |
| 22 |
| |
| --- 4 row(s) selected. |
| Qid MXID11000011701212378219753251307000000000206U3333300_336_S1 |
| Compile Start Time 2017/11/23 17:56:56.513528 |
| Compile End Time 2017/11/23 17:56:56.575220 |
| Compile Elapsed Time 0:00:00.061692 |
| Execute Start Time 2017/11/23 17:57:19.265825 |
| Execute End Time 2017/11/23 17:57:19.285723 |
| Execute Elapsed Time 0:00:00.019898 |
| State CLOSE |
| Rows Affected 0 |
| SQL Error Code 100 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| Number of SQL Processes 1 |
| Number of Cpus 0 |
| Transaction Id -1 |
| Source String select distinct d from tstat ; |
| SQL Source Length 30 |
| Rows Returned 4 |
| First Row Returned Time 2017/11/23 17:57:19.281560 |
| 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 2 |
| Min. Execute Time 0.019898 secs |
| Max. Execute Time 0.027312 secs |
| Avg. Execute Time 0.023605 secs |
| Stats Collection Type OPERATOR_STATS |
| SQL Process Busy Time 11,337 |
| UDR Process Busy Time 0 |
| SQL Space Allocated 896 KB |
| SQL Space Used 773 KB |
| SQL Heap Allocated 1,032 KB |
| SQL Heap Used 913 KB |
| SQL Heap WM 11,175 KB |
| Processes Created 0 |
| Process Create Time 0 |
| Request Message Count 18 |
| Request Message Bytes 5,856 |
| Reply Message Count 6 |
| Reply Message Bytes 45,520 |
| BMO Space Buffer Size 256 |
| BMO Space Buffer Count 2 |
| BMO Interim Row Count 0 |
| Scr. Overflow Mode DISK |
| Scr. File Count 0 |
| Scr. IO Size 0 |
| Scr. Read Count 0 |
| Scr. Write Count 0 |
| Scr. IO Max Time 0 |
| Sort TopN -1 |
| |
| Id DOP EstRowsAccess ActRowsAccess EstRowUsed ActRowsUsed SE_IOs SE_IO_KBytes SE_IO_SumTime SE_IO_MaxTime TableName |
| 1 2 0 4 100 4 4 0 11,553 5,830 TRAFODION.SCH.TSTAT |
| |
| --- SQL operation complete. |
| >>set statistics progress ; |
| >>execute s1 ; |
| |
| D |
| ----------- |
| |
| 12 |
| 11 |
| 21 |
| 22 |
| |
| --- 4 row(s) selected. |
| Qid MXID11000011701212378219753251307000000000206U3333300_336_S1 |
| Compile Start Time 2017/11/23 17:56:56.513528 |
| Compile End Time 2017/11/23 17:56:56.575220 |
| Compile Elapsed Time 0:00:00.061692 |
| Execute Start Time 2017/11/23 17:57:19.294814 |
| Execute End Time 2017/11/23 17:57:19.304072 |
| Execute Elapsed Time 0:00:00.009258 |
| State CLOSE |
| Rows Affected 0 |
| SQL Error Code 100 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| Number of SQL Processes 1 |
| Number of Cpus 0 |
| Transaction Id -1 |
| Source String select distinct d from tstat ; |
| SQL Source Length 30 |
| Rows Returned 4 |
| First Row Returned Time 2017/11/23 17:57:19.302006 |
| 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 3 |
| Min. Execute Time 0.009258 secs |
| Max. Execute Time 0.027312 secs |
| Avg. Execute Time 0.018822 secs |
| Stats Collection Type OPERATOR_STATS |
| SQL Process Busy Time 5,357 |
| SQL Space Allocated 896 KB |
| SQL Space Used 774 KB |
| SQL Heap Allocated 1,032 KB |
| SQL Heap Used 913 KB |
| SQL Heap WM 11,175 KB |
| Processes Created 0 |
| Process Create Time 0 |
| Request Message Count 18 |
| Request Message Bytes 5,856 |
| Reply Message Count 6 |
| Reply Message Bytes 45,520 |
| |
| Id DOP EstRowsAccess ActRowsAccess EstRowUsed ActRowsUsed SE_IOs SE_IO_KBytes SE_IO_SumTime SE_IO_MaxTime TableName |
| 1 2 0 4 100 4 4 0 3,947 2,047 TRAFODION.SCH.TSTAT |
| |
| Id TDBName Mode DOP TopN BMOPhase InterimRowCount CPUTime BMOHeapUsed BMOHeapAllocated BMOHeapWM EstMemory BMOSpaceBufSz BMOSpaceBufCnt FileCnt ScrIOSize ScrIORead ScrIOWritten ScrIOTime ScrIOMaxTime |
| 6 EX_HASH_GRBY DISK 2 -1 READ_ROWS 0 2,280 4 1,024 7,6870.07 256 2 0 -1 0 0 0 0 |
| |
| --- SQL operation complete. |
| >>set statistics default ; |
| >>execute s1 ; |
| |
| D |
| ----------- |
| |
| 12 |
| 11 |
| 21 |
| 22 |
| |
| --- 4 row(s) selected. |
| Qid MXID11000011701212378219753251307000000000206U3333300_336_S1 |
| Compile Start Time 2017/11/23 17:56:56.513528 |
| Compile End Time 2017/11/23 17:56:56.575220 |
| Compile Elapsed Time 0:00:00.061692 |
| Execute Start Time 2017/11/23 17:57:19.313762 |
| Execute End Time 2017/11/23 17:57:19.324361 |
| Execute Elapsed Time 0:00:00.010599 |
| State CLOSE |
| Rows Affected 0 |
| SQL Error Code 100 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| Number of SQL Processes 1 |
| Number of Cpus 0 |
| Transaction Id -1 |
| Source String select distinct d from tstat ; |
| SQL Source Length 30 |
| Rows Returned 4 |
| First Row Returned Time 2017/11/23 17:57:19.321364 |
| 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 4 |
| Min. Execute Time 0.009258 secs |
| Max. Execute Time 0.027312 secs |
| Avg. Execute Time 0.016766 secs |
| Stats Collection Type OPERATOR_STATS |
| |
| LC RC Id PaId ExId Frag TDBName DOP Dispatches OperCPUTime EstRowsUsed ActRowsUsed Details |
| |
| 10 . 11 . 5 0 EX_ROOT 1 5 19 0 4 507 |
| 9 . 10 11 4 0 EX_SPLIT_TOP 1 5 24 2 4 |
| 8 . 9 10 4 0 EX_SEND_TOP 2 6 464 2 4 |
| 7 . 8 9 4 2 EX_SEND_BOTTOM 2 19 13 2 4 |
| 6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 25 2 4 2821 |
| 5 . 6 7 3 2 EX_HASH_GRBY 2 5 2,357 1 4 0|0|0 |
| 4 . 5 6 2 2 EX_SPLIT_TOP 2 8 35 100 4 |
| 3 . 4 5 2 2 EX_SEND_TOP 4 18 391 100 4 |
| 2 . 3 4 2 3 EX_SEND_BOTTOM 4 20 148 100 4 |
| 1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 6 34 100 4 2055 |
| . . 1 2 1 3 EX_TRAF_KEY_SELECT 2 2 1,873 100 4 TRAFODION.SCH.TSTAT|4|176 |
| |
| --- SQL operation complete. |
| >>set statistics all ; |
| >>execute s1 ; |
| |
| D |
| ----------- |
| |
| 12 |
| 11 |
| 21 |
| 22 |
| |
| --- 4 row(s) selected. |
| Qid MXID11000011701212378219753251307000000000206U3333300_336_S1 |
| Compile Start Time 2017/11/23 17:56:56.513528 |
| Compile End Time 2017/11/23 17:56:56.575220 |
| Compile Elapsed Time 0:00:00.061692 |
| Execute Start Time 2017/11/23 17:57:19.334122 |
| Execute End Time 2017/11/23 17:57:19.343143 |
| Execute Elapsed Time 0:00:00.009021 |
| State CLOSE |
| Rows Affected 0 |
| SQL Error Code 100 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| Number of SQL Processes 1 |
| Number of Cpus 0 |
| Transaction Id -1 |
| Source String select distinct d from tstat ; |
| SQL Source Length 30 |
| Rows Returned 4 |
| First Row Returned Time 2017/11/23 17:57:19.340938 |
| 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 5 |
| Min. Execute Time 0.009021 secs |
| Max. Execute Time 0.027312 secs |
| Avg. Execute Time 0.015217 secs |
| Stats Collection Type OPERATOR_STATS |
| SQL Process Busy Time 5,199 |
| SQL Space Allocated 896 KB |
| SQL Space Used 774 KB |
| SQL Heap Allocated 1,032 KB |
| SQL Heap Used 913 KB |
| SQL Heap WM 11,175 KB |
| Processes Created 0 |
| Process Create Time 0 |
| Request Message Count 18 |
| Request Message Bytes 5,856 |
| Reply Message Count 6 |
| Reply Message Bytes 45,520 |
| |
| Id DOP EstRowsAccess ActRowsAccess EstRowUsed ActRowsUsed SE_IOs SE_IO_KBytes SE_IO_SumTime SE_IO_MaxTime TableName |
| 1 2 0 4 100 4 4 0 5,946 2,997 TRAFODION.SCH.TSTAT |
| |
| Id TDBName Mode DOP TopN BMOPhase InterimRowCount CPUTime BMOHeapUsed BMOHeapAllocated BMOHeapWM EstMemory BMOSpaceBufSz BMOSpaceBufCnt FileCnt ScrIOSize ScrIORead ScrIOWritten ScrIOTime ScrIOMaxTime |
| 6 EX_HASH_GRBY DISK 2 -1 READ_ROWS 0 2,327 4 1,024 7,6870.07 256 2 0 -1 0 0 0 0 |
| |
| --- SQL operation complete. |
| Qid MXID11000011701212378219753251307000000000206U3333300_336_S1 |
| Compile Start Time 2017/11/23 17:56:56.513528 |
| Compile End Time 2017/11/23 17:56:56.575220 |
| Compile Elapsed Time 0:00:00.061692 |
| Execute Start Time 2017/11/23 17:57:19.334122 |
| Execute End Time 2017/11/23 17:57:19.343143 |
| Execute Elapsed Time 0:00:00.009021 |
| State CLOSE |
| Rows Affected 0 |
| SQL Error Code 100 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| Number of SQL Processes 1 |
| Number of Cpus 0 |
| Transaction Id -1 |
| Source String select distinct d from tstat ; |
| SQL Source Length 30 |
| Rows Returned 4 |
| First Row Returned Time 2017/11/23 17:57:19.340938 |
| 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 5 |
| Min. Execute Time 0.009021 secs |
| Max. Execute Time 0.027312 secs |
| Avg. Execute Time 0.015217 secs |
| Stats Collection Type OPERATOR_STATS |
| |
| LC RC Id PaId ExId Frag TDBName DOP Dispatches OperCPUTime EstRowsUsed ActRowsUsed Details |
| |
| 10 . 11 . 5 0 EX_ROOT 1 5 10 0 4 486 |
| 9 . 10 11 4 0 EX_SPLIT_TOP 1 5 34 2 4 |
| 8 . 9 10 4 0 EX_SEND_TOP 2 6 442 2 4 |
| 7 . 8 9 4 2 EX_SEND_BOTTOM 2 15 12 2 4 |
| 6 . 7 8 4 2 EX_SPLIT_BOTTOM 2 7 29 2 4 2796 |
| 5 . 6 7 3 2 EX_HASH_GRBY 2 5 2,327 1 4 0|0|0 |
| 4 . 5 6 2 2 EX_SPLIT_TOP 2 8 31 100 4 |
| 3 . 4 5 2 2 EX_SEND_TOP 4 18 397 100 4 |
| 2 . 3 4 2 3 EX_SEND_BOTTOM 4 15 137 100 4 |
| 1 . 2 3 2 3 EX_SPLIT_BOTTOM 2 7 27 100 4 1917 |
| . . 1 2 1 3 EX_TRAF_KEY_SELECT 2 2 1,753 100 4 TRAFODION.SCH.TSTAT|4|176 |
| |
| --- SQL operation complete. |
| >>set statistics off ; |
| >> |
| >>-- TEST for RMS Stats |
| >>get statistics for RMS 0 ; |
| Node name edev06.esgyn.local:0 |
| Node Id 0 |
| RMS Version 2511 |
| SSCP PID 29181 |
| SSCP Creation Timestamp 2017/11/23 16:54:13.933909 |
| SSMP PID 29245 |
| SSMP Creation Timestamp 2017/11/23 16:54:16.774836 |
| Source String Store Len 254 |
| Stats Heap Allocated 67,106,592 |
| Stats Heap Used 1,794,672 |
| Stats Heap High WM 1,971,088 |
| No.of Process Stats Heaps 9 |
| No.of Process Regd. 4 |
| No.of Query Fragments Regd. 9 |
| RMS Semaphore Owner -1 |
| No.of SSCPs Opened 2 |
| No.of SSCPs Open Deleted 0 |
| Last GC Time 2017/11/23 17:54:23.352792 |
| Queries GCed in Last Run 3 |
| Total Queries GCed 82 |
| SSMP Request Message Count 24,226 |
| SSMP Request Message Bytes 13,781,592 |
| SSMP Reply Message Count 24,225 |
| SSMP Reply Message Bytes 3,418,240 |
| SSCP Request Message Count 353 |
| SSCP Request Message Bytes 80,176 |
| SSCP Reply Message Count 353 |
| SSCP Reply Message Bytes 139,848 |
| RMS Stats Reset Timestamp 2017/11/23 16:54:16.511971 |
| No. Query Invalidation Keys 121 |
| Configured Pid Max 32768 |
| |
| |
| --- SQL operation complete. |
| >>-- get statistics for RMS all is not tested because it can filtering issues |
| >> |
| >>-- Misc tests to increase code coverage |
| >>control query shape cut; |
| |
| --- SQL operation complete. |
| >>select 'FUNKY_OPT_UNIQUE', count(*) from table(statistics(NULL,'CPU=0')); |
| |
| (EXPR) (EXPR) |
| ---------------- -------------------- |
| |
| FUNKY_OPT_UNIQUE 0 |
| |
| --- 1 row(s) selected. |
| >>select 'FUNKY_OPT_UNIQUE', count(*) from table(statistics(NULL,'CPU_OFFENDER=-1')); |
| |
| (EXPR) (EXPR) |
| ---------------- -------------------- |
| |
| FUNKY_OPT_UNIQUE 0 |
| |
| --- 1 row(s) selected. |
| >>-- Coverage for SscpNewIncomingConnectionStream::processCpuStatsReq |
| >>select 'FUNKY_OPT_UNIQUE', count(*) from table(statistics(NULL,'CPU_OFFENDER=-1')); |
| |
| (EXPR) (EXPR) |
| ---------------- -------------------- |
| |
| FUNKY_OPT_UNIQUE 0 |
| |
| --- 1 row(s) selected. |
| >>select 'FUNKY_OPT_UNIQUE', count(*) from table(statistics(NULL,'DISK_OFFENDER=-1')); |
| |
| (EXPR) (EXPR) |
| ---------------- -------------------- |
| |
| FUNKY_OPT_UNIQUE 0 |
| |
| --- 1 row(s) selected. |
| >>log; |
| Stats Heap Allocated 67,106,592 |
| >> |
| >>-- TEST for EXPLAIN_IN_RMS |
| >>control query default explain_in_rms 'on' ; |
| |
| --- SQL operation complete. |
| >>control query shape cut; |
| |
| --- SQL operation complete. |
| >>prepare s1 from select d from tstat ; |
| |
| --- SQL command prepared. |
| >>log; |
| >>explain options 'f' for qid MXID11000011701212378219753251307000000000206U3333300_366_S1 ; |
| |
| LC RC OP OPERATOR OPT DESCRIPTION CARD |
| ---- ---- ---- -------------------- -------- -------------------- --------- |
| |
| 1 . 2 root 1.00E+002 |
| . . 1 trafodion_scan TSTAT 1.00E+002 |
| |
| --- SQL operation complete. |
| >>log; |
| >>control query default explain_in_rms reset; |
| |
| --- SQL operation complete. |
| >> |
| >>-- TEST for index name - Soln 10-090330-0390 |
| >>create index tstati on tstat(d); |
| |
| --- SQL operation complete. |
| >>prepare s1 from select d from tstat ; |
| |
| --- SQL command prepared. |
| >>explain options 'f' s1 ; |
| |
| LC RC OP OPERATOR OPT DESCRIPTION CARD |
| ---- ---- ---- -------------------- -------- -------------------- --------- |
| |
| 1 . 2 root 1.00E+002 |
| . . 1 trafodion_index_scan TSTATI 1.00E+002 |
| |
| --- SQL operation complete. |
| >>log ; |
| >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ; |
| |
| --- SQL operation complete. |
| >>display statistics for QID MXID11000011701212378219753251307000000000206U3333300_491_S1 ; |
| Qid MXID11000011701212378219753251307000000000206U3333300_491_S1 |
| Compile Start Time 2017/11/23 17:57:44.184561 |
| Compile End Time 2017/11/23 17:57:44.630325 |
| Compile Elapsed Time 0:00:00.445764 |
| Execute Start Time -1 |
| Execute End Time -1 |
| Execute Elapsed Time 0:00:00.000000 |
| State CLOSE |
| Rows Affected -1 |
| SQL Error Code 0 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| Number of SQL Processes 1 |
| Number of Cpus 0 |
| Transaction Id -1 |
| Source String select d from tstat ; |
| SQL Source Length 21 |
| Rows Returned 0 |
| First Row Returned Time -1 |
| 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 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 MXID11000011701212378219753251307000000000206U3333300_491_S1 ; |
| Qid MXID11000011701212378219753251307000000000206U3333300_491_S1 |
| Compile Start Time 2017/11/23 17:57:44.184561 |
| Compile End Time 2017/11/23 17:57:44.630325 |
| Compile Elapsed Time 0:00:00.445764 |
| Execute Start Time -1 |
| Execute End Time -1 |
| Execute Elapsed Time 0:00:00.000000 |
| State CLOSE |
| Rows Affected -1 |
| SQL Error Code 0 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| Number of SQL Processes 1 |
| Number of Cpus 0 |
| Transaction Id -1 |
| Source String select d from tstat ; |
| SQL Source Length 21 |
| Rows Returned 0 |
| First Row Returned Time -1 |
| 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 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. |
| >>log; |
| >>execute s1 ; |
| |
| D |
| ----------- |
| |
| 11 |
| 12 |
| 21 |
| 22 |
| |
| --- 4 row(s) selected. |
| >>log ; |
| >>SET SESSION DEFAULT STATISTICS_VIEW_TYPE 'DEFAULT' ; |
| |
| --- SQL operation complete. |
| >>display statistics for QID MXID11000011701212378219753251307000000000206U3333300_491_S1 PERTABLE; |
| Qid MXID11000011701212378219753251307000000000206U3333300_491_S1 |
| Compile Start Time 2017/11/23 17:57:44.184561 |
| Compile End Time 2017/11/23 17:57:44.630325 |
| Compile Elapsed Time 0:00:00.445764 |
| Execute Start Time 2017/11/23 17:57:51.904186 |
| Execute End Time 2017/11/23 17:57:51.929161 |
| Execute Elapsed Time 0:00:00.024975 |
| State CLOSE |
| Rows Affected 0 |
| SQL Error Code 100 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| Number of SQL Processes 1 |
| Number of Cpus 1 |
| Transaction Id -1 |
| Source String select d from tstat ; |
| SQL Source Length 21 |
| Rows Returned 4 |
| First Row Returned Time 2017/11/23 17:57:51.927636 |
| 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.024975 secs |
| Max. Execute Time 0.024975 secs |
| Avg. Execute Time 0.024975 secs |
| Stats Collection Type OPERATOR_STATS |
| SQL Process Busy Time 2,653 |
| UDR Process Busy Time 0 |
| SQL Space Allocated 32 KB |
| SQL Space Used 5 KB |
| SQL Heap Allocated 40 KB |
| SQL Heap Used 36 KB |
| SQL Heap WM 43 KB |
| Processes Created 0 |
| Process Create Time 0 |
| Request Message Count 0 |
| Request Message Bytes 0 |
| Reply Message Count 0 |
| Reply Message Bytes 0 |
| BMO Space Buffer Size 0 |
| BMO Space Buffer Count 0 |
| BMO Interim Row Count 0 |
| Scr. Overflow Mode UNKNOWN |
| Scr. File Count 0 |
| Scr. IO Size 0 |
| Scr. Read Count 0 |
| Scr. Write Count 0 |
| 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 |
| 1 1 TRAFODION.SCH.TSTATI |
| 0 4 100 4 2 0 20,698 20,698 |
| |
| --- SQL operation complete. |
| >>get statistics for QID MXID11000011701212378219753251307000000000206U3333300_491_S1 PERTABLE; |
| Qid MXID11000011701212378219753251307000000000206U3333300_491_S1 |
| Compile Start Time 2017/11/23 17:57:44.184561 |
| Compile End Time 2017/11/23 17:57:44.630325 |
| Compile Elapsed Time 0:00:00.445764 |
| Execute Start Time 2017/11/23 17:57:51.904186 |
| Execute End Time 2017/11/23 17:57:51.929161 |
| Execute Elapsed Time 0:00:00.024975 |
| State CLOSE |
| Rows Affected 0 |
| SQL Error Code 100 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| Number of SQL Processes 1 |
| Number of Cpus 1 |
| Transaction Id -1 |
| Source String select d from tstat ; |
| SQL Source Length 21 |
| Rows Returned 4 |
| First Row Returned Time 2017/11/23 17:57:51.927636 |
| 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.024975 secs |
| Max. Execute Time 0.024975 secs |
| Avg. Execute Time 0.024975 secs |
| Stats Collection Type OPERATOR_STATS |
| SQL Process Busy Time 2,653 |
| UDR Process Busy Time 0 |
| SQL Space Allocated 32 KB |
| SQL Space Used 5 KB |
| SQL Heap Allocated 40 KB |
| SQL Heap Used 36 KB |
| SQL Heap WM 43 KB |
| Processes Created 0 |
| Process Create Time 0 |
| Request Message Count 0 |
| Request Message Bytes 0 |
| Reply Message Count 0 |
| Reply Message Bytes 0 |
| BMO Space Buffer Size 0 |
| BMO Space Buffer Count 0 |
| BMO Interim Row Count 0 |
| Scr. Overflow Mode UNKNOWN |
| Scr. File Count 0 |
| Scr. IO Size 0 |
| Scr. Read Count 0 |
| Scr. Write Count 0 |
| 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 |
| 1 1 TRAFODION.SCH.TSTATI |
| 0 4 100 4 2 0 20,698 20,698 |
| |
| --- SQL operation complete. |
| >>log; |
| >> |
| >>-- EXECDirect test to check if QID current is proper |
| >>select * from tstat ; |
| |
| A B C D |
| ----- ------ ---- ----------- |
| |
| MMMM 21 MMMM 21 |
| XXXXX 22 XXXX 22 |
| AAAA 11 AAAA 11 |
| BBBB 12 BBBB 12 |
| |
| --- 4 row(s) selected. |
| >>get statistics for qid current ; |
| Qid MXID11000011701212378219753251307000000000206U3333300_515___SQLCI_DML_LAST__ |
| Compile Start Time 2017/11/23 17:57:55.581199 |
| Compile End Time 2017/11/23 17:57:55.609168 |
| Compile Elapsed Time 0:00:00.027969 |
| Execute Start Time 2017/11/23 17:57:55.609379 |
| Execute End Time 2017/11/23 17:57:55.619162 |
| Execute Elapsed Time 0:00:00.009783 |
| State DEALLOCATED |
| Rows Affected 0 |
| SQL Error Code 100 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| Number of SQL Processes 1 |
| Number of Cpus 1 |
| Transaction Id -1 |
| Source String select * from tstat ; |
| SQL Source Length 21 |
| Rows Returned 4 |
| First Row Returned Time 2017/11/23 17:57:55.617820 |
| 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.009783 secs |
| Max. Execute Time 0.009783 secs |
| Avg. Execute Time 0.009783 secs |
| Stats Collection Type OPERATOR_STATS |
| SQL Process Busy Time 2,139 |
| UDR Process Busy Time 0 |
| SQL Space Allocated 32 KB |
| SQL Space Used 5 KB |
| SQL Heap Allocated 40 KB |
| SQL Heap Used 36 KB |
| SQL Heap WM 43 KB |
| Processes Created 0 |
| Process Create Time 0 |
| Request Message Count 0 |
| Request Message Bytes 0 |
| Reply Message Count 0 |
| Reply Message Bytes 0 |
| BMO Space Buffer Size 0 |
| BMO Space Buffer Count 0 |
| BMO Interim Row Count 0 |
| Scr. Overflow Mode UNKNOWN |
| Scr. File Count 0 |
| Scr. IO Size 0 |
| Scr. Read Count 0 |
| Scr. Write Count 0 |
| 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 |
| 1 1 TRAFODION.SCH.TSTAT |
| 0 4 100 4 2 0 6,627 6,627 |
| |
| --- SQL operation complete. |
| >> |
| >>-- Compare QID CURRENT to QID <qid> |
| >>control query default detailed_statistics 'ACCUMULATED' ; |
| |
| --- SQL operation complete. |
| >>obey TESTRTS(compare_current_qid); |
| >>prepare s1 from select count(*) from |
| +>tstat A, tstat B, tstat C, tstat D; |
| |
| --- SQL command prepared. |
| >> |
| >>execute s1; |
| |
| (EXPR) |
| -------------------- |
| |
| 256 |
| |
| --- 1 row(s) selected. |
| >> |
| >>log; |
| >>sh grep "^QID is " QID_TEMP | cut -c 8- | sed "s/^/get statistics for qid /g" | sed "s/$/;/g" > STATS_CMD_QID; |
| >>log; |
| 1c1,2 |
| < >>get statistics for qid current; |
| --- |
| > >>obey STATS_CMD_QID; |
| > >>get statistics for qid MXID11000011701212378219753251307000000000206U3333300_518_S1; |
| 21c22 |
| < Number of Cpus 1 |
| --- |
| > Number of Cpus 2 |
| 38a40,50 |
| > Id DOP Table Name |
| > EstRowsAccess ActRowsAccess EstRowsUsed ActRowsUsed SE_IOs SE_IO_KBytes SE_IO_SumTime SE_IO_MaxTime |
| > 1 0 TRAFODION.SCH.TSTATI |
| > 0 0 100 0 0 0 0 0 |
| > 6 0 TRAFODION.SCH.TSTATI |
| > 0 0 100 0 0 0 0 0 |
| > 11 0 TRAFODION.SCH.TSTATI |
| > 0 0 100 0 0 0 0 0 |
| > 16 0 TRAFODION.SCH.TSTATI |
| > 0 0 100 0 0 0 0 0 |
| > |
| >> |
| >> |
| >>control query default detailed_statistics 'PERTABLE' ; |
| |
| --- SQL operation complete. |
| >>obey TESTRTS(compare_current_qid); |
| >>prepare s1 from select count(*) from |
| +>tstat A, tstat B, tstat C, tstat D; |
| |
| --- SQL command prepared. |
| >> |
| >>execute s1; |
| |
| (EXPR) |
| -------------------- |
| |
| 256 |
| |
| --- 1 row(s) selected. |
| >> |
| >>log; |
| >>sh grep "^QID is " QID_TEMP | cut -c 8- | sed "s/^/get statistics for qid /g" | sed "s/$/;/g" > STATS_CMD_QID; |
| >>log; |
| 1c1,2 |
| < >>get statistics for qid current; |
| --- |
| > >>obey STATS_CMD_QID; |
| > >>get statistics for qid MXID11000011701212378219753251307000000000206U3333300_522_S1; |
| 21c22 |
| < Number of Cpus 1 |
| --- |
| > Number of Cpus 2 |
| >> |
| >> |
| >>control query default detailed_statistics 'system' ; |
| |
| --- SQL operation complete. |
| >>obey TESTRTS(compare_current_qid); |
| >>prepare s1 from select count(*) from |
| +>tstat A, tstat B, tstat C, tstat D; |
| |
| --- SQL command prepared. |
| >> |
| >>execute s1; |
| |
| (EXPR) |
| -------------------- |
| |
| 256 |
| |
| --- 1 row(s) selected. |
| >> |
| >>log; |
| >>sh grep "^QID is " QID_TEMP | cut -c 8- | sed "s/^/get statistics for qid /g" | sed "s/$/;/g" > STATS_CMD_QID; |
| >>log; |
| 1c1,2 |
| < >>get statistics for qid current; |
| --- |
| > >>obey STATS_CMD_QID; |
| > >>get statistics for qid MXID11000011701212378219753251307000000000206U3333300_526_S1; |
| 21c22 |
| < Number of Cpus 1 |
| --- |
| > Number of Cpus 2 |
| >> |
| >> |
| >>obey TESTRTS(exeindp2_stats); |
| |
| *** ERROR[15014] Section exeindp2_stats was not found in file TESTRTS. |
| |
| >>--Negative tests using STATISTICS stored procedure |
| >>select * from table (statistics(null, 'QID=')); |
| |
| --- 0 row(s) selected. |
| >>select * from table (statistics(null, 'QID=mxid')); |
| |
| *** ERROR[8919] Unable to retrieve Runtime Statistics for invalid Query Id mxid. |
| |
| --- 0 row(s) selected. |
| >>select * from table (statistics(null, 'QID=MXID01001')); |
| |
| *** ERROR[8919] Unable to retrieve Runtime Statistics for invalid Query Id MXID01001. |
| |
| --- 0 row(s) selected. |
| >>select * from table (statistics(null, 'CPU=')); |
| |
| --- 0 row(s) selected. |
| >>select * from table (statistics(null, 'PID=')); |
| |
| *** ERROR[8920] Invalid CPU or PID passed in. Unable to retrieve Runtime Statistics. |
| |
| --- 0 row(s) selected. |
| >>select * from table (statistics(null, 'SYSTEM=')); |
| |
| --- 0 row(s) selected. |
| >>select * from table (statistics(null, 'MERGE=2')); |
| |
| --- 0 row(s) selected. |
| >> |
| >>--Negative tests using GET STATISTICS command |
| >>get statistics for qid ; |
| |
| *** ERROR[15001] A syntax error occurred at or before: |
| get statistics for qid ; |
| ^ (24 characters from start of SQL statement) |
| |
| *** ERROR[8822] The statement was not prepared. |
| |
| >>get statistics for qid mxid ; |
| |
| *** ERROR[8919] Unable to retrieve Runtime Statistics for invalid Query Id MXID. |
| |
| --- SQL operation failed with errors. |
| >>get statistics for qid "mxid" ; |
| |
| *** ERROR[8919] Unable to retrieve Runtime Statistics for invalid Query Id mxid. |
| |
| --- SQL operation failed with errors. |
| >>get statistics for qid mxid01001 ; |
| |
| *** ERROR[8919] Unable to retrieve Runtime Statistics for invalid Query Id MXID01001. |
| |
| --- SQL operation failed with errors. |
| >>get statistics for qid mxid0100202 ; |
| |
| *** ERROR[8919] Unable to retrieve Runtime Statistics for invalid Query Id MXID0100202. |
| |
| --- SQL operation failed with errors. |
| >>get statistics for qid mxid010010A0788 ; |
| |
| *** ERROR[8919] Unable to retrieve Runtime Statistics for invalid Query Id MXID010010A0788. |
| |
| --- SQL operation failed with errors. |
| >>get statistics for qid mxid01002020880 ; |
| |
| *** ERROR[8919] Unable to retrieve Runtime Statistics for invalid Query Id MXID01002020880. |
| |
| --- SQL operation failed with errors. |
| >>get statistics for cpu ; |
| |
| *** ERROR[15001] A syntax error occurred at or before: |
| get statistics for cpu ; |
| ^ (24 characters from start of SQL statement) |
| |
| *** ERROR[8822] The statement was not prepared. |
| |
| >>get statistics for cpu a; |
| |
| *** ERROR[15001] A syntax error occurred at or before: |
| get statistics for cpu a; |
| ^ (24 characters from start of SQL statement) |
| |
| *** ERROR[8822] The statement was not prepared. |
| |
| >>get statistics for cpu "A"; |
| |
| *** ERROR[15001] A syntax error occurred at or before: |
| get statistics for cpu "A"; |
| ^ (26 characters from start of SQL statement) |
| |
| *** ERROR[8822] The statement was not prepared. |
| |
| >>get statistics for pid ; |
| |
| *** ERROR[15001] A syntax error occurred at or before: |
| get statistics for pid ; |
| ^ (24 characters from start of SQL statement) |
| |
| *** ERROR[8822] The statement was not prepared. |
| |
| >>get statistics for pid a,a ; |
| |
| *** ERROR[15001] A syntax error occurred at or before: |
| get statistics for pid a,a ; |
| ^ (24 characters from start of SQL statement) |
| |
| *** ERROR[8822] The statement was not prepared. |
| |
| >>get statistics for pid a; |
| |
| *** ERROR[15001] A syntax error occurred at or before: |
| get statistics for pid a; |
| ^ (24 characters from start of SQL statement) |
| |
| *** ERROR[8822] The statement was not prepared. |
| |
| >> |
| >>-- Test to determine if invalid token is taken as stmt name |
| >>select * from table (statistics(null, 'AAA=')); |
| |
| --- 0 row(s) selected. |
| >> |
| >>obey TESTRTS(esp_idle_timeout); |
| >>get process statistics for current ; |
| |
| Node Id: 0 |
| PID 11701 |
| Start Time 2017/11/23 17:55:53.251307 |
| EXE Memory Allocated 20 MB |
| EXE Memory Used High WM 98 MB |
| EXE Memory Used 20 MB |
| IPC Memory Allocated 1 MB |
| IPC Memory Used High WM 1 MB |
| IPC Memory Used 1 MB |
| Static Stmt Count 0 |
| Dynamic Stmt Count 3 |
| Open Stmt Count 0 |
| Reclaimable Stmt Count 0 |
| Reclaimed Stmt Count 0 |
| Total ESPs Started 2 |
| Total ESPs Startup Completed 2 |
| Total ESPs Error in Startup 0 |
| Total ESPs Deleted 0 |
| Num ESPs In Use 2 |
| Num ESPs Free 0 |
| Recent Qid MXID11000011701212378219753251307000000000206U3333300_526_S1 |
| |
| --- SQL operation complete. |
| >>set session default esp_idle_timeout '60' ; |
| |
| --- SQL operation complete. |
| >>cqd esp_idle_timeout '60' ; |
| |
| --- SQL operation complete. |
| >>control query shape esp_exchange(hash_groupby(esp_exchange(scan))); |
| |
| --- SQL operation complete. |
| >>select distinct d from tstat ; |
| |
| D |
| ----------- |
| |
| 11 |
| 21 |
| 22 |
| 12 |
| |
| --- 4 row(s) selected. |
| >>get process statistics for current ; |
| |
| Node Id: 0 |
| PID 11701 |
| Start Time 2017/11/23 17:55:53.251307 |
| EXE Memory Allocated 20 MB |
| EXE Memory Used High WM 98 MB |
| EXE Memory Used 20 MB |
| IPC Memory Allocated 1 MB |
| IPC Memory Used High WM 1 MB |
| IPC Memory Used 1 MB |
| Static Stmt Count 0 |
| Dynamic Stmt Count 3 |
| Open Stmt Count 0 |
| Reclaimable Stmt Count 0 |
| Reclaimed Stmt Count 0 |
| Total ESPs Started 4 |
| Total ESPs Startup Completed 4 |
| Total ESPs Error in Startup 0 |
| Total ESPs Deleted 0 |
| Num ESPs In Use 2 |
| Num ESPs Free 2 |
| Recent Qid MXID11000011701212378219753251307000000000206U3333300_554___SQLCI_DML_LAST__ |
| |
| --- SQL operation complete. |
| >>sh sleep 70; |
| >>select distinct d from tstat ; |
| |
| D |
| ----------- |
| |
| 12 |
| 11 |
| 21 |
| 22 |
| |
| --- 4 row(s) selected. |
| >>get process statistics for current ; |
| |
| Node Id: 0 |
| PID 11701 |
| Start Time 2017/11/23 17:55:53.251307 |
| EXE Memory Allocated 20 MB |
| EXE Memory Used High WM 98 MB |
| EXE Memory Used 20 MB |
| IPC Memory Allocated 1 MB |
| IPC Memory Used High WM 1 MB |
| IPC Memory Used 1 MB |
| Static Stmt Count 0 |
| Dynamic Stmt Count 3 |
| Open Stmt Count 0 |
| Reclaimable Stmt Count 0 |
| Reclaimed Stmt Count 0 |
| Total ESPs Started 6 |
| Total ESPs Startup Completed 6 |
| Total ESPs Error in Startup 0 |
| Total ESPs Deleted 2 |
| Num ESPs In Use 2 |
| Num ESPs Free 2 |
| Recent Qid MXID11000011701212378219753251307000000000206U3333300_556___SQLCI_DML_LAST__ |
| |
| --- SQL operation complete. |
| >>control query shape cut; |
| |
| --- SQL operation complete. |
| >> |
| >>obey TESTRTS(hive_tests); |
| >>select [last 0] * from hive.hive.store; |
| |
| --- 0 row(s) selected. |
| >>get statistics for qid current ; |
| Qid MXID11000011701212378219753251307000000000206U3333300_559___SQLCI_DML_LAST__ |
| Compile Start Time 2017/11/23 17:59:15.477494 |
| Compile End Time 2017/11/23 17:59:22.839987 |
| Compile Elapsed Time 0:00:07.362493 |
| Execute Start Time 2017/11/23 17:59:22.841372 |
| Execute End Time 2017/11/23 17:59:22.904988 |
| Execute Elapsed Time 0:00:00.063616 |
| State DEALLOCATED |
| Rows Affected 0 |
| SQL Error Code 100 |
| Stats Error Code 0 |
| Query Type SQL_SELECT_NON_UNIQUE |
| Sub Query Type SQL_STMT_NA |
| Estimated Accessed Rows 0 |
| Estimated Used Rows 0 |
| Parent Qid NONE |
| Parent Query System NONE |
| Child Qid NONE |
| Number of SQL Processes 1 |
| Number of Cpus 1 |
| Transaction Id -1 |
| Source String select [last 0] * from hive.hive.store; |
| SQL Source Length 39 |
| Rows Returned 0 |
| First Row Returned Time -1 |
| 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.063616 secs |
| Max. Execute Time 0.063616 secs |
| Avg. Execute Time 0.063616 secs |
| Stats Collection Type OPERATOR_STATS |
| SQL Process Busy Time 6,473 |
| UDR Process Busy Time 0 |
| SQL Space Allocated 72,584 KB |
| SQL Space Used 72,577 KB |
| SQL Heap Allocated 139,169 KB |
| SQL Heap Used 139,152 KB |
| SQL Heap WM 139,152 KB |
| Processes Created 0 |
| Process Create Time 0 |
| Request Message Count 0 |
| Request Message Bytes 0 |
| Reply Message Count 0 |
| Reply Message Bytes 0 |
| BMO Space Buffer Size 0 |
| BMO Space Buffer Count 0 |
| BMO Interim Row Count 0 |
| Scr. Overflow Mode UNKNOWN |
| Scr. File Count 0 |
| Scr. IO Size 0 |
| Scr. Read Count 0 |
| Scr. Write Count 0 |
| 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 |
| 1 1 HIVE.HIVE.STORE |
| 0 12 0 12 1 3 2,000 2,000 |
| |
| --- SQL operation complete. |
| >> |
| >>obey TESTRTS(clean_up); |
| >>drop table tstat; |
| |
| --- SQL operation complete. |
| >> |
| >>log ; |
