High amount of memory usage in grafana on certain queries

[33Fraise33]

Hello,

I have noticed if I request 14 days or a month of data on the 5g accessability dashboard for rach 5012a and 5013a the memory usage in grafana is huge. Is there any specific reason for this? We are also sometimes receiving status 429 from opensearch on those queries when we change to a larger timeframe. I notice you request 75 metrics in one of those queries, can this be more optimal?

[soursing]

@33Fraise33 NDAC pmdata API only send counters generated by Radio, KPI calculation should be done at grafana, so we've to use all the counter.

OpenSearch 429 error code occurs due to high memory/ CPU usage, you can consider to increase OpenSearch heap_size.

[soursing]

@33Fraise33 We've added improvement in KPI queries in 4.6.1 release, please check if you're getting the issue with latest release.