explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iUmh : test

Settings
# exclusive inclusive rows x rows loops node
1. 9.084 101.227 ↑ 377.9 306 1

Nested Loop Left Join (cost=6,023.400..219,489.960 rows=115,627 width=252) (actual time=86.241..101.227 rows=306 loops=1)

  • Join Filter: ((mike.kilo = foxtrot.kilo) OR (mike.kilo five NULL))
  • Rows Removed by Join Filter: 93,942
2. 65.409 65.521 ↑ 1.3 306 1

Nested Loop Left Join (cost=37.190..792.290 rows=389 width=230) (actual time=65.254..65.521 rows=306 loops=1)

  • Join Filter: ((victor_lima.kilo = foxtrot.kilo) OR (victor_lima.kilo five NULL))
3. 0.112 0.112 ↑ 1.0 306 1

Index Scan using lima_five_echo_bravo on victor_two foxtrot (cost=0.270..45.050 rows=306 width=198) (actual time=0.023..0.112 rows=306 loops=1)

4. 0.000 0.000 ↓ 0.0 0 306

Materialize (cost=36.920..40.770 rows=154 width=40) (actual time=0.000..0.000 rows=0 loops=306)

5. 0.001 0.066 ↓ 0.0 0 1

Subquery Scan on victor_lima (cost=36.920..40.000 rows=154 width=40) (actual time=0.065..0.066 rows=0 loops=1)

6. 0.002 0.065 ↓ 0.0 0 1

HashAggregate (cost=36.920..38.460 rows=154 width=48) (actual time=0.065..0.065 rows=0 loops=1)

  • Group Key: golf.zulu, two.quebec_seven
7. 0.000 0.063 ↓ 0.0 0 1

Nested Loop Left Join (cost=19.390..35.760 rows=154 width=21) (actual time=0.063..0.063 rows=0 loops=1)

  • Join Filter: CASE WHEN (papa_kilo_hotel.whiskey_india five NOT NULL) THEN (papa_kilo_hotel.whiskey_india = two.whiskey_india) WHEN (papa_kilo_hotel.lima_five_echo_papa five NOT NULL) THEN (papa_kilo_hotel.lima_five_echo_papa = two.lima_five_echo_papa) ELSE ((papa_kilo_hotel.romeo_seven_two)::text = (two.romeo_seven_two)::text) END
8. 0.015 0.063 ↓ 0.0 0 1

Hash Right Join (cost=19.390..25.290 rows=1 width=24) (actual time=0.063..0.063 rows=0 loops=1)

  • Hash Cond: (papa_kilo_hotel.quebec_seven = golf.kilo)
9. 0.000 0.000 ↓ 0.0 0

Seq Scan on papa_kilo_hotel (cost=0.000..5.080 rows=308 width=19) (never executed)

10. 0.000 0.048 ↓ 0.0 0 1

Hash (cost=19.380..19.380 rows=1 width=21) (actual time=0.048..0.048 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
11. 0.048 0.048 ↓ 0.0 0 1

Index Scan using papa_kilo_echo on delta golf (cost=0.290..19.380 rows=1 width=21) (actual time=0.048..0.048 rows=0 loops=1)

  • Index Cond: ((zulu = 93) AND (charlie = 2))
12. 0.000 0.000 ↓ 0.0 0

Seq Scan on papa_kilo_hotel two (cost=0.000..5.080 rows=308 width=19) (never executed)

13. 5.280 26.622 ↑ 117.0 308 306

Materialize (cost=5,986.210..7,361.430 rows=36,036 width=40) (actual time=0.069..0.087 rows=308 loops=306)

14. 0.041 21.342 ↑ 117.0 308 1

Subquery Scan on mike (cost=5,986.210..7,181.250 rows=36,036 width=40) (actual time=20.978..21.342 rows=308 loops=1)

15. 0.303 21.301 ↑ 117.0 308 1

GroupAggregate (cost=5,986.210..6,820.890 rows=36,036 width=48) (actual time=20.976..21.301 rows=308 loops=1)

  • Group Key: yankee1.zulu, quebec_papa1.quebec_seven
16. 0.299 20.998 ↑ 66.3 715 1

Sort (cost=5,986.210..6,104.790 rows=47,432 width=21) (actual time=20.952..20.998 rows=715 loops=1)

  • Sort Key: quebec_papa1.quebec_seven
  • Sort Method: quicksort Memory: 80kB
17. 12.588 20.699 ↑ 66.3 715 1

Nested Loop Left Join (cost=24.380..2,302.270 rows=47,432 width=21) (actual time=0.216..20.699 rows=715 loops=1)

  • Join Filter: CASE WHEN (bravo1.whiskey_india five NOT NULL) THEN (bravo1.whiskey_india = quebec_papa1.whiskey_india) WHEN (bravo1.lima_five_echo_papa five NOT NULL) THEN (bravo1.lima_five_echo_papa = quebec_papa1.lima_five_echo_papa) ELSE ((bravo1.romeo_seven_two)::text = (quebec_papa1.romeo_seven_two)::text) END
  • Rows Removed by Join Filter: 94,149
18. 0.205 1.643 ↑ 1.0 308 1

Hash Left Join (cost=24.380..399.140 rows=308 width=24) (actual time=0.204..1.643 rows=308 loops=1)

  • Hash Cond: (yankee1.kilo = bravo1.quebec_seven)
19. 1.282 1.315 ↑ 1.0 308 1

Bitmap Heap Scan on delta romeo_seven_three (cost=15.450..389.390 rows=308 width=21) (actual time=0.073..1.315 rows=308 loops=1)

  • Recheck Cond: ((zulu = 93) AND (charlie = 1))
  • Heap Blocks: exact=308
20. 0.033 0.033 ↓ 1.0 309 1

Bitmap Index Scan on papa_kilo_echo (cost=0.000..15.370 rows=308 width=0) (actual time=0.033..0.033 rows=309 loops=1)

  • Index Cond: ((zulu = 93) AND (charlie = 1))
21. 0.059 0.123 ↑ 1.0 308 1

Hash (cost=5.080..5.080 rows=308 width=19) (actual time=0.123..0.123 rows=308 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 23kB
22. 0.064 0.064 ↑ 1.0 308 1

Seq Scan on papa_kilo_hotel whiskey_oscar (cost=0.000..5.080 rows=308 width=19) (actual time=0.012..0.064 rows=308 loops=1)

23. 6.411 6.468 ↑ 1.0 308 308

Materialize (cost=0.000..6.620 rows=308 width=19) (actual time=0.000..0.021 rows=308 loops=308)

24. 0.057 0.057 ↑ 1.0 308 1

Seq Scan on papa_kilo_hotel echo (cost=0.000..5.080 rows=308 width=19) (actual time=0.005..0.057 rows=308 loops=1)