explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6VaS : Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: plan #gWgH; plan #lj5Ms; plan #B8eq; plan #Yty9; plan #Lheu; plan #27c; plan #qUXb; plan #6xFD; plan #YOFp; plan #tvR9; plan #vDLc; plan #4jS3; plan #a2yB; plan #elHgV

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.017 69.740 ↑ 2.1 120 1

Limit (cost=13,353.50..13,382.66 rows=250 width=5,715) (actual time=62.559..69.740 rows=120 loops=1)

2. 26.030 69.723 ↑ 22.8 120 1

Gather Merge (cost=13,353.50..13,672.02 rows=2,730 width=5,715) (actual time=62.557..69.723 rows=120 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.248 43.693 ↑ 34.1 40 3 / 3

Sort (cost=12,353.47..12,356.88 rows=1,365 width=5,715) (actual time=43.675..43.693 rows=40 loops=3)

  • Sort Key: lima_delta1.mike_seven
  • Sort Method: quicksort Memory: 406kB
4. 0.056 43.445 ↑ 34.1 40 3 / 3

Hash Left Join (cost=1,240.17..12,282.39 rows=1,365 width=5,715) (actual time=16.000..43.445 rows=40 loops=3)

  • Hash Cond: (echo_seven1.delta_kilo = alpha_seven1.quebec_seven)
5. 0.086 41.979 ↑ 34.1 40 3 / 3

Hash Left Join (cost=965.66..12,004.29 rows=1,365 width=3,694) (actual time=14.574..41.979 rows=40 loops=3)

  • Hash Cond: (echo_seven1.four_delta = kilo_foxtrot2.quebec_seven)
6. 0.044 41.089 ↑ 34.1 40 3 / 3

Nested Loop Left Join (cost=760.37..11,795.39 rows=1,365 width=3,372) (actual time=13.735..41.089 rows=40 loops=3)

7. 0.043 40.565 ↑ 33.8 40 3 / 3

Nested Loop Left Join (cost=759.93..8,623.71 rows=1,351 width=3,316) (actual time=13.698..40.565 rows=40 loops=3)

8. 0.093 40.242 ↑ 33.8 40 3 / 3

Hash Left Join (cost=759.65..8,142.25 rows=1,351 width=1,873) (actual time=13.673..40.242 rows=40 loops=3)

  • Hash Cond: ((kilo_foxtrot1.quebec_seven = alpha_oscar1.uniform_bravo) AND (lima_delta1.juliet_hotel = alpha_oscar1.foxtrot_charlie))
9. 0.075 32.729 ↑ 33.8 40 3 / 3

Nested Loop Left Join (cost=424.28..7,799.78 rows=1,351 width=1,640) (actual time=6.208..32.729 rows=40 loops=3)

10. 0.082 32.454 ↑ 33.8 40 3 / 3

Hash Left Join (cost=424.00..7,314.44 rows=1,351 width=1,355) (actual time=6.171..32.454 rows=40 loops=3)

  • Hash Cond: (lima_delta1.two = papa_kilo1.quebec_seven)
11. 0.097 27.096 ↑ 33.8 40 3 / 3

Hash Left Join (cost=80.87..6,967.76 rows=1,351 width=1,230) (actual time=0.856..27.096 rows=40 loops=3)

  • Hash Cond: (lima_delta1.four_sierra = romeo_three1.quebec_seven)
12. 0.054 26.982 ↑ 33.8 40 3 / 3

Hash Left Join (cost=79.58..6,961.77 rows=1,351 width=1,182) (actual time=0.826..26.982 rows=40 loops=3)

  • Hash Cond: (lima_delta1.juliet_hotel = uniform_delta1.quebec_seven)
13. 0.486 26.431 ↑ 33.8 40 3 / 3

Hash Left Join (cost=1.65..6,880.26 rows=1,351 width=518) (actual time=0.312..26.431 rows=40 loops=3)

  • Hash Cond: (lima_delta1.juliet_hotel = india1.quebec_hotel)
  • Filter: ((lima_delta1.juliet_hotel = 81) OR (india1.yankee_zulu = 81))
  • Rows Removed by Filter: 1,246
14. 25.890 25.890 ↑ 3.2 1,286 3 / 3

Parallel Index Scan using papa_yankee on foxtrot_romeo quebec_sierra (cost=0.56..6,862.90 rows=4,154 width=295) (actual time=0.033..25.890 rows=1,286 loops=3)

  • Index Cond: ((lima_romeo)::text = 'quebec_quebec'::text)
  • Filter: (((NOT papa_bravo) OR (papa_bravo five_romeo NULL)) AND ((mike_seven)::date >= 'four_india'::date))
  • Rows Removed by Filter: 7,778
15. 0.004 0.055 ↑ 1.0 3 3 / 3

Hash (cost=1.05..1.05 rows=3 width=223) (actual time=0.054..0.055 rows=3 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
16. 0.051 0.051 ↑ 1.0 3 3 / 3

Seq Scan on hotel_three romeo_foxtrot (cost=0.00..1.05 rows=3 width=223) (actual time=0.048..0.051 rows=3 loops=3)

  • Filter: ((juliet_charlie)::text = 'kilo_papa'::text)
  • Rows Removed by Filter: 1
17. 0.272 0.497 ↑ 1.0 397 3 / 3

Hash (cost=72.97..72.97 rows=397 width=664) (actual time=0.496..0.497 rows=397 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 282kB
18. 0.225 0.225 ↑ 1.0 397 3 / 3

Seq Scan on echo_zulu mike_quebec (cost=0.00..72.97 rows=397 width=664) (actual time=0.013..0.225 rows=397 loops=3)

19. 0.005 0.017 ↑ 1.0 13 3 / 3

Hash (cost=1.13..1.13 rows=13 width=48) (actual time=0.017..0.017 rows=13 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
20. 0.012 0.012 ↑ 1.0 13 3 / 3

Seq Scan on tango four_uniform (cost=0.00..1.13 rows=13 width=48) (actual time=0.010..0.012 rows=13 loops=3)

21. 3.647 5.276 ↓ 1.0 8,167 3 / 3

Hash (cost=241.39..241.39 rows=8,139 width=125) (actual time=5.275..5.276 rows=8,167 loops=3)

  • Buckets: 8,192 Batches: 1 Memory Usage: 1,324kB
22. 1.629 1.629 ↓ 1.0 8,167 3 / 3

Seq Scan on golf uniform_romeo (cost=0.00..241.39 rows=8,139 width=125) (actual time=0.013..1.629 rows=8,167 loops=3)

23. 0.200 0.200 ↑ 1.0 1 120 / 3

Index Scan using sierra_delta on sierra_three whiskey_six (cost=0.28..0.36 rows=1 width=285) (actual time=0.005..0.005 rows=1 loops=120)

  • Index Cond: (lima_delta1.lima_echo = quebec_seven)
24. 6.155 7.420 ↓ 1.0 5,539 3 / 3

Hash (cost=252.95..252.95 rows=5,495 width=233) (actual time=7.419..7.420 rows=5,539 loops=3)

  • Buckets: 8,192 Batches: 1 Memory Usage: 1,455kB
25. 1.265 1.265 ↓ 1.0 5,539 3 / 3

Seq Scan on delta_alpha five_xray (cost=0.00..252.95 rows=5,495 width=233) (actual time=0.017..1.265 rows=5,539 loops=3)

26. 0.280 0.280 ↓ 0.0 0 120 / 3

Index Scan using five_oscar on juliet_november romeo_kilo (cost=0.28..0.35 rows=1 width=1,443) (actual time=0.007..0.007 rows=0 loops=120)

  • Index Cond: (lima_delta1.quebec_seven = sierra_foxtrot)
27. 0.480 0.480 ↑ 1.0 1 120 / 3

Index Scan using charlie on uniform_kilo victor (cost=0.43..2.34 rows=1 width=56) (actual time=0.011..0.012 rows=1 loops=120)

  • Index Cond: (sierra_foxtrot = lima_delta1.quebec_seven)
28. 0.463 0.804 ↑ 1.0 902 3 / 3

Hash (cost=194.02..194.02 rows=902 width=322) (actual time=0.804..0.804 rows=902 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 287kB
29. 0.341 0.341 ↑ 1.0 902 3 / 3

Seq Scan on oscar yankee_xray (cost=0.00..194.02 rows=902 width=322) (actual time=0.012..0.341 rows=902 loops=3)

30. 0.940 1.410 ↓ 1.0 1,193 3 / 3

Hash (cost=259.78..259.78 rows=1,178 width=2,013) (actual time=1.409..1.410 rows=1,193 loops=3)

  • Buckets: 2,048 Batches: 1 Memory Usage: 999kB
31. 0.470 0.470 ↓ 1.0 1,193 3 / 3

Seq Scan on whiskey_tango hotel_golf (cost=0.00..259.78 rows=1,178 width=2,013) (actual time=0.014..0.470 rows=1,193 loops=3)

Planning time : 18.348 ms
Execution time : 70.248 ms