explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DJ5s

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 55.418 ↑ 1.0 1 1

Aggregate (cost=3,410.860..3,410.870 rows=1 width=8) (actual time=55.418..55.418 rows=1 loops=1)

2. 0.068 55.408 ↓ 26.0 52 1

Sort (cost=3,410.830..3,410.840 rows=2 width=12) (actual time=55.405..55.408 rows=52 loops=1)

  • Sort Key: (five_two(papa.quebec)) DESC
  • Sort Method: quicksort Memory: 27kB
3. 1.940 55.340 ↓ 26.0 52 1

GroupAggregate (cost=1.540..3,410.820 rows=2 width=12) (actual time=1.469..55.340 rows=52 loops=1)

  • Group Key: papa.six
4. 1.668 53.400 ↓ 4,622.5 9,245 1

Nested Loop (cost=1.540..3,410.790 rows=2 width=8) (actual time=0.244..53.400 rows=9,245 loops=1)

5. 0.191 4.832 ↓ 5.6 67 1

Nested Loop (cost=1.120..3,316.740 rows=12 width=12) (actual time=0.186..4.832 rows=67 loops=1)

6. 0.283 3.065 ↑ 1.1 394 1

Nested Loop (cost=0.690..3,074.820 rows=420 width=8) (actual time=0.027..3.065 rows=394 loops=1)

7. 0.627 0.627 ↑ 1.0 431 1

Index Scan using kilo_four on kilo_oscar uniform (cost=0.270..36.870 rows=431 width=4) (actual time=0.011..0.627 rows=431 loops=1)

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

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

  • Index Cond: (quebec = uniform.zulu_lima)
  • Filter: (foxtrot AND seven AND (quebec <> 19834))
  • Rows Removed by Filter: 0
9. 1.576 1.576 ↓ 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.004..0.004 rows=0 loops=394)

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

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

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