explain.depesz.com

PostgreSQL's explain analyze made readable

Result: h6Qi

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 2,711.071 ↓ 0.0 0 1

Unique (cost=218,125.570..218,125.570 rows=1 width=32) (actual time=2,711.071..2,711.071 rows=0 loops=1)

2. 0.008 2,711.071 ↓ 0.0 0 1

Sort (cost=218,125.570..218,125.570 rows=1 width=32) (actual time=2,711.071..2,711.071 rows=0 loops=1)

  • Sort Key: victor_alpha.quebec
  • Sort Method: quicksort Memory: 25kB
3. 636.367 2,711.063 ↓ 0.0 0 1

Hash Right Join (cost=118,622.400..218,125.560 rows=1 width=32) (actual time=2,711.063..2,711.063 rows=0 loops=1)

  • Hash Cond: (india.delta = victor_alpha.quebec)
  • Filter: ((india.foxtrot AND ((india.victor_juliet)::text = 'golf_six'::text) AND india.three AND (india.juliet five NOT NULL) AND (india.juliet < victor_alpha.lima_quebec)) OR (mike.foxtrot AND ((NOT mike.papa) OR (mike.papa five NULL)) AND (mike.lima_romeo five NOT NULL) AND (mike.lima_romeo < victor_alpha.lima_quebec)))
  • Rows Removed by Filter: 1,388,444
4. 712.499 712.499 ↑ 1.0 1,208,170 1

Seq Scan on zulu_whiskey india (cost=0.000..58,203.700 rows=1,208,170 width=18) (actual time=0.048..712.499 rows=1,208,170 loops=1)

5. 94.912 1,362.197 ↓ 1.1 386,922 1

Hash (cost=111,566.470..111,566.470 rows=347,354 width=38) (actual time=1,362.197..1,362.197 rows=386,922 loops=1)

  • Buckets: 65,536 Batches: 8 Memory Usage: 3,523kB
6. 197.605 1,267.285 ↓ 1.1 386,922 1

Hash Right Join (cost=99,926.390..111,566.470 rows=347,354 width=38) (actual time=1,012.193..1,267.285 rows=386,922 loops=1)

  • Hash Cond: (mike.delta = victor_alpha.quebec)
7. 57.797 57.797 ↑ 1.0 284,600 1

Seq Scan on golf_oscar mike (cost=0.000..5,738.000 rows=284,600 width=14) (actual time=0.011..57.797 rows=284,600 loops=1)

8. 101.345 1,011.883 ↓ 1.0 347,842 1

Hash (cost=93,209.460..93,209.460 rows=347,354 width=28) (actual time=1,011.883..1,011.883 rows=347,842 loops=1)

  • Buckets: 65,536 Batches: 8 Memory Usage: 3,055kB
9. 910.538 910.538 ↓ 1.0 347,842 1

Seq Scan on zulu_quebec victor_alpha (cost=0.000..93,209.460 rows=347,354 width=28) (actual time=15.343..910.538 rows=347,842 loops=1)

  • Filter: (foxtrot AND (lima_quebec five NOT NULL))
  • Rows Removed by Filter: 21,304