explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KclY

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

HashAggregate (cost=143,986.560..143,986.740 rows=18 width=88) (actual rows= loops=)

  • Group Key: juliet_xray2.india_bravo_alpha, kilo_foxtrot2.quebec_seven, (november_three((kilo_foxtrot2.november_lima_uniform1)::text)), (november_three((kilo_foxtrot2.november_lima_uniform2)::text)), juliet_xray2.juliet_charlie, juliet_xray2.six_yankee_three
2. 0.000 0.000 ↓ 0.0

Append (cost=139,951.830..143,986.290 rows=18 width=88) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Unique (cost=139,951.830..139,951.960 rows=9 width=88) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Sort (cost=139,951.830..139,951.850 rows=9 width=88) (actual rows= loops=)

  • Sort Key: kilo_foxtrot2.quebec_seven, (november_three((kilo_foxtrot2.november_lima_uniform1)::text)), (november_three((kilo_foxtrot2.november_lima_uniform2)::text)), juliet_xray2.juliet_charlie, juliet_xray2.six_yankee_three
5. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.280..139,951.690 rows=9 width=88) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.860..139,933.080 rows=9 width=24) (actual rows= loops=)

  • Join Filter: ((juliet_xray.hotel_juliet = juliet_xray2.hotel_juliet) AND (lima_sierra(juliet_xray.victor, 'november_golf'::bigint) = lima_sierra(juliet_xray2.victor, 'november_golf'::bigint)))
7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.860..51.320 rows=1 width=16) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Index Only Scan using alpha_four on two (cost=0.430..8.450 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (quebec_seven = 'five_yankee'::bigint)
9. 0.000 0.000 ↓ 0.0

Index Scan using november_lima_four on romeo juliet_xray (cost=0.430..42.860 rows=1 width=24) (actual rows= loops=)

  • Index Cond: (lima_seven = 'five_yankee'::bigint)
  • Filter: (six_yankee_hotel = 35)
10. 0.000 0.000 ↓ 0.0

Seq Scan on romeo uniform_uniform (cost=0.000..138,510.090 rows=91,445 width=40) (actual rows= loops=)

  • Filter: (india_bravo_alpha = 5)
11. 0.000 0.000 ↓ 0.0

Index Scan using alpha_four on two yankee_xray (cost=0.430..2.050 rows=1 width=22) (actual rows= loops=)

  • Index Cond: (juliet_xray2.lima_seven = quebec_seven)
12. 0.000 0.000 ↓ 0.0

Unique (cost=114.710..114.830 rows=7 width=88) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Sort (cost=114.710..114.730 rows=7 width=88) (actual rows= loops=)

  • Sort Key: juliet_xray2kilo_oscar1.india_bravo_alpha, kilo_foxtrot2kilo_oscar1.quebec_seven, (november_three((kilo_foxtrot2kilo_oscar1.november_lima_uniform1)::text)), (november_three((kilo_foxtrot2kilo_oscar1.november_lima_uniform2)::text)), juliet_xray2kilo_oscar1.juliet_charlie, juliet_xray2kilo_oscar1.six_yankee_three
14. 0.000 0.000 ↓ 0.0

Nested Loop (cost=3.130..114.610 rows=7 width=88) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.710..111.060 rows=7 width=24) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.270..105.790 rows=7 width=8) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.850..102.860 rows=6 width=16) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.420..100.090 rows=6 width=8) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.860..51.320 rows=1 width=8) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Index Only Scan using alpha_four on two echo (cost=0.430..8.450 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (quebec_seven = 'five_yankee'::bigint)
21. 0.000 0.000 ↓ 0.0

Index Scan using november_lima_four on romeo (cost=0.430..42.860 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (lima_seven = 'five_yankee'::bigint)
  • Filter: (six_yankee_hotel = 35)
22. 0.000 0.000 ↓ 0.0

Index Only Scan using five_victor on papa (cost=0.560..48.540 rows=23 width=16) (actual rows= loops=)

  • Index Cond: (hotel_whiskey = romeo.quebec_seven)
23. 0.000 0.000 ↓ 0.0

Index Only Scan using zulu on juliet_foxtrot (cost=0.430..0.450 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (quebec_seven = papa.hotel_foxtrot)
24. 0.000 0.000 ↓ 0.0

Index Scan using mike on tango_uniform (cost=0.430..0.470 rows=2 width=16) (actual rows= loops=)

  • Index Cond: (hotel_foxtrot = papa.hotel_foxtrot)
25. 0.000 0.000 ↓ 0.0

Index Scan using five_whiskey on romeo delta_yankee (cost=0.430..0.740 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (quebec_seven = tango_uniform.foxtrot_six)
26. 0.000 0.000 ↓ 0.0

Index Scan using alpha_four on two alpha_bravo (cost=0.430..0.490 rows=1 width=22) (actual rows= loops=)

  • Index Cond: (quebec_seven = juliet_xray2kilo_oscar1.lima_seven)
27. 0.000 0.000 ↓ 0.0

Unique (cost=3,752.740..3,752.760 rows=1 width=88) (actual rows= loops=)

28. 0.000 0.000 ↓ 0.0

Sort (cost=3,752.740..3,752.750 rows=1 width=88) (actual rows= loops=)

  • Sort Key: kilo_foxtrot.quebec_seven, (november_three((kilo_foxtrot.november_lima_uniform1)::text)), (november_three((kilo_foxtrot.november_lima_uniform2)::text)), india_romeo1.juliet_charlie, india_romeo1.six_yankee_three
29. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.280..3,752.730 rows=1 width=88) (actual rows= loops=)

30. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.850..3,744.270 rows=1 width=24) (actual rows= loops=)

31. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.420..3,735.920 rows=1 width=8) (actual rows= loops=)

32. 0.000 0.000 ↓ 0.0

Seq Scan on quebec_papa (cost=0.000..13.820 rows=482 width=16) (actual rows= loops=)

33. 0.000 0.000 ↓ 0.0

Index Scan using lima_xray on yankee_oscar (cost=0.420..7.710 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (quebec_seven = quebec_papa.four)
  • Filter: (uniform_tango = 'five_yankee'::bigint)
34. 0.000 0.000 ↓ 0.0

Index Scan using five_whiskey on romeo quebec_oscar (cost=0.430..8.340 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (quebec_seven = quebec_papa.india_bravo_juliet)
  • Filter: ((india_bravo_alpha = 20) AND (six_yankee_hotel = 35))
35. 0.000 0.000 ↓ 0.0

Index Scan using alpha_four on two kilo_foxtrot (cost=0.430..8.450 rows=1 width=22) (actual rows= loops=)

  • Index Cond: (quebec_seven = india_romeo1.lima_seven)
36. 0.000 0.000 ↓ 0.0

Unique (cost=166.530..166.550 rows=1 width=88) (actual rows= loops=)

37. 0.000 0.000 ↓ 0.0

Sort (cost=166.530..166.540 rows=1 width=88) (actual rows= loops=)

  • Sort Key: oscar1.quebec_seven, (november_three((oscar1.november_lima_uniform1)::text)), (november_three((oscar1.november_lima_uniform2)::text)), india_romeo2.juliet_charlie, india_romeo2.six_yankee_three
38. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.280..166.520 rows=1 width=88) (actual rows= loops=)

39. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.860..161.140 rows=1 width=24) (actual rows= loops=)

40. 0.000 0.000 ↓ 0.0

Index Scan using november_lima_four on romeo hotel_five (cost=0.430..42.840 rows=10 width=8) (actual rows= loops=)

  • Index Cond: (lima_seven = 'five_yankee'::bigint)
41. 0.000 0.000 ↓ 0.0

Index Scan using tango_oscar on romeo delta_five (cost=0.430..11.820 rows=1 width=32) (actual rows= loops=)

  • Index Cond: (hotel_whiskey = foxtrot_four1.quebec_seven)
  • Filter: ((india_bravo_alpha = 3) AND (six_yankee_hotel = 35))
42. 0.000 0.000 ↓ 0.0

Index Scan using alpha_four on two juliet_juliet (cost=0.430..5.370 rows=1 width=22) (actual rows= loops=)

  • Index Cond: (quebec_seven = india_romeo2.lima_seven)