{"repo":"JacobArthurs/pgplan","free":true,"listed":false,"github":"https://github.com/JacobArthurs/pgplan","clone":"git clone https://github.com/JacobArthurs/pgplan.git","description":"Compare and analyze PostgreSQL EXPLAIN plans from the CLI","language":"Go","stars":13,"topics":["cli","cobra","database","developer-tools","golang","postgresql","query-optimization"],"license":"MIT","category":"databases-storage","readme_excerpt":"pgplan A command-line tool for analyzing and comparing PostgreSQL query execution plans. Get optimization insights and track performance regressions without leaving your terminal. Features - Plan Analysis - Run 15+ intelligent rules against a query plan to surface performance issues with actionable fix suggestions - Plan Comparison - Semantically diff two plans side-by-side to understand what changed and whether it got better or worse - Flexible Input - Accept JSON EXPLAIN output, raw SQL files, stdin, or paste plans interactively - Connection Profiles - Save and manage named PostgreSQL connection strings for quick reuse - Multiple Output Formats - Human-readable colored terminal output or structured JSON for tooling integration Installation PyPI npm Go Binary Download the latest release for your platform from the releases page. Quick Start Commands pgplan analyze [file] Analyzes a single query plan and returns optimization findings sorted by severity. Arguments: Argument Description -------- ----------- file Path to a .json (EXPLAIN output) or .sql file. Use - for stdin. Omit for interactive mode. Flags: Flag Description ---- ----------- -d, --db PostgreSQL connection string (required for SQL input) -p, --profile Named connection profile to use -f, --format Output format: text (default) or json Example: pgplan compare [file1] [file2] Compares two query plans and reports on cost, time, row estimate, and buffer differences across every node in the plan tree. Arguments: Argumen","default_branch":null,"files":null,"tree":[],"storefront":"/r/JacobArthurs","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/JacobArthurs/pgplan/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."}