I get more than 1000 elasticsearch records, but grafana only shows 500 rows in the table, how do I change this? Help please.
There is a default size limit of 500 on terms queries. Set the size property in your query to set a custom limit. You can use other variables inside the query.
hi,danie
We update to grafana7,the new features is very awesome.
but there are some questions in table panel:
1.in the past ,i use ăraw documentă to some the field of elasticsearch,but grafana7 can not do this.when i setting raw document,it will show all the field.
2.logs provide this feature,but it canât show more then 500 rows,i try to setting âsizeâ in panel json,but it can not work, please tell me how to do.
Have a good day
Hi everyone,
I am experiencing similar issues - my Flux query returns all the rows I want from InfluxDB, as evident from the Query Inspector. However I cannot get them show all on the Logs Panel. 500 seems to be about the limit (havenât counted).
Is there any way to set the Panel to show more rows? The âmax data pointsâ setting in the query options doesnât make any differenceâŚ
Hi, I have faced the same issue before but here is the workaround.
Instead of using the Logs you can use âRaw Dataâ option , which has a size property and you can set it up to max of 10K.
To show the data in table data format, I have used âOrganize fieldsâ under Transform and it populates a list of all available columns in each log record and one can choose what to show and what not to.
Hope this helps
2 Likes
