Database Lab guides
Administration
- How to configure PostgreSQL used by Database Lab Engine
- How to manage Database Lab Engine
- How to manage Joe Bot
- Secure Database Lab Engine
- Set up machine for Database Lab Engine
- How to refresh data when working in the "logical" mode
- Masking sensitive data in PostgreSQL logs when using CI Observer
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 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