mirror of https://gitee.com/bigwinds/arangodb
43 lines
2.9 KiB
Plaintext
43 lines
2.9 KiB
Plaintext
arangosh> db._profileQuery(<span class="hljs-string">`
|
|
........> FOR doc IN acollection
|
|
........> FILTER doc.value < 10
|
|
........> RETURN doc`</span>, {}, {<span class="hljs-attr">colors</span>: <span class="hljs-literal">false</span>}
|
|
........> );
|
|
Query <span class="hljs-built_in">String</span> (<span class="hljs-number">58</span> chars, <span class="hljs-attr">cacheable</span>: <span class="hljs-literal">false</span>):
|
|
FOR doc IN acollection
|
|
FILTER doc.value < <span class="hljs-number">10</span>
|
|
RETURN doc
|
|
|
|
Execution plan:
|
|
Id NodeType Calls Items Runtime [s] Comment
|
|
<span class="hljs-number">1</span> SingletonNode <span class="hljs-number">1</span> <span class="hljs-number">1</span> <span class="hljs-number">0.00000</span> * ROOT
|
|
<span class="hljs-number">6</span> IndexNode <span class="hljs-number">1</span> <span class="hljs-number">10</span> <span class="hljs-number">0.00009</span> - FOR doc IN acollection <span class="hljs-comment">/* skiplist index scan */</span>
|
|
<span class="hljs-number">5</span> ReturnNode <span class="hljs-number">1</span> <span class="hljs-number">10</span> <span class="hljs-number">0.00000</span> - RETURN doc
|
|
|
|
Indexes used:
|
|
By Name Type Collection Unique Sparse Selectivity Fields Ranges
|
|
<span class="hljs-number">6</span> idx_1646382028474548226 skiplist acollection <span class="hljs-literal">false</span> <span class="hljs-literal">false</span> <span class="hljs-number">100.00</span> % [ <span class="hljs-string">`value`</span> ] (doc.<span class="hljs-string">`value`</span> < <span class="hljs-number">10</span>)
|
|
|
|
Optimization rules applied:
|
|
Id RuleName
|
|
<span class="hljs-number">1</span> use-indexes
|
|
<span class="hljs-number">2</span> remove-filter-covered-by-index
|
|
<span class="hljs-number">3</span> remove-unnecessary-calculations<span class="hljs-number">-2</span>
|
|
|
|
Query Statistics:
|
|
Writes Exec Writes Ign Scan Full Scan Index Filtered Exec Time [s]
|
|
<span class="hljs-number">0</span> <span class="hljs-number">0</span> <span class="hljs-number">0</span> <span class="hljs-number">10</span> <span class="hljs-number">0</span> <span class="hljs-number">0.00037</span>
|
|
|
|
Query Profile:
|
|
Query Stage Duration [s]
|
|
initializing <span class="hljs-number">0.00000</span>
|
|
parsing <span class="hljs-number">0.00004</span>
|
|
optimizing ast <span class="hljs-number">0.00000</span>
|
|
loading collections <span class="hljs-number">0.00001</span>
|
|
instantiating plan <span class="hljs-number">0.00001</span>
|
|
optimizing plan <span class="hljs-number">0.00010</span>
|
|
executing <span class="hljs-number">0.00011</span>
|
|
finalizing <span class="hljs-number">0.00007</span>
|
|
|
|
|