THE ART OF SQL QUERY OPTIMIZATION

Summary from the TLDR Web Dev newsletter

Plan Explorer is a tool developed to visualize and analyze PostgreSQL query optimization decisions. It iterates over a search space, executes SQL queries, and generates diagrams showing query plans, estimated costs, and actual execution times, both in a browser with PGlite or through a proxy to a real PostgreSQL server.