duyet/clickhouse-monitoring

Self tracking monitoring dashboard

Closed this issue · 0 comments

CREATE TABLE IF NOT EXISTS system.monitoring_ui_log (
  kind Enum('pageview', 'user_kill_query', 'system_kill_query'),
  actor LowCardinality(String),
  message String,
  event_time DateTime,
  event_date Date
) ENGINE = MergeTree
PARTITION BY toYYYYMMDD(event_time)
ORDER BY event_time