GBase 8a的行存列grouped性能提升测试

本文测试GBase 8a里行存列功能对性能的提升情况。整体看行存列提升了1倍的性能。但也消耗了1倍的额外空间。

测试结论

本测试都是int数据,只有110万行,对比200列的结果看,行存列提升了1倍的性能。但也消耗了1倍的额外空间。

测试环境

硬件

笔记本的虚拟机, 4C, 4G. redhat 7

版本

9.5.2, 该功能没有做过改动。

数据

110万行,200列的表。实际是1000列,但1个行存列最多256个,所以只使用了其中的前200列。

gbase> select count(*) from c1000;
+----------+
| count(*) |
+----------+
|  1100000 |
+----------+
1 row in set (Elapsed: 00:00:00.26)

测试SQL

每个DC返回1行的极限情况。

gbase> select id1,id2,i ... id198,id199,id200 from c1000 where rowid%65536=0;

测试过程

无行存列

耗时3.14,其中物化部分花费3秒。从磁盘读取了1800个DC, 9行*200列=1800DC.

2021-08-16 17:02:47.245 [M: 642M,   0B,D:   0B] [DC:   208,     0] ======================================================
^[[B^[[B^[[B2021-08-16 17:04:27.398 [M:   0B,   0B,D:   0B] [DC:     0,     0] SQL Statement:
SELECT /*10.0.2.101_3_61_2021-08-16_17:04:27*/ /*+ TID('1769572') */ `vcname000001.testdb.c1000`.`id1` AS `id1`, `vcname000001.testdb.c1000`.`id2` AS `id2`, `vcname000001.testdb.c1000`.`id3` AS `id3`, `vcname000001.testdb.c1000`.`id4` AS `id4`, `vcname000001.testdb.c1000`.`id5` AS `id5`, `vcname000001.testdb.c1000`.`id6` AS `id6`, `vcname000001.testdb.c1000`.`id7` AS `id7`, `vcname000001.testdb.c1000`.`id8` AS `id8`, `vcname000001.testdb.c1000`.`id9` AS `id9`, `vcname000001.testdb.c1000`.`id10` AS `id10`, `vcname000001.testdb.c1000`.`id11` AS `id11`, `vcname000001.testdb.c1000`.`id12` AS `id12`, `vcname000001.testdb.c1000`.`id13` AS `id13`, `vcname000001.testdb.c1000`.`id14` AS `id14`, `vcname000001.testdb.c1000`.`id15` AS `id15`, `vcname000001.testdb.c1000`.`id16` AS `id16`, `vcname000001.testdb.c1000`.`id17` AS `id17`, `vcname000001.testdb.c1000`.`id18` AS `id18`, `vcname000001.testdb.c1000`.`id19` AS `id19`, `vcname000001.testdb.c1000`.`id20` AS `id20`, `vcname000001.testdb.c1000`.`id21` AS `id21`, `vcname000001.testdb.c1000`.`id22` AS `id22`, `vcname000001.testdb.c1000`.`id23` AS `id23`, `vcname000001.testdb.c1000`.`id24` AS `id24`, `vcname000001.testdb.c1000`.`id25` AS `id25`, `vcname000001.testdb.c1000`.`id26` AS `id26`, `vcname000001.testdb.c1000`.`id27` AS `id27`, `vcname000001.testdb.c1000`.`id28` AS `id28`, `vcname000001.testdb.c1000`.`id29` AS `id29`, `vcname000001.testdb.c1000`.`id30` AS `id30`, `vcname000001.testdb.c1000`.`id31` AS `id31`, `vcname000001.testdb.c1000`.`id32` AS `id32`, `vcname000001.testdb.c1000`.`id33` AS `id33`, `vcname000001.testdb.c1000`.`id34` AS `id34`, `vcname000001.testdb.c1000`.`id35` AS `id35`, `vcname000001.testdb.c1000`.`id36` AS `id36`, `vcname000001.testdb.c1000`.`id37` AS `id37`, `vcname000001.testdb.c1000`.`id38` AS `id38`, `vcname000001.testdb.c1000`.`id39` AS `id39`, `vcname000001.testdb.c1000`.`id40` AS `id40`, `vcname000001.testdb.c1000`.`id41` AS `id41`, `vcname000001.testdb.c1000`.`id42` AS `id42`, `vcname000001.testdb.c1000`.`id43` AS `id43`, `vcname000001.testdb.c1000`.`id44` AS `id44`, `vcname000001.testdb.c1000`.`id45` AS `id45`, `vcname000001.testdb.c1000`.`id46` AS `id46`, `vcname000001.testdb.c1000`.`id47` AS `id47`, `vcname000001.testdb.c1000`.`id48` AS `id48`, `vcname000001.testdb.c1000`.`id49` AS `id49`, `vcname000001.testdb.c1000`.`id50` AS `id50`, `vcname000001.testdb.c1000`.`id51` AS `id51`, `vcname000001.testdb.c1000`.`id52` AS `id52`, `vcname000001.testdb.c1000`.`id53` AS `id53`, `vcname000001.testdb.c1000`.`id54` AS `id54`, `vcname000001.testdb.c1000`.`id55` AS `id55`, `vcname000001.testdb.c1000`.`id56` AS `id56`, `vcname000001.testdb.c1000`.`id57` AS `id57`, `vcname000001.testdb.c1000`.`id58` AS `id58`, `vcname000001.testdb.c1000`.`id59` AS `id59`, `vcname000001.testdb.c1000`.`id60` AS `id60`, `vcname000001.testdb.c1000`.`id61` AS `id61`, `vcname000001.testdb.c1000`.`id62` AS `id62`, `vcname000001.testdb.c1000`.`id63` AS `id63`, `vcname000001.testdb.c1000`.`id64` AS `id64`, `vcname000001.testdb.c1000`.`id65` AS `id65`, `vcname000001.testdb.c1000`.`id66` AS `id66`, `vcname000001.testdb.c1000`.`id67` AS `id67`, `vcname000001.testdb.c1000`.`id68` AS `id68`, `vcname000001.testdb.c1000`.`id69` AS `id69`, `vcname000001.testdb.c1000`.`id70` AS `id70`, `vcname000001.testdb.c1000`.`id71` AS `id71`, `vcname000001.testdb.c1000`.`id72` AS `id72`, `vcname000001.testdb.c1000`.`id73` AS `id73`, `vcname000001.testdb.c1000`.`id74` AS `id74`, `vcname000001.testdb.c1000`.`id75` AS `id75`, `vcname000001.testdb.c1000`.`id76` AS `id76`, `vcname000001.testdb.c1000`.`id77` AS `id77`, `vcname000001.testdb.c1000`.`id78` AS `id78`, `vcname000001.testdb.c1000`.`id79` AS `id79`, `vcname000001.testdb.c1000`.`id80` AS `id80`, `vcname000001.testdb.c1000`.`id81` AS `id81`, `vcname000001.testdb.c1000`.`id82` AS `id82`, `vcname000001.testdb.c1000`.`id83` AS `id83`, `vcname000001.testdb.c1000`.`id84` AS `id84`, `vcname000001.testdb.c1000`.`id85` AS `id85`, `vcname000001.testdb.c1000`.`id86` AS `id86`, `vcname000001.testdb.c1000`.`id87` AS `id87`, `vcname000001.testdb.c1000`.`id88` AS `id88`, `vcname000001.testdb.c1000`.`id89` AS `id89`, `vcname000001.testdb.c1000`.`id90` AS `id90`, `vcname000001.testdb.c1000`.`id91` AS `id91`, `vcname000001.testdb.c1000`.`id92` AS `id92`, `vcname000001.testdb.c1000`.`id93` AS `id93`, `vcname000001.testdb.c1000`.`id94` AS `id94`, `vcname000001.testdb.c1000`.`id95` AS `id95`, `vcname000001.testdb.c1000`.`id96` AS `id96`, `vcname000001.testdb.c1000`.`id97` AS `id97`, `vcname000001.testdb.c1000`.`id98` AS `id98`, `vcname000001.testdb.c1000`.`id99` AS `id99`, `vcname000001.testdb.c1000`.`id100` AS `id100`, `vcname000001.testdb.c1000`.`id101` AS `id101`, `vcname000001.testdb.c1000`.`id102` AS `id102`, `vcname000001.testdb.c1000`.`id103` AS `id103`, `vcname000001.testdb.c1000`.`id104` AS `id104`, `vcname000001.testdb.c1000`.`id105` AS `id105`, `vcname000001.testdb.c1000`.`id106` AS `id106`, `vcname000001.testdb.c1000`.`id107` AS `id107`, `vcname000001.testdb.c1000`.`id108` AS `id108`, `vcname000001.testdb.c1000`.`id109` AS `id109`, `vcname000001.testdb.c1000`.`id110` AS `id110`, `vcname000001.testdb.c1000`.`id111` AS `id111`, `vcname000001.testdb.c1000`.`id112` AS `id112`, `vcname000001.testdb.c1000`.`id113` AS `id113`, `vcname000001.testdb.c1000`.`id114` AS `id114`, `vcname000001.testdb.c1000`.`id115` AS `id115`, `vcname000001.testdb.c1000`.`id116` AS `id116`, `vcname000001.testdb.c1000`.`id117` AS `id117`, `vcname000001.testdb.c1000`.`id118` AS `id118`, `vcname000001.testdb.c1000`.`id119` AS `id119`, `vcname000001.testdb.c1000`.`id120` AS `id120`, `vcname000001.testdb.c1000`.`id121` AS `id121`, `vcname000001.testdb.c1000`.`id122` AS `id122`, `vcname000001.testdb.c1000`.`id123` AS `id123`, `vcname000001.testdb.c1000`.`id124` AS `id124`, `vcname000001.testdb.c1000`.`id125` AS `id125`, `vcname000001.testdb.c1000`.`id126` AS `id126`, `vcname000001.testdb.c1000`.`id127` AS `id127`, `vcname000001.testdb.c1000`.`id128` AS `id128`, `vcname000001.testdb.c1000`.`id129` AS `id129`, `vcname000001.testdb.c1000`.`id130` AS `id130`, `vcname000001.testdb.c1000`.`id131` AS `id131`, `vcname000001.testdb.c1000`.`id132` AS `id132`, `vcname000001.testdb.c1000`.`id133` AS `id133`, `vcname000001.testdb.c1000`.`id134` AS `id134`, `vcname000001.testdb.c1000`.`id135` AS `id135`, `vcname000001.testdb.c1000`.`id136` AS `id136`, `vcname000001.testdb.c1000`.`id137` AS `id137`, `vcname000001.testdb.c1000`.`id138` AS `id138`, `vcname000001.testdb.c1000`.`id139` AS `id139`, `vcname000001.testdb.c1000`.`id140` AS `id140`, `vcname000001.testdb.c1000`.`id141` AS `id141`, `vcname000001.testdb.c1000`.`id142` AS `id142`, `vcname000001.testdb.c1000`.`id143` AS `id143`, `vcname000001.testdb.c1000`.`id144` AS `id144`, `vcname000001.testdb.c1000`.`id145` AS `id145`, `vcname000001.testdb.c1000`.`id146` AS `id146`, `vcname000001.testdb.c1000`.`id147` AS `id147`, `vcname000001.testdb.c1000`.`id148` AS `id148`, `vcname000001.testdb.c1000`.`id149` AS `id149`, `vcname000001.testdb.c1000`.`id150` AS `id150`, `vcname000001.testdb.c1000`.`id151` AS `id151`, `vcname000001.testdb.c1000`.`id152` AS `id152`, `vcname000001.testdb.c1000`.`id153` AS `id153`, `vcname000001.testdb.c1000`.`id154` AS `id154`, `vcname000001.testdb.c1000`.`id155` AS `id155`, `vcname000001.testdb.c1000`.`id156` AS `id156`, `vcname000001.testdb.c1000`.`id157` AS `id157`, `vcname000001.testdb.c1000`.`id158` AS `id158`, `vcname000001.testdb.c1000`.`id159` AS `id159`, `vcname000001.testdb.c1000`.`id160` AS `id160`, `vcname000001.testdb.c1000`.`id161` AS `id161`, `vcname000001.testdb.c1000`.`id162` AS `id162`, `vcname000001.testdb.c1000`.`id163` AS `id163`, `vcname000001.testdb.c1000`.`id164` AS `id164`, `vcname000001.testdb.c1000`.`id165` AS `id165`, `vcname000001.testdb.c1000`.`id166` AS `id166`, `vcname000001.testdb.c1000`.`id167` AS `id167`, `vcname000001.testdb.c1000`.`id168` AS `id168`, `vcname000001.testdb.c1000`.`id169` AS `id169`, `vcname000001.testdb.c1000`.`id170` AS `id170`, `vcname000001.testdb.c1000`.`id171` AS `id171`, `vcname000001.testdb.c1000`.`id172` AS `id172`, `vcname000001.testdb.c1000`.`id173` AS `id173`, `vcname000001.testdb.c1000`.`id174` AS `id174`, `vcname000001.testdb.c1000`.`id175` AS `id175`, `vcname000001.testdb.c1000`.`id176` AS `id176`, `vcname000001.testdb.c1000`.`id177` AS `id177`, `vcname000001.testdb.c1000`.`id178` AS `id178`, `vcname000001.testdb.c1000`.`id179` AS `id179`, `vcname000001.testdb.c1000`.`id180` AS `id180`, `vcname000001.testdb.c1000`.`id181` AS `id181`, `vcname000001.testdb.c1000`.`id182` AS `id182`, `vcname000001.testdb.c1000`.`id183` AS `id183`, `vcname000001.testdb.c1000`.`id184` AS `id184`, `vcname000001.testdb.c1000`.`id185` AS `id185`, `vcname000001.testdb.c1000`.`id186` AS `id186`, `vcname000001.testdb.c1000`.`id187` AS `id187`, `vcname000001.testdb.c1000`.`id188` AS `id188`, `vcname000001.testdb.c1000`.`id189` AS `id189`, `vcname000001.testdb.c1000`.`id190` AS `id190`, `vcname000001.testdb.c1000`.`id191` AS `id191`, `vcname000001.testdb.c1000`.`id192` AS `id192`, `vcname000001.testdb.c1000`.`id193` AS `id193`, `vcname000001.testdb.c1000`.`id194` AS `id194`, `vcname000001.testdb.c1000`.`id195` AS `id195`, `vcname000001.testdb.c1000`.`id196` AS `id196`, `vcname000001.testdb.c1000`.`id197` AS `id197`, `vcname000001.testdb.c1000`.`id198` AS `id198`, `vcname000001.testdb.c1000`.`id199` AS `id199`, `vcname000001.testdb.c1000`.`id200` AS `id200` FROM `testdb`.`c1000_n2` `vcname000001.testdb.c1000` WHERE ((`vcname000001.testdb.c1000`.`rowid` % 65536) = 0)
2021-08-16 17:04:27.398 [M:   0B,   0B,D:   0B] [DC:     0,     0] Start Query Execution
2021-08-16 17:04:27.399 [M:   0B,   0B,D:   0B] [DC:     0,     0] Tables:
2021-08-16 17:04:27.399 [M:   0B,   0B,D:   0B] [DC:     0,     0] T0:          vcname000001.testdb.c1000(testdb.c1000_n2),     549984 rows,     9 DC
2021-08-16 17:04:27.399 [M:   0B,   0B,D:   0B] [DC:     0,     0] Condition Weight (non-join):
2021-08-16 17:04:27.399 [M:   0B,   0B,D:   0B] [DC:     0,     0] cnd(0):      LA:200 = 0      (0)
2021-08-16 17:04:27.399 [M:   0B,   0B,D:   0B] [DC:     0,     0] BEGIN Smart Scan
2021-08-16 17:04:27.399 [M:   0B,   0B,D:   0B] [DC:     0,     0] T0:          total 9 DC,     found 9 DC to scan(with 0 FULL DC).
2021-08-16 17:04:27.399 [M:   0B,   0B,D:   0B] [DC:     0,     0] END Smart Scan. (time used: 0.000s)
2021-08-16 17:04:27.399 [M:   0B,   0B,D:   0B] [DC:     0,     0] BEGIN Scan
2021-08-16 17:04:27.399 [M:   0B,   0B,D:   0B] [DC:     0,     0] cnd(0) LA:200 = 0
2021-08-16 17:04:27.501 [M:   0B,   0B,D:   0B] [DC:     0,     0] ( 3)cnd(0)   scanned 91232 rows,     found 2 rows (time used: 0.102s)
2021-08-16 17:04:27.531 [M:   0B,   0B,D:   0B] [DC:     0,     0] ( 0)cnd(0)   scanned 196608 rows,    found 3 rows (time used: 0.123s)
2021-08-16 17:04:27.537 [M:   0B,   0B,D:   0B] [DC:     0,     0] ( 1)cnd(0)   scanned 131072 rows,    found 2 rows (time used: 0.138s)
2021-08-16 17:04:27.551 [M:   0B,   0B,D:   0B] [DC:     0,     0] ( 2)cnd(0)   scanned 131072 rows,    found 2 rows (time used: 0.151s)
2021-08-16 17:04:27.551 [M:   0B,   0B,D:   0B] [DC:     0,     0] cnd(0) Done. scanned 549984 rows,    found 9 rows (time used: 0.152s)
2021-08-16 17:04:27.559 [M:   0B,   0B,D:   0B] [DC:     0,     0] T0:          total 9 DC,     found 9 DC after scan(with 0 FULL DC).
2021-08-16 17:04:27.559 [M:   0B,   0B,D:   0B] [DC:     0,     0] END Scan. (time used: 0.160s)
2021-08-16 17:04:27.559 [M:   0B,   0B,D:   0B] [DC:     0,     0] Condition Weight (join):
2021-08-16 17:04:27.559 [M:   0B,   0B,D:   0B] [DC:     0,     0] BEGIN Join
2021-08-16 17:04:27.559 [M:   0B,   0B,D:   0B] [DC:     0,     0] END Join(time used: 0.000s)
2021-08-16 17:04:27.559 [M:   0B,   0B,D:   0B] [DC:     0,     0] BEGIN Scan(after join)
2021-08-16 17:04:27.560 [M:   0B,   0B,D:   0B] [DC:     0,     0] END Scan(after join)(time used: 0.000s)
2021-08-16 17:04:27.560 [M:   0B,   0B,D:   0B] [DC:     0,     0]
2021-08-16 17:04:27.560 [M:   0B,   0B,D:   0B] [DC:     0,     0] BEGIN Materialization(9 rows, page size: 65536)
2021-08-16 17:04:27.560 [M:   0B,   0B,D:   0B] [DC:     0,     0] need not materialize here, materialize later
2021-08-16 17:04:30.501 [M: 764M,   0B,D:   0B] [DC:     0,  1800] Send 9 rows already
2021-08-16 17:04:30.502 [M: 764M,   0B,D:   0B] [DC:     0,  1800] ResultSender: send 0 rows.
2021-08-16 17:04:30.502 [M: 764M,   0B,D:   0B] [DC:     0,  1800] output result done.

2021-08-16 17:04:30.504 [M: 764M,   0B,D:   0B] [DC:     0,  1800] SUMMARY
2021-08-16 17:04:30.504 [M: 764M,   0B,D:   0B] [DC:     0,  1800] elapsed time:                00:00:03.105
2021-08-16 17:04:30.504 [M: 764M,   0B,D:   0B] [DC:     0,  1800] data loaded from storage:     244M,  2.674s,         1800 DC.
2021-08-16 17:04:30.504 [M: 764M,   0B,D:   0B] [DC:     0,  1800] data decompressed:            389M,  0.189s.
2021-08-16 17:04:30.504 [M: 764M,   0B,D:   0B] [DC:     0,  1800] temp space IO stats:
2021-08-16 17:04:30.504 [M: 764M,   0B,D:   0B] [DC:     0,  1800] CB   write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)
2021-08-16 17:04:30.504 [M: 764M,   0B,D:   0B] [DC:     0,  1800] SRT  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)
2021-08-16 17:04:30.504 [M: 764M,   0B,D:   0B] [DC:     0,  1800] GDC  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)
2021-08-16 17:04:30.504 [M: 764M,   0B,D:   0B] [DC:     0,  1800] MAT  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)
2021-08-16 17:04:30.504 [M: 764M,   0B,D:   0B] [DC:     0,  1800] HSJ  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)
2021-08-16 17:04:30.504 [M: 764M,   0B,D:   0B] [DC:     0,  1800] ======================================================

有行存列

耗时1.91,其中物化部分花费1.6秒,提升约1倍。从磁盘读取了208个DC。

2021-08-16 17:02:18.265 [M:2.81G,   0B,D:   0B] [DC:   208,     0] ======================================================
2021-08-16 17:02:39.331 [M:   0B,   0B,D:   0B] [DC:     0,     0] SQL Statement:
SELECT /*10.0.2.101_3_54_2021-08-16_17:02:39*/ /*+ TID('1769562') */ `vcname000001.testdb.c1000`.`id1` AS `id1`, `vcname000001.testdb.c1000`.`id2` AS `id2`, `vcname000001.testdb.c1000`.`id3` AS `id3`, `vcname000001.testdb.c1000`.`id4` AS `id4`, `vcname000001.testdb.c1000`.`id5` AS `id5`, `vcname000001.testdb.c1000`.`id6` AS `id6`, `vcname000001.testdb.c1000`.`id7` AS `id7`, `vcname000001.testdb.c1000`.`id8` AS `id8`, `vcname000001.testdb.c1000`.`id9` AS `id9`, `vcname000001.testdb.c1000`.`id10` AS `id10`, `vcname000001.testdb.c1000`.`id11` AS `id11`, `vcname000001.testdb.c1000`.`id12` AS `id12`, `vcname000001.testdb.c1000`.`id13` AS `id13`, `vcname000001.testdb.c1000`.`id14` AS `id14`, `vcname000001.testdb.c1000`.`id15` AS `id15`, `vcname000001.testdb.c1000`.`id16` AS `id16`, `vcname000001.testdb.c1000`.`id17` AS `id17`, `vcname000001.testdb.c1000`.`id18` AS `id18`, `vcname000001.testdb.c1000`.`id19` AS `id19`, `vcname000001.testdb.c1000`.`id20` AS `id20`, `vcname000001.testdb.c1000`.`id21` AS `id21`, `vcname000001.testdb.c1000`.`id22` AS `id22`, `vcname000001.testdb.c1000`.`id23` AS `id23`, `vcname000001.testdb.c1000`.`id24` AS `id24`, `vcname000001.testdb.c1000`.`id25` AS `id25`, `vcname000001.testdb.c1000`.`id26` AS `id26`, `vcname000001.testdb.c1000`.`id27` AS `id27`, `vcname000001.testdb.c1000`.`id28` AS `id28`, `vcname000001.testdb.c1000`.`id29` AS `id29`, `vcname000001.testdb.c1000`.`id30` AS `id30`, `vcname000001.testdb.c1000`.`id31` AS `id31`, `vcname000001.testdb.c1000`.`id32` AS `id32`, `vcname000001.testdb.c1000`.`id33` AS `id33`, `vcname000001.testdb.c1000`.`id34` AS `id34`, `vcname000001.testdb.c1000`.`id35` AS `id35`, `vcname000001.testdb.c1000`.`id36` AS `id36`, `vcname000001.testdb.c1000`.`id37` AS `id37`, `vcname000001.testdb.c1000`.`id38` AS `id38`, `vcname000001.testdb.c1000`.`id39` AS `id39`, `vcname000001.testdb.c1000`.`id40` AS `id40`, `vcname000001.testdb.c1000`.`id41` AS `id41`, `vcname000001.testdb.c1000`.`id42` AS `id42`, `vcname000001.testdb.c1000`.`id43` AS `id43`, `vcname000001.testdb.c1000`.`id44` AS `id44`, `vcname000001.testdb.c1000`.`id45` AS `id45`, `vcname000001.testdb.c1000`.`id46` AS `id46`, `vcname000001.testdb.c1000`.`id47` AS `id47`, `vcname000001.testdb.c1000`.`id48` AS `id48`, `vcname000001.testdb.c1000`.`id49` AS `id49`, `vcname000001.testdb.c1000`.`id50` AS `id50`, `vcname000001.testdb.c1000`.`id51` AS `id51`, `vcname000001.testdb.c1000`.`id52` AS `id52`, `vcname000001.testdb.c1000`.`id53` AS `id53`, `vcname000001.testdb.c1000`.`id54` AS `id54`, `vcname000001.testdb.c1000`.`id55` AS `id55`, `vcname000001.testdb.c1000`.`id56` AS `id56`, `vcname000001.testdb.c1000`.`id57` AS `id57`, `vcname000001.testdb.c1000`.`id58` AS `id58`, `vcname000001.testdb.c1000`.`id59` AS `id59`, `vcname000001.testdb.c1000`.`id60` AS `id60`, `vcname000001.testdb.c1000`.`id61` AS `id61`, `vcname000001.testdb.c1000`.`id62` AS `id62`, `vcname000001.testdb.c1000`.`id63` AS `id63`, `vcname000001.testdb.c1000`.`id64` AS `id64`, `vcname000001.testdb.c1000`.`id65` AS `id65`, `vcname000001.testdb.c1000`.`id66` AS `id66`, `vcname000001.testdb.c1000`.`id67` AS `id67`, `vcname000001.testdb.c1000`.`id68` AS `id68`, `vcname000001.testdb.c1000`.`id69` AS `id69`, `vcname000001.testdb.c1000`.`id70` AS `id70`, `vcname000001.testdb.c1000`.`id71` AS `id71`, `vcname000001.testdb.c1000`.`id72` AS `id72`, `vcname000001.testdb.c1000`.`id73` AS `id73`, `vcname000001.testdb.c1000`.`id74` AS `id74`, `vcname000001.testdb.c1000`.`id75` AS `id75`, `vcname000001.testdb.c1000`.`id76` AS `id76`, `vcname000001.testdb.c1000`.`id77` AS `id77`, `vcname000001.testdb.c1000`.`id78` AS `id78`, `vcname000001.testdb.c1000`.`id79` AS `id79`, `vcname000001.testdb.c1000`.`id80` AS `id80`, `vcname000001.testdb.c1000`.`id81` AS `id81`, `vcname000001.testdb.c1000`.`id82` AS `id82`, `vcname000001.testdb.c1000`.`id83` AS `id83`, `vcname000001.testdb.c1000`.`id84` AS `id84`, `vcname000001.testdb.c1000`.`id85` AS `id85`, `vcname000001.testdb.c1000`.`id86` AS `id86`, `vcname000001.testdb.c1000`.`id87` AS `id87`, `vcname000001.testdb.c1000`.`id88` AS `id88`, `vcname000001.testdb.c1000`.`id89` AS `id89`, `vcname000001.testdb.c1000`.`id90` AS `id90`, `vcname000001.testdb.c1000`.`id91` AS `id91`, `vcname000001.testdb.c1000`.`id92` AS `id92`, `vcname000001.testdb.c1000`.`id93` AS `id93`, `vcname000001.testdb.c1000`.`id94` AS `id94`, `vcname000001.testdb.c1000`.`id95` AS `id95`, `vcname000001.testdb.c1000`.`id96` AS `id96`, `vcname000001.testdb.c1000`.`id97` AS `id97`, `vcname000001.testdb.c1000`.`id98` AS `id98`, `vcname000001.testdb.c1000`.`id99` AS `id99`, `vcname000001.testdb.c1000`.`id100` AS `id100`, `vcname000001.testdb.c1000`.`id101` AS `id101`, `vcname000001.testdb.c1000`.`id102` AS `id102`, `vcname000001.testdb.c1000`.`id103` AS `id103`, `vcname000001.testdb.c1000`.`id104` AS `id104`, `vcname000001.testdb.c1000`.`id105` AS `id105`, `vcname000001.testdb.c1000`.`id106` AS `id106`, `vcname000001.testdb.c1000`.`id107` AS `id107`, `vcname000001.testdb.c1000`.`id108` AS `id108`, `vcname000001.testdb.c1000`.`id109` AS `id109`, `vcname000001.testdb.c1000`.`id110` AS `id110`, `vcname000001.testdb.c1000`.`id111` AS `id111`, `vcname000001.testdb.c1000`.`id112` AS `id112`, `vcname000001.testdb.c1000`.`id113` AS `id113`, `vcname000001.testdb.c1000`.`id114` AS `id114`, `vcname000001.testdb.c1000`.`id115` AS `id115`, `vcname000001.testdb.c1000`.`id116` AS `id116`, `vcname000001.testdb.c1000`.`id117` AS `id117`, `vcname000001.testdb.c1000`.`id118` AS `id118`, `vcname000001.testdb.c1000`.`id119` AS `id119`, `vcname000001.testdb.c1000`.`id120` AS `id120`, `vcname000001.testdb.c1000`.`id121` AS `id121`, `vcname000001.testdb.c1000`.`id122` AS `id122`, `vcname000001.testdb.c1000`.`id123` AS `id123`, `vcname000001.testdb.c1000`.`id124` AS `id124`, `vcname000001.testdb.c1000`.`id125` AS `id125`, `vcname000001.testdb.c1000`.`id126` AS `id126`, `vcname000001.testdb.c1000`.`id127` AS `id127`, `vcname000001.testdb.c1000`.`id128` AS `id128`, `vcname000001.testdb.c1000`.`id129` AS `id129`, `vcname000001.testdb.c1000`.`id130` AS `id130`, `vcname000001.testdb.c1000`.`id131` AS `id131`, `vcname000001.testdb.c1000`.`id132` AS `id132`, `vcname000001.testdb.c1000`.`id133` AS `id133`, `vcname000001.testdb.c1000`.`id134` AS `id134`, `vcname000001.testdb.c1000`.`id135` AS `id135`, `vcname000001.testdb.c1000`.`id136` AS `id136`, `vcname000001.testdb.c1000`.`id137` AS `id137`, `vcname000001.testdb.c1000`.`id138` AS `id138`, `vcname000001.testdb.c1000`.`id139` AS `id139`, `vcname000001.testdb.c1000`.`id140` AS `id140`, `vcname000001.testdb.c1000`.`id141` AS `id141`, `vcname000001.testdb.c1000`.`id142` AS `id142`, `vcname000001.testdb.c1000`.`id143` AS `id143`, `vcname000001.testdb.c1000`.`id144` AS `id144`, `vcname000001.testdb.c1000`.`id145` AS `id145`, `vcname000001.testdb.c1000`.`id146` AS `id146`, `vcname000001.testdb.c1000`.`id147` AS `id147`, `vcname000001.testdb.c1000`.`id148` AS `id148`, `vcname000001.testdb.c1000`.`id149` AS `id149`, `vcname000001.testdb.c1000`.`id150` AS `id150`, `vcname000001.testdb.c1000`.`id151` AS `id151`, `vcname000001.testdb.c1000`.`id152` AS `id152`, `vcname000001.testdb.c1000`.`id153` AS `id153`, `vcname000001.testdb.c1000`.`id154` AS `id154`, `vcname000001.testdb.c1000`.`id155` AS `id155`, `vcname000001.testdb.c1000`.`id156` AS `id156`, `vcname000001.testdb.c1000`.`id157` AS `id157`, `vcname000001.testdb.c1000`.`id158` AS `id158`, `vcname000001.testdb.c1000`.`id159` AS `id159`, `vcname000001.testdb.c1000`.`id160` AS `id160`, `vcname000001.testdb.c1000`.`id161` AS `id161`, `vcname000001.testdb.c1000`.`id162` AS `id162`, `vcname000001.testdb.c1000`.`id163` AS `id163`, `vcname000001.testdb.c1000`.`id164` AS `id164`, `vcname000001.testdb.c1000`.`id165` AS `id165`, `vcname000001.testdb.c1000`.`id166` AS `id166`, `vcname000001.testdb.c1000`.`id167` AS `id167`, `vcname000001.testdb.c1000`.`id168` AS `id168`, `vcname000001.testdb.c1000`.`id169` AS `id169`, `vcname000001.testdb.c1000`.`id170` AS `id170`, `vcname000001.testdb.c1000`.`id171` AS `id171`, `vcname000001.testdb.c1000`.`id172` AS `id172`, `vcname000001.testdb.c1000`.`id173` AS `id173`, `vcname000001.testdb.c1000`.`id174` AS `id174`, `vcname000001.testdb.c1000`.`id175` AS `id175`, `vcname000001.testdb.c1000`.`id176` AS `id176`, `vcname000001.testdb.c1000`.`id177` AS `id177`, `vcname000001.testdb.c1000`.`id178` AS `id178`, `vcname000001.testdb.c1000`.`id179` AS `id179`, `vcname000001.testdb.c1000`.`id180` AS `id180`, `vcname000001.testdb.c1000`.`id181` AS `id181`, `vcname000001.testdb.c1000`.`id182` AS `id182`, `vcname000001.testdb.c1000`.`id183` AS `id183`, `vcname000001.testdb.c1000`.`id184` AS `id184`, `vcname000001.testdb.c1000`.`id185` AS `id185`, `vcname000001.testdb.c1000`.`id186` AS `id186`, `vcname000001.testdb.c1000`.`id187` AS `id187`, `vcname000001.testdb.c1000`.`id188` AS `id188`, `vcname000001.testdb.c1000`.`id189` AS `id189`, `vcname000001.testdb.c1000`.`id190` AS `id190`, `vcname000001.testdb.c1000`.`id191` AS `id191`, `vcname000001.testdb.c1000`.`id192` AS `id192`, `vcname000001.testdb.c1000`.`id193` AS `id193`, `vcname000001.testdb.c1000`.`id194` AS `id194`, `vcname000001.testdb.c1000`.`id195` AS `id195`, `vcname000001.testdb.c1000`.`id196` AS `id196`, `vcname000001.testdb.c1000`.`id197` AS `id197`, `vcname000001.testdb.c1000`.`id198` AS `id198`, `vcname000001.testdb.c1000`.`id199` AS `id199`, `vcname000001.testdb.c1000`.`id200` AS `id200` FROM `testdb`.`c1000_n2` `vcname000001.testdb.c1000` WHERE ((`vcname000001.testdb.c1000`.`rowid` % 65536) = 0)
2021-08-16 17:02:39.331 [M:   0B,   0B,D:   0B] [DC:     0,     0] Start Query Execution
2021-08-16 17:02:39.333 [M:   0B,   0B,D:   0B] [DC:     0,     0] Tables:
2021-08-16 17:02:39.333 [M:   0B,   0B,D:   0B] [DC:     0,     0] T0:          vcname000001.testdb.c1000(testdb.c1000_n2),     549984 rows,     9 DC
2021-08-16 17:02:39.333 [M:   0B,   0B,D:   0B] [DC:     0,     0] Condition Weight (non-join):
2021-08-16 17:02:39.333 [M:   0B,   0B,D:   0B] [DC:     0,     0] cnd(0):      LA:200 = 0      (0)
2021-08-16 17:02:39.333 [M:   0B,   0B,D:   0B] [DC:     0,     0] BEGIN Smart Scan
2021-08-16 17:02:39.333 [M:   0B,   0B,D:   0B] [DC:     0,     0] T0:          total 9 DC,     found 9 DC to scan(with 0 FULL DC).
2021-08-16 17:02:39.333 [M:   0B,   0B,D:   0B] [DC:     0,     0] END Smart Scan. (time used: 0.000s)
2021-08-16 17:02:39.333 [M:   0B,   0B,D:   0B] [DC:     0,     0] BEGIN Scan
2021-08-16 17:02:39.333 [M:   0B,   0B,D:   0B] [DC:     0,     0] cnd(0) LA:200 = 0
2021-08-16 17:02:39.488 [M:   0B,   0B,D:   0B] [DC:     0,     0] ( 3)cnd(0)   scanned 91232 rows,     found 2 rows (time used: 0.155s)
2021-08-16 17:02:39.543 [M:   0B,   0B,D:   0B] [DC:     0,     0] ( 2)cnd(0)   scanned 131072 rows,    found 2 rows (time used: 0.209s)
2021-08-16 17:02:39.544 [M:   0B,   0B,D:   0B] [DC:     0,     0] ( 0)cnd(0)   scanned 196608 rows,    found 3 rows (time used: 0.198s)
2021-08-16 17:02:39.559 [M:   4M,   0B,D:   0B] [DC:     0,     0] ( 1)cnd(0)   scanned 131072 rows,    found 2 rows (time used: 0.216s)
2021-08-16 17:02:39.560 [M:   4M,   0B,D:   0B] [DC:     0,     0] cnd(0) Done. scanned 549984 rows,    found 9 rows (time used: 0.227s)
2021-08-16 17:02:39.560 [M:   4M,   0B,D:   0B] [DC:     0,     0] T0:          total 9 DC,     found 9 DC after scan(with 0 FULL DC).
2021-08-16 17:02:39.560 [M:   4M,   0B,D:   0B] [DC:     0,     0] END Scan. (time used: 0.227s)
2021-08-16 17:02:39.560 [M:   4M,   0B,D:   0B] [DC:     0,     0] Condition Weight (join):
2021-08-16 17:02:39.560 [M:   4M,   0B,D:   0B] [DC:     0,     0] BEGIN Join
2021-08-16 17:02:39.560 [M:   4M,   0B,D:   0B] [DC:     0,     0] END Join(time used: 0.000s)
2021-08-16 17:02:39.560 [M:   4M,   0B,D:   0B] [DC:     0,     0] BEGIN Scan(after join)
2021-08-16 17:02:39.560 [M:   4M,   0B,D:   0B] [DC:     0,     0] END Scan(after join)(time used: 0.000s)
2021-08-16 17:02:39.560 [M:   4M,   0B,D:   0B] [DC:     0,     0]
2021-08-16 17:02:39.560 [M:   4M,   0B,D:   0B] [DC:     0,     0] BEGIN Materialization(9 rows, page size: 65536)
2021-08-16 17:02:39.561 [M:   4M,   0B,D:   0B] [DC:     0,     0] need not materialize here, materialize later
2021-08-16 17:02:39.563 [M:   5M,   0B,D:   0B] [DC:     0,     0] use hybrid store: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 . gbase_hybrid_store: 1. NoTuplesEachDc: 1
2021-08-16 17:02:41.167 [M: 634M,   0B,D:   0B] [DC:     0,   208] Send 9 rows already
2021-08-16 17:02:41.171 [M: 635M,   0B,D:   0B] [DC:     0,   208] ResultSender: send 0 rows.
2021-08-16 17:02:41.171 [M: 635M,   0B,D:   0B] [DC:     0,   208] output result done.

2021-08-16 17:02:41.172 [M: 635M,   0B,D:   0B] [DC:     0,   208] SUMMARY
2021-08-16 17:02:41.172 [M: 635M,   0B,D:   0B] [DC:     0,   208] elapsed time:                00:00:01.840
2021-08-16 17:02:41.172 [M: 635M,   0B,D:   0B] [DC:     0,   208] data loaded from storage:     223M,  1.504s,         208 DC.
2021-08-16 17:02:41.172 [M: 635M,   0B,D:   0B] [DC:     0,   208] data decompressed:            101M,  0.059s.
2021-08-16 17:02:41.172 [M: 635M,   0B,D:   0B] [DC:     0,   208] pages loaded:                        6904.
2021-08-16 17:02:41.172 [M: 635M,   0B,D:   0B] [DC:     0,   208] pages size loaded from storage:       204M,  0.829s.
2021-08-16 17:02:41.172 [M: 635M,   0B,D:   0B] [DC:     0,   208] pages size decompressed:                5M,  0.092s.
2021-08-16 17:02:41.173 [M: 635M,   0B,D:   0B] [DC:     0,   208] temp space IO stats:
2021-08-16 17:02:41.173 [M: 635M,   0B,D:   0B] [DC:     0,   208] CB   write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)
2021-08-16 17:02:41.173 [M: 635M,   0B,D:   0B] [DC:     0,   208] SRT  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)
2021-08-16 17:02:41.173 [M: 635M,   0B,D:   0B] [DC:     0,   208] GDC  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)
2021-08-16 17:02:41.173 [M: 635M,   0B,D:   0B] [DC:     0,   208] MAT  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)
2021-08-16 17:02:41.173 [M: 635M,   0B,D:   0B] [DC:     0,   208] HSJ  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)
2021-08-16 17:02:41.173 [M: 635M,   0B,D:   0B] [DC:     0,   208] ======================================================

发表评论

您的电子邮箱地址不会被公开。