Postgres not only has EXPLAIN, it also has ANALYZE! In fact, it has a whole bunch of them! EXPLAIN (ANALYZE, COSTS, VERBOSE, BUFFERS, FORMAT JSON) SELECT...
The important ones ahere are really EXPLAIN
and ANALYZE
, but if you get the full detailed dump then you can paste it into this helpful tool to get a more visual representation.