[ 
https://issues.apache.org/jira/browse/CASSANDRA-18861?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17767889#comment-17767889
 ] 

Stefan Miklosovic commented on CASSANDRA-18861:
-----------------------------------------------

examples of the output:

{code}
cassandra@cqlsh> list USERS ;

 name      | super | datacenters
-----------+-------+-------------
 cassandra |  True |         ALL

(1 rows, 12ms elapsed)
{code}

{code}
cassandra@cqlsh> update myks.mytb SET name = 'stefan' WHERE id = 1;
cassandra@cqlsh> update myks.mytb SET name = 'stefan' WHERE id = 1 IF exists;

 [applied]
-----------
      True

(36ms elapsed)
{code}

{code}
cassandra@cqlsh> BEGIN BATCH insert into myks.mytb (id, name) VALUES (1, 
'joe'); APPLY BATCH;
cassandra@cqlsh> BEGIN BATCH insert into myks.mytb (id, name) VALUES (1, 'joe') 
IF NOT EXISTS ; APPLY BATCH;

 [applied] | id | name
-----------+----+------
     False |  1 |  joe

(8ms elapsed)
{code}

It is interesting to see that elapsed time is written only for CAS statements. 
So if I do this when one statement is CAS and another is not:

{code}
cassandra@cqlsh> BEGIN BATCH insert into myks.mytb (id, name) VALUES (1, 'joe') 
IF NOT EXISTS; insert into myks.mytb (id, name) VALUES (1, 'joe'); APPLY BATCH;

 [applied] | id | name
-----------+----+------
     False |  1 |  joe

(9ms elapsed)
{code}

It will basically take into account not the time of whole batch but only of 
statements which are CAS. So it will leave out another one from the elapsed 
time computation.

> add time elapsed for simple CQL statement in the cql shell
> ----------------------------------------------------------
>
>                 Key: CASSANDRA-18861
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-18861
>             Project: Cassandra
>          Issue Type: Improvement
>          Components: CQL/Semantics
>            Reporter: Ling Mao
>            Assignee: Ling Mao
>            Priority: Normal
>             Fix For: 5.x
>
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to