explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tS2h

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.027 2,356.887 ↑ 1.0 200 1

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

2. 0.863 2,356.860 ↑ 7.8 200 1

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

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

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

  • Workers Planned: 2
  • Workers Launched: 2
4. 0.078 2,234.348 ↑ 5.1 128 3 / 3

Nested Loop Left Join (cost=1.98..369,038.83 rows=648 width=215) (actual time=2,212.436..2,234.348 rows=128 loops=3)

5. 0.141 2,232.990 ↑ 5.0 128 3 / 3

Nested Loop Left Join (cost=1.27..367,168.09 rows=646 width=191) (actual time=2,212.393..2,232.990 rows=128 loops=3)

6. 0.047 2,232.593 ↑ 5.0 128 3 / 3

Nested Loop Left Join (cost=1.00..366,948.82 rows=646 width=148) (actual time=2,212.368..2,232.593 rows=128 loops=3)

7. 0.098 2,232.034 ↑ 5.0 128 3 / 3

Nested Loop Left Join (cost=0.71..366,510.36 rows=646 width=134) (actual time=2,212.347..2,232.034 rows=128 loops=3)

8. 2,231.424 2,231.424 ↑ 5.0 128 3 / 3

Parallel Index Scan using victor on foxtrot echo_foxtrot (cost=0.43..366,232.26 rows=646 width=123) (actual time=2,212.320..2,231.424 rows=128 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,888,290
9. 0.512 0.512 ↑ 1.0 1 384 / 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=384)

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

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

  • Index Cond: (echo_foxtrot.juliet = quebec)
12. 0.102 1.280 ↑ 1.0 1 384 / 3

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

13. 0.896 0.896 ↑ 1.0 1 384 / 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=384)

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

  • 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.007..0.011 rows=13 loops=1)

Planning time : 5.358 ms
Execution time : 2,357.012 ms