explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UvtL

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 417.274 ↑ 1.0 1 1

Finalize Aggregate (cost=44,366.720..44,366.730 rows=1 width=32) (actual time=417.274..417.274 rows=1 loops=1)

  • Output: five_hotel(foxtrot.romeo_echo)
2. 7.064 417.302 ↓ 1.5 3 1

Gather (cost=44,366.490..44,366.700 rows=2 width=32) (actual time=417.255..417.302 rows=3 loops=1)

  • Output: (bravo five_hotel(foxtrot.romeo_echo))
  • Workers Planned: 2
  • Workers Launched: 2
3. 2.600 410.238 ↑ 1.0 1 3

Partial Aggregate (cost=43,366.490..43,366.500 rows=1 width=32) (actual time=410.238..410.238 rows=1 loops=3)

  • Output: bravo five_hotel(foxtrot.romeo_echo)
  • Worker 0: actual time=409.266..409.266 rows=1 loops=1
  • Worker 1: actual time=404.459..404.460 rows=1 loops=1
4. 78.358 407.638 ↑ 1.1 9,482 3

Hash Join (cost=16.870..43,340.470 rows=10,410 width=5) (actual time=151.291..407.638 rows=9,482 loops=3)

  • Output: foxtrot.romeo_echo
  • Inner Unique: true
  • Hash Cond: (foxtrot.charlie = sierra.quebec)
  • Worker 0: actual time=150.124..405.952 rows=12201 loops=1
  • Worker 1: actual time=142.540..401.831 rows=9586 loops=1
5. 329.164 329.164 ↑ 1.2 103,823 3

Parallel Seq Scan on seven_victor (cost=0.000..42,985.340 rows=127,598 width=13) (actual time=91.080..329.164 rows=103,823 loops=3)

  • Output: foxtrot.quebec, foxtrot.charlie, foxtrot.golf_tango, foxtrot.romeo_echo, foxtrot.golf_six, foxtrot.november, foxtrot.juliet, foxtrot.seven_papa, foxtrot.romeo_hotel, foxtrot.hotel, foxtrot.two
  • Filter: ((foxtrot.hotel)::text <> 'papa'::text)
  • Rows Removed by Filter: 511153
  • Worker 0: actual time=138.118..320.718 rows=103497 loops=1
  • Worker 1: actual time=130.330..323.311 rows=99934 loops=1
6. 0.013 0.116 ↑ 2.2 16 3

Hash (cost=16.430..16.430 rows=35 width=8) (actual time=0.116..0.116 rows=16 loops=3)

  • Output: sierra.quebec
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Worker 0: actual time=0.109..0.109 rows=16 loops=1
  • Worker 1: actual time=0.134..0.135 rows=16 loops=1
7. 0.103 0.103 ↑ 2.2 16 3

Seq Scan on five_echo (cost=0.000..16.430 rows=35 width=8) (actual time=0.027..0.103 rows=16 loops=3)

  • Output: sierra.quebec
  • Filter: ((sierra.four = 5) AND (sierra.kilo = 155))
  • Rows Removed by Filter: 413
  • Worker 0: actual time=0.025..0.096 rows=16 loops=1
  • Worker 1: actual time=0.038..0.116 rows=16 loops=1