ignite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pavel Vinokurov (JIRA)" <j...@apache.org>
Subject [jira] [Created] (IGNITE-7761) EXPLAIN with run time statistics
Date Tue, 20 Feb 2018 08:15:05 GMT
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)

Mime
View raw message