首页 项目目录 关于我们
Sign In
rust
/
Materialize
1
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Branch: master
Branches Tags
Materialize
/
doc
/
user
/
layouts
/
partials
/
sql-grammar
/
explain-plan.svg

explain-plan.svg 8.0 KB
Permalink History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162 
  1. <svg xmlns="http://www.w3.org/2000/svg" width="603" height="781">
    2. 

  2.    <polygon points="9 17 1 13 1 21"/>
    3. 

  3.    <polygon points="17 17 9 13 9 21"/>
    4. 

  4.    <rect x="31" y="3" width="80" height="32" rx="10"/>
    5. 

  5.    <rect x="29"
    6. 

  6.          y="1"
    7. 

  7.          width="80"
    8. 

  8.          height="32"
    9. 

  9.          class="terminal"
    10. 

  10.          rx="10"/>
    11. 

  11.    <text class="terminal" x="39" y="21">EXPLAIN</text>
    12. 

  12.    <rect x="171" y="67" width="54" height="32" rx="10"/>
    13. 

  13.    <rect x="169"
    14. 

  14.          y="65"
    15. 

  15.          width="54"
    16. 

  16.          height="32"
    17. 

  17.          class="terminal"
    18. 

  18.          rx="10"/>
    19. 

  19.    <text class="terminal" x="179" y="85">RAW</text>
    20. 

  20.    <rect x="171" y="111" width="134" height="32" rx="10"/>
    21. 

  21.    <rect x="169"
    22. 

  22.          y="109"
    23. 

  23.          width="134"
    24. 

  24.          height="32"
    25. 

  25.          class="terminal"
    26. 

  26.          rx="10"/>
    27. 

  27.    <text class="terminal" x="179" y="129">DECORRELATED</text>
    28. 

  28.    <rect x="191" y="187" width="86" height="32" rx="10"/>
    29. 

  29.    <rect x="189"
    30. 

  30.          y="185"
    31. 

  31.          width="86"
    32. 

  32.          height="32"
    33. 

  33.          class="terminal"
    34. 

  34.          rx="10"/>
    35. 

  35.    <text class="terminal" x="199" y="205">LOCALLY</text>
    36. 

  36.    <rect x="317" y="155" width="98" height="32" rx="10"/>
    37. 

  37.    <rect x="315"
    38. 

  38.          y="153"
    39. 

  39.          width="98"
    40. 

  40.          height="32"
    41. 

  41.          class="terminal"
    42. 

  42.          rx="10"/>
    43. 

  43.    <text class="terminal" x="325" y="173">OPTIMIZED</text>
    44. 

  44.    <rect x="171" y="231" width="92" height="32" rx="10"/>
    45. 

  45.    <rect x="169"
    46. 

  46.          y="229"
    47. 

  47.          width="92"
    48. 

  48.          height="32"
    49. 

  49.          class="terminal"
    50. 

  50.          rx="10"/>
    51. 

  51.    <text class="terminal" x="179" y="249">PHYSICAL</text>
    52. 

  52.    <rect x="455" y="35" width="58" height="32" rx="10"/>
    53. 

  53.    <rect x="453"
    54. 

  54.          y="33"
    55. 

  55.          width="58"
    56. 

  56.          height="32"
    57. 

  57.          class="terminal"
    58. 

  58.          rx="10"/>
    59. 

  59.    <text class="terminal" x="463" y="53">PLAN</text>
    60. 

  60.    <rect x="45" y="341" width="68" height="32" rx="10"/>
    61. 

  61.    <rect x="43"
    62. 

  62.          y="339"
    63. 

  63.          width="68"
    64. 

  64.          height="32"
    65. 

  65.          class="terminal"
    66. 

  66.          rx="10"/>
    67. 

  67.    <text class="terminal" x="53" y="359">WITH (</text>
    68. 

  68.    <rect x="153" y="341" width="124" height="32"/>
    69. 

  69.    <rect x="151" y="339" width="124" height="32" class="nonterminal"/>
    70. 

  70.    <text class="nonterminal" x="161" y="359">output_modifier</text>
    71. 

  71.    <rect x="153" y="297" width="24" height="32" rx="10"/>
    72. 

  72.    <rect x="151"
    73. 

  73.          y="295"
    74. 

  74.          width="24"
    75. 

  75.          height="32"
    76. 

  76.          class="terminal"
    77. 

  77.          rx="10"/>
    78. 

  78.    <text class="terminal" x="161" y="315">,</text>
    79. 

  79.    <rect x="317" y="341" width="26" height="32" rx="10"/>
    80. 

  80.    <rect x="315"
    81. 

  81.          y="339"
    82. 

  82.          width="26"
    83. 

  83.          height="32"
    84. 

  84.          class="terminal"
    85. 

  85.          rx="10"/>
    86. 

  86.    <text class="terminal" x="325" y="359">)</text>
    87. 

  87.    <rect x="403" y="373" width="40" height="32" rx="10"/>
    88. 

  88.    <rect x="401"
    89. 

  89.          y="371"
    90. 

  90.          width="40"
    91. 

  91.          height="32"
    92. 

  92.          class="terminal"
    93. 

  93.          rx="10"/>
    94. 

  94.    <text class="terminal" x="411" y="391">AS</text>
    95. 

  95.    <rect x="483" y="373" width="56" height="32" rx="10"/>
    96. 

  96.    <rect x="481"
    97. 

  97.          y="371"
    98. 

  98.          width="56"
    99. 

  99.          height="32"
    100. 

  100.          class="terminal"
    101. 

  101.          rx="10"/>
    102. 

  102.    <text class="terminal" x="491" y="391">TEXT</text>
    103. 

  103.    <rect x="483" y="417" width="58" height="32" rx="10"/>
    104. 

  104.    <rect x="481"
    105. 

  105.          y="415"
    106. 

  106.          width="58"
    107. 

  107.          height="32"
    108. 

  108.          class="terminal"
    109. 

  109.          rx="10"/>
    110. 

  110.    <text class="terminal" x="491" y="435">JSON</text>
    111. 

  111.    <rect x="165" y="515" width="48" height="32" rx="10"/>
    112. 

  112.    <rect x="163"
    113. 

  113.          y="513"
    114. 

  114.          width="48"
    115. 

  115.          height="32"
    116. 

  116.          class="terminal"
    117. 

  117.          rx="10"/>
    118. 

  118.    <text class="terminal" x="173" y="533">FOR</text>
    119. 

  119.    <rect x="273" y="483" width="96" height="32"/>
    120. 

  120.    <rect x="271" y="481" width="96" height="32" class="nonterminal"/>
    121. 

  121.    <text class="nonterminal" x="281" y="501">select_stmt</text>
    122. 

  122.    <rect x="273" y="527" width="98" height="32"/>
    123. 

  123.    <rect x="271" y="525" width="98" height="32" class="nonterminal"/>
    124. 

  124.    <text class="nonterminal" x="281" y="545">create_view</text>
    125. 

  125.    <rect x="273" y="571" width="104" height="32"/>
    126. 

  126.    <rect x="271" y="569" width="104" height="32" class="nonterminal"/>
    127. 

  127.    <text class="nonterminal" x="281" y="589">create_index</text>
    128. 

  128.    <rect x="273" y="615" width="186" height="32"/>
    129. 

  129.    <rect x="271" y="613" width="186" height="32" class="nonterminal"/>
    130. 

  130.    <text class="nonterminal" x="281" y="633">create_materialized_view</text>
    131. 

  131.    <rect x="293" y="659" width="58" height="32" rx="10"/>
    132. 

  132.    <rect x="291"
    133. 

  133.          y="657"
    134. 

  134.          width="58"
    135. 

  135.          height="32"
    136. 

  136.          class="terminal"
    137. 

  137.          rx="10"/>
    138. 

  138.    <text class="terminal" x="301" y="677">VIEW</text>
    139. 

  139.    <rect x="293" y="703" width="62" height="32" rx="10"/>
    140. 

  140.    <rect x="291"
    141. 

  141.          y="701"
    142. 

  142.          width="62"
    143. 

  143.          height="32"
    144. 

  144.          class="terminal"
    145. 

  145.          rx="10"/>
    146. 

  146.    <text class="terminal" x="301" y="721">INDEX</text>
    147. 

  147.    <rect x="293" y="747" width="166" height="32" rx="10"/>
    148. 

  148.    <rect x="291"
    149. 

  149.          y="745"
    150. 

  150.          width="166"
    151. 

  151.          height="32"
    152. 

  152.          class="terminal"
    153. 

  153.          rx="10"/>
    154. 

  154.    <text class="terminal" x="301" y="765">MATERIALIZED VIEW</text>
    155. 

  155.    <rect x="499" y="659" width="56" height="32"/>
    156. 

  156.    <rect x="497" y="657" width="56" height="32" class="nonterminal"/>
    157. 

  157.    <text class="nonterminal" x="507" y="677">name</text>
    158. 

  158.    <path class="line"
    159. 

  159.          d="m17 17 h2 m0 0 h10 m80 0 h10 m20 0 h10 m0 0 h372 m-402 0 h20 m382 0 h20 m-422 0 q10 0 10 10 m402 0 q0 -10 10 -10 m-412 10 v12 m402 0 v-12 m-402 12 q0 10 10 10 m382 0 q10 0 10 -10 m-372 10 h10 m0 0 h254 m-284 0 h20 m264 0 h20 m-304 0 q10 0 10 10 m284 0 q0 -10 10 -10 m-294 10 v12 m284 0 v-12 m-284 12 q0 10 10 10 m264 0 q10 0 10 -10 m-274 10 h10 m54 0 h10 m0 0 h190 m-274 -10 v20 m284 0 v-20 m-284 20 v24 m284 0 v-24 m-284 24 q0 10 10 10 m264 0 q10 0 10 -10 m-274 10 h10 m134 0 h10 m0 0 h110 m-274 -10 v20 m284 0 v-20 m-284 20 v24 m284 0 v-24 m-284 24 q0 10 10 10 m264 0 q10 0 10 -10 m-254 10 h10 m0 0 h96 m-126 0 h20 m106 0 h20 m-146 0 q10 0 10 10 m126 0 q0 -10 10 -10 m-136 10 v12 m126 0 v-12 m-126 12 q0 10 10 10 m106 0 q10 0 10 -10 m-116 10 h10 m86 0 h10 m20 -32 h10 m98 0 h10 m-274 -10 v20 m284 0 v-20 m-284 20 v56 m284 0 v-56 m-284 56 q0 10 10 10 m264 0 q10 0 10 -10 m-274 10 h10 m92 0 h10 m0 0 h152 m20 -196 h10 m58 0 h10 m22 -32 l2 0 m2 0 l2 0 m2 0 l2 0 m-552 338 l2 0 m2 0 l2 0 m2 0 l2 0 m22 0 h10 m68 0 h10 m20 0 h10 m124 0 h10 m-164 0 l20 0 m-1 0 q-9 0 -9 -10 l0 -24 q0 -10 10 -10 m144 44 l20 0 m-20 0 q10 0 10 -10 l0 -24 q0 -10 -10 -10 m-144 0 h10 m24 0 h10 m0 0 h100 m20 44 h10 m26 0 h10 m-338 0 h20 m318 0 h20 m-358 0 q10 0 10 10 m338 0 q0 -10 10 -10 m-348 10 v14 m338 0 v-14 m-338 14 q0 10 10 10 m318 0 q10 0 10 -10 m-328 10 h10 m0 0 h308 m40 -34 h10 m0 0 h168 m-198 0 h20 m178 0 h20 m-218 0 q10 0 10 10 m198 0 q0 -10 10 -10 m-208 10 v12 m198 0 v-12 m-198 12 q0 10 10 10 m178 0 q10 0 10 -10 m-188 10 h10 m40 0 h10 m20 0 h10 m56 0 h10 m0 0 h2 m-98 0 h20 m78 0 h20 m-118 0 q10 0 10 10 m98 0 q0 -10 10 -10 m-108 10 v24 m98 0 v-24 m-98 24 q0 10 10 10 m78 0 q10 0 10 -10 m-88 10 h10 m58 0 h10 m42 -76 l2 0 m2 0 l2 0 m2 0 l2 0 m-480 142 l2 0 m2 0 l2 0 m2 0 l2 0 m22 0 h10 m0 0 h58 m-88 0 h20 m68 0 h20 m-108 0 q10 0 10 10 m88 0 q0 -10 10 -10 m-98 10 v12 m88 0 v-12 m-88 12 q0 10 10 10 m68 0 q10 0 10 -10 m-78 10 h10 m48 0 h10 m40 -32 h10 m96 0 h10 m0 0 h186 m-322 0 h20 m302 0 h20 m-342 0 q10 0 10 10 m322 0 q0 -10 10 -10 m-332 10 v24 m322 0 v-24 m-322 24 q0 10 10 10 m302 0 q10 0 10 -10 m-312 10 h10 m98 0 h10 m0 0 h184 m-312 -10 v20 m322 0 v-20 m-322 20 v24 m322 0 v-24 m-322 24 q0 10 10 10 m302 0 q10 0 10 -10 m-312 10 h10 m104 0 h10 m0 0 h178 m-312 -10 v20 m322 0 v-20 m-322 20 v24 m322 0 v-24 m-322 24 q0 10 10 10 m302 0 q10 0 10 -10 m-312 10 h10 m186 0 h10 m0 0 h96 m-312 -10 v20 m322 0 v-20 m-322 20 v24 m322 0 v-24 m-322 24 q0 10 10 10 m302 0 q10 0 10 -10 m-292 10 h10 m58 0 h10 m0 0 h108 m-206 0 h20 m186 0 h20 m-226 0 q10 0 10 10 m206 0 q0 -10 10 -10 m-216 10 v24 m206 0 v-24 m-206 24 q0 10 10 10 m186 0 q10 0 10 -10 m-196 10 h10 m62 0 h10 m0 0 h104 m-196 -10 v20 m206 0 v-20 m-206 20 v24 m206 0 v-24 m-206 24 q0 10 10 10 m186 0 q10 0 10 -10 m-196 10 h10 m166 0 h10 m20 -88 h10 m56 0 h10 m23 -176 h-3"/>
    160. 

  160.    <polygon points="593 497 601 493 601 501"/>
    161. 

  161.    <polygon points="593 497 585 493 585 501"/>
    162. 

  162. </svg>
    163.