Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
5.5.1
-
None
-
None
-
CentOS, Virtualized, On Premise
Description
Customer reported that query time takes much long in v5.5.x than v1.2.5.
Here is calSetTrace result after calFlushCache from v1.2.5 and v.5.5.1.
[v1.2.5]
Old System Columnstore:
|
select calFlushCache();
|
select calSetTrace(1); |
SELECT v.`WHO1_ID` AS `1102_WHO1`
|
,SUM(`VAL_61_200`) AS `VALUE_2018_01_M_200_1_1`
|
...
|
...
|
select calGetStats();
|
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| calGetStats() |
|
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
Query Stats: MaxMemPct-0; NumTempFiles-0; TempFileSpace-0B; ApproxPhyI/O-305648; CacheI/O-305627; BlocksTouched-305544; PartitionBlocksEliminated-0; MsgBytesIn-861KB; MsgBytesOut-19MB; Mode-Distributed | |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
select convert(calGetTrace() ,CHAR);
|
 |
Desc Mode Table TableOID ReferencedColumns PIO LIO PBE Elapsed Rows
|
CES UM - - - - - - 0.161 160341 |
BPS PM fact_de_nvikt_1102 888958 (PZN_ID,VAL_13_200,VAL_14_200,VAL_15_200,VAL_16_200,VAL_17_200,VAL_18_200,VAL_19_200,VAL_1_101,VAL_20_200,VAL_21_200,VAL_22_200,VAL_23_200,VAL_24_200) 305648 305627 0 9.649 1980 |
HJS PM fact_de_nvikt_1102-ct 888958 ------- - |
TAS UM - - - - - - 8.646 15 |
TNS UM - - - - - - 0.000 15 |
[v5.5.1]
select calFlushCache();
|
select calSetTrace(1); |
SELECT v.`WHO1_ID` AS `1102_WHO1`
|
,SUM(`VAL_61_200`) AS `VALUE_2018_01_M_200_1_1`
|
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| calGetStats() |
|
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| Query Stats: MaxMemPct-0; NumTempFiles-0; TempFileSpace-0B; ApproxPhyI/O-305606; CacheI/O-305588; BlocksTouched-305528; PartitionBlocksEliminated-0; MsgBytesIn-801KB; MsgBytesOut-14MB; Mode-Distributed | |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
 |
select convert(calGetTrace() ,CHAR);
|
Desc Mode Table TableOID ReferencedColumns PIO LIO PBE Elapsed Rows
|
CES UM - - - - - - 0.101 160341 |
BPS PM fact_de_nvikt_1102 23610 (pzn_id,val_13_200,val_14_200,val_15_200,val_16_200,val_17_200,val_18_200,val_19_200,val_1_101,val_20_200,val_21_200,val_22_200,val_23_200,val_24_200) 305606 305588 0 115.846 1485 |
HJS PM fact_de_nvikt_1102-ct 23610 - - - - ----- - |
TAS UM - - - - - - 113.812 15 |
TNS UM - - - - - - 0.000 15 |
|
|