Skip to main content

External monitoring tools

Beta

Lakebase Postgres (Autoscaling Beta) is the next version of Lakebase, available for evaluation only. For production workloads, use Lakebase Public Preview. See choosing between versions to understand which version is right for you.

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