Pavel Vinokurov created IGNITE-7761:
---------------------------------------

             Summary: EXPLAIN with run time statistics
                 Key: IGNITE-7761
                 URL: https://issues.apache.org/jira/browse/IGNITE-7761
             Project: Ignite
          Issue Type: New Feature
          Components: sql
    Affects Versions: 2.3
            Reporter: Pavel Vinokurov


For performance tuning of the sql queries It is nice to have actual run time 
statistics of the query execution.

Statistics could include elapsed time and the number of rows for each query 
node.

Example:

 
||Rows||Actual Time||Plan Node|| ||
|1|5ms|group by city|Index scan using person.city|
|20|30ms|person.age=5|Full scan(person.age)|
|131231|50ms|person.name='John'|Index scan using person_name_idx|

 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to