explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pr1P

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.022 4,505.897 ↑ 1.0 200 1

Limit (cost=1,002.00..48,581.92 rows=200 width=219) (actual time=4,351.619..4,505.897 rows=200 loops=1)

2. 0.291 4,505.875 ↑ 7.8 200 1

Nested Loop Left Join (cost=1,002.00..370,935.86 rows=1,555 width=219) (actual time=4,351.618..4,505.875 rows=200 loops=1)

  • Join Filter: (echo_foxtrot.four_sierra = romeo1charlie_hotel3kilo_oscar.quebec)
  • Rows Removed by Join Filter: 2,182
3. 147.964 4,505.384 ↑ 7.8 200 1

Gather Merge (cost=1,002.00..370,651.52 rows=1,555 width=215) (actual time=4,351.601..4,505.384 rows=200 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 0.049 4,357.420 ↑ 8.5 76 3 / 3

Nested Loop Left Join (cost=1.98..369,472.02 rows=648 width=215) (actual time=4,339.714..4,357.420 rows=76 loops=3)

5. 0.025 4,355.933 ↑ 8.5 76 3 / 3

Nested Loop Left Join (cost=1.27..367,598.34 rows=647 width=191) (actual time=4,339.655..4,355.933 rows=76 loops=3)

6. 0.087 4,355.681 ↑ 8.5 76 3 / 3

Nested Loop Left Join (cost=1.00..367,376.93 rows=647 width=148) (actual time=4,339.629..4,355.681 rows=76 loops=3)

7. 0.050 4,355.291 ↑ 8.5 76 3 / 3

Nested Loop Left Join (cost=0.71..366,938.11 rows=647 width=134) (actual time=4,339.608..4,355.291 rows=76 loops=3)

8. 4,347.977 4,347.977 ↑ 8.5 76 3 / 3

Parallel Index Scan using victor on foxtrot echo_foxtrot (cost=0.43..366,659.69 rows=647 width=123) (actual time=4,336.023..4,347.977 rows=76 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,872
9. 7.264 7.264 ↑ 1.0 1 227 / 3

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

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

  • Index Cond: (echo_foxtrot.lima_echo = quebec)
11. 0.227 0.227 ↑ 1.0 1 227 / 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=227)

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

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

13. 1.211 1.211 ↑ 1.0 1 227 / 3

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

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

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

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

Planning time : 5.354 ms
Execution time : 4,506.035 ms