explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.002 4,562.542 ↑ 1.0 10 1

Limit (cost=1.98..2,827.44 rows=10 width=219) (actual time=4,561.945..4,562.542 rows=10 loops=1)

2. 0.005 4,562.540 ↑ 155.5 10 1

Nested Loop Left Join (cost=1.98..439,360.81 rows=1,555 width=219) (actual time=4,561.944..4,562.540 rows=10 loops=1)

3. 0.011 4,562.455 ↑ 155.2 10 1

Nested Loop Left Join (cost=1.27..434,866.35 rows=1,552 width=195) (actual time=4,561.920..4,562.455 rows=10 loops=1)

  • Join Filter: (echo_foxtrot.four_sierra = romeo1charlie_hotel3kilo_oscar.quebec)
  • Rows Removed by Join Filter: 115
4. 0.005 4,562.424 ↑ 155.2 10 1

Nested Loop Left Join (cost=1.27..434,582.44 rows=1,552 width=191) (actual time=4,561.906..4,562.424 rows=10 loops=1)

5. 0.012 4,562.389 ↑ 155.2 10 1

Nested Loop Left Join (cost=1.00..434,055.63 rows=1,552 width=148) (actual time=4,561.898..4,562.389 rows=10 loops=1)

6. 0.008 4,562.357 ↑ 155.2 10 1

Nested Loop Left Join (cost=0.71..433,002.63 rows=1,552 width=134) (actual time=4,561.891..4,562.357 rows=10 loops=1)

7. 4,562.299 4,562.299 ↑ 155.2 10 1

Index Scan using victor on foxtrot echo_foxtrot (cost=0.43..432,334.63 rows=1,552 width=123) (actual time=4,561.872..4,562.299 rows=10 loops=1)

  • 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: 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.005..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.030 0.030 ↑ 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.002..0.003 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.004..0.007 rows=13 loops=1)

13. 0.012 0.080 ↑ 1.0 1 10

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

14. 0.050 0.050 ↑ 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.005..0.005 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 : 4.229 ms
Execution time : 4,562.642 ms