HouseWatch, open source pganalyze for ClickHouse

In plain words

HouseWatch is an open-source monitoring and management tool for ClickHouse clusters. It provides a user interface for analyzing query performance and deriving actionable insights, similar to pganalyze for Postgres, while also handling cluster management tasks like system tuning and data migrations. Built by PostHog and available as beta software, it deploys easily via Docker Compose and is designed for teams running ClickHouse in production environments.

written from the facts on this page · September 2026

From the sources

Open source tool for monitoring and managing ClickHouse clusters - PostHog/HouseWatch

In the maker’s words, at launch

Hey all! Yakko from PostHog here. We manage a few large ClickHouse clusters and found ourselves using a lot of different tools internally to monitor and manage them. We also realized that there was no proper UI available for easily digging into query performance and deriving actionable insights, so we built…

• 
  SigNoz – open-source alternative to DataDog, NewRelic2022 · github.com · ▲510

  We just released a major upgrade to SigNoz with support for Logs management based on ClickHouse. Would love to get any feedback from the community here on what you think and any questions you may have for us Many big companies like Uber and Cloudflare have been shifting to ClickHouse as their main workhorse for Logs management seeing much better performance. for e.g Cloudflare recently shifted from Elastic to ClickHouse and are seeing 8x improvement in memory/cpu resource requirement in ingestion. This is our first release with Logs support and we have added support for: - Filtering…

• 
  Distributed Tracing Using OpenTelemetry and ClickHouse2021 · github.com · ▲105

  Open source APM: OpenTelemetry traces, metrics, and logs - uptrace/uptrace

• 
  PostHog2021 · posthog.com · ▲458

  An all-in-one product analytics suite you can self-host

• 
  pganalyze2019 · pganalyze.com · ▲84

  Automated EXPLAIN Plan Visualization & Insights for Postgres

• 
  ClickHouse-local – a small tool for serverless data analytics2023 · clickhouse.com · ▲289

  Me with my friend Vitaly Ludvichenko made an experiment to combine ClickHouse server and client to make a self-contained program running a database engine and processing data without a server: https://github.com/ClickHouse/ClickHouse/pull/150 Development continued in the past 6 years, and now clickhouse-local becomes a swiss-army knife for data processing. Say "ffmpeg" for datasets and more. It can resemble textql, octosql, dsq, duckdb, trdsql, q, datafusion-cli, spyql, but has better capabilities and performance. Here is a tutorial:…

• 
  We built a ClickHouse-based logging service2023 · github.com · ▲192

  Hey hn! I'm one of the co-founders of highlight.io, an open source monitoring tool. Today we're sharing a ClickHouse-based logging solution we've been working on. We wanted to showcase how we built it and share how you could try it out to give feedback. Since we started working on highlight.io, we've been hyper-focused on "cohesion", or ensuring that when you install your monitoring stack, all of the resources in that stack (user interactions, requests, traces, logs, etc.) are connected in a consumable way. We've written up more about our philosophy on this here [1]. We started building…

• 
  Run full iOS 16.5 firmware on Android Devices▲516

  Contribute to oosexgang/hackios-xnu-kernel development by creating an account on GitHub.

  Dev tools · 2d ago · github.com

• 
  /dev/null▲492

  a social network for devs

  Dev tools · 5d ago · dev-null.sh

• 
  Whiteboard (YC W26) – an open-source IDE for thoughtful software design▲423

  open-source IDE for thoughtful software design. Contribute to devdotfast/whiteboard development by creating an account on GitHub.

  Dev tools · 29d ago · github.com

• 
  Reladraw – A diagram language where you decide where to place things▲411

  Contribute to reladraw/reladraw development by creating an account on GitHub.

  Dev tools · 27d ago · github.com

• 
  OpenBot▲362

  Grok Bot alternative: free, local, open-source, multiplayer

  Dev tools · 25d ago · openbot.run

• 
  Talanoa▲346

  Hi HN, I’m a fullstack developer, and honestly, I’ve lost count of how many side projects I’ve worked on over the years. But one idea kept coming back to me: a different kind of email client. It first came to me in 2014: “What if we could handle emails more like conversations?” Every year, I’d revisit this concept in my “Build Notes.” Ten years later, no one had built exactly what I had in mind — so I finally decided to do it myself. That’s how Talanoa was born. I wanted something focused on people, not timelines. I was tired of marking messages as unread just to remember to reply later, or…

  Dev tools · 22d ago · talanoa.email

• 
  Non.io, a Reddit-like platform Ive been working on for the last 4 years▲1,943

  Heya HN, I've been working on a reddit-like platform as my primary side project for the last few years. Doing a (very) soft launch today, mainly because I want to use it to encourage discussion of alternatives. How non.io works: 1. Free to browse, paid to interact. 2. Minimum subscription is $2 (though you can choose more). I take $1 to run the servers, everything left gets split evenly between everything you upvote that month. It's a simple model, but I hope it's a better one than the freemium model we've been relying on for the last few years. Fundamentally I feel like any ad-supported…

  Commerce · 2023 · non.io

• 
  Sivi AI▲938

  Generative AI to magically turn text to visual designs

  AI · 2023 · sivi.ai

• 
  Typefully 2.0▲931

  Effortlessly publish on Twitter and LinkedIn, now with AI

  Growth · 2023 · typefully.com

• 
  Olvy 2.0▲826

  Analyze user feedback 10x faster with AI

  AI · 2023 · olvy.co

• 
  SlashPage▲755

  Create websites in seconds to build your first 1K community

  Growth · 2023 · slashpage.com

• 
  Unicorn Platform AI▲751

  Easy to use AI-powered, drag-and-drop website, SAAS landing, directory, and blog builder for startups, mobile apps, and SaaS. 100% no code, no design skills needed.

  AI · 2023 · unicornplatform.com