Taking on 2–3 new engagements in 2026 — EST & PST hours

Start a Conversation

Your support data is in ClickHouse. Let Altor query it.

ClickHouse holds your customer's API logs, event streams, and operational metrics. Today your support engineers write ad-hoc queries to investigate tickets. Altor runs those same queries automatically - every ticket, every time, in 2 minutes.

How ClickHouse data powers ticket investigation

These are the tickets that sit in queue until an engineer has time to investigate:

  • "Error rate spiked for our production workload" - Altor queries ClickHouse for error_count by endpoint, time window, and customer_id to isolate the pattern
  • "Latency doubled on our batch processing endpoint" - Altor queries p50/p95/p99 latency over the last 48 hours, segments by payload size and region
  • "We are seeing intermittent timeouts on reads" - Altor checks query_log for slow queries, MergeTree part counts, and concurrent merge activity
  • "Our event pipeline dropped events between 2-4am UTC" - Altor queries ingestion_log for gaps, checks insert_errors, and correlates with merge operations

ClickHouse tables Altor can query

Altor connects to the systems where your investigation data actually lives:

  • Request/event logs - error rates, latency percentiles, status codes by customer, endpoint, and time window
  • system.query_log - slow queries affecting specific customers, resource-intensive operations
  • system.merges / system.parts - merge activity, part counts, storage health indicators
  • Custom analytics tables - whatever customer-facing metrics your product tracks
  • Billing/usage tables - metered consumption reconciled against Stripe invoices
200+

tickets diagnosed using ClickHouse data at Portkey

< 2 min

from ticket to ClickHouse-backed diagnosis

5-10

ClickHouse queries typically needed per investigation

0

queries your support team needs to write manually

"Altor diagnosed in 2 minutes what used to take our engineers 45 minutes of copying data between tabs. Our tickets are investigations, not FAQs - nobody else could even attempt to answer them automatically."

— Engineering lead, Portkey

Why ClickHouse teams get the most from Altor

ClickHouse is the ideal investigation backend: it stores massive volumes of customer operational data with sub-second query performance. The problem isn't that the data doesn't exist - it's that writing the right queries for each ticket takes 15-20 minutes.

Altor knows your schema. It generates and executes the right ClickHouse queries for each ticket automatically - the same queries your best engineer would write, but in seconds instead of minutes.

See Altor investigate a real ticket from your queue

We'll connect to your systems and run a live investigation. Your data, your ticket, diagnosed in 2 minutes during EST or PST hours.

Get weekly support engineering insights

Opens your email app with your address prefilled.