Server Status

API Docs
IP Category Status Containers Disk Memory CPU CPU Avg 5m

ClickHouse DB

Events:
Markets:
Currently tracked OB Markets:
First OB snap UTC:
Last OB snap UTC:

Polymarket API Counts


Slow endpoint (~30-60s)

Events:
Markets:

DB vs Polymarket API Comparison

Events:
Markets:

Users Activity

Logged in (24h):
Loading...
 
Duplicates Management

Inter-Shard Check

Counts rows whose ORDER BY key appears on more than one shard. Uses clusterAllReplicas + FINAL. Excludes order_books (too heavy for live cross-shard scan).

Intra-Shard Check - Force ReplacingMergeTree Dedup

Runs OPTIMIZE TABLE ... FINAL on all ReplacingMergeTree tables on every shard, including order_books. Forces pending merges and intra-shard deduplication.

Truncate System Logs

Runs TRUNCATE TABLE system.* on all shards for: text_log, query_log, processors_profile_log, part_log, trace_log, metric_log, asynchronous_metric_log, query_metric_log. Frees disk and reduces background merge pressure. Irreversible.

Purge OrderBooks Data
Shard:
Start (UTC):
End (UTC):