This repository was archived by the owner on Aug 16, 2021. It is now read-only.

Experiment

Jump to bottom

Nikolay edited this page May 8, 2018 · 7 revisions

Input for an Experiment Run

Project name (ID)
Server hostname + database name
DB version
EC2 instance for this run
Change ("no change" or something changed, e.g. postgresql.conf or create index ...)
Queries (two options: (a) pgreplay bin file, or (b) custom queries)

Change and Queries are specified when Experiment is created.

Optimization idea: based on all input options we can calculate "experiment run hash" to allow skipping "no change" runs.

Output of an Experiment Run

Postgres log (goes to S3)
JSON produced by pgBadger (goes to S3)
Main values from pgBadger JSON (we post them to Postgres.ai metadata DB, using API)
[todo] pg_stat_statements snapshots
[todo] snapshots of other pg_stat_*** views