Monitor

info

Lakebase Autoscaling is available in the following regions: us-east-1, us-east-2, eu-central-1, eu-west-1, eu-west-2, ap-south-1, ap-southeast-1, ap-southeast-2.

Lakebase Autoscaling is the latest 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 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

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

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