The only monitoring platform with native ClickHouse support →

Blog

Guides, insights, and ideas on database performance, observability, and modern infrastructure.

AWS PI Migration

If you are planning around the June 30, 2026 transition, use our dedicated migration guide.

Latest9 min read

Postgres audit logging at scale: pgaudit vs triggers vs logical decoding

Three real options for auditing a busy Postgres database, when to pick each, and why audit data almost never belongs in your transactional cluster.

By Behroz Saadat
PostgreSQLObservabilityArchitecture
8 min read

Cheap audit logs in ClickHouse: the schema we're using for Basira's command log

Audit logs in Postgres get expensive fast. Here's the MergeTree schema we designed for Basira's command audit trail — actor-first ordering, monthly partitions, LowCardinality enums, ZSTD-compressed payloads, and TTL-based retention.

Behroz Saadat
ClickHouseArchitecture
8 min read

How to Set Up pg_stat_statements: The Complete Guide

pg_stat_statements is the foundation of PostgreSQL query performance monitoring. Here's everything you need to know to set it up, configure it, and use it effectively.

Behroz Saadat
PostgreSQLPerformance
9 min read

PostgreSQL Query Optimization: 10 Patterns That Slow Down Your Database

The same query patterns cause most PostgreSQL performance problems. Here are 10 patterns to watch for, how to spot them in pg_stat_statements, and how to fix each one.

Behroz Saadat
PostgreSQLPerformance
7 min read

Datadog Database Monitoring vs. Basira: An Honest Comparison

Datadog is the default choice for database monitoring. But is it the right one? A side-by-side comparison of features, pricing, and trade-offs for teams that only need database observability.

Behroz Saadat
ComparisonPricing
8 min read

ClickHouse MergeTree Engine: Understanding Parts, Merges, and Performance

MergeTree is the engine behind most ClickHouse deployments. Understanding how parts and merges work is essential for preventing performance problems before they escalate.

Behroz Saadat
ClickHousePerformance
6 min read

Database Monitoring Costs Are Out of Control

Most teams overpay for database observability by a factor of 5-10x. Usage-based pricing is broken. Here's what predictable database monitoring actually costs.

Behroz Saadat
PricingObservability
6 min read

ClickHouse Monitoring: Why the Gap Exists

ClickHouse is everywhere in modern data stacks, but database monitoring tools treat it as an afterthought. We built native ClickHouse monitoring to fix that.

Behroz Saadat
ClickHouseObservability
6 min read

What Agent-Native Database Monitoring Means

AI agents are automating infrastructure setup. Your database monitoring tool needs to be ready for that. Here's how Basira is designed to be agent-native.

Behroz Saadat
AIArchitecture
7 min read

RDS Performance Insights Is Going Away

AWS is retiring the RDS Performance Insights console by June 30, 2026. Here's what your options are, what they cost, and what to do before the deadline.

Behroz Saadat
AWSPostgreSQL

Ready to fix your slow queries?

Deploy Basira in under a minute. $29/db/month. No usage surprises.

Start Free Trial