Hi Team, I am checking various metric queries with...
# support
h
Hi Team, I am checking various metric queries with SigNoz. I wonder if it is possible to query from SigNoz to the following PromQL. It hasn't been long since I used PromQL, so my query itself may be a problem. When verified in https://o11y.tools/promqlparser/, it was succeed and the test was conducted. • many-to-many query ◦ The query I tried :
otelcol_signoz_metric_points_count / on(job_name) group_left otelcol_signoz_metric_points_byte
◦ I got this error message : 'API responded with 400 - error in prom queries status: error, errors: {"A":{}}' • one-to-one query • example :
sum by (type) (job:tcpgw_forward_requests:rate5m:avg_over_time_1w{type="A"} + 3 * job:tcpgw_forward_requests:rate5m:stddev_over_time_1w{type="A"})
• time() ◦ example :
probe_ssl_earliest_cert_expiry - time()
• histogram_quantile() ◦ example :
histogram_quantile(0.95, rate(http_request_duration_seconds_bucket[5m]))
• sort() ◦ example :
sort(sum(kafka_burrow_partition_lag{topic!="__consumer_offsets",cluster="new"})by(topic,group))
◦ There is no error and the data comes out well, but it does not seem to be sorted, so I am inquiring. Thank you.
n
@Srikanth Chekuri might be able to help your here
s
Please mention which queries worked and which failed. It's not clear. Also share the error logs of the query-service when you run the failed queries.
h
In the case of time, histogram_quantile, many-to-many, the operation was confirmed in the signoz installed in another environment. One-to-one is checking query. However, the result value of sort is not sorted out. I would like to request to check sort(). • sort() ◦ example :
sort(sum(kafka_burrow_partition_lag{topic!="__consumer_offsets",cluster="new"})by(topic,group))
◦ There is no error and the data comes out well, but it does not seem to be sorted, so I am inquiring.