pgreplay PostgreSQL log file replayer for performance tests
Download

pgreplay Ranking & Summary

pgreplay Tags

PostgreSQL statement video format replayer sound format replayer execute SQL statement record replayer PostgreSQL log replayer log file replayer log replayer performance monitor log

pgreplay Description

Extracts the SQL statements and executes them in the same order and relative time 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: * You want to compare the performance of your PostgreSQL application on different hardware or different operating systems. * You want to upgrade your database and want to make sure that the new database version does not suffer from performance regressions that affect you. 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. Features: * Should compile and run on any platform that PostgreSQL supports * Can replay the workload at different speeds * Can parse "stderr" and "csvlog" log files * Can save workload to replay in "replay file" for reuse

pgreplay Related Software