Hey I have an issue. I'm collctiong datapoint with...
# support
g
Hey I have an issue. I'm collctiong datapoint with httpcheck to ping a service to see if it's up. Doing with an interval of 30s. But working with t I had strange issue where I can see I have no data. Looking at the DB I see that I have data only every hours One of my httpcheck is like
Copy code
receivers:
  # 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
Copy code
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 │
    └──────────────┴───────────────┘