Database Lab guides
Administration​
- How to install DLE from Postgres.ai Console
- How to install DLE from AWS Marketplace
- How to install DLE manually (Community Edition)
- How to configure PostgreSQL used by Database Lab Engine
- How to manage Database Lab Engine
- How to manage Joe Bot
- Secure Database Lab Engine
- How to refresh data when working in the "logical" mode
- Masking sensitive data in PostgreSQL logs when using CI Observer
- Add disk space to ZFS pool without downtime
How to work with Database Lab clones​
- How to create Database Lab clones
- How to connect to Database Lab clones
- How to reset Database Lab clone
- How to destroy Database Lab clone
- Protect clones from manual and automatic deletion
- How to upgrade Postgres to a new major version in the DBLab clone
How to work with Joe bot​
- How to get a query execution plan (EXPLAIN)
- How to create an index using Joe bot
- How to reset the state of a Joe session / clone
- How to get a list of active queries in a Joe session and stop long-running queries
- How to visualize a query plan
- How to work with SQL optimization history
- How to get row counts for arbitrary SELECTs
- How to get sizes of PostgreSQL databases, tables, and indexes with psql commands