[ { "Plan": { "Node Type": "Merge Join", "Parallel Aware": false, "Async Capable": false, "Join Type": "Full", "Startup Cost": 3220156.72, "Total Cost": 3275667.50, "Plan Rows": 3161900, "Plan Width": 145, "Actual Startup Time": 71261.216, "Actual Total Time": 71417.537, "Actual Rows": 27545, "Actual Loops": 1, "Output": ["lu_holding_buckets.simulationrunid", "lu_holding_buckets.componentid", "(lu_holding_buckets.bucket_start AT TIME ZONE 'UTC'::text)", "(((lu_holding_buckets.bucket_start + '01:00:00'::interval)) AT TIME ZONE 'UTC'::text)", "(sum(CASE WHEN ((lu_holding_buckets.finish >= lu_holding_buckets.bucket_start) AND (lu_holding_buckets.finish < ((lu_holding_buckets.bucket_start + '01:00:00'::interval)))) THEN 1 ELSE 0 END))", "(sum(CASE WHEN (lu_holding_buckets.finish >= ((lu_holding_buckets.bucket_start + '01:00:00'::interval))) THEN 1 ELSE 0 END))", "(sum(CASE WHEN ((lu_holding_buckets.finish >= lu_holding_buckets.bucket_start) AND (lu_holding_buckets.finish < ((lu_holding_buckets.bucket_start + '01:00:00'::interval))) AND (lu_holding_buckets.finish > lu_holding_buckets.late_ref_time)) THEN 1 ELSE 0 END))", "(sum(CASE WHEN ((lu_holding_buckets.finish >= ((lu_holding_buckets.bucket_start + '01:00:00'::interval))) AND (lu_holding_buckets.late_ref_time < ((lu_holding_buckets.bucket_start + '01:00:00'::interval))) AND (lu_holding_buckets.finish > lu_holding_buckets.late_ref_time)) THEN 1 ELSE 0 END))", "(EXTRACT(epoch FROM sum((CASE WHEN (work_order_buckets.finish < ((work_order_buckets.bucket_start + '01:00:00'::interval))) THEN work_order_buckets.finish ELSE ((work_order_buckets.bucket_start + '01:00:00'::interval)) END - CASE WHEN (work_order_buckets.start > work_order_buckets.bucket_start) THEN work_order_buckets.start ELSE work_order_buckets.bucket_start END))))", "(count(DISTINCT work_order_buckets.workerid))", "(count(DISTINCT work_order_buckets.workorderid))", "(sum(CASE WHEN (work_order_buckets.finish >= ((work_order_buckets.bucket_start + '01:00:00'::interval))) THEN 1 ELSE 0 END))", "(sum(CASE WHEN ((work_order_buckets.finish >= ((work_order_buckets.bucket_start + '01:00:00'::interval))) AND (work_order_buckets.finish > work_order_buckets.late_ref_time)) THEN 1 ELSE 0 END))", "(max(ac_buckets.max_elements))", "(COALESCE((lim_soft.value)::integer))", "(COALESCE((lim_hard.value)::integer))", "(CASE WHEN (((max(ac_buckets.max_elements)))::double precision > COALESCE(((lim_soft.value)::integer)::double precision, 'Infinity'::double precision)) THEN 1 ELSE 0 END)"], "Inner Unique": false, "Merge Cond": "((ac_buckets.simulationrunid = lu_holding_buckets.simulationrunid) AND ((ac_buckets.componentid)::text = (lu_holding_buckets.componentid)::text) AND (ac_buckets.bucket_start = lu_holding_buckets.bucket_start) AND (((ac_buckets.bucket_start + '01:00:00'::interval)) = ((lu_holding_buckets.bucket_start + '01:00:00'::interval))))", "Shared Hit Blocks": 161902, "Shared Read Blocks": 1508, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 1933, "Temp Written Blocks": 1934, "Plans": [ { "Node Type": "Index Scan", "Parent Relationship": "InitPlan", "Subplan Name": "CTE filtered_elements", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "element_pkey", "Relation Name": "element", "Schema": "public", "Alias": "element", "Startup Cost": 0.42, "Total Cost": 2.64, "Plan Rows": 1, "Plan Width": 61, "Actual Startup Time": 0.031, "Actual Total Time": 1.890, "Actual Rows": 8088, "Actual Loops": 1, "Output": ["element.simulationrunid", "element.elementid", "element.elementcreatedatcomponentid"], "Index Cond": "(element.simulationrunid = 325)", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 3101, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Sort", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 3203053.21, "Total Cost": 3210957.96, "Plan Rows": 3161900, "Plan Width": 49, "Actual Startup Time": 338.573, "Actual Total Time": 341.188, "Actual Rows": 27545, "Actual Loops": 1, "Output": ["(max(ac_buckets.max_elements))", "ac_buckets.simulationrunid", "ac_buckets.componentid", "ac_buckets.bucket_start", "((ac_buckets.bucket_start + '01:00:00'::interval))", "(COALESCE((lim_soft.value)::integer))", "(CASE WHEN (((max(ac_buckets.max_elements)))::double precision > COALESCE(((lim_soft.value)::integer)::double precision, 'Infinity'::double precision)) THEN 1 ELSE 0 END)", "(COALESCE((lim_hard.value)::integer))"], "Sort Key": ["ac_buckets.simulationrunid", "ac_buckets.componentid", "ac_buckets.bucket_start", "((ac_buckets.bucket_start + '01:00:00'::interval))"], "Sort Method": "quicksort", "Sort Space Used": 2705, "Sort Space Type": "Memory", "Shared Hit Blocks": 14382, "Shared Read Blocks": 1507, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Hash Join", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Join Type": "Left", "Startup Cost": 2168378.93, "Total Cost": 2798388.89, "Plan Rows": 3161900, "Plan Width": 49, "Actual Startup Time": 283.906, "Actual Total Time": 302.431, "Actual Rows": 27545, "Actual Loops": 1, "Output": ["(max(ac_buckets.max_elements))", "ac_buckets.simulationrunid", "ac_buckets.componentid", "ac_buckets.bucket_start", "((ac_buckets.bucket_start + '01:00:00'::interval))", "COALESCE((lim_soft.value)::integer)", "CASE WHEN (((max(ac_buckets.max_elements)))::double precision > COALESCE(((lim_soft.value)::integer)::double precision, 'Infinity'::double precision)) THEN 1 ELSE 0 END", "(COALESCE((lim_hard.value)::integer))"], "Inner Unique": true, "Hash Cond": "((ac_buckets.simulationrunid = lim_soft.sim_run_id) AND ((ac_buckets.componentid)::text = (lim_soft.component)::text))", "Shared Hit Blocks": 14382, "Shared Read Blocks": 1507, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Hash Join", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Join Type": "Left", "Startup Cost": 2153520.97, "Total Cost": 2751120.82, "Plan Rows": 3161900, "Plan Width": 41, "Actual Startup Time": 281.696, "Actual Total Time": 291.149, "Actual Rows": 27545, "Actual Loops": 1, "Output": ["(max(ac_buckets.max_elements))", "ac_buckets.simulationrunid", "ac_buckets.componentid", "ac_buckets.bucket_start", "((ac_buckets.bucket_start + '01:00:00'::interval))", "COALESCE((lim_hard.value)::integer)"], "Inner Unique": true, "Hash Cond": "((ac_buckets.simulationrunid = lim_hard.sim_run_id) AND ((ac_buckets.componentid)::text = (lim_hard.component)::text))", "Shared Hit Blocks": 12402, "Shared Read Blocks": 1507, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Aggregate", "Strategy": "Hashed", "Partial Mode": "Simple", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 2137030.29, "Total Cost": 2670600.92, "Plan Rows": 3161900, "Plan Width": 37, "Actual Startup Time": 270.095, "Actual Total Time": 275.885, "Actual Rows": 27545, "Actual Loops": 1, "Output": ["ac_buckets.simulationrunid", "ac_buckets.componentid", "ac_buckets.bucket_start", "((ac_buckets.bucket_start + '01:00:00'::interval))", "max(ac_buckets.max_elements)"], "Group Key": ["ac_buckets.simulationrunid", "ac_buckets.componentid", "ac_buckets.bucket_start", "(ac_buckets.bucket_start + '01:00:00'::interval)"], "Planned Partitions": 16, "HashAgg Batches": 1, "Peak Memory Usage": 9233, "Disk Usage": 0, "Shared Hit Blocks": 9062, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Subquery Scan", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Alias": "ac_buckets", "Startup Cost": 13.52, "Total Cost": 565961.23, "Plan Rows": 31619000, "Plan Width": 37, "Actual Startup Time": 0.708, "Actual Total Time": 217.913, "Actual Rows": 272237, "Actual Loops": 1, "Output": ["ac_buckets.simulationrunid", "ac_buckets.componentid", "ac_buckets.bucket_start", "(ac_buckets.bucket_start + '01:00:00'::interval)", "ac_buckets.max_elements"], "Shared Hit Blocks": 9062, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "ProjectSet", "Parent Relationship": "Subquery", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 13.52, "Total Cost": 170723.73, "Plan Rows": 31619000, "Plan Width": 69, "Actual Startup Time": 0.707, "Actual Total Time": 196.724, "Actual Rows": 272237, "Actual Loops": 1, "Output": ["_hyper_8_2343_chunk.simulationrunid", "_hyper_8_2343_chunk.componentid", "NULL::character varying", "NULL::timestamp with time zone", "generate_series(time_bucket('01:00:00'::interval, _hyper_8_2343_chunk.start), time_bucket('01:00:00'::interval, _hyper_8_2343_chunk.finish), '01:00:00'::interval)", "(sum(\"*VALUES*\".column2) OVER (?))"], "Shared Hit Blocks": 9062, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Incremental Sort", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 13.52, "Total Cost": 11917.30, "Plan Rows": 31619, "Plan Width": 90, "Actual Startup Time": 0.702, "Actual Total Time": 169.971, "Actual Rows": 32352, "Actual Loops": 1, "Output": ["_hyper_8_2343_chunk.simulationrunid", "_hyper_8_2343_chunk.componentid", "_hyper_8_2343_chunk.elementid", "_hyper_8_2343_chunk.start", "_hyper_8_2343_chunk.finish", "\"*VALUES*\".column1", "NULL::integer", "(sum(\"*VALUES*\".column2) OVER (?))"], "Sort Key": ["_hyper_8_2343_chunk.componentid", "_hyper_8_2343_chunk.elementid", "\"*VALUES*\".column1"], "Presorted Key": ["_hyper_8_2343_chunk.componentid"], "Full-sort Groups": { "Group Count": 127, "Sort Methods Used": ["quicksort"], "Sort Space Memory": { "Average Sort Space Used": 28, "Peak Sort Space Used": 28 } }, "Pre-sorted Groups": { "Group Count": 96, "Sort Methods Used": ["quicksort"], "Sort Space Memory": { "Average Sort Space Used": 58, "Peak Sort Space Used": 1109 } }, "Shared Hit Blocks": 9062, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "WindowAgg", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 10.02, "Total Cost": 10939.15, "Plan Rows": 31619, "Plan Width": 90, "Actual Startup Time": 0.456, "Actual Total Time": 115.534, "Actual Rows": 32352, "Actual Loops": 1, "Output": ["_hyper_8_2343_chunk.simulationrunid", "_hyper_8_2343_chunk.componentid", "_hyper_8_2343_chunk.elementid", "_hyper_8_2343_chunk.start", "_hyper_8_2343_chunk.finish", "\"*VALUES*\".column1", "NULL::integer", "sum(\"*VALUES*\".column2) OVER (?)"], "Shared Hit Blocks": 9062, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Incremental Sort", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 10.02, "Total Cost": 10385.82, "Plan Rows": 31619, "Plan Width": 82, "Actual Startup Time": 0.448, "Actual Total Time": 102.621, "Actual Rows": 32352, "Actual Loops": 1, "Output": ["_hyper_8_2343_chunk.componentid", "\"*VALUES*\".column1", "_hyper_8_2343_chunk.simulationrunid", "_hyper_8_2343_chunk.elementid", "_hyper_8_2343_chunk.start", "_hyper_8_2343_chunk.finish", "\"*VALUES*\".column2"], "Sort Key": ["_hyper_8_2343_chunk.componentid", "\"*VALUES*\".column1"], "Presorted Key": ["_hyper_8_2343_chunk.componentid"], "Full-sort Groups": { "Group Count": 127, "Sort Methods Used": ["quicksort"], "Sort Space Memory": { "Average Sort Space Used": 28, "Peak Sort Space Used": 28 } }, "Pre-sorted Groups": { "Group Count": 96, "Sort Methods Used": ["quicksort"], "Sort Space Memory": { "Average Sort Space Used": 59, "Peak Sort Space Used": 1172 } }, "Shared Hit Blocks": 9062, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Nested Loop", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Join Type": "Inner", "Startup Cost": 6.99, "Total Cost": 9407.67, "Plan Rows": 31619, "Plan Width": 82, "Actual Startup Time": 0.278, "Actual Total Time": 90.601, "Actual Rows": 32352, "Actual Loops": 1, "Output": ["_hyper_8_2343_chunk.componentid", "\"*VALUES*\".column1", "_hyper_8_2343_chunk.simulationrunid", "_hyper_8_2343_chunk.elementid", "_hyper_8_2343_chunk.start", "_hyper_8_2343_chunk.finish", "\"*VALUES*\".column2"], "Inner Unique": false, "Shared Hit Blocks": 9062, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Incremental Sort", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 6.99, "Total Cost": 7826.72, "Plan Rows": 31619, "Plan Width": 99, "Actual Startup Time": 0.273, "Actual Total Time": 68.121, "Actual Rows": 32352, "Actual Loops": 1, "Output": ["_hyper_8_2343_chunk.simulationrunid", "_hyper_8_2343_chunk.componentid", "_hyper_8_2343_chunk.discriminator", "_hyper_8_2343_chunk.elementid", "_hyper_8_2343_chunk.workorderid", "_hyper_8_2343_chunk.start", "_hyper_8_2343_chunk.finish"], "Sort Key": ["_hyper_8_2343_chunk.componentid", "_hyper_8_2343_chunk.elementid", "_hyper_8_2343_chunk.workorderid", "_hyper_8_2343_chunk.start", "_hyper_8_2343_chunk.finish"], "Presorted Key": ["_hyper_8_2343_chunk.componentid"], "Full-sort Groups": { "Group Count": 127, "Sort Methods Used": ["quicksort"], "Sort Space Memory": { "Average Sort Space Used": 28, "Peak Sort Space Used": 28 } }, "Pre-sorted Groups": { "Group Count": 96, "Sort Methods Used": ["quicksort"], "Sort Space Memory": { "Average Sort Space Used": 59, "Peak Sort Space Used": 1172 } }, "Shared Hit Blocks": 9062, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Merge Append", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 4.74, "Total Cost": 6848.57, "Plan Rows": 31619, "Plan Width": 98, "Actual Startup Time": 0.216, "Actual Total Time": 15.208, "Actual Rows": 32352, "Actual Loops": 1, "Sort Key": ["_hyper_8_2343_chunk.componentid"], "Shared Hit Blocks": 9062, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Subplans Removed": 0, "Plans": [ { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2343_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2343_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2343_chunk", "Startup Cost": 0.29, "Total Cost": 438.10, "Plan Rows": 2146, "Plan Width": 93, "Actual Startup Time": 0.019, "Actual Total Time": 0.841, "Actual Rows": 2179, "Actual Loops": 1, "Output": ["_hyper_8_2343_chunk.simulationrunid", "_hyper_8_2343_chunk.componentid", "_hyper_8_2343_chunk.discriminator", "_hyper_8_2343_chunk.elementid", "_hyper_8_2343_chunk.workorderid", "_hyper_8_2343_chunk.start", "_hyper_8_2343_chunk.finish"], "Index Cond": "((_hyper_8_2343_chunk.simulationrunid = 325) AND ((_hyper_8_2343_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 628, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2344_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2344_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2344_chunk", "Startup Cost": 0.29, "Total Cost": 462.90, "Plan Rows": 2188, "Plan Width": 101, "Actual Startup Time": 0.014, "Actual Total Time": 0.927, "Actual Rows": 2179, "Actual Loops": 1, "Output": ["_hyper_8_2344_chunk.simulationrunid", "_hyper_8_2344_chunk.componentid", "_hyper_8_2344_chunk.discriminator", "_hyper_8_2344_chunk.elementid", "_hyper_8_2344_chunk.workorderid", "_hyper_8_2344_chunk.start", "_hyper_8_2344_chunk.finish"], "Index Cond": "((_hyper_8_2344_chunk.simulationrunid = 325) AND ((_hyper_8_2344_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 791, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2345_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2345_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2345_chunk", "Startup Cost": 0.13, "Total Cost": 2.35, "Plan Rows": 1, "Plan Width": 120, "Actual Startup Time": 0.006, "Actual Total Time": 0.007, "Actual Rows": 0, "Actual Loops": 1, "Output": ["_hyper_8_2345_chunk.simulationrunid", "_hyper_8_2345_chunk.componentid", "_hyper_8_2345_chunk.discriminator", "_hyper_8_2345_chunk.elementid", "_hyper_8_2345_chunk.workorderid", "_hyper_8_2345_chunk.start", "_hyper_8_2345_chunk.finish"], "Index Cond": "((_hyper_8_2345_chunk.simulationrunid = 325) AND ((_hyper_8_2345_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 1, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2346_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2346_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2346_chunk", "Startup Cost": 0.29, "Total Cost": 219.37, "Plan Rows": 1137, "Plan Width": 96, "Actual Startup Time": 0.012, "Actual Total Time": 0.340, "Actual Rows": 1200, "Actual Loops": 1, "Output": ["_hyper_8_2346_chunk.simulationrunid", "_hyper_8_2346_chunk.componentid", "_hyper_8_2346_chunk.discriminator", "_hyper_8_2346_chunk.elementid", "_hyper_8_2346_chunk.workorderid", "_hyper_8_2346_chunk.start", "_hyper_8_2346_chunk.finish"], "Index Cond": "((_hyper_8_2346_chunk.simulationrunid = 325) AND ((_hyper_8_2346_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 193, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2347_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2347_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2347_chunk", "Startup Cost": 0.29, "Total Cost": 437.90, "Plan Rows": 2007, "Plan Width": 94, "Actual Startup Time": 0.014, "Actual Total Time": 0.715, "Actual Rows": 2237, "Actual Loops": 1, "Output": ["_hyper_8_2347_chunk.simulationrunid", "_hyper_8_2347_chunk.componentid", "_hyper_8_2347_chunk.discriminator", "_hyper_8_2347_chunk.elementid", "_hyper_8_2347_chunk.workorderid", "_hyper_8_2347_chunk.start", "_hyper_8_2347_chunk.finish"], "Index Cond": "((_hyper_8_2347_chunk.simulationrunid = 325) AND ((_hyper_8_2347_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 561, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2348_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2348_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2348_chunk", "Startup Cost": 0.29, "Total Cost": 481.02, "Plan Rows": 2712, "Plan Width": 94, "Actual Startup Time": 0.015, "Actual Total Time": 0.969, "Actual Rows": 2758, "Actual Loops": 1, "Output": ["_hyper_8_2348_chunk.simulationrunid", "_hyper_8_2348_chunk.componentid", "_hyper_8_2348_chunk.discriminator", "_hyper_8_2348_chunk.elementid", "_hyper_8_2348_chunk.workorderid", "_hyper_8_2348_chunk.start", "_hyper_8_2348_chunk.finish"], "Index Cond": "((_hyper_8_2348_chunk.simulationrunid = 325) AND ((_hyper_8_2348_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 767, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2349_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2349_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2349_chunk", "Startup Cost": 0.29, "Total Cost": 539.85, "Plan Rows": 3233, "Plan Width": 95, "Actual Startup Time": 0.015, "Actual Total Time": 1.072, "Actual Rows": 3233, "Actual Loops": 1, "Output": ["_hyper_8_2349_chunk.simulationrunid", "_hyper_8_2349_chunk.componentid", "_hyper_8_2349_chunk.discriminator", "_hyper_8_2349_chunk.elementid", "_hyper_8_2349_chunk.workorderid", "_hyper_8_2349_chunk.start", "_hyper_8_2349_chunk.finish"], "Index Cond": "((_hyper_8_2349_chunk.simulationrunid = 325) AND ((_hyper_8_2349_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 849, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2350_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2350_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2350_chunk", "Startup Cost": 0.29, "Total Cost": 569.78, "Plan Rows": 3434, "Plan Width": 95, "Actual Startup Time": 0.013, "Actual Total Time": 1.168, "Actual Rows": 3438, "Actual Loops": 1, "Output": ["_hyper_8_2350_chunk.simulationrunid", "_hyper_8_2350_chunk.componentid", "_hyper_8_2350_chunk.discriminator", "_hyper_8_2350_chunk.elementid", "_hyper_8_2350_chunk.workorderid", "_hyper_8_2350_chunk.start", "_hyper_8_2350_chunk.finish"], "Index Cond": "((_hyper_8_2350_chunk.simulationrunid = 325) AND ((_hyper_8_2350_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 931, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2351_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2351_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2351_chunk", "Startup Cost": 0.29, "Total Cost": 272.42, "Plan Rows": 1143, "Plan Width": 93, "Actual Startup Time": 0.010, "Actual Total Time": 0.443, "Actual Rows": 1131, "Actual Loops": 1, "Output": ["_hyper_8_2351_chunk.simulationrunid", "_hyper_8_2351_chunk.componentid", "_hyper_8_2351_chunk.discriminator", "_hyper_8_2351_chunk.elementid", "_hyper_8_2351_chunk.workorderid", "_hyper_8_2351_chunk.start", "_hyper_8_2351_chunk.finish"], "Index Cond": "((_hyper_8_2351_chunk.simulationrunid = 325) AND ((_hyper_8_2351_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 372, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2352_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2352_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2352_chunk", "Startup Cost": 0.29, "Total Cost": 270.47, "Plan Rows": 1232, "Plan Width": 105, "Actual Startup Time": 0.015, "Actual Total Time": 0.364, "Actual Rows": 1283, "Actual Loops": 1, "Output": ["_hyper_8_2352_chunk.simulationrunid", "_hyper_8_2352_chunk.componentid", "_hyper_8_2352_chunk.discriminator", "_hyper_8_2352_chunk.elementid", "_hyper_8_2352_chunk.workorderid", "_hyper_8_2352_chunk.start", "_hyper_8_2352_chunk.finish"], "Index Cond": "((_hyper_8_2352_chunk.simulationrunid = 325) AND ((_hyper_8_2352_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 246, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2353_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2353_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2353_chunk", "Startup Cost": 0.29, "Total Cost": 413.32, "Plan Rows": 1910, "Plan Width": 102, "Actual Startup Time": 0.013, "Actual Total Time": 0.718, "Actual Rows": 2154, "Actual Loops": 1, "Output": ["_hyper_8_2353_chunk.simulationrunid", "_hyper_8_2353_chunk.componentid", "_hyper_8_2353_chunk.discriminator", "_hyper_8_2353_chunk.elementid", "_hyper_8_2353_chunk.workorderid", "_hyper_8_2353_chunk.start", "_hyper_8_2353_chunk.finish"], "Index Cond": "((_hyper_8_2353_chunk.simulationrunid = 325) AND ((_hyper_8_2353_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 552, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2354_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2354_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2354_chunk", "Startup Cost": 0.29, "Total Cost": 503.54, "Plan Rows": 2670, "Plan Width": 102, "Actual Startup Time": 0.016, "Actual Total Time": 1.015, "Actual Rows": 2758, "Actual Loops": 1, "Output": ["_hyper_8_2354_chunk.simulationrunid", "_hyper_8_2354_chunk.componentid", "_hyper_8_2354_chunk.discriminator", "_hyper_8_2354_chunk.elementid", "_hyper_8_2354_chunk.workorderid", "_hyper_8_2354_chunk.start", "_hyper_8_2354_chunk.finish"], "Index Cond": "((_hyper_8_2354_chunk.simulationrunid = 325) AND ((_hyper_8_2354_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 795, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2355_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2355_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2355_chunk", "Startup Cost": 0.29, "Total Cost": 565.50, "Plan Rows": 3233, "Plan Width": 103, "Actual Startup Time": 0.014, "Actual Total Time": 1.127, "Actual Rows": 3233, "Actual Loops": 1, "Output": ["_hyper_8_2355_chunk.simulationrunid", "_hyper_8_2355_chunk.componentid", "_hyper_8_2355_chunk.discriminator", "_hyper_8_2355_chunk.elementid", "_hyper_8_2355_chunk.workorderid", "_hyper_8_2355_chunk.start", "_hyper_8_2355_chunk.finish"], "Index Cond": "((_hyper_8_2355_chunk.simulationrunid = 325) AND ((_hyper_8_2355_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 924, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2356_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2356_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2356_chunk", "Startup Cost": 0.41, "Total Cost": 599.76, "Plan Rows": 3441, "Plan Width": 103, "Actual Startup Time": 0.011, "Actual Total Time": 1.209, "Actual Rows": 3438, "Actual Loops": 1, "Output": ["_hyper_8_2356_chunk.simulationrunid", "_hyper_8_2356_chunk.componentid", "_hyper_8_2356_chunk.discriminator", "_hyper_8_2356_chunk.elementid", "_hyper_8_2356_chunk.workorderid", "_hyper_8_2356_chunk.start", "_hyper_8_2356_chunk.finish"], "Index Cond": "((_hyper_8_2356_chunk.simulationrunid = 325) AND ((_hyper_8_2356_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 1019, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2357_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2357_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2357_chunk", "Startup Cost": 0.29, "Total Cost": 279.73, "Plan Rows": 1131, "Plan Width": 100, "Actual Startup Time": 0.012, "Actual Total Time": 0.484, "Actual Rows": 1131, "Actual Loops": 1, "Output": ["_hyper_8_2357_chunk.simulationrunid", "_hyper_8_2357_chunk.componentid", "_hyper_8_2357_chunk.discriminator", "_hyper_8_2357_chunk.elementid", "_hyper_8_2357_chunk.workorderid", "_hyper_8_2357_chunk.start", "_hyper_8_2357_chunk.finish"], "Index Cond": "((_hyper_8_2357_chunk.simulationrunid = 325) AND ((_hyper_8_2357_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 432, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2358_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2358_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2358_chunk", "Startup Cost": 0.14, "Total Cost": 1.75, "Plan Rows": 1, "Plan Width": 100, "Actual Startup Time": 0.013, "Actual Total Time": 0.013, "Actual Rows": 0, "Actual Loops": 1, "Output": ["_hyper_8_2358_chunk.simulationrunid", "_hyper_8_2358_chunk.componentid", "_hyper_8_2358_chunk.discriminator", "_hyper_8_2358_chunk.elementid", "_hyper_8_2358_chunk.workorderid", "_hyper_8_2358_chunk.start", "_hyper_8_2358_chunk.finish"], "Index Cond": "((_hyper_8_2358_chunk.simulationrunid = 325) AND ((_hyper_8_2358_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 1, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 } ] } ] }, { "Node Type": "Values Scan", "Parent Relationship": "Inner", "Parallel Aware": false, "Async Capable": false, "Alias": "*VALUES*", "Startup Cost": 0.00, "Total Cost": 0.03, "Plan Rows": 1, "Plan Width": 12, "Actual Startup Time": 0.000, "Actual Total Time": 0.000, "Actual Rows": 1, "Actual Loops": 32352, "Output": ["\"*VALUES*\".column1", "\"*VALUES*\".column2"], "Filter": "(\"*VALUES*\".column2 > 0)", "Rows Removed by Filter": 1, "Shared Hit Blocks": 0, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 } ] } ] } ] } ] } ] } ] } ] }, { "Node Type": "Hash", "Parent Relationship": "Inner", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 16490.59, "Total Cost": 16490.59, "Plan Rows": 6, "Plan Width": 39, "Actual Startup Time": 11.578, "Actual Total Time": 11.579, "Actual Rows": 4385, "Actual Loops": 1, "Output": ["lim_hard.sim_run_id", "lim_hard.component", "lim_hard.value"], "Hash Buckets": 8192, "Original Hash Buckets": 1024, "Hash Batches": 1, "Original Hash Batches": 1, "Peak Memory Usage": 277, "Shared Hit Blocks": 3340, "Shared Read Blocks": 1507, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Index Scan", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "idx_simruncomponentmetadata_simrunid_key", "Relation Name": "sim_run_component_metadata", "Schema": "public", "Alias": "lim_hard", "Startup Cost": 0.43, "Total Cost": 16490.59, "Plan Rows": 6, "Plan Width": 39, "Actual Startup Time": 3.691, "Actual Total Time": 10.739, "Actual Rows": 4385, "Actual Loops": 1, "Output": ["lim_hard.sim_run_id", "lim_hard.component", "lim_hard.value"], "Index Cond": "((lim_hard.key)::text = 'HARD'::text)", "Rows Removed by Index Recheck": 0, "Filter": "((lim_hard.generator)::text = 'AREA_CAPACITY'::text)", "Rows Removed by Filter": 0, "Shared Hit Blocks": 3340, "Shared Read Blocks": 1507, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 } ] } ] }, { "Node Type": "Hash", "Parent Relationship": "Inner", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 14857.95, "Total Cost": 14857.95, "Plan Rows": 1, "Plan Width": 39, "Actual Startup Time": 2.186, "Actual Total Time": 2.187, "Actual Rows": 2335, "Actual Loops": 1, "Output": ["lim_soft.sim_run_id", "lim_soft.component", "lim_soft.value"], "Hash Buckets": 4096, "Original Hash Buckets": 1024, "Hash Batches": 1, "Original Hash Batches": 1, "Peak Memory Usage": 146, "Shared Hit Blocks": 1980, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Index Scan", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "idx_simruncomponentmetadata_simrunid_key", "Relation Name": "sim_run_component_metadata", "Schema": "public", "Alias": "lim_soft", "Startup Cost": 0.43, "Total Cost": 14857.95, "Plan Rows": 1, "Plan Width": 39, "Actual Startup Time": 0.582, "Actual Total Time": 1.764, "Actual Rows": 2335, "Actual Loops": 1, "Output": ["lim_soft.sim_run_id", "lim_soft.component", "lim_soft.value"], "Index Cond": "((lim_soft.key)::text = 'SOFT'::text)", "Rows Removed by Index Recheck": 0, "Filter": "((lim_soft.generator)::text = 'AREA_CAPACITY'::text)", "Rows Removed by Filter": 0, "Shared Hit Blocks": 1980, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 } ] } ] } ] }, { "Node Type": "Materialize", "Parent Relationship": "Inner", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 17100.87, "Total Cost": 17268.38, "Plan Rows": 1000, "Plan Width": 125, "Actual Startup Time": 70922.634, "Actual Total Time": 71056.269, "Actual Rows": 27545, "Actual Loops": 1, "Output": ["lu_holding_buckets.simulationrunid", "lu_holding_buckets.componentid", "lu_holding_buckets.bucket_start", "((lu_holding_buckets.bucket_start + '01:00:00'::interval))", "(sum(CASE WHEN ((lu_holding_buckets.finish >= lu_holding_buckets.bucket_start) AND (lu_holding_buckets.finish < ((lu_holding_buckets.bucket_start + '01:00:00'::interval)))) THEN 1 ELSE 0 END))", "(sum(CASE WHEN (lu_holding_buckets.finish >= ((lu_holding_buckets.bucket_start + '01:00:00'::interval))) THEN 1 ELSE 0 END))", "(sum(CASE WHEN ((lu_holding_buckets.finish >= lu_holding_buckets.bucket_start) AND (lu_holding_buckets.finish < ((lu_holding_buckets.bucket_start + '01:00:00'::interval))) AND (lu_holding_buckets.finish > lu_holding_buckets.late_ref_time)) THEN 1 ELSE 0 END))", "(sum(CASE WHEN ((lu_holding_buckets.finish >= ((lu_holding_buckets.bucket_start + '01:00:00'::interval))) AND (lu_holding_buckets.late_ref_time < ((lu_holding_buckets.bucket_start + '01:00:00'::interval))) AND (lu_holding_buckets.finish > lu_holding_buckets.late_ref_time)) THEN 1 ELSE 0 END))", "(EXTRACT(epoch FROM sum((CASE WHEN (work_order_buckets.finish < ((work_order_buckets.bucket_start + '01:00:00'::interval))) THEN work_order_buckets.finish ELSE ((work_order_buckets.bucket_start + '01:00:00'::interval)) END - CASE WHEN (work_order_buckets.start > work_order_buckets.bucket_start) THEN work_order_buckets.start ELSE work_order_buckets.bucket_start END))))", "(count(DISTINCT work_order_buckets.workerid))", "(count(DISTINCT work_order_buckets.workorderid))", "(sum(CASE WHEN (work_order_buckets.finish >= ((work_order_buckets.bucket_start + '01:00:00'::interval))) THEN 1 ELSE 0 END))", "(sum(CASE WHEN ((work_order_buckets.finish >= ((work_order_buckets.bucket_start + '01:00:00'::interval))) AND (work_order_buckets.finish > work_order_buckets.late_ref_time)) THEN 1 ELSE 0 END))"], "Shared Hit Blocks": 147520, "Shared Read Blocks": 1, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 1933, "Temp Written Blocks": 1934, "Plans": [ { "Node Type": "Merge Join", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Join Type": "Left", "Startup Cost": 17100.87, "Total Cost": 17265.88, "Plan Rows": 1000, "Plan Width": 125, "Actual Startup Time": 70922.603, "Actual Total Time": 71047.578, "Actual Rows": 27545, "Actual Loops": 1, "Output": ["lu_holding_buckets.simulationrunid", "lu_holding_buckets.componentid", "lu_holding_buckets.bucket_start", "((lu_holding_buckets.bucket_start + '01:00:00'::interval))", "(sum(CASE WHEN ((lu_holding_buckets.finish >= lu_holding_buckets.bucket_start) AND (lu_holding_buckets.finish < ((lu_holding_buckets.bucket_start + '01:00:00'::interval)))) THEN 1 ELSE 0 END))", "(sum(CASE WHEN (lu_holding_buckets.finish >= ((lu_holding_buckets.bucket_start + '01:00:00'::interval))) THEN 1 ELSE 0 END))", "(sum(CASE WHEN ((lu_holding_buckets.finish >= lu_holding_buckets.bucket_start) AND (lu_holding_buckets.finish < ((lu_holding_buckets.bucket_start + '01:00:00'::interval))) AND (lu_holding_buckets.finish > lu_holding_buckets.late_ref_time)) THEN 1 ELSE 0 END))", "(sum(CASE WHEN ((lu_holding_buckets.finish >= ((lu_holding_buckets.bucket_start + '01:00:00'::interval))) AND (lu_holding_buckets.late_ref_time < ((lu_holding_buckets.bucket_start + '01:00:00'::interval))) AND (lu_holding_buckets.finish > lu_holding_buckets.late_ref_time)) THEN 1 ELSE 0 END))", "(EXTRACT(epoch FROM sum((CASE WHEN (work_order_buckets.finish < ((work_order_buckets.bucket_start + '01:00:00'::interval))) THEN work_order_buckets.finish ELSE ((work_order_buckets.bucket_start + '01:00:00'::interval)) END - CASE WHEN (work_order_buckets.start > work_order_buckets.bucket_start) THEN work_order_buckets.start ELSE work_order_buckets.bucket_start END))))", "(count(DISTINCT work_order_buckets.workerid))", "(count(DISTINCT work_order_buckets.workorderid))", "(sum(CASE WHEN (work_order_buckets.finish >= ((work_order_buckets.bucket_start + '01:00:00'::interval))) THEN 1 ELSE 0 END))", "(sum(CASE WHEN ((work_order_buckets.finish >= ((work_order_buckets.bucket_start + '01:00:00'::interval))) AND (work_order_buckets.finish > work_order_buckets.late_ref_time)) THEN 1 ELSE 0 END))"], "Inner Unique": true, "Merge Cond": "((lu_holding_buckets.simulationrunid = work_order_buckets.simulationrunid) AND ((lu_holding_buckets.componentid)::text = (work_order_buckets.componentid)::text) AND (lu_holding_buckets.bucket_start = work_order_buckets.bucket_start) AND (((lu_holding_buckets.bucket_start + '01:00:00'::interval)) = ((work_order_buckets.bucket_start + '01:00:00'::interval))))", "Shared Hit Blocks": 147520, "Shared Read Blocks": 1, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 1933, "Temp Written Blocks": 1934, "Plans": [ { "Node Type": "Aggregate", "Strategy": "Sorted", "Partial Mode": "Simple", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 8450.04, "Total Cost": 8520.04, "Plan Rows": 1000, "Plan Width": 61, "Actual Startup Time": 34046.917, "Actual Total Time": 34151.241, "Actual Rows": 27545, "Actual Loops": 1, "Output": ["lu_holding_buckets.simulationrunid", "lu_holding_buckets.componentid", "lu_holding_buckets.bucket_start", "((lu_holding_buckets.bucket_start + '01:00:00'::interval))", "sum(CASE WHEN ((lu_holding_buckets.finish >= lu_holding_buckets.bucket_start) AND (lu_holding_buckets.finish < ((lu_holding_buckets.bucket_start + '01:00:00'::interval)))) THEN 1 ELSE 0 END)", "sum(CASE WHEN (lu_holding_buckets.finish >= ((lu_holding_buckets.bucket_start + '01:00:00'::interval))) THEN 1 ELSE 0 END)", "sum(CASE WHEN ((lu_holding_buckets.finish >= lu_holding_buckets.bucket_start) AND (lu_holding_buckets.finish < ((lu_holding_buckets.bucket_start + '01:00:00'::interval))) AND (lu_holding_buckets.finish > lu_holding_buckets.late_ref_time)) THEN 1 ELSE 0 END)", "sum(CASE WHEN ((lu_holding_buckets.finish >= ((lu_holding_buckets.bucket_start + '01:00:00'::interval))) AND (lu_holding_buckets.late_ref_time < ((lu_holding_buckets.bucket_start + '01:00:00'::interval))) AND (lu_holding_buckets.finish > lu_holding_buckets.late_ref_time)) THEN 1 ELSE 0 END)"], "Group Key": ["lu_holding_buckets.simulationrunid", "lu_holding_buckets.componentid", "lu_holding_buckets.bucket_start", "((lu_holding_buckets.bucket_start + '01:00:00'::interval))"], "Shared Hit Blocks": 12498, "Shared Read Blocks": 1, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 1933, "Temp Written Blocks": 1934, "Plans": [ { "Node Type": "Sort", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 8450.04, "Total Cost": 8452.54, "Plan Rows": 1000, "Plan Width": 45, "Actual Startup Time": 34046.901, "Actual Total Time": 34093.430, "Actual Rows": 272354, "Actual Loops": 1, "Output": ["lu_holding_buckets.simulationrunid", "lu_holding_buckets.componentid", "lu_holding_buckets.bucket_start", "((lu_holding_buckets.bucket_start + '01:00:00'::interval))", "lu_holding_buckets.finish", "lu_holding_buckets.late_ref_time"], "Sort Key": ["lu_holding_buckets.simulationrunid", "lu_holding_buckets.componentid", "lu_holding_buckets.bucket_start", "((lu_holding_buckets.bucket_start + '01:00:00'::interval))"], "Sort Method": "external merge", "Sort Space Used": 15464, "Sort Space Type": "Disk", "Shared Hit Blocks": 12498, "Shared Read Blocks": 1, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 1933, "Temp Written Blocks": 1934, "Plans": [ { "Node Type": "Subquery Scan", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Alias": "lu_holding_buckets", "Startup Cost": 9.07, "Total Cost": 8400.21, "Plan Rows": 1000, "Plan Width": 45, "Actual Startup Time": 27.862, "Actual Total Time": 33825.146, "Actual Rows": 272354, "Actual Loops": 1, "Output": ["lu_holding_buckets.simulationrunid", "lu_holding_buckets.componentid", "lu_holding_buckets.bucket_start", "(lu_holding_buckets.bucket_start + '01:00:00'::interval)", "lu_holding_buckets.finish", "lu_holding_buckets.late_ref_time"], "Shared Hit Blocks": 12498, "Shared Read Blocks": 1, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "ProjectSet", "Parent Relationship": "Subquery", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 9.07, "Total Cost": 8387.71, "Plan Rows": 1000, "Plan Width": 77, "Actual Startup Time": 27.860, "Actual Total Time": 33802.125, "Actual Rows": 272354, "Actual Loops": 1, "Output": ["_hyper_8_2343_chunk_1.simulationrunid", "_hyper_8_2343_chunk_1.componentid", "NULL::character varying", "NULL::timestamp with time zone", "_hyper_8_2343_chunk_1.finish", "generate_series(time_bucket('01:00:00'::interval, _hyper_8_2343_chunk_1.start), time_bucket('01:00:00'::interval, _hyper_8_2343_chunk_1.finish), '01:00:00'::interval)", "((sim_run_component_metadata.value)::timestamp with time zone)"], "Shared Hit Blocks": 12498, "Shared Read Blocks": 1, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Nested Loop", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Join Type": "Left", "Startup Cost": 9.07, "Total Cost": 8382.70, "Plan Rows": 1, "Plan Width": 37, "Actual Startup Time": 27.856, "Actual Total Time": 33769.441, "Actual Rows": 32352, "Actual Loops": 1, "Output": ["_hyper_8_2343_chunk_1.start", "_hyper_8_2343_chunk_1.finish", "_hyper_8_2343_chunk_1.simulationrunid", "_hyper_8_2343_chunk_1.componentid", "((sim_run_component_metadata.value)::timestamp with time zone)"], "Inner Unique": false, "Join Filter": "(((sim_run_component_metadata.generator)::text = (e.elementcreatedatcomponentid)::text) AND ((sim_run_component_metadata.component)::text = (_hyper_8_2343_chunk_1.componentid)::text))", "Rows Removed by Join Filter": 337204896, "Shared Hit Blocks": 12498, "Shared Read Blocks": 1, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Hash Join", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Join Type": "Inner", "Startup Cost": 7.02, "Total Cost": 8380.63, "Plan Rows": 1, "Plan Width": 61, "Actual Startup Time": 6.236, "Actual Total Time": 107.050, "Actual Rows": 32352, "Actual Loops": 1, "Output": ["_hyper_8_2343_chunk_1.simulationrunid", "_hyper_8_2343_chunk_1.componentid", "_hyper_8_2343_chunk_1.finish", "_hyper_8_2343_chunk_1.start", "e.elementcreatedatcomponentid"], "Inner Unique": false, "Hash Cond": "((_hyper_8_2343_chunk_1.simulationrunid = e.simulationrunid) AND ((_hyper_8_2343_chunk_1.elementid)::text = (e.elementid)::text))", "Shared Hit Blocks": 12279, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Incremental Sort", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 6.99, "Total Cost": 7827.15, "Plan Rows": 31625, "Plan Width": 99, "Actual Startup Time": 0.284, "Actual Total Time": 78.387, "Actual Rows": 32352, "Actual Loops": 1, "Output": ["_hyper_8_2343_chunk_1.simulationrunid", "_hyper_8_2343_chunk_1.componentid", "_hyper_8_2343_chunk_1.discriminator", "_hyper_8_2343_chunk_1.elementid", "_hyper_8_2343_chunk_1.workorderid", "_hyper_8_2343_chunk_1.start", "_hyper_8_2343_chunk_1.finish"], "Sort Key": ["_hyper_8_2343_chunk_1.componentid", "_hyper_8_2343_chunk_1.elementid", "_hyper_8_2343_chunk_1.workorderid", "_hyper_8_2343_chunk_1.start", "_hyper_8_2343_chunk_1.finish"], "Presorted Key": ["_hyper_8_2343_chunk_1.componentid"], "Full-sort Groups": { "Group Count": 127, "Sort Methods Used": ["quicksort"], "Sort Space Memory": { "Average Sort Space Used": 28, "Peak Sort Space Used": 28 } }, "Pre-sorted Groups": { "Group Count": 96, "Sort Methods Used": ["quicksort"], "Sort Space Memory": { "Average Sort Space Used": 60, "Peak Sort Space Used": 1172 } }, "Shared Hit Blocks": 9178, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Merge Append", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 4.74, "Total Cost": 6848.78, "Plan Rows": 31625, "Plan Width": 98, "Actual Startup Time": 0.220, "Actual Total Time": 19.596, "Actual Rows": 32352, "Actual Loops": 1, "Sort Key": ["_hyper_8_2343_chunk_1.componentid"], "Shared Hit Blocks": 9178, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Subplans Removed": 0, "Plans": [ { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2343_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2343_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2343_chunk_1", "Startup Cost": 0.29, "Total Cost": 438.10, "Plan Rows": 2146, "Plan Width": 93, "Actual Startup Time": 0.021, "Actual Total Time": 1.216, "Actual Rows": 2179, "Actual Loops": 1, "Output": ["_hyper_8_2343_chunk_1.simulationrunid", "_hyper_8_2343_chunk_1.componentid", "_hyper_8_2343_chunk_1.discriminator", "_hyper_8_2343_chunk_1.elementid", "_hyper_8_2343_chunk_1.workorderid", "_hyper_8_2343_chunk_1.start", "_hyper_8_2343_chunk_1.finish"], "Index Cond": "((_hyper_8_2343_chunk_1.simulationrunid = 325) AND ((_hyper_8_2343_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 645, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2344_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2344_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2344_chunk_1", "Startup Cost": 0.29, "Total Cost": 462.90, "Plan Rows": 2188, "Plan Width": 101, "Actual Startup Time": 0.013, "Actual Total Time": 1.352, "Actual Rows": 2179, "Actual Loops": 1, "Output": ["_hyper_8_2344_chunk_1.simulationrunid", "_hyper_8_2344_chunk_1.componentid", "_hyper_8_2344_chunk_1.discriminator", "_hyper_8_2344_chunk_1.elementid", "_hyper_8_2344_chunk_1.workorderid", "_hyper_8_2344_chunk_1.start", "_hyper_8_2344_chunk_1.finish"], "Index Cond": "((_hyper_8_2344_chunk_1.simulationrunid = 325) AND ((_hyper_8_2344_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 818, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2345_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2345_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2345_chunk_1", "Startup Cost": 0.13, "Total Cost": 2.35, "Plan Rows": 1, "Plan Width": 120, "Actual Startup Time": 0.007, "Actual Total Time": 0.007, "Actual Rows": 0, "Actual Loops": 1, "Output": ["_hyper_8_2345_chunk_1.simulationrunid", "_hyper_8_2345_chunk_1.componentid", "_hyper_8_2345_chunk_1.discriminator", "_hyper_8_2345_chunk_1.elementid", "_hyper_8_2345_chunk_1.workorderid", "_hyper_8_2345_chunk_1.start", "_hyper_8_2345_chunk_1.finish"], "Index Cond": "((_hyper_8_2345_chunk_1.simulationrunid = 325) AND ((_hyper_8_2345_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 1, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2346_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2346_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2346_chunk_1", "Startup Cost": 0.29, "Total Cost": 219.37, "Plan Rows": 1137, "Plan Width": 96, "Actual Startup Time": 0.014, "Actual Total Time": 0.402, "Actual Rows": 1200, "Actual Loops": 1, "Output": ["_hyper_8_2346_chunk_1.simulationrunid", "_hyper_8_2346_chunk_1.componentid", "_hyper_8_2346_chunk_1.discriminator", "_hyper_8_2346_chunk_1.elementid", "_hyper_8_2346_chunk_1.workorderid", "_hyper_8_2346_chunk_1.start", "_hyper_8_2346_chunk_1.finish"], "Index Cond": "((_hyper_8_2346_chunk_1.simulationrunid = 325) AND ((_hyper_8_2346_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 191, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2347_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2347_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2347_chunk_1", "Startup Cost": 0.29, "Total Cost": 437.97, "Plan Rows": 2014, "Plan Width": 94, "Actual Startup Time": 0.015, "Actual Total Time": 0.939, "Actual Rows": 2237, "Actual Loops": 1, "Output": ["_hyper_8_2347_chunk_1.simulationrunid", "_hyper_8_2347_chunk_1.componentid", "_hyper_8_2347_chunk_1.discriminator", "_hyper_8_2347_chunk_1.elementid", "_hyper_8_2347_chunk_1.workorderid", "_hyper_8_2347_chunk_1.start", "_hyper_8_2347_chunk_1.finish"], "Index Cond": "((_hyper_8_2347_chunk_1.simulationrunid = 325) AND ((_hyper_8_2347_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 558, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2348_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2348_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2348_chunk_1", "Startup Cost": 0.29, "Total Cost": 481.01, "Plan Rows": 2711, "Plan Width": 94, "Actual Startup Time": 0.014, "Actual Total Time": 1.297, "Actual Rows": 2758, "Actual Loops": 1, "Output": ["_hyper_8_2348_chunk_1.simulationrunid", "_hyper_8_2348_chunk_1.componentid", "_hyper_8_2348_chunk_1.discriminator", "_hyper_8_2348_chunk_1.elementid", "_hyper_8_2348_chunk_1.workorderid", "_hyper_8_2348_chunk_1.start", "_hyper_8_2348_chunk_1.finish"], "Index Cond": "((_hyper_8_2348_chunk_1.simulationrunid = 325) AND ((_hyper_8_2348_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 776, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2349_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2349_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2349_chunk_1", "Startup Cost": 0.29, "Total Cost": 539.85, "Plan Rows": 3233, "Plan Width": 95, "Actual Startup Time": 0.013, "Actual Total Time": 1.352, "Actual Rows": 3233, "Actual Loops": 1, "Output": ["_hyper_8_2349_chunk_1.simulationrunid", "_hyper_8_2349_chunk_1.componentid", "_hyper_8_2349_chunk_1.discriminator", "_hyper_8_2349_chunk_1.elementid", "_hyper_8_2349_chunk_1.workorderid", "_hyper_8_2349_chunk_1.start", "_hyper_8_2349_chunk_1.finish"], "Index Cond": "((_hyper_8_2349_chunk_1.simulationrunid = 325) AND ((_hyper_8_2349_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 863, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2350_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2350_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2350_chunk_1", "Startup Cost": 0.29, "Total Cost": 569.79, "Plan Rows": 3435, "Plan Width": 95, "Actual Startup Time": 0.011, "Actual Total Time": 1.514, "Actual Rows": 3438, "Actual Loops": 1, "Output": ["_hyper_8_2350_chunk_1.simulationrunid", "_hyper_8_2350_chunk_1.componentid", "_hyper_8_2350_chunk_1.discriminator", "_hyper_8_2350_chunk_1.elementid", "_hyper_8_2350_chunk_1.workorderid", "_hyper_8_2350_chunk_1.start", "_hyper_8_2350_chunk_1.finish"], "Index Cond": "((_hyper_8_2350_chunk_1.simulationrunid = 325) AND ((_hyper_8_2350_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 926, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2351_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2351_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2351_chunk_1", "Startup Cost": 0.29, "Total Cost": 272.42, "Plan Rows": 1143, "Plan Width": 93, "Actual Startup Time": 0.012, "Actual Total Time": 0.537, "Actual Rows": 1131, "Actual Loops": 1, "Output": ["_hyper_8_2351_chunk_1.simulationrunid", "_hyper_8_2351_chunk_1.componentid", "_hyper_8_2351_chunk_1.discriminator", "_hyper_8_2351_chunk_1.elementid", "_hyper_8_2351_chunk_1.workorderid", "_hyper_8_2351_chunk_1.start", "_hyper_8_2351_chunk_1.finish"], "Index Cond": "((_hyper_8_2351_chunk_1.simulationrunid = 325) AND ((_hyper_8_2351_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 382, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2352_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2352_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2352_chunk_1", "Startup Cost": 0.29, "Total Cost": 270.47, "Plan Rows": 1232, "Plan Width": 105, "Actual Startup Time": 0.014, "Actual Total Time": 0.414, "Actual Rows": 1283, "Actual Loops": 1, "Output": ["_hyper_8_2352_chunk_1.simulationrunid", "_hyper_8_2352_chunk_1.componentid", "_hyper_8_2352_chunk_1.discriminator", "_hyper_8_2352_chunk_1.elementid", "_hyper_8_2352_chunk_1.workorderid", "_hyper_8_2352_chunk_1.start", "_hyper_8_2352_chunk_1.finish"], "Index Cond": "((_hyper_8_2352_chunk_1.simulationrunid = 325) AND ((_hyper_8_2352_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 253, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2353_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2353_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2353_chunk_1", "Startup Cost": 0.29, "Total Cost": 413.31, "Plan Rows": 1909, "Plan Width": 102, "Actual Startup Time": 0.014, "Actual Total Time": 0.923, "Actual Rows": 2154, "Actual Loops": 1, "Output": ["_hyper_8_2353_chunk_1.simulationrunid", "_hyper_8_2353_chunk_1.componentid", "_hyper_8_2353_chunk_1.discriminator", "_hyper_8_2353_chunk_1.elementid", "_hyper_8_2353_chunk_1.workorderid", "_hyper_8_2353_chunk_1.start", "_hyper_8_2353_chunk_1.finish"], "Index Cond": "((_hyper_8_2353_chunk_1.simulationrunid = 325) AND ((_hyper_8_2353_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 548, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2354_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2354_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2354_chunk_1", "Startup Cost": 0.29, "Total Cost": 503.54, "Plan Rows": 2670, "Plan Width": 102, "Actual Startup Time": 0.016, "Actual Total Time": 1.367, "Actual Rows": 2758, "Actual Loops": 1, "Output": ["_hyper_8_2354_chunk_1.simulationrunid", "_hyper_8_2354_chunk_1.componentid", "_hyper_8_2354_chunk_1.discriminator", "_hyper_8_2354_chunk_1.elementid", "_hyper_8_2354_chunk_1.workorderid", "_hyper_8_2354_chunk_1.start", "_hyper_8_2354_chunk_1.finish"], "Index Cond": "((_hyper_8_2354_chunk_1.simulationrunid = 325) AND ((_hyper_8_2354_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 799, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2355_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2355_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2355_chunk_1", "Startup Cost": 0.29, "Total Cost": 565.50, "Plan Rows": 3233, "Plan Width": 103, "Actual Startup Time": 0.014, "Actual Total Time": 1.476, "Actual Rows": 3233, "Actual Loops": 1, "Output": ["_hyper_8_2355_chunk_1.simulationrunid", "_hyper_8_2355_chunk_1.componentid", "_hyper_8_2355_chunk_1.discriminator", "_hyper_8_2355_chunk_1.elementid", "_hyper_8_2355_chunk_1.workorderid", "_hyper_8_2355_chunk_1.start", "_hyper_8_2355_chunk_1.finish"], "Index Cond": "((_hyper_8_2355_chunk_1.simulationrunid = 325) AND ((_hyper_8_2355_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 938, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2356_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2356_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2356_chunk_1", "Startup Cost": 0.41, "Total Cost": 599.76, "Plan Rows": 3441, "Plan Width": 103, "Actual Startup Time": 0.016, "Actual Total Time": 1.613, "Actual Rows": 3438, "Actual Loops": 1, "Output": ["_hyper_8_2356_chunk_1.simulationrunid", "_hyper_8_2356_chunk_1.componentid", "_hyper_8_2356_chunk_1.discriminator", "_hyper_8_2356_chunk_1.elementid", "_hyper_8_2356_chunk_1.workorderid", "_hyper_8_2356_chunk_1.start", "_hyper_8_2356_chunk_1.finish"], "Index Cond": "((_hyper_8_2356_chunk_1.simulationrunid = 325) AND ((_hyper_8_2356_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 1038, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2357_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2357_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2357_chunk_1", "Startup Cost": 0.29, "Total Cost": 279.73, "Plan Rows": 1131, "Plan Width": 100, "Actual Startup Time": 0.012, "Actual Total Time": 0.606, "Actual Rows": 1131, "Actual Loops": 1, "Output": ["_hyper_8_2357_chunk_1.simulationrunid", "_hyper_8_2357_chunk_1.componentid", "_hyper_8_2357_chunk_1.discriminator", "_hyper_8_2357_chunk_1.elementid", "_hyper_8_2357_chunk_1.workorderid", "_hyper_8_2357_chunk_1.start", "_hyper_8_2357_chunk_1.finish"], "Index Cond": "((_hyper_8_2357_chunk_1.simulationrunid = 325) AND ((_hyper_8_2357_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 441, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2358_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2358_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2358_chunk_1", "Startup Cost": 0.14, "Total Cost": 1.75, "Plan Rows": 1, "Plan Width": 100, "Actual Startup Time": 0.007, "Actual Total Time": 0.007, "Actual Rows": 0, "Actual Loops": 1, "Output": ["_hyper_8_2358_chunk_1.simulationrunid", "_hyper_8_2358_chunk_1.componentid", "_hyper_8_2358_chunk_1.discriminator", "_hyper_8_2358_chunk_1.elementid", "_hyper_8_2358_chunk_1.workorderid", "_hyper_8_2358_chunk_1.start", "_hyper_8_2358_chunk_1.finish"], "Index Cond": "((_hyper_8_2358_chunk_1.simulationrunid = 325) AND ((_hyper_8_2358_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 1, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 } ] } ] }, { "Node Type": "Hash", "Parent Relationship": "Inner", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 0.02, "Total Cost": 0.02, "Plan Rows": 1, "Plan Width": 68, "Actual Startup Time": 5.931, "Actual Total Time": 5.931, "Actual Rows": 8088, "Actual Loops": 1, "Output": ["e.simulationrunid", "e.elementid", "e.elementcreatedatcomponentid"], "Hash Buckets": 8192, "Original Hash Buckets": 1024, "Hash Batches": 1, "Original Hash Batches": 1, "Peak Memory Usage": 939, "Shared Hit Blocks": 3101, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "CTE Scan", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "CTE Name": "filtered_elements", "Alias": "e", "Startup Cost": 0.00, "Total Cost": 0.02, "Plan Rows": 1, "Plan Width": 68, "Actual Startup Time": 0.034, "Actual Total Time": 4.356, "Actual Rows": 8088, "Actual Loops": 1, "Output": ["e.simulationrunid", "e.elementid", "e.elementcreatedatcomponentid"], "Shared Hit Blocks": 3101, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 } ] } ] }, { "Node Type": "Sort", "Parent Relationship": "Inner", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 2.04, "Total Cost": 2.05, "Plan Rows": 1, "Plan Width": 51, "Actual Startup Time": 0.001, "Actual Total Time": 0.366, "Actual Rows": 10424, "Actual Loops": 32352, "Output": ["NULL::bigint", "sim_run_component_metadata.generator", "sim_run_component_metadata.component", "((sim_run_component_metadata.value)::timestamp with time zone)"], "Sort Key": ["sim_run_component_metadata.generator", "sim_run_component_metadata.component"], "Sort Method": "quicksort", "Sort Space Used": 1158, "Sort Space Type": "Memory", "Shared Hit Blocks": 219, "Shared Read Blocks": 1, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Index Scan", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "idx_simruncomponentmetadata_simrunid_key", "Relation Name": "sim_run_component_metadata", "Schema": "public", "Alias": "sim_run_component_metadata", "Startup Cost": 0.43, "Total Cost": 2.03, "Plan Rows": 1, "Plan Width": 51, "Actual Startup Time": 0.045, "Actual Total Time": 5.287, "Actual Rows": 10424, "Actual Loops": 1, "Output": ["NULL::bigint", "sim_run_component_metadata.generator", "sim_run_component_metadata.component", "(sim_run_component_metadata.value)::timestamp with time zone"], "Index Cond": "((sim_run_component_metadata.sim_run_id = 325) AND ((sim_run_component_metadata.key)::text = 'LATEST'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 219, "Shared Read Blocks": 1, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 } ] } ] } ] } ] } ] } ] }, { "Node Type": "Aggregate", "Strategy": "Sorted", "Partial Mode": "Simple", "Parent Relationship": "Inner", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 8650.83, "Total Cost": 8715.83, "Plan Rows": 1000, "Plan Width": 92, "Actual Startup Time": 36875.680, "Actual Total Time": 36891.879, "Actual Rows": 2344, "Actual Loops": 1, "Output": ["work_order_buckets.simulationrunid", "work_order_buckets.componentid", "work_order_buckets.bucket_start", "((work_order_buckets.bucket_start + '01:00:00'::interval))", "EXTRACT(epoch FROM sum((CASE WHEN (work_order_buckets.finish < ((work_order_buckets.bucket_start + '01:00:00'::interval))) THEN work_order_buckets.finish ELSE ((work_order_buckets.bucket_start + '01:00:00'::interval)) END - CASE WHEN (work_order_buckets.start > work_order_buckets.bucket_start) THEN work_order_buckets.start ELSE work_order_buckets.bucket_start END)))", "count(DISTINCT work_order_buckets.workerid)", "count(DISTINCT work_order_buckets.workorderid)", "sum(CASE WHEN (work_order_buckets.finish >= ((work_order_buckets.bucket_start + '01:00:00'::interval))) THEN 1 ELSE 0 END)", "sum(CASE WHEN ((work_order_buckets.finish >= ((work_order_buckets.bucket_start + '01:00:00'::interval))) AND (work_order_buckets.finish > work_order_buckets.late_ref_time)) THEN 1 ELSE 0 END)"], "Group Key": ["work_order_buckets.simulationrunid", "work_order_buckets.componentid", "work_order_buckets.bucket_start", "((work_order_buckets.bucket_start + '01:00:00'::interval))"], "Shared Hit Blocks": 135022, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Sort", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 8650.83, "Total Cost": 8653.33, "Plan Rows": 1000, "Plan Width": 79, "Actual Startup Time": 36875.603, "Actual Total Time": 36877.348, "Actual Rows": 32639, "Actual Loops": 1, "Output": ["work_order_buckets.simulationrunid", "work_order_buckets.componentid", "work_order_buckets.bucket_start", "((work_order_buckets.bucket_start + '01:00:00'::interval))", "work_order_buckets.finish", "work_order_buckets.start", "work_order_buckets.workerid", "work_order_buckets.workorderid", "work_order_buckets.late_ref_time"], "Sort Key": ["work_order_buckets.simulationrunid", "work_order_buckets.componentid", "work_order_buckets.bucket_start", "((work_order_buckets.bucket_start + '01:00:00'::interval))", "work_order_buckets.workerid"], "Sort Method": "quicksort", "Sort Space Used": 4338, "Sort Space Type": "Memory", "Shared Hit Blocks": 135022, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Subquery Scan", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Alias": "work_order_buckets", "Startup Cost": 9.54, "Total Cost": 8601.00, "Plan Rows": 1000, "Plan Width": 79, "Actual Startup Time": 23.939, "Actual Total Time": 36836.499, "Actual Rows": 32639, "Actual Loops": 1, "Output": ["work_order_buckets.simulationrunid", "work_order_buckets.componentid", "work_order_buckets.bucket_start", "(work_order_buckets.bucket_start + '01:00:00'::interval)", "work_order_buckets.finish", "work_order_buckets.start", "work_order_buckets.workerid", "work_order_buckets.workorderid", "work_order_buckets.late_ref_time"], "Shared Hit Blocks": 135022, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "ProjectSet", "Parent Relationship": "Subquery", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 9.54, "Total Cost": 8588.50, "Plan Rows": 1000, "Plan Width": 103, "Actual Startup Time": 23.937, "Actual Total Time": 36827.999, "Actual Rows": 32639, "Actual Loops": 1, "Output": ["_hyper_8_2343_chunk_2.simulationrunid", "_hyper_8_2343_chunk_2.componentid", "NULL::character varying", "_hyper_8_2343_chunk_2.workorderid", "wo.workerid", "_hyper_8_2343_chunk_2.start", "_hyper_8_2343_chunk_2.finish", "((sim_run_component_metadata_1.value)::timestamp with time zone)", "generate_series(time_bucket('01:00:00'::interval, _hyper_8_2343_chunk_2.start), time_bucket('01:00:00'::interval, _hyper_8_2343_chunk_2.finish), '01:00:00'::interval)"], "Shared Hit Blocks": 135022, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Nested Loop", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Join Type": "Left", "Startup Cost": 9.54, "Total Cost": 8583.49, "Plan Rows": 1, "Plan Width": 63, "Actual Startup Time": 23.933, "Actual Total Time": 36806.789, "Actual Rows": 32352, "Actual Loops": 1, "Output": ["_hyper_8_2343_chunk_2.start", "_hyper_8_2343_chunk_2.finish", "_hyper_8_2343_chunk_2.simulationrunid", "_hyper_8_2343_chunk_2.componentid", "_hyper_8_2343_chunk_2.workorderid", "wo.workerid", "((sim_run_component_metadata_1.value)::timestamp with time zone)"], "Inner Unique": false, "Join Filter": "(((sim_run_component_metadata_1.generator)::text = (e_1.elementcreatedatcomponentid)::text) AND ((sim_run_component_metadata_1.component)::text = (_hyper_8_2343_chunk_2.componentid)::text))", "Rows Removed by Join Filter": 337204896, "Shared Hit Blocks": 135022, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Nested Loop", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Join Type": "Inner", "Startup Cost": 7.49, "Total Cost": 8581.41, "Plan Rows": 1, "Plan Width": 87, "Actual Startup Time": 2.429, "Actual Total Time": 242.277, "Actual Rows": 32352, "Actual Loops": 1, "Output": ["_hyper_8_2343_chunk_2.simulationrunid", "_hyper_8_2343_chunk_2.componentid", "_hyper_8_2343_chunk_2.workorderid", "_hyper_8_2343_chunk_2.start", "_hyper_8_2343_chunk_2.finish", "e_1.elementcreatedatcomponentid", "wo.workerid"], "Inner Unique": true, "Join Filter": "(wo.simulationrunid = e_1.simulationrunid)", "Rows Removed by Join Filter": 0, "Shared Hit Blocks": 134802, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Hash Join", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Join Type": "Inner", "Startup Cost": 7.06, "Total Cost": 8579.51, "Plan Rows": 1, "Plan Width": 68, "Actual Startup Time": 2.410, "Actual Total Time": 109.791, "Actual Rows": 32352, "Actual Loops": 1, "Output": ["_hyper_8_2343_chunk_2.simulationrunid", "_hyper_8_2343_chunk_2.componentid", "_hyper_8_2343_chunk_2.workorderid", "_hyper_8_2343_chunk_2.start", "_hyper_8_2343_chunk_2.finish", "e_1.simulationrunid", "e_1.elementcreatedatcomponentid"], "Inner Unique": false, "Hash Cond": "((_hyper_8_2343_chunk_2.simulationrunid = e_1.simulationrunid) AND ((_hyper_8_2343_chunk_2.elementid)::text = (e_1.elementid)::text))", "Shared Hit Blocks": 5394, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Incremental Sort", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 7.03, "Total Cost": 7987.51, "Plan Rows": 33826, "Plan Width": 98, "Actual Startup Time": 0.364, "Actual Total Time": 81.228, "Actual Rows": 32352, "Actual Loops": 1, "Output": ["_hyper_8_2343_chunk_2.simulationrunid", "_hyper_8_2343_chunk_2.componentid", "_hyper_8_2343_chunk_2.discriminator", "_hyper_8_2343_chunk_2.elementid", "_hyper_8_2343_chunk_2.workorderid", "_hyper_8_2343_chunk_2.start", "_hyper_8_2343_chunk_2.finish"], "Sort Key": ["_hyper_8_2343_chunk_2.componentid", "_hyper_8_2343_chunk_2.elementid", "_hyper_8_2343_chunk_2.workorderid", "_hyper_8_2343_chunk_2.start", "_hyper_8_2343_chunk_2.finish"], "Presorted Key": ["_hyper_8_2343_chunk_2.componentid"], "Full-sort Groups": { "Group Count": 127, "Sort Methods Used": ["quicksort"], "Sort Space Memory": { "Average Sort Space Used": 28, "Peak Sort Space Used": 28 } }, "Pre-sorted Groups": { "Group Count": 96, "Sort Methods Used": ["quicksort"], "Sort Space Memory": { "Average Sort Space Used": 60, "Peak Sort Space Used": 1175 } }, "Shared Hit Blocks": 5394, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Merge Append", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 4.74, "Total Cost": 6929.18, "Plan Rows": 33826, "Plan Width": 98, "Actual Startup Time": 0.296, "Actual Total Time": 18.604, "Actual Rows": 32352, "Actual Loops": 1, "Sort Key": ["_hyper_8_2343_chunk_2.componentid"], "Shared Hit Blocks": 5394, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Subplans Removed": 0, "Plans": [ { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2343_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2343_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2343_chunk_2", "Startup Cost": 0.29, "Total Cost": 459.19, "Plan Rows": 3187, "Plan Width": 93, "Actual Startup Time": 0.028, "Actual Total Time": 1.320, "Actual Rows": 3037, "Actual Loops": 1, "Output": ["_hyper_8_2343_chunk_2.simulationrunid", "_hyper_8_2343_chunk_2.componentid", "_hyper_8_2343_chunk_2.discriminator", "_hyper_8_2343_chunk_2.elementid", "_hyper_8_2343_chunk_2.workorderid", "_hyper_8_2343_chunk_2.start", "_hyper_8_2343_chunk_2.finish"], "Index Cond": "((_hyper_8_2343_chunk_2.simulationrunid = 325) AND ((_hyper_8_2343_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 507, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2344_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2344_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2344_chunk_2", "Startup Cost": 0.29, "Total Cost": 480.82, "Plan Rows": 3027, "Plan Width": 101, "Actual Startup Time": 0.014, "Actual Total Time": 1.454, "Actual Rows": 3037, "Actual Loops": 1, "Output": ["_hyper_8_2344_chunk_2.simulationrunid", "_hyper_8_2344_chunk_2.componentid", "_hyper_8_2344_chunk_2.discriminator", "_hyper_8_2344_chunk_2.elementid", "_hyper_8_2344_chunk_2.workorderid", "_hyper_8_2344_chunk_2.start", "_hyper_8_2344_chunk_2.finish"], "Index Cond": "((_hyper_8_2344_chunk_2.simulationrunid = 325) AND ((_hyper_8_2344_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 602, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2345_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2345_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2345_chunk_2", "Startup Cost": 0.13, "Total Cost": 2.35, "Plan Rows": 1, "Plan Width": 120, "Actual Startup Time": 0.006, "Actual Total Time": 0.007, "Actual Rows": 0, "Actual Loops": 1, "Output": ["_hyper_8_2345_chunk_2.simulationrunid", "_hyper_8_2345_chunk_2.componentid", "_hyper_8_2345_chunk_2.discriminator", "_hyper_8_2345_chunk_2.elementid", "_hyper_8_2345_chunk_2.workorderid", "_hyper_8_2345_chunk_2.start", "_hyper_8_2345_chunk_2.finish"], "Index Cond": "((_hyper_8_2345_chunk_2.simulationrunid = 325) AND ((_hyper_8_2345_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 1, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2346_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2346_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2346_chunk_2", "Startup Cost": 0.29, "Total Cost": 193.74, "Plan Rows": 452, "Plan Width": 96, "Actual Startup Time": 0.049, "Actual Total Time": 0.185, "Actual Rows": 531, "Actual Loops": 1, "Output": ["_hyper_8_2346_chunk_2.simulationrunid", "_hyper_8_2346_chunk_2.componentid", "_hyper_8_2346_chunk_2.discriminator", "_hyper_8_2346_chunk_2.elementid", "_hyper_8_2346_chunk_2.workorderid", "_hyper_8_2346_chunk_2.start", "_hyper_8_2346_chunk_2.finish"], "Index Cond": "((_hyper_8_2346_chunk_2.simulationrunid = 325) AND ((_hyper_8_2346_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 69, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2347_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2347_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2347_chunk_2", "Startup Cost": 0.29, "Total Cost": 436.66, "Plan Rows": 1940, "Plan Width": 94, "Actual Startup Time": 0.020, "Actual Total Time": 0.492, "Actual Rows": 1605, "Actual Loops": 1, "Output": ["_hyper_8_2347_chunk_2.simulationrunid", "_hyper_8_2347_chunk_2.componentid", "_hyper_8_2347_chunk_2.discriminator", "_hyper_8_2347_chunk_2.elementid", "_hyper_8_2347_chunk_2.workorderid", "_hyper_8_2347_chunk_2.start", "_hyper_8_2347_chunk_2.finish"], "Index Cond": "((_hyper_8_2347_chunk_2.simulationrunid = 325) AND ((_hyper_8_2347_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 164, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2348_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2348_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2348_chunk_2", "Startup Cost": 0.29, "Total Cost": 486.42, "Plan Rows": 2971, "Plan Width": 94, "Actual Startup Time": 0.020, "Actual Total Time": 1.178, "Actual Rows": 2717, "Actual Loops": 1, "Output": ["_hyper_8_2348_chunk_2.simulationrunid", "_hyper_8_2348_chunk_2.componentid", "_hyper_8_2348_chunk_2.discriminator", "_hyper_8_2348_chunk_2.elementid", "_hyper_8_2348_chunk_2.workorderid", "_hyper_8_2348_chunk_2.start", "_hyper_8_2348_chunk_2.finish"], "Index Cond": "((_hyper_8_2348_chunk_2.simulationrunid = 325) AND ((_hyper_8_2348_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 455, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2349_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2349_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2349_chunk_2", "Startup Cost": 0.29, "Total Cost": 535.58, "Plan Rows": 3031, "Plan Width": 95, "Actual Startup Time": 0.015, "Actual Total Time": 1.232, "Actual Rows": 3031, "Actual Loops": 1, "Output": ["_hyper_8_2349_chunk_2.simulationrunid", "_hyper_8_2349_chunk_2.componentid", "_hyper_8_2349_chunk_2.discriminator", "_hyper_8_2349_chunk_2.elementid", "_hyper_8_2349_chunk_2.workorderid", "_hyper_8_2349_chunk_2.start", "_hyper_8_2349_chunk_2.finish"], "Index Cond": "((_hyper_8_2349_chunk_2.simulationrunid = 325) AND ((_hyper_8_2349_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 486, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2350_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2350_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2350_chunk_2", "Startup Cost": 0.29, "Total Cost": 565.15, "Plan Rows": 3196, "Plan Width": 95, "Actual Startup Time": 0.012, "Actual Total Time": 1.306, "Actual Rows": 3167, "Actual Loops": 1, "Output": ["_hyper_8_2350_chunk_2.simulationrunid", "_hyper_8_2350_chunk_2.componentid", "_hyper_8_2350_chunk_2.discriminator", "_hyper_8_2350_chunk_2.elementid", "_hyper_8_2350_chunk_2.workorderid", "_hyper_8_2350_chunk_2.start", "_hyper_8_2350_chunk_2.finish"], "Index Cond": "((_hyper_8_2350_chunk_2.simulationrunid = 325) AND ((_hyper_8_2350_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 507, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2351_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2351_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2351_chunk_2", "Startup Cost": 0.29, "Total Cost": 291.14, "Plan Rows": 2059, "Plan Width": 93, "Actual Startup Time": 0.010, "Actual Total Time": 0.986, "Actual Rows": 2088, "Actual Loops": 1, "Output": ["_hyper_8_2351_chunk_2.simulationrunid", "_hyper_8_2351_chunk_2.componentid", "_hyper_8_2351_chunk_2.discriminator", "_hyper_8_2351_chunk_2.elementid", "_hyper_8_2351_chunk_2.workorderid", "_hyper_8_2351_chunk_2.start", "_hyper_8_2351_chunk_2.finish"], "Index Cond": "((_hyper_8_2351_chunk_2.simulationrunid = 325) AND ((_hyper_8_2351_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 382, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2352_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2352_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2352_chunk_2", "Startup Cost": 0.29, "Total Cost": 249.78, "Plan Rows": 656, "Plan Width": 105, "Actual Startup Time": 0.028, "Actual Total Time": 0.241, "Actual Rows": 614, "Actual Loops": 1, "Output": ["_hyper_8_2352_chunk_2.simulationrunid", "_hyper_8_2352_chunk_2.componentid", "_hyper_8_2352_chunk_2.discriminator", "_hyper_8_2352_chunk_2.elementid", "_hyper_8_2352_chunk_2.workorderid", "_hyper_8_2352_chunk_2.start", "_hyper_8_2352_chunk_2.finish"], "Index Cond": "((_hyper_8_2352_chunk_2.simulationrunid = 325) AND ((_hyper_8_2352_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 73, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2353_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2353_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2353_chunk_2", "Startup Cost": 0.29, "Total Cost": 412.22, "Plan Rows": 1856, "Plan Width": 102, "Actual Startup Time": 0.021, "Actual Total Time": 0.611, "Actual Rows": 1522, "Actual Loops": 1, "Output": ["_hyper_8_2353_chunk_2.simulationrunid", "_hyper_8_2353_chunk_2.componentid", "_hyper_8_2353_chunk_2.discriminator", "_hyper_8_2353_chunk_2.elementid", "_hyper_8_2353_chunk_2.workorderid", "_hyper_8_2353_chunk_2.start", "_hyper_8_2353_chunk_2.finish"], "Index Cond": "((_hyper_8_2353_chunk_2.simulationrunid = 325) AND ((_hyper_8_2353_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 165, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2354_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2354_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2354_chunk_2", "Startup Cost": 0.29, "Total Cost": 513.52, "Plan Rows": 3162, "Plan Width": 102, "Actual Startup Time": 0.014, "Actual Total Time": 1.198, "Actual Rows": 2717, "Actual Loops": 1, "Output": ["_hyper_8_2354_chunk_2.simulationrunid", "_hyper_8_2354_chunk_2.componentid", "_hyper_8_2354_chunk_2.discriminator", "_hyper_8_2354_chunk_2.elementid", "_hyper_8_2354_chunk_2.workorderid", "_hyper_8_2354_chunk_2.start", "_hyper_8_2354_chunk_2.finish"], "Index Cond": "((_hyper_8_2354_chunk_2.simulationrunid = 325) AND ((_hyper_8_2354_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 476, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2355_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2355_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2355_chunk_2", "Startup Cost": 0.29, "Total Cost": 561.23, "Plan Rows": 3031, "Plan Width": 103, "Actual Startup Time": 0.019, "Actual Total Time": 1.287, "Actual Rows": 3031, "Actual Loops": 1, "Output": ["_hyper_8_2355_chunk_2.simulationrunid", "_hyper_8_2355_chunk_2.componentid", "_hyper_8_2355_chunk_2.discriminator", "_hyper_8_2355_chunk_2.elementid", "_hyper_8_2355_chunk_2.workorderid", "_hyper_8_2355_chunk_2.start", "_hyper_8_2355_chunk_2.finish"], "Index Cond": "((_hyper_8_2355_chunk_2.simulationrunid = 325) AND ((_hyper_8_2355_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 520, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2356_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2356_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2356_chunk_2", "Startup Cost": 0.41, "Total Cost": 594.22, "Plan Rows": 3168, "Plan Width": 103, "Actual Startup Time": 0.012, "Actual Total Time": 1.371, "Actual Rows": 3167, "Actual Loops": 1, "Output": ["_hyper_8_2356_chunk_2.simulationrunid", "_hyper_8_2356_chunk_2.componentid", "_hyper_8_2356_chunk_2.discriminator", "_hyper_8_2356_chunk_2.elementid", "_hyper_8_2356_chunk_2.workorderid", "_hyper_8_2356_chunk_2.start", "_hyper_8_2356_chunk_2.finish"], "Index Cond": "((_hyper_8_2356_chunk_2.simulationrunid = 325) AND ((_hyper_8_2356_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 555, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2357_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2357_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2357_chunk_2", "Startup Cost": 0.29, "Total Cost": 299.43, "Plan Rows": 2088, "Plan Width": 100, "Actual Startup Time": 0.013, "Actual Total Time": 1.000, "Actual Rows": 2088, "Actual Loops": 1, "Output": ["_hyper_8_2357_chunk_2.simulationrunid", "_hyper_8_2357_chunk_2.componentid", "_hyper_8_2357_chunk_2.discriminator", "_hyper_8_2357_chunk_2.elementid", "_hyper_8_2357_chunk_2.workorderid", "_hyper_8_2357_chunk_2.start", "_hyper_8_2357_chunk_2.finish"], "Index Cond": "((_hyper_8_2357_chunk_2.simulationrunid = 325) AND ((_hyper_8_2357_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 431, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2358_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2358_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2358_chunk_2", "Startup Cost": 0.14, "Total Cost": 1.75, "Plan Rows": 1, "Plan Width": 100, "Actual Startup Time": 0.007, "Actual Total Time": 0.007, "Actual Rows": 0, "Actual Loops": 1, "Output": ["_hyper_8_2358_chunk_2.simulationrunid", "_hyper_8_2358_chunk_2.componentid", "_hyper_8_2358_chunk_2.discriminator", "_hyper_8_2358_chunk_2.elementid", "_hyper_8_2358_chunk_2.workorderid", "_hyper_8_2358_chunk_2.start", "_hyper_8_2358_chunk_2.finish"], "Index Cond": "((_hyper_8_2358_chunk_2.simulationrunid = 325) AND ((_hyper_8_2358_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 1, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 } ] } ] }, { "Node Type": "Hash", "Parent Relationship": "Inner", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 0.02, "Total Cost": 0.02, "Plan Rows": 1, "Plan Width": 68, "Actual Startup Time": 2.024, "Actual Total Time": 2.024, "Actual Rows": 8088, "Actual Loops": 1, "Output": ["e_1.simulationrunid", "e_1.elementid", "e_1.elementcreatedatcomponentid"], "Hash Buckets": 8192, "Original Hash Buckets": 1024, "Hash Batches": 1, "Original Hash Batches": 1, "Peak Memory Usage": 939, "Shared Hit Blocks": 0, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "CTE Scan", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "CTE Name": "filtered_elements", "Alias": "e_1", "Startup Cost": 0.00, "Total Cost": 0.02, "Plan Rows": 1, "Plan Width": 68, "Actual Startup Time": 0.002, "Actual Total Time": 0.627, "Actual Rows": 8088, "Actual Loops": 1, "Output": ["e_1.simulationrunid", "e_1.elementid", "e_1.elementcreatedatcomponentid"], "Shared Hit Blocks": 0, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 } ] } ] }, { "Node Type": "Index Scan", "Parent Relationship": "Inner", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "workorder_pkey", "Relation Name": "work_order", "Schema": "public", "Alias": "wo", "Startup Cost": 0.43, "Total Cost": 1.89, "Plan Rows": 1, "Plan Width": 39, "Actual Startup Time": 0.003, "Actual Total Time": 0.003, "Actual Rows": 1, "Actual Loops": 32352, "Output": ["wo.simulationrunid", "wo.componentid", "wo.workerid", "wo.workorderid", "wo.start", "wo.finish", "wo.lastupdate"], "Index Cond": "((wo.simulationrunid = _hyper_8_2343_chunk_2.simulationrunid) AND ((wo.componentid)::text = (_hyper_8_2343_chunk_2.componentid)::text) AND (wo.workorderid = _hyper_8_2343_chunk_2.workorderid))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 129408, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 } ] }, { "Node Type": "Sort", "Parent Relationship": "Inner", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 2.04, "Total Cost": 2.05, "Plan Rows": 1, "Plan Width": 51, "Actual Startup Time": 0.001, "Actual Total Time": 0.435, "Actual Rows": 10424, "Actual Loops": 32352, "Output": ["NULL::bigint", "sim_run_component_metadata_1.generator", "sim_run_component_metadata_1.component", "((sim_run_component_metadata_1.value)::timestamp with time zone)"], "Sort Key": ["sim_run_component_metadata_1.generator", "sim_run_component_metadata_1.component"], "Sort Method": "quicksort", "Sort Space Used": 1158, "Sort Space Type": "Memory", "Shared Hit Blocks": 220, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Index Scan", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "idx_simruncomponentmetadata_simrunid_key", "Relation Name": "sim_run_component_metadata", "Schema": "public", "Alias": "sim_run_component_metadata_1", "Startup Cost": 0.43, "Total Cost": 2.03, "Plan Rows": 1, "Plan Width": 51, "Actual Startup Time": 0.024, "Actual Total Time": 5.212, "Actual Rows": 10424, "Actual Loops": 1, "Output": ["NULL::bigint", "sim_run_component_metadata_1.generator", "sim_run_component_metadata_1.component", "(sim_run_component_metadata_1.value)::timestamp with time zone"], "Index Cond": "((sim_run_component_metadata_1.sim_run_id = 325) AND ((sim_run_component_metadata_1.key)::text = 'LATEST'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 220, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 } ] } ] } ] } ] } ] } ] } ] } ] } ] }, "Planning": { "Shared Hit Blocks": 675, "Shared Read Blocks": 1, "Shared Dirtied Blocks": 8, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, "Planning Time": 4.678, "Triggers": [ ], "Execution Time": 71423.588 } ]