pg_replay

A utility which parses statements from PostgreSQL logfiles and replays them to a PostgreSQL cluster to help replicate real-world workloads.

pg_replay is a utility which parses statements from PostgreSQL logfiles and replays them to a PostgreSQL cluster to help replicate real-world workloads. It attempts to replay the statements in the same order and at the same speed they were originally executed as, to reproduce the original workload as closely as possible.

pg_replay requires specific log settings in order to be able to extract sufficient data from the PostgreSQL log files, and CSV logging is recommended. See the documentation for details.

It writes the parsed statements to a custom binary file, which is used to execute the replay.

Minimum supported PostgreSQL version is PostgreSQL 8.0.

Release history

This is a summary of significant releases; for a full and detailed list of releases, see the pg_replay release page.

Note: release dates are taken from the pg_replay GitHub release page.

Categories

Logging, Performance, Utility program