promscale

alert: PromscaleDown
annotations:
  description: '{{ $labels.instance }} of job {{ $labels.job }} is down.'
  runbook_url: https://github.com/timescale/promscale/blob/master/docs/runbooks/PromscaleDown.md
  summary: Promscale is down.
expr: absent(up{job=~".*promscale.*"})
labels:
  severity: critical

alert: PromscaleIngestHighErrorRate
annotations:
  description: Promscale ingestion is having a {{ $value | humanizePercentage }} error
    rate.
  runbook_url: https://github.com/timescale/promscale/blob/master/docs/runbooks/PromscaleIngestHighErrorRate.md
  summary: High error rate in Promscale ingestion.
expr: |
  (
    sum by (job, instance, type) (
      rate(promscale_ingest_requests_total{code=~"5.."}[5m])
    )
  /
    sum by (job, instance, type) (
      rate(promscale_ingest_requests_total[5m])
    )
  ) > 0.05
labels:
  severity: warning

alert: PromscaleIngestHighErrorRate
annotations:
  description: Promscale ingestion is having a {{ $value | humanizePercentage }} error
    rate.
  runbook_url: https://github.com/timescale/promscale/blob/master/docs/runbooks/PromscaleIngestHighErrorRate.md
  summary: High error rate in Promscale ingestion.
expr: |
  (
    sum by (job, instance, type) (
      rate(promscale_ingest_requests_total{code=~"5.."}[5m])
    )
  /
    sum by (job, instance, type) (
      rate(promscale_ingest_requests_total[5m])
    )
  ) > 0.1
labels:
  severity: critical

alert: PromscaleIngestHighLatency
annotations:
  description: Slowest 10% of ingestion batch took more than {{ $value }} seconds
    to ingest.
  runbook_url: https://github.com/timescale/promscale/blob/master/docs/runbooks/PromscaleIngestHighLatency.md
  summary: Slow Promscale ingestion.
expr: |
  (
    histogram_quantile(
      0.90,
      sum by (job, instance, type, le) (
        rate(promscale_ingest_duration_seconds_bucket[5m])
      )
    ) > 10
  and
    sum by (job, instance, type) (
        rate(promscale_ingest_duration_seconds_bucket[5m])
    )
  ) > 0
for: 5m
labels:
  severity: warning

alert: PromscaleIngestHighLatency
annotations:
  description: Slowest 10% of ingestion batch took more than {{ $value }} seconds
    to ingest.
  runbook_url: https://github.com/timescale/promscale/blob/master/docs/runbooks/PromscaleIngestHighLatency.md
  summary: Slow Promscale ingestion.
expr: |
  (
    histogram_quantile(
      0.90,
      sum by (job, instance, type, le) (
        rate(promscale_ingest_duration_seconds_bucket[5m])
      )
    ) > 30
  and
    sum by (job, instance, type) (
        rate(promscale_ingest_duration_seconds_bucket[5m])
    )
  ) > 0
for: 5m
labels:
  severity: critical

alert: PromscaleQueryHighErrorRate
annotations:
  description: Evaluating queries via Promscale has {{ $value | humanizePercentage
    }} error rate.
  runbook_url: https://github.com/timescale/promscale/blob/master/docs/runbooks/PromscaleQueryHighErrorRate.md
  summary: High error rate in querying Promscale.
expr: |
  (
    sum by (job, instance, type) (
      rate(promscale_query_requests_total{code=~"5.."}[5m])
    )
  /
    sum by (job, instance, type) (
      rate(promscale_query_requests_total[5m])
    )
  ) > 0.05
labels:
  severity: warning

alert: PromscaleQueryHighErrorRate
annotations:
  description: Evaluating queries via Promscale had {{ $value | humanizePercentage
    }} error rate.
  runbook_url: https://github.com/timescale/promscale/blob/master/docs/runbooks/PromscaleQueryHighErrorRate.md
  summary: High error rate in querying Promscale.
expr: |
  (
    sum by (job, instance, type) (
      rate(promscale_query_requests_total{code=~"5.."}[5m])
    )
  /
    sum by (job, instance, type) (
      rate(promscale_query_requests_total[5m])
    )
  ) > 0.1
labels:
  severity: critical

alert: PromscaleQueryHighLatency
annotations:
  description: Slowest 10% of the queries took more than {{ $value }} seconds to evaluate.
  runbook_url: https://github.com/timescale/promscale/blob/master/docs/runbooks/PromscaleQueryHighLatency.md
  summary: Slow Promscale querying.
expr: |
  (
    histogram_quantile(
      0.90,
      sum by (job, instance, type, le) (
        rate(promscale_query_duration_seconds_bucket[5m])
      )
    ) > 5
  and
    sum by (job, instance, type) (
      rate(promscale_query_duration_seconds_bucket[5m])
    ) > 0
  )
for: 5m
labels:
  severity: warning

alert: PromscaleQueryHighLatency
annotations:
  description: Slowest 10% of the queries took {{ $value }} seconds to evaluate.
  runbook_url: https://github.com/timescale/promscale/blob/master/docs/runbooks/PromscaleQueryHighLatency.md
  summary: Slow Promscale querying.
expr: |
  (
    histogram_quantile(
      0.90,
      sum by (job, instance, type, le) (
        rate(promscale_query_duration_seconds_bucket[5m])
      )
    ) > 10
  and
    sum by (job, instance, type) (
      rate(promscale_query_duration_seconds_bucket[5m])
    ) > 0
  )
for: 5m
labels:
  severity: critical

alert: PromscaleCacheHighNumberOfEvictions
annotations:
  description: Promscale {{ $labels.name }} is evicting at {{ $value }} entries a
    second.
  runbook_url: https://github.com/timescale/promscale/blob/master/docs/runbooks/PromscaleCacheHighNumberOfEvictions.md
  summary: High cache eviction in Promscale.
expr: |
  (
    sum by (job, instance, name, type) (
      rate(promscale_cache_evictions_total[5m])
    )
  /
    sum by (job, instance, name, type) (
      promscale_cache_capacity_elements
    )
  ) > 0.2
labels:
  severity: warning

alert: PromscaleCacheTooSmall
annotations:
  description: Promscale {{ $labels.name }} has a hit ratio of {{ $value | humanizePercentage
    }}.
  runbook_url: https://github.com/timescale/promscale/blob/master/docs/runbooks/PromscaleCacheTooSmall.md
  summary: High cache eviction in Promscale.
expr: |
  (
    sum by (job, instance, type, name) (
      rate(promscale_cache_query_hits_total[5m])
    )
  /
    sum by (job, instance, type, name) (
      rate(promscale_cache_queries_total[5m])
    )
  ) < 0.9
labels:
  severity: warning

alert: PromscaleDBHighErrorRate
annotations:
  description: Promscale connection with the database has an error of {{ $value |
    humanizePercentage }}.
  runbook_url: https://github.com/timescale/promscale/blob/master/docs/runbooks/PromscaleDBHighErrorRate.md
  summary: Promscale experiences a high error rate when connecting to the database.
expr: |
  (
    sum by (job) (
      # Error counter exists for query, query_row & exec, and not for send_batch.
      rate(promscale_database_request_errors_total{method=~"query.*|exec"}[5m])
    )
  /
    sum by (job) (
      rate(promscale_database_requests_total{method=~"query.*|exec"}[5m])
    )
  ) > 0.05
labels:
  severity: warning

alert: PromscaleStorageHighLatency
annotations:
  description: Slowest 10% of database requests are taking more than {{ $value }}
    seconds to respond.
  runbook_url: https://github.com/timescale/promscale/blob/master/docs/runbooks/PromscaleStorageHighLatency.md
  summary: Slow database response.
expr: |
  (
    histogram_quantile(0.9,
      sum by (le, job, type) (
        rate(promscale_database_requests_duration_seconds_bucket[5m])
      )
    ) > 5
  and
    sum by (job, type) (
      rate(promscale_database_requests_duration_seconds_count[5m])
    ) > 0
  )
labels:
  severity: warning

alert: PromscaleStorageUnhealthy
annotations:
  description: Promscale connection with the database has an error of {{ $value |
    humanizePercentage }}.
  runbook_url: https://github.com/timescale/promscale/blob/master/docs/runbooks/PromscaleStorageUnhealthy.md
  summary: Promscale database is unhealthy.
expr: |
  (
    sum by (job) (
      rate(promscale_sql_database_health_check_errors_total[5m])
    )
  /
    sum by (job) (
      rate(promscale_sql_database_health_check_total[5m])
    )
  ) > 0.05
labels:
  severity: warning

alert: PromscaleMaintenanceJobRunningTooLong
annotations:
  description: Promscale Database is taking {{ $value }} seconds to respond to Promscale's
    requests.
  runbook_url: https://github.com/timescale/promscale/blob/master/docs/runbooks/PromscaleMaintenanceJobRunningTooLong.md
  summary: Promscale maintenance jobs taking too long to complete.
expr: |
  (
    (
      (
        time()
      -
        promscale_sql_database_worker_maintenance_job_start_timestamp_seconds
      )
        >
          30 * 60 * 2 # 30 mins (we launch maintenance jobs scheduled at 30 mins) * 60 (to seconds) * 2 (wait max for 2 complete scans before firing alert).
    )
  and
    promscale_sql_database_worker_maintenance_job_start_timestamp_seconds > 0
  )
labels:
  severity: warning

alert: PromscaleMaintenanceJobFailures
annotations:
  description: Maintenance job for Promscale instance {{ $labels.instance }} failed
    to successfully execute.
  runbook_url: https://github.com/timescale/promscale/blob/master/docs/runbooks/PromscaleMaintenanceJobFailures.md
  summary: Promscale maintenance job failed.
expr: promscale_sql_database_worker_maintenance_job_failed == 1
labels:
  severity: warning

alert: PromscaleCompressionLow
annotations:
  description: High uncompressed data in Promscale, on average, {{ $value }} uncompressed
    chunks per metric.
  runbook_url: https://github.com/timescale/promscale/blob/master/docs/runbooks/PromscaleCompressionLow.md
  summary: High uncompressed data.
expr: |
  (
    (
      (promscale_sql_database_chunks_count - promscale_sql_database_chunks_compressed_count) # Number of uncompressed chunks.
    /
      promscale_sql_database_metric_count
    ) > 4 # If total number of average uncompressed chunk per metric is more than 4 chunks at maximum, we should alert.
  and
    promscale_sql_database_compression_status == 1
  )
labels:
  severity: warning