arangodb/Documentation/Examples/09_workWithAQL_statementsPl...

arangosh&gt; <span class="hljs-keyword">var</span> stmt = db._createStatement(
........&gt; <span class="hljs-string">`FOR doc IN @@collection FILTER doc.user == @user RETURN doc`</span>
........&gt; );
arangosh&gt; stmt.bind({ <span class="hljs-string">"@collection"</span> : <span class="hljs-string">"_users"</span>, <span class="hljs-string">"user"</span> : <span class="hljs-string">"root"</span> });
arangosh&gt; stmt.explain();
{
  <span class="hljs-string">"plan"</span> : {
    <span class="hljs-string">"nodes"</span> : [
      {
        <span class="hljs-string">"type"</span> : <span class="hljs-string">"SingletonNode"</span>,
        <span class="hljs-string">"dependencies"</span> : [ ],
        <span class="hljs-string">"id"</span> : <span class="hljs-number">1</span>,
        <span class="hljs-string">"estimatedCost"</span> : <span class="hljs-number">1</span>,
        <span class="hljs-string">"estimatedNrItems"</span> : <span class="hljs-number">1</span>
      },
      {
        <span class="hljs-string">"type"</span> : <span class="hljs-string">"IndexNode"</span>,
        <span class="hljs-string">"dependencies"</span> : [
          <span class="hljs-number">1</span>
        ],
        <span class="hljs-string">"id"</span> : <span class="hljs-number">6</span>,
        <span class="hljs-string">"estimatedCost"</span> : <span class="hljs-number">2.04475</span>,
        <span class="hljs-string">"estimatedNrItems"</span> : <span class="hljs-number">1</span>,
        <span class="hljs-string">"outVariable"</span> : {
          <span class="hljs-string">"id"</span> : <span class="hljs-number">0</span>,
          <span class="hljs-string">"name"</span> : <span class="hljs-string">"doc"</span>
        },
        <span class="hljs-string">"projections"</span> : [ ],
        <span class="hljs-string">"producesResult"</span> : <span class="hljs-literal">true</span>,
        <span class="hljs-string">"database"</span> : <span class="hljs-string">"_system"</span>,
        <span class="hljs-string">"collection"</span> : <span class="hljs-string">"_users"</span>,
        <span class="hljs-string">"satellite"</span> : <span class="hljs-literal">false</span>,
        <span class="hljs-string">"needsGatherNodeSort"</span> : <span class="hljs-literal">false</span>,
        <span class="hljs-string">"indexCoversProjections"</span> : <span class="hljs-literal">false</span>,
        <span class="hljs-string">"indexes"</span> : [
          {
            <span class="hljs-string">"id"</span> : <span class="hljs-string">"46"</span>,
            <span class="hljs-string">"type"</span> : <span class="hljs-string">"hash"</span>,
            <span class="hljs-string">"name"</span> : <span class="hljs-string">"idx_1646382023744421888"</span>,
            <span class="hljs-string">"fields"</span> : [
              <span class="hljs-string">"user"</span>
            ],
            <span class="hljs-string">"selectivityEstimate"</span> : <span class="hljs-number">1</span>,
            <span class="hljs-string">"unique"</span> : <span class="hljs-literal">true</span>,
            <span class="hljs-string">"sparse"</span> : <span class="hljs-literal">true</span>,
            <span class="hljs-string">"deduplicate"</span> : <span class="hljs-literal">true</span>
          }
        ],
        <span class="hljs-string">"condition"</span> : {
          <span class="hljs-string">"type"</span> : <span class="hljs-string">"n-ary or"</span>,
          <span class="hljs-string">"typeID"</span> : <span class="hljs-number">63</span>,
          <span class="hljs-string">"subNodes"</span> : [
            {
              <span class="hljs-string">"type"</span> : <span class="hljs-string">"n-ary and"</span>,
              <span class="hljs-string">"typeID"</span> : <span class="hljs-number">62</span>,
              <span class="hljs-string">"subNodes"</span> : [
                {
                  <span class="hljs-string">"type"</span> : <span class="hljs-string">"compare =="</span>,
                  <span class="hljs-string">"typeID"</span> : <span class="hljs-number">25</span>,
                  <span class="hljs-string">"excludesNull"</span> : <span class="hljs-literal">false</span>,
                  <span class="hljs-string">"subNodes"</span> : [
                    {
                      <span class="hljs-string">"type"</span> : <span class="hljs-string">"attribute access"</span>,
                      <span class="hljs-string">"typeID"</span> : <span class="hljs-number">35</span>,
                      <span class="hljs-string">"name"</span> : <span class="hljs-string">"user"</span>,
                      <span class="hljs-string">"subNodes"</span> : [
                        {
                          <span class="hljs-string">"type"</span> : <span class="hljs-string">"reference"</span>,
                          <span class="hljs-string">"typeID"</span> : <span class="hljs-number">45</span>,
                          <span class="hljs-string">"name"</span> : <span class="hljs-string">"doc"</span>,
                          <span class="hljs-string">"id"</span> : <span class="hljs-number">0</span>
                        }
                      ]
                    },
                    {
                      <span class="hljs-string">"type"</span> : <span class="hljs-string">"value"</span>,
                      <span class="hljs-string">"typeID"</span> : <span class="hljs-number">40</span>,
                      <span class="hljs-string">"value"</span> : <span class="hljs-string">"root"</span>,
                      <span class="hljs-string">"vType"</span> : <span class="hljs-string">"string"</span>,
                      <span class="hljs-string">"vTypeID"</span> : <span class="hljs-number">4</span>
                    }
                  ]
                }
              ]
            }
          ]
        },
        <span class="hljs-string">"sorted"</span> : <span class="hljs-literal">true</span>,
        <span class="hljs-string">"ascending"</span> : <span class="hljs-literal">true</span>,
        <span class="hljs-string">"reverse"</span> : <span class="hljs-literal">false</span>,
        <span class="hljs-string">"evalFCalls"</span> : <span class="hljs-literal">true</span>,
        <span class="hljs-string">"limit"</span> : <span class="hljs-number">0</span>
      },
      {
        <span class="hljs-string">"type"</span> : <span class="hljs-string">"ReturnNode"</span>,
        <span class="hljs-string">"dependencies"</span> : [
          <span class="hljs-number">6</span>
        ],
        <span class="hljs-string">"id"</span> : <span class="hljs-number">5</span>,
        <span class="hljs-string">"estimatedCost"</span> : <span class="hljs-number">3.04475</span>,
        <span class="hljs-string">"estimatedNrItems"</span> : <span class="hljs-number">1</span>,
        <span class="hljs-string">"inVariable"</span> : {
          <span class="hljs-string">"id"</span> : <span class="hljs-number">0</span>,
          <span class="hljs-string">"name"</span> : <span class="hljs-string">"doc"</span>
        },
        <span class="hljs-string">"count"</span> : <span class="hljs-literal">true</span>
      }
    ],
    <span class="hljs-string">"rules"</span> : [
      <span class="hljs-string">"use-indexes"</span>,
      <span class="hljs-string">"remove-filter-covered-by-index"</span>,
      <span class="hljs-string">"remove-unnecessary-calculations-2"</span>
    ],
    <span class="hljs-string">"collections"</span> : [
      {
        <span class="hljs-string">"name"</span> : <span class="hljs-string">"_users"</span>,
        <span class="hljs-string">"type"</span> : <span class="hljs-string">"read"</span>
      }
    ],
    <span class="hljs-string">"variables"</span> : [
      {
        <span class="hljs-string">"id"</span> : <span class="hljs-number">2</span>,
        <span class="hljs-string">"name"</span> : <span class="hljs-string">"1"</span>
      },
      {
        <span class="hljs-string">"id"</span> : <span class="hljs-number">0</span>,
        <span class="hljs-string">"name"</span> : <span class="hljs-string">"doc"</span>
      }
    ],
    <span class="hljs-string">"estimatedCost"</span> : <span class="hljs-number">3.04475</span>,
    <span class="hljs-string">"estimatedNrItems"</span> : <span class="hljs-number">1</span>,
    <span class="hljs-string">"initialize"</span> : <span class="hljs-literal">true</span>,
    <span class="hljs-string">"isModificationQuery"</span> : <span class="hljs-literal">false</span>
  },
  <span class="hljs-string">"warnings"</span> : [ ],
  <span class="hljs-string">"stats"</span> : {
    <span class="hljs-string">"rulesExecuted"</span> : <span class="hljs-number">36</span>,
    <span class="hljs-string">"rulesSkipped"</span> : <span class="hljs-number">0</span>,
    <span class="hljs-string">"plansCreated"</span> : <span class="hljs-number">1</span>
  },
  <span class="hljs-string">"cacheable"</span> : <span class="hljs-literal">true</span>
}