explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DvyS : Optimization for: plan #WL46

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.375 1,220.390 ↓ 203.0 203 1

Sort (cost=149,674.49..149,674.49 rows=1 width=386) (actual time=1,181.993..1,220.390 rows=203 loops=1)

  • Sort Key: romeo2.november, romeo8.three_zulu, romeo3.three_zulu
  • Sort Method: quicksort Memory: 129kB
2. 2.724 1,220.015 ↓ 203.0 203 1

Nested Loop Left Join (cost=1,001.68..149,674.48 rows=1 width=386) (actual time=976.119..1,220.015 rows=203 loops=1)

3. 0.446 1,216.885 ↓ 203.0 203 1

Nested Loop (cost=1,001.54..149,674.31 rows=1 width=260) (actual time=976.100..1,216.885 rows=203 loops=1)

4. 0.405 1,215.627 ↓ 203.0 203 1

Nested Loop Left Join (cost=1,001.27..149,671.81 rows=1 width=268) (actual time=976.088..1,215.627 rows=203 loops=1)

5. 0.329 1,214.410 ↓ 203.0 203 1

Nested Loop (cost=1,000.99..149,671.50 rows=1 width=217) (actual time=976.078..1,214.410 rows=203 loops=1)

6. 4.759 1,159.037 ↓ 4,587.0 4,587 1

Nested Loop Left Join (cost=1,000.55..149,668.85 rows=1 width=110) (actual time=975.967..1,159.037 rows=4,587 loops=1)

7. 9.273 1,122.169 ↓ 4,587.0 4,587 1

Nested Loop Left Join (cost=1,000.28..149,666.36 rows=1 width=57) (actual time=975.958..1,122.169 rows=4,587 loops=1)

8. 91.157 1,089.961 ↓ 4,587.0 4,587 1

Gather (cost=1,000.00..149,663.86 rows=1 width=32) (actual time=975.943..1,089.961 rows=4,587 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
9. 998.804 998.804 ↓ 1,529.0 1,529 3 / 3

Parallel Seq Scan on alpha four_uniform (cost=0.00..148,663.76 rows=1 width=32) (actual time=968.836..998.804 rows=1,529 loops=3)

  • Filter: (((NOT papa_bravo) OR (papa_bravo five_romeo NULL)) AND (kilo_sierra >= 'four_foxtrot'::timestamp without time zone) AND (kilo_sierra <= 'uniform_hotel'::timestamp without time zone))
  • Rows Removed by Filter: 1,835,723
10. 22.935 22.935 ↑ 1.0 1 4,587

Index Scan using uniform_golf on whiskey papa_seven (cost=0.28..2.50 rows=1 width=41) (actual time=0.005..0.005 rows=1 loops=4,587)

  • Index Cond: (romeo1.delta = quebec)
11. 32.109 32.109 ↑ 1.0 1 4,587

Index Scan using kilo_kilo on oscar three_quebec (cost=0.28..2.49 rows=1 width=69) (actual time=0.007..0.007 rows=1 loops=4,587)

  • Index Cond: (romeo1.four_delta = quebec)
12. 55.044 55.044 ↓ 0.0 0 4,587

Index Scan using victor on foxtrot_romeo foxtrot_juliet (cost=0.43..2.65 rows=1 width=123) (actual time=0.012..0.012 rows=0 loops=4,587)

  • Index Cond: (quebec = romeo1.sierra_foxtrot)
  • Filter: (((NOT papa_bravo) OR (papa_bravo five_romeo NULL)) AND (juliet = 2))
  • Rows Removed by Filter: 1
13. 0.812 0.812 ↑ 1.0 1 203

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

  • Index Cond: (romeo2.lima = quebec)
14. 0.812 0.812 ↑ 1.0 1 203

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

  • Index Cond: (quebec = 2)
  • Heap Fetches: 203
15. 0.406 0.406 ↑ 1.0 1 203

Index Scan using uniform_romeo on tango five_echo (cost=0.14..0.15 rows=1 width=13) (actual time=0.002..0.002 rows=1 loops=203)

  • Index Cond: (romeo2.four_sierra = quebec)
Planning time : 1.441 ms
Execution time : 1,220.567 ms