Observability

Observe your Lakebase Postgres projects to track performance, resource usage, and system health, and to find and fix issues when they arise. Lakebase provides several categories of tools, from AI-assisted troubleshooting to metrics and query analysis.

AI-assisted observability

Lakebase captures your project's Postgres telemetry as Delta tables in your own Unity Catalog, then puts that data to work for you: Insights reviews it on a schedule and surfaces issues without being asked, and you can troubleshoot conversationally with Genie.

Tool	Description
AI-assisted troubleshooting	How telemetry, Insights, and Genie fit together, and where your data lives.
Diagnose and fix issues with Genie	Ask Genie about a problem in your own words and walk through a guided fix.
Find and resolve issues with Insights	Let a background agent catch issues and early warnings before they affect you.
Capture telemetry to the Lakehouse	Send your project's telemetry to Unity Catalog as Delta tables.

Lakebase monitoring tools

Tool	Description
Metrics dashboard	View system and database metrics including CPU, RAM, connections, database size, and more.
Monitor active queries	View and analyze running queries, monitor performance, and identify long-running operations.
Monitor query performance	View query history, review past performance, and identify optimization patterns.
System operations	View and track operations performed by the Lakebase platform and monitor project health.

Postgres extensions

Extension	Description
Monitor with pg_stat_statements	Track SQL execution statistics with pg_stat_statements to analyze and optimize performance.

External monitoring tools

Tool	Description
Connect with pgAdmin	Monitor your database using pgAdmin's comprehensive administration platform and web interface.
Connect with PgHero	Monitor database performance with PgHero to identify slow queries and optimization opportunities.