Skip to content

Instantly share code, notes, and snippets.

@sontek
Created May 1, 2015 22:53
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 sontek/060b8a801e9545053bce to your computer and use it in GitHub Desktop.
Save sontek/060b8a801e9545053bce to your computer and use it in GitHub Desktop.
cassandra tracing gist
Tracing session: 43c34fb0-f054-11e4-8ca4-b9a936855b1e
activity | timestamp | source | source_elapsed
---------------------------------------------------------------------------------------------------------+----------------------------+---------------+----------------
Execute CQL3 query | 2015-05-01 15:49:03.275000 | 10.128.36.179 | 0
Parsing select * from hour_response where survey_id=100326883 and hour_created=1; [SharedPool-Worker-1] | 2015-05-01 15:49:03.277000 | 10.128.36.179 | 110
Preparing statement [SharedPool-Worker-1] | 2015-05-01 15:49:03.277000 | 10.128.36.179 | 275
Sending message to /10.128.36.193 [WRITE-/10.128.36.193] | 2015-05-01 15:49:03.278000 | 10.128.36.179 | 795
Sending message to /10.128.36.195 [WRITE-/10.128.36.195] | 2015-05-01 15:49:04.024000 | 10.128.36.179 | 749072
Message received from /10.128.36.193 [Thread-16] | 2015-05-01 15:49:04.864000 | 10.128.36.179 | 588381
Processing response from /10.128.36.193 [SharedPool-Worker-2] | 2015-05-01 15:49:04.868000 | 10.128.36.179 | 588766
Message received from /10.128.36.195 [Thread-14] | 2015-05-01 15:49:05.520000 | 10.128.36.179 | --
Processing response from /10.128.36.195 [SharedPool-Worker-1] | 2015-05-01 15:49:05.521000 | 10.128.36.179 | --
Message received from /10.128.36.179 [Thread-32] | 2015-05-01 15:49:31.440000 | 10.128.36.195 | 73
Executing single-partition query on hour_response [SharedPool-Worker-2] | 2015-05-01 15:49:31.441000 | 10.128.36.195 | 613
Acquiring sstable references [SharedPool-Worker-2] | 2015-05-01 15:49:31.441000 | 10.128.36.195 | 650
Merging memtable tombstones [SharedPool-Worker-2] | 2015-05-01 15:49:31.441000 | 10.128.36.195 | 687
Key cache hit for sstable 13 [SharedPool-Worker-2] | 2015-05-01 15:49:31.442000 | 10.128.36.195 | 771
Seeking to partition beginning in data file [SharedPool-Worker-2] | 2015-05-01 15:49:31.442000 | 10.128.36.195 | 1253
Skipped 0/1 non-slice-intersecting sstables, included 0 due to tombstones [SharedPool-Worker-2] | 2015-05-01 15:49:31.443000 | 10.128.36.195 | 4215
Merging data from memtables and 1 sstables [SharedPool-Worker-2] | 2015-05-01 15:49:31.444000 | 10.128.36.195 | 4284
Message received from /10.128.36.179 [Thread-11] | 2015-05-01 15:49:31.612000 | 10.128.36.193 | 27
Executing single-partition query on hour_response [SharedPool-Worker-1] | 2015-05-01 15:49:31.613000 | 10.128.36.193 | 219
Acquiring sstable references [SharedPool-Worker-1] | 2015-05-01 15:49:31.614000 | 10.128.36.193 | 228
Merging memtable tombstones [SharedPool-Worker-1] | 2015-05-01 15:49:31.614000 | 10.128.36.193 | 270
Key cache hit for sstable 11 [SharedPool-Worker-1] | 2015-05-01 15:49:31.615000 | 10.128.36.193 | 333
Seeking to partition beginning in data file [SharedPool-Worker-1] | 2015-05-01 15:49:31.615000 | 10.128.36.193 | 338
Skipped 0/1 non-slice-intersecting sstables, included 0 due to tombstones [SharedPool-Worker-1] | 2015-05-01 15:49:31.616000 | 10.128.36.193 | 668
Merging data from memtables and 1 sstables [SharedPool-Worker-1] | 2015-05-01 15:49:31.617000 | 10.128.36.193 | 687
Read 102326 live and 0 tombstoned cells [SharedPool-Worker-2] | 2015-05-01 15:49:32.132000 | 10.128.36.195 | 692498
Enqueuing response to /10.128.36.179 [SharedPool-Worker-2] | 2015-05-01 15:49:32.133000 | 10.128.36.195 | 693563
Sending message to /10.128.36.179 [WRITE-/10.128.36.179] | 2015-05-01 15:49:32.133000 | 10.128.36.195 | 693944
Read 102326 live and 0 tombstoned cells [SharedPool-Worker-1] | 2015-05-01 15:49:32.145000 | 10.128.36.193 | 533100
Enqueuing response to /10.128.36.179 [SharedPool-Worker-1] | 2015-05-01 15:49:32.147000 | 10.128.36.193 | 533482
Sending message to /10.128.36.179 [WRITE-/10.128.36.179] | 2015-05-01 15:49:32.150000 | 10.128.36.193 | 533584
Request complete | 2015-05-01 15:49:05.109028 | 10.128.36.179 | 834028
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment