Skip to main content

External monitoring tools

Preview

This feature is in Public Preview in the following regions: us-east-1, us-west-2, eu-west-1.

Lakebase Autoscaling is the new version of Lakebase with autoscaling compute, scale-to-zero, branching, and instant restore. For feature comparison with Lakebase Provisioned, see choosing between versions.

Monitor your Lakebase Postgres database using external tools that provide performance insights, query analysis, and operational visibility. These tools connect to your database using standard Postgres protocols and help you optimize database performance and troubleshoot issues.

Available monitoring tools

Tool

Description

pgAdmin

Comprehensive graphical administration platform for PostgreSQL. Monitor real-time performance metrics, manage database objects, analyze queries, and view system statistics through a web-based interface.

PgHero

Lightweight open-source performance monitoring tool focused on query optimization. Identify slow queries, detect missing indexes, analyze table statistics, and get actionable recommendations for improving database performance.

note

Lakebase Postgres doesn't currently support monitoring tools or platforms that require installing an agent on the Postgres host system. Use client-based tools that connect via standard Postgres protocols.

Connection requirements

Both monitoring tools require:

  • A Lakebase project with network connectivity
  • A Postgres role with appropriate permissions
  • Standard Postgres connection details (hostname, port, database name)

We recommend using native Postgres password authentication for monitoring tools. Native Postgres passwords don't expire hourly like OAuth tokens. For more information about authentication options, see Authentication overview.