You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@ignite.apache.org by "Pavel Vinokurov (JIRA)" <ji...@apache.org> on 2018/02/20 08:15:05 UTC

[jira] [Created] (IGNITE-7761) EXPLAIN with run time statistics

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)