Grafana Dashboard freeze when backend Bigquery Table add search index on jsonPayload

Grafana Dashboards
1

  • What Grafana version and what operating system are you using?
    Grafana v9.5.5, OSS, on Rocky 8

  • What are you trying to achieve?
    The dashboard visualizes backend BigQuery Table, and I am trying to reduce the memory cost for running the queries in the panels.

  • How are you trying to achieve it?
    I added a search index on the jsonpayload column(which has 19 nested columns).
    Here is the DDL:
    CREATE SEARCH INDEX all_search_index
    ON <My_Table_Name>(jsonPayload)
    OPTIONS (analyzer = ‘LOG_ANALYZER’);

  • What happened?
    Most of the panels of the Grafana dashboard freezes.
    But the same SQL in the GCP Cloud console returns with lower memory usage as expected

  • What did you expect to happen?
    Grafana should stay responsive.

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
    It displays “No data”