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

Posted to issues@ignite.apache.org by "Vladimir Ozerov (JIRA)" <ji...@apache.org> on 2019/02/14 08:04:00 UTC

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

     [ https://issues.apache.org/jira/browse/IGNITE-7761?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Vladimir Ozerov closed IGNITE-7761.
-----------------------------------

> 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
>            Priority: Major
>
> 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)