explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EV3X : Optimization for: Optimization for: plan #ZJws; plan #n5rm

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.002 1.530 ↑ 1.3 7 1

Limit (cost=573.24..573.26 rows=9 width=167) (actual time=1.526..1.530 rows=7 loops=1)

2. 0.018 1.528 ↑ 1.3 7 1

Sort (cost=573.24..573.26 rows=9 width=167) (actual time=1.525..1.528 rows=7 loops=1)

  • Sort Key: echo_foxtrot.quebec
  • Sort Method: quicksort Memory: 26kB
3. 0.000 1.510 ↑ 1.3 7 1

Nested Loop Left Join (cost=0.71..573.10 rows=9 width=167) (actual time=0.166..1.510 rows=7 loops=1)

4. 0.000 1.496 ↑ 1.3 7 1

Nested Loop Left Join (cost=0.57..571.65 rows=9 width=158) (actual time=0.158..1.496 rows=7 loops=1)

5. 0.009 1.476 ↑ 1.3 7 1

Nested Loop Left Join (cost=0.29..552.39 rows=9 width=150) (actual time=0.147..1.476 rows=7 loops=1)

  • Join Filter: (echo_foxtrot.juliet = uniform_delta1charlie_hotel2kilo_oscar.quebec)
  • Rows Removed by Join Filter: 91
6. 0.004 1.453 ↑ 1.3 7 1

Nested Loop Left Join (cost=0.29..542.11 rows=9 width=138) (actual time=0.136..1.453 rows=7 loops=1)

7. 0.005 1.435 ↑ 1.3 7 1

Nested Loop Left Join (cost=0.14..529.65 rows=9 width=132) (actual time=0.127..1.435 rows=7 loops=1)

8. 0.013 1.416 ↑ 1.3 7 1

Nested Loop Left Join (cost=0.00..521.58 rows=9 width=127) (actual time=0.115..1.416 rows=7 loops=1)

  • Join Filter: (echo_foxtrot.four_sierra = romeo1charlie_hotel3kilo_oscar.quebec)
  • Rows Removed by Join Filter: 140
9. 1.382 1.382 ↑ 1.3 7 1

Seq Scan on foxtrot echo_foxtrot (cost=0.00..517.04 rows=9 width=114) (actual time=0.099..1.382 rows=7 loops=1)

  • Filter: ((mike >= 'golf_xray'::timestamp without time zone) AND ((lima_romeo)::text <> november ('kilo_yankee'::text[])))
  • Rows Removed by Filter: 6,224
10. 0.014 0.021 ↑ 1.1 21 7

Materialize (cost=0.00..1.36 rows=24 width=29) (actual time=0.001..0.003 rows=21 loops=7)

11. 0.007 0.007 ↑ 1.1 21 1

Seq Scan on tango delta (cost=0.00..1.24 rows=24 width=29) (actual time=0.005..0.007 rows=21 loops=1)

12. 0.014 0.014 ↑ 1.0 1 7

Index Scan using kilo_charlie on golf_five bravo (cost=0.14..0.90 rows=1 width=21) (actual time=0.002..0.002 rows=1 loops=7)

  • Index Cond: (echo_foxtrot.two = quebec)
13. 0.014 0.014 ↑ 1.0 1 7

Index Scan using sierra_delta on sierra_three hotel (cost=0.14..1.38 rows=1 width=22) (actual time=0.002..0.002 rows=1 loops=7)

  • Index Cond: (echo_foxtrot.lima_echo = quebec)
14. 0.008 0.014 ↑ 2.1 14 7

Materialize (cost=0.00..6.43 rows=29 width=28) (actual time=0.001..0.002 rows=14 loops=7)

15. 0.006 0.006 ↑ 2.1 14 1

Seq Scan on echo_zulu oscar_foxtrot (cost=0.00..6.29 rows=29 width=28) (actual time=0.003..0.006 rows=14 loops=1)

16. 0.021 0.021 ↑ 1.0 1 7

Index Scan using charlie_alpha on uniform_kilo four_six (cost=0.28..2.13 rows=1 width=16) (actual time=0.002..0.003 rows=1 loops=7)

  • Index Cond: (echo_foxtrot.quebec = sierra_foxtrot)
17. 0.014 0.014 ↑ 1.0 1 7

Index Scan using kilo_kilo on oscar_oscar six (cost=0.14..0.16 rows=1 width=25) (actual time=0.002..0.002 rows=1 loops=7)

  • Index Cond: (echo_seven1charlie_hotel5kilo_oscar.four_delta = quebec)
Planning time : 2.562 ms
Execution time : 1.628 ms