explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wi5g

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

Limit (cost=79,251.990..79,252.090 rows=10 width=44) (actual time=0.058..0.058 rows=0 loops=1)

2. 0.000 0.057 ↓ 0.0 0 1

Unique (cost=79,251.990..79,252.470 rows=48 width=44) (actual time=0.057..0.057 rows=0 loops=1)

3. 0.045 0.057 ↓ 0.0 0 1

Sort (cost=79,251.990..79,252.110 rows=48 width=44) (actual time=0.057..0.057 rows=0 loops=1)

  • Sort Key: (((juliet_india1.six_mike ->> 'hotel'::text))::double precision) DESC, (lima_sierra(kilo5.lima_tango, 'uniform_romeo'::character varying)), kilo2.xray_india
  • Sort Method: quicksort Memory: 25kB
4. 0.000 0.012 ↓ 0.0 0 1

Nested Loop (cost=6.090..79,250.650 rows=48 width=44) (actual time=0.012..0.012 rows=0 loops=1)

  • Join Filter: (kilo2.quebec_seven = quebec_sierra3.romeo_lima)
5. 0.000 0.012 ↓ 0.0 0 1

Nested Loop Left Join (cost=5.520..77,250.390 rows=35 width=55) (actual time=0.012..0.012 rows=0 loops=1)

  • Join Filter: ((uniform_delta0.juliet_victor = kilo5.juliet_victor) AND (kilo2.xray_india = kilo5.xray_india))
6. 0.001 0.012 ↓ 0.0 0 1

Nested Loop (cost=1.150..77,202.580 rows=35 width=52) (actual time=0.012..0.012 rows=0 loops=1)

7. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on oscar_yankee foxtrot (cost=0.000..1.300 rows=1 width=26) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: (juliet_victor = 1)
  • Rows Removed by Filter: 54
8. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.150..77,200.930 rows=35 width=44) (never executed)

9. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.580..75,454.010 rows=94 width=40) (never executed)

10. 0.000 0.000 ↓ 0.0 0

Function Scan on charlie yankee_charlie (cost=0.000..1.000 rows=100 width=32) (never executed)

11. 0.000 0.000 ↓ 0.0 0

Index Scan using romeo_sierra on delta yankee_xray (cost=0.570..754.520 rows=1 width=8) (never executed)

  • Index Cond: (xray_india = ((juliet_india1.six_mike ->> 'yankee_foxtrot'::text))::integer)
  • Filter: ((lima_sierra(papa_three_two, yankee_kilo) <= 'lima_xray'::date) AND (lima_sierra(papa_three_two, yankee_kilo) >= 'xray_three'::date))
12. 0.000 0.000 ↓ 0.0 0

Index Scan using alpha_romeo on tango three_november (cost=0.570..18.570 rows=1 width=4) (never executed)

  • Index Cond: (romeo_lima = kilo2.quebec_seven)
  • Filter: (oscar_india ~~ 'six_kilo'::text)
13. 0.000 0.000 ↓ 0.0 0

Materialize (cost=4.370..42.330 rows=9 width=23) (never executed)

14. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on victor india (cost=4.370..42.280 rows=9 width=23) (never executed)

  • Recheck Cond: (juliet_victor = 1)
  • Filter: ((lima_tango)::text = ANY ('papa_three_six'::text[]))
15. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on golf (cost=0.000..4.370 rows=11 width=0) (never executed)

  • Index Cond: (juliet_victor = 1)
16. 0.000 0.000 ↓ 0.0 0

Index Scan using three_hotel on five uniform_yankee (cost=0.570..57.080 rows=5 width=4) (never executed)

  • Index Cond: (romeo_lima = alpha_quebec4.romeo_lima)
  • Filter: ((lima_romeo ~~ 'sierra'::text) OR (lima_romeo ~~ 'romeo_two'::text))