Skip to main content

Monitor

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 projects to track performance, resource usage, and system health. Lakebase provides multiple categories of monitoring tools to help you understand your database operations and optimize performance.

Lakebase monitoring tools

Tool

Description

Monitor active queries

View and analyze running queries in your database. Monitor query performance and identify long-running operations in real time.

Monitor query performance

View and analyze query history for your database. Review past query performance and identify patterns to optimize your database.

System operations

View operations performed by the Lakebase platform, including user-initiated and system-initiated activities. Track the health and status of your database project by monitoring background processes and administrative tasks.

Postgres extensions

Extension

Description

Monitor with pg_stat_statements

Track execution statistics for all SQL statements using the pg_stat_statements Postgres extension. Analyze query performance and identify optimization opportunities.

External monitoring tools

Tool

Description

Connect with pgAdmin

Monitor your database using pgAdmin, a comprehensive administration platform. View performance metrics, analyze queries, and manage database operations through a web interface.

Connect with PgHero

Monitor database performance with PgHero, a focused Postgres monitoring tool. Identify slow queries, analyze performance trends, and get optimization recommendations.