<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>
| 