{"repo":"pg-tools/pgcompare","free":true,"listed":false,"github":"https://github.com/pg-tools/pgcompare","clone":"git clone https://github.com/pg-tools/pgcompare.git","description":"CLI for benchmarking PostgreSQL queries before and after optimization and generating an HTML report.","language":"Go","stars":21,"topics":["cli","golang","postgresql","docker","tool","benchmark"],"license":"GPL-3.0","category":"cli-tools","readme_excerpt":"Run your queries before and after any optimization. Get a full HTML report with latency percentiles, QPS, and execution plan diffs. For Russian documentation, see RU.md . Installation Pre-built binaries are available on the Releases page. Or install via script: For more options (custom version, custom directory), see INSTALL.md. Updating Update to the latest version: Verify installed version: What pgcompare Does pgcompare runs the same benchmark flow twice: 1. Load pgcompare.yaml and .env from the same project directory. 2. Prepare the before state with the configured migration env var. 3. Warm up the before queries, run the measured benchmark, and capture EXPLAIN ANALYZE plans. 4. Recreate the environment for the after state. 5. Warm up the after queries, run the measured benchmark, and capture plans again. 6. Generate one HTML comparison report. This is intended for comparing the effect of: - schema changes - new or changed indexes - rewritten SQL - migration changes - changes in seeded data Requirements - Docker with either docker compose v2 or docker-compose v1 in PATH - PostgreSQL reachable from the host on localhost:$POSTGRES PORT - A project directory containing .env , pgcompare.yaml , and the SQL files referenced by the config If you build from source, use Go 1.25 . Project Layout pgcompare treats the directory that contains pgcompare.yaml as the project root. It loads .env from there, runs external commands there, and writes the default report there. Recommended layo","default_branch":null,"files":null,"tree":[],"storefront":"/r/pg-tools","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/pg-tools/pgcompare/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}