explain.depesz.com

PostgreSQL's explain analyze made readable

Result: n5rm : Optimization for: plan #ZJws

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.002 1.741 ↓ 3.5 7 1

Limit (cost=556.75..556.76 rows=2 width=167) (actual time=1.736..1.741 rows=7 loops=1)

2. 0.017 1.739 ↓ 3.5 7 1

Sort (cost=556.75..556.76 rows=2 width=167) (actual time=1.735..1.739 rows=7 loops=1)

  • Sort Key: echo_foxtrot.quebec
  • Sort Method: quicksort Memory: 26kB
3. 0.001 1.722 ↓ 3.5 7 1

Nested Loop Left Join (cost=0.71..556.74 rows=2 width=167) (actual time=0.203..1.722 rows=7 loops=1)

4. 0.003 1.707 ↓ 3.5 7 1

Nested Loop Left Join (cost=0.57..556.42 rows=2 width=158) (actual time=0.194..1.707 rows=7 loops=1)

5. 0.005 1.690 ↓ 3.5 7 1

Nested Loop Left Join (cost=0.43..551.63 rows=2 width=152) (actual time=0.185..1.690 rows=7 loops=1)

6. 0.001 1.671 ↓ 3.5 7 1

Nested Loop Left Join (cost=0.28..546.89 rows=2 width=147) (actual time=0.174..1.671 rows=7 loops=1)

7. 0.009 1.649 ↓ 3.5 7 1

Nested Loop Left Join (cost=0.00..541.87 rows=2 width=139) (actual time=0.164..1.649 rows=7 loops=1)

  • Join Filter: (echo_foxtrot.juliet = uniform_delta1charlie_hotel2kilo_oscar.quebec)
  • Rows Removed by Join Filter: 91
8. 0.013 1.626 ↓ 3.5 7 1

Nested Loop Left Join (cost=0.00..534.64 rows=2 width=127) (actual time=0.152..1.626 rows=7 loops=1)

  • Join Filter: (echo_foxtrot.four_sierra = romeo1charlie_hotel3kilo_oscar.quebec)
  • Rows Removed by Join Filter: 140
9. 1.592 1.592 ↓ 3.5 7 1

Seq Scan on foxtrot echo_foxtrot (cost=0.00..532.62 rows=2 width=114) (actual time=0.134..1.592 rows=7 loops=1)

  • Filter: (((NOT papa) OR (papa five NULL)) AND (mike >= 'golf_xray'::timestamp without time zone) AND ((NOT seven) OR (seven AND ((lima_romeo)::text <> 'two_tango'::text))) AND ((lima_romeo)::text <> november ('kilo_yankee'::text[])))
  • Rows Removed by Filter: 6,224
10. 0.013 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.008 0.008 ↑ 1.1 21 1

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

12. 0.007 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)

13. 0.007 0.007 ↑ 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.007 rows=14 loops=1)

14. 0.021 0.021 ↑ 1.0 1 7

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

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

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

  • Index Cond: (echo_foxtrot.two_romeo = quebec)
16. 0.014 0.014 ↑ 1.0 1 7

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

  • Index Cond: (echo_foxtrot.lima_echo = quebec)
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.755 ms
Execution time : 1.850 ms