{"id":7701,"date":"2021-08-16T17:20:41","date_gmt":"2021-08-16T09:20:41","guid":{"rendered":"https:\/\/www.gbase8.cn\/?p=7701"},"modified":"2021-08-16T17:20:41","modified_gmt":"2021-08-16T09:20:41","slug":"gbase-8a%e7%9a%84%e8%a1%8c%e5%ad%98%e5%88%97grouped%e6%80%a7%e8%83%bd%e6%8f%90%e5%8d%87%e6%b5%8b%e8%af%95","status":"publish","type":"post","link":"https:\/\/www.gbase8.cn\/en\/7701","title":{"rendered":"\u5357\u5927\u901a\u7528GBase 8a\u7684\u884c\u5b58\u5217grouped\u6027\u80fd\u63d0\u5347\u6d4b\u8bd5"},"content":{"rendered":"<p>\u672c\u6587\u6d4b\u8bd5GBase 8a\u91cc\u884c\u5b58\u5217\u529f\u80fd\u5bf9\u6027\u80fd\u7684\u63d0\u5347\u60c5\u51b5\u3002\u6574\u4f53\u770b\u884c\u5b58\u5217\u63d0\u5347\u4e861\u500d\u7684\u6027\u80fd\u3002\u4f46\u4e5f\u6d88\u8017\u4e861\u500d\u7684\u989d\u5916\u7a7a\u95f4\u3002<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Directory Navigation<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a2ad78a28b5c\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a2ad78a28b5c\"  aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.gbase8.cn\/en\/7701\/#%E6%B5%8B%E8%AF%95%E7%BB%93%E8%AE%BA\" >\u6d4b\u8bd5\u7ed3\u8bba<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.gbase8.cn\/en\/7701\/#%E6%B5%8B%E8%AF%95%E7%8E%AF%E5%A2%83\" >\u6d4b\u8bd5\u73af\u5883<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.gbase8.cn\/en\/7701\/#%E7%A1%AC%E4%BB%B6\" >\u786c\u4ef6<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.gbase8.cn\/en\/7701\/#%E7%89%88%E6%9C%AC\" >\u7248\u672c<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.gbase8.cn\/en\/7701\/#%E6%95%B0%E6%8D%AE\" >\u6570\u636e<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.gbase8.cn\/en\/7701\/#%E6%B5%8B%E8%AF%95SQL\" >\u6d4b\u8bd5SQL<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.gbase8.cn\/en\/7701\/#%E6%B5%8B%E8%AF%95%E8%BF%87%E7%A8%8B\" >\u6d4b\u8bd5\u8fc7\u7a0b<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.gbase8.cn\/en\/7701\/#%E6%97%A0%E8%A1%8C%E5%AD%98%E5%88%97\" >\u65e0\u884c\u5b58\u5217<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.gbase8.cn\/en\/7701\/#%E6%9C%89%E8%A1%8C%E5%AD%98%E5%88%97\" >\u6709\u884c\u5b58\u5217<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%B5%8B%E8%AF%95%E7%BB%93%E8%AE%BA\"><\/span>\u6d4b\u8bd5\u7ed3\u8bba<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u672c\u6d4b\u8bd5\u90fd\u662fint\u6570\u636e\uff0c\u53ea\u6709110\u4e07\u884c\uff0c\u5bf9\u6bd4200\u5217\u7684\u7ed3\u679c\u770b\uff0c\u884c\u5b58\u5217\u63d0\u5347\u4e861\u500d\u7684\u6027\u80fd\u3002\u4f46\u4e5f\u6d88\u8017\u4e861\u500d\u7684\u989d\u5916\u7a7a\u95f4\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%B5%8B%E8%AF%95%E7%8E%AF%E5%A2%83\"><\/span>\u6d4b\u8bd5\u73af\u5883<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E7%A1%AC%E4%BB%B6\"><\/span>\u786c\u4ef6<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u7b14\u8bb0\u672c\u7684\u865a\u62df\u673a\uff0c 4C, 4G. redhat 7<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E7%89%88%E6%9C%AC\"><\/span>\u7248\u672c<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>9.5.2, \u8be5\u529f\u80fd\u6ca1\u6709\u505a\u8fc7\u6539\u52a8\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%95%B0%E6%8D%AE\"><\/span>\u6570\u636e<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>110\u4e07\u884c\uff0c200\u5217\u7684\u8868\u3002\u5b9e\u9645\u662f1000\u5217\uff0c\u4f461\u4e2a\u884c\u5b58\u5217\u6700\u591a256\u4e2a\uff0c\u6240\u4ee5\u53ea\u4f7f\u7528\u4e86\u5176\u4e2d\u7684\u524d200\u5217\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase> select count(*) from c1000;\r\n+----------+\r\n| count(*) |\r\n+----------+\r\n|  1100000 |\r\n+----------+\r\n1 row in set (Elapsed: 00:00:00.26)\r\n<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%B5%8B%E8%AF%95SQL\"><\/span>\u6d4b\u8bd5SQL<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u6bcf\u4e2aDC\u8fd4\u56de1\u884c\u7684\u6781\u9650\u60c5\u51b5\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>gbase> select id1,id2,i ... id198,id199,id200 from c1000 where rowid%65536=0;<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%B5%8B%E8%AF%95%E8%BF%87%E7%A8%8B\"><\/span>\u6d4b\u8bd5\u8fc7\u7a0b<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%97%A0%E8%A1%8C%E5%AD%98%E5%88%97\"><\/span>\u65e0\u884c\u5b58\u5217<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u8017\u65f63.14\uff0c\u5176\u4e2d\u7269\u5316\u90e8\u5206\u82b1\u8d393\u79d2\u3002\u4ece\u78c1\u76d8\u8bfb\u53d6\u4e861800\u4e2aDC,  9\u884c*200\u5217=1800DC.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>2021-08-16 17:02:47.245 &#91;M: 642M,   0B,D:   0B] &#91;DC:   208,     0] ======================================================\r\n^&#91;&#91;B^&#91;&#91;B^&#91;&#91;B2021-08-16 17:04:27.398 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] SQL Statement:\r\nSELECT \/*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)\r\n2021-08-16 17:04:27.398 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] Start Query Execution\r\n2021-08-16 17:04:27.399 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] Tables:\r\n2021-08-16 17:04:27.399 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] T0:          vcname000001.testdb.c1000(testdb.c1000_n2),     549984 rows,     9 DC\r\n2021-08-16 17:04:27.399 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] Condition Weight (non-join):\r\n2021-08-16 17:04:27.399 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] cnd(0):      LA:200 = 0      (0)\r\n2021-08-16 17:04:27.399 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] BEGIN Smart Scan\r\n2021-08-16 17:04:27.399 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] T0:          total 9 DC,     found 9 DC to scan(with 0 FULL DC).\r\n2021-08-16 17:04:27.399 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] END Smart Scan. (time used: 0.000s)\r\n2021-08-16 17:04:27.399 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] BEGIN Scan\r\n2021-08-16 17:04:27.399 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] cnd(0) LA:200 = 0\r\n2021-08-16 17:04:27.501 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] ( 3)cnd(0)   scanned 91232 rows,     found 2 rows (time used: 0.102s)\r\n2021-08-16 17:04:27.531 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] ( 0)cnd(0)   scanned 196608 rows,    found 3 rows (time used: 0.123s)\r\n2021-08-16 17:04:27.537 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] ( 1)cnd(0)   scanned 131072 rows,    found 2 rows (time used: 0.138s)\r\n2021-08-16 17:04:27.551 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] ( 2)cnd(0)   scanned 131072 rows,    found 2 rows (time used: 0.151s)\r\n2021-08-16 17:04:27.551 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] cnd(0) Done. scanned 549984 rows,    found 9 rows (time used: 0.152s)\r\n2021-08-16 17:04:27.559 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] T0:          total 9 DC,     found 9 DC after scan(with 0 FULL DC).\r\n2021-08-16 17:04:27.559 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] END Scan. (time used: 0.160s)\r\n2021-08-16 17:04:27.559 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] Condition Weight (join):\r\n2021-08-16 17:04:27.559 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] BEGIN Join\r\n2021-08-16 17:04:27.559 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] END Join(time used: 0.000s)\r\n2021-08-16 17:04:27.559 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] BEGIN Scan(after join)\r\n2021-08-16 17:04:27.560 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] END Scan(after join)(time used: 0.000s)\r\n2021-08-16 17:04:27.560 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0]\r\n2021-08-16 17:04:27.560 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] BEGIN Materialization(9 rows, page size: 65536)\r\n2021-08-16 17:04:27.560 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] need not materialize here, materialize later\r\n2021-08-16 17:04:30.501 &#91;M: 764M,   0B,D:   0B] &#91;DC:     0,  1800] Send 9 rows already\r\n2021-08-16 17:04:30.502 &#91;M: 764M,   0B,D:   0B] &#91;DC:     0,  1800] ResultSender: send 0 rows.\r\n2021-08-16 17:04:30.502 &#91;M: 764M,   0B,D:   0B] &#91;DC:     0,  1800] output result done.\r\n\r\n2021-08-16 17:04:30.504 &#91;M: 764M,   0B,D:   0B] &#91;DC:     0,  1800] SUMMARY\r\n2021-08-16 17:04:30.504 &#91;M: 764M,   0B,D:   0B] &#91;DC:     0,  1800] elapsed time:                00:00:03.105\r\n2021-08-16 17:04:30.504 &#91;M: 764M,   0B,D:   0B] &#91;DC:     0,  1800] data loaded from storage:     244M,  2.674s,         1800 DC.\r\n2021-08-16 17:04:30.504 &#91;M: 764M,   0B,D:   0B] &#91;DC:     0,  1800] data decompressed:            389M,  0.189s.\r\n2021-08-16 17:04:30.504 &#91;M: 764M,   0B,D:   0B] &#91;DC:     0,  1800] temp space IO stats:\r\n2021-08-16 17:04:30.504 &#91;M: 764M,   0B,D:   0B] &#91;DC:     0,  1800] CB   write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\r\n2021-08-16 17:04:30.504 &#91;M: 764M,   0B,D:   0B] &#91;DC:     0,  1800] SRT  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\r\n2021-08-16 17:04:30.504 &#91;M: 764M,   0B,D:   0B] &#91;DC:     0,  1800] GDC  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\r\n2021-08-16 17:04:30.504 &#91;M: 764M,   0B,D:   0B] &#91;DC:     0,  1800] MAT  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\r\n2021-08-16 17:04:30.504 &#91;M: 764M,   0B,D:   0B] &#91;DC:     0,  1800] HSJ  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\r\n2021-08-16 17:04:30.504 &#91;M: 764M,   0B,D:   0B] &#91;DC:     0,  1800] ======================================================<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%9C%89%E8%A1%8C%E5%AD%98%E5%88%97\"><\/span>\u6709\u884c\u5b58\u5217<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u8017\u65f61.91\uff0c\u5176\u4e2d\u7269\u5316\u90e8\u5206\u82b1\u8d391.6\u79d2\uff0c\u63d0\u5347\u7ea61\u500d\u3002\u4ece\u78c1\u76d8\u8bfb\u53d6\u4e86208\u4e2aDC\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>2021-08-16 17:02:18.265 &#91;M:2.81G,   0B,D:   0B] &#91;DC:   208,     0] ======================================================\r\n2021-08-16 17:02:39.331 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] SQL Statement:\r\nSELECT \/*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)\r\n2021-08-16 17:02:39.331 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] Start Query Execution\r\n2021-08-16 17:02:39.333 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] Tables:\r\n2021-08-16 17:02:39.333 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] T0:          vcname000001.testdb.c1000(testdb.c1000_n2),     549984 rows,     9 DC\r\n2021-08-16 17:02:39.333 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] Condition Weight (non-join):\r\n2021-08-16 17:02:39.333 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] cnd(0):      LA:200 = 0      (0)\r\n2021-08-16 17:02:39.333 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] BEGIN Smart Scan\r\n2021-08-16 17:02:39.333 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] T0:          total 9 DC,     found 9 DC to scan(with 0 FULL DC).\r\n2021-08-16 17:02:39.333 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] END Smart Scan. (time used: 0.000s)\r\n2021-08-16 17:02:39.333 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] BEGIN Scan\r\n2021-08-16 17:02:39.333 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] cnd(0) LA:200 = 0\r\n2021-08-16 17:02:39.488 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] ( 3)cnd(0)   scanned 91232 rows,     found 2 rows (time used: 0.155s)\r\n2021-08-16 17:02:39.543 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] ( 2)cnd(0)   scanned 131072 rows,    found 2 rows (time used: 0.209s)\r\n2021-08-16 17:02:39.544 &#91;M:   0B,   0B,D:   0B] &#91;DC:     0,     0] ( 0)cnd(0)   scanned 196608 rows,    found 3 rows (time used: 0.198s)\r\n2021-08-16 17:02:39.559 &#91;M:   4M,   0B,D:   0B] &#91;DC:     0,     0] ( 1)cnd(0)   scanned 131072 rows,    found 2 rows (time used: 0.216s)\r\n2021-08-16 17:02:39.560 &#91;M:   4M,   0B,D:   0B] &#91;DC:     0,     0] cnd(0) Done. scanned 549984 rows,    found 9 rows (time used: 0.227s)\r\n2021-08-16 17:02:39.560 &#91;M:   4M,   0B,D:   0B] &#91;DC:     0,     0] T0:          total 9 DC,     found 9 DC after scan(with 0 FULL DC).\r\n2021-08-16 17:02:39.560 &#91;M:   4M,   0B,D:   0B] &#91;DC:     0,     0] END Scan. (time used: 0.227s)\r\n2021-08-16 17:02:39.560 &#91;M:   4M,   0B,D:   0B] &#91;DC:     0,     0] Condition Weight (join):\r\n2021-08-16 17:02:39.560 &#91;M:   4M,   0B,D:   0B] &#91;DC:     0,     0] BEGIN Join\r\n2021-08-16 17:02:39.560 &#91;M:   4M,   0B,D:   0B] &#91;DC:     0,     0] END Join(time used: 0.000s)\r\n2021-08-16 17:02:39.560 &#91;M:   4M,   0B,D:   0B] &#91;DC:     0,     0] BEGIN Scan(after join)\r\n2021-08-16 17:02:39.560 &#91;M:   4M,   0B,D:   0B] &#91;DC:     0,     0] END Scan(after join)(time used: 0.000s)\r\n2021-08-16 17:02:39.560 &#91;M:   4M,   0B,D:   0B] &#91;DC:     0,     0]\r\n2021-08-16 17:02:39.560 &#91;M:   4M,   0B,D:   0B] &#91;DC:     0,     0] BEGIN Materialization(9 rows, page size: 65536)\r\n2021-08-16 17:02:39.561 &#91;M:   4M,   0B,D:   0B] &#91;DC:     0,     0] need not materialize here, materialize later\r\n2021-08-16 17:02:39.563 &#91;M:   5M,   0B,D:   0B] &#91;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\r\n2021-08-16 17:02:41.167 &#91;M: 634M,   0B,D:   0B] &#91;DC:     0,   208] Send 9 rows already\r\n2021-08-16 17:02:41.171 &#91;M: 635M,   0B,D:   0B] &#91;DC:     0,   208] ResultSender: send 0 rows.\r\n2021-08-16 17:02:41.171 &#91;M: 635M,   0B,D:   0B] &#91;DC:     0,   208] output result done.\r\n\r\n2021-08-16 17:02:41.172 &#91;M: 635M,   0B,D:   0B] &#91;DC:     0,   208] SUMMARY\r\n2021-08-16 17:02:41.172 &#91;M: 635M,   0B,D:   0B] &#91;DC:     0,   208] elapsed time:                00:00:01.840\r\n2021-08-16 17:02:41.172 &#91;M: 635M,   0B,D:   0B] &#91;DC:     0,   208] data loaded from storage:     223M,  1.504s,         208 DC.\r\n2021-08-16 17:02:41.172 &#91;M: 635M,   0B,D:   0B] &#91;DC:     0,   208] data decompressed:            101M,  0.059s.\r\n2021-08-16 17:02:41.172 &#91;M: 635M,   0B,D:   0B] &#91;DC:     0,   208] pages loaded:                        6904.\r\n2021-08-16 17:02:41.172 &#91;M: 635M,   0B,D:   0B] &#91;DC:     0,   208] pages size loaded from storage:       204M,  0.829s.\r\n2021-08-16 17:02:41.172 &#91;M: 635M,   0B,D:   0B] &#91;DC:     0,   208] pages size decompressed:                5M,  0.092s.\r\n2021-08-16 17:02:41.173 &#91;M: 635M,   0B,D:   0B] &#91;DC:     0,   208] temp space IO stats:\r\n2021-08-16 17:02:41.173 &#91;M: 635M,   0B,D:   0B] &#91;DC:     0,   208] CB   write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\r\n2021-08-16 17:02:41.173 &#91;M: 635M,   0B,D:   0B] &#91;DC:     0,   208] SRT  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\r\n2021-08-16 17:02:41.173 &#91;M: 635M,   0B,D:   0B] &#91;DC:     0,   208] GDC  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\r\n2021-08-16 17:02:41.173 &#91;M: 635M,   0B,D:   0B] &#91;DC:     0,   208] MAT  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\r\n2021-08-16 17:02:41.173 &#91;M: 635M,   0B,D:   0B] &#91;DC:     0,   208] HSJ  write(   0B, 0time, 0sec),       read(   0B, 0time, 0sec)\r\n2021-08-16 17:02:41.173 &#91;M: 635M,   0B,D:   0B] &#91;DC:     0,   208] ======================================================<\/code><\/pre>","protected":false},"excerpt":{"rendered":"<p>\u672c\u6587\u6d4b\u8bd5GBase 8a\u91cc\u884c\u5b58\u5217\u529f\u80fd\u5bf9\u6027\u80fd\u7684\u63d0\u5347\u60c5\u51b5\u3002\u6574\u4f53\u770b\u884c\u5b58\u5217\u63d0\u5347\u4e861\u500d\u7684\u6027\u80fd\u3002\u4f46\u4e5f\u6d88\u8017\u4e861\u500d\u7684\u989d\u5916\u7a7a\u95f4\u3002<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-7701","post","type-post","status-publish","format-standard","hentry","category-gbase8a"],"_links":{"self":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/7701","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/comments?post=7701"}],"version-history":[{"count":1,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/7701\/revisions"}],"predecessor-version":[{"id":7702,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/7701\/revisions\/7702"}],"wp:attachment":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/media?parent=7701"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/categories?post=7701"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/tags?post=7701"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}