Gil
05/21/2025, 7:32 AMreceivers:
# Healthcheck - un receiver par service
httpcheck/passport:
collection_interval: 30s
targets:
- endpoint: "<https://foobar.com/healthcheck>"
method: GET
tls:
insecure_skip_verify: true
In the db I do
SELECT
DISTINCT(CAST(JSONExtractString(labels, 'health_score') AS Int32)) AS health_score,
unix_milli
FROM signoz_metrics.time_series_v4
WHERE
metric_name = 'httpcheck_status'
AND JSONExtractString(labels, 'service_name') = 'PASSPORT'
AND JSONExtractString(labels, 'deployment_environment') = 'DEV08'
AND JSONExtractString(labels, 'health_score') IS NOT NULL
AND JSONExtractString(labels, 'health_score') != ''
AND JSONExtractString(labels, 'health_score') != '0'
ORDER BY unix_milli DESC
Query id: cc24e792-b1b7-4329-84b2-6960482ea16f
┌─health_score─┬────unix_milli─┐
1. │ 3 │ 1747810800000 │
2. │ 3 │ 1747807200000 │
3. │ 3 │ 1747803600000 │
4. │ 3 │ 1747800000000 │
5. │ 3 │ 1747796400000 │
6. │ 3 │ 1747792800000 │
7. │ 3 │ 1747789200000 │
8. │ 3 │ 1747785600000 │
9. │ 3 │ 1747782000000 │
10. │ 3 │ 1747778400000 │
11. │ 3 │ 1747774800000 │
12. │ 3 │ 1747771200000 │
13. │ 3 │ 1747767600000 │
14. │ 3 │ 1747764000000 │
15. │ 3 │ 1747760400000 │
16. │ 3 │ 1747756800000 │
17. │ 3 │ 1747753200000 │
18. │ 3 │ 1747749600000 │
└──────────────┴───────────────┘