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

Reply via email to