[
https://issues.apache.org/jira/browse/CASSANDRA-17380?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17511258#comment-17511258
]
Benjamin Lerer commented on CASSANDRA-17380:
--------------------------------------------
[~gimhana.ds] As first step you should look into {{SelectStatement}} to try to
understand what are the different types of information that are used in order
to execute a query.
What you should try to determine from the code how to identify:
* the type of query: `full scan`, `single partition slice`, `multi partition
range`, `secondary index`
* the set of rows being requested
* the consistency level
* if the query is filtering or not
* if the query perform aggregation
* the size of the page
* if there is a limit or not
> Add support for EXPLAIN statements
> ----------------------------------
>
> Key: CASSANDRA-17380
> URL: https://issues.apache.org/jira/browse/CASSANDRA-17380
> Project: Cassandra
> Issue Type: Improvement
> Reporter: Benjamin Lerer
> Priority: Normal
> Labels: gsoc, gsoc2022
>
> We should provide users a way to understand how their query will be executed
> and some information on the amount of work that will be performed.
> Explain statements are the most common way to do that.
> A CEP Draft has been open for that: [(DRAFT) CEP-4:
> Explain|https://docs.google.com/document/d/1s_gc4TDYdDbHnYHHVxxjqVVUn3MONUqG6W2JehnC11g/edit].
> This draft propose to add support for {{EXPLAIN}} and {{EXPLAIN ANALYZE}}
> but I believe that we should split the work in 2 parts because a simple
> {{EXPLAIN}} would already provide relevant information.
> To complete this work I believe that the following steps will be required:
> * Rework and submit the CEP
> * Add missing statistics
> * Implements the logic behind the EXPLAIN statements
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]