Hi all. I just started using Grafana but I am experiencing some difficulties with setting Elasticsearch query in Grafana. The goal is to create the chart that will display server memory usage per different processes. I defined the following fields: Query: beat.name:beatServerName Metric: Average …

you can investigate the query & the response, here is a guide: [image] How to troubleshoot metric query issues How To If you get a panel query error or not seeing the data you expect to see the most important thing to do is view the query Grafana sends to your database an…

Did you investigate the query sent by grafana and the elasticsearch response? (open chrome dev tools network tab)

Hi Torkel, This is how request looks: {"search_type":"query_then_fetch","ignore_unavailable":true,"index":["logstash-2017.05.13"]} {"size":0,"query":{"bool":{"filter":[{"range":{"@timestamp":{"gte":"1494681900389","lte":"1494703500389","format":"epoch_millis"}}},{"query_string":{"analyze_wildcard"…

No hits, make sure the lucene filter is correct, are you using correct case (maybe some char needs to be upper case)

In Elasticsearch data source settings I changed Index name to [metricbeat-]YYYY.MM.DD The query is: {"search_type":"query_then_fetch","ignore_unavailable":true,"index":["metricbeat-2017.05.13"]} {"size":0,"query":{"bool":{"filter":[{"range":{"@timestamp":{"gte":"1494701295851","lte":"1494704895851…

X axis mode should be time series

That helped, thanks a lot. I faced another issue: When I select data range Last 6 hours, there is chart displayed with data, but when I select date range Last 1 hour - there is no any data on chart: [image]

[image] john018: 1494704867926 I’ve experienced something similar when my server timestamp didn’t match the expected range. You might check that the epoch dates being sent are not “in the future” according to the elastic server.

Also check the FAQ section on the community, there is an topic there for that scenario (zoom in and no data)

Data is written to ES every 10s. I set Group by time interval as >20s but I can see chart with data for the period not later then Last 1 hour. Though in Kibana period Last 20s works good and shows the data. Is it expected result?

Maybe there is a time difference between your ES server or collector and your browser time?

Wrong Elasticsearch query

Grafana Elasticsearch

torkel May 18, 2017, 5:49am 14

you can investigate the query & the response, here is a guide:

Topic		Replies	Views
Can't query elasticsearch data source from grafana	1	6435	June 7, 2017
Problem query Graylog's Elasticsearch with Grafana Elasticsearch	3	2183	July 22, 2017
Grafana won't talk to Elasticsearch instance Grafana	4	3842	September 11, 2017
Data is empty from elastic data source Dashboards plugins	2	955	August 17, 2022
ElasticSearch data viz is not working as expected Grafana	0	697	October 18, 2021

Wrong Elasticsearch query

Related topics