explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YX5q : Optimization for: Optimization for: plan #tS2h; plan #8kTf

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.025 2,130.410 ↑ 1.0 200 1

Limit (cost=1,002.00..48,526.37 rows=200 width=219) (actual time=2,070.172..2,130.410 rows=200 loops=1)

2. 0.350 2,130.385 ↑ 7.8 200 1

Nested Loop Left Join (cost=1,002.00..370,503.95 rows=1,555 width=219) (actual time=2,070.171..2,130.385 rows=200 loops=1)

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

Gather Merge (cost=1,002.00..370,219.62 rows=1,555 width=215) (actual time=2,070.149..2,129.835 rows=200 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 0.052 2,064.954 ↑ 9.1 71 3 / 3

Nested Loop Left Join (cost=1.98..369,040.11 rows=648 width=215) (actual time=2,058.288..2,064.954 rows=71 loops=3)

5. 0.085 2,064.331 ↑ 9.1 71 3 / 3

Nested Loop Left Join (cost=1.27..367,169.38 rows=646 width=191) (actual time=2,058.244..2,064.331 rows=71 loops=3)

6. 0.040 2,064.103 ↑ 9.1 71 3 / 3

Nested Loop Left Join (cost=1.00..366,950.10 rows=646 width=148) (actual time=2,058.220..2,064.103 rows=71 loops=3)

7. 0.031 2,063.778 ↑ 9.1 71 3 / 3

Nested Loop Left Join (cost=0.71..366,511.64 rows=646 width=134) (actual time=2,058.198..2,063.778 rows=71 loops=3)

8. 2,063.462 2,063.462 ↑ 9.1 71 3 / 3

Parallel Index Scan using victor on foxtrot echo_foxtrot (cost=0.43..366,233.54 rows=646 width=123) (actual time=2,058.166..2,063.462 rows=71 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,468
9. 0.285 0.285 ↑ 1.0 1 214 / 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=214)

  • Index Cond: (echo_foxtrot.two_romeo = quebec)
10. 0.285 0.285 ↑ 1.0 1 214 / 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=214)

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

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

  • Index Cond: (echo_foxtrot.juliet = quebec)
12. 0.064 0.571 ↑ 1.0 1 214 / 3

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

13. 0.357 0.357 ↑ 1.0 1 214 / 3

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

  • Index Cond: (echo_foxtrot.quebec = sierra_foxtrot)
14. 0.150 0.150 ↑ 1.0 1 150 / 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=150)

  • Index Cond: (echo_seven1charlie_hotel5kilo_oscar.four_delta = quebec)
15. 0.188 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.012 0.012 ↑ 1.0 13 1

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

Planning time : 3.855 ms
Execution time : 2,130.501 ms