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
Example PromQL query for outliers
Raw
cassandara_tombstones.promql
# 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"}
- avg_over_time(mean_tombstones_scanned_avg{service="CASSANDRA"}[1d])
)
/ (stddev_over_time(mean_tombstones_scanned_avg{service="CASSANDRA"}[1d]))
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment