A useful postgres explain tool

When working on performance with Postgres the EXPLAIN tool is incredibly useful. Sometimes the raw output from this is a bit hard to read. Recently I've come across a tool that creates a highly readable output of this:

https://explain.depesz.com/

Published: Fri 03 March 2023

By Janis Lesinskis

In Software-engineering

Tags: SQL postgres performance profiling

Other articles

What causes Pylint no-member false positives and how to deal with this - 2020 February 17

SQLAlchemy when used with Pylint complains about some false positives. Here's an explanation of why and what you can do about it.

read more
Enforcing foreign key constraints with SQLite - 2018 May 07

SQLAlchemy when used with SQLite as the backend doesn't enforce foreign key constraints by default, here's how to enable that behavior.

read more