Logs query is not giving all the results always, i...
# support
p
Logs query is not giving all the results always, if you see in this image below, there are 4 such logs seen from histogram but actually below we see only 1 log
n
can you share the API calls for
query_range
api’s from the network tab when you run the query, there should be two calls
p
Copy code
curl '<https://signoz.dev.itribe.in/api/v3/query_range>' \
  -H 'sec-ch-ua: "Not/A)Brand";v="8", "Chromium";v="126", "Google Chrome";v="126"' \
  -H 'sec-ch-ua-mobile: ?0' \
  -H 'Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbWFpbCI6InBydXRodmlAaXRyaWJlLmluIiwiZXhwIjoxNzIwNTgyNDI5LCJnaWQiOiIwNmU3NzM5Yy0wOTkyLTQxNDItODMyNS1mOGEzZWNlMDk0MmQiLCJpZCI6ImYxMTQ0YWQxLTQ4NGItNGE2Ni04YzA2LTlmMmViZWZhYTFmMiJ9.BcLYFp_1ULlqGorGAdKCAZY9LJE__43d7uC_cqfOLJQ' \
  -H 'User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36' \
  -H 'Content-Type: application/json' \
  -H 'Accept: application/json, text/plain, */*' \
  -H 'Referer: <https://signoz.dev.itribe.in/logs/logs-explorer?options=%7B%22selectColumns%22%3A%5B%5D%2C%22maxLines%22%3A20%2C%22format%22%3A%22raw%22%7D&compositeQuery=%257B%2522queryType%2522%253A%2522builder%2522%252C%2522builder%2522%253A%257B%2522queryData%2522%253A%255B%257B%2522dataSource%2522%253A%2522logs%2522%252C%2522queryName%2522%253A%2522A%2522%252C%2522aggregateOperator%2522%253A%2522noop%2522%252C%2522aggregateAttribute%2522%253A%257B%2522id%2522%253A%2522------false%2522%252C%2522dataType%2522%253A%2522%2522%252C%2522key%2522%253A%2522%2522%252C%2522isColumn%2522%253Afalse%252C%2522type%2522%253A%2522%2522%252C%2522isJSON%2522%253Afalse%257D%252C%2522timeAggregation%2522%253A%2522rate%2522%252C%2522spaceAggregation%2522%253A%2522sum%2522%252C%2522functions%2522%253A%255B%255D%252C%2522filters%2522%253A%257B%2522items%2522%253A%255B%257B%2522id%2522%253A%252249612f20%2522%252C%2522key%2522%253A%257B%2522key%2522%253A%2522k8s.cluster.name%2522%252C%2522dataType%2522%253A%2522string%2522%252C%2522type%2522%253A%2522resource%2522%252C%2522isColumn%2522%253Afalse%252C%2522isJSON%2522%253Afalse%252C%2522id%2522%253A%2522k8s.cluster.name--string--resource--false%2522%257D%252C%2522op%2522%253A%2522%253D%2522%252C%2522value%2522%253A%2522prod%2522%257D%252C%257B%2522id%2522%253A%2522eddaa4af%2522%252C%2522key%2522%253A%257B%2522key%2522%253A%2522k8s.container.name%2522%252C%2522dataType%2522%253A%2522string%2522%252C%2522type%2522%253A%2522resource%2522%252C%2522isColumn%2522%253Afalse%252C%2522isJSON%2522%253Afalse%252C%2522id%2522%253A%2522k8s.container.name--string--resource--false%2522%257D%252C%2522op%2522%253A%2522%253D%2522%252C%2522value%2522%253A%2522tralkserver%2522%257D%252C%257B%2522id%2522%253A%2522922b808a%2522%252C%2522key%2522%253A%257B%2522key%2522%253A%2522body%2522%252C%2522dataType%2522%253A%2522string%2522%252C%2522type%2522%253A%2522%2522%252C%2522isColumn%2522%253Atrue%252C%2522isJSON%2522%253Afalse%252C%2522id%2522%253A%2522body--string----true%2522%257D%252C%2522op%2522%253A%2522contains%2522%252C%2522value%2522%253A%2522leads%2522%257D%252C%257B%2522id%2522%253A%2522c1896fce%2522%252C%2522key%2522%253A%257B%2522key%2522%253A%2522body%2522%252C%2522dataType%2522%253A%2522string%2522%252C%2522type%2522%253A%2522%2522%252C%2522isColumn%2522%253Atrue%252C%2522isJSON%2522%253Afalse%252C%2522id%2522%253A%2522body--string----true%2522%257D%252C%2522op%2522%253A%2522contains%2522%252C%2522value%2522%253A%2522RANJIT%2520KUMAR%2520PANDIT%2522%257D%255D%252C%2522op%2522%253A%2522AND%2522%257D%252C%2522expression%2522%253A%2522A%2522%252C%2522disabled%2522%253Afalse%252C%2522stepInterval%2522%253A60%252C%2522having%2522%253A%255B%255D%252C%2522limit%2522%253Anull%252C%2522orderBy%2522%253A%255B%257B%2522columnName%2522%253A%2522timestamp%2522%252C%2522order%2522%253A%2522desc%2522%257D%255D%252C%2522groupBy%2522%253A%255B%255D%252C%2522legend%2522%253A%2522%2522%252C%2522reduceTo%2522%253A%2522avg%2522%257D%255D%252C%2522queryFormulas%2522%253A%255B%255D%257D%252C%2522promql%2522%253A%255B%257B%2522name%2522%253A%2522A%2522%252C%2522query%2522%253A%2522%2522%252C%2522legend%2522%253A%2522%2522%252C%2522disabled%2522%253Afalse%257D%255D%252C%2522clickhouse_sql%2522%253A%255B%257B%2522name%2522%253A%2522A%2522%252C%2522legend%2522%253A%2522%2522%252C%2522disabled%2522%253Afalse%252C%2522query%2522%253A%2522%2522%257D%255D%252C%2522id%2522%253A%2522f88fdb52-fc18-4992-bcaf-fe1a2152e20f%2522%257D&timeRange=%7B%22start%22%3A1720494382000%2C%22end%22%3A1720580632000%2C%22pageSize%22%3A3%7D&relativeTime=1d>' \
  -H 'sec-ch-ua-platform: "macOS"' \
  --data-raw '{"start":1720494402000,"end":1720580802000,"step":240,"variables":{},"compositeQuery":{"queryType":"builder","panelType":"graph","fillGaps":false,"builderQueries":{"A":{"dataSource":"logs","queryName":"A","aggregateOperator":"count","aggregateAttribute":{"id":"------false","dataType":"","key":"","isColumn":false,"type":"","isJSON":false},"timeAggregation":"rate","spaceAggregation":"sum","functions":[],"filters":{"items":[{"id":"49612f20","key":{"key":"k8s.cluster.name","dataType":"string","type":"resource","isColumn":false,"isJSON":false,"id":"k8s.cluster.name--string--resource--false"},"op":"=","value":"prod"},{"id":"eddaa4af","key":{"key":"k8s.container.name","dataType":"string","type":"resource","isColumn":false,"isJSON":false,"id":"k8s.container.name--string--resource--false"},"op":"=","value":"tralkserver"},{"id":"922b808a","key":{"key":"body","dataType":"string","type":"","isColumn":true,"isJSON":false,"id":"body--string----true"},"op":"contains","value":"leads"},{"id":"c1896fce","key":{"key":"body","dataType":"string","type":"","isColumn":true,"isJSON":false,"id":"body--string----true"},"op":"contains","value":"RANJIT KUMAR PANDIT"}],"op":"AND"},"expression":"A","disabled":false,"stepInterval":60,"having":[],"limit":null,"orderBy":[{"columnName":"timestamp","order":"desc"}],"groupBy":[],"legend":"","reduceTo":"avg"}}}}'
Copy code
curl '<https://signoz.dev.itribe.in/api/v3/query_range>' \
  -H 'sec-ch-ua: "Not/A)Brand";v="8", "Chromium";v="126", "Google Chrome";v="126"' \
  -H 'sec-ch-ua-mobile: ?0' \
  -H 'Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbWFpbCI6InBydXRodmlAaXRyaWJlLmluIiwiZXhwIjoxNzIwNTgyNDI5LCJnaWQiOiIwNmU3NzM5Yy0wOTkyLTQxNDItODMyNS1mOGEzZWNlMDk0MmQiLCJpZCI6ImYxMTQ0YWQxLTQ4NGItNGE2Ni04YzA2LTlmMmViZWZhYTFmMiJ9.BcLYFp_1ULlqGorGAdKCAZY9LJE__43d7uC_cqfOLJQ' \
  -H 'User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.0.0 Safari/537.36' \
  -H 'Content-Type: application/json' \
  -H 'Accept: application/json, text/plain, */*' \
  -H 'Referer: <https://signoz.dev.itribe.in/logs/logs-explorer?options=%7B%22selectColumns%22%3A%5B%5D%2C%22maxLines%22%3A20%2C%22format%22%3A%22raw%22%7D&compositeQuery=%257B%2522queryType%2522%253A%2522builder%2522%252C%2522builder%2522%253A%257B%2522queryData%2522%253A%255B%257B%2522dataSource%2522%253A%2522logs%2522%252C%2522queryName%2522%253A%2522A%2522%252C%2522aggregateOperator%2522%253A%2522noop%2522%252C%2522aggregateAttribute%2522%253A%257B%2522id%2522%253A%2522------false%2522%252C%2522dataType%2522%253A%2522%2522%252C%2522key%2522%253A%2522%2522%252C%2522isColumn%2522%253Afalse%252C%2522type%2522%253A%2522%2522%252C%2522isJSON%2522%253Afalse%257D%252C%2522timeAggregation%2522%253A%2522rate%2522%252C%2522spaceAggregation%2522%253A%2522sum%2522%252C%2522functions%2522%253A%255B%255D%252C%2522filters%2522%253A%257B%2522items%2522%253A%255B%257B%2522id%2522%253A%252249612f20%2522%252C%2522key%2522%253A%257B%2522key%2522%253A%2522k8s.cluster.name%2522%252C%2522dataType%2522%253A%2522string%2522%252C%2522type%2522%253A%2522resource%2522%252C%2522isColumn%2522%253Afalse%252C%2522isJSON%2522%253Afalse%252C%2522id%2522%253A%2522k8s.cluster.name--string--resource--false%2522%257D%252C%2522op%2522%253A%2522%253D%2522%252C%2522value%2522%253A%2522prod%2522%257D%252C%257B%2522id%2522%253A%2522eddaa4af%2522%252C%2522key%2522%253A%257B%2522key%2522%253A%2522k8s.container.name%2522%252C%2522dataType%2522%253A%2522string%2522%252C%2522type%2522%253A%2522resource%2522%252C%2522isColumn%2522%253Afalse%252C%2522isJSON%2522%253Afalse%252C%2522id%2522%253A%2522k8s.container.name--string--resource--false%2522%257D%252C%2522op%2522%253A%2522%253D%2522%252C%2522value%2522%253A%2522tralkserver%2522%257D%252C%257B%2522id%2522%253A%2522922b808a%2522%252C%2522key%2522%253A%257B%2522key%2522%253A%2522body%2522%252C%2522dataType%2522%253A%2522string%2522%252C%2522type%2522%253A%2522%2522%252C%2522isColumn%2522%253Atrue%252C%2522isJSON%2522%253Afalse%252C%2522id%2522%253A%2522body--string----true%2522%257D%252C%2522op%2522%253A%2522contains%2522%252C%2522value%2522%253A%2522leads%2522%257D%252C%257B%2522id%2522%253A%2522c1896fce%2522%252C%2522key%2522%253A%257B%2522key%2522%253A%2522body%2522%252C%2522dataType%2522%253A%2522string%2522%252C%2522type%2522%253A%2522%2522%252C%2522isColumn%2522%253Atrue%252C%2522isJSON%2522%253Afalse%252C%2522id%2522%253A%2522body--string----true%2522%257D%252C%2522op%2522%253A%2522contains%2522%252C%2522value%2522%253A%2522RANJIT%2520KUMAR%2520PANDIT%2522%257D%255D%252C%2522op%2522%253A%2522AND%2522%257D%252C%2522expression%2522%253A%2522A%2522%252C%2522disabled%2522%253Afalse%252C%2522stepInterval%2522%253A60%252C%2522having%2522%253A%255B%255D%252C%2522limit%2522%253Anull%252C%2522orderBy%2522%253A%255B%257B%2522columnName%2522%253A%2522timestamp%2522%252C%2522order%2522%253A%2522desc%2522%257D%255D%252C%2522groupBy%2522%253A%255B%255D%252C%2522legend%2522%253A%2522%2522%252C%2522reduceTo%2522%253A%2522avg%2522%257D%255D%252C%2522queryFormulas%2522%253A%255B%255D%257D%252C%2522promql%2522%253A%255B%257B%2522name%2522%253A%2522A%2522%252C%2522query%2522%253A%2522%2522%252C%2522legend%2522%253A%2522%2522%252C%2522disabled%2522%253Afalse%257D%255D%252C%2522clickhouse_sql%2522%253A%255B%257B%2522name%2522%253A%2522A%2522%252C%2522legend%2522%253A%2522%2522%252C%2522disabled%2522%253Afalse%252C%2522query%2522%253A%2522%2522%257D%255D%252C%2522id%2522%253A%2522f88fdb52-fc18-4992-bcaf-fe1a2152e20f%2522%257D&timeRange=%7B%22start%22%3A1720494382000%2C%22end%22%3A1720580632000%2C%22pageSize%22%3A3%7D&relativeTime=1d>' \
  -H 'sec-ch-ua-platform: "macOS"' \
  --data-raw '{"start":1720494402000,"end":1720580802000,"step":240,"variables":{},"compositeQuery":{"queryType":"builder","panelType":"list","fillGaps":false,"builderQueries":{"A":{"dataSource":"logs","queryName":"A","aggregateOperator":"noop","aggregateAttribute":{"id":"------false","dataType":"","key":"","isColumn":false,"type":"","isJSON":false},"timeAggregation":"rate","spaceAggregation":"sum","functions":[],"filters":{"items":[{"id":"49612f20","key":{"key":"k8s.cluster.name","dataType":"string","type":"resource","isColumn":false,"isJSON":false,"id":"k8s.cluster.name--string--resource--false"},"op":"=","value":"prod"},{"id":"eddaa4af","key":{"key":"k8s.container.name","dataType":"string","type":"resource","isColumn":false,"isJSON":false,"id":"k8s.container.name--string--resource--false"},"op":"=","value":"tralkserver"},{"id":"922b808a","key":{"key":"body","dataType":"string","type":"","isColumn":true,"isJSON":false,"id":"body--string----true"},"op":"contains","value":"leads"},{"id":"c1896fce","key":{"key":"body","dataType":"string","type":"","isColumn":true,"isJSON":false,"id":"body--string----true"},"op":"contains","value":"RANJIT KUMAR PANDIT"}],"op":"AND"},"expression":"A","disabled":false,"stepInterval":60,"having":[],"limit":null,"orderBy":[{"columnName":"timestamp","order":"desc"}],"groupBy":[],"legend":"","reduceTo":"avg","offset":0,"pageSize":100}}}}'