DBLab HowTo guides
Administration
- How to install DBLab Engine from Postgres AI Console
- How to install DBLab Engine from AWS Marketplace
- How to install DBLab Engine manually (Community Edition)
- How to configure PostgreSQL used by DBLab Engine
- How to manage DBLab Engine
- How to manage Joe Bot
- Secure DBLab 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 DBLab clones
- How to create DBLab clones
- How to connect to DBLab clones
- How to reset DBLab clone
- How to destroy DBLab 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 DBLab branches
How to work with DBLab snapshots
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