Menu
Database Lab logoDatabase Lab logoPostgres.ai
Product
  • How It Works
  • Database Migration Testing
  • SQL Optimization
  • Realistic Dev & Test Environments
  • Sensitive Data Masking
Pricing
Documentation
  • Documentation Home
  • Getting Started for Amazon RDS
  • Database Lab FAQ
Services
Company
  • Blog
  • Case Studies
Sign in
🌜
🌞
Database Lab logoDatabase Lab logoPostgres.ai
  • Product
    • How It Works
    • Database Migration Testing
    • SQL Optimization
    • Realistic Dev & Test Environments
    • Sensitive Data Masking
  • Pricing
  • Documentation
    • Documentation Home
    • Getting Started for Amazon RDS
    • Database Lab FAQ
  • Services
  • Company
    • Blog
    • Case Studies
  • Sign in
  • Overview
    • Documentation Home
    • Q&A
    • Roadmap
  • Tutorials
    • Tutorial for any PostgreSQL database
    • Tutorial for Amazon RDS
    • Start using Joe Bot
    • Platform onboarding checklist
  • Guides
    • Overview
    • Administration
      • Overview
      • Configure PostgreSQL used by Database Lab Engine
      • Manage Database Lab Engine
      • Manage Joe bot
      • Secure Database Lab Engine
      • Set up a machine for Database Lab Engine
      • Full refresh for "logical" mode
      • Masking sensitive data (CI Observer)
    • Cloning
      • Overview
      • Create a clone
      • Connect to a clones
      • Reset a clone
      • Destroy a clone
      • Protect clones from manual and automatic deletion
    • Joe bot
      • Overview
      • Get a query execution plan
      • Create an index
      • Reset a session
      • Get a list of active queries and stop long-running queries
      • Visualize a query plan
      • Work with SQL optimization history
      • Get row counts for arbitrary SELECTs
      • Get sizes of PostgreSQL database objects
    • CLI
      • Overview
      • Install and initialize Database Lab CLI
    • Data sources
      • Overview
      • AWS RDS
      • pg_dump
      • pg_basebackup
      • WAL-G
      • Custom
    • Platform
      • Overview
      • Start using Platform
      • Create and use tokens
  • Database Lab Platform
    • Overview
    • Security
  • Database Lab Engine
    • Overview
    • Data masking and obfuscation
    • Query duration for production environments
    • PostgreSQL versions and extensions
    • Reference
      • API reference
      • Client CLI reference
      • Components
      • Configuration reference
  • Joe Bot
    • Overview
    • Demo and example
    • Reference
      • Configuration reference
      • Chatbot commands
  • Other
    • Checkup
    • Data recovery
    • Data access

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

Database Lab CLI#

  • How to install and initialize Database Lab CLI

Obtaining data for Database Lab#

Logical retrieval#

  • Amazon RDS
  • Any database (dump/restore)

Physical retrieval#

  • pg_basebackup
  • WAL-G
  • Custom

Database Lab (Postgres.ai) Platform#

  • Start using Postgres.ai Platform
Edit this page
Previous
« Database Lab Platform onboarding checklist
Next
Database Lab Engine administration »
  • Administration
  • How to work with Database Lab clones
  • How to work with Joe bot
  • Database Lab CLI
  • Obtaining data for Database Lab
    • Logical retrieval
    • Physical retrieval
  • Database Lab (Postgres.ai) Platform

Docs

  • Platform overview
  • Getting started
  • FAQ
  • Guides
  • API reference
  • CLI reference

Products

  • Database Lab Engine
  • Joe Bot for SQL Optimization

Social

  • Community Slack
  • GitLab
  • GitHub
  • Twitter
  • YouTube
  • LinkedIn

Links

  • Home
  • Documentation
  • Case Studies
  • Careers
  • Sign in
  • Terms of service
  • Privacy policy
Copyright © 2021 Postgres.ai