ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vladimir Ozerov (JIRA)" <j...@apache.org>
Subject [jira] [Closed] (IGNITE-7761) EXPLAIN with run time statistics
Date Thu, 14 Feb 2019 08:04:00 GMT

     [ 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)

Mime
View raw message