[ { "Plan": { "Node Type": "Merge Join", "Parallel Aware": false, "Async Capable": false, "Join Type": "Full", "Startup Cost": 3315714.96, "Total Cost": 3372321.24, "Plan Rows": 3224500, "Plan Width": 145, "Actual Startup Time": 1418.822, "Actual Total Time": 1574.466, "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": 518429, "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": 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.049, "Actual Total Time": 2.162, "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": 3302155.33, "Total Cost": 3310216.58, "Plan Rows": 3224500, "Plan Width": 49, "Actual Startup Time": 417.820, "Actual Total Time": 420.555, "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": 47834, "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": "Left", "Startup Cost": 2246538.97, "Total Cost": 2889022.00, "Plan Rows": 3224500, "Plan Width": 49, "Actual Startup Time": 353.125, "Actual Total Time": 373.323, "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": 47834, "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": "Left", "Startup Cost": 2212020.99, "Total Cost": 2821452.26, "Plan Rows": 3224500, "Plan Width": 41, "Actual Startup Time": 310.984, "Actual Total Time": 321.349, "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": 29643, "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": "Aggregate", "Strategy": "Hashed", "Partial Mode": "Simple", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 2177500.37, "Total Cost": 2721634.74, "Plan Rows": 3224500, "Plan Width": 37, "Actual Startup Time": 269.908, "Actual Total Time": 276.294, "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": 9059, "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": 11.69, "Total Cost": 575326.93, "Plan Rows": 32245000, "Plan Width": 37, "Actual Startup Time": 0.723, "Actual Total Time": 217.724, "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": 9059, "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": 11.69, "Total Cost": 172264.43, "Plan Rows": 32245000, "Plan Width": 69, "Actual Startup Time": 0.721, "Actual Total Time": 196.393, "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": 9059, "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": 11.69, "Total Cost": 10313.92, "Plan Rows": 32245, "Plan Width": 90, "Actual Startup Time": 0.718, "Actual Total Time": 169.871, "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": 9059, "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": 8.68, "Total Cost": 9313.14, "Plan Rows": 32245, "Plan Width": 90, "Actual Startup Time": 0.455, "Actual Total Time": 115.181, "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": 9059, "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": 8.68, "Total Cost": 8748.85, "Plan Rows": 32245, "Plan Width": 82, "Actual Startup Time": 0.447, "Actual Total Time": 102.328, "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": 9059, "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.15, "Total Cost": 7748.07, "Plan Rows": 32245, "Plan Width": 82, "Actual Startup Time": 0.274, "Actual Total Time": 90.445, "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": 9059, "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.15, "Total Cost": 6135.82, "Plan Rows": 32245, "Plan Width": 99, "Actual Startup Time": 0.269, "Actual Total Time": 68.443, "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": 9059, "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.42, "Total Cost": 5135.04, "Plan Rows": 32245, "Plan Width": 99, "Actual Startup Time": 0.212, "Actual Total Time": 15.363, "Actual Rows": 32352, "Actual Loops": 1, "Sort Key": ["_hyper_8_2343_chunk.componentid"], "Shared Hit Blocks": 9059, "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": 333.53, "Plan Rows": 2198, "Plan Width": 93, "Actual Startup Time": 0.022, "Actual Total Time": 0.846, "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": 355.67, "Plan Rows": 2198, "Plan Width": 101, "Actual Startup Time": 0.017, "Actual Total Time": 0.924, "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.15, "Total Cost": 2.38, "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.28, "Total Cost": 130.09, "Plan Rows": 1158, "Plan Width": 96, "Actual Startup Time": 0.013, "Actual Total Time": 0.332, "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": 248.23, "Plan Rows": 2237, "Plan Width": 96, "Actual Startup Time": 0.014, "Actual Total Time": 0.741, "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": 361.20, "Plan Rows": 2758, "Plan Width": 94, "Actual Startup Time": 0.014, "Actual Total Time": 1.003, "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": 766, "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": 412.24, "Plan Rows": 3229, "Plan Width": 95, "Actual Startup Time": 0.015, "Actual Total Time": 1.069, "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": 434.74, "Plan Rows": 3438, "Plan Width": 95, "Actual Startup Time": 0.012, "Actual Total Time": 1.184, "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.28, "Total Cost": 204.09, "Plan Rows": 1131, "Plan Width": 92, "Actual Startup Time": 0.012, "Actual Total Time": 0.454, "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.28, "Total Cost": 143.32, "Plan Rows": 1283, "Plan Width": 105, "Actual Startup Time": 0.015, "Actual Total Time": 0.374, "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.28, "Total Cost": 247.69, "Plan Rows": 2154, "Plan Width": 104, "Actual Startup Time": 0.014, "Actual Total Time": 0.728, "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": 372.63, "Plan Rows": 2658, "Plan Width": 102, "Actual Startup Time": 0.017, "Actual Total Time": 1.014, "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": 431.85, "Plan Rows": 3233, "Plan Width": 103, "Actual Startup Time": 0.014, "Actual Total Time": 1.164, "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.29, "Total Cost": 455.91, "Plan Rows": 3438, "Plan Width": 103, "Actual Startup Time": 0.011, "Actual Total Time": 1.226, "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": 1018, "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.28, "Total Cost": 210.09, "Plan Rows": 1131, "Plan Width": 100, "Actual Startup Time": 0.011, "Actual Total Time": 0.472, "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": "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": 34520.55, "Total Cost": 34520.55, "Plan Rows": 5, "Plan Width": 39, "Actual Startup Time": 41.054, "Actual Total Time": 41.055, "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": 20584, "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": "sim_run_component_metadata_pkey", "Relation Name": "sim_run_component_metadata", "Schema": "public", "Alias": "lim_hard", "Startup Cost": 0.55, "Total Cost": 34520.55, "Plan Rows": 5, "Plan Width": 39, "Actual Startup Time": 17.106, "Actual Total Time": 40.070, "Actual Rows": 4385, "Actual Loops": 1, "Output": ["lim_hard.sim_run_id", "lim_hard.component", "lim_hard.value"], "Index Cond": "(((lim_hard.generator)::text = 'AREA_CAPACITY'::text) AND ((lim_hard.key)::text = 'HARD'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 20584, "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": 34517.96, "Total Cost": 34517.96, "Plan Rows": 1, "Plan Width": 39, "Actual Startup Time": 42.105, "Actual Total Time": 42.105, "Actual Rows": 2400, "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": 149, "Shared Hit Blocks": 18191, "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": "sim_run_component_metadata_pkey", "Relation Name": "sim_run_component_metadata", "Schema": "public", "Alias": "lim_soft", "Startup Cost": 0.55, "Total Cost": 34517.96, "Plan Rows": 1, "Plan Width": 39, "Actual Startup Time": 15.976, "Actual Total Time": 41.597, "Actual Rows": 2400, "Actual Loops": 1, "Output": ["lim_soft.sim_run_id", "lim_soft.component", "lim_soft.value"], "Index Cond": "(((lim_soft.generator)::text = 'AREA_CAPACITY'::text) AND ((lim_soft.key)::text = 'SOFT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 18191, "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": 13556.99, "Total Cost": 13724.50, "Plan Rows": 1000, "Plan Width": 125, "Actual Startup Time": 1000.991, "Actual Total Time": 1134.176, "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": 470595, "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": 1933, "Temp Written Blocks": 1934, "Plans": [ { "Node Type": "Merge Join", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Join Type": "Left", "Startup Cost": 13556.99, "Total Cost": 13722.00, "Plan Rows": 1000, "Plan Width": 125, "Actual Startup Time": 1000.974, "Actual Total Time": 1125.589, "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": 470595, "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": 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": 6769.92, "Total Cost": 6839.92, "Plan Rows": 1000, "Plan Width": 61, "Actual Startup Time": 651.551, "Actual Total Time": 755.979, "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": 174036, "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": 1933, "Temp Written Blocks": 1934, "Plans": [ { "Node Type": "Sort", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 6769.92, "Total Cost": 6772.42, "Plan Rows": 1000, "Plan Width": 45, "Actual Startup Time": 651.533, "Actual Total Time": 697.870, "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": 174036, "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": 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": 6.74, "Total Cost": 6720.09, "Plan Rows": 1000, "Plan Width": 45, "Actual Startup Time": 6.952, "Actual Total Time": 424.615, "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": 174036, "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": 6.74, "Total Cost": 6707.59, "Plan Rows": 1000, "Plan Width": 77, "Actual Startup Time": 6.950, "Actual Total Time": 395.509, "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)", "(m_latest.value)::timestamp with time zone"], "Shared Hit Blocks": 174036, "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": 6.74, "Total Cost": 6702.58, "Plan Rows": 1, "Plan Width": 49, "Actual Startup Time": 6.939, "Actual Total Time": 232.385, "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", "m_latest.value"], "Inner Unique": true, "Shared Hit Blocks": 174036, "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": 6.18, "Total Cost": 6699.80, "Plan Rows": 1, "Plan Width": 61, "Actual Startup Time": 6.916, "Actual Total Time": 102.883, "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": 12276, "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.15, "Total Cost": 6135.54, "Plan Rows": 32241, "Plan Width": 99, "Actual Startup Time": 0.275, "Actual Total Time": 79.464, "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": 9175, "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.42, "Total Cost": 5134.90, "Plan Rows": 32241, "Plan Width": 99, "Actual Startup Time": 0.209, "Actual Total Time": 19.280, "Actual Rows": 32352, "Actual Loops": 1, "Sort Key": ["_hyper_8_2343_chunk_1.componentid"], "Shared Hit Blocks": 9175, "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": 333.53, "Plan Rows": 2198, "Plan Width": 93, "Actual Startup Time": 0.022, "Actual Total Time": 1.163, "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": 355.67, "Plan Rows": 2198, "Plan Width": 101, "Actual Startup Time": 0.013, "Actual Total Time": 1.343, "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.15, "Total Cost": 2.38, "Plan Rows": 1, "Plan Width": 120, "Actual Startup Time": 0.008, "Actual Total Time": 0.008, "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.28, "Total Cost": 130.09, "Plan Rows": 1158, "Plan Width": 96, "Actual Startup Time": 0.012, "Actual Total Time": 0.371, "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": 248.23, "Plan Rows": 2237, "Plan Width": 96, "Actual Startup Time": 0.014, "Actual Total Time": 0.918, "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": 361.20, "Plan Rows": 2758, "Plan Width": 94, "Actual Startup Time": 0.014, "Actual Total Time": 1.254, "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": 775, "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": 412.20, "Plan Rows": 3225, "Plan Width": 95, "Actual Startup Time": 0.015, "Actual Total Time": 1.357, "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": 434.74, "Plan Rows": 3438, "Plan Width": 95, "Actual Startup Time": 0.012, "Actual Total Time": 1.493, "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.28, "Total Cost": 204.09, "Plan Rows": 1131, "Plan Width": 92, "Actual Startup Time": 0.011, "Actual Total Time": 0.566, "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.28, "Total Cost": 143.32, "Plan Rows": 1283, "Plan Width": 105, "Actual Startup Time": 0.016, "Actual Total Time": 0.391, "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.28, "Total Cost": 247.69, "Plan Rows": 2154, "Plan Width": 104, "Actual Startup Time": 0.013, "Actual Total Time": 0.909, "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": 372.63, "Plan Rows": 2658, "Plan Width": 102, "Actual Startup Time": 0.015, "Actual Total Time": 1.275, "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": 431.85, "Plan Rows": 3233, "Plan Width": 103, "Actual Startup Time": 0.014, "Actual Total Time": 1.409, "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.29, "Total Cost": 455.91, "Plan Rows": 3438, "Plan Width": 103, "Actual Startup Time": 0.012, "Actual Total Time": 1.545, "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": 1037, "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.28, "Total Cost": 210.09, "Plan Rows": 1131, "Plan Width": 100, "Actual Startup Time": 0.014, "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": "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": 6.609, "Actual Total Time": 6.609, "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.052, "Actual Total Time": 4.871, "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": "Index Scan", "Parent Relationship": "Inner", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "sim_run_component_metadata_pkey", "Relation Name": "sim_run_component_metadata", "Schema": "public", "Alias": "m_latest", "Startup Cost": 0.55, "Total Cost": 2.78, "Plan Rows": 1, "Plan Width": 63, "Actual Startup Time": 0.004, "Actual Total Time": 0.004, "Actual Rows": 1, "Actual Loops": 32352, "Output": ["m_latest.sim_run_id", "m_latest.generator", "m_latest.component", "m_latest.key", "m_latest.value"], "Index Cond": "((m_latest.sim_run_id = _hyper_8_2343_chunk_1.simulationrunid) AND ((m_latest.generator)::text = (e.elementcreatedatcomponentid)::text) AND ((m_latest.component)::text = (_hyper_8_2343_chunk_1.componentid)::text) AND ((m_latest.key)::text = 'LATEST'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 161760, "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": "Aggregate", "Strategy": "Sorted", "Partial Mode": "Simple", "Parent Relationship": "Inner", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 6787.07, "Total Cost": 6852.07, "Plan Rows": 1000, "Plan Width": 92, "Actual Startup Time": 349.418, "Actual Total Time": 365.068, "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": 296559, "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": 6787.07, "Total Cost": 6789.57, "Plan Rows": 1000, "Plan Width": 79, "Actual Startup Time": 349.381, "Actual Total Time": 351.239, "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": 296559, "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": 7.17, "Total Cost": 6737.24, "Plan Rows": 1000, "Plan Width": 79, "Actual Startup Time": 2.417, "Actual Total Time": 318.864, "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": 296559, "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": 7.17, "Total Cost": 6724.74, "Plan Rows": 1000, "Plan Width": 103, "Actual Startup Time": 2.415, "Actual Total Time": 314.453, "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", "(m_latest_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": 296559, "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": 7.17, "Total Cost": 6719.72, "Plan Rows": 1, "Plan Width": 75, "Actual Startup Time": 2.405, "Actual Total Time": 278.901, "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", "m_latest_1.value"], "Inner Unique": true, "Shared Hit Blocks": 296559, "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.62, "Total Cost": 6716.94, "Plan Rows": 1, "Plan Width": 87, "Actual Startup Time": 2.385, "Actual Total Time": 165.476, "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": 134799, "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": 6.19, "Total Cost": 6715.01, "Plan Rows": 1, "Plan Width": 68, "Actual Startup Time": 2.369, "Actual Total Time": 85.057, "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": 5391, "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.15, "Total Cost": 6147.85, "Plan Rows": 32407, "Plan Width": 98, "Actual Startup Time": 0.358, "Actual Total Time": 70.113, "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": 5391, "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.42, "Total Cost": 5141.20, "Plan Rows": 32407, "Plan Width": 98, "Actual Startup Time": 0.291, "Actual Total Time": 14.779, "Actual Rows": 32352, "Actual Loops": 1, "Sort Key": ["_hyper_8_2343_chunk_2.componentid"], "Shared Hit Blocks": 5391, "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": 350.18, "Plan Rows": 3019, "Plan Width": 93, "Actual Startup Time": 0.026, "Actual Total Time": 0.998, "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": 372.28, "Plan Rows": 3016, "Plan Width": 101, "Actual Startup Time": 0.016, "Actual Total Time": 1.094, "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.15, "Total Cost": 2.38, "Plan Rows": 1, "Plan Width": 120, "Actual Startup Time": 0.008, "Actual Total Time": 0.008, "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.28, "Total Cost": 117.76, "Plan Rows": 544, "Plan Width": 96, "Actual Startup Time": 0.050, "Actual Total Time": 0.182, "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": 235.16, "Plan Rows": 1605, "Plan Width": 96, "Actual Startup Time": 0.018, "Actual Total Time": 0.447, "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": 360.23, "Plan Rows": 2717, "Plan Width": 94, "Actual Startup Time": 0.016, "Actual Total Time": 0.901, "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": 454, "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": 408.01, "Plan Rows": 3031, "Plan Width": 95, "Actual Startup Time": 0.015, "Actual Total Time": 0.994, "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": 429.78, "Plan Rows": 3167, "Plan Width": 95, "Actual Startup Time": 0.012, "Actual Total Time": 1.022, "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.28, "Total Cost": 223.22, "Plan Rows": 2088, "Plan Width": 92, "Actual Startup Time": 0.013, "Actual Total Time": 0.700, "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.28, "Total Cost": 129.32, "Plan Rows": 614, "Plan Width": 105, "Actual Startup Time": 0.029, "Actual Total Time": 0.199, "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.28, "Total Cost": 234.62, "Plan Rows": 1522, "Plan Width": 104, "Actual Startup Time": 0.019, "Actual Total Time": 0.458, "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": 375.14, "Plan Rows": 2797, "Plan Width": 102, "Actual Startup Time": 0.016, "Actual Total Time": 0.960, "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": 427.58, "Plan Rows": 3031, "Plan Width": 103, "Actual Startup Time": 0.019, "Actual Total Time": 1.049, "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.29, "Total Cost": 450.38, "Plan Rows": 3167, "Plan Width": 103, "Actual Startup Time": 0.014, "Actual Total Time": 1.100, "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": 554, "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.28, "Total Cost": 229.78, "Plan Rows": 2088, "Plan Width": 100, "Actual Startup Time": 0.013, "Actual Total Time": 0.761, "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": "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": 1.993, "Actual Total Time": 1.994, "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.001, "Actual Total Time": 0.622, "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.91, "Plan Rows": 1, "Plan Width": 39, "Actual Startup Time": 0.002, "Actual Total Time": 0.002, "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": "Index Scan", "Parent Relationship": "Inner", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "sim_run_component_metadata_pkey", "Relation Name": "sim_run_component_metadata", "Schema": "public", "Alias": "m_latest_1", "Startup Cost": 0.55, "Total Cost": 2.78, "Plan Rows": 1, "Plan Width": 63, "Actual Startup Time": 0.003, "Actual Total Time": 0.003, "Actual Rows": 1, "Actual Loops": 32352, "Output": ["m_latest_1.sim_run_id", "m_latest_1.generator", "m_latest_1.component", "m_latest_1.key", "m_latest_1.value"], "Index Cond": "((m_latest_1.sim_run_id = _hyper_8_2343_chunk_2.simulationrunid) AND ((m_latest_1.generator)::text = (e_1.elementcreatedatcomponentid)::text) AND ((m_latest_1.component)::text = (_hyper_8_2343_chunk_2.componentid)::text) AND ((m_latest_1.key)::text = 'LATEST'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 161760, "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": 578, "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 Time": 4.790, "Triggers": [ ], "Execution Time": 1580.826 } ]