1
0
Fork 0
arangodb/Documentation/Examples/06_workWithAQL_statementsEx...

44 lines
2.8 KiB
Plaintext

arangosh&gt; db._query(<span class="hljs-string">`
........&gt; FOR i IN 1..@count INSERT
........&gt; { _key: CONCAT('anothertest', TO_STRING(i)) }
........&gt; INTO mycollection`</span>,
........&gt; {<span class="hljs-attr">count</span>: <span class="hljs-number">100</span>},
........&gt; {},
........&gt; {<span class="hljs-attr">fullCount</span>: <span class="hljs-literal">true</span>}
........&gt; ).getExtra();
{
<span class="hljs-string">"stats"</span> : {
<span class="hljs-string">"writesExecuted"</span> : <span class="hljs-number">100</span>,
<span class="hljs-string">"writesIgnored"</span> : <span class="hljs-number">0</span>,
<span class="hljs-string">"scannedFull"</span> : <span class="hljs-number">0</span>,
<span class="hljs-string">"scannedIndex"</span> : <span class="hljs-number">0</span>,
<span class="hljs-string">"filtered"</span> : <span class="hljs-number">0</span>,
<span class="hljs-string">"httpRequests"</span> : <span class="hljs-number">0</span>,
<span class="hljs-string">"fullCount"</span> : <span class="hljs-number">0</span>,
<span class="hljs-string">"executionTime"</span> : <span class="hljs-number">0.0022063255310058594</span>,
<span class="hljs-string">"peakMemoryUsage"</span> : <span class="hljs-number">98744</span>
},
<span class="hljs-string">"warnings"</span> : [ ]
}
arangosh&gt; db._query({
........&gt; <span class="hljs-string">"query"</span>: <span class="hljs-string">`FOR i IN 200..@count INSERT
........&gt; { _key: CONCAT('anothertest', TO_STRING(i)) }
........&gt; INTO mycollection`</span>,
........&gt; <span class="hljs-string">"bindVars"</span>: {<span class="hljs-attr">count</span>: <span class="hljs-number">300</span>},
........&gt; <span class="hljs-string">"options"</span>: { <span class="hljs-attr">fullCount</span>: <span class="hljs-literal">true</span>}
........&gt; }).getExtra();
{
<span class="hljs-string">"stats"</span> : {
<span class="hljs-string">"writesExecuted"</span> : <span class="hljs-number">101</span>,
<span class="hljs-string">"writesIgnored"</span> : <span class="hljs-number">0</span>,
<span class="hljs-string">"scannedFull"</span> : <span class="hljs-number">0</span>,
<span class="hljs-string">"scannedIndex"</span> : <span class="hljs-number">0</span>,
<span class="hljs-string">"filtered"</span> : <span class="hljs-number">0</span>,
<span class="hljs-string">"httpRequests"</span> : <span class="hljs-number">0</span>,
<span class="hljs-string">"fullCount"</span> : <span class="hljs-number">0</span>,
<span class="hljs-string">"executionTime"</span> : <span class="hljs-number">0.0019061565399169922</span>,
<span class="hljs-string">"peakMemoryUsage"</span> : <span class="hljs-number">98744</span>
},
<span class="hljs-string">"warnings"</span> : [ ]
}