explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8kTf : Optimization for: plan #tS2h

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.023 2,471.075 ↑ 1.0 200 1

Limit (cost=1,002.00..48,526.20 rows=200 width=219) (actual time=2,355.862..2,471.075 rows=200 loops=1)

2. 0.309 2,471.052 ↑ 7.8 200 1

Nested Loop Left Join (cost=1,002.00..370,502.67 rows=1,555 width=219) (actual time=2,355.861..2,471.052 rows=200 loops=1)

  • Join Filter: (echo_foxtrot.four_sierra = romeo1charlie_hotel3kilo_oscar.quebec)
  • Rows Removed by Join Filter: 2,180
3. 106.283 2,470.543 ↑ 7.8 200 1

Gather Merge (cost=1,002.00..370,218.34 rows=1,555 width=215) (actual time=2,355.840..2,470.543 rows=200 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 0.047 2,364.260 ↑ 8.6 75 3 / 3

Nested Loop Left Join (cost=1.98..369,038.83 rows=648 width=215) (actual time=2,350.249..2,364.260 rows=75 loops=3)

5. 0.021 2,363.466 ↑ 8.6 75 3 / 3

Nested Loop Left Join (cost=1.27..367,168.09 rows=646 width=191) (actual time=2,350.207..2,363.466 rows=75 loops=3)

6. 0.074 2,363.221 ↑ 8.6 75 3 / 3

Nested Loop Left Join (cost=1.00..366,948.82 rows=646 width=148) (actual time=2,350.186..2,363.221 rows=75 loops=3)

7. 0.080 2,362.848 ↑ 8.6 75 3 / 3

Nested Loop Left Join (cost=0.71..366,510.36 rows=646 width=134) (actual time=2,350.164..2,362.848 rows=75 loops=3)

8. 2,362.469 2,362.469 ↑ 8.6 75 3 / 3

Parallel Index Scan using victor on foxtrot echo_foxtrot (cost=0.43..366,232.26 rows=646 width=123) (actual time=2,350.126..2,362.469 rows=75 loops=3)

  • 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: 1,884,633
9. 0.299 0.299 ↑ 1.0 1 224 / 3

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

  • Index Cond: (echo_foxtrot.two_romeo = quebec)
10. 0.299 0.299 ↑ 1.0 1 224 / 3

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

  • Index Cond: (echo_foxtrot.lima_echo = quebec)
11. 0.224 0.224 ↑ 1.0 1 224 / 3

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

  • Index Cond: (echo_foxtrot.juliet = quebec)
12. 0.065 0.747 ↑ 1.0 1 224 / 3

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

13. 0.523 0.523 ↑ 1.0 1 224 / 3

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

  • Index Cond: (echo_foxtrot.quebec = sierra_foxtrot)
14. 0.159 0.159 ↑ 1.0 1 159 / 3

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

  • Index Cond: (echo_seven1charlie_hotel5kilo_oscar.four_delta = quebec)
15. 0.189 0.200 ↑ 1.1 12 200

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

16. 0.011 0.011 ↑ 1.0 13 1

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

Planning time : 5.414 ms
Execution time : 2,471.199 ms