explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

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

Limit (cost=559.13..559.15 rows=9 width=167) (actual time=8.017..8.022 rows=7 loops=1)

2. 0.020 8.020 ↑ 1.3 7 1

Sort (cost=559.13..559.15 rows=9 width=167) (actual time=8.016..8.020 rows=7 loops=1)

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

Nested Loop Left Join (cost=1.12..558.99 rows=9 width=167) (actual time=0.249..8.000 rows=7 loops=1)

4. 0.006 7.969 ↑ 1.3 7 1

Nested Loop Left Join (cost=0.99..557.55 rows=9 width=158) (actual time=0.232..7.969 rows=7 loops=1)

5. 0.007 7.935 ↑ 1.3 7 1

Nested Loop Left Join (cost=0.71..554.55 rows=9 width=150) (actual time=0.220..7.935 rows=7 loops=1)

6. 0.006 7.907 ↑ 1.3 7 1

Nested Loop Left Join (cost=0.57..553.12 rows=9 width=138) (actual time=0.209..7.907 rows=7 loops=1)

7. 0.009 7.873 ↑ 1.3 7 1

Nested Loop Left Join (cost=0.43..551.55 rows=9 width=132) (actual time=0.196..7.873 rows=7 loops=1)

8. 0.017 7.570 ↑ 1.3 7 1

Nested Loop Left Join (cost=0.28..550.06 rows=9 width=127) (actual time=0.184..7.570 rows=7 loops=1)

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

Nested Loop (cost=0.28..545.52 rows=9 width=114) (actual time=0.158..7.518 rows=7 loops=1)

10. 7.416 7.416 ↓ 1.2 32 1

Seq Scan on foxtrot (cost=0.00..485.89 rows=26 width=8) (actual time=0.092..7.416 rows=32 loops=1)

  • Filter: (mike >= 'golf_xray'::timestamp without time zone)
  • Rows Removed by Filter: 6,199
11. 0.096 0.096 ↓ 0.0 0 32

Index Scan using victor on foxtrot echo_foxtrot (cost=0.28..2.29 rows=1 width=114) (actual time=0.003..0.003 rows=0 loops=32)

  • Index Cond: (quebec = foxtrot.quebec)
  • Filter: ((lima_romeo)::text <> november ('kilo_yankee'::text[]))
  • Rows Removed by Filter: 1
12. 0.023 0.035 ↑ 1.1 21 7

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

13. 0.012 0.012 ↑ 1.1 21 1

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

14. 0.294 0.294 ↑ 1.0 1 7

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

  • Index Cond: (echo_foxtrot.two_romeo = quebec)
15. 0.028 0.028 ↑ 1.0 1 7

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

  • Index Cond: (echo_foxtrot.lima_echo = quebec)
16. 0.021 0.021 ↑ 1.0 1 7

Index Scan using two_delta on echo_zulu oscar_foxtrot (cost=0.14..0.16 rows=1 width=28) (actual time=0.003..0.003 rows=1 loops=7)

  • Index Cond: (echo_foxtrot.juliet = quebec)
17. 0.028 0.028 ↑ 1.0 1 7

Index Scan using charlie_alpha on uniform four_six (cost=0.28..0.32 rows=1 width=16) (actual time=0.004..0.004 rows=1 loops=7)

  • Index Cond: (echo_foxtrot.quebec = sierra_foxtrot)
18. 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)
Planning time : 28.792 ms
Execution time : 8.216 ms