ClickHouse analytics DB

v0.2.5

ClickHouse server + table introspection — metrics, errors, slow & failed queries, parts/partitions, merges, mutations, replication queue, Keeper/ZK health, detached parts, distributed-send backlog, backups — plus narrow mutators (OPTIMIZE, KILL QUERY, SYSTEM RELOAD CONFIG, replica ops). Auth via CH_HOST + CH_USER + CH_PASSWORD env vars on the runner host. Uses clickhouse-client with --query to keep arg surface minimal.

27 allowed by default 3 need approval 2 denied by default

Pack ID

clickhouse

Vendor

emisar

linux

Actions

Required binaries. Install these on the host before relying on the pack — an action that calls a missing one fails at run time.


              clickhouse-client

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:721817e6dbccefab19e026124316f239aa64b501c50baa5482d9963357d8731b

on the runner host

sudo emisar pack install clickhouse \
  --hash sha256:721817e6dbccefab19e026124316f239aa64b501c50baa5482d9963357d8731b \
  --dest /etc/emisar/packs

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

Actions 32 total

View on GitHub

ch.asynchronous_metrics exec low

SELECT * FROM system.asynchronous_metrics
ch.backups exec low

SELECT * FROM system.backups
ch.detached_parts exec low

SELECT * FROM system.detached_parts
ch.dictionaries exec low

SELECT * FROM system.dictionaries
ch.disks exec low

SELECT * FROM system.disks
ch.distribution_queue exec low

SELECT * FROM system.distribution_queue
ch.errors exec low

SELECT * FROM system.errors
ch.keeper_status exec low

List a Keeper/ZooKeeper path (system.zookeeper)
ch.kill_mutation exec critical

Cancel a stuck mutation (KILL MUTATION)
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_by_partition exec low

Active part count per partition (system.parts)
ch.parts_summary exec low

SELECT system.parts (by table)
ch.processes exec low

SELECT * FROM system.processes
ch.query_errors exec low

Failed queries from system.query_log (last hour)
ch.reload_config exec medium

SYSTEM RELOAD CONFIG
ch.replicas_status exec low

SELECT * FROM system.replicas
ch.replication_queue exec low

SELECT * FROM system.replication_queue
ch.slow_queries exec low

system.query_log slowest queries
ch.stuck_mutations exec low

Failing mutations (system.mutations)
ch.system_drop_replica exec critical

SYSTEM DROP REPLICA <name>
ch.system_events exec low

SELECT * FROM system.events
ch.system_flush_logs exec medium

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.tables_overview exec low

Engine inventory (system.tables)
ch.uptime exec low

SELECT version, uptime
ch.zookeeper_connection exec low

SELECT * FROM system.zookeeper_connection

← Back to registry

Pack reference Publish your own →