explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2hwS : Optimization for: plan #pr1P

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.019 340.040 ↑ 1.0 200 1

Limit (cost=23,897.53..23,898.03 rows=200 width=219) (actual time=339.985..340.040 rows=200 loops=1)

2. 4.013 340.021 ↑ 7.8 200 1

Sort (cost=23,897.53..23,901.42 rows=1,555 width=219) (actual time=339.984..340.021 rows=200 loops=1)

  • Sort Key: echo_foxtrot.quebec
  • Sort Method: top-N heapsort Memory: 169kB
3. 4.604 336.008 ↓ 3.4 5,333 1

Nested Loop Left Join (cost=1,028.46..23,830.32 rows=1,555 width=219) (actual time=10.741..336.008 rows=5,333 loops=1)

4. 2.759 278.074 ↓ 3.4 5,333 1

Hash Left Join (cost=1,027.75..19,332.92 rows=1,553 width=195) (actual time=10.715..278.074 rows=5,333 loops=1)

  • Hash Cond: (echo_foxtrot.four_sierra = romeo1charlie_hotel3kilo_oscar.quebec)
5. 4.638 275.302 ↓ 3.4 5,333 1

Hash Left Join (cost=1,026.46..19,326.22 rows=1,553 width=191) (actual time=10.696..275.302 rows=5,333 loops=1)

  • Hash Cond: (echo_foxtrot.juliet_hotel = uniform_delta1charlie_hotel2kilo_oscar.quebec)
6. 2.464 270.341 ↓ 3.4 5,333 1

Hash Left Join (cost=948.57..19,244.21 rows=1,553 width=148) (actual time=10.362..270.341 rows=5,333 loops=1)

  • Hash Cond: (echo_foxtrot.lima_echo = juliet_xray1charlie_hotel1kilo_oscar.quebec)
7. 3.690 261.577 ↓ 3.4 5,333 1

Hash Left Join (cost=341.54..18,633.10 rows=1,553 width=134) (actual time=4.040..261.577 rows=5,333 loops=1)

  • Hash Cond: (echo_foxtrot.two_romeo = papa_kilo1charlie_hotel4kilo_oscar.quebec)
8. 253.911 253.911 ↓ 3.4 5,333 1

Index Scan using papa_yankee on foxtrot echo_foxtrot (cost=0.56..18,288.05 rows=1,553 width=123) (actual time=0.045..253.911 rows=5,333 loops=1)

  • Index Cond: ((lima_romeo)::text = ANY ('alpha'::text[]))
  • Filter: (((NOT papa_bravo) OR (papa_bravo five NULL)) AND (mike >= 'golf_xray'::timestamp without time zone) AND ((NOT seven) OR (seven AND ((lima_romeo)::text <> 'two_tango'::text))))
  • Rows Removed by Filter: 75,076
9. 1.751 3.976 ↓ 1.0 8,121 1

Hash (cost=239.88..239.88 rows=8,088 width=27) (actual time=3.975..3.976 rows=8,121 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 567kB
10. 2.225 2.225 ↓ 1.0 8,121 1

Seq Scan on golf_five bravo (cost=0.00..239.88 rows=8,088 width=27) (actual time=0.006..2.225 rows=8,121 loops=1)

11. 3.859 6.300 ↑ 1.0 5,157 1

Hash (cost=542.57..542.57 rows=5,157 width=30) (actual time=6.299..6.300 rows=5,157 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 397kB
12. 2.441 2.441 ↑ 1.0 5,157 1

Seq Scan on sierra_three hotel (cost=0.00..542.57 rows=5,157 width=30) (actual time=0.009..2.441 rows=5,157 loops=1)

13. 0.099 0.323 ↑ 1.0 395 1

Hash (cost=72.95..72.95 rows=395 width=59) (actual time=0.323..0.323 rows=395 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 45kB
14. 0.224 0.224 ↑ 1.0 395 1

Seq Scan on echo_zulu oscar_foxtrot (cost=0.00..72.95 rows=395 width=59) (actual time=0.008..0.224 rows=395 loops=1)

15. 0.005 0.013 ↑ 1.0 13 1

Hash (cost=1.13..1.13 rows=13 width=20) (actual time=0.012..0.013 rows=13 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
16. 0.008 0.008 ↑ 1.0 13 1

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

17. 1.262 53.330 ↓ 0.0 0 5,333

Nested Loop Left Join (cost=0.71..2.89 rows=1 width=32) (actual time=0.010..0.010 rows=0 loops=5,333)

18. 42.664 42.664 ↓ 0.0 0 5,333

Index Scan using charlie_alpha on uniform_kilo four_six (cost=0.43..2.59 rows=1 width=16) (actual time=0.008..0.008 rows=0 loops=5,333)

  • Index Cond: (echo_foxtrot.quebec = sierra_foxtrot)
19. 9.404 9.404 ↑ 1.0 1 2,351

Index Scan using kilo_kilo on oscar_oscar six (cost=0.28..0.29 rows=1 width=32) (actual time=0.004..0.004 rows=1 loops=2,351)

  • Index Cond: (echo_seven1charlie_hotel5kilo_oscar.four_delta = quebec)
Planning time : 6.287 ms
Execution time : 340.168 ms