explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZJws

Settings

Optimization(s) for this plan:

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

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

2. 0.021 11.404 ↓ 3.5 7 1

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

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

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

4. 0.004 11.349 ↓ 3.5 7 1

Nested Loop Left Join (cost=0.57..551.96 rows=2 width=161) (actual time=0.444..11.349 rows=7 loops=1)

5. 0.021 11.310 ↓ 3.5 7 1

Nested Loop Left Join (cost=0.42..547.21 rows=2 width=156) (actual time=0.418..11.310 rows=7 loops=1)

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

Nested Loop Left Join (cost=0.42..545.19 rows=2 width=143) (actual time=0.400..11.268 rows=7 loops=1)

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

Nested Loop Left Join (cost=0.42..537.96 rows=2 width=131) (actual time=0.359..11.208 rows=7 loops=1)

8. 0.010 11.183 ↓ 3.5 7 1

Nested Loop Left Join (cost=0.28..537.63 rows=2 width=122) (actual time=0.345..11.183 rows=7 loops=1)

9. 11.117 11.117 ↓ 3.5 7 1

Seq Scan on foxtrot echo_foxtrot (cost=0.00..532.62 rows=2 width=114) (actual time=0.308..11.117 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.056 0.056 ↑ 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.008..0.008 rows=1 loops=7)

  • Index Cond: (echo_foxtrot.quebec = sierra_foxtrot)
11. 0.021 0.021 ↑ 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.003..0.003 rows=1 loops=7)

  • Index Cond: (echo_seven1charlie_hotel5kilo_oscar.four_delta = quebec)
12. 0.012 0.042 ↑ 2.1 14 7

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

13. 0.030 0.030 ↑ 2.1 14 1

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

14. 0.012 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)

15. 0.009 0.009 ↑ 1.1 21 1

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

16. 0.035 0.035 ↑ 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.005..0.005 rows=1 loops=7)

  • Index Cond: (echo_foxtrot.two_romeo = quebec)
17. 0.028 0.028 ↑ 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.004..0.004 rows=1 loops=7)

  • Index Cond: (echo_foxtrot.lima_echo = quebec)
Planning time : 4.621 ms
Execution time : 11.543 ms