explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NYHbM

Settings
# exclusive inclusive rows x rows loops node
1. 2.417 57.900 ↑ 1.0 1 1

Aggregate (cost=3,383.390..3,383.400 rows=1 width=8) (actual time=57.900..57.900 rows=1 loops=1)

2. 1.675 55.483 ↓ 4,622.5 9,245 1

Nested Loop (cost=1.270..3,383.390 rows=2 width=4) (actual time=0.163..55.483 rows=9,245 loops=1)

3. 0.373 5.970 ↓ 5.6 67 1

Nested Loop (cost=0.840..3,289.340 rows=12 width=12) (actual time=0.140..5.970 rows=67 loops=1)

4. 0.234 3.627 ↑ 1.1 394 1

Nested Loop (cost=0.420..3,047.410 rows=420 width=8) (actual time=0.035..3.627 rows=394 loops=1)

5. 0.376 0.376 ↑ 1.0 431 1

Seq Scan on kilo_oscar uniform (cost=0.000..9.460 rows=431 width=4) (actual time=0.020..0.376 rows=431 loops=1)

  • Filter: ((quebec five_romeo NOT NULL) AND (four = ANY ('victor'::integer[])))
6. 3.017 3.017 ↑ 1.0 1 431

Index Scan using yankee on lima kilo_hotel (cost=0.420..7.040 rows=1 width=4) (actual time=0.006..0.007 rows=1 loops=431)

  • Index Cond: (quebec = uniform.zulu_lima)
  • Filter: (foxtrot AND seven AND (quebec <> 19834))
  • Rows Removed by Filter: 0
7. 1.970 1.970 ↓ 0.0 0 394

Index Only Scan using five_victor on zulu_india hotel_quebec (cost=0.420..0.570 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=394)

  • Index Cond: ((zulu_lima = kilo_hotel.quebec) AND (charlie = 104))
  • Heap Fetches: 67
8. 47.838 47.838 ↓ 34.5 138 67

Index Scan using hotel_six on sierra papa (cost=0.430..7.800 rows=4 width=4) (actual time=0.076..0.714 rows=138 loops=67)

  • Index Cond: (six = kilo_hotel.quebec)
  • Filter: ((charlie = 104) AND (juliet = 4))
  • Rows Removed by Filter: 476