-
Notifications
You must be signed in to change notification settings - Fork 121
Description
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.