explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WL46

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 38.925 1,758.772 ↑ 2.1 288 1

Gather Merge (cost=186,494.63..186,564.63 rows=600 width=386) (actual time=1,734.201..1,758.772 rows=288 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.245 1,719.847 ↑ 3.1 96 3 / 3

Sort (cost=185,494.60..185,495.35 rows=300 width=386) (actual time=1,719.828..1,719.847 rows=96 loops=3)

  • Sort Key: romeo2.november, romeo8.three_zulu, romeo3.three_zulu
  • Sort Method: quicksort Memory: 81kB
3. 0.674 1,719.602 ↑ 3.1 96 3 / 3

Hash Left Join (cost=2.83..185,482.26 rows=300 width=386) (actual time=1,677.136..1,719.602 rows=96 loops=3)

  • Hash Cond: (romeo2.four_sierra = romeo6.quebec)
4. 0.080 1,718.901 ↑ 3.1 96 3 / 3

Nested Loop (cost=1.54..185,475.42 rows=300 width=260) (actual time=1,676.935..1,718.901 rows=96 loops=3)

5. 0.059 1,718.533 ↑ 3.1 96 3 / 3

Nested Loop Left Join (cost=1.27..184,725.42 rows=300 width=268) (actual time=1,676.888..1,718.533 rows=96 loops=3)

6. 0.076 1,717.610 ↑ 3.1 96 3 / 3

Nested Loop Left Join (cost=0.98..184,634.26 rows=300 width=217) (actual time=1,676.867..1,717.610 rows=96 loops=3)

7. 0.049 1,717.246 ↑ 3.1 96 3 / 3

Nested Loop Left Join (cost=0.71..184,541.79 rows=300 width=164) (actual time=1,676.843..1,717.246 rows=96 loops=3)

8. 0.581 1,716.909 ↑ 3.1 96 3 / 3

Nested Loop (cost=0.43..184,450.13 rows=300 width=139) (actual time=1,676.817..1,716.909 rows=96 loops=3)

9. 1,705.625 1,705.625 ↑ 5.2 2,141 3 / 3

Parallel Seq Scan on alpha four_uniform (cost=0.00..159,840.01 rows=11,176 width=32) (actual time=1,676.501..1,705.625 rows=2,141 loops=3)

  • Filter: (((NOT papa_bravo) OR (papa_bravo five_romeo NULL)) AND ((kilo_sierra)::date >= 'whiskey_kilo'::date) AND ((kilo_sierra)::date <= 'golf'::date))
  • Rows Removed by Filter: 1,835,110
10. 10.703 10.703 ↓ 0.0 0 6,422 / 3

Index Scan using victor on foxtrot_romeo foxtrot_juliet (cost=0.43..2.20 rows=1 width=123) (actual time=0.005..0.005 rows=0 loops=6,422)

  • Index Cond: (quebec = romeo1.sierra_foxtrot)
  • Filter: (((NOT papa_bravo) OR (papa_bravo five_romeo NULL)) AND (juliet = 2))
  • Rows Removed by Filter: 1
11. 0.288 0.288 ↑ 1.0 1 288 / 3

Index Scan using uniform on whiskey_tango papa_seven (cost=0.28..0.31 rows=1 width=41) (actual time=0.003..0.003 rows=1 loops=288)

  • Index Cond: (romeo1.delta = quebec)
12. 0.288 0.288 ↑ 1.0 1 288 / 3

Index Scan using kilo_kilo on oscar three_quebec (cost=0.28..0.31 rows=1 width=69) (actual time=0.003..0.003 rows=1 loops=288)

  • Index Cond: (romeo1.four_delta = quebec)
13. 0.864 0.864 ↑ 1.0 1 288 / 3

Index Scan using sierra_delta on sierra_three india (cost=0.28..0.30 rows=1 width=67) (actual time=0.009..0.009 rows=1 loops=288)

  • Index Cond: (romeo2.lima = quebec)
14. 0.288 0.288 ↑ 1.0 1 288 / 3

Index Only Scan using two on echo xray (cost=0.27..2.49 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=288)

  • Index Cond: (quebec = 2)
  • Heap Fetches: 109
15. 0.009 0.027 ↑ 1.0 13 3 / 3

Hash (cost=1.13..1.13 rows=13 width=13) (actual time=0.026..0.027 rows=13 loops=3)

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

Seq Scan on tango five_echo (cost=0.00..1.13 rows=13 width=13) (actual time=0.015..0.018 rows=13 loops=3)

Planning time : 2.389 ms
Execution time : 1,758.933 ms