When we got 100k rows from the plugin, then Logs panel stuck, let's try to avoid it
Grafana plugin make two requests,
first aggregating like
SELECT toStartOfInterval("event_time", INTERVAL 1 MINUTE) as "time", sum(multiSearchAny(toString("level"), ['critical','fatal','crit','alert','emerg','CRITICAL','FATAL','CRIT','ALERT','EMERG','Critical','Fatal','Crit','Alert','Emerg'])) as critical, sum(multiSearchAny(toString("level"), ['error','err','eror','ERROR','ERR','EROR','Error','Err','Eror'])) as error, sum(multiSearchAny(toString("level"), ['warn','warning','WARN','WARNING','Warn','Warning'])) as warn, sum(multiSearchAny(toString("level"), ['info','information','informational','INFO','INFORMATION','INFORMATIONAL','Info','Information','Informational'])) as info, sum(multiSearchAny(toString("level"), ['debug','dbug','DEBUG','DBUG','Debug','Dbug'])) as debug, sum(multiSearchAny(toString("level"), ['trace','TRACE','Trace'])) as trace, sum(multiSearchAny(toString("level"), ['unknown','UNKNOWN','Unknown'])) as unknown FROM "system"."text_log" WHERE ( time >= $__fromTime AND time <= $__toTime ) GROUP BY time ORDER BY time ASC
second
SELECT ... WHERE ... LIMIT 1000
our plugin return warning in https://localhost:3000/explore
altinity-cloud-managed-clickhouse-prod. This datasource does not support full-range histograms. The graph below is based on the logs seen in the response.
When we got 100k rows from the plugin, then Logs panel stuck, let's try to avoid it
Grafana plugin make two requests,
first aggregating like
SELECT toStartOfInterval("event_time", INTERVAL 1 MINUTE) as "time", sum(multiSearchAny(toString("level"), ['critical','fatal','crit','alert','emerg','CRITICAL','FATAL','CRIT','ALERT','EMERG','Critical','Fatal','Crit','Alert','Emerg'])) as critical, sum(multiSearchAny(toString("level"), ['error','err','eror','ERROR','ERR','EROR','Error','Err','Eror'])) as error, sum(multiSearchAny(toString("level"), ['warn','warning','WARN','WARNING','Warn','Warning'])) as warn, sum(multiSearchAny(toString("level"), ['info','information','informational','INFO','INFORMATION','INFORMATIONAL','Info','Information','Informational'])) as info, sum(multiSearchAny(toString("level"), ['debug','dbug','DEBUG','DBUG','Debug','Dbug'])) as debug, sum(multiSearchAny(toString("level"), ['trace','TRACE','Trace'])) as trace, sum(multiSearchAny(toString("level"), ['unknown','UNKNOWN','Unknown'])) as unknown FROM "system"."text_log" WHERE ( time >= $__fromTime AND time <= $__toTime ) GROUP BY time ORDER BY time ASCsecond
SELECT ... WHERE ... LIMIT 1000our plugin return warning in
https://localhost:3000/explorealtinity-cloud-managed-clickhouse-prod. This datasource does not support full-range histograms. The graph below is based on the logs seen in the response.