[ { "Plan": { "Node Type": "Merge Join", "Parallel Aware": false, "Async Capable": false, "Join Type": "Full", "Startup Cost": 3315711.62, "Total Cost": 3372317.90, "Plan Rows": 3224500, "Plan Width": 145, "Actual Startup Time": 83695.419, "Actual Total Time": 83852.036, "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": 205432, "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.028, "Actual Total Time": 1.897, "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": "Index Scan", "Parent Relationship": "InitPlan", "Subplan Name": "CTE filtered_component_metadata", "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": "sim_run_component_metadata", "Startup Cost": 0.55, "Total Cost": 2.16, "Plan Rows": 1, "Plan Width": 51, "Actual Startup Time": 0.024, "Actual Total Time": 7.895, "Actual Rows": 10424, "Actual Loops": 1, "Output": ["sim_run_component_metadata.sim_run_id", "sim_run_component_metadata.generator", "sim_run_component_metadata.component", "(sim_run_component_metadata.value)::timestamp with time zone"], "Index Cond": "((sim_run_component_metadata.sim_run_id = 325) AND ((sim_run_component_metadata.key)::text = 'LATEST'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 10523, "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": 400.037, "Actual Total Time": 402.998, "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": 345.113, "Actual Total Time": 363.803, "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": 307.911, "Actual Total Time": 317.418, "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": 268.177, "Actual Total Time": 273.911, "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.698, "Actual Total Time": 217.318, "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.697, "Actual Total Time": 195.835, "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.692, "Actual Total Time": 169.510, "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.442, "Actual Total Time": 115.258, "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.434, "Actual Total Time": 102.285, "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.257, "Actual Total Time": 90.402, "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.253, "Actual Total Time": 68.340, "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.196, "Actual Total Time": 15.199, "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.018, "Actual Total Time": 0.823, "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.015, "Actual Total Time": 0.913, "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.007, "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.011, "Actual Total Time": 0.334, "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.730, "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.013, "Actual Total Time": 0.969, "Actual Rows": 2758, "Actual Loops": 1, "Output": ["_hyper_8_2348_chunk.simulationrunid", "_hyper_8_2348_chunk.componentid", "_hyper_8_2348_chunk.discriminator", "_hyper_8_2348_chunk.elementid", "_hyper_8_2348_chunk.workorderid", "_hyper_8_2348_chunk.start", "_hyper_8_2348_chunk.finish"], "Index Cond": "((_hyper_8_2348_chunk.simulationrunid = 325) AND ((_hyper_8_2348_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 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.014, "Actual Total Time": 1.055, "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.010, "Actual Total Time": 1.167, "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.010, "Actual Total Time": 0.469, "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.366, "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.012, "Actual Total Time": 0.713, "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.013, "Actual Total Time": 0.995, "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.135, "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.013, "Actual Total Time": 1.217, "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.012, "Actual Total Time": 0.471, "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": 39.712, "Actual Total Time": 39.713, "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": 16.433, "Actual Total Time": 38.790, "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": 37.173, "Actual Total Time": 37.174, "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": 16.118, "Actual Total Time": 36.655, "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": 13551.49, "Total Cost": 13719.00, "Plan Rows": 1000, "Plan Width": 125, "Actual Startup Time": 83295.373, "Actual Total Time": 83429.186, "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": 157598, "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": 13551.49, "Total Cost": 13716.50, "Plan Rows": 1000, "Plan Width": 125, "Actual Startup Time": 83295.359, "Actual Total Time": 83420.747, "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": 157598, "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": 6767.18, "Total Cost": 6837.18, "Plan Rows": 1000, "Plan Width": 61, "Actual Startup Time": 41985.016, "Actual Total Time": 42089.712, "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": 22799, "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": 6767.18, "Total Cost": 6769.68, "Plan Rows": 1000, "Plan Width": 45, "Actual Startup Time": 41985.000, "Actual Total Time": 42031.929, "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": 22799, "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.18, "Total Cost": 6717.35, "Plan Rows": 1000, "Plan Width": 45, "Actual Startup Time": 9.034, "Actual Total Time": 41757.108, "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": 22799, "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.18, "Total Cost": 6704.85, "Plan Rows": 1000, "Plan Width": 77, "Actual Startup Time": 9.032, "Actual Total Time": 41730.925, "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.late_ref_time"], "Shared Hit Blocks": 22799, "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.18, "Total Cost": 6699.83, "Plan Rows": 1, "Plan Width": 37, "Actual Startup Time": 9.028, "Actual Total Time": 41693.405, "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.late_ref_time"], "Inner Unique": false, "Join Filter": "(((m_latest.generator)::text = (e.elementcreatedatcomponentid)::text) AND ((m_latest.component)::text = (_hyper_8_2343_chunk_1.componentid)::text))", "Rows Removed by Join Filter": 337204896, "Shared Hit Blocks": 22799, "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.266, "Actual Total Time": 114.290, "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.272, "Actual Total Time": 79.953, "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.207, "Actual Total Time": 19.657, "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.018, "Actual Total Time": 1.213, "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.014, "Actual Total Time": 1.339, "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.007, "Actual Total Time": 0.007, "Actual Rows": 0, "Actual Loops": 1, "Output": ["_hyper_8_2345_chunk_1.simulationrunid", "_hyper_8_2345_chunk_1.componentid", "_hyper_8_2345_chunk_1.discriminator", "_hyper_8_2345_chunk_1.elementid", "_hyper_8_2345_chunk_1.workorderid", "_hyper_8_2345_chunk_1.start", "_hyper_8_2345_chunk_1.finish"], "Index Cond": "((_hyper_8_2345_chunk_1.simulationrunid = 325) AND ((_hyper_8_2345_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 1, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2346_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2346_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2346_chunk_1", "Startup Cost": 0.28, "Total Cost": 130.09, "Plan Rows": 1158, "Plan Width": 96, "Actual Startup Time": 0.013, "Actual Total Time": 0.357, "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.015, "Actual Total Time": 0.935, "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.016, "Actual Total Time": 1.330, "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.013, "Actual Total Time": 1.383, "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.534, "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.010, "Actual Total Time": 0.536, "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.017, "Actual Total Time": 0.417, "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.016, "Actual Total Time": 0.925, "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.014, "Actual Total Time": 1.368, "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.473, "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.011, "Actual Total Time": 1.599, "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.013, "Actual Total Time": 0.631, "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": 5.972, "Actual Total Time": 5.972, "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.030, "Actual Total Time": 4.364, "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": "CTE Scan", "Parent Relationship": "Inner", "Parallel Aware": false, "Async Capable": false, "CTE Name": "filtered_component_metadata", "Alias": "m_latest", "Startup Cost": 0.00, "Total Cost": 0.02, "Plan Rows": 1, "Plan Width": 224, "Actual Startup Time": 0.000, "Actual Total Time": 0.608, "Actual Rows": 10424, "Actual Loops": 32352, "Output": ["m_latest.sim_run_id", "m_latest.generator", "m_latest.component", "m_latest.late_ref_time"], "Shared Hit Blocks": 10523, "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": 6784.32, "Total Cost": 6849.32, "Plan Rows": 1000, "Plan Width": 92, "Actual Startup Time": 41310.338, "Actual Total Time": 41326.684, "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": 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": "Sort", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 6784.32, "Total Cost": 6786.82, "Plan Rows": 1000, "Plan Width": 79, "Actual Startup Time": 41310.272, "Actual Total Time": 41312.120, "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": 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": "Subquery Scan", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Alias": "work_order_buckets", "Startup Cost": 6.62, "Total Cost": 6734.49, "Plan Rows": 1000, "Plan Width": 79, "Actual Startup Time": 2.607, "Actual Total Time": 41267.088, "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": 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": "ProjectSet", "Parent Relationship": "Subquery", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 6.62, "Total Cost": 6721.99, "Plan Rows": 1000, "Plan Width": 103, "Actual Startup Time": 2.606, "Actual Total Time": 41258.762, "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.late_ref_time", "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": 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": "Nested Loop", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Join Type": "Left", "Startup Cost": 6.62, "Total Cost": 6716.98, "Plan Rows": 1, "Plan Width": 63, "Actual Startup Time": 2.602, "Actual Total Time": 41232.818, "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.late_ref_time"], "Inner Unique": false, "Join Filter": "(((m_latest_1.generator)::text = (e_1.elementcreatedatcomponentid)::text) AND ((m_latest_1.component)::text = (_hyper_8_2343_chunk_2.componentid)::text))", "Rows Removed by Join Filter": 337204896, "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": "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.325, "Actual Total Time": 266.886, "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.303, "Actual Total Time": 112.879, "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": 80.753, "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.290, "Actual Total Time": 18.186, "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.030, "Actual Total Time": 1.290, "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.015, "Actual Total Time": 1.416, "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.007, "Actual Total Time": 0.007, "Actual Rows": 0, "Actual Loops": 1, "Output": ["_hyper_8_2345_chunk_2.simulationrunid", "_hyper_8_2345_chunk_2.componentid", "_hyper_8_2345_chunk_2.discriminator", "_hyper_8_2345_chunk_2.elementid", "_hyper_8_2345_chunk_2.workorderid", "_hyper_8_2345_chunk_2.start", "_hyper_8_2345_chunk_2.finish"], "Index Cond": "((_hyper_8_2345_chunk_2.simulationrunid = 325) AND ((_hyper_8_2345_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 1, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2346_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2346_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2346_chunk_2", "Startup Cost": 0.28, "Total Cost": 117.76, "Plan Rows": 544, "Plan Width": 96, "Actual Startup Time": 0.045, "Actual Total Time": 0.187, "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.017, "Actual Total Time": 0.489, "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.015, "Actual Total Time": 1.151, "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": 1.245, "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.015, "Actual Total Time": 1.287, "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.020, "Actual Total Time": 0.947, "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.030, "Actual Total Time": 0.203, "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.510, "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.014, "Actual Total Time": 1.198, "Actual Rows": 2717, "Actual Loops": 1, "Output": ["_hyper_8_2354_chunk_2.simulationrunid", "_hyper_8_2354_chunk_2.componentid", "_hyper_8_2354_chunk_2.discriminator", "_hyper_8_2354_chunk_2.elementid", "_hyper_8_2354_chunk_2.workorderid", "_hyper_8_2354_chunk_2.start", "_hyper_8_2354_chunk_2.finish"], "Index Cond": "((_hyper_8_2354_chunk_2.simulationrunid = 325) AND ((_hyper_8_2354_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 476, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2355_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2355_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2355_chunk_2", "Startup Cost": 0.29, "Total Cost": 427.58, "Plan Rows": 3031, "Plan Width": 103, "Actual Startup Time": 0.015, "Actual Total Time": 1.277, "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.012, "Actual Total Time": 1.342, "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.014, "Actual Total Time": 1.034, "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.930, "Actual Total Time": 1.931, "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.599, "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.004, "Actual Total Time": 0.004, "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": "CTE Scan", "Parent Relationship": "Inner", "Parallel Aware": false, "Async Capable": false, "CTE Name": "filtered_component_metadata", "Alias": "m_latest_1", "Startup Cost": 0.00, "Total Cost": 0.02, "Plan Rows": 1, "Plan Width": 224, "Actual Startup Time": 0.000, "Actual Total Time": 0.595, "Actual Rows": 10424, "Actual Loops": 32352, "Output": ["m_latest_1.sim_run_id", "m_latest_1.generator", "m_latest_1.component", "m_latest_1.late_ref_time"], "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 } ] } ] } ] } ] } ] } ] } ] } ] }, "Planning": { "Shared Hit Blocks": 581, "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.417, "Triggers": [ ], "Execution Time": 83858.322 } ]