Ivan Fedorenkov created IGNITE-14981:
----------------------------------------
Summary: Explain analyze query doesn't show the scan count
Key: IGNITE-14981
URL: https://issues.apache.org/jira/browse/IGNITE-14981
Project: Ignite
Issue Type: Bug
Components: sql
Affects Versions: 2.10
Reporter: Ivan Fedorenkov
Right now, it is impossible to get the scan count using the "explain analyze"
query (e.g. using the sqlline.sh tool).
The only known workaround is to set the query execution time threshold to some
very low number which forces ignite to log every SQL query execution plan. This
workaround can't be used in production for the obvious reasons.
Example:
{noformat}
0: jdbc:ignite:thin://<host>:10800> explain analyze select count(*) from
<table>;
+--------------------------------+
| PLAN |
+--------------------------------+
| SELECT
COUNT(*) AS __C0_0
FROM PUBLIC.<table> __Z0
/* PUBLIC.<table>.__SCAN_ */
/* direct lookup */ |
| SELECT
CAST(SUM(__C0_0) AS BIGINT) AS __C0_0
FROM PUBLIC.__T0
/* PUBLIC."merge_scan" */ |
+--------------------------------+
2 rows selected (0.036 seconds){noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
