Monitor
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 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 |
|---|---|
View system and database metrics in the metrics dashboard. Track CPU, RAM, connections, database size, deadlocks, row operations, replication delays, cache performance, and working set size. | |
View and analyze running queries in your database. Monitor query performance and identify long-running operations in real time. | |
View and analyze query history for your database. Review past query performance and identify patterns to optimize your database. | |
View operations performed by the Lakebase platform, including user-initiated and system-initiated activities. Track the health and status of your project by monitoring background processes and administrative tasks. |
Postgres extensions
Extension | Description |
|---|---|
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 |
|---|---|
Monitor your database using pgAdmin, a comprehensive administration platform. View performance metrics, analyze queries, and manage database operations through a web interface. | |
Monitor database performance with PgHero, a focused Postgres monitoring tool. Identify slow queries, analyze performance trends, and get optimization recommendations. |