ClickHouse analytics DB

Install

emisar pack install validates the pack and verifies its content hash before copying it into /etc/emisar/packs. The --hash below pins the install to the exact bytes on this page — a tampered copy is rejected. After install, reload the runner; it re-reads the catalog and advertises every action.

content hash: sha256:4960d1cc8b7c882c8707a5b6896aed94a5e2238bbfcaf82d93f5f957c3b1b2fe

sudo emisar pack install clickhouse \
  --hash sha256:4960d1cc8b7c882c8707a5b6896aed94a5e2238bbfcaf82d93f5f957c3b1b2fe \
  --dest /etc/emisar/packs

# Reload so the runner re-reads the catalog:
sudo systemctl reload emisar

• ch.dictionaries exec low

  SELECT * FROM system.dictionaries

• ch.disks exec low

  SELECT * FROM system.disks

• ch.kill_query exec high

  KILL QUERY WHERE query_id = '<id>'

• ch.merge_queue exec low

  SELECT * FROM system.merges

• ch.mutation_queue exec low

  SELECT * FROM system.mutations

• ch.optimize_table exec high

  OPTIMIZE TABLE FINAL

• ch.parts_summary exec low

  SELECT system.parts (by table)

• ch.processes exec low

  SELECT * FROM system.processes

• ch.reload_config exec medium

  SYSTEM RELOAD CONFIG

• ch.replicas_status exec low

  SELECT * FROM system.replicas

• ch.slow_queries exec low

  system.query_log slowest queries

• ch.system_drop_replica exec critical

  SYSTEM DROP REPLICA <name>

• ch.system_events exec low

  SELECT * FROM system.events

• ch.system_flush_logs exec low

  SYSTEM FLUSH LOGS

• ch.system_metrics exec low

  SELECT * FROM system.metrics

• ch.system_restart_replica exec high

  SYSTEM RESTART REPLICA <table>

• ch.system_sync_replica exec medium

  SYSTEM SYNC REPLICA <table>

• ch.table_sizes exec low

  system.tables uncompressed sizes

• ch.uptime exec low

  SELECT version, uptime