explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Mlda

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.074 ↓ 0.0 0 1

Limit (cost=18.910..18.920 rows=1 width=81) (actual time=0.074..0.074 rows=0 loops=1)

2. 0.014 0.073 ↓ 0.0 0 1

Sort (cost=18.910..18.920 rows=1 width=81) (actual time=0.073..0.073 rows=0 loops=1)

  • Sort Key: seven_november.uniform
  • Sort Method: quicksort Memory: 25kB
3. 0.002 0.059 ↓ 0.0 0 1

WindowAgg (cost=18.850..18.900 rows=1 width=81) (actual time=0.059..0.059 rows=0 loops=1)

4. 0.001 0.057 ↓ 0.0 0 1

Unique (cost=18.850..18.880 rows=1 width=73) (actual time=0.057..0.057 rows=0 loops=1)

5. 0.021 0.056 ↓ 0.0 0 1

Sort (cost=18.850..18.850 rows=1 width=73) (actual time=0.056..0.056 rows=0 loops=1)

  • Sort Key: kilo_foxtrot.golf_four, seven_november.juliet_oscar, seven_november.uniform, quebec_sierra.juliet_zulu, seven_november.three_november, kilo_foxtrot.three_november, delta.whiskey, delta.quebec_india, delta.sierra_tango, delta.victor
  • Sort Method: quicksort Memory: 25kB
6. 0.000 0.035 ↓ 0.0 0 1

Nested Loop Left Join (cost=2.220..18.840 rows=1 width=73) (actual time=0.035..0.035 rows=0 loops=1)

  • Filter: ((quebec_sierra.three_zulu five_romeo NULL) OR (india((quebec_sierra.three_zulu)::text) ~~* india(juliet_golf('xray_alpha', 'seven_india', 'xray_alpha'))) OR (((six_oscar.three_zulu five_romeo NULL) OR (india((six_oscar.three_zulu)::text) ~~* india(juliet_golf('xray_alpha', 'seven_india', 'xray_alpha')))) AND (hotel_six.hotel_sierra = 1)))
7. 0.001 0.035 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.950..18.500 rows=1 width=95) (actual time=0.035..0.035 rows=0 loops=1)

8. 0.000 0.034 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.670..18.080 rows=1 width=83) (actual time=0.034..0.034 rows=0 loops=1)

9. 0.000 0.034 ↓ 0.0 0 1

Nested Loop (cost=1.400..17.780 rows=1 width=63) (actual time=0.034..0.034 rows=0 loops=1)

  • Join Filter: ((india((seven_november.juliet_oscar)::text) ~~* india('seven_india'::text)) OR (india((golf_juliet.juliet_oscar)::text) ~~* india('seven_india'::text)))
10. 0.000 0.034 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.120..17.390 rows=1 width=61) (actual time=0.034..0.034 rows=0 loops=1)

11. 0.000 0.034 ↓ 0.0 0 1

Nested Loop (cost=0.840..17.030 rows=1 width=54) (actual time=0.034..0.034 rows=0 loops=1)

  • Join Filter: ((november_uniform.zulu)::text = (kilo_foxtrot.golf_four)::text)
12. 0.002 0.034 ↓ 0.0 0 1

Nested Loop (cost=0.560..16.610 rows=1 width=48) (actual time=0.034..0.034 rows=0 loops=1)

13. 0.032 0.032 ↓ 0.0 0 1

Index Only Scan using kilo_bravo on oscar november_uniform (cost=0.280..8.300 rows=1 width=16) (actual time=0.032..0.032 rows=0 loops=1)

  • Index Cond: (kilo_whiskey = 'charlie_lima'::text)
  • Heap Fetches: 0
14. 0.000 0.000 ↓ 0.0 0

Index Scan using yankee on zulu delta (cost=0.280..8.300 rows=1 width=32) (never executed)

  • Index Cond: ((zulu)::text = (november_uniform.zulu)::text)
15. 0.000 0.000 ↓ 0.0 0

Index Scan using five_sierra on zulu kilo_foxtrot (cost=0.280..0.410 rows=1 width=38) (never executed)

  • Index Cond: ((golf_four)::text = (delta.zulu)::text)
  • Filter: ((hotel_sierra = 1) AND ((three_november = ANY ('hotel_yankee'::integer[])) OR (0 = three_november)))
16. 0.000 0.000 ↓ 0.0 0

Index Scan using tango on six_echo golf_juliet (cost=0.280..0.350 rows=1 width=26) (never executed)

  • Index Cond: ((kilo_foxtrot.golf_four)::text = (zulu)::text)
17. 0.000 0.000 ↓ 0.0 0

Index Scan using two on six_echo seven_november (cost=0.280..0.370 rows=1 width=41) (never executed)

  • Index Cond: ((golf_four)::text = (kilo_foxtrot.mike)::text)
  • Filter: ((sierra_delta = 1) AND (india((uniform)::text) ~~* india(juliet_golf('xray_alpha', 'seven_india', 'xray_alpha'))))
18. 0.000 0.000 ↓ 0.0 0

Index Scan using four on xray_foxtrot quebec_sierra (cost=0.270..0.310 rows=1 width=32) (never executed)

  • Index Cond: ((kilo_foxtrot.charlie_two)::text = (golf_four)::text)
19. 0.000 0.000 ↓ 0.0 0

Index Scan using november_charlie on alpha hotel_six (cost=0.280..0.380 rows=3 width=28) (never executed)

  • Index Cond: ((kilo_foxtrot.golf_four)::text = (zulu)::text)
20. 0.000 0.000 ↓ 0.0 0

Index Scan using four on xray_foxtrot six_oscar (cost=0.270..0.310 rows=1 width=20) (never executed)

  • Index Cond: ((hotel_six.xray_foxtrot)::text = (golf_four)::text)