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.

• • 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

• • 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.

Export

• • OpenTelemetry export
  • Export metrics and Postgres logs to an OpenTelemetry (OTLP) endpoint for Grafana, New Relic, Datadog OTLP, or other backends.

Postgres extensions

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

External monitoring tools

• • 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.