Picture of an elephant

Welcome to the pgreplay Project Home Page

Home Downloads Documentation Project page 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.


The pgreplay project is a PostgreSQL Community project that is a part of the pgFoundry.

Powered By GForge Collaborative Development Environment