...
| Expand |
|---|
| Code Block |
|---|
<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 planner display 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.
...
which looks like this in the plan visualiser (click to enlarge):
Image Removed
Image Added
With the execution plan:
...