The best single-page guide to query tuning that I’ve ever seen, for any database platform, dropped this week from Francesco Tisiot of EverSQL.  It’s one hell of a long page, sure, but it covers all kinds of common techniques.

Next up is an in-depth multi-post guide to reading EXPLAIN from Hubert Lubaczewski aka depesz, the guy behind https://explain.depesz.com/. Subsequent parts in the guide are listed here.

Finally, for tuning server parameters, postgresqlco.nf has guides for basic, intermediate, and advanced users that explain each configuration setting that they recommend changing, and why.

Technique of the Week:
Showing Your Server’s Settings

If I give you a link to tune your parameters, your next question is gonna be, “Uh, what are my current parameter settings?” To find out, query pg_settings:

This works in AWS Aurora, too, and includes Aurora-specific settings:

If you continue to scroll off to the right, there are columns for the datatype, min & max values, the source of the setting (like it’s the default, or came from the command line or a config file), and more.