Chresmos Capital Infrastructure / SysAdmin
★

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):