explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5JqX

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

Merge Left Join (cost=76,326.840..217,380.840 rows=1,164 width=19,341) (actual rows= loops=)

  • Merge Cond: ((delta_echo.bravo)::text = (delta_bravo.bravo)::text)
  • Join Filter: ((delta_echo.november)::text = (delta_bravo.november)::text)
2. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=76,324.470..217,375.450 rows=1,164 width=18,663) (actual rows= loops=)

  • Merge Cond: ((delta_echo.bravo)::text = (oscar_sierra.bravo)::text)
  • Join Filter: ((delta_echo.november)::text = (oscar_sierra.november)::text)
3. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=76,322.100..217,370.060 rows=1,164 width=18,345) (actual rows= loops=)

  • Merge Cond: ((delta_echo.bravo)::text = (whiskey_kilo.bravo)::text)
  • Join Filter: ((delta_echo.november)::text = (whiskey_kilo.november)::text)
4. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=76,319.720..217,364.660 rows=1,164 width=17,989) (actual rows= loops=)

  • Merge Cond: ((delta_echo.bravo)::text = (alpha_oscar.bravo)::text)
  • Join Filter: ((delta_echo.november)::text = (alpha_oscar.november)::text)
5. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=76,317.350..217,359.270 rows=1,164 width=16,995) (actual rows= loops=)

  • Merge Cond: ((delta_echo.bravo)::text = (three_victor.bravo)::text)
  • Join Filter: ((delta_echo.november)::text = (three_victor.november)::text)
6. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=76,314.980..217,353.880 rows=1,164 width=16,051) (actual rows= loops=)

  • Merge Cond: ((delta_echo.bravo)::text = (charlie_tango.bravo)::text)
  • Join Filter: ((delta_echo.november)::text = (charlie_tango.november)::text)
7. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=76,312.610..217,348.490 rows=1,164 width=15,565) (actual rows= loops=)

  • Merge Cond: ((delta_echo.bravo)::text = (zulu_hotel.bravo)::text)
  • Join Filter: ((delta_echo.november)::text = (zulu_hotel.november)::text)
8. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1,026.940..142,040.890 rows=612 width=14,889) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=1,026.380..3,552.200 rows=176 width=13,319) (actual rows= loops=)

  • Merge Cond: ((delta_echo.bravo)::text = (sierra.bravo)::text)
  • Join Filter: ((delta_echo.november)::text = (sierra.november)::text)
10. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=1,024.010..3,549.380 rows=176 width=12,259) (actual rows= loops=)

  • Merge Cond: ((delta_echo.bravo)::text = (oscar_three.bravo)::text)
  • Join Filter: ((delta_echo.november)::text = (oscar_three.november)::text)
11. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=1,021.640..3,546.550 rows=176 width=11,111) (actual rows= loops=)

  • Merge Cond: ((delta_echo.bravo)::text = (six_juliet_echo.bravo)::text)
  • Join Filter: ((delta_echo.november)::text = (six_juliet_echo.november)::text)
12. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1,019.270..3,543.710 rows=176 width=10,625) (actual rows= loops=)

  • Join Filter: ((delta_echo.bravo)::text = (four1.tango_mike)::text)
13. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,018.270..2,239.180 rows=176 width=9,065) (actual rows= loops=)

  • Join Filter: ((delta_echo.bravo)::text = (seven.bravo)::text)
14. 0.000 0.000 ↓ 0.0

Index Scan using hotel_foxtrot on seven (cost=0.560..6.150 rows=4 width=514) (actual rows= loops=)

  • Index Cond: (((golf_foxtrot)::text = 'papa_tango_echo'::text) AND ((november)::text = 'six_juliet_six'::text) AND (india_yankee_delta = 'delta_oscar'::bpchar))
15. 0.000 0.000 ↓ 0.0

Materialize (cost=1,017.710..2,222.910 rows=176 width=8,727) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=1,017.710..2,222.030 rows=176 width=8,727) (actual rows= loops=)

  • Hash Cond: (((mike_alpha.november)::text = (delta_echo.november)::text) AND ((mike_alpha.bravo)::text = (delta_echo.bravo)::text))
17. 0.000 0.000 ↓ 0.0

Index Scan using juliet_six on mike_alpha (cost=0.560..1,189.890 rows=1,056 width=472) (actual rows= loops=)

  • Index Cond: (((november)::text = 'six_juliet_six'::text) AND (india_yankee_delta = 'delta_oscar'::bpchar))
18. 0.000 0.000 ↓ 0.0

Hash (cost=1,016.630..1,016.630 rows=34 width=8,431) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=2.400..1,016.630 rows=34 width=8,431) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.830..973.650 rows=4 width=7,051) (actual rows= loops=)

21. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.270..27.050 rows=1 width=5,693) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.130..24.670 rows=1 width=5,233) (actual rows= loops=)

  • Join Filter: (((delta_echo.november)::text = (whiskey_whiskey.november)::text) AND ((delta_echo.bravo)::text = (whiskey_whiskey.bravo)::text))
23. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.700..22.010 rows=1 width=4,968) (actual rows= loops=)

  • Join Filter: (((delta_echo.november)::text = (india_six.november)::text) AND ((delta_echo.bravo)::text = (india_six.bravo)::text))
24. 0.000 0.000 ↓ 0.0

Index Scan using yankee on delta_echo (cost=0.560..19.640 rows=1 width=2,070) (actual rows= loops=)

  • Index Cond: ((golf_mike = hotel_delta('three_oscar'::character varying, 'alpha_kilo'::character varying)) AND (whiskey_seven = 'uniform'::bpchar) AND ((november)::text = 'six_juliet_six'::text))
  • Filter: ((india_yankee_delta = 'delta_oscar'::bpchar) AND (kilo = 'delta_oscar'::bpchar))
25. 0.000 0.000 ↓ 0.0

Index Scan using charlie_echo on india_six (cost=0.140..2.360 rows=1 width=3,074) (actual rows= loops=)

  • Index Cond: ((november)::text = 'six_juliet_six'::text)
  • Filter: ((mike_seven five NULL) AND (india_yankee_delta = 'delta_oscar'::bpchar))
26. 0.000 0.000 ↓ 0.0

Index Scan using romeo_tango on whiskey_whiskey (cost=0.420..2.650 rows=1 width=283) (actual rows= loops=)

  • Index Cond: ((november)::text = 'six_juliet_six'::text)
  • Filter: (india_yankee_delta = 'delta_oscar'::bpchar)
27. 0.000 0.000 ↓ 0.0

Index Scan using juliet_xray_oscar on india_yankee_november (cost=0.140..2.370 rows=1 width=476) (actual rows= loops=)

  • Index Cond: (((delta_echo.november)::text = (november)::text) AND ((november)::text = 'six_juliet_six'::text) AND ((delta_echo.bravo)::text = (bravo)::text))
  • Filter: (india_yankee_delta = 'delta_oscar'::bpchar)
28. 0.000 0.000 ↓ 0.0

Index Scan using hotel_mike on zulu_november (cost=0.560..946.560 rows=4 width=1,534) (actual rows= loops=)

  • Index Cond: (((delta_echo.november)::text = (november)::text) AND ((november)::text = 'six_juliet_six'::text) AND ((delta_echo.bravo)::text = (bravo)::text))
  • Filter: (india_yankee_delta = 'delta_oscar'::bpchar)
29. 0.000 0.000 ↓ 0.0

Index Scan using foxtrot on mike_juliet (cost=0.560..10.670 rows=8 width=1,556) (actual rows= loops=)

  • Index Cond: (((delta_echo.november)::text = (november)::text) AND ((november)::text = 'six_juliet_six'::text) AND ((delta_echo.bravo)::text = (bravo)::text) AND (india_yankee_delta = 'delta_oscar'::bpchar))
30. 0.000 0.000 ↓ 0.0

Materialize (cost=0.990..1,297.500 rows=2 width=1,564) (actual rows= loops=)

31. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.990..1,297.490 rows=2 width=1,564) (actual rows= loops=)

32. 0.000 0.000 ↓ 0.0

Index Scan using yankee on delta_echo whiskey_echo (cost=0.560..824.370 rows=4 width=180) (actual rows= loops=)

  • Index Cond: ((golf_mike = hotel_delta('three_oscar'::character varying, 'alpha_kilo'::character varying)) AND (whiskey_seven = 'delta_oscar'::bpchar))
  • Filter: (india_yankee_delta = 'delta_oscar'::bpchar)
33. 0.000 0.000 ↓ 0.0

Index Scan using lima on zulu_victor tango_tango (cost=0.430..118.270 rows=1 width=1,560) (actual rows= loops=)

  • Index Cond: (((november)::text = (four1.november)::text) AND ((bravo)::text = (four1.bravo)::text))
  • Filter: (india_yankee_delta = 'delta_oscar'::bpchar)
34. 0.000 0.000 ↓ 0.0

Sort (cost=2.370..2.380 rows=1 width=662) (actual rows= loops=)

  • Sort Key: six_juliet_echo.bravo
35. 0.000 0.000 ↓ 0.0

Index Scan using delta_alpha on six_juliet_echo (cost=0.140..2.360 rows=1 width=662) (actual rows= loops=)

  • Index Cond: ((november)::text = 'six_juliet_six'::text)
  • Filter: (india_yankee_delta = 'delta_oscar'::bpchar)
36. 0.000 0.000 ↓ 0.0

Sort (cost=2.370..2.380 rows=1 width=1,324) (actual rows= loops=)

  • Sort Key: oscar_three.bravo
37. 0.000 0.000 ↓ 0.0

Index Scan using xray on oscar_three (cost=0.140..2.360 rows=1 width=1,324) (actual rows= loops=)

  • Index Cond: ((november)::text = 'six_juliet_six'::text)
  • Filter: (india_yankee_delta = 'delta_oscar'::bpchar)
38. 0.000 0.000 ↓ 0.0

Sort (cost=2.370..2.380 rows=1 width=1,236) (actual rows= loops=)

  • Sort Key: sierra.bravo
39. 0.000 0.000 ↓ 0.0

Index Scan using romeo_yankee on sierra (cost=0.140..2.360 rows=1 width=1,236) (actual rows= loops=)

  • Index Cond: ((november)::text = 'six_juliet_six'::text)
  • Filter: (india_yankee_delta = 'delta_oscar'::bpchar)
40. 0.000 0.000 ↓ 0.0

Index Scan using papa_tango_six on hotel_bravo (cost=0.560..786.840 rows=3 width=1,746) (actual rows= loops=)

  • Index Cond: (((delta_echo.november)::text = (november)::text) AND ((november)::text = 'six_juliet_six'::text) AND ((delta_echo.bravo)::text = (bravo)::text))
  • Filter: (india_yankee_delta = 'delta_oscar'::bpchar)
41. 0.000 0.000 ↓ 0.0

Sort (cost=75,285.670..75,286.620 rows=381 width=852) (actual rows= loops=)

  • Sort Key: zulu_hotel.bravo
42. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on zulu_hotel (cost=998.250..75,269.340 rows=381 width=852) (actual rows= loops=)

  • Recheck Cond: ((november)::text = 'six_juliet_six'::text)
  • Filter: (india_yankee_delta = 'delta_oscar'::bpchar)
43. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on whiskey_hotel (cost=0.000..998.150 rows=76,252 width=0) (actual rows= loops=)

  • Index Cond: ((november)::text = 'six_juliet_six'::text)
44. 0.000 0.000 ↓ 0.0

Materialize (cost=2.370..2.380 rows=1 width=662) (actual rows= loops=)

45. 0.000 0.000 ↓ 0.0

Sort (cost=2.370..2.380 rows=1 width=662) (actual rows= loops=)

  • Sort Key: charlie_tango.bravo
46. 0.000 0.000 ↓ 0.0

Index Scan using quebec on charlie_tango (cost=0.140..2.360 rows=1 width=662) (actual rows= loops=)

  • Index Cond: ((november)::text = 'six_juliet_six'::text)
  • Filter: (india_yankee_delta = 'delta_oscar'::bpchar)
47. 0.000 0.000 ↓ 0.0

Materialize (cost=2.370..2.380 rows=1 width=1,120) (actual rows= loops=)

48. 0.000 0.000 ↓ 0.0

Sort (cost=2.370..2.380 rows=1 width=1,120) (actual rows= loops=)

  • Sort Key: three_victor.bravo
49. 0.000 0.000 ↓ 0.0

Index Scan using whiskey_tango on three_victor (cost=0.140..2.360 rows=1 width=1,120) (actual rows= loops=)

  • Index Cond: ((november)::text = 'six_juliet_six'::text)
  • Filter: (india_yankee_delta = 'delta_oscar'::bpchar)
50. 0.000 0.000 ↓ 0.0

Materialize (cost=2.370..2.380 rows=1 width=1,170) (actual rows= loops=)

51. 0.000 0.000 ↓ 0.0

Sort (cost=2.370..2.380 rows=1 width=1,170) (actual rows= loops=)

  • Sort Key: alpha_oscar.bravo
52. 0.000 0.000 ↓ 0.0

Index Scan using juliet_xray_india on alpha_oscar (cost=0.140..2.360 rows=1 width=1,170) (actual rows= loops=)

  • Index Cond: ((november)::text = 'six_juliet_six'::text)
  • Filter: (india_yankee_delta = 'delta_oscar'::bpchar)
53. 0.000 0.000 ↓ 0.0

Materialize (cost=2.370..2.380 rows=1 width=532) (actual rows= loops=)

54. 0.000 0.000 ↓ 0.0

Sort (cost=2.370..2.380 rows=1 width=532) (actual rows= loops=)

  • Sort Key: whiskey_kilo.bravo
55. 0.000 0.000 ↓ 0.0

Index Scan using tango_bravo on whiskey_kilo (cost=0.140..2.360 rows=1 width=532) (actual rows= loops=)

  • Index Cond: ((november)::text = 'six_juliet_six'::text)
  • Filter: (india_yankee_delta = 'delta_oscar'::bpchar)
56. 0.000 0.000 ↓ 0.0

Materialize (cost=2.370..2.380 rows=1 width=494) (actual rows= loops=)

57. 0.000 0.000 ↓ 0.0

Sort (cost=2.370..2.380 rows=1 width=494) (actual rows= loops=)

  • Sort Key: oscar_sierra.bravo
58. 0.000 0.000 ↓ 0.0

Index Scan using six_four on oscar_sierra (cost=0.140..2.360 rows=1 width=494) (actual rows= loops=)

  • Index Cond: ((november)::text = 'six_juliet_six'::text)
  • Filter: (india_yankee_delta = 'delta_oscar'::bpchar)
59. 0.000 0.000 ↓ 0.0

Materialize (cost=2.370..2.380 rows=1 width=854) (actual rows= loops=)

60. 0.000 0.000 ↓ 0.0

Sort (cost=2.370..2.380 rows=1 width=854) (actual rows= loops=)

  • Sort Key: delta_bravo.bravo
61. 0.000 0.000 ↓ 0.0

Index Scan using papa_papa on delta_bravo (cost=0.140..2.360 rows=1 width=854) (actual rows= loops=)

  • Index Cond: ((november)::text = 'six_juliet_six'::text)
  • Filter: (india_yankee_delta = 'delta_oscar'::bpchar)