/
PostgreSQL explain plan oddities
PostgreSQL explain plan oddities
Frits Jalvingh
Owned by Frits Jalvingh
Parallel execution woes
For the following query:
select
coalesce(eenheid_pe.id_s,-1) as eenheid_id
, sum(prijscomponent_pe.bedrag)::numeric(23,2) as kg00225
from s_h_eenheid_ssm eenheid_pe
inner join l_prijscomponent_eenheid l_prijscomponent_eenheid_pe
on eenheid_pe.id_h_eenheid = l_prijscomponent_eenheid_pe.id_h_eenheid
inner join s_l_prijscomponent_eenheid_ssm s_l_prijscomponent_eenheid_ssm_pe
on l_prijscomponent_eenheid_pe.id_l = s_l_prijscomponent_eenheid_ssm_pe.id_l
inner join s_h_prijscomponent_ssm prijscomponent_pe
on l_prijscomponent_eenheid_pe.id_h_prijscomponent = prijscomponent_pe.id_h_prijscomponent
where (prijscomponent_pe.soort = 'NET')
group by
coalesce(eenheid_pe.id_s,-1)
we get the following execution plan
Click here to expand...
<explain xmlns="http://www.postgresql.org/2009/explain">
<Query>
<Plan>
<Node-Type>Aggregate</Node-Type>
<Strategy>Hashed</Strategy>
<Partial-Mode>Finalize</Partial-Mode>
<Parallel-Aware>false</Parallel-Aware>
<Startup-Cost>396030.34</Startup-Cost>
<Total-Cost>396860.12</Total-Cost>
<Plan-Rows>55319</Plan-Rows>
<Plan-Width>26</Plan-Width>
<Actual-Startup-Time>3346.980</Actual-Startup-Time>
<Actual-Total-Time>3364.074</Actual-Total-Time>
<Actual-Rows>50285</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Output>
<Item>(COALESCE(eenheid_pe.id_s, '-1'::integer))</Item>
<Item>(sum(prijscomponent_pe.bedrag))::numeric(23,2)</Item>
</Output>
<Group-Key>
<Item>(COALESCE(eenheid_pe.id_s, '-1'::integer))</Item>
</Group-Key>
<Shared-Hit-Blocks>15031</Shared-Hit-Blocks>
<Shared-Read-Blocks>132413</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
<Plans>
<Plan>
<Node-Type>Gather</Node-Type>
<Parent-Relationship>Outer</Parent-Relationship>
<Parallel-Aware>false</Parallel-Aware>
<Startup-Cost>383445.26</Startup-Cost>
<Total-Cost>395200.55</Total-Cost>
<Plan-Rows>110638</Plan-Rows>
<Plan-Width>36</Plan-Width>
<Actual-Startup-Time>3217.674</Actual-Startup-Time>
<Actual-Total-Time>3260.882</Actual-Total-Time>
<Actual-Rows>130713</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Output>
<Item>(COALESCE(eenheid_pe.id_s, '-1'::integer))</Item>
<Item>(PARTIAL sum(prijscomponent_pe.bedrag))</Item>
</Output>
<Workers-Planned>2</Workers-Planned>
<Workers-Launched>2</Workers-Launched>
<Single-Copy>false</Single-Copy>
<Shared-Hit-Blocks>15031</Shared-Hit-Blocks>
<Shared-Read-Blocks>132413</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
<Plans>
<Plan>
<Node-Type>Aggregate</Node-Type>
<Strategy>Hashed</Strategy>
<Partial-Mode>Partial</Partial-Mode>
<Parent-Relationship>Outer</Parent-Relationship>
<Parallel-Aware>false</Parallel-Aware>
<Startup-Cost>382445.26</Startup-Cost>
<Total-Cost>383136.75</Total-Cost>
<Plan-Rows>55319</Plan-Rows>
<Plan-Width>36</Plan-Width>
<Actual-Startup-Time>3214.911</Actual-Startup-Time>
<Actual-Total-Time>3240.731</Actual-Total-Time>
<Actual-Rows>43571</Actual-Rows>
<Actual-Loops>3</Actual-Loops>
<Output>
<Item>(COALESCE(eenheid_pe.id_s, '-1'::integer))</Item>
<Item>PARTIAL sum(prijscomponent_pe.bedrag)</Item>
</Output>
<Group-Key>
<Item>COALESCE(eenheid_pe.id_s, '-1'::integer)</Item>
</Group-Key>
<Shared-Hit-Blocks>40137</Shared-Hit-Blocks>
<Shared-Read-Blocks>402484</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
<Workers>
<Worker>
<Worker-Number>0</Worker-Number>
<Actual-Startup-Time>3213.592</Actual-Startup-Time>
<Actual-Total-Time>3246.260</Actual-Total-Time>
<Actual-Rows>43797</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>5235</Shared-Hit-Blocks>
<Shared-Read-Blocks>142425</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
<Worker>
<Worker-Number>1</Worker-Number>
<Actual-Startup-Time>3213.709</Actual-Startup-Time>
<Actual-Total-Time>3237.020</Actual-Total-Time>
<Actual-Rows>43594</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>19871</Shared-Hit-Blocks>
<Shared-Read-Blocks>127646</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
</Workers>
<Plans>
<Plan>
<Node-Type>Hash Join</Node-Type>
<Parent-Relationship>Outer</Parent-Relationship>
<Parallel-Aware>false</Parallel-Aware>
<Join-Type>Inner</Join-Type>
<Startup-Cost>301903.63</Startup-Cost>
<Total-Cost>379849.23</Total-Cost>
<Plan-Rows>519206</Plan-Rows>
<Plan-Width>8</Plan-Width>
<Actual-Startup-Time>2602.879</Actual-Startup-Time>
<Actual-Total-Time>3125.668</Actual-Total-Time>
<Actual-Rows>411780</Actual-Rows>
<Actual-Loops>3</Actual-Loops>
<Output>
<Item>COALESCE(eenheid_pe.id_s, '-1'::integer)</Item>
<Item>prijscomponent_pe.bedrag</Item>
</Output>
<Inner-Unique>false</Inner-Unique>
<Hash-Cond>(l_prijscomponent_eenheid_pe.id_h_eenheid = eenheid_pe.id_h_eenheid)</Hash-Cond>
<Shared-Hit-Blocks>40137</Shared-Hit-Blocks>
<Shared-Read-Blocks>402484</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
<Workers>
<Worker>
<Worker-Number>0</Worker-Number>
<Actual-Startup-Time>2590.188</Actual-Startup-Time>
<Actual-Total-Time>3122.613</Actual-Total-Time>
<Actual-Rows>415819</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>5235</Shared-Hit-Blocks>
<Shared-Read-Blocks>142425</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
<Worker>
<Worker-Number>1</Worker-Number>
<Actual-Startup-Time>2606.252</Actual-Startup-Time>
<Actual-Total-Time>3125.799</Actual-Total-Time>
<Actual-Rows>410278</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>19871</Shared-Hit-Blocks>
<Shared-Read-Blocks>127646</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
</Workers>
<Plans>
<Plan>
<Node-Type>Hash Join</Node-Type>
<Parent-Relationship>Outer</Parent-Relationship>
<Parallel-Aware>false</Parallel-Aware>
<Join-Type>Inner</Join-Type>
<Startup-Cost>298532.96</Startup-Cost>
<Total-Cost>369339.47</Total-Cost>
<Plan-Rows>519206</Plan-Rows>
<Plan-Width>8</Plan-Width>
<Actual-Startup-Time>2583.478</Actual-Startup-Time>
<Actual-Total-Time>3032.836</Actual-Total-Time>
<Actual-Rows>411780</Actual-Rows>
<Actual-Loops>3</Actual-Loops>
<Output>
<Item>l_prijscomponent_eenheid_pe.id_h_eenheid</Item>
<Item>prijscomponent_pe.bedrag</Item>
</Output>
<Inner-Unique>false</Inner-Unique>
<Hash-Cond>(s_l_prijscomponent_eenheid_ssm_pe.id_l = l_prijscomponent_eenheid_pe.id_l)</Hash-Cond>
<Shared-Hit-Blocks>33753</Shared-Hit-Blocks>
<Shared-Read-Blocks>402484</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
<Workers>
<Worker>
<Worker-Number>0</Worker-Number>
<Actual-Startup-Time>2571.563</Actual-Startup-Time>
<Actual-Total-Time>3029.214</Actual-Total-Time>
<Actual-Rows>415819</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>3106</Shared-Hit-Blocks>
<Shared-Read-Blocks>142425</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
<Worker>
<Worker-Number>1</Worker-Number>
<Actual-Startup-Time>2588.093</Actual-Startup-Time>
<Actual-Total-Time>3035.242</Actual-Total-Time>
<Actual-Rows>410278</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>17742</Shared-Hit-Blocks>
<Shared-Read-Blocks>127646</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
</Workers>
<Plans>
<Plan>
<Node-Type>Seq Scan</Node-Type>
<Parent-Relationship>Outer</Parent-Relationship>
<Parallel-Aware>true</Parallel-Aware>
<Relation-Name>s_l_prijscomponent_eenheid_ssm</Relation-Name>
<Schema>datavault</Schema>
<Alias>s_l_prijscomponent_eenheid_ssm_pe</Alias>
<Startup-Cost>0.00</Startup-Cost>
<Total-Cost>58324.06</Total-Cost>
<Plan-Rows>1944106</Plan-Rows>
<Plan-Width>8</Plan-Width>
<Actual-Startup-Time>0.029</Actual-Startup-Time>
<Actual-Total-Time>100.320</Actual-Total-Time>
<Actual-Rows>1555285</Actual-Rows>
<Actual-Loops>3</Actual-Loops>
<Output>
<Item>s_l_prijscomponent_eenheid_ssm_pe.id_s</Item>
<Item>s_l_prijscomponent_eenheid_ssm_pe.dv_end_dts</Item>
<Item>s_l_prijscomponent_eenheid_ssm_pe.dv_load_dts</Item>
<Item>s_l_prijscomponent_eenheid_ssm_pe.dv_start_dts</Item>
<Item>s_l_prijscomponent_eenheid_ssm_pe.id_l</Item>
<Item>s_l_prijscomponent_eenheid_ssm_pe.organisatie</Item>
</Output>
<Shared-Hit-Blocks>864</Shared-Hit-Blocks>
<Shared-Read-Blocks>38019</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
<Workers>
<Worker>
<Worker-Number>0</Worker-Number>
<Actual-Startup-Time>0.025</Actual-Startup-Time>
<Actual-Total-Time>102.162</Actual-Total-Time>
<Actual-Rows>1569120</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>263</Shared-Hit-Blocks>
<Shared-Read-Blocks>12813</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
<Worker>
<Worker-Number>1</Worker-Number>
<Actual-Startup-Time>0.027</Actual-Startup-Time>
<Actual-Total-Time>99.250</Actual-Total-Time>
<Actual-Rows>1551854</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>296</Shared-Hit-Blocks>
<Shared-Read-Blocks>12637</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
</Workers>
</Plan>
<Plan>
<Node-Type>Hash</Node-Type>
<Parent-Relationship>Inner</Parent-Relationship>
<Parallel-Aware>false</Parallel-Aware>
<Startup-Cost>282956.78</Startup-Cost>
<Total-Cost>282956.78</Total-Cost>
<Plan-Rows>1246094</Plan-Rows>
<Plan-Width>12</Plan-Width>
<Actual-Startup-Time>2579.555</Actual-Startup-Time>
<Actual-Total-Time>2579.555</Actual-Total-Time>
<Actual-Rows>1235341</Actual-Rows>
<Actual-Loops>3</Actual-Loops>
<Output>
<Item>l_prijscomponent_eenheid_pe.id_h_eenheid</Item>
<Item>l_prijscomponent_eenheid_pe.id_l</Item>
<Item>prijscomponent_pe.bedrag</Item>
</Output>
<Hash-Buckets>2097152</Hash-Buckets>
<Original-Hash-Buckets>2097152</Original-Hash-Buckets>
<Hash-Batches>1</Hash-Batches>
<Original-Hash-Batches>1</Original-Hash-Batches>
<Peak-Memory-Usage>69856</Peak-Memory-Usage>
<Shared-Hit-Blocks>32858</Shared-Hit-Blocks>
<Shared-Read-Blocks>364465</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
<Workers>
<Worker>
<Worker-Number>0</Worker-Number>
<Actual-Startup-Time>2567.927</Actual-Startup-Time>
<Actual-Total-Time>2567.927</Actual-Total-Time>
<Actual-Rows>1235341</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>2829</Shared-Hit-Blocks>
<Shared-Read-Blocks>129612</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
<Worker>
<Worker-Number>1</Worker-Number>
<Actual-Startup-Time>2584.349</Actual-Startup-Time>
<Actual-Total-Time>2584.349</Actual-Total-Time>
<Actual-Rows>1235341</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>17432</Shared-Hit-Blocks>
<Shared-Read-Blocks>115009</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
</Workers>
<Plans>
<Plan>
<Node-Type>Hash Join</Node-Type>
<Parent-Relationship>Outer</Parent-Relationship>
<Parallel-Aware>false</Parallel-Aware>
<Join-Type>Inner</Join-Type>
<Startup-Cost>172032.35</Startup-Cost>
<Total-Cost>282956.78</Total-Cost>
<Plan-Rows>1246094</Plan-Rows>
<Plan-Width>12</Plan-Width>
<Actual-Startup-Time>1026.851</Actual-Startup-Time>
<Actual-Total-Time>2355.056</Actual-Total-Time>
<Actual-Rows>1235341</Actual-Rows>
<Actual-Loops>3</Actual-Loops>
<Output>
<Item>l_prijscomponent_eenheid_pe.id_h_eenheid</Item>
<Item>l_prijscomponent_eenheid_pe.id_l</Item>
<Item>prijscomponent_pe.bedrag</Item>
</Output>
<Inner-Unique>false</Inner-Unique>
<Hash-Cond>(l_prijscomponent_eenheid_pe.id_h_prijscomponent = prijscomponent_pe.id_h_prijscomponent)</Hash-Cond>
<Shared-Hit-Blocks>32858</Shared-Hit-Blocks>
<Shared-Read-Blocks>364465</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
<Workers>
<Worker>
<Worker-Number>0</Worker-Number>
<Actual-Startup-Time>984.823</Actual-Startup-Time>
<Actual-Total-Time>2338.222</Actual-Total-Time>
<Actual-Rows>1235341</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>2829</Shared-Hit-Blocks>
<Shared-Read-Blocks>129612</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
<Worker>
<Worker-Number>1</Worker-Number>
<Actual-Startup-Time>1049.712</Actual-Startup-Time>
<Actual-Total-Time>2363.045</Actual-Total-Time>
<Actual-Rows>1235341</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>17432</Shared-Hit-Blocks>
<Shared-Read-Blocks>115009</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
</Workers>
<Plans>
<Plan>
<Node-Type>Seq Scan</Node-Type>
<Parent-Relationship>Outer</Parent-Relationship>
<Parallel-Aware>false</Parallel-Aware>
<Relation-Name>l_prijscomponent_eenheid</Relation-Name>
<Schema>datavault</Schema>
<Alias>l_prijscomponent_eenheid_pe</Alias>
<Startup-Cost>0.00</Startup-Cost>
<Total-Cost>80966.54</Total-Cost>
<Plan-Rows>4665854</Plan-Rows>
<Plan-Width>12</Plan-Width>
<Actual-Startup-Time>0.024</Actual-Startup-Time>
<Actual-Total-Time>289.457</Actual-Total-Time>
<Actual-Rows>4665854</Actual-Rows>
<Actual-Loops>3</Actual-Loops>
<Output>
<Item>l_prijscomponent_eenheid_pe.id_l</Item>
<Item>l_prijscomponent_eenheid_pe.id_h_eenheid</Item>
<Item>l_prijscomponent_eenheid_pe.id_h_prijscomponent</Item>
<Item>l_prijscomponent_eenheid_pe.load_dts</Item>
<Item>l_prijscomponent_eenheid_pe.source_system_id</Item>
</Output>
<Shared-Hit-Blocks>11472</Shared-Hit-Blocks>
<Shared-Read-Blocks>91452</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
<Workers>
<Worker>
<Worker-Number>0</Worker-Number>
<Actual-Startup-Time>0.022</Actual-Startup-Time>
<Actual-Total-Time>297.085</Actual-Total-Time>
<Actual-Rows>4665854</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>1203</Shared-Hit-Blocks>
<Shared-Read-Blocks>33105</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
<Worker>
<Worker-Number>1</Worker-Number>
<Actual-Startup-Time>0.035</Actual-Startup-Time>
<Actual-Total-Time>283.992</Actual-Total-Time>
<Actual-Rows>4665854</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>5724</Shared-Hit-Blocks>
<Shared-Read-Blocks>28584</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
</Workers>
</Plan>
<Plan>
<Node-Type>Hash</Node-Type>
<Parent-Relationship>Inner</Parent-Relationship>
<Parallel-Aware>false</Parallel-Aware>
<Startup-Cost>156456.17</Startup-Cost>
<Total-Cost>156456.17</Total-Cost>
<Plan-Rows>1246094</Plan-Rows>
<Plan-Width>8</Plan-Width>
<Actual-Startup-Time>1023.252</Actual-Startup-Time>
<Actual-Total-Time>1023.252</Actual-Total-Time>
<Actual-Rows>1235341</Actual-Rows>
<Actual-Loops>3</Actual-Loops>
<Output>
<Item>prijscomponent_pe.bedrag</Item>
<Item>prijscomponent_pe.id_h_prijscomponent</Item>
</Output>
<Hash-Buckets>2097152</Hash-Buckets>
<Original-Hash-Buckets>2097152</Original-Hash-Buckets>
<Hash-Batches>1</Hash-Batches>
<Original-Hash-Batches>1</Original-Hash-Batches>
<Peak-Memory-Usage>66252</Peak-Memory-Usage>
<Shared-Hit-Blocks>21386</Shared-Hit-Blocks>
<Shared-Read-Blocks>273013</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
<Workers>
<Worker>
<Worker-Number>0</Worker-Number>
<Actual-Startup-Time>981.257</Actual-Startup-Time>
<Actual-Total-Time>981.257</Actual-Total-Time>
<Actual-Rows>1235341</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>1626</Shared-Hit-Blocks>
<Shared-Read-Blocks>96507</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
<Worker>
<Worker-Number>1</Worker-Number>
<Actual-Startup-Time>1046.080</Actual-Startup-Time>
<Actual-Total-Time>1046.080</Actual-Total-Time>
<Actual-Rows>1235341</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>11708</Shared-Hit-Blocks>
<Shared-Read-Blocks>86425</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
</Workers>
<Plans>
<Plan>
<Node-Type>Seq Scan</Node-Type>
<Parent-Relationship>Outer</Parent-Relationship>
<Parallel-Aware>false</Parallel-Aware>
<Relation-Name>s_h_prijscomponent_ssm</Relation-Name>
<Schema>datavault</Schema>
<Alias>prijscomponent_pe</Alias>
<Startup-Cost>0.00</Startup-Cost>
<Total-Cost>156456.17</Total-Cost>
<Plan-Rows>1246094</Plan-Rows>
<Plan-Width>8</Plan-Width>
<Actual-Startup-Time>0.019</Actual-Startup-Time>
<Actual-Total-Time>794.602</Actual-Total-Time>
<Actual-Rows>1235341</Actual-Rows>
<Actual-Loops>3</Actual-Loops>
<Output>
<Item>prijscomponent_pe.bedrag</Item>
<Item>prijscomponent_pe.id_h_prijscomponent</Item>
</Output>
<Filter>(prijscomponent_pe.soort = 'NET'::text)</Filter>
<Rows-Removed-by-Filter>3430513</Rows-Removed-by-Filter>
<Shared-Hit-Blocks>21386</Shared-Hit-Blocks>
<Shared-Read-Blocks>273013</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
<Workers>
<Worker>
<Worker-Number>0</Worker-Number>
<Actual-Startup-Time>0.016</Actual-Startup-Time>
<Actual-Total-Time>757.438</Actual-Total-Time>
<Actual-Rows>1235341</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>1626</Shared-Hit-Blocks>
<Shared-Read-Blocks>96507</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
<Worker>
<Worker-Number>1</Worker-Number>
<Actual-Startup-Time>0.027</Actual-Startup-Time>
<Actual-Total-Time>812.968</Actual-Total-Time>
<Actual-Rows>1235341</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>11708</Shared-Hit-Blocks>
<Shared-Read-Blocks>86425</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
</Workers>
</Plan>
</Plans>
</Plan>
</Plans>
</Plan>
</Plans>
</Plan>
</Plans>
</Plan>
<Plan>
<Node-Type>Hash</Node-Type>
<Parent-Relationship>Inner</Parent-Relationship>
<Parallel-Aware>false</Parallel-Aware>
<Startup-Cost>2679.19</Startup-Cost>
<Total-Cost>2679.19</Total-Cost>
<Plan-Rows>55319</Plan-Rows>
<Plan-Width>8</Plan-Width>
<Actual-Startup-Time>19.230</Actual-Startup-Time>
<Actual-Total-Time>19.230</Actual-Total-Time>
<Actual-Rows>55319</Actual-Rows>
<Actual-Loops>3</Actual-Loops>
<Output>
<Item>eenheid_pe.id_s</Item>
<Item>eenheid_pe.id_h_eenheid</Item>
</Output>
<Hash-Buckets>65536</Hash-Buckets>
<Original-Hash-Buckets>65536</Original-Hash-Buckets>
<Hash-Batches>1</Hash-Batches>
<Original-Hash-Batches>1</Original-Hash-Batches>
<Peak-Memory-Usage>2673</Peak-Memory-Usage>
<Shared-Hit-Blocks>6378</Shared-Hit-Blocks>
<Shared-Read-Blocks>0</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
<Workers>
<Worker>
<Worker-Number>0</Worker-Number>
<Actual-Startup-Time>18.435</Actual-Startup-Time>
<Actual-Total-Time>18.435</Actual-Total-Time>
<Actual-Rows>55319</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>2126</Shared-Hit-Blocks>
<Shared-Read-Blocks>0</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
<Worker>
<Worker-Number>1</Worker-Number>
<Actual-Startup-Time>17.968</Actual-Startup-Time>
<Actual-Total-Time>17.968</Actual-Total-Time>
<Actual-Rows>55319</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>2126</Shared-Hit-Blocks>
<Shared-Read-Blocks>0</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
</Workers>
<Plans>
<Plan>
<Node-Type>Seq Scan</Node-Type>
<Parent-Relationship>Outer</Parent-Relationship>
<Parallel-Aware>false</Parallel-Aware>
<Relation-Name>s_h_eenheid_ssm</Relation-Name>
<Schema>datavault</Schema>
<Alias>eenheid_pe</Alias>
<Startup-Cost>0.00</Startup-Cost>
<Total-Cost>2679.19</Total-Cost>
<Plan-Rows>55319</Plan-Rows>
<Plan-Width>8</Plan-Width>
<Actual-Startup-Time>0.015</Actual-Startup-Time>
<Actual-Total-Time>9.727</Actual-Total-Time>
<Actual-Rows>55319</Actual-Rows>
<Actual-Loops>3</Actual-Loops>
<Output>
<Item>eenheid_pe.id_s</Item>
<Item>eenheid_pe.id_h_eenheid</Item>
</Output>
<Shared-Hit-Blocks>6378</Shared-Hit-Blocks>
<Shared-Read-Blocks>0</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
<Workers>
<Worker>
<Worker-Number>0</Worker-Number>
<Actual-Startup-Time>0.017</Actual-Startup-Time>
<Actual-Total-Time>9.328</Actual-Total-Time>
<Actual-Rows>55319</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>2126</Shared-Hit-Blocks>
<Shared-Read-Blocks>0</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
<Worker>
<Worker-Number>1</Worker-Number>
<Actual-Startup-Time>0.019</Actual-Startup-Time>
<Actual-Total-Time>8.883</Actual-Total-Time>
<Actual-Rows>55319</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>2126</Shared-Hit-Blocks>
<Shared-Read-Blocks>0</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
</Workers>
</Plan>
</Plans>
</Plan>
</Plans>
</Plan>
</Plans>
</Plan>
</Plans>
</Plan>
</Plans>
</Plan>
<Planning-Time>0.644</Planning-Time>
<Triggers>
</Triggers>
<Execution-Time>3368.593</Execution-Time>
</Query>
</explain>
The plan visualiser shows:
In this image there is trouble in seq scan 12: it reports 3 loops and consequently a large total #of rows, while the actual #of rows is 55.319. This node in the plan has loops=3 for a hash join which is odd because that should not repeatedly execute its contents. The number of loops is persistently 1 = (number of workers) which leads me to believe that each worker executes the whole subflow.
Questions:
- Since we have two workers but loops = 3, are there actually 3 processes executing the node?
- As we have loops = 3, is the ACTUAL ROWS READ 3x the number of actual rows reported, i.e. 165,957 rows are really read (meaning that the table is actually read 3 times)?
- As we are running in parallel, what does the total time now represent? Is it the sum of the lapses of all three runs? Divided by loops perhaps?
More complex queries
In the more complex thing:
select
coalesce(eenheid_pe.id_s,-1) as eenheid_id
, sum(prijscomponent_pe.bedrag)::numeric(23,2) as kg00225
from s_h_eenheid_ssm eenheid_pe
inner join l_prijscomponent_eenheid l_prijscomponent_eenheid_ps
on eenheid_pe.id_h_eenheid = l_prijscomponent_eenheid_ps.id_h_eenheid
inner join s_l_prijscomponent_eenheid_ssm s_l_prijscomponent_eenheid_ssm_ps
on l_prijscomponent_eenheid_ps.id_l = s_l_prijscomponent_eenheid_ssm_ps.id_l
inner join s_h_prijscomponent_ssm prijscomponent_ps
on l_prijscomponent_eenheid_ps.id_h_prijscomponent = prijscomponent_ps.id_h_prijscomponent
inner join s_h_eenheid_ssm eenheid_ps
on eenheid_pe.id_h_eenheid = eenheid_ps.id_h_eenheid
inner join l_prijscomponent_eenheid l_prijscomponent_eenheid_pe
on eenheid_pe.id_h_eenheid = l_prijscomponent_eenheid_pe.id_h_eenheid
inner join s_l_prijscomponent_eenheid_ssm s_l_prijscomponent_eenheid_ssm_pe
on l_prijscomponent_eenheid_pe.id_l = s_l_prijscomponent_eenheid_ssm_pe.id_l
inner join s_h_prijscomponent_ssm prijscomponent_pe
on l_prijscomponent_eenheid_pe.id_h_prijscomponent = prijscomponent_pe.id_h_prijscomponent
where (prijscomponent_pe.soort = 'NET')
group by
coalesce(eenheid_pe.id_s,-1)
which looks like this in the plan visualiser:
With the execution plan:
Click here to expand...
<explain xmlns="http://www.postgresql.org/2009/explain">
<Query>
<Plan>
<Node-Type>Aggregate</Node-Type>
<Strategy>Sorted</Strategy>
<Partial-Mode>Finalize</Partial-Mode>
<Parallel-Aware>false</Parallel-Aware>
<Startup-Cost>1655629.20</Startup-Cost>
<Total-Cost>1657565.37</Total-Cost>
<Plan-Rows>55319</Plan-Rows>
<Plan-Width>26</Plan-Width>
<Actual-Startup-Time>18393.373</Actual-Startup-Time>
<Actual-Total-Time>18471.509</Actual-Total-Time>
<Actual-Rows>50285</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Output>
<Item>(COALESCE(eenheid_pe.id_s, '-1'::integer))</Item>
<Item>(sum(prijscomponent_pe.bedrag))::numeric(23,2)</Item>
</Output>
<Group-Key>
<Item>(COALESCE(eenheid_pe.id_s, '-1'::integer))</Item>
</Group-Key>
<Shared-Hit-Blocks>84718</Shared-Hit-Blocks>
<Shared-Read-Blocks>236297</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
<Plans>
<Plan>
<Node-Type>Sort</Node-Type>
<Parent-Relationship>Outer</Parent-Relationship>
<Parallel-Aware>false</Parallel-Aware>
<Startup-Cost>1655629.20</Startup-Cost>
<Total-Cost>1655905.80</Total-Cost>
<Plan-Rows>110638</Plan-Rows>
<Plan-Width>36</Plan-Width>
<Actual-Startup-Time>18393.363</Actual-Startup-Time>
<Actual-Total-Time>18405.707</Actual-Total-Time>
<Actual-Rows>134821</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Output>
<Item>(COALESCE(eenheid_pe.id_s, '-1'::integer))</Item>
<Item>(PARTIAL sum(prijscomponent_pe.bedrag))</Item>
</Output>
<Sort-Key>
<Item>(COALESCE(eenheid_pe.id_s, '-1'::integer))</Item>
</Sort-Key>
<Sort-Method>quicksort</Sort-Method>
<Sort-Space-Used>16677</Sort-Space-Used>
<Sort-Space-Type>Memory</Sort-Space-Type>
<Shared-Hit-Blocks>84718</Shared-Hit-Blocks>
<Shared-Read-Blocks>236297</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
<Plans>
<Plan>
<Node-Type>Gather</Node-Type>
<Parent-Relationship>Outer</Parent-Relationship>
<Parallel-Aware>false</Parallel-Aware>
<Startup-Cost>1634604.95</Startup-Cost>
<Total-Cost>1646360.23</Total-Cost>
<Plan-Rows>110638</Plan-Rows>
<Plan-Width>36</Plan-Width>
<Actual-Startup-Time>18323.007</Actual-Startup-Time>
<Actual-Total-Time>18367.239</Actual-Total-Time>
<Actual-Rows>134821</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Output>
<Item>(COALESCE(eenheid_pe.id_s, '-1'::integer))</Item>
<Item>(PARTIAL sum(prijscomponent_pe.bedrag))</Item>
</Output>
<Workers-Planned>2</Workers-Planned>
<Workers-Launched>2</Workers-Launched>
<Single-Copy>false</Single-Copy>
<Shared-Hit-Blocks>84715</Shared-Hit-Blocks>
<Shared-Read-Blocks>236297</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
<Plans>
<Plan>
<Node-Type>Aggregate</Node-Type>
<Strategy>Hashed</Strategy>
<Partial-Mode>Partial</Partial-Mode>
<Parent-Relationship>Outer</Parent-Relationship>
<Parallel-Aware>false</Parallel-Aware>
<Startup-Cost>1633604.95</Startup-Cost>
<Total-Cost>1634296.43</Total-Cost>
<Plan-Rows>55319</Plan-Rows>
<Plan-Width>36</Plan-Width>
<Actual-Startup-Time>18320.220</Actual-Startup-Time>
<Actual-Total-Time>18342.012</Actual-Total-Time>
<Actual-Rows>44940</Actual-Rows>
<Actual-Loops>3</Actual-Loops>
<Output>
<Item>(COALESCE(eenheid_pe.id_s, '-1'::integer))</Item>
<Item>PARTIAL sum(prijscomponent_pe.bedrag)</Item>
</Output>
<Group-Key>
<Item>COALESCE(eenheid_pe.id_s, '-1'::integer)</Item>
</Group-Key>
<Shared-Hit-Blocks>234150</Shared-Hit-Blocks>
<Shared-Read-Blocks>728821</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
<Workers>
<Worker>
<Worker-Number>0</Worker-Number>
<Actual-Startup-Time>18318.778</Actual-Startup-Time>
<Actual-Total-Time>18340.737</Actual-Total-Time>
<Actual-Rows>45107</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>73167</Shared-Hit-Blocks>
<Shared-Read-Blocks>247913</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
<Worker>
<Worker-Number>1</Worker-Number>
<Actual-Startup-Time>18319.338</Actual-Startup-Time>
<Actual-Total-Time>18340.887</Actual-Total-Time>
<Actual-Rows>44705</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>76268</Shared-Hit-Blocks>
<Shared-Read-Blocks>244611</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
</Workers>
<Plans>
<Plan>
<Node-Type>Hash Join</Node-Type>
<Parent-Relationship>Outer</Parent-Relationship>
<Parallel-Aware>false</Parallel-Aware>
<Join-Type>Inner</Join-Type>
<Startup-Cost>796648.78</Startup-Cost>
<Total-Cost>1414644.14</Total-Cost>
<Plan-Rows>43792162</Plan-Rows>
<Plan-Width>8</Plan-Width>
<Actual-Startup-Time>6722.669</Actual-Startup-Time>
<Actual-Total-Time>11677.796</Actual-Total-Time>
<Actual-Rows>42457728</Actual-Rows>
<Actual-Loops>3</Actual-Loops>
<Output>
<Item>COALESCE(eenheid_pe.id_s, '-1'::integer)</Item>
<Item>prijscomponent_pe.bedrag</Item>
</Output>
<Inner-Unique>false</Inner-Unique>
<Hash-Cond>(l_prijscomponent_eenheid_ps.id_h_eenheid = eenheid_pe.id_h_eenheid)</Hash-Cond>
<Shared-Hit-Blocks>234150</Shared-Hit-Blocks>
<Shared-Read-Blocks>728821</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
<Workers>
<Worker>
<Worker-Number>0</Worker-Number>
<Actual-Startup-Time>6672.321</Actual-Startup-Time>
<Actual-Total-Time>11648.916</Actual-Total-Time>
<Actual-Rows>42691244</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>73167</Shared-Hit-Blocks>
<Shared-Read-Blocks>247913</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
<Worker>
<Worker-Number>1</Worker-Number>
<Actual-Startup-Time>6769.988</Actual-Startup-Time>
<Actual-Total-Time>11706.970</Actual-Total-Time>
<Actual-Rows>42108705</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>76268</Shared-Hit-Blocks>
<Shared-Read-Blocks>244611</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
</Workers>
<Plans>
<Plan>
<Node-Type>Hash Join</Node-Type>
<Parent-Relationship>Outer</Parent-Relationship>
<Parallel-Aware>false</Parallel-Aware>
<Join-Type>Inner</Join-Type>
<Startup-Cost>342404.43</Startup-Cost>
<Total-Cost>461724.81</Total-Cost>
<Plan-Rows>1944106</Plan-Rows>
<Plan-Width>4</Plan-Width>
<Actual-Startup-Time>2593.779</Actual-Startup-Time>
<Actual-Total-Time>3741.301</Actual-Total-Time>
<Actual-Rows>1555285</Actual-Rows>
<Actual-Loops>3</Actual-Loops>
<Output>
<Item>l_prijscomponent_eenheid_ps.id_h_eenheid</Item>
</Output>
<Inner-Unique>false</Inner-Unique>
<Hash-Cond>(l_prijscomponent_eenheid_ps.id_h_prijscomponent = prijscomponent_ps.id_h_prijscomponent)</Hash-Cond>
<Shared-Hit-Blocks>48789</Shared-Hit-Blocks>
<Shared-Read-Blocks>387454</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
<Workers>
<Worker>
<Worker-Number>0</Worker-Number>
<Actual-Startup-Time>2569.172</Actual-Startup-Time>
<Actual-Total-Time>3717.860</Actual-Total-Time>
<Actual-Rows>1565520</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>13375</Shared-Hit-Blocks>
<Shared-Read-Blocks>132129</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
<Worker>
<Worker-Number>1</Worker-Number>
<Actual-Startup-Time>2629.302</Actual-Startup-Time>
<Actual-Total-Time>3768.949</Actual-Total-Time>
<Actual-Rows>1541294</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>13665</Shared-Hit-Blocks>
<Shared-Read-Blocks>131638</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
</Workers>
<Plans>
<Plan>
<Node-Type>Hash Join</Node-Type>
<Parent-Relationship>Outer</Parent-Relationship>
<Parallel-Aware>false</Parallel-Aware>
<Join-Type>Inner</Join-Type>
<Startup-Cost>139289.72</Startup-Cost>
<Total-Cost>222158.11</Total-Cost>
<Plan-Rows>1944106</Plan-Rows>
<Plan-Width>8</Plan-Width>
<Actual-Startup-Time>1302.572</Actual-Startup-Time>
<Actual-Total-Time>1926.825</Actual-Total-Time>
<Actual-Rows>1555285</Actual-Rows>
<Actual-Loops>3</Actual-Loops>
<Output>
<Item>l_prijscomponent_eenheid_ps.id_h_eenheid</Item>
<Item>l_prijscomponent_eenheid_ps.id_h_prijscomponent</Item>
</Output>
<Inner-Unique>true</Inner-Unique>
<Hash-Cond>(s_l_prijscomponent_eenheid_ssm_ps.id_l = l_prijscomponent_eenheid_ps.id_l)</Hash-Cond>
<Shared-Hit-Blocks>15846</Shared-Hit-Blocks>
<Shared-Read-Blocks>125992</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
<Workers>
<Worker>
<Worker-Number>0</Worker-Number>
<Actual-Startup-Time>1283.351</Actual-Startup-Time>
<Actual-Total-Time>1910.770</Actual-Total-Time>
<Actual-Rows>1565520</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>5997</Shared-Hit-Blocks>
<Shared-Read-Blocks>41371</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
<Worker>
<Worker-Number>1</Worker-Number>
<Actual-Startup-Time>1332.163</Actual-Startup-Time>
<Actual-Total-Time>1954.529</Actual-Total-Time>
<Actual-Rows>1541294</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>2269</Shared-Hit-Blocks>
<Shared-Read-Blocks>44898</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
</Workers>
<Plans>
<Plan>
<Node-Type>Seq Scan</Node-Type>
<Parent-Relationship>Outer</Parent-Relationship>
<Parallel-Aware>true</Parallel-Aware>
<Relation-Name>s_l_prijscomponent_eenheid_ssm</Relation-Name>
<Schema>datavault</Schema>
<Alias>s_l_prijscomponent_eenheid_ssm_ps</Alias>
<Startup-Cost>0.00</Startup-Cost>
<Total-Cost>58324.06</Total-Cost>
<Plan-Rows>1944106</Plan-Rows>
<Plan-Width>8</Plan-Width>
<Actual-Startup-Time>0.027</Actual-Startup-Time>
<Actual-Total-Time>109.022</Actual-Total-Time>
<Actual-Rows>1555285</Actual-Rows>
<Actual-Loops>3</Actual-Loops>
<Output>
<Item>s_l_prijscomponent_eenheid_ssm_ps.id_s</Item>
<Item>s_l_prijscomponent_eenheid_ssm_ps.dv_end_dts</Item>
<Item>s_l_prijscomponent_eenheid_ssm_ps.dv_load_dts</Item>
<Item>s_l_prijscomponent_eenheid_ssm_ps.dv_start_dts</Item>
<Item>s_l_prijscomponent_eenheid_ssm_ps.id_l</Item>
<Item>s_l_prijscomponent_eenheid_ssm_ps.organisatie</Item>
</Output>
<Shared-Hit-Blocks>1056</Shared-Hit-Blocks>
<Shared-Read-Blocks>37827</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
<Workers>
<Worker>
<Worker-Number>0</Worker-Number>
<Actual-Startup-Time>0.031</Actual-Startup-Time>
<Actual-Total-Time>111.316</Actual-Total-Time>
<Actual-Rows>1565520</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>354</Shared-Hit-Blocks>
<Shared-Read-Blocks>12692</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
<Worker>
<Worker-Number>1</Worker-Number>
<Actual-Startup-Time>0.022</Actual-Startup-Time>
<Actual-Total-Time>107.685</Actual-Total-Time>
<Actual-Rows>1541294</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>354</Shared-Hit-Blocks>
<Shared-Read-Blocks>12491</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
</Workers>
</Plan>
<Plan>
<Node-Type>Hash</Node-Type>
<Parent-Relationship>Inner</Parent-Relationship>
<Parallel-Aware>false</Parallel-Aware>
<Startup-Cost>80966.54</Startup-Cost>
<Total-Cost>80966.54</Total-Cost>
<Plan-Rows>4665854</Plan-Rows>
<Plan-Width>12</Plan-Width>
<Actual-Startup-Time>1285.519</Actual-Startup-Time>
<Actual-Total-Time>1285.519</Actual-Total-Time>
<Actual-Rows>4665854</Actual-Rows>
<Actual-Loops>3</Actual-Loops>
<Output>
<Item>l_prijscomponent_eenheid_ps.id_h_eenheid</Item>
<Item>l_prijscomponent_eenheid_ps.id_l</Item>
<Item>l_prijscomponent_eenheid_ps.id_h_prijscomponent</Item>
</Output>
<Hash-Buckets>8388608</Hash-Buckets>
<Original-Hash-Buckets>8388608</Original-Hash-Buckets>
<Hash-Batches>1</Hash-Batches>
<Original-Hash-Batches>1</Original-Hash-Batches>
<Peak-Memory-Usage>266022</Peak-Memory-Usage>
<Shared-Hit-Blocks>14759</Shared-Hit-Blocks>
<Shared-Read-Blocks>88165</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
<Workers>
<Worker>
<Worker-Number>0</Worker-Number>
<Actual-Startup-Time>1264.671</Actual-Startup-Time>
<Actual-Total-Time>1264.671</Actual-Total-Time>
<Actual-Rows>4665854</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>5629</Shared-Hit-Blocks>
<Shared-Read-Blocks>28679</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
<Worker>
<Worker-Number>1</Worker-Number>
<Actual-Startup-Time>1314.883</Actual-Startup-Time>
<Actual-Total-Time>1314.883</Actual-Total-Time>
<Actual-Rows>4665854</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>1901</Shared-Hit-Blocks>
<Shared-Read-Blocks>32407</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
</Workers>
<Plans>
<Plan>
<Node-Type>Seq Scan</Node-Type>
<Parent-Relationship>Outer</Parent-Relationship>
<Parallel-Aware>false</Parallel-Aware>
<Relation-Name>l_prijscomponent_eenheid</Relation-Name>
<Schema>datavault</Schema>
<Alias>l_prijscomponent_eenheid_ps</Alias>
<Startup-Cost>0.00</Startup-Cost>
<Total-Cost>80966.54</Total-Cost>
<Plan-Rows>4665854</Plan-Rows>
<Plan-Width>12</Plan-Width>
<Actual-Startup-Time>0.027</Actual-Startup-Time>
<Actual-Total-Time>469.057</Actual-Total-Time>
<Actual-Rows>4665854</Actual-Rows>
<Actual-Loops>3</Actual-Loops>
<Output>
<Item>l_prijscomponent_eenheid_ps.id_h_eenheid</Item>
<Item>l_prijscomponent_eenheid_ps.id_l</Item>
<Item>l_prijscomponent_eenheid_ps.id_h_prijscomponent</Item>
</Output>
<Shared-Hit-Blocks>14759</Shared-Hit-Blocks>
<Shared-Read-Blocks>88165</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
<Workers>
<Worker>
<Worker-Number>0</Worker-Number>
<Actual-Startup-Time>0.030</Actual-Startup-Time>
<Actual-Total-Time>459.264</Actual-Total-Time>
<Actual-Rows>4665854</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>5629</Shared-Hit-Blocks>
<Shared-Read-Blocks>28679</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
<Worker>
<Worker-Number>1</Worker-Number>
<Actual-Startup-Time>0.031</Actual-Startup-Time>
<Actual-Total-Time>479.999</Actual-Total-Time>
<Actual-Rows>4665854</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>1901</Shared-Hit-Blocks>
<Shared-Read-Blocks>32407</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
</Workers>
</Plan>
</Plans>
</Plan>
</Plans>
</Plan>
<Plan>
<Node-Type>Hash</Node-Type>
<Parent-Relationship>Inner</Parent-Relationship>
<Parallel-Aware>false</Parallel-Aware>
<Startup-Cost>144791.54</Startup-Cost>
<Total-Cost>144791.54</Total-Cost>
<Plan-Rows>4665854</Plan-Rows>
<Plan-Width>4</Plan-Width>
<Actual-Startup-Time>1276.841</Actual-Startup-Time>
<Actual-Total-Time>1276.841</Actual-Total-Time>
<Actual-Rows>4665854</Actual-Rows>
<Actual-Loops>3</Actual-Loops>
<Output>
<Item>prijscomponent_ps.id_h_prijscomponent</Item>
</Output>
<Hash-Buckets>8388608</Hash-Buckets>
<Original-Hash-Buckets>8388608</Original-Hash-Buckets>
<Hash-Batches>1</Hash-Batches>
<Original-Hash-Batches>1</Original-Hash-Batches>
<Peak-Memory-Usage>229570</Peak-Memory-Usage>
<Shared-Hit-Blocks>32937</Shared-Hit-Blocks>
<Shared-Read-Blocks>261462</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
<Workers>
<Worker>
<Worker-Number>0</Worker-Number>
<Actual-Startup-Time>1271.077</Actual-Startup-Time>
<Actual-Total-Time>1271.077</Actual-Total-Time>
<Actual-Rows>4665854</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>7375</Shared-Hit-Blocks>
<Shared-Read-Blocks>90758</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
<Worker>
<Worker-Number>1</Worker-Number>
<Actual-Startup-Time>1282.729</Actual-Startup-Time>
<Actual-Total-Time>1282.729</Actual-Total-Time>
<Actual-Rows>4665854</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>11393</Shared-Hit-Blocks>
<Shared-Read-Blocks>86740</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
</Workers>
<Plans>
<Plan>
<Node-Type>Seq Scan</Node-Type>
<Parent-Relationship>Outer</Parent-Relationship>
<Parallel-Aware>false</Parallel-Aware>
<Relation-Name>s_h_prijscomponent_ssm</Relation-Name>
<Schema>datavault</Schema>
<Alias>prijscomponent_ps</Alias>
<Startup-Cost>0.00</Startup-Cost>
<Total-Cost>144791.54</Total-Cost>
<Plan-Rows>4665854</Plan-Rows>
<Plan-Width>4</Plan-Width>
<Actual-Startup-Time>0.023</Actual-Startup-Time>
<Actual-Total-Time>551.102</Actual-Total-Time>
<Actual-Rows>4665854</Actual-Rows>
<Actual-Loops>3</Actual-Loops>
<Output>
<Item>prijscomponent_ps.id_h_prijscomponent</Item>
</Output>
<Shared-Hit-Blocks>32937</Shared-Hit-Blocks>
<Shared-Read-Blocks>261462</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
<Workers>
<Worker>
<Worker-Number>0</Worker-Number>
<Actual-Startup-Time>0.033</Actual-Startup-Time>
<Actual-Total-Time>550.307</Actual-Total-Time>
<Actual-Rows>4665854</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>7375</Shared-Hit-Blocks>
<Shared-Read-Blocks>90758</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
<Worker>
<Worker-Number>1</Worker-Number>
<Actual-Startup-Time>0.021</Actual-Startup-Time>
<Actual-Total-Time>551.895</Actual-Total-Time>
<Actual-Rows>4665854</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>11393</Shared-Hit-Blocks>
<Shared-Read-Blocks>86740</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
</Workers>
</Plan>
</Plans>
</Plan>
</Plans>
</Plan>
<Plan>
<Node-Type>Hash</Node-Type>
<Parent-Relationship>Inner</Parent-Relationship>
<Parallel-Aware>false</Parallel-Aware>
<Startup-Cost>438668.17</Startup-Cost>
<Total-Cost>438668.17</Total-Cost>
<Plan-Rows>1246094</Plan-Rows>
<Plan-Width>20</Plan-Width>
<Actual-Startup-Time>4125.462</Actual-Startup-Time>
<Actual-Total-Time>4125.462</Actual-Total-Time>
<Actual-Rows>1235341</Actual-Rows>
<Actual-Loops>3</Actual-Loops>
<Output>
<Item>eenheid_pe.id_s</Item>
<Item>eenheid_pe.id_h_eenheid</Item>
<Item>eenheid_ps.id_h_eenheid</Item>
<Item>l_prijscomponent_eenheid_pe.id_h_eenheid</Item>
<Item>prijscomponent_pe.bedrag</Item>
</Output>
<Hash-Buckets>2097152</Hash-Buckets>
<Original-Hash-Buckets>2097152</Original-Hash-Buckets>
<Hash-Batches>1</Hash-Batches>
<Original-Hash-Batches>1</Original-Hash-Batches>
<Peak-Memory-Usage>79507</Peak-Memory-Usage>
<Shared-Hit-Blocks>185361</Shared-Hit-Blocks>
<Shared-Read-Blocks>341367</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
<Workers>
<Worker>
<Worker-Number>0</Worker-Number>
<Actual-Startup-Time>4099.767</Actual-Startup-Time>
<Actual-Total-Time>4099.767</Actual-Total-Time>
<Actual-Rows>1235341</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>59792</Shared-Hit-Blocks>
<Shared-Read-Blocks>115784</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
<Worker>
<Worker-Number>1</Worker-Number>
<Actual-Startup-Time>4137.147</Actual-Startup-Time>
<Actual-Total-Time>4137.147</Actual-Total-Time>
<Actual-Rows>1235341</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>62603</Shared-Hit-Blocks>
<Shared-Read-Blocks>112973</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
</Workers>
<Plans>
<Plan>
<Node-Type>Hash Join</Node-Type>
<Parent-Relationship>Outer</Parent-Relationship>
<Parallel-Aware>false</Parallel-Aware>
<Join-Type>Inner</Join-Type>
<Startup-Cost>306034.95</Startup-Cost>
<Total-Cost>438668.17</Total-Cost>
<Plan-Rows>1246094</Plan-Rows>
<Plan-Width>20</Plan-Width>
<Actual-Startup-Time>2433.971</Actual-Startup-Time>
<Actual-Total-Time>3957.402</Actual-Total-Time>
<Actual-Rows>1235341</Actual-Rows>
<Actual-Loops>3</Actual-Loops>
<Output>
<Item>eenheid_pe.id_s</Item>
<Item>eenheid_pe.id_h_eenheid</Item>
<Item>eenheid_ps.id_h_eenheid</Item>
<Item>l_prijscomponent_eenheid_pe.id_h_eenheid</Item>
<Item>prijscomponent_pe.bedrag</Item>
</Output>
<Inner-Unique>false</Inner-Unique>
<Hash-Cond>(l_prijscomponent_eenheid_pe.id_h_eenheid = eenheid_pe.id_h_eenheid)</Hash-Cond>
<Shared-Hit-Blocks>185361</Shared-Hit-Blocks>
<Shared-Read-Blocks>341367</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
<Workers>
<Worker>
<Worker-Number>0</Worker-Number>
<Actual-Startup-Time>2418.029</Actual-Startup-Time>
<Actual-Total-Time>3931.108</Actual-Total-Time>
<Actual-Rows>1235341</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>59792</Shared-Hit-Blocks>
<Shared-Read-Blocks>115784</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
<Worker>
<Worker-Number>1</Worker-Number>
<Actual-Startup-Time>2437.110</Actual-Startup-Time>
<Actual-Total-Time>3969.997</Actual-Total-Time>
<Actual-Rows>1235341</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>62603</Shared-Hit-Blocks>
<Shared-Read-Blocks>112973</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
</Workers>
<Plans>
<Plan>
<Node-Type>Hash Join</Node-Type>
<Parent-Relationship>Outer</Parent-Relationship>
<Parallel-Aware>false</Parallel-Aware>
<Join-Type>Inner</Join-Type>
<Startup-Cost>298532.96</Startup-Cost>
<Total-Cost>414032.39</Total-Cost>
<Plan-Rows>1246094</Plan-Rows>
<Plan-Width>8</Plan-Width>
<Actual-Startup-Time>2392.118</Actual-Startup-Time>
<Actual-Total-Time>3686.640</Actual-Total-Time>
<Actual-Rows>1235341</Actual-Rows>
<Actual-Loops>3</Actual-Loops>
<Output>
<Item>l_prijscomponent_eenheid_pe.id_h_eenheid</Item>
<Item>prijscomponent_pe.bedrag</Item>
</Output>
<Inner-Unique>false</Inner-Unique>
<Hash-Cond>(s_l_prijscomponent_eenheid_ssm_pe.id_l = l_prijscomponent_eenheid_pe.id_l)</Hash-Cond>
<Shared-Hit-Blocks>172605</Shared-Hit-Blocks>
<Shared-Read-Blocks>341367</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
<Workers>
<Worker>
<Worker-Number>0</Worker-Number>
<Actual-Startup-Time>2376.901</Actual-Startup-Time>
<Actual-Total-Time>3660.817</Actual-Total-Time>
<Actual-Rows>1235341</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>55540</Shared-Hit-Blocks>
<Shared-Read-Blocks>115784</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
<Worker>
<Worker-Number>1</Worker-Number>
<Actual-Startup-Time>2395.413</Actual-Startup-Time>
<Actual-Total-Time>3699.921</Actual-Total-Time>
<Actual-Rows>1235341</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>58351</Shared-Hit-Blocks>
<Shared-Read-Blocks>112973</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
</Workers>
<Plans>
<Plan>
<Node-Type>Seq Scan</Node-Type>
<Parent-Relationship>Outer</Parent-Relationship>
<Parallel-Aware>false</Parallel-Aware>
<Relation-Name>s_l_prijscomponent_eenheid_ssm</Relation-Name>
<Schema>datavault</Schema>
<Alias>s_l_prijscomponent_eenheid_ssm_pe</Alias>
<Startup-Cost>0.00</Startup-Cost>
<Total-Cost>85541.54</Total-Cost>
<Plan-Rows>4665854</Plan-Rows>
<Plan-Width>8</Plan-Width>
<Actual-Startup-Time>0.007</Actual-Startup-Time>
<Actual-Total-Time>286.149</Actual-Total-Time>
<Actual-Rows>4665854</Actual-Rows>
<Actual-Loops>3</Actual-Loops>
<Output>
<Item>s_l_prijscomponent_eenheid_ssm_pe.id_s</Item>
<Item>s_l_prijscomponent_eenheid_ssm_pe.dv_end_dts</Item>
<Item>s_l_prijscomponent_eenheid_ssm_pe.dv_load_dts</Item>
<Item>s_l_prijscomponent_eenheid_ssm_pe.dv_start_dts</Item>
<Item>s_l_prijscomponent_eenheid_ssm_pe.id_l</Item>
<Item>s_l_prijscomponent_eenheid_ssm_pe.organisatie</Item>
</Output>
<Shared-Hit-Blocks>2985</Shared-Hit-Blocks>
<Shared-Read-Blocks>113664</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
<Workers>
<Worker>
<Worker-Number>0</Worker-Number>
<Actual-Startup-Time>0.009</Actual-Startup-Time>
<Actual-Total-Time>282.382</Actual-Total-Time>
<Actual-Rows>4665854</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>963</Shared-Hit-Blocks>
<Shared-Read-Blocks>37920</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
<Worker>
<Worker-Number>1</Worker-Number>
<Actual-Startup-Time>0.009</Actual-Startup-Time>
<Actual-Total-Time>280.942</Actual-Total-Time>
<Actual-Rows>4665854</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>1027</Shared-Hit-Blocks>
<Shared-Read-Blocks>37856</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
</Workers>
</Plan>
<Plan>
<Node-Type>Hash</Node-Type>
<Parent-Relationship>Inner</Parent-Relationship>
<Parallel-Aware>false</Parallel-Aware>
<Startup-Cost>282956.78</Startup-Cost>
<Total-Cost>282956.78</Total-Cost>
<Plan-Rows>1246094</Plan-Rows>
<Plan-Width>12</Plan-Width>
<Actual-Startup-Time>2388.647</Actual-Startup-Time>
<Actual-Total-Time>2388.647</Actual-Total-Time>
<Actual-Rows>1235341</Actual-Rows>
<Actual-Loops>3</Actual-Loops>
<Output>
<Item>l_prijscomponent_eenheid_pe.id_h_eenheid</Item>
<Item>l_prijscomponent_eenheid_pe.id_l</Item>
<Item>prijscomponent_pe.bedrag</Item>
</Output>
<Hash-Buckets>2097152</Hash-Buckets>
<Original-Hash-Buckets>2097152</Original-Hash-Buckets>
<Hash-Batches>1</Hash-Batches>
<Original-Hash-Batches>1</Original-Hash-Batches>
<Peak-Memory-Usage>69856</Peak-Memory-Usage>
<Shared-Hit-Blocks>169620</Shared-Hit-Blocks>
<Shared-Read-Blocks>227703</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
<Workers>
<Worker>
<Worker-Number>0</Worker-Number>
<Actual-Startup-Time>2373.346</Actual-Startup-Time>
<Actual-Total-Time>2373.346</Actual-Total-Time>
<Actual-Rows>1235341</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>54577</Shared-Hit-Blocks>
<Shared-Read-Blocks>77864</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
<Worker>
<Worker-Number>1</Worker-Number>
<Actual-Startup-Time>2391.968</Actual-Startup-Time>
<Actual-Total-Time>2391.968</Actual-Total-Time>
<Actual-Rows>1235341</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>57324</Shared-Hit-Blocks>
<Shared-Read-Blocks>75117</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
</Workers>
<Plans>
<Plan>
<Node-Type>Hash Join</Node-Type>
<Parent-Relationship>Outer</Parent-Relationship>
<Parallel-Aware>false</Parallel-Aware>
<Join-Type>Inner</Join-Type>
<Startup-Cost>172032.35</Startup-Cost>
<Total-Cost>282956.78</Total-Cost>
<Plan-Rows>1246094</Plan-Rows>
<Plan-Width>12</Plan-Width>
<Actual-Startup-Time>916.457</Actual-Startup-Time>
<Actual-Total-Time>2173.628</Actual-Total-Time>
<Actual-Rows>1235341</Actual-Rows>
<Actual-Loops>3</Actual-Loops>
<Output>
<Item>l_prijscomponent_eenheid_pe.id_h_eenheid</Item>
<Item>l_prijscomponent_eenheid_pe.id_l</Item>
<Item>prijscomponent_pe.bedrag</Item>
</Output>
<Inner-Unique>false</Inner-Unique>
<Hash-Cond>(l_prijscomponent_eenheid_pe.id_h_prijscomponent = prijscomponent_pe.id_h_prijscomponent)</Hash-Cond>
<Shared-Hit-Blocks>169620</Shared-Hit-Blocks>
<Shared-Read-Blocks>227703</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
<Workers>
<Worker>
<Worker-Number>0</Worker-Number>
<Actual-Startup-Time>916.357</Actual-Startup-Time>
<Actual-Total-Time>2163.106</Actual-Total-Time>
<Actual-Rows>1235341</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>54577</Shared-Hit-Blocks>
<Shared-Read-Blocks>77864</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
<Worker>
<Worker-Number>1</Worker-Number>
<Actual-Startup-Time>916.148</Actual-Startup-Time>
<Actual-Total-Time>2171.436</Actual-Total-Time>
<Actual-Rows>1235341</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>57324</Shared-Hit-Blocks>
<Shared-Read-Blocks>75117</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
</Workers>
<Plans>
<Plan>
<Node-Type>Seq Scan</Node-Type>
<Parent-Relationship>Outer</Parent-Relationship>
<Parallel-Aware>false</Parallel-Aware>
<Relation-Name>l_prijscomponent_eenheid</Relation-Name>
<Schema>datavault</Schema>
<Alias>l_prijscomponent_eenheid_pe</Alias>
<Startup-Cost>0.00</Startup-Cost>
<Total-Cost>80966.54</Total-Cost>
<Plan-Rows>4665854</Plan-Rows>
<Plan-Width>12</Plan-Width>
<Actual-Startup-Time>0.013</Actual-Startup-Time>
<Actual-Total-Time>267.480</Actual-Total-Time>
<Actual-Rows>4665854</Actual-Rows>
<Actual-Loops>3</Actual-Loops>
<Output>
<Item>l_prijscomponent_eenheid_pe.id_l</Item>
<Item>l_prijscomponent_eenheid_pe.id_h_eenheid</Item>
<Item>l_prijscomponent_eenheid_pe.id_h_prijscomponent</Item>
<Item>l_prijscomponent_eenheid_pe.load_dts</Item>
<Item>l_prijscomponent_eenheid_pe.source_system_id</Item>
</Output>
<Shared-Hit-Blocks>4758</Shared-Hit-Blocks>
<Shared-Read-Blocks>98166</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
<Workers>
<Worker>
<Worker-Number>0</Worker-Number>
<Actual-Startup-Time>0.024</Actual-Startup-Time>
<Actual-Total-Time>267.117</Actual-Total-Time>
<Actual-Rows>4665854</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>1544</Shared-Hit-Blocks>
<Shared-Read-Blocks>32764</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
<Worker>
<Worker-Number>1</Worker-Number>
<Actual-Startup-Time>0.007</Actual-Startup-Time>
<Actual-Total-Time>267.591</Actual-Total-Time>
<Actual-Rows>4665854</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>1609</Shared-Hit-Blocks>
<Shared-Read-Blocks>32699</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
</Workers>
</Plan>
<Plan>
<Node-Type>Hash</Node-Type>
<Parent-Relationship>Inner</Parent-Relationship>
<Parallel-Aware>false</Parallel-Aware>
<Startup-Cost>156456.17</Startup-Cost>
<Total-Cost>156456.17</Total-Cost>
<Plan-Rows>1246094</Plan-Rows>
<Plan-Width>8</Plan-Width>
<Actual-Startup-Time>912.960</Actual-Startup-Time>
<Actual-Total-Time>912.960</Actual-Total-Time>
<Actual-Rows>1235341</Actual-Rows>
<Actual-Loops>3</Actual-Loops>
<Output>
<Item>prijscomponent_pe.bedrag</Item>
<Item>prijscomponent_pe.id_h_prijscomponent</Item>
</Output>
<Hash-Buckets>2097152</Hash-Buckets>
<Original-Hash-Buckets>2097152</Original-Hash-Buckets>
<Hash-Batches>1</Hash-Batches>
<Original-Hash-Batches>1</Original-Hash-Batches>
<Peak-Memory-Usage>66252</Peak-Memory-Usage>
<Shared-Hit-Blocks>164862</Shared-Hit-Blocks>
<Shared-Read-Blocks>129537</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
<Workers>
<Worker>
<Worker-Number>0</Worker-Number>
<Actual-Startup-Time>912.879</Actual-Startup-Time>
<Actual-Total-Time>912.879</Actual-Total-Time>
<Actual-Rows>1235341</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>53033</Shared-Hit-Blocks>
<Shared-Read-Blocks>45100</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
<Worker>
<Worker-Number>1</Worker-Number>
<Actual-Startup-Time>912.710</Actual-Startup-Time>
<Actual-Total-Time>912.710</Actual-Total-Time>
<Actual-Rows>1235341</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>55715</Shared-Hit-Blocks>
<Shared-Read-Blocks>42418</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
</Workers>
<Plans>
<Plan>
<Node-Type>Seq Scan</Node-Type>
<Parent-Relationship>Outer</Parent-Relationship>
<Parallel-Aware>false</Parallel-Aware>
<Relation-Name>s_h_prijscomponent_ssm</Relation-Name>
<Schema>datavault</Schema>
<Alias>prijscomponent_pe</Alias>
<Startup-Cost>0.00</Startup-Cost>
<Total-Cost>156456.17</Total-Cost>
<Plan-Rows>1246094</Plan-Rows>
<Plan-Width>8</Plan-Width>
<Actual-Startup-Time>0.009</Actual-Startup-Time>
<Actual-Total-Time>709.610</Actual-Total-Time>
<Actual-Rows>1235341</Actual-Rows>
<Actual-Loops>3</Actual-Loops>
<Output>
<Item>prijscomponent_pe.bedrag</Item>
<Item>prijscomponent_pe.id_h_prijscomponent</Item>
</Output>
<Filter>(prijscomponent_pe.soort = 'NET'::text)</Filter>
<Rows-Removed-by-Filter>3430513</Rows-Removed-by-Filter>
<Shared-Hit-Blocks>164862</Shared-Hit-Blocks>
<Shared-Read-Blocks>129537</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
<Workers>
<Worker>
<Worker-Number>0</Worker-Number>
<Actual-Startup-Time>0.006</Actual-Startup-Time>
<Actual-Total-Time>711.333</Actual-Total-Time>
<Actual-Rows>1235341</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>53033</Shared-Hit-Blocks>
<Shared-Read-Blocks>45100</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
<Worker>
<Worker-Number>1</Worker-Number>
<Actual-Startup-Time>0.009</Actual-Startup-Time>
<Actual-Total-Time>709.141</Actual-Total-Time>
<Actual-Rows>1235341</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>55715</Shared-Hit-Blocks>
<Shared-Read-Blocks>42418</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
</Workers>
</Plan>
</Plans>
</Plan>
</Plans>
</Plan>
</Plans>
</Plan>
</Plans>
</Plan>
<Plan>
<Node-Type>Hash</Node-Type>
<Parent-Relationship>Inner</Parent-Relationship>
<Parallel-Aware>false</Parallel-Aware>
<Startup-Cost>6810.50</Startup-Cost>
<Total-Cost>6810.50</Total-Cost>
<Plan-Rows>55319</Plan-Rows>
<Plan-Width>12</Plan-Width>
<Actual-Startup-Time>41.731</Actual-Startup-Time>
<Actual-Total-Time>41.731</Actual-Total-Time>
<Actual-Rows>55319</Actual-Rows>
<Actual-Loops>3</Actual-Loops>
<Output>
<Item>eenheid_pe.id_s</Item>
<Item>eenheid_pe.id_h_eenheid</Item>
<Item>eenheid_ps.id_h_eenheid</Item>
</Output>
<Hash-Buckets>65536</Hash-Buckets>
<Original-Hash-Buckets>65536</Original-Hash-Buckets>
<Hash-Batches>1</Hash-Batches>
<Original-Hash-Batches>1</Original-Hash-Batches>
<Peak-Memory-Usage>2889</Peak-Memory-Usage>
<Shared-Hit-Blocks>12756</Shared-Hit-Blocks>
<Shared-Read-Blocks>0</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
<Workers>
<Worker>
<Worker-Number>0</Worker-Number>
<Actual-Startup-Time>41.015</Actual-Startup-Time>
<Actual-Total-Time>41.015</Actual-Total-Time>
<Actual-Rows>55319</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>4252</Shared-Hit-Blocks>
<Shared-Read-Blocks>0</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
<Worker>
<Worker-Number>1</Worker-Number>
<Actual-Startup-Time>41.559</Actual-Startup-Time>
<Actual-Total-Time>41.559</Actual-Total-Time>
<Actual-Rows>55319</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>4252</Shared-Hit-Blocks>
<Shared-Read-Blocks>0</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
</Workers>
<Plans>
<Plan>
<Node-Type>Hash Join</Node-Type>
<Parent-Relationship>Outer</Parent-Relationship>
<Parallel-Aware>false</Parallel-Aware>
<Join-Type>Inner</Join-Type>
<Startup-Cost>3370.68</Startup-Cost>
<Total-Cost>6810.50</Total-Cost>
<Plan-Rows>55319</Plan-Rows>
<Plan-Width>12</Plan-Width>
<Actual-Startup-Time>14.372</Actual-Startup-Time>
<Actual-Total-Time>33.541</Actual-Total-Time>
<Actual-Rows>55319</Actual-Rows>
<Actual-Loops>3</Actual-Loops>
<Output>
<Item>eenheid_pe.id_s</Item>
<Item>eenheid_pe.id_h_eenheid</Item>
<Item>eenheid_ps.id_h_eenheid</Item>
</Output>
<Inner-Unique>false</Inner-Unique>
<Hash-Cond>(eenheid_pe.id_h_eenheid = eenheid_ps.id_h_eenheid)</Hash-Cond>
<Shared-Hit-Blocks>12756</Shared-Hit-Blocks>
<Shared-Read-Blocks>0</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
<Workers>
<Worker>
<Worker-Number>0</Worker-Number>
<Actual-Startup-Time>14.370</Actual-Startup-Time>
<Actual-Total-Time>33.061</Actual-Total-Time>
<Actual-Rows>55319</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>4252</Shared-Hit-Blocks>
<Shared-Read-Blocks>0</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
<Worker>
<Worker-Number>1</Worker-Number>
<Actual-Startup-Time>14.498</Actual-Startup-Time>
<Actual-Total-Time>33.482</Actual-Total-Time>
<Actual-Rows>55319</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>4252</Shared-Hit-Blocks>
<Shared-Read-Blocks>0</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
</Workers>
<Plans>
<Plan>
<Node-Type>Seq Scan</Node-Type>
<Parent-Relationship>Outer</Parent-Relationship>
<Parallel-Aware>false</Parallel-Aware>
<Relation-Name>s_h_eenheid_ssm</Relation-Name>
<Schema>datavault</Schema>
<Alias>eenheid_pe</Alias>
<Startup-Cost>0.00</Startup-Cost>
<Total-Cost>2679.19</Total-Cost>
<Plan-Rows>55319</Plan-Rows>
<Plan-Width>8</Plan-Width>
<Actual-Startup-Time>0.016</Actual-Startup-Time>
<Actual-Total-Time>4.434</Actual-Total-Time>
<Actual-Rows>55319</Actual-Rows>
<Actual-Loops>3</Actual-Loops>
<Output>
<Item>eenheid_pe.id_s</Item>
<Item>eenheid_pe.dv_end_dts</Item>
<Item>eenheid_pe.dv_load_dts</Item>
<Item>eenheid_pe.dv_start_dts</Item>
<Item>eenheid_pe.id_h_eenheid</Item>
<Item>eenheid_pe.auditinfo</Item>
<Item>eenheid_pe.beginbouwdatum</Item>
<Item>eenheid_pe.beschermdstadsgezicht</Item>
<Item>eenheid_pe.bestemming</Item>
<Item>eenheid_pe.bewoonbarevertrekkentotaalinhoud</Item>
<Item>eenheid_pe.bezitdetailsoort</Item>
<Item>eenheid_pe.bezitsoort</Item>
<Item>eenheid_pe.bouwjaar</Item>
<Item>eenheid_pe.bouwnummer</Item>
<Item>eenheid_pe.bronsysteem</Item>
<Item>eenheid_pe.brutohuur</Item>
<Item>eenheid_pe.businesskey</Item>
<Item>eenheid_pe.code</Item>
<Item>eenheid_pe.detailsoort</Item>
<Item>eenheid_pe.detailstatus</Item>
<Item>eenheid_pe.doelgroep</Item>
<Item>eenheid_pe.etage</Item>
<Item>eenheid_pe.extraelementen</Item>
<Item>eenheid_pe.huurklasse</Item>
<Item>eenheid_pe.identificatie</Item>
<Item>eenheid_pe.inbezitbegindatum</Item>
<Item>eenheid_pe.inbeziteinddatum</Item>
<Item>eenheid_pe.inexploitatiedatum</Item>
<Item>eenheid_pe.inexploitatiereden</Item>
<Item>eenheid_pe.kadastraalnummer</Item>
<Item>eenheid_pe.kamersaantal</Item>
<Item>eenheid_pe.kwaliteitsniveau</Item>
<Item>eenheid_pe.maatschappelijklabel</Item>
<Item>eenheid_pe.marktlabel</Item>
<Item>eenheid_pe.naam</Item>
<Item>eenheid_pe.nettohuur</Item>
<Item>eenheid_pe.omschrijving</Item>
<Item>eenheid_pe.onderhoudslabel</Item>
<Item>eenheid_pe.opleverdatum</Item>
<Item>eenheid_pe.organisatie</Item>
<Item>eenheid_pe.overigevertrekkentotaaloppervlakte</Item>
<Item>eenheid_pe.pandcode</Item>
<Item>eenheid_pe.rayon</Item>
<Item>eenheid_pe.sat_attributes_concat</Item>
<Item>eenheid_pe.situering</Item>
<Item>eenheid_pe.soort</Item>
<Item>eenheid_pe.status</Item>
<Item>eenheid_pe.streefhuur</Item>
<Item>eenheid_pe.subsidiabelehuur</Item>
<Item>eenheid_pe.totaleoppervlakte</Item>
<Item>eenheid_pe.uitexploitatiedatum</Item>
<Item>eenheid_pe.uitexploitatiereden</Item>
<Item>eenheid_pe.verkoop</Item>
<Item>eenheid_pe.vertrekkenaantal</Item>
<Item>eenheid_pe.verwarmdevertrekkenaantal</Item>
<Item>eenheid_pe.volgnummer</Item>
<Item>eenheid_pe.vraagprijs</Item>
<Item>eenheid_pe.woonvertrekinhoud</Item>
<Item>eenheid_pe.woonvertrekkentotaaloppervlakte</Item>
<Item>eenheid_pe.woonvorm</Item>
<Item>eenheid_pe.zelfstandig</Item>
<Item>eenheid_pe.zorgfaciliteitomschrijving</Item>
</Output>
<Shared-Hit-Blocks>6378</Shared-Hit-Blocks>
<Shared-Read-Blocks>0</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
<Workers>
<Worker>
<Worker-Number>0</Worker-Number>
<Actual-Startup-Time>0.021</Actual-Startup-Time>
<Actual-Total-Time>4.303</Actual-Total-Time>
<Actual-Rows>55319</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>2126</Shared-Hit-Blocks>
<Shared-Read-Blocks>0</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
<Worker>
<Worker-Number>1</Worker-Number>
<Actual-Startup-Time>0.020</Actual-Startup-Time>
<Actual-Total-Time>4.328</Actual-Total-Time>
<Actual-Rows>55319</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>2126</Shared-Hit-Blocks>
<Shared-Read-Blocks>0</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
</Workers>
</Plan>
<Plan>
<Node-Type>Hash</Node-Type>
<Parent-Relationship>Inner</Parent-Relationship>
<Parallel-Aware>false</Parallel-Aware>
<Startup-Cost>2679.19</Startup-Cost>
<Total-Cost>2679.19</Total-Cost>
<Plan-Rows>55319</Plan-Rows>
<Plan-Width>4</Plan-Width>
<Actual-Startup-Time>14.236</Actual-Startup-Time>
<Actual-Total-Time>14.236</Actual-Total-Time>
<Actual-Rows>55319</Actual-Rows>
<Actual-Loops>3</Actual-Loops>
<Output>
<Item>eenheid_ps.id_h_eenheid</Item>
</Output>
<Hash-Buckets>65536</Hash-Buckets>
<Original-Hash-Buckets>65536</Original-Hash-Buckets>
<Hash-Batches>1</Hash-Batches>
<Original-Hash-Batches>1</Original-Hash-Batches>
<Peak-Memory-Usage>2457</Peak-Memory-Usage>
<Shared-Hit-Blocks>6378</Shared-Hit-Blocks>
<Shared-Read-Blocks>0</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
<Workers>
<Worker>
<Worker-Number>0</Worker-Number>
<Actual-Startup-Time>14.237</Actual-Startup-Time>
<Actual-Total-Time>14.237</Actual-Total-Time>
<Actual-Rows>55319</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>2126</Shared-Hit-Blocks>
<Shared-Read-Blocks>0</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
<Worker>
<Worker-Number>1</Worker-Number>
<Actual-Startup-Time>14.364</Actual-Startup-Time>
<Actual-Total-Time>14.364</Actual-Total-Time>
<Actual-Rows>55319</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>2126</Shared-Hit-Blocks>
<Shared-Read-Blocks>0</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
</Workers>
<Plans>
<Plan>
<Node-Type>Seq Scan</Node-Type>
<Parent-Relationship>Outer</Parent-Relationship>
<Parallel-Aware>false</Parallel-Aware>
<Relation-Name>s_h_eenheid_ssm</Relation-Name>
<Schema>datavault</Schema>
<Alias>eenheid_ps</Alias>
<Startup-Cost>0.00</Startup-Cost>
<Total-Cost>2679.19</Total-Cost>
<Plan-Rows>55319</Plan-Rows>
<Plan-Width>4</Plan-Width>
<Actual-Startup-Time>0.003</Actual-Startup-Time>
<Actual-Total-Time>7.372</Actual-Total-Time>
<Actual-Rows>55319</Actual-Rows>
<Actual-Loops>3</Actual-Loops>
<Output>
<Item>eenheid_ps.id_h_eenheid</Item>
</Output>
<Shared-Hit-Blocks>6378</Shared-Hit-Blocks>
<Shared-Read-Blocks>0</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
<Workers>
<Worker>
<Worker-Number>0</Worker-Number>
<Actual-Startup-Time>0.002</Actual-Startup-Time>
<Actual-Total-Time>7.342</Actual-Total-Time>
<Actual-Rows>55319</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>2126</Shared-Hit-Blocks>
<Shared-Read-Blocks>0</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
<Worker>
<Worker-Number>1</Worker-Number>
<Actual-Startup-Time>0.003</Actual-Startup-Time>
<Actual-Total-Time>7.435</Actual-Total-Time>
<Actual-Rows>55319</Actual-Rows>
<Actual-Loops>1</Actual-Loops>
<Shared-Hit-Blocks>2126</Shared-Hit-Blocks>
<Shared-Read-Blocks>0</Shared-Read-Blocks>
<Shared-Dirtied-Blocks>0</Shared-Dirtied-Blocks>
<Shared-Written-Blocks>0</Shared-Written-Blocks>
<Local-Hit-Blocks>0</Local-Hit-Blocks>
<Local-Read-Blocks>0</Local-Read-Blocks>
<Local-Dirtied-Blocks>0</Local-Dirtied-Blocks>
<Local-Written-Blocks>0</Local-Written-Blocks>
<Temp-Read-Blocks>0</Temp-Read-Blocks>
<Temp-Written-Blocks>0</Temp-Written-Blocks>
</Worker>
</Workers>
</Plan>
</Plans>
</Plan>
</Plans>
</Plan>
</Plans>
</Plan>
</Plans>
</Plan>
</Plans>
</Plan>
</Plans>
</Plan>
</Plans>
</Plan>
</Plans>
</Plan>
</Plans>
</Plan>
</Plans>
</Plan>
<Planning-Time>3.100</Planning-Time>
<Triggers>
</Triggers>
<Execution-Time>18480.092</Execution-Time>
</Query>
</explain>
Issue with explain plan:
Related content
PostgreSQL performance tests
PostgreSQL performance tests
More like this
zmspc0 test failure
zmspc0 test failure
More like this
Unibone inside the PDP-11/44
Unibone inside the PDP-11/44
More like this
HP 16702A Z80 pod project
HP 16702A Z80 pod project
More like this
The Generic Query framework - QCriteria
The Generic Query framework - QCriteria
More like this
The HP 1607A Logic Analyzer
The HP 1607A Logic Analyzer
More like this