explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9tF8 : Old

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 31,369.562 ↑ 1.0 20 1

Limit (cost=4.100..33,288.600 rows=20 width=755) (actual time=24,980.147..31,369.562 rows=20 loops=1)

2. 24.345 31,369.526 ↑ 12.1 20 1

Nested Loop Left Join (cost=4.100..401,079.890 rows=241 width=755) (actual time=24,980.146..31,369.526 rows=20 loops=1)

3. 51.137 31,345.181 ↑ 12.1 20 1

Nested Loop Left Join (cost=3.670..399,394.530 rows=241 width=572) (actual time=24,975.349..31,345.181 rows=20 loops=1)

4. 0.120 31,294.044 ↑ 12.1 20 1

Nested Loop Left Join (cost=3.250..399,120.910 rows=241 width=564) (actual time=24,968.699..31,294.044 rows=20 loops=1)

  • Join Filter: (november_echo.mike_tango = kilo_sierra_mike.mike_tango)
  • Rows Removed by Join Filter: 43
5. 18.172 31,293.924 ↑ 12.1 20 1

Nested Loop Left Join (cost=3.250..399,104.170 rows=241 width=548) (actual time=24,968.672..31,293.924 rows=20 loops=1)

6. 6.210 31,275.752 ↑ 12.1 20 1

Nested Loop Left Join (cost=2.960..399,029.880 rows=241 width=505) (actual time=24,968.124..31,275.752 rows=20 loops=1)

  • Join Filter: ((charlie_charlie.whiskey)::text = (four_hotel.golf_hotel)::text)
  • Rows Removed by Join Filter: 10957
7. 3.731 31,269.542 ↑ 12.1 20 1

Nested Loop Left Join (cost=2.960..396,718.810 rows=241 width=481) (actual time=24,965.546..31,269.542 rows=20 loops=1)

  • Join Filter: ((three_seven.oscar_golf)::text = (four_hotel.india_papa)::text)
  • Rows Removed by Join Filter: 8019
8. 120.712 31,265.811 ↑ 12.1 20 1

Nested Loop Left Join (cost=2.960..394,113.150 rows=241 width=457) (actual time=24,964.514..31,265.811 rows=20 loops=1)

  • Join Filter: ((sierra_six.four_yankee)::text = CASE WHEN (romeo_quebec.uniform_foxtrot > 0) THEN 'uniform_five'::text ELSE 'delta_oscar'::text END)
9. 2.035 31,145.099 ↑ 12.1 20 1

Nested Loop Left Join (cost=2.540..393,845.190 rows=241 width=335) (actual time=24,950.547..31,145.099 rows=20 loops=1)

10. 4.205 31,143.064 ↑ 12.1 20 1

Nested Loop Left Join (cost=2.260..393,773.950 rows=241 width=321) (actual time=24,950.516..31,143.064 rows=20 loops=1)

11. 74.454 31,138.859 ↑ 12.1 20 1

Nested Loop Left Join (cost=1.980..393,701.030 rows=241 width=295) (actual time=24,949.984..31,138.859 rows=20 loops=1)

12. 31,064.405 31,064.405 ↑ 12.1 20 1

Nested Loop Left Join (cost=1.420..393,333.450 rows=241 width=273) (actual time=24,936.342..31,064.405 rows=20 loops=1)

  • Join Filter: ((zulu_lima.romeo_romeo)::text = (five_hotel.bravo)::text)
  • Rows Removed by Join Filter: 23
13. 0.133 31,064.275 ↑ 12.1 20 1

Nested Loop (cost=1.420..393,259.430 rows=241 width=277) (actual time=24,936.330..31,064.275 rows=20 loops=1)

14. 3.925 31,050.742 ↑ 12.1 20 1

Nested Loop (cost=0.990..392,993.570 rows=241 width=224) (actual time=24,935.513..31,050.742 rows=20 loops=1)

15. 149.328 29,372.157 ↑ 1.7 1,235 1

Nested Loop (cost=0.560..387,909.900 rows=2,086 width=177) (actual time=79.486..29,372.157 rows=1,235 loops=1)

16. 265.189 265.189 ↓ 4.1 123,224 1

Seq Scan on seven_five zulu_tango (cost=0.000..220,027.940 rows=29,993 width=73) (actual time=0.312..265.189 rows=123,224 loops=1)

  • Filter: (((five_charlie)::date >= 'alpha_alpha'::date) AND ((five_charlie)::date <= 'romeo_xray_charlie'::date))
  • Rows Removed by Filter: 129573
17. 28,957.640 28,957.640 ↓ 0.0 0 123,224

Index Scan using romeo_charlie on sierra_victor romeo_quebec (cost=0.560..5.600 rows=1 width=104) (actual time=0.235..0.235 rows=0 loops=123,224)

  • Index Cond: ((india_zulu)::text = (zulu_tango.india_zulu)::text)
  • Filter: (juliet_charlie = ANY ('juliet_alpha'::bpchar[]))
  • Rows Removed by Filter: 1
18. 1,674.660 1,674.660 ↓ 0.0 0 1,235

Index Scan using kilo_lima on charlie_six kilo_sierra_mike (cost=0.430..2.440 rows=1 width=47) (actual time=1.356..1.356 rows=0 loops=1,235)

  • Index Cond: ((romeo_xray_five)::text = (romeo_quebec.romeo_xray_five)::text)
  • Filter: (five_four = 1)
  • Rows Removed by Filter: 1
19. 13.360 13.360 ↑ 1.0 1 20

Index Scan using mike_five on romeo_victor five_hotel (cost=0.430..1.100 rows=1 width=68) (actual time=0.668..0.668 rows=1 loops=20)

  • Index Cond: ((four_papa)::text = (kilo_sierra_mike.four_papa)::text)
20. 0.031 0.040 ↑ 10.5 2 20

Materialize (cost=0.000..1.310 rows=21 width=14) (actual time=0.001..0.002 rows=2 loops=20)

21. 0.009 0.009 ↑ 1.9 11 1

Seq Scan on alpha_yankee zulu_lima (cost=0.000..1.210 rows=21 width=14) (actual time=0.005..0.009 rows=11 loops=1)

22. 0.000 74.320 ↑ 1.0 1 20

Index Scan using six_two on quebec four_hotel (cost=0.560..1.520 rows=1 width=42) (actual time=3.714..3.716 rows=1 loops=20)

  • Index Cond: ((romeo_xray_five)::text = (romeo_quebec.romeo_xray_five)::text)
  • Filter: (kilo_sierra_romeo = romeo_quebec.kilo_sierra_romeo)
23. 4.060 4.060 ↑ 1.0 1 20

Index Scan using seven_oscar on victor_oscar tango_whiskey (cost=0.290..0.300 rows=1 width=26) (actual time=0.203..0.203 rows=1 loops=20)

  • Index Cond: (tango_romeo = four_hotel.victor_uniform_oscar)
24. 1.900 1.900 ↑ 1.0 1 20

Index Scan using delta_victor on golf_two six_seven (cost=0.280..0.300 rows=1 width=30) (actual time=0.095..0.095 rows=1 loops=20)

  • Index Cond: ((five_zulu)::text = (kilo_sierra_mike.delta_four)::text)
25. 120.480 120.480 ↑ 1.0 1 20

Index Scan using charlie_delta on alpha_hotel sierra_six (cost=0.420..1.090 rows=1 width=131) (actual time=6.024..6.024 rows=1 loops=20)

  • Index Cond: ((lima)::text = (zulu_tango.india_delta)::text)
26. 1.050 1.960 ↑ 1.8 402 20

Materialize (cost=0.000..22.720 rows=715 width=32) (actual time=0.022..0.098 rows=402 loops=20)

27. 0.910 0.910 ↑ 1.6 442 1

Seq Scan on victor_uniform_xray three_seven (cost=0.000..19.150 rows=715 width=32) (actual time=0.410..0.910 rows=442 loops=1)

28. 1.420 3.720 ↑ 1.1 549 20

Materialize (cost=0.000..42.420 rows=628 width=34) (actual time=0.017..0.186 rows=549 loops=20)

29. 2.300 2.300 ↑ 1.0 626 1

Seq Scan on three_foxtrot charlie_charlie (cost=0.000..39.280 rows=628 width=34) (actual time=0.309..2.300 rows=626 loops=1)

30. 18.040 18.040 ↑ 1.0 1 20

Index Scan using six_juliet on oscar_juliet four_seven (cost=0.290..0.310 rows=1 width=47) (actual time=0.902..0.902 rows=1 loops=20)

  • Index Cond: (kilo_sierra_romeo = four_hotel.kilo_sierra_romeo)
31. 0.027 0.040 ↑ 1.7 3 20

Materialize (cost=0.000..1.070 rows=5 width=20) (actual time=0.001..0.002 rows=3 loops=20)

32. 0.013 0.013 ↑ 1.2 4 1

Seq Scan on romeo_mike november_echo (cost=0.000..1.050 rows=5 width=20) (actual time=0.012..0.013 rows=4 loops=1)

33. 50.980 50.980 ↑ 1.0 1 20

Index Scan using papa on five_six victor_india (cost=0.420..1.140 rows=1 width=12) (actual time=2.549..2.549 rows=1 loops=20)

  • Index Cond: (uniform_india = zulu_tango.kilo_whiskey)
34. 18.920 18.920 ↑ 1.0 1 20

Index Scan using oscar_oscar on november_yankee tango_sierra (cost=0.430..6.420 rows=1 width=28) (actual time=0.553..0.946 rows=1 loops=20)

  • Filter: (zulu_tango.kilo_whiskey = uniform_india)
  • Rows Removed by Filter: 1
35.          

SubPlan (for Index Scan)

36. 0.040 0.040 ↑ 1.0 1 20

Result (cost=0.000..0.020 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=20)