Examples for histogram about promcasa HOT 3 CLOSED

Hello @senja7r this is mostly up to your ClickHouse query being a histogram.
Is there an example as of what you're trying to achieve?

from promcasa.

Hello, @lmangani.

There is a table log_nginx (see attachment lognginx.txt pls.) where nginx logs are written. The table is just an example, there are a lot of endpoints(url). I need a histogram of request durations for each endpoint(url) to export to VictoriaMetrics.

For example:

<sub>#HELP obrm_request_duration_seconds Histogram of latencies for HTTP requests.
#TYPE obrm_request_duration_seconds histogram
obrm_request_duration_seconds_count{url="obrm-core.merto.nt/htpm-engine/rest/engine"}
obrm_request_duration_seconds_sum{url="obrm-core.merto.nt/htpm-engine/rest/engine"}
obrm_request_duration_seconds_bucket{le="+Inf", url="obrm-core.merto.nt/htpm-engine/rest/engine"}
obrm_request_duration_seconds_bucket{le="12", url="obrm-core.merto.nt/htpm-engine/rest/engine"}
obrm_request_duration_seconds_bucket{le="10", url="obrm-core.merto.nt/htpm-engine/rest/engine"}
obrm_request_duration_seconds_bucket{le="5",url="obrm-core.merto.nt/htpm-engine/rest/engine"}
obrm_request_duration_seconds_bucket{le="2.5"url="obrm-core.merto.nt/htpm-engine/rest/engine"}
obrm_request_duration_seconds_bucket{le="1",url="obrm-core.merto.nt/htpm-engine/rest/engine"}
obrm_request_duration_seconds_bucket{le="0.5"url="obrm-core.merto.nt/htpm-engine/rest/engine"}
obrm_request_duration_seconds_bucket{le="0.25", url="obrm-core.merto.nt/htpm-engine/rest/engine"}
obrm_request_duration_seconds_bucket{le="0.1", url="obrm-core.merto.nt/htpm-engine/rest/engine"}
obrm_request_duration_seconds_bucket{le="0.05", url="obrm-core.merto.nt/htpm-engine/rest/engine"}
obrm_request_duration_seconds_bucket{le="0.025", url="obrm-core.merto.nt/htpm-engine/rest/engine"}
obrm_request_duration_seconds_bucket{le="0.01", url="obrm-core.merto.nt/htpm-engine/rest/engine"}
obrm_request_duration_seconds_bucket{le="0.005", url="obrm-core.merto.nt/htpm-engine/rest/engine"}


obrm_request_duration_seconds_count{url="obrm-core.merto.nt/djkm-aggregates/v2/process/id"}
obrm_request_duration_seconds_sum{url="obrm-core.merto.nt/djkm-aggregates/v2/process/id"}
obrm_request_duration_seconds_bucket{le="+Inf", url="obrm-core.merto.nt/djkm-aggregates/v2/process/id"}
obrm_request_duration_seconds_bucket{le="12", url="obrm-core.merto.nt/djkm-aggregates/v2/process/id"}
obrm_request_duration_seconds_bucket{le="10", url="obrm-core.merto.nt/djkm-aggregates/v2/process/id"}
obrm_request_duration_seconds_bucket{le="5",url="obrm-core.merto.nt/djkm-aggregates/v2/process/id"}
obrm_request_duration_seconds_bucket{le="2.5"url="obrm-core.merto.nt/djkm-aggregates/v2/process/id"}
obrm_request_duration_seconds_bucket{le="1",url="obrm-core.merto.nt/djkm-aggregates/v2/process/id"}
obrm_request_duration_seconds_bucket{le="0.5"url="obrm-core.merto.nt/djkm-aggregates/v2/process/id"}
obrm_request_duration_seconds_bucket{le="0.25", url="obrm-core.merto.nt/djkm-aggregates/v2/process/id"}
obrm_request_duration_seconds_bucket{le="0.1", url="obrm-core.merto.nt/djkm-aggregates/v2/process/id"}
obrm_request_duration_seconds_bucket{le="0.05", url="obrm-core.merto.nt/djkm-aggregates/v2/process/id"}
obrm_request_duration_seconds_bucket{le="0.025", url="obrm-core.merto.nt/djkm-aggregates/v2/process/id"}
obrm_request_duration_seconds_bucket{le="0.01", url="obrm-core.merto.nt/djkm-aggregates/v2/process/id"}
obrm_request_duration_seconds_bucket{le="0.005", url="obrm-core.merto.nt/djkm-aggregates/v2/process/id"}</sub>

and so on.

Thank you in advance.

lognginx.txt

from promcasa.

@senja7r can you please show your config (query) ?

from promcasa.