Picture of an elephant

Welcome to the pgreplay Project Home Page

Downloads Documentation Source Repository License

pgreplay reads a PostgreSQL log file (not a WAL file), extracts the SQL statements and executes them in the same order and relative time against a PostgreSQL database cluster.

If the execution of statements gets behind schedule, warning messages are issued that indicate that the server cannot handle the load in a timely fashion. The idea is to replay a real-world database workload as exactly as possible.

pgreplay is useful for performance tests, particularly in the following situations:

Moreover, pgreplay can give you some feeling as to how your application might scale by allowing you to replay the workload at a different speed. Be warned, though, that 500 users working at double speed is not really the same as 1000 users working at normal speed.



Please report problems on the mailing list or by opening an issue.

pgreplay uses semantic versioning.