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