Skip to content

Add support status Histogram for Explore -> logs #782

@Slach

Description

@Slach

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.

Metadata

Metadata

Labels

Type

No type

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions