# Kibana Dashboard loading Issue

**URL:** <https://discuss.elastic.co/t/kibana-dashboard-loading-issue/326702>\
**Category:** Kibana\
**Tags:** dashboard\
**Created:** [February 28, 2023, 6:44pm UTC](https://discuss.elastic.co/t/kibana-dashboard-loading-issue/326702 "2023-02-28T18:44:42Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![rohitguptaggg](https://avatars.discourse-cdn.com/v4/letter/r/a9a28c/32.png) [@rohitguptaggg](https://discuss.elastic.co/u/rohitguptaggg)\
**Post date:** [February 28, 2023, 6:44pm UTC](https://discuss.elastic.co/t/kibana-dashboard-loading-issue/326702/1 "2023-02-28T18:44:42Z")

</div>

Hello,

I have created a Kibana dashboard using a filter and query, but it is causing loading issues and the Elasticsearch CPU is going up to 99%, even though there are 3 Elasticsearch nodes. Can someone please help and suggest how to handle this type of query for the dashboard and provide some query optimization techniques to solve this issue? also please help with teh some suggestion for the best practices so that i can improve my dashboards to load fatser .

The query used for the dashboard is given below.

```auto
{
  "query": {
    "bool": {
      "must_not": [
        {
          "wildcard": {
            "payload.data.details.keyword": "[j-*]*onConnectionFailure*"
          }
        },
        {
          "wildcard": {
            "payload.data.details.keyword": "_reconnectDevices: onError Exception: maximum number of retries reached*"
          }
        },
        {
          "wildcard": {
            "payload.data.details.keyword": "*Sanity check: Finished log uploading unsuccessfully*"
          }
        },
        {
          "wildcard": {
            "payload.data.details.keyword": "*upload logs InternetConnectionException Instance of 'InternetConnectionException*"
          }
        },
        {
          "wildcard": {
            "payload.data.details.keyword": "*set slow params error:PlatformException(i not ready*is not initialized or has been disposed, {details: *, message: Device not reachable*"
          }
        },
        {
          "wildcard": {
            "payload.data.details.keyword": "*[j-*] Bluetooth stack returned GATT error status 133*"
          }
        },
        {
          "wildcard": {
            "payload.data.details.keyword": "*HAT download error caused by com.medtronic.minimed.connect.ble*GATT service is not provided by the server*"
          }
        },
        {
          "wildcard": {
            "payload.data.details.keyword": "*HAT download error *Exception occurred in transfer block parsing*"
          }
        },
        {
          "wildcard": {
            "payload.data.details.keyword": "*HAT download error caused by *Actual payload length*doesn't match the expected (567)*"
          }
        }
      ]
    }
  }
}

```

Thank you.

---

<div class="post-metadata">

**Author:** ![carly.richmond](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/carly.richmond/32/104935_2.png) [@carly.richmond](https://discuss.elastic.co/u/carly.richmond)\
**Post date:** [March 1, 2023, 10:41am UTC](https://discuss.elastic.co/t/kibana-dashboard-loading-issue/326702/2 "2023-03-01T10:41:31Z")

</div>

Hi @rohitguptaggg,

I would recommend running the query using the [Search Profiler](https://www.elastic.co/guide/en/kibana/current/xpack-profiler.html) or [Profile API](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-profile.html) if you can to see the bottlenecks.

Looking at your query and checking the warning in the [`wildcard` documentation](https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-wildcard-query.html) the clauses starting with \* characters will be expensive:

> Avoid beginning patterns with `*` or `?` . This can increase the iterations needed to find matching terms and slow search performance.

I would recommend removing the preceding `*` from terms if you can.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [March 29, 2023, 10:42am UTC](https://discuss.elastic.co/t/kibana-dashboard-loading-issue/326702/3 "2023-03-29T10:42:08Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.