explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yi4p

Settings
# exclusive inclusive rows x rows loops node
1. 0.172 27.066 ↑ 1.0 1 1

Aggregate (cost=183,831.290..183,831.300 rows=1 width=229) (actual time=27.065..27.066 rows=1 loops=1)

2. 0.000 26.894 ↑ 1.0 1 1

Unique (cost=183,732.810..183,732.820 rows=1 width=83) (actual time=26.889..26.894 rows=1 loops=1)

3.          

Initplan (forUnique)

4. 0.000 0.024 ↑ 1.0 1 1

Limit (cost=11.510..11.520 rows=1 width=20) (actual time=0.024..0.024 rows=1 loops=1)

5. 0.010 0.024 ↑ 1.0 1 1

Sort (cost=11.510..11.520 rows=1 width=20) (actual time=0.024..0.024 rows=1 loops=1)

  • Sort Key: alpha_tango.november_seven
  • Sort Method: top-N heapsort Memory: 25kB
6. 0.014 0.014 ↓ 4.0 4 1

Seq Scan on alpha_tango (cost=0.000..11.500 rows=1 width=20) (actual time=0.009..0.014 rows=4 loops=1)

  • Filter: (((four_four)::text = 'yankee'::text) AND ((romeo_mike_two)::text = 'juliet_whiskey'::text))
  • Rows Removed by Filter: 38
7. 0.054 26.889 ↓ 3.0 3 1

Sort (cost=183,721.300..183,721.300 rows=1 width=83) (actual time=26.885..26.889 rows=3 loops=1)

  • Sort Key: romeo_three1.two DESC, romeo_three1.papa_india
  • Sort Method: quicksort Memory: 49kB
8. 0.113 26.835 ↓ 3.0 3 1

Nested Loop (cost=0.000..183,721.290 rows=1 width=83) (actual time=9.363..26.835 rows=3 loops=1)

  • Join Filter: (romeo_three3.sierra_victor = romeo_three2.delta)
  • Rows Removed by Join Filter: 150
9. 0.032 0.076 ↓ 9.0 9 1

Nested Loop (cost=0.000..21.710 rows=1 width=83) (actual time=0.031..0.076 rows=9 loops=1)

  • Join Filter: (romeo_three1.two = romeo_three3.two)
  • Rows Removed by Join Filter: 66
10. 0.014 0.014 ↓ 3.0 3 1

Seq Scan on romeo_mike_golf four_uniform (cost=0.000..19.150 rows=1 width=24) (actual time=0.011..0.014 rows=3 loops=1)

  • Filter: ((india_golf = 10) AND (mike_mike = 'juliet_whiskey'::bpchar))
  • Rows Removed by Filter: 8
11. 0.030 0.030 ↑ 1.0 25 3

Seq Scan on victor_four india_november (cost=0.000..2.250 rows=25 width=59) (actual time=0.002..0.010 rows=25 loops=3)

12. 0.072 0.072 ↑ 1.0 17 9

Seq Scan on seven_five foxtrot (cost=0.000..2.230 rows=17 width=8) (actual time=0.002..0.008 rows=17 loops=9)

  • Filter: (mike_mike = 'juliet_whiskey'::bpchar)
  • Rows Removed by Filter: 1
13.          

SubPlan (forNested Loop)

14. 0.012 0.033 ↑ 1.0 1 3

Aggregate (cost=13.250..13.260 rows=1 width=8) (actual time=0.010..0.011 rows=1 loops=3)

15. 0.021 0.021 ↓ 3.0 3 3

Seq Scan on four_three_papa (cost=0.000..13.250 rows=1 width=8) (actual time=0.006..0.007 rows=3 loops=3)

  • Filter: (delta = romeo_three3.sierra_victor)
  • Rows Removed by Filter: 30
16. 0.012 0.012 ↑ 1.0 1 3

Seq Scan on seven_five (cost=0.000..2.230 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=3)

  • Filter: (quebec = romeo_three1.papa_india)
  • Rows Removed by Filter: 17
17. 0.012 0.012 ↑ 1.0 1 3

Seq Scan on seven_five india_quebec (cost=0.000..2.230 rows=1 width=8) (actual time=0.003..0.004 rows=1 loops=3)

  • Filter: (quebec = romeo_three1.papa_india)
  • Rows Removed by Filter: 17
18. 0.072 0.144 ↑ 1.0 1 3

Hash Semi Join (cost=2.240..3.990 rows=1 width=13) (actual time=0.032..0.048 rows=1 loops=3)

  • Hash Cond: (uniform_lima.four_five = golf1.mike_romeo)
19. 0.048 0.048 ↑ 1.0 59 3

Seq Scan on uniform_lima (cost=0.000..1.590 rows=59 width=21) (actual time=0.002..0.016 rows=59 loops=3)

20. 0.012 0.024 ↑ 1.0 1 3

Hash (cost=2.230..2.230 rows=1 width=8) (actual time=0.008..0.008 rows=1 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
21. 0.012 0.012 ↑ 1.0 1 3

Seq Scan on seven_five alpha_zulu (cost=0.000..2.230 rows=1 width=8) (actual time=0.003..0.004 rows=1 loops=3)

  • Filter: (quebec = romeo_three1.papa_india)
  • Rows Removed by Filter: 17
22. 0.009 0.009 ↑ 1.0 1 3

Seq Scan on seven_five uniform_delta_victor (cost=0.000..2.230 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=3)

  • Filter: (quebec = romeo_three1.papa_india)
  • Rows Removed by Filter: 17
23. 0.378 26.364 ↑ 1.0 1 3

Aggregate (cost=183,673.190..183,673.210 rows=1 width=282) (actual time=8.787..8.788 rows=1 loops=3)

24. 0.018 25.986 ↓ 3.0 3 3

Subquery Scan on romeo_three (cost=183,673.170..183,673.190 rows=1 width=282) (actual time=8.659..8.662 rows=3 loops=3)

25. 0.039 25.968 ↓ 3.0 3 3

Sort (cost=183,673.170..183,673.180 rows=1 width=1,073) (actual time=8.654..8.656 rows=3 loops=3)

  • Sort Key: romeo_three2kilo_oscar2.romeo_yankee
  • Sort Method: quicksort Memory: 29kB
26. 0.450 25.929 ↓ 3.0 3 3

Nested Loop Left Join (cost=183,667.650..183,673.160 rows=1 width=1,073) (actual time=8.572..8.643 rows=3 loops=3)

  • Join Filter: ((romeo_three2kilo_oscar2.two = kilo_tango.two) AND (romeo_three4.seven_uniform = kilo_tango.seven_uniform) AND (romeo_three4.papa_india = kilo_tango.november_kilo))
  • Rows Removed by Join Filter: 28
27. 0.054 25.479 ↓ 3.0 3 3

Unique (cost=183,591.890..183,595.640 rows=1 width=120) (actual time=8.462..8.493 rows=3 loops=3)

28. 0.261 25.425 ↑ 10.9 69 3

Sort (cost=183,591.890..183,593.760 rows=750 width=120) (actual time=8.460..8.475 rows=69 loops=3)

  • Sort Key: romeo_three4.seven_uniform, romeo_three2kilo_oscar2.romeo_yankee
  • Sort Method: quicksort Memory: 44kB
29. 16.569 25.164 ↑ 10.9 69 3

Nested Loop (cost=0.140..183,556.070 rows=750 width=120) (actual time=0.306..8.388 rows=69 loops=3)

30. 0.045 0.450 ↓ 3.0 3 3

Nested Loop (cost=0.140..44.430 rows=1 width=88) (actual time=0.106..0.150 rows=3 loops=3)

  • Join Filter: (romeo_three2kilo_oscar2.delta = romeo_three5.delta)
  • Rows Removed by Join Filter: 6
31. 0.069 0.297 ↓ 9.0 9 3

Nested Loop (cost=0.140..42.100 rows=1 width=96) (actual time=0.020..0.099 rows=9 loops=3)

  • Join Filter: (romeo_three2kilo_oscar2.seven_uniform = romeo_three4.seven_uniform)
  • Rows Removed by Join Filter: 18
32. 0.045 0.120 ↓ 9.0 9 3

Nested Loop (cost=0.140..21.410 rows=1 width=72) (actual time=0.011..0.040 rows=9 loops=3)

33. 0.021 0.021 ↓ 9.0 9 3

Seq Scan on four_three_papa lima (cost=0.000..13.250 rows=1 width=32) (actual time=0.004..0.007 rows=9 loops=3)

  • Filter: (two = romeo_three3.two)
  • Rows Removed by Filter: 24
34. 0.054 0.054 ↑ 1.0 1 27

Index Scan using kilo_lima on seven_mike papa_seven (cost=0.140..8.150 rows=1 width=40) (actual time=0.002..0.002 rows=1 loops=27)

  • Index Cond: (seven_uniform = romeo_three2kilo_oscar2.seven_uniform)
35. 0.108 0.108 ↓ 3.0 3 27

Seq Scan on romeo_mike_golf victor_hotel (cost=0.000..20.680 rows=1 width=32) (actual time=0.003..0.004 rows=3 loops=27)

  • Filter: ((mike_mike = 'juliet_whiskey'::bpchar) AND (papa_india = romeo_three1.papa_india) AND (two = romeo_three3.two))
  • Rows Removed by Filter: 8
36. 0.108 0.108 ↑ 1.0 1 27

Seq Scan on seven_five xray_five (cost=0.000..2.310 rows=1 width=20) (actual time=0.004..0.004 rows=1 loops=27)

  • Filter: ((mike_mike = 'juliet_whiskey'::bpchar) AND (quebec = romeo_three1.papa_india) AND (two = romeo_three3.two))
  • Rows Removed by Filter: 17
37. 0.072 0.072 ↑ 32.6 23 9

Seq Scan on papa_alpha uniform_delta_yankee (cost=0.000..17.500 rows=750 width=32) (actual time=0.001..0.008 rows=23 loops=9)

38.          

SubPlan (forNested Loop)

39. 1.035 1.035 ↑ 1.0 1 207

Seq Scan on uniform_lima four_three_foxtrot (cost=0.000..1.740 rows=1 width=13) (actual time=0.002..0.005 rows=1 loops=207)

  • Filter: (four_five = romeo_three7.juliet_charlie)
  • Rows Removed by Filter: 58
40. 0.414 7.038 ↑ 1.0 1 207

Aggregate (cost=184.030..184.040 rows=1 width=32) (actual time=0.033..0.034 rows=1 loops=207)

41. 6.624 6.624 ↑ 100.0 1 207

Sort (cost=182.530..182.780 rows=100 width=36) (actual time=0.031..0.032 rows=1 loops=207)

  • Sort Key: five.xray_romeo DESC
  • Sort Method: quicksort Memory: 25kB
42.          

CTE five

43. 5.175 5.589 ↑ 33.7 3 207

Recursive Union (cost=22.520..176.940 rows=101 width=46) (actual time=0.006..0.027 rows=3 loops=207)

44. 0.000 0.414 ↑ 1.0 1 207

Index Scan using sierra_foxtrot on echo (cost=22.520..30.540 rows=1 width=42) (actual time=0.002..0.002 rows=1 loops=207)

  • Index Cond: (quebec = $15)
45.          

Initplan (forIndex Scan)

46. 0.621 0.621 ↑ 5.0 1 207

Seq Scan on sierra_alpha (cost=0.000..22.380 rows=5 width=8) (actual time=0.002..0.003 rows=1 loops=207)