Skip to content

Instantly share code, notes, and snippets.

@tkroman
Created November 21, 2018 16:27
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tkroman/2f472a0f3e57b2c59d4affe1d1e326ab to your computer and use it in GitHub Desktop.
Save tkroman/2f472a0f3e57b2c59d4affe1d1e326ab to your computer and use it in GitHub Desktop.
cqlsh:ks> delete from collection_table where k = 1;
Tracing session: 58c21de0-edaa-11e8-99e2-399d8477c401
activity | timestamp | source | source_elapsed | client
-------------------------------------------------------------------------+----------------------------+------------+----------------+------------
Execute CQL3 query | 2018-11-21 18:27:32.414000 | 172.17.0.6 | 0 | 172.17.0.1
Parsing delete from collection_table where k = 1; [SharedPool-Worker-1] | 2018-11-21 18:27:32.415000 | 172.17.0.6 | 1093 | 172.17.0.1
Preparing statement [SharedPool-Worker-1] | 2018-11-21 18:27:32.416000 | 172.17.0.6 | 1383 | 172.17.0.1
Determining replicas for mutation [SharedPool-Worker-1] | 2018-11-21 18:27:32.416000 | 172.17.0.6 | 1950 | 172.17.0.1
Appending to commitlog [SharedPool-Worker-2] | 2018-11-21 18:27:32.417000 | 172.17.0.6 | 2786 | 172.17.0.1
Adding to collection_table memtable [SharedPool-Worker-2] | 2018-11-21 18:27:32.417000 | 172.17.0.6 | 2970 | 172.17.0.1
Request complete | 2018-11-21 18:27:32.417371 | 172.17.0.6 | 3371 | 172.17.0.1
cqlsh:ks> select * from collection_table ;
k | l | m | s
---+---+---+---
(0 rows)
Tracing session: 5a7b8db0-edaa-11e8-99e2-399d8477c401
activity | timestamp | source | source_elapsed | client
-----------------------------------------------------------------------------------------------------------------------+----------------------------+------------+----------------+------------
Execute CQL3 query | 2018-11-21 18:27:35.307000 | 172.17.0.6 | 0 | 172.17.0.1
Parsing select * from collection_table ; [SharedPool-Worker-2] | 2018-11-21 18:27:35.308000 | 172.17.0.6 | 253 | 172.17.0.1
Preparing statement [SharedPool-Worker-2] | 2018-11-21 18:27:35.308000 | 172.17.0.6 | 465 | 172.17.0.1
Computing ranges to query [SharedPool-Worker-2] | 2018-11-21 18:27:35.308000 | 172.17.0.6 | 856 | 172.17.0.1
Submitting range requests on 257 ranges with a concurrency of 1 (0.0 rows per range expected) [SharedPool-Worker-2] | 2018-11-21 18:27:35.309000 | 172.17.0.6 | 1333 | 172.17.0.1
Executing seq scan across 0 sstables for (min(-9223372036854775808), min(-9223372036854775808)] [SharedPool-Worker-4] | 2018-11-21 18:27:35.310000 | 172.17.0.6 | 3135 | 172.17.0.1
Submitted 1 concurrent range requests [SharedPool-Worker-2] | 2018-11-21 18:27:35.317000 | 172.17.0.6 | 9284 | 172.17.0.1
Read 0 live and 0 tombstone cells [SharedPool-Worker-4] | 2018-11-21 18:27:35.318000 | 172.17.0.6 | 10691 | 172.17.0.1
Request complete | 2018-11-21 18:27:35.317801 | 172.17.0.6 | 10801 | 172.17.0.1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment