explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wfDr : after vacuum, reindex

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 0.157 ↑ 1.5 4 1

Nested Loop Left Join (cost=10.050..313.070 rows=6 width=624) (actual time=0.075..0.157 rows=4 loops=1)

2. 0.003 0.153 ↑ 1.5 4 1

Nested Loop Left Join (cost=9.630..310.060 rows=6 width=213) (actual time=0.073..0.153 rows=4 loops=1)

3. 0.003 0.150 ↑ 1.5 4 1

Nested Loop Left Join (cost=9.210..307.230 rows=6 width=207) (actual time=0.072..0.150 rows=4 loops=1)

4. 0.003 0.147 ↑ 1.5 4 1

Nested Loop Left Join (cost=8.790..259.490 rows=6 width=207) (actual time=0.071..0.147 rows=4 loops=1)

5. 0.000 0.144 ↑ 1.5 4 1

Nested Loop Left Join (cost=8.370..211.750 rows=6 width=207) (actual time=0.070..0.144 rows=4 loops=1)

6. 0.003 0.136 ↑ 1.5 4 1

Nested Loop Left Join (cost=8.080..209.770 rows=6 width=195) (actual time=0.066..0.136 rows=4 loops=1)

7. 0.002 0.133 ↑ 1.5 4 1

Nested Loop Left Join (cost=7.660..206.940 rows=6 width=189) (actual time=0.065..0.133 rows=4 loops=1)

8. 0.003 0.131 ↑ 1.5 4 1

Nested Loop Left Join (cost=7.240..204.100 rows=6 width=183) (actual time=0.064..0.131 rows=4 loops=1)

9. 0.003 0.128 ↑ 1.5 4 1

Nested Loop Left Join (cost=6.820..156.380 rows=6 width=183) (actual time=0.063..0.128 rows=4 loops=1)

10. 0.001 0.125 ↑ 1.5 4 1

Nested Loop Left Join (cost=6.390..108.660 rows=6 width=183) (actual time=0.062..0.125 rows=4 loops=1)

11. 0.001 0.116 ↑ 1.5 4 1

Nested Loop Left Join (cost=6.100..106.680 rows=6 width=171) (actual time=0.059..0.116 rows=4 loops=1)

12. 0.003 0.111 ↑ 1.5 4 1

Nested Loop Left Join (cost=5.690..104.000 rows=6 width=159) (actual time=0.056..0.111 rows=4 loops=1)

13. 0.002 0.108 ↑ 1.5 4 1

Nested Loop Left Join (cost=5.260..100.610 rows=6 width=147) (actual time=0.055..0.108 rows=4 loops=1)

14. 0.003 0.106 ↑ 1.5 4 1

Nested Loop Left Join (cost=4.830..97.770 rows=6 width=143) (actual time=0.054..0.106 rows=4 loops=1)

15. 0.003 0.103 ↑ 1.5 4 1

Nested Loop Left Join (cost=4.410..92.930 rows=6 width=131) (actual time=0.053..0.103 rows=4 loops=1)

16. 0.002 0.100 ↑ 1.5 4 1

Nested Loop Left Join (cost=4.120..91.020 rows=6 width=127) (actual time=0.052..0.100 rows=4 loops=1)

  • Join Filter: alpha_zulu.romeo_charlie
17. 0.001 0.070 ↑ 1.5 4 1

Nested Loop Left Join (cost=3.690..79.250 rows=6 width=132) (actual time=0.038..0.070 rows=4 loops=1)

18. 0.003 0.061 ↑ 1.5 4 1

Nested Loop (cost=3.270..76.430 rows=6 width=116) (actual time=0.035..0.061 rows=4 loops=1)

19. 0.001 0.046 ↑ 2.5 2 1

Nested Loop Left Join (cost=2.840..69.380 rows=5 width=76) (actual time=0.029..0.046 rows=2 loops=1)

20. 0.001 0.039 ↑ 2.5 2 1

Nested Loop Left Join (cost=2.410..66.560 rows=5 width=64) (actual time=0.028..0.039 rows=2 loops=1)

21. 0.002 0.028 ↑ 2.5 2 1

Nested Loop Left Join (cost=1.980..63.350 rows=5 width=60) (actual time=0.023..0.028 rows=2 loops=1)

22. 0.001 0.026 ↑ 2.5 2 1

Nested Loop Left Join (cost=1.560..59.320 rows=5 width=48) (actual time=0.022..0.026 rows=2 loops=1)

23. 0.003 0.021 ↑ 2.5 2 1

Nested Loop (cost=1.270..57.710 rows=5 width=44) (actual time=0.019..0.021 rows=2 loops=1)

24. 0.002 0.013 ↑ 3.0 1 1

Nested Loop (cost=0.840..20.940 rows=3 width=19) (actual time=0.012..0.013 rows=1 loops=1)

25. 0.006 0.006 ↑ 1.0 1 1

Index Only Scan using romeo_india on mike three (cost=0.420..4.440 rows=1 width=4) (actual time=0.006..0.006 rows=1 loops=1)

  • Index Cond: (whiskey_echo = 272827)
  • Heap Fetches: 0
26. 0.005 0.005 ↑ 3.0 1 1

Index Scan using foxtrot_uniform on tango_tango quebec_sierra (cost=0.420..16.470 rows=3 width=19) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (foxtrot_yankee = 272827)
27. 0.005 0.005 ↑ 1.0 2 1

Index Scan using whiskey_three on alpha_zulu (cost=0.430..12.240 rows=2 width=25) (actual time=0.005..0.005 rows=2 loops=1)

  • Index Cond: ((tango_oscar = quebec_sierra.whiskey_echo) AND (whiskey_oscar = 3))
28. 0.004 0.004 ↓ 0.0 0 2

Index Scan using quebec_three on zulu_seven bravo (cost=0.290..0.310 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=2)

  • Index Cond: (tango_november = alpha_zulu.whiskey_echo)
29. 0.000 0.000 ↓ 0.0 0 2

Index Scan using quebec_uniform on five_bravo charlie_oscar (cost=0.420..0.810 rows=1 width=20) (actual time=0.000..0.000 rows=0 loops=2)

  • Index Cond: (whiskey_echo = quebec_sierra2kilo.romeo_four)
30. 0.010 0.010 ↓ 0.0 0 2

Index Scan using xray_romeo on lima_four juliet_bravo (cost=0.430..0.630 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=2)

  • Index Cond: (tango_november = alpha_zulu.whiskey_echo)
31. 0.006 0.006 ↓ 0.0 0 2

Index Scan using echo on lima_india oscar (cost=0.430..0.560 rows=1 width=20) (actual time=0.003..0.003 rows=0 loops=2)

  • Index Cond: (whiskey_echo = quebec_sierra2whiskey_alpha.two_sierra)
32. 0.012 0.012 ↑ 1.5 2 2

Index Scan using zulu_oscar on papa_november golf_papa (cost=0.430..1.380 rows=3 width=44) (actual time=0.005..0.006 rows=2 loops=2)

  • Index Cond: (tango_november = alpha_zulu.whiskey_echo)
33. 0.008 0.008 ↓ 0.0 0 4

Index Scan using charlie_charlie on five_bravo whiskey_seven (cost=0.420..0.460 rows=1 width=20) (actual time=0.002..0.002 rows=0 loops=4)

  • Index Cond: (tango_november = alpha_zulu.whiskey_echo)
34. 0.028 0.028 ↓ 0.0 0 4

Index Scan using india_five on alpha_zulu charlie_hotel (cost=0.430..1.950 rows=1 width=12) (actual time=0.007..0.007 rows=0 loops=4)

  • Index Cond: (tango_oscar = alpha_zulu.tango_oscar)
  • Filter: (alpha_zulu.hotel_lima = two_juliet)
  • Rows Removed by Filter: 6
35. 0.000 0.000 ↓ 0.0 0 4

Index Scan using quebec_three on zulu_seven delta_four (cost=0.290..0.310 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=4)

  • Index Cond: (tango_november = alpha_zulu2.whiskey_echo)
36. 0.000 0.000 ↓ 0.0 0 4

Index Scan using quebec_uniform on five_bravo four (cost=0.420..0.810 rows=1 width=20) (actual time=0.000..0.000 rows=0 loops=4)

  • Index Cond: (whiskey_echo = quebec_sierra2kilo2.romeo_four)
37. 0.000 0.000 ↓ 0.0 0 4

Index Scan using xray_romeo on lima_four delta_xray (cost=0.430..0.460 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=4)

  • Index Cond: (tango_november = alpha_zulu2.whiskey_echo)
38. 0.000 0.000 ↓ 0.0 0 4

Index Scan using echo on lima_india november (cost=0.430..0.560 rows=1 width=20) (actual time=0.000..0.000 rows=0 loops=4)

  • Index Cond: (whiskey_echo = quebec_sierra2whiskey_alpha2.two_sierra)
39. 0.004 0.004 ↓ 0.0 0 4

Index Scan using charlie_charlie on five_bravo india_six (cost=0.420..0.440 rows=1 width=20) (actual time=0.001..0.001 rows=0 loops=4)

  • Index Cond: (tango_november = alpha_zulu2.whiskey_echo)
40. 0.008 0.008 ↓ 0.0 0 4

Index Scan using india_whiskey on whiskey_kilo five_xray (cost=0.290..0.320 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=4)

  • Index Cond: (alpha_kilo = alpha_zulu.whiskey_echo)
  • Filter: ((two_alpha five_romeo NOT NULL) AND (golf_romeo((lima_echo)::text) = 'whiskey_zulu'::text))
41. 0.000 0.000 ↓ 0.0 0 4

Index Scan using five_november on tango_tango hotel_oscar (cost=0.420..7.950 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=4)

  • Index Cond: (whiskey_echo = five_xray.xray_hotel)
42. 0.000 0.000 ↓ 0.0 0 4

Index Scan using five_november on tango_tango papa_bravo (cost=0.420..7.950 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=4)

  • Index Cond: (whiskey_echo = five_xray.two_alpha)
43. 0.000 0.000 ↓ 0.0 0 4

Index Scan using romeo_india on mike xray_bravo (cost=0.420..0.470 rows=1 width=14) (actual time=0.000..0.000 rows=0 loops=4)

  • Index Cond: (whiskey_echo = hotel_oscar.foxtrot_yankee)
44. 0.000 0.000 ↓ 0.0 0 4

Index Scan using romeo_india on mike lima_whiskey (cost=0.420..0.470 rows=1 width=14) (actual time=0.000..0.000 rows=0 loops=4)

  • Index Cond: (whiskey_echo = hotel_oscar2.foxtrot_yankee)
45. 0.008 0.008 ↓ 0.0 0 4

Index Scan using two_whiskey on whiskey_kilo juliet_two (cost=0.290..0.320 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=4)

  • Index Cond: (five_tango = alpha_zulu.whiskey_echo)
  • Filter: (golf_romeo((lima_echo)::text) = 'whiskey_zulu'::text)
46. 0.000 0.000 ↓ 0.0 0 4

Index Scan using five_november on tango_tango whiskey_bravo (cost=0.420..7.960 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=4)

  • Index Cond: (whiskey_echo = juliet_two.xray_hotel)
47. 0.000 0.000 ↓ 0.0 0 4

Index Scan using five_november on tango_tango six_bravo (cost=0.420..7.960 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=4)

  • Index Cond: (whiskey_echo = juliet_two.two_alpha)
48. 0.000 0.000 ↓ 0.0 0 4

Index Scan using romeo_india on mike six_five (cost=0.420..0.470 rows=1 width=14) (actual time=0.000..0.000 rows=0 loops=4)

  • Index Cond: (whiskey_echo = whiskey_bravo.foxtrot_yankee)
49. 0.000 0.000 ↓ 0.0 0 4

Index Scan using romeo_india on mike delta_golf (cost=0.420..0.470 rows=1 width=14) (actual time=0.000..0.000 rows=0 loops=4)

  • Index Cond: (whiskey_echo = whiskey_bravo2.foxtrot_yankee)