explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3TKB

Settings
# exclusive inclusive rows x rows loops node
1. 0.067 25.051 ↑ 1.0 100 1

Limit (cost=1.400..12,621.800 rows=100 width=1,237) (actual time=3.088..25.051 rows=100 loops=1)

2. 0.581 24.984 ↑ 5.9 100 1

Nested Loop Left Join (cost=1.400..74,966.550 rows=594 width=1,237) (actual time=3.086..24.984 rows=100 loops=1)

3. 0.434 22.403 ↑ 5.9 100 1

Nested Loop Left Join (cost=0.980..58,137.720 rows=594 width=869) (actual time=2.978..22.403 rows=100 loops=1)

  • Join Filter: (golf_golf.yankee_oscar = "yankee_tango".quebec)
  • Rows Removed by Join Filter: 1400
4. 0.195 21.669 ↑ 5.9 100 1

Nested Loop Left Join (cost=0.980..58,011.800 rows=594 width=857) (actual time=2.955..21.669 rows=100 loops=1)

  • Join Filter: (lima_november.alpha_november = alpha_november.quebec)
  • Rows Removed by Join Filter: 198
5. 0.243 21.374 ↑ 5.9 100 1

Nested Loop Left Join (cost=0.980..57,984.030 rows=594 width=852) (actual time=2.946..21.374 rows=100 loops=1)

  • Join Filter: (golf_golf.yankee_uniform = "romeo_kilo".quebec)
  • Rows Removed by Join Filter: 595
6. 0.188 20.931 ↑ 5.9 100 1

Nested Loop Left Join (cost=0.980..57,920.580 rows=594 width=832) (actual time=2.934..20.931 rows=100 loops=1)

  • Join Filter: (golf_golf.four_echo = "five_papa".quebec)
  • Rows Removed by Join Filter: 600
7. 0.135 20.543 ↑ 5.9 100 1

Nested Loop Left Join (cost=0.980..57,866.040 rows=594 width=826) (actual time=2.920..20.543 rows=100 loops=1)

  • Join Filter: (golf_golf.echo_four_quebec = echo_four_quebec.quebec)
  • Rows Removed by Join Filter: 99
8. 0.299 20.308 ↑ 5.9 100 1

Nested Loop Left Join (cost=0.980..57,847.200 rows=594 width=820) (actual time=2.912..20.308 rows=100 loops=1)

  • Join Filter: (golf_golf.india_juliet_kilo = "alpha_xray".quebec)
  • Rows Removed by Join Filter: 495
9. 0.156 19.909 ↑ 5.9 100 1

Nested Loop Left Join (cost=0.980..57,792.660 rows=594 width=809) (actual time=2.899..19.909 rows=100 loops=1)

  • Join Filter: (golf_golf.whiskey_alpha = whiskey_alpha.quebec)
  • Rows Removed by Join Filter: 198
10. 0.272 19.653 ↑ 5.9 100 1

Nested Loop Left Join (cost=0.980..57,764.890 rows=594 width=802) (actual time=2.891..19.653 rows=100 loops=1)

  • Join Filter: (golf_golf.sierra_bravo = sierra_bravo.quebec)
  • Rows Removed by Join Filter: 396
11. 0.151 19.281 ↑ 5.9 100 1

Nested Loop (cost=0.980..57,719.280 rows=594 width=790) (actual time=2.869..19.281 rows=100 loops=1)

12. 3.559 18.730 ↑ 5.9 100 1

Nested Loop Left Join (cost=0.550..56,362.510 rows=594 width=222) (actual time=2.856..18.730 rows=100 loops=1)

  • Filter: (golf_romeo(lima_four(five_echo('echo_four_mike'::text, november_xray1.seven_six, november_xray2.seven_six), ''victor_delta'six_victor'::text)
  • Rows Removed by Filter: 2827
13. 7.749 15.171 ↑ 40.6 2,927 1

Nested Loop Left Join (cost=0.420..36,139.890 rows=118,886 width=211) (actual time=0.041..15.171 rows=2,927 loops=1)

  • Join Filter: (golf_golf.november_xray1uniform = november_xray1.quebec)
  • Rows Removed by Join Filter: 23259
14. 1.568 1.568 ↑ 40.6 2,927 1

Index Scan using charlie_foxtrot on golf_golf (cost=0.420..21,872.470 rows=118,886 width=200) (actual time=0.015..1.568 rows=2,927 loops=1)

15. 5.844 5.854 ↑ 1.0 8 2,927

Materialize (cost=0.000..1.120 rows=8 width=19) (actual time=0.000..0.002 rows=8 loops=2,927)

16. 0.010 0.010 ↑ 1.0 8 1

Seq Scan on november_xray sierra_november (cost=0.000..1.080 rows=8 width=19) (actual time=0.008..0.010 rows=8 loops=1)

17. 0.000 0.000 ↓ 0.0 0 2,927

Index Scan using five_zulu on november_xray seven_seven (cost=0.130..0.150 rows=1 width=19) (actual time=0.000..0.000 rows=0 loops=2,927)

  • Index Cond: (golf_golf.november_xray2uniform = quebec)
18. 0.400 0.400 ↑ 1.0 1 100

Index Scan using victor_two on lima_november (cost=0.430..2.270 rows=1 width=576) (actual time=0.003..0.004 rows=1 loops=100)

  • Index Cond: (quebec = golf_golf.india_juliet_juliet)
19. 0.091 0.100 ↑ 1.0 5 100

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

20. 0.009 0.009 ↑ 1.0 5 1

Seq Scan on sierra_bravo (cost=0.000..1.050 rows=5 width=20) (actual time=0.008..0.009 rows=5 loops=1)

21. 0.095 0.100 ↑ 1.0 3 100

Materialize (cost=0.000..1.040 rows=3 width=15) (actual time=0.000..0.001 rows=3 loops=100)

22. 0.005 0.005 ↑ 1.0 3 1

Seq Scan on whiskey_alpha (cost=0.000..1.030 rows=3 width=15) (actual time=0.003..0.005 rows=3 loops=1)

23. 0.092 0.100 ↑ 1.0 6 100

Materialize (cost=0.000..1.090 rows=6 width=19) (actual time=0.000..0.001 rows=6 loops=100)

24. 0.008 0.008 ↑ 1.0 6 1

Seq Scan on india_juliet_kilo alpha_xray (cost=0.000..1.060 rows=6 width=19) (actual time=0.004..0.008 rows=6 loops=1)

25. 0.097 0.100 ↑ 1.0 2 100

Materialize (cost=0.000..1.030 rows=2 width=14) (actual time=0.000..0.001 rows=2 loops=100)

26. 0.003 0.003 ↑ 1.0 2 1

Seq Scan on echo_four_quebec (cost=0.000..1.020 rows=2 width=14) (actual time=0.003..0.003 rows=2 loops=1)

27. 0.196 0.200 ↑ 1.0 6 100

Materialize (cost=0.000..1.090 rows=6 width=14) (actual time=0.000..0.002 rows=6 loops=100)

28. 0.004 0.004 ↑ 1.0 6 1

Seq Scan on four_echo five_papa (cost=0.000..1.060 rows=6 width=14) (actual time=0.003..0.004 rows=6 loops=1)

29. 0.194 0.200 ↑ 1.0 7 100

Materialize (cost=0.000..1.100 rows=7 width=28) (actual time=0.000..0.002 rows=7 loops=100)

30. 0.006 0.006 ↑ 1.0 7 1

Seq Scan on yankee_uniform romeo_kilo (cost=0.000..1.070 rows=7 width=28) (actual time=0.003..0.006 rows=7 loops=1)

31. 0.094 0.100 ↑ 1.0 3 100

Materialize (cost=0.000..1.040 rows=3 width=13) (actual time=0.000..0.001 rows=3 loops=100)

32. 0.006 0.006 ↑ 1.0 3 1

Seq Scan on alpha_november (cost=0.000..1.030 rows=3 width=13) (actual time=0.003..0.006 rows=3 loops=1)

33. 0.295 0.300 ↑ 1.0 14 100

Materialize (cost=0.000..1.210 rows=14 width=20) (actual time=0.000..0.003 rows=14 loops=100)

34. 0.005 0.005 ↑ 1.0 14 1

Seq Scan on whiskey_sierra yankee_tango (cost=0.000..1.140 rows=14 width=20) (actual time=0.005..0.005 rows=14 loops=1)

35. 0.400 0.400 ↑ 1.0 1 100

Index Scan using four_mike on victor_golf mike (cost=0.420..0.650 rows=1 width=72) (actual time=0.004..0.004 rows=1 loops=100)

  • Index Cond: (golf_golf.romeo_foxtrot = quebec)
36.          

SubPlan (forNested Loop Left Join)

37. 0.100 0.700 ↓ 0.0 0 100

Limit (cost=9.590..9.600 rows=1 width=16) (actual time=0.007..0.007 rows=0 loops=100)

38. 0.300 0.600 ↓ 0.0 0 100

Sort (cost=9.590..9.600 rows=1 width=16) (actual time=0.006..0.006 rows=0 loops=100)

  • Sort Key: november_mike.quebec
  • Sort Method: quicksort Memory: 25kB
39. 0.096 0.300 ↓ 0.0 0 100

Nested Loop (cost=0.430..9.580 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=100)

  • Join Filter: (november_mike.india_bravo = romeo_three.quebec)
  • Rows Removed by Join Filter: 0
40. 0.200 0.200 ↓ 0.0 0 100

Index Scan using charlie_six on two november_mike (cost=0.430..8.450 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=100)

  • Index Cond: (victor_five = golf_golf.quebec)
41. 0.004 0.004 ↑ 1.0 6 1

Seq Scan on charlie_two romeo_three (cost=0.000..1.060 rows=6 width=16) (actual time=0.003..0.004 rows=6 loops=1)

42. 0.100 0.500 ↓ 0.0 0 100

Limit (cost=9.590..9.600 rows=1 width=10) (actual time=0.005..0.005 rows=0 loops=100)

43. 0.200 0.400 ↓ 0.0 0 100

Sort (cost=9.590..9.600 rows=1 width=10) (actual time=0.004..0.004 rows=0 loops=100)

  • Sort Key: foxtrot1.quebec
  • Sort Method: quicksort Memory: 25kB
44. 0.000 0.200 ↓ 0.0 0 100

Nested Loop (cost=0.430..9.580 rows=1 width=10) (actual time=0.002..0.002 rows=0 loops=100)

  • Join Filter: (foxtrot1.india_bravo = six_lima1.quebec)
  • Rows Removed by Join Filter: 0
45. 0.200 0.200 ↓ 0.0 0 100

Index Scan using charlie_six on two echo_yankee (cost=0.430..8.450 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=100)

  • Index Cond: (victor_five = golf_golf.quebec)
46. 0.004 0.004 ↑ 1.0 6 1

Seq Scan on charlie_two victor_echo (cost=0.000..1.060 rows=6 width=10) (actual time=0.002..0.004 rows=6 loops=1)

47. 0.100 0.400 ↓ 0.0 0 100

Limit (cost=8.460..8.460 rows=1 width=10) (actual time=0.004..0.004 rows=0 loops=100)

48. 0.100 0.300 ↓ 0.0 0 100

Sort (cost=8.460..8.460 rows=1 width=10) (actual time=0.003..0.003 rows=0 loops=100)

  • Sort Key: foxtrot2.quebec
  • Sort Method: quicksort Memory: 25kB
49. 0.200 0.200 ↓ 0.0 0 100

Index Scan using charlie_six on two yankee_bravo (cost=0.430..8.450 rows=1 width=10) (actual time=0.002..0.002 rows=0 loops=100)

  • Index Cond: (victor_five = golf_golf.quebec)