# How to restrict count of execute query for visualize in dashboards? **URL:** \ **Category:** Kibana\ **Created:** [May 30, 2018, 10:12am UTC](https://discuss.elastic.co/t/how-to-restrict-count-of-execute-query-for-visualize-in-dashboards/133853 "2018-05-30T10:12:22Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![alah64](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alah64/32/100065_2.png) [@alah64](https://discuss.elastic.co/u/alah64)\ **Post date:** [May 30, 2018, 10:12am UTC](https://discuss.elastic.co/t/how-to-restrict-count-of-execute-query-for-visualize-in-dashboards/133853/1 "2018-05-30T10:12:22Z")
my data exists in daily indices and 10-20 milion doc per indice ,with 32G memory for elastic jvm . when i run a dashboard elastice run at least 20 query that created by visualizes . , when i set time range between 1 and 7 days, All things are good. but for more days range, i have multiple issue: 1\_ kibana query timed out after 3 minute (seted by elasticsearch.requestTimeout). 2\_ elastic Continues to execute query for awhile after that 3 minutes. 3\_ breake down status appers. 4\_ i added more memory and no benefit. there is no problem if i set some filters (reduce the number of docs ) . i need some setting to restrict executing concurrent query count that created by dashboard, eg: 5 cuncurrent from all visualize in dashboard. and wait bar for another loading visualizes . ---
**Author:** ![alah64](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alah64/32/100065_2.png) [@alah64](https://discuss.elastic.co/u/alah64)\ **Post date:** [May 30, 2018, 11:19am UTC](https://discuss.elastic.co/t/how-to-restrict-count-of-execute-query-for-visualize-in-dashboards/133853/2 "2018-05-30T11:19:14Z")
this is jvm status while running dashboard , my command is: jstat -gcutil -h3 5539 5000 100 and result : ![gcutil](https://us1.discourse-cdn.com/elastic/original/3X/9/f/9f5effbbf5f00bde57f7e6956c4bc61473e24f5a.jpg) monitoring elastic shows : ![gcutil](https://us1.discourse-cdn.com/elastic/original/3X/c/e/cefc8bc54d126e6473e138866a023757b7ca9c80.jpg) ---
**Author:** ![alah64](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alah64/32/100065_2.png) [@alah64](https://discuss.elastic.co/u/alah64)\ **Post date:** [May 30, 2018, 11:47am UTC](https://discuss.elastic.co/t/how-to-restrict-count-of-execute-query-for-visualize-in-dashboards/133853/3 "2018-05-30T11:47:39Z")
i see long new generation gc and i think these steps occeurred: 1: while new generation gc , elastic is fully stopped 2: kibana timeout occurred 3: finally query execute continuing until finish ---
**Author:** ![lukas](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lukas/32/6812_2.png) [@lukas](https://discuss.elastic.co/u/lukas)\ **Post date:** [May 30, 2018, 4:44pm UTC](https://discuss.elastic.co/t/how-to-restrict-count-of-execute-query-for-visualize-in-dashboards/133853/4 "2018-05-30T16:44:14Z")
This isn't something you can currently do in Kibana, but if you'd like, you can file an enhancement request here: [https://github.com/elastic/kibana/issues/new?template=Feature\_request.md](https://github.com/elastic/kibana/issues/new?template=Feature_request.md) ---
**Author:** ![alah64](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alah64/32/100065_2.png) [@alah64](https://discuss.elastic.co/u/alah64)\ **Post date:** [June 2, 2018, 5:02am UTC](https://discuss.elastic.co/t/how-to-restrict-count-of-execute-query-for-visualize-in-dashboards/133853/5 "2018-06-02T05:02:27Z")
in my dashboard exists visualizes like line,bar,gauge,pie,region map ,data table,timelion and other. i finally found that "data table" take high amount of ram and it is cuse of breake down. my data table is top 10 source ip s that have more distinct destinations : ![gcutil](https://us1.discourse-cdn.com/elastic/original/3X/8/0/8038333fbffbde73642f5a36520581941b917a34.jpg) ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [June 30, 2018, 5:02am UTC](https://discuss.elastic.co/t/how-to-restrict-count-of-execute-query-for-visualize-in-dashboards/133853/6 "2018-06-30T05:02:27Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.