NO OF ROWS SCANNED IN A TABLE FOR A DATABASE OPERATION

[Jahnavi latha]

Hi

 I am trying to know the number of rows got scanned for select operation with condition.

Is there any way in tarantool sql to know the number of rows scanned for a select operation with condition.Please help me in this.

Tried with "explain" and "explain query plan".In output it is not displaying number of rows scanned.

explain output:

tarantool> box.execute([[explain select *from "users2" where "id" > 1]])

---

- metadata:

  - name: addr

    type: integer

  - name: opcode

    type: text

  - name: p1

    type: integer

  - name: p2

    type: integer

  - name: p3

    type: integer

  - name: p4

    type: text

  - name: p5

    type: text

  - name: comment

    type: text

  rows:

  - [0, 'Init', 0, 1, 0, '', '00', null]

  - [1, 'IteratorOpen', 1, 0, 0, 'space<name=users2>', '00', null]

  - [2, 'Integer', 1, 1, 0, '', '00', null]

  - [3, 'ApplyType', 1, 1, 0, "\x01", '00', null]

  - [4, 'SeekGT', 1, 10, 1, '1', '01', null]

  - [5, 'Column', 1, 0, 2, '', '00', null]

  - [6, 'Column', 1, 1, 3, '', '00', null]

  - [7, 'Column', 1, 2, 4, '', '00', null]

  - [8, 'ResultRow', 2, 3, 0, '', '00', null]

  - [9, 'Next', 1, 5, 0, '', '00', null]

  - [10, 'Halt', 0, 0, 0, '', '00', null]

explain query plan output:

tarantool> box.execute([[explain query plan select *from "users2" where "id" > 1]])

---

- metadata:

  - name: selectid

    type: integer

  - name: order

    type: integer

  - name: from

    type: integer

  - name: detail

    type: text

  rows:

  - [0, 0, 0, 'SEARCH TABLE users2 USING PRIMARY KEY (id>?) (~262144 rows)']

Thank you,

MV Jahnavi latha