explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7CLo : Optimization for: plan #AoRD

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.002 6,181.492 ↑ 1.0 10 1

Limit (cost=1.98..2,735.13 rows=10 width=219) (actual time=6,180.941..6,181.492 rows=10 loops=1)

2. 0.004 6,181.490 ↑ 155.7 10 1

Nested Loop Left Join (cost=1.98..425,554.51 rows=1,557 width=219) (actual time=6,180.940..6,181.490 rows=10 loops=1)

3. 0.008 6,181.416 ↑ 155.5 10 1

Nested Loop Left Join (cost=1.27..421,051.19 rows=1,555 width=195) (actual time=6,180.921..6,181.416 rows=10 loops=1)

  • Join Filter: (echo_foxtrot.four_sierra = romeo1charlie_hotel3kilo_oscar.quebec)
  • Rows Removed by Join Filter: 115
4. 0.011 6,181.388 ↑ 155.5 10 1

Nested Loop Left Join (cost=1.27..420,766.86 rows=1,555 width=191) (actual time=6,180.908..6,181.388 rows=10 loops=1)

5. 0.010 6,181.367 ↑ 155.5 10 1

Nested Loop Left Join (cost=1.00..420,234.79 rows=1,555 width=148) (actual time=6,180.901..6,181.367 rows=10 loops=1)

6. 0.005 6,181.337 ↑ 155.5 10 1

Nested Loop Left Join (cost=0.71..419,180.89 rows=1,555 width=134) (actual time=6,180.893..6,181.337 rows=10 loops=1)

7. 6,181.282 6,181.282 ↑ 155.5 10 1

Index Scan using victor on foxtrot echo_foxtrot (cost=0.43..418,511.99 rows=1,555 width=123) (actual time=6,180.879..6,181.282 rows=10 loops=1)

  • Filter: (((NOT papa) OR (papa five NULL)) AND (mike >= 'golf_xray'::timestamp without time zone) AND ((lima_romeo)::text <> november ('kilo_yankee'::text[])))
  • Rows Removed by Filter: 5,639,322
8. 0.050 0.050 ↑ 1.0 1 10

Index Scan using kilo_charlie on golf_five bravo (cost=0.28..0.43 rows=1 width=27) (actual time=0.004..0.005 rows=1 loops=10)

  • Index Cond: (echo_foxtrot.two_romeo = quebec)
9. 0.020 0.020 ↑ 1.0 1 10

Index Scan using sierra_delta on sierra_three hotel (cost=0.28..0.68 rows=1 width=30) (actual time=0.002..0.002 rows=1 loops=10)

  • Index Cond: (echo_foxtrot.lima_echo = quebec)
10. 0.010 0.010 ↑ 1.0 1 10

Index Scan using two_delta on echo_zulu oscar_foxtrot (cost=0.27..0.34 rows=1 width=59) (actual time=0.001..0.001 rows=1 loops=10)

  • Index Cond: (echo_foxtrot.juliet = quebec)
11. 0.013 0.020 ↑ 1.1 12 10

Materialize (cost=0.00..1.19 rows=13 width=20) (actual time=0.001..0.002 rows=12 loops=10)

12. 0.007 0.007 ↑ 1.0 13 1

Seq Scan on tango delta (cost=0.00..1.13 rows=13 width=20) (actual time=0.005..0.007 rows=13 loops=1)

13. 0.012 0.070 ↑ 1.0 1 10

Nested Loop Left Join (cost=0.71..2.89 rows=1 width=32) (actual time=0.007..0.007 rows=1 loops=10)

14. 0.040 0.040 ↑ 1.0 1 10

Index Scan using charlie_alpha on uniform four_six (cost=0.43..2.59 rows=1 width=16) (actual time=0.004..0.004 rows=1 loops=10)

  • Index Cond: (echo_foxtrot.quebec = sierra_foxtrot)
15. 0.018 0.018 ↑ 1.0 1 9

Index Scan using kilo_kilo on oscar_oscar six (cost=0.28..0.29 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=9)

  • Index Cond: (echo_seven1charlie_hotel5kilo_oscar.four_delta = quebec)
Planning time : 5.926 ms
Execution time : 6,181.614 ms