Skip to content

Instantly share code, notes, and snippets.

@mstump

mstump/cassandara_tombstones.promql

Last active February 5, 2020 16:46
Show Gist options
  • Save mstump/abf9f7643424b3b2ef0cb693700af2bc to your computer and use it in GitHub Desktop.
Save mstump/abf9f7643424b3b2ef0cb693700af2bc to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. Matt Stump revised this gist Feb 5, 2020. 1 changed file with 5 additions and 1 deletion.
    6 changes: 5 additions & 1 deletion cassandara_tombstones.promql
    View file
    Original file line number Diff line number Diff line change
    @@ -1,5 +1,9 @@
    # PromQL query looking for outliers in Cassandra tombstone activity
    # (mean tombstones scanned in Cassandra - the rolling average of the same value)
    # divided by the standard deviation

    (
    ( mean_tombstones_scanned_avg{service="CASSANDRA"}
    ( mean_tombstones_scanned_avg{service="CASSANDRA"}
    - avg_over_time(mean_tombstones_scanned_avg{service="CASSANDRA"}[1d])
    )
    / (stddev_over_time(mean_tombstones_scanned_avg{service="CASSANDRA"}[1d]))
  2. Matt Stump revised this gist Feb 5, 2020. 1 changed file with 6 additions and 1 deletion.
    7 changes: 6 additions & 1 deletion cassandara_tombstones.promql
    View file
    Original file line number Diff line number Diff line change
    @@ -1 +1,6 @@
    ((mean_tombstones_scanned_avg{service="CASSANDRA"} - avg_over_time(mean_tombstones_scanned_avg{service="CASSANDRA"}[1d]))/(stddev_over_time(mean_tombstones_scanned_avg{service="CASSANDRA"}[1d])))
    (
    ( mean_tombstones_scanned_avg{service="CASSANDRA"}
    - avg_over_time(mean_tombstones_scanned_avg{service="CASSANDRA"}[1d])
    )
    / (stddev_over_time(mean_tombstones_scanned_avg{service="CASSANDRA"}[1d]))
    )
  3. Matt Stump created this gist Feb 3, 2020.
    1 change: 1 addition & 0 deletions cassandara_tombstones.promql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1 @@
    ((mean_tombstones_scanned_avg{service="CASSANDRA"} - avg_over_time(mean_tombstones_scanned_avg{service="CASSANDRA"}[1d]))/(stddev_over_time(mean_tombstones_scanned_avg{service="CASSANDRA"}[1d])))