[ { "Plan": { "Node Type": "Merge Join", "Parallel Aware": false, "Async Capable": false, "Join Type": "Full", "Startup Cost": 4316814.71, "Total Cost": 4389367.31, "Plan Rows": 4136000, "Plan Width": 146, "Actual Startup Time": 63919.385, "Actual Total Time": 63980.319, "Actual Rows": 28983, "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": 251140, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": "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": 10019.92, "Plan Rows": 10231, "Plan Width": 61, "Actual Startup Time": 0.033, "Actual Total Time": 2.353, "Actual Rows": 10152, "Actual Loops": 1, "Output": ["element.simulationrunid", "element.elementid", "element.elementcreatedatcomponentid"], "Index Cond": "(element.simulationrunid = 329)", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 3793, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": 11243.21, "Plan Rows": 12632, "Plan Width": 52, "Actual Startup Time": 0.042, "Actual Total Time": 11.026, "Actual Rows": 12632, "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 = 329) AND ((sim_run_component_metadata.key)::text = 'LATEST'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 12736, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": 4241479.22, "Total Cost": 4251819.22, "Plan Rows": 4136000, "Plan Width": 50, "Actual Startup Time": 477.686, "Actual Total Time": 480.592, "Actual Rows": 28983, "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": 2806, "Sort Space Type": "Memory", "Shared Hit Blocks": 53784, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": 2880036.42, "Total Cost": 3704135.31, "Plan Rows": 4136000, "Plan Width": 50, "Actual Startup Time": 419.508, "Actual Total Time": 439.454, "Actual Rows": 28983, "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": 53784, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": 2843147.87, "Total Cost": 3624852.32, "Plan Rows": 4136000, "Plan Width": 42, "Actual Startup Time": 378.369, "Actual Total Time": 388.550, "Actual Rows": 28983, "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": 32695, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": 2806258.38, "Total Cost": 3504208.38, "Plan Rows": 4136000, "Plan Width": 38, "Actual Startup Time": 336.154, "Actual Total Time": 342.257, "Actual Rows": 28983, "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": 11434, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": 29.10, "Total Cost": 751183.38, "Plan Rows": 41360000, "Plan Width": 38, "Actual Startup Time": 0.817, "Actual Total Time": 272.900, "Actual Rows": 327837, "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": 11434, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": 29.10, "Total Cost": 234183.38, "Plan Rows": 41360000, "Plan Width": 70, "Actual Startup Time": 0.816, "Actual Total Time": 248.204, "Actual Rows": 327837, "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": 11434, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": 29.10, "Total Cost": 26452.78, "Plan Rows": 41360, "Plan Width": 90, "Actual Startup Time": 0.812, "Actual Total Time": 215.414, "Actual Rows": 40608, "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": 176, "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": 71, "Peak Sort Space Used": 1535 } }, "Shared Hit Blocks": 11434, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": 21.25, "Total Cost": 25114.87, "Plan Rows": 41360, "Plan Width": 90, "Actual Startup Time": 0.558, "Actual Total Time": 146.460, "Actual Rows": 40608, "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": 11434, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": 21.25, "Total Cost": 24391.07, "Plan Rows": 41360, "Plan Width": 82, "Actual Startup Time": 0.548, "Actual Total Time": 130.109, "Actual Rows": 40608, "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": 176, "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": 73, "Peak Sort Space Used": 1614 } }, "Shared Hit Blocks": 11434, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": 14.02, "Total Cost": 23053.16, "Plan Rows": 41360, "Plan Width": 82, "Actual Startup Time": 0.364, "Actual Total Time": 114.701, "Actual Rows": 40608, "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": 11434, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": 14.02, "Total Cost": 20985.16, "Plan Rows": 41360, "Plan Width": 99, "Actual Startup Time": 0.360, "Actual Total Time": 86.677, "Actual Rows": 40608, "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": 176, "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": 73, "Peak Sort Space Used": 1614 } }, "Shared Hit Blocks": 11434, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": 7.83, "Total Cost": 19647.25, "Plan Rows": 41360, "Plan Width": 98, "Actual Startup Time": 0.302, "Actual Total Time": 19.615, "Actual Rows": 40608, "Actual Loops": 1, "Sort Key": ["_hyper_8_2343_chunk.componentid"], "Shared Hit Blocks": 11434, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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.41, "Total Cost": 1289.57, "Plan Rows": 2470, "Plan Width": 94, "Actual Startup Time": 0.021, "Actual Total Time": 0.864, "Actual Rows": 2180, "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 = 329) AND ((_hyper_8_2343_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 637, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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.41, "Total Cost": 1688.70, "Plan Rows": 2403, "Plan Width": 100, "Actual Startup Time": 0.017, "Actual Total Time": 1.051, "Actual Rows": 2180, "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 = 329) AND ((_hyper_8_2344_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 808, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": 1.75, "Plan Rows": 1, "Plan Width": 111, "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 = 329) 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.41, "Total Cost": 541.79, "Plan Rows": 2582, "Plan Width": 97, "Actual Startup Time": 0.046, "Actual Total Time": 0.730, "Actual Rows": 2561, "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 = 329) AND ((_hyper_8_2346_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 380, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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.41, "Total Cost": 1382.27, "Plan Rows": 5258, "Plan Width": 95, "Actual Startup Time": 0.013, "Actual Total Time": 1.774, "Actual Rows": 5000, "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 = 329) AND ((_hyper_8_2347_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 1466, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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.41, "Total Cost": 937.34, "Plan Rows": 2774, "Plan Width": 94, "Actual Startup Time": 0.015, "Actual Total Time": 0.993, "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 = 329) AND ((_hyper_8_2348_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 737, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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.41, "Total Cost": 1006.74, "Plan Rows": 3230, "Plan Width": 95, "Actual Startup Time": 0.013, "Actual Total Time": 1.105, "Actual Rows": 3235, "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 = 329) AND ((_hyper_8_2349_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 857, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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.41, "Total Cost": 1039.01, "Plan Rows": 3427, "Plan Width": 95, "Actual Startup Time": 0.014, "Actual Total Time": 1.198, "Actual Rows": 3439, "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 = 329) AND ((_hyper_8_2350_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 907, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2351_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2351_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2351_chunk", "Startup Cost": 0.29, "Total Cost": 380.41, "Plan Rows": 1142, "Plan Width": 93, "Actual Startup Time": 0.013, "Actual Total Time": 0.457, "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 = 329) AND ((_hyper_8_2351_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 384, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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.41, "Total Cost": 1340.86, "Plan Rows": 3504, "Plan Width": 104, "Actual Startup Time": 0.016, "Actual Total Time": 1.030, "Actual Rows": 3551, "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 = 329) AND ((_hyper_8_2352_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 723, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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.41, "Total Cost": 2439.73, "Plan Rows": 4139, "Plan Width": 101, "Actual Startup Time": 0.016, "Actual Total Time": 1.487, "Actual Rows": 4010, "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 = 329) AND ((_hyper_8_2353_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 1310, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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.41, "Total Cost": 1730.66, "Plan Rows": 2709, "Plan Width": 100, "Actual Startup Time": 0.014, "Actual Total Time": 1.037, "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 = 329) AND ((_hyper_8_2354_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 796, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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.41, "Total Cost": 1972.41, "Plan Rows": 3229, "Plan Width": 102, "Actual Startup Time": 0.019, "Actual Total Time": 1.230, "Actual Rows": 3235, "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 = 329) AND ((_hyper_8_2355_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 966, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2356_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2356_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2356_chunk", "Startup Cost": 0.41, "Total Cost": 2050.56, "Plan Rows": 3356, "Plan Width": 102, "Actual Startup Time": 0.015, "Actual Total Time": 1.255, "Actual Rows": 3439, "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 = 329) AND ((_hyper_8_2356_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 1013, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2357_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2357_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2357_chunk", "Startup Cost": 0.29, "Total Cost": 718.59, "Plan Rows": 1130, "Plan Width": 97, "Actual Startup Time": 0.011, "Actual Total Time": 0.526, "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 = 329) AND ((_hyper_8_2357_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 437, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2358_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2358_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2358_chunk", "Startup Cost": 0.27, "Total Cost": 1.87, "Plan Rows": 1, "Plan Width": 100, "Actual Startup Time": 0.008, "Actual Total Time": 0.009, "Actual Rows": 0, "Actual Loops": 1, "Output": ["_hyper_8_2358_chunk.simulationrunid", "_hyper_8_2358_chunk.componentid", "_hyper_8_2358_chunk.discriminator", "_hyper_8_2358_chunk.elementid", "_hyper_8_2358_chunk.workorderid", "_hyper_8_2358_chunk.start", "_hyper_8_2358_chunk.finish"], "Index Cond": "((_hyper_8_2358_chunk.simulationrunid = 329) AND ((_hyper_8_2358_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 2, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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_2363_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2363_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2363_chunk", "Startup Cost": 0.28, "Total Cost": 1.88, "Plan Rows": 1, "Plan Width": 108, "Actual Startup Time": 0.008, "Actual Total Time": 0.008, "Actual Rows": 0, "Actual Loops": 1, "Output": ["_hyper_8_2363_chunk.simulationrunid", "_hyper_8_2363_chunk.componentid", "_hyper_8_2363_chunk.discriminator", "_hyper_8_2363_chunk.elementid", "_hyper_8_2363_chunk.workorderid", "_hyper_8_2363_chunk.start", "_hyper_8_2363_chunk.finish"], "Index Cond": "((_hyper_8_2363_chunk.simulationrunid = 329) AND ((_hyper_8_2363_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 2, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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_2364_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2364_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2364_chunk", "Startup Cost": 0.28, "Total Cost": 1.88, "Plan Rows": 1, "Plan Width": 110, "Actual Startup Time": 0.008, "Actual Total Time": 0.008, "Actual Rows": 0, "Actual Loops": 1, "Output": ["_hyper_8_2364_chunk.simulationrunid", "_hyper_8_2364_chunk.componentid", "_hyper_8_2364_chunk.discriminator", "_hyper_8_2364_chunk.elementid", "_hyper_8_2364_chunk.workorderid", "_hyper_8_2364_chunk.start", "_hyper_8_2364_chunk.finish"], "Index Cond": "((_hyper_8_2364_chunk.simulationrunid = 329) AND ((_hyper_8_2364_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 2, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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_2365_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2365_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2365_chunk", "Startup Cost": 0.28, "Total Cost": 1.88, "Plan Rows": 1, "Plan Width": 111, "Actual Startup Time": 0.009, "Actual Total Time": 0.009, "Actual Rows": 0, "Actual Loops": 1, "Output": ["_hyper_8_2365_chunk.simulationrunid", "_hyper_8_2365_chunk.componentid", "_hyper_8_2365_chunk.discriminator", "_hyper_8_2365_chunk.elementid", "_hyper_8_2365_chunk.workorderid", "_hyper_8_2365_chunk.start", "_hyper_8_2365_chunk.finish"], "Index Cond": "((_hyper_8_2365_chunk.simulationrunid = 329) AND ((_hyper_8_2365_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 2, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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_2366_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2366_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2366_chunk", "Startup Cost": 0.28, "Total Cost": 1.88, "Plan Rows": 1, "Plan Width": 111, "Actual Startup Time": 0.007, "Actual Total Time": 0.008, "Actual Rows": 0, "Actual Loops": 1, "Output": ["_hyper_8_2366_chunk.simulationrunid", "_hyper_8_2366_chunk.componentid", "_hyper_8_2366_chunk.discriminator", "_hyper_8_2366_chunk.elementid", "_hyper_8_2366_chunk.workorderid", "_hyper_8_2366_chunk.start", "_hyper_8_2366_chunk.finish"], "Index Cond": "((_hyper_8_2366_chunk.simulationrunid = 329) AND ((_hyper_8_2366_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 2, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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_2367_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2367_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2367_chunk", "Startup Cost": 0.28, "Total Cost": 1.88, "Plan Rows": 1, "Plan Width": 111, "Actual Startup Time": 0.007, "Actual Total Time": 0.007, "Actual Rows": 0, "Actual Loops": 1, "Output": ["_hyper_8_2367_chunk.simulationrunid", "_hyper_8_2367_chunk.componentid", "_hyper_8_2367_chunk.discriminator", "_hyper_8_2367_chunk.elementid", "_hyper_8_2367_chunk.workorderid", "_hyper_8_2367_chunk.start", "_hyper_8_2367_chunk.finish"], "Index Cond": "((_hyper_8_2367_chunk.simulationrunid = 329) AND ((_hyper_8_2367_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 2, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": 40608, "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": 36889.18, "Total Cost": 36889.18, "Plan Rows": 21, "Plan Width": 39, "Actual Startup Time": 42.185, "Actual Total Time": 42.186, "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": 21261, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": 36889.18, "Plan Rows": 21, "Plan Width": 39, "Actual Startup Time": 16.372, "Actual Total Time": 41.220, "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": 21261, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": 36888.25, "Total Cost": 36888.25, "Plan Rows": 20, "Plan Width": 39, "Actual Startup Time": 41.114, "Actual Total Time": 41.114, "Actual Rows": 4256, "Actual Loops": 1, "Output": ["lim_soft.sim_run_id", "lim_soft.component", "lim_soft.value"], "Hash Buckets": 8192, "Original Hash Buckets": 1024, "Hash Batches": 1, "Original Hash Batches": 1, "Peak Memory Usage": 272, "Shared Hit Blocks": 21089, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": 36888.25, "Plan Rows": 20, "Plan Width": 39, "Actual Startup Time": 17.130, "Actual Total Time": 40.249, "Actual Rows": 4256, "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": 21089, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": 54072.36, "Total Cost": 54209.87, "Plan Rows": 3500, "Plan Width": 126, "Actual Startup Time": 63441.690, "Actual Total Time": 63480.519, "Actual Rows": 28983, "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": 197356, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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 Join", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Join Type": "Left", "Startup Cost": 54072.36, "Total Cost": 54201.12, "Plan Rows": 3500, "Plan Width": 126, "Actual Startup Time": 63441.678, "Actual Total Time": 63471.123, "Actual Rows": 28983, "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": 197356, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": 29026.60, "Total Cost": 29035.35, "Plan Rows": 3500, "Plan Width": 62, "Actual Startup Time": 426.916, "Actual Total Time": 429.971, "Actual Rows": 28983, "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))"], "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": "quicksort", "Sort Space Used": 3259, "Sort Space Type": "Memory", "Shared Hit Blocks": 28055, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": 28776.82, "Total Cost": 28820.57, "Plan Rows": 3500, "Plan Width": 62, "Actual Startup Time": 386.638, "Actual Total Time": 392.759, "Actual Rows": 28983, "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)"], "Planned Partitions": 0, "HashAgg Batches": 1, "Peak Memory Usage": 5649, "Disk Usage": 0, "Shared Hit Blocks": 28055, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": "lu_holding_buckets", "Startup Cost": 25796.75, "Total Cost": 26851.82, "Plan Rows": 35000, "Plan Width": 46, "Actual Startup Time": 209.159, "Actual Total Time": 294.355, "Actual Rows": 328018, "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": 28055, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": 25796.75, "Total Cost": 26414.32, "Plan Rows": 35000, "Plan Width": 78, "Actual Startup Time": 209.158, "Actual Total Time": 267.578, "Actual Rows": 328018, "Actual Loops": 1, "Output": ["lwt.simulationrunid", "lwt.componentid", "NULL::character varying", "NULL::timestamp with time zone", "lwt.finish", "generate_series(time_bucket('01:00:00'::interval, lwt.start), time_bucket('01:00:00'::interval, lwt.finish), '01:00:00'::interval)", "m_latest.late_ref_time"], "Shared Hit Blocks": 28055, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": "Right", "Startup Cost": 25796.75, "Total Cost": 26238.88, "Plan Rows": 35, "Plan Width": 38, "Actual Startup Time": 209.152, "Actual Total Time": 237.215, "Actual Rows": 40608, "Actual Loops": 1, "Output": ["lwt.start", "lwt.finish", "lwt.simulationrunid", "lwt.componentid", "m_latest.late_ref_time"], "Inner Unique": false, "Hash Cond": "(((m_latest.generator)::text = (e.elementcreatedatcomponentid)::text) AND ((m_latest.component)::text = (lwt.componentid)::text))", "Shared Hit Blocks": 28055, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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_component_metadata", "Alias": "m_latest", "Startup Cost": 0.00, "Total Cost": 252.64, "Plan Rows": 12632, "Plan Width": 224, "Actual Startup Time": 0.045, "Actual Total Time": 15.593, "Actual Rows": 12632, "Actual Loops": 1, "Output": ["m_latest.sim_run_id", "m_latest.generator", "m_latest.component", "m_latest.late_ref_time"], "Shared Hit Blocks": 12736, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": 25796.23, "Total Cost": 25796.23, "Plan Rows": 35, "Plan Width": 62, "Actual Startup Time": 209.088, "Actual Total Time": 209.097, "Actual Rows": 40608, "Actual Loops": 1, "Output": ["lwt.simulationrunid", "lwt.componentid", "lwt.finish", "lwt.start", "e.elementcreatedatcomponentid"], "Hash Buckets": 65536, "Original Hash Buckets": 1024, "Hash Batches": 1, "Original Hash Batches": 1, "Peak Memory Usage": 4345, "Shared Hit Blocks": 15319, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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 Join", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Join Type": "Inner", "Startup Cost": 25410.23, "Total Cost": 25796.23, "Plan Rows": 35, "Plan Width": 62, "Actual Startup Time": 179.668, "Actual Total Time": 197.480, "Actual Rows": 40608, "Actual Loops": 1, "Output": ["lwt.simulationrunid", "lwt.componentid", "lwt.finish", "lwt.start", "e.elementcreatedatcomponentid"], "Inner Unique": false, "Merge Cond": "((lwt.simulationrunid = e.simulationrunid) AND ((lwt.elementid)::text = (e.elementid)::text))", "Shared Hit Blocks": 15319, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": 24524.19, "Total Cost": 24627.16, "Plan Rows": 41189, "Plan Width": 70, "Actual Startup Time": 171.394, "Actual Total Time": 172.849, "Actual Rows": 40608, "Actual Loops": 1, "Output": ["lwt.simulationrunid", "lwt.componentid", "lwt.finish", "lwt.start", "lwt.elementid"], "Sort Key": ["lwt.simulationrunid", "lwt.elementid"], "Sort Method": "quicksort", "Sort Space Used": 5502, "Sort Space Type": "Memory", "Shared Hit Blocks": 11526, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": "lwt", "Startup Cost": 14.01, "Total Cost": 21367.06, "Plan Rows": 41189, "Plan Width": 70, "Actual Startup Time": 0.408, "Actual Total Time": 89.657, "Actual Rows": 40608, "Actual Loops": 1, "Output": ["lwt.simulationrunid", "lwt.componentid", "lwt.finish", "lwt.start", "lwt.elementid"], "Shared Hit Blocks": 11526, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": "Subquery", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 14.01, "Total Cost": 20955.17, "Plan Rows": 41189, "Plan Width": 99, "Actual Startup Time": 0.406, "Actual Total Time": 85.877, "Actual Rows": 40608, "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": 176, "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": 74, "Peak Sort Space Used": 1614 } }, "Shared Hit Blocks": 11526, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": 7.83, "Total Cost": 19623.75, "Plan Rows": 41189, "Plan Width": 98, "Actual Startup Time": 0.345, "Actual Total Time": 19.120, "Actual Rows": 40608, "Actual Loops": 1, "Sort Key": ["_hyper_8_2343_chunk_1.componentid"], "Shared Hit Blocks": 11526, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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.41, "Total Cost": 1289.76, "Plan Rows": 2489, "Plan Width": 94, "Actual Startup Time": 0.031, "Actual Total Time": 0.828, "Actual Rows": 2180, "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 = 329) AND ((_hyper_8_2343_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 658, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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.41, "Total Cost": 1676.76, "Plan Rows": 2369, "Plan Width": 100, "Actual Startup Time": 0.025, "Actual Total Time": 0.963, "Actual Rows": 2180, "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 = 329) AND ((_hyper_8_2344_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 807, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": 1.75, "Plan Rows": 1, "Plan Width": 111, "Actual Startup Time": 0.008, "Actual Total Time": 0.008, "Actual Rows": 0, "Actual Loops": 1, "Output": ["_hyper_8_2345_chunk_1.simulationrunid", "_hyper_8_2345_chunk_1.componentid", "_hyper_8_2345_chunk_1.discriminator", "_hyper_8_2345_chunk_1.elementid", "_hyper_8_2345_chunk_1.workorderid", "_hyper_8_2345_chunk_1.start", "_hyper_8_2345_chunk_1.finish"], "Index Cond": "((_hyper_8_2345_chunk_1.simulationrunid = 329) 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.41, "Total Cost": 541.79, "Plan Rows": 2582, "Plan Width": 97, "Actual Startup Time": 0.053, "Actual Total Time": 0.723, "Actual Rows": 2561, "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 = 329) AND ((_hyper_8_2346_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 385, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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.41, "Total Cost": 1379.01, "Plan Rows": 5127, "Plan Width": 95, "Actual Startup Time": 0.015, "Actual Total Time": 1.717, "Actual Rows": 5000, "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 = 329) AND ((_hyper_8_2347_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 1488, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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.41, "Total Cost": 937.31, "Plan Rows": 2771, "Plan Width": 94, "Actual Startup Time": 0.017, "Actual Total Time": 0.940, "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 = 329) AND ((_hyper_8_2348_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 730, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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.41, "Total Cost": 1006.08, "Plan Rows": 3212, "Plan Width": 95, "Actual Startup Time": 0.015, "Actual Total Time": 1.078, "Actual Rows": 3235, "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 = 329) AND ((_hyper_8_2349_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 864, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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.41, "Total Cost": 1038.98, "Plan Rows": 3424, "Plan Width": 95, "Actual Startup Time": 0.013, "Actual Total Time": 1.160, "Actual Rows": 3439, "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 = 329) AND ((_hyper_8_2350_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 914, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2351_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2351_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2351_chunk_1", "Startup Cost": 0.29, "Total Cost": 380.41, "Plan Rows": 1142, "Plan Width": 93, "Actual Startup Time": 0.012, "Actual Total Time": 0.448, "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 = 329) AND ((_hyper_8_2351_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 396, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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.41, "Total Cost": 1340.86, "Plan Rows": 3504, "Plan Width": 104, "Actual Startup Time": 0.019, "Actual Total Time": 1.047, "Actual Rows": 3551, "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 = 329) AND ((_hyper_8_2352_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 738, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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.41, "Total Cost": 2439.80, "Plan Rows": 4146, "Plan Width": 101, "Actual Startup Time": 0.015, "Actual Total Time": 1.431, "Actual Rows": 4010, "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 = 329) AND ((_hyper_8_2353_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 1331, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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.41, "Total Cost": 1725.34, "Plan Rows": 2692, "Plan Width": 100, "Actual Startup Time": 0.014, "Actual Total Time": 1.023, "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 = 329) 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.41, "Total Cost": 1972.41, "Plan Rows": 3229, "Plan Width": 102, "Actual Startup Time": 0.012, "Actual Total Time": 1.163, "Actual Rows": 3235, "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 = 329) AND ((_hyper_8_2355_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 962, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2356_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2356_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2356_chunk_1", "Startup Cost": 0.41, "Total Cost": 2052.65, "Plan Rows": 3365, "Plan Width": 102, "Actual Startup Time": 0.016, "Actual Total Time": 1.210, "Actual Rows": 3439, "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 = 329) AND ((_hyper_8_2356_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 1010, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2357_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2357_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2357_chunk_1", "Startup Cost": 0.29, "Total Cost": 718.59, "Plan Rows": 1130, "Plan Width": 97, "Actual Startup Time": 0.012, "Actual Total Time": 0.499, "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 = 329) AND ((_hyper_8_2357_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 431, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2358_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2358_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2358_chunk_1", "Startup Cost": 0.27, "Total Cost": 1.87, "Plan Rows": 1, "Plan Width": 100, "Actual Startup Time": 0.009, "Actual Total Time": 0.009, "Actual Rows": 0, "Actual Loops": 1, "Output": ["_hyper_8_2358_chunk_1.simulationrunid", "_hyper_8_2358_chunk_1.componentid", "_hyper_8_2358_chunk_1.discriminator", "_hyper_8_2358_chunk_1.elementid", "_hyper_8_2358_chunk_1.workorderid", "_hyper_8_2358_chunk_1.start", "_hyper_8_2358_chunk_1.finish"], "Index Cond": "((_hyper_8_2358_chunk_1.simulationrunid = 329) AND ((_hyper_8_2358_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 2, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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_2363_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2363_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2363_chunk_1", "Startup Cost": 0.28, "Total Cost": 1.88, "Plan Rows": 1, "Plan Width": 108, "Actual Startup Time": 0.009, "Actual Total Time": 0.009, "Actual Rows": 0, "Actual Loops": 1, "Output": ["_hyper_8_2363_chunk_1.simulationrunid", "_hyper_8_2363_chunk_1.componentid", "_hyper_8_2363_chunk_1.discriminator", "_hyper_8_2363_chunk_1.elementid", "_hyper_8_2363_chunk_1.workorderid", "_hyper_8_2363_chunk_1.start", "_hyper_8_2363_chunk_1.finish"], "Index Cond": "((_hyper_8_2363_chunk_1.simulationrunid = 329) AND ((_hyper_8_2363_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 2, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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_2364_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2364_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2364_chunk_1", "Startup Cost": 0.28, "Total Cost": 1.88, "Plan Rows": 1, "Plan Width": 110, "Actual Startup Time": 0.010, "Actual Total Time": 0.011, "Actual Rows": 0, "Actual Loops": 1, "Output": ["_hyper_8_2364_chunk_1.simulationrunid", "_hyper_8_2364_chunk_1.componentid", "_hyper_8_2364_chunk_1.discriminator", "_hyper_8_2364_chunk_1.elementid", "_hyper_8_2364_chunk_1.workorderid", "_hyper_8_2364_chunk_1.start", "_hyper_8_2364_chunk_1.finish"], "Index Cond": "((_hyper_8_2364_chunk_1.simulationrunid = 329) AND ((_hyper_8_2364_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 2, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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_2365_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2365_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2365_chunk_1", "Startup Cost": 0.28, "Total Cost": 1.88, "Plan Rows": 1, "Plan Width": 111, "Actual Startup Time": 0.016, "Actual Total Time": 0.016, "Actual Rows": 0, "Actual Loops": 1, "Output": ["_hyper_8_2365_chunk_1.simulationrunid", "_hyper_8_2365_chunk_1.componentid", "_hyper_8_2365_chunk_1.discriminator", "_hyper_8_2365_chunk_1.elementid", "_hyper_8_2365_chunk_1.workorderid", "_hyper_8_2365_chunk_1.start", "_hyper_8_2365_chunk_1.finish"], "Index Cond": "((_hyper_8_2365_chunk_1.simulationrunid = 329) AND ((_hyper_8_2365_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 2, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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_2366_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2366_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2366_chunk_1", "Startup Cost": 0.28, "Total Cost": 1.88, "Plan Rows": 1, "Plan Width": 111, "Actual Startup Time": 0.008, "Actual Total Time": 0.008, "Actual Rows": 0, "Actual Loops": 1, "Output": ["_hyper_8_2366_chunk_1.simulationrunid", "_hyper_8_2366_chunk_1.componentid", "_hyper_8_2366_chunk_1.discriminator", "_hyper_8_2366_chunk_1.elementid", "_hyper_8_2366_chunk_1.workorderid", "_hyper_8_2366_chunk_1.start", "_hyper_8_2366_chunk_1.finish"], "Index Cond": "((_hyper_8_2366_chunk_1.simulationrunid = 329) AND ((_hyper_8_2366_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 2, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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_2367_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2367_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2367_chunk_1", "Startup Cost": 0.28, "Total Cost": 1.88, "Plan Rows": 1, "Plan Width": 111, "Actual Startup Time": 0.008, "Actual Total Time": 0.008, "Actual Rows": 0, "Actual Loops": 1, "Output": ["_hyper_8_2367_chunk_1.simulationrunid", "_hyper_8_2367_chunk_1.componentid", "_hyper_8_2367_chunk_1.discriminator", "_hyper_8_2367_chunk_1.elementid", "_hyper_8_2367_chunk_1.workorderid", "_hyper_8_2367_chunk_1.start", "_hyper_8_2367_chunk_1.finish"], "Index Cond": "((_hyper_8_2367_chunk_1.simulationrunid = 329) AND ((_hyper_8_2367_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 2, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 } ] } ] } ] } ] }, { "Node Type": "Sort", "Parent Relationship": "Inner", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 886.04, "Total Cost": 911.62, "Plan Rows": 10231, "Plan Width": 68, "Actual Startup Time": 8.266, "Actual Total Time": 9.609, "Actual Rows": 40605, "Actual Loops": 1, "Output": ["e.simulationrunid", "e.elementid", "e.elementcreatedatcomponentid"], "Sort Key": ["e.simulationrunid", "e.elementid"], "Sort Method": "quicksort", "Sort Space Used": 1416, "Sort Space Type": "Memory", "Shared Hit Blocks": 3793, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": 204.62, "Plan Rows": 10231, "Plan Width": 68, "Actual Startup Time": 0.036, "Actual Total Time": 5.428, "Actual Rows": 10152, "Actual Loops": 1, "Output": ["e.simulationrunid", "e.elementid", "e.elementcreatedatcomponentid"], "Shared Hit Blocks": 3793, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": 25045.76, "Total Cost": 25110.76, "Plan Rows": 1000, "Plan Width": 93, "Actual Startup Time": 63014.755, "Actual Total Time": 63034.529, "Actual Rows": 2797, "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": 169301, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": 25045.76, "Total Cost": 25048.26, "Plan Rows": 1000, "Plan Width": 80, "Actual Startup Time": 63014.705, "Actual Total Time": 63017.331, "Actual Rows": 41001, "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": 6021, "Sort Space Type": "Memory", "Shared Hit Blocks": 169301, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": 24135.31, "Total Cost": 24995.93, "Plan Rows": 1000, "Plan Width": 80, "Actual Startup Time": 184.081, "Actual Total Time": 62950.708, "Actual Rows": 41001, "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": 169301, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": 24135.31, "Total Cost": 24983.43, "Plan Rows": 1000, "Plan Width": 104, "Actual Startup Time": 184.079, "Actual Total Time": 62938.512, "Actual Rows": 41001, "Actual Loops": 1, "Output": ["lwt_1.simulationrunid", "lwt_1.componentid", "NULL::character varying", "lwt_1.workorderid", "wo.workerid", "lwt_1.start", "lwt_1.finish", "m_latest_1.late_ref_time", "generate_series(time_bucket('01:00:00'::interval, lwt_1.start), time_bucket('01:00:00'::interval, lwt_1.finish), '01:00:00'::interval)"], "Shared Hit Blocks": 169301, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": 24135.31, "Total Cost": 24978.41, "Plan Rows": 1, "Plan Width": 64, "Actual Startup Time": 184.074, "Actual Total Time": 62902.951, "Actual Rows": 40608, "Actual Loops": 1, "Output": ["lwt_1.start", "lwt_1.finish", "lwt_1.simulationrunid", "lwt_1.componentid", "lwt_1.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 = (lwt_1.componentid)::text))", "Rows Removed by Join Filter": 512919648, "Shared Hit Blocks": 169301, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": 24135.31, "Total Cost": 24536.29, "Plan Rows": 1, "Plan Width": 88, "Actual Startup Time": 184.070, "Actual Total Time": 461.083, "Actual Rows": 40608, "Actual Loops": 1, "Output": ["lwt_1.simulationrunid", "lwt_1.componentid", "lwt_1.workorderid", "lwt_1.start", "lwt_1.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": 169301, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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 Join", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Join Type": "Inner", "Startup Cost": 24134.88, "Total Cost": 24479.92, "Plan Rows": 30, "Plan Width": 69, "Actual Startup Time": 184.037, "Actual Total Time": 236.664, "Actual Rows": 40608, "Actual Loops": 1, "Output": ["lwt_1.simulationrunid", "lwt_1.componentid", "lwt_1.workorderid", "lwt_1.start", "lwt_1.finish", "e_1.simulationrunid", "e_1.elementcreatedatcomponentid"], "Inner Unique": false, "Merge Cond": "((lwt_1.simulationrunid = e_1.simulationrunid) AND ((lwt_1.elementid)::text = (e_1.elementid)::text))", "Shared Hit Blocks": 6869, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": 23248.85, "Total Cost": 23338.18, "Plan Rows": 35734, "Plan Width": 73, "Actual Startup Time": 180.487, "Actual Total Time": 187.474, "Actual Rows": 40608, "Actual Loops": 1, "Output": ["lwt_1.simulationrunid", "lwt_1.componentid", "lwt_1.workorderid", "lwt_1.start", "lwt_1.finish", "lwt_1.elementid"], "Sort Key": ["lwt_1.simulationrunid", "lwt_1.elementid"], "Sort Method": "quicksort", "Sort Space Used": 5598, "Sort Space Type": "Memory", "Shared Hit Blocks": 6869, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": "lwt_1", "Startup Cost": 13.80, "Total Cost": 20546.46, "Plan Rows": 35734, "Plan Width": 73, "Actual Startup Time": 0.563, "Actual Total Time": 96.251, "Actual Rows": 40608, "Actual Loops": 1, "Output": ["lwt_1.simulationrunid", "lwt_1.componentid", "lwt_1.workorderid", "lwt_1.start", "lwt_1.finish", "lwt_1.elementid"], "Shared Hit Blocks": 6869, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": "Subquery", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 13.80, "Total Cost": 20189.12, "Plan Rows": 35734, "Plan Width": 98, "Actual Startup Time": 0.561, "Actual Total Time": 92.309, "Actual Rows": 40608, "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": 176, "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": 74, "Peak Sort Space Used": 1617 } }, "Shared Hit Blocks": 6869, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": 7.83, "Total Cost": 19061.93, "Plan Rows": 35734, "Plan Width": 98, "Actual Startup Time": 0.484, "Actual Total Time": 20.790, "Actual Rows": 40608, "Actual Loops": 1, "Sort Key": ["_hyper_8_2343_chunk_2.componentid"], "Shared Hit Blocks": 6869, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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.41, "Total Cost": 1293.52, "Plan Rows": 2749, "Plan Width": 94, "Actual Startup Time": 0.034, "Actual Total Time": 1.186, "Actual Rows": 3039, "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 = 329) AND ((_hyper_8_2343_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 506, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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.41, "Total Cost": 1817.01, "Plan Rows": 2792, "Plan Width": 100, "Actual Startup Time": 0.021, "Actual Total Time": 1.262, "Actual Rows": 3039, "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 = 329) AND ((_hyper_8_2344_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 606, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": 1.75, "Plan Rows": 1, "Plan Width": 111, "Actual Startup Time": 0.009, "Actual Total Time": 0.009, "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 = 329) 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.41, "Total Cost": 441.87, "Plan Rows": 733, "Plan Width": 97, "Actual Startup Time": 0.115, "Actual Total Time": 0.398, "Actual Rows": 881, "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 = 329) AND ((_hyper_8_2346_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 159, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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.41, "Total Cost": 1354.65, "Plan Rows": 4058, "Plan Width": 95, "Actual Startup Time": 0.019, "Actual Total Time": 1.724, "Actual Rows": 5379, "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 = 329) AND ((_hyper_8_2347_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 806, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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.41, "Total Cost": 932.00, "Plan Rows": 2511, "Plan Width": 94, "Actual Startup Time": 0.020, "Actual Total Time": 1.032, "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 = 329) AND ((_hyper_8_2348_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 457, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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.41, "Total Cost": 994.27, "Plan Rows": 2656, "Plan Width": 95, "Actual Startup Time": 0.019, "Actual Total Time": 1.169, "Actual Rows": 3032, "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 = 329) AND ((_hyper_8_2349_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 494, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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.41, "Total Cost": 1025.58, "Plan Rows": 2814, "Plan Width": 95, "Actual Startup Time": 0.014, "Actual Total Time": 1.216, "Actual Rows": 3168, "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 = 329) AND ((_hyper_8_2350_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 507, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2351_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2351_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2351_chunk_2", "Startup Cost": 0.29, "Total Cost": 403.65, "Plan Rows": 2060, "Plan Width": 93, "Actual Startup Time": 0.013, "Actual Total Time": 0.812, "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 = 329) AND ((_hyper_8_2351_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 390, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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.41, "Total Cost": 1227.85, "Plan Rows": 1630, "Plan Width": 104, "Actual Startup Time": 0.079, "Actual Total Time": 0.674, "Actual Rows": 1863, "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 = 329) AND ((_hyper_8_2352_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 230, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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.41, "Total Cost": 2366.34, "Plan Rows": 3475, "Plan Width": 101, "Actual Startup Time": 0.028, "Actual Total Time": 1.476, "Actual Rows": 4397, "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 = 329) AND ((_hyper_8_2353_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 687, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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.41, "Total Cost": 1676.77, "Plan Rows": 2533, "Plan Width": 100, "Actual Startup Time": 0.014, "Actual Total Time": 1.161, "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 = 329) AND ((_hyper_8_2354_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 498, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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.41, "Total Cost": 1836.64, "Plan Rows": 2771, "Plan Width": 102, "Actual Startup Time": 0.012, "Actual Total Time": 1.212, "Actual Rows": 3032, "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 = 329) AND ((_hyper_8_2355_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 535, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2356_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2356_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2356_chunk_2", "Startup Cost": 0.41, "Total Cost": 1903.31, "Plan Rows": 2858, "Plan Width": 102, "Actual Startup Time": 0.013, "Actual Total Time": 1.378, "Actual Rows": 3168, "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 = 329) AND ((_hyper_8_2356_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 566, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2357_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2357_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2357_chunk_2", "Startup Cost": 0.29, "Total Cost": 811.56, "Plan Rows": 2087, "Plan Width": 97, "Actual Startup Time": 0.011, "Actual Total Time": 0.840, "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 = 329) AND ((_hyper_8_2357_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 415, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2358_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2358_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2358_chunk_2", "Startup Cost": 0.27, "Total Cost": 1.87, "Plan Rows": 1, "Plan Width": 100, "Actual Startup Time": 0.009, "Actual Total Time": 0.009, "Actual Rows": 0, "Actual Loops": 1, "Output": ["_hyper_8_2358_chunk_2.simulationrunid", "_hyper_8_2358_chunk_2.componentid", "_hyper_8_2358_chunk_2.discriminator", "_hyper_8_2358_chunk_2.elementid", "_hyper_8_2358_chunk_2.workorderid", "_hyper_8_2358_chunk_2.start", "_hyper_8_2358_chunk_2.finish"], "Index Cond": "((_hyper_8_2358_chunk_2.simulationrunid = 329) AND ((_hyper_8_2358_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 2, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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_2363_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2363_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2363_chunk_2", "Startup Cost": 0.28, "Total Cost": 1.88, "Plan Rows": 1, "Plan Width": 108, "Actual Startup Time": 0.011, "Actual Total Time": 0.011, "Actual Rows": 0, "Actual Loops": 1, "Output": ["_hyper_8_2363_chunk_2.simulationrunid", "_hyper_8_2363_chunk_2.componentid", "_hyper_8_2363_chunk_2.discriminator", "_hyper_8_2363_chunk_2.elementid", "_hyper_8_2363_chunk_2.workorderid", "_hyper_8_2363_chunk_2.start", "_hyper_8_2363_chunk_2.finish"], "Index Cond": "((_hyper_8_2363_chunk_2.simulationrunid = 329) AND ((_hyper_8_2363_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 2, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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_2364_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2364_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2364_chunk_2", "Startup Cost": 0.28, "Total Cost": 1.88, "Plan Rows": 1, "Plan Width": 110, "Actual Startup Time": 0.007, "Actual Total Time": 0.007, "Actual Rows": 0, "Actual Loops": 1, "Output": ["_hyper_8_2364_chunk_2.simulationrunid", "_hyper_8_2364_chunk_2.componentid", "_hyper_8_2364_chunk_2.discriminator", "_hyper_8_2364_chunk_2.elementid", "_hyper_8_2364_chunk_2.workorderid", "_hyper_8_2364_chunk_2.start", "_hyper_8_2364_chunk_2.finish"], "Index Cond": "((_hyper_8_2364_chunk_2.simulationrunid = 329) AND ((_hyper_8_2364_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 2, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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_2365_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2365_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2365_chunk_2", "Startup Cost": 0.28, "Total Cost": 1.88, "Plan Rows": 1, "Plan Width": 111, "Actual Startup Time": 0.011, "Actual Total Time": 0.011, "Actual Rows": 0, "Actual Loops": 1, "Output": ["_hyper_8_2365_chunk_2.simulationrunid", "_hyper_8_2365_chunk_2.componentid", "_hyper_8_2365_chunk_2.discriminator", "_hyper_8_2365_chunk_2.elementid", "_hyper_8_2365_chunk_2.workorderid", "_hyper_8_2365_chunk_2.start", "_hyper_8_2365_chunk_2.finish"], "Index Cond": "((_hyper_8_2365_chunk_2.simulationrunid = 329) AND ((_hyper_8_2365_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 2, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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_2366_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2366_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2366_chunk_2", "Startup Cost": 0.28, "Total Cost": 1.88, "Plan Rows": 1, "Plan Width": 111, "Actual Startup Time": 0.007, "Actual Total Time": 0.007, "Actual Rows": 0, "Actual Loops": 1, "Output": ["_hyper_8_2366_chunk_2.simulationrunid", "_hyper_8_2366_chunk_2.componentid", "_hyper_8_2366_chunk_2.discriminator", "_hyper_8_2366_chunk_2.elementid", "_hyper_8_2366_chunk_2.workorderid", "_hyper_8_2366_chunk_2.start", "_hyper_8_2366_chunk_2.finish"], "Index Cond": "((_hyper_8_2366_chunk_2.simulationrunid = 329) AND ((_hyper_8_2366_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 2, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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_2367_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2367_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2367_chunk_2", "Startup Cost": 0.28, "Total Cost": 1.88, "Plan Rows": 1, "Plan Width": 111, "Actual Startup Time": 0.009, "Actual Total Time": 0.009, "Actual Rows": 0, "Actual Loops": 1, "Output": ["_hyper_8_2367_chunk_2.simulationrunid", "_hyper_8_2367_chunk_2.componentid", "_hyper_8_2367_chunk_2.discriminator", "_hyper_8_2367_chunk_2.elementid", "_hyper_8_2367_chunk_2.workorderid", "_hyper_8_2367_chunk_2.start", "_hyper_8_2367_chunk_2.finish"], "Index Cond": "((_hyper_8_2367_chunk_2.simulationrunid = 329) AND ((_hyper_8_2367_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 2, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 } ] } ] } ] } ] }, { "Node Type": "Sort", "Parent Relationship": "Inner", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 886.04, "Total Cost": 911.62, "Plan Rows": 10231, "Plan Width": 68, "Actual Startup Time": 3.540, "Actual Total Time": 9.563, "Actual Rows": 40605, "Actual Loops": 1, "Output": ["e_1.simulationrunid", "e_1.elementid", "e_1.elementcreatedatcomponentid"], "Sort Key": ["e_1.simulationrunid", "e_1.elementid"], "Sort Method": "quicksort", "Sort Space Used": 1416, "Sort Space Type": "Memory", "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": 204.62, "Plan Rows": 10231, "Plan Width": 68, "Actual Startup Time": 0.003, "Actual Total Time": 0.766, "Actual Rows": 10152, "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.87, "Plan Rows": 1, "Plan Width": 39, "Actual Startup Time": 0.004, "Actual Total Time": 0.004, "Actual Rows": 1, "Actual Loops": 40608, "Output": ["wo.simulationrunid", "wo.componentid", "wo.workerid", "wo.workorderid", "wo.start", "wo.finish", "wo.lastupdate"], "Index Cond": "((wo.simulationrunid = lwt_1.simulationrunid) AND ((wo.componentid)::text = (lwt_1.componentid)::text) AND (wo.workorderid = lwt_1.workorderid))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 162432, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": 252.64, "Plan Rows": 12632, "Plan Width": 224, "Actual Startup Time": 0.000, "Actual Total Time": 0.727, "Actual Rows": 12632, "Actual Loops": 40608, "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 } ] } ] } ] } ] } ] } ] } ] } ] }, "Query Identifier": -8597811903588049987, "Planning": { "Shared Hit Blocks": 832, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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.891, "Triggers": [ ], "Execution Time": 63986.897 } ]