[ { "Plan": { "Node Type": "Merge Join", "Parallel Aware": false, "Async Capable": false, "Join Type": "Full", "Startup Cost": 3260534.12, "Total Cost": 3316044.90, "Plan Rows": 3161900, "Plan Width": 145, "Actual Startup Time": 499367.360, "Actual Total Time": 499522.730, "Actual Rows": 27545, "Actual Loops": 1, "Output": ["lu_holding_buckets.simulationrunid", "lu_holding_buckets.componentid", "(lu_holding_buckets.bucket_start AT TIME ZONE 'UTC'::text)", "(((lu_holding_buckets.bucket_start + '01:00:00'::interval)) AT TIME ZONE 'UTC'::text)", "(sum(CASE WHEN ((lu_holding_buckets.finish >= lu_holding_buckets.bucket_start) AND (lu_holding_buckets.finish < ((lu_holding_buckets.bucket_start + '01:00:00'::interval)))) THEN 1 ELSE 0 END))", "(sum(CASE WHEN (lu_holding_buckets.finish >= ((lu_holding_buckets.bucket_start + '01:00:00'::interval))) THEN 1 ELSE 0 END))", "(sum(CASE WHEN ((lu_holding_buckets.finish >= lu_holding_buckets.bucket_start) AND (lu_holding_buckets.finish < ((lu_holding_buckets.bucket_start + '01:00:00'::interval))) AND (lu_holding_buckets.finish > lu_holding_buckets.late_ref_time)) THEN 1 ELSE 0 END))", "(sum(CASE WHEN ((lu_holding_buckets.finish >= ((lu_holding_buckets.bucket_start + '01:00:00'::interval))) AND (lu_holding_buckets.late_ref_time < ((lu_holding_buckets.bucket_start + '01:00:00'::interval))) AND (lu_holding_buckets.finish > lu_holding_buckets.late_ref_time)) THEN 1 ELSE 0 END))", "(EXTRACT(epoch FROM sum((CASE WHEN (work_order_buckets.finish < ((work_order_buckets.bucket_start + '01:00:00'::interval))) THEN work_order_buckets.finish ELSE ((work_order_buckets.bucket_start + '01:00:00'::interval)) END - CASE WHEN (work_order_buckets.start > work_order_buckets.bucket_start) THEN work_order_buckets.start ELSE work_order_buckets.bucket_start END))))", "(count(DISTINCT work_order_buckets.workerid))", "(count(DISTINCT work_order_buckets.workorderid))", "(sum(CASE WHEN (work_order_buckets.finish >= ((work_order_buckets.bucket_start + '01:00:00'::interval))) THEN 1 ELSE 0 END))", "(sum(CASE WHEN ((work_order_buckets.finish >= ((work_order_buckets.bucket_start + '01:00:00'::interval))) AND (work_order_buckets.finish > work_order_buckets.late_ref_time)) THEN 1 ELSE 0 END))", "(max(ac_buckets.max_elements))", "(COALESCE((lim_soft.value)::integer))", "(COALESCE((lim_hard.value)::integer))", "(CASE WHEN (((max(ac_buckets.max_elements)))::double precision > COALESCE(((lim_soft.value)::integer)::double precision, 'Infinity'::double precision)) THEN 1 ELSE 0 END)"], "Inner Unique": false, "Merge Cond": "((ac_buckets.simulationrunid = lu_holding_buckets.simulationrunid) AND ((ac_buckets.componentid)::text = (lu_holding_buckets.componentid)::text) AND (ac_buckets.bucket_start = lu_holding_buckets.bucket_start) AND (((ac_buckets.bucket_start + '01:00:00'::interval)) = ((lu_holding_buckets.bucket_start + '01:00:00'::interval))))", "Shared Hit Blocks": 681075539, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 1933, "Temp Written Blocks": 1934, "Plans": [ { "Node Type": "Index Scan", "Parent Relationship": "InitPlan", "Subplan Name": "CTE filtered_elements", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "element_pkey", "Relation Name": "element", "Schema": "public", "Alias": "element", "Startup Cost": 0.42, "Total Cost": 2.64, "Plan Rows": 1, "Plan Width": 61, "Actual Startup Time": 0.035, "Actual Total Time": 1.898, "Actual Rows": 8088, "Actual Loops": 1, "Output": ["element.simulationrunid", "element.elementid", "element.elementcreatedatcomponentid"], "Index Cond": "(element.simulationrunid = 325)", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 3101, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Sort", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 3243430.39, "Total Cost": 3251335.14, "Plan Rows": 3161900, "Plan Width": 49, "Actual Startup Time": 404.085, "Actual Total Time": 406.601, "Actual Rows": 27545, "Actual Loops": 1, "Output": ["(max(ac_buckets.max_elements))", "ac_buckets.simulationrunid", "ac_buckets.componentid", "ac_buckets.bucket_start", "((ac_buckets.bucket_start + '01:00:00'::interval))", "(COALESCE((lim_soft.value)::integer))", "(CASE WHEN (((max(ac_buckets.max_elements)))::double precision > COALESCE(((lim_soft.value)::integer)::double precision, 'Infinity'::double precision)) THEN 1 ELSE 0 END)", "(COALESCE((lim_hard.value)::integer))"], "Sort Key": ["ac_buckets.simulationrunid", "ac_buckets.componentid", "ac_buckets.bucket_start", "((ac_buckets.bucket_start + '01:00:00'::interval))"], "Sort Method": "quicksort", "Sort Space Used": 2705, "Sort Space Type": "Memory", "Shared Hit Blocks": 48266, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": 2208756.12, "Total Cost": 2838766.07, "Plan Rows": 3161900, "Plan Width": 49, "Actual Startup Time": 348.858, "Actual Total Time": 367.753, "Actual Rows": 27545, "Actual Loops": 1, "Output": ["(max(ac_buckets.max_elements))", "ac_buckets.simulationrunid", "ac_buckets.componentid", "ac_buckets.bucket_start", "((ac_buckets.bucket_start + '01:00:00'::interval))", "COALESCE((lim_soft.value)::integer)", "CASE WHEN (((max(ac_buckets.max_elements)))::double precision > COALESCE(((lim_soft.value)::integer)::double precision, 'Infinity'::double precision)) THEN 1 ELSE 0 END", "(COALESCE((lim_hard.value)::integer))"], "Inner Unique": true, "Hash Cond": "((ac_buckets.simulationrunid = lim_soft.sim_run_id) AND ((ac_buckets.componentid)::text = (lim_soft.component)::text))", "Shared Hit Blocks": 48266, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": 2172894.78, "Total Cost": 2770494.63, "Plan Rows": 3161900, "Plan Width": 41, "Actual Startup Time": 311.187, "Actual Total Time": 320.928, "Actual Rows": 27545, "Actual Loops": 1, "Output": ["(max(ac_buckets.max_elements))", "ac_buckets.simulationrunid", "ac_buckets.componentid", "ac_buckets.bucket_start", "((ac_buckets.bucket_start + '01:00:00'::interval))", "COALESCE((lim_hard.value)::integer)"], "Inner Unique": true, "Hash Cond": "((ac_buckets.simulationrunid = lim_hard.sim_run_id) AND ((ac_buckets.componentid)::text = (lim_hard.component)::text))", "Shared Hit Blocks": 29814, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Aggregate", "Strategy": "Hashed", "Partial Mode": "Simple", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 2137030.29, "Total Cost": 2670600.92, "Plan Rows": 3161900, "Plan Width": 37, "Actual Startup Time": 270.345, "Actual Total Time": 276.341, "Actual Rows": 27545, "Actual Loops": 1, "Output": ["ac_buckets.simulationrunid", "ac_buckets.componentid", "ac_buckets.bucket_start", "((ac_buckets.bucket_start + '01:00:00'::interval))", "max(ac_buckets.max_elements)"], "Group Key": ["ac_buckets.simulationrunid", "ac_buckets.componentid", "ac_buckets.bucket_start", "(ac_buckets.bucket_start + '01:00:00'::interval)"], "Planned Partitions": 16, "HashAgg Batches": 1, "Peak Memory Usage": 9233, "Disk Usage": 0, "Shared Hit Blocks": 9062, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Subquery Scan", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Alias": "ac_buckets", "Startup Cost": 13.52, "Total Cost": 565961.23, "Plan Rows": 31619000, "Plan Width": 37, "Actual Startup Time": 0.700, "Actual Total Time": 218.009, "Actual Rows": 272237, "Actual Loops": 1, "Output": ["ac_buckets.simulationrunid", "ac_buckets.componentid", "ac_buckets.bucket_start", "(ac_buckets.bucket_start + '01:00:00'::interval)", "ac_buckets.max_elements"], "Shared Hit Blocks": 9062, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "ProjectSet", "Parent Relationship": "Subquery", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 13.52, "Total Cost": 170723.73, "Plan Rows": 31619000, "Plan Width": 69, "Actual Startup Time": 0.699, "Actual Total Time": 197.125, "Actual Rows": 272237, "Actual Loops": 1, "Output": ["_hyper_8_2343_chunk.simulationrunid", "_hyper_8_2343_chunk.componentid", "NULL::character varying", "NULL::timestamp with time zone", "generate_series(time_bucket('01:00:00'::interval, _hyper_8_2343_chunk.start), time_bucket('01:00:00'::interval, _hyper_8_2343_chunk.finish), '01:00:00'::interval)", "(sum(\"*VALUES*\".column2) OVER (?))"], "Shared Hit Blocks": 9062, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Incremental Sort", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 13.52, "Total Cost": 11917.30, "Plan Rows": 31619, "Plan Width": 90, "Actual Startup Time": 0.696, "Actual Total Time": 170.294, "Actual Rows": 32352, "Actual Loops": 1, "Output": ["_hyper_8_2343_chunk.simulationrunid", "_hyper_8_2343_chunk.componentid", "_hyper_8_2343_chunk.elementid", "_hyper_8_2343_chunk.start", "_hyper_8_2343_chunk.finish", "\"*VALUES*\".column1", "NULL::integer", "(sum(\"*VALUES*\".column2) OVER (?))"], "Sort Key": ["_hyper_8_2343_chunk.componentid", "_hyper_8_2343_chunk.elementid", "\"*VALUES*\".column1"], "Presorted Key": ["_hyper_8_2343_chunk.componentid"], "Full-sort Groups": { "Group Count": 127, "Sort Methods Used": ["quicksort"], "Sort Space Memory": { "Average Sort Space Used": 28, "Peak Sort Space Used": 28 } }, "Pre-sorted Groups": { "Group Count": 96, "Sort Methods Used": ["quicksort"], "Sort Space Memory": { "Average Sort Space Used": 58, "Peak Sort Space Used": 1109 } }, "Shared Hit Blocks": 9062, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "WindowAgg", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 10.02, "Total Cost": 10939.15, "Plan Rows": 31619, "Plan Width": 90, "Actual Startup Time": 0.457, "Actual Total Time": 115.515, "Actual Rows": 32352, "Actual Loops": 1, "Output": ["_hyper_8_2343_chunk.simulationrunid", "_hyper_8_2343_chunk.componentid", "_hyper_8_2343_chunk.elementid", "_hyper_8_2343_chunk.start", "_hyper_8_2343_chunk.finish", "\"*VALUES*\".column1", "NULL::integer", "sum(\"*VALUES*\".column2) OVER (?)"], "Shared Hit Blocks": 9062, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Incremental Sort", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 10.02, "Total Cost": 10385.82, "Plan Rows": 31619, "Plan Width": 82, "Actual Startup Time": 0.450, "Actual Total Time": 102.271, "Actual Rows": 32352, "Actual Loops": 1, "Output": ["_hyper_8_2343_chunk.componentid", "\"*VALUES*\".column1", "_hyper_8_2343_chunk.simulationrunid", "_hyper_8_2343_chunk.elementid", "_hyper_8_2343_chunk.start", "_hyper_8_2343_chunk.finish", "\"*VALUES*\".column2"], "Sort Key": ["_hyper_8_2343_chunk.componentid", "\"*VALUES*\".column1"], "Presorted Key": ["_hyper_8_2343_chunk.componentid"], "Full-sort Groups": { "Group Count": 127, "Sort Methods Used": ["quicksort"], "Sort Space Memory": { "Average Sort Space Used": 28, "Peak Sort Space Used": 28 } }, "Pre-sorted Groups": { "Group Count": 96, "Sort Methods Used": ["quicksort"], "Sort Space Memory": { "Average Sort Space Used": 59, "Peak Sort Space Used": 1172 } }, "Shared Hit Blocks": 9062, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Nested Loop", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Join Type": "Inner", "Startup Cost": 6.99, "Total Cost": 9407.67, "Plan Rows": 31619, "Plan Width": 82, "Actual Startup Time": 0.279, "Actual Total Time": 90.257, "Actual Rows": 32352, "Actual Loops": 1, "Output": ["_hyper_8_2343_chunk.componentid", "\"*VALUES*\".column1", "_hyper_8_2343_chunk.simulationrunid", "_hyper_8_2343_chunk.elementid", "_hyper_8_2343_chunk.start", "_hyper_8_2343_chunk.finish", "\"*VALUES*\".column2"], "Inner Unique": false, "Shared Hit Blocks": 9062, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Incremental Sort", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 6.99, "Total Cost": 7826.72, "Plan Rows": 31619, "Plan Width": 99, "Actual Startup Time": 0.275, "Actual Total Time": 68.181, "Actual Rows": 32352, "Actual Loops": 1, "Output": ["_hyper_8_2343_chunk.simulationrunid", "_hyper_8_2343_chunk.componentid", "_hyper_8_2343_chunk.discriminator", "_hyper_8_2343_chunk.elementid", "_hyper_8_2343_chunk.workorderid", "_hyper_8_2343_chunk.start", "_hyper_8_2343_chunk.finish"], "Sort Key": ["_hyper_8_2343_chunk.componentid", "_hyper_8_2343_chunk.elementid", "_hyper_8_2343_chunk.workorderid", "_hyper_8_2343_chunk.start", "_hyper_8_2343_chunk.finish"], "Presorted Key": ["_hyper_8_2343_chunk.componentid"], "Full-sort Groups": { "Group Count": 127, "Sort Methods Used": ["quicksort"], "Sort Space Memory": { "Average Sort Space Used": 28, "Peak Sort Space Used": 28 } }, "Pre-sorted Groups": { "Group Count": 96, "Sort Methods Used": ["quicksort"], "Sort Space Memory": { "Average Sort Space Used": 59, "Peak Sort Space Used": 1172 } }, "Shared Hit Blocks": 9062, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Merge Append", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 4.74, "Total Cost": 6848.57, "Plan Rows": 31619, "Plan Width": 98, "Actual Startup Time": 0.219, "Actual Total Time": 15.198, "Actual Rows": 32352, "Actual Loops": 1, "Sort Key": ["_hyper_8_2343_chunk.componentid"], "Shared Hit Blocks": 9062, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Subplans Removed": 0, "Plans": [ { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2343_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2343_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2343_chunk", "Startup Cost": 0.29, "Total Cost": 438.10, "Plan Rows": 2146, "Plan Width": 93, "Actual Startup Time": 0.018, "Actual Total Time": 0.818, "Actual Rows": 2179, "Actual Loops": 1, "Output": ["_hyper_8_2343_chunk.simulationrunid", "_hyper_8_2343_chunk.componentid", "_hyper_8_2343_chunk.discriminator", "_hyper_8_2343_chunk.elementid", "_hyper_8_2343_chunk.workorderid", "_hyper_8_2343_chunk.start", "_hyper_8_2343_chunk.finish"], "Index Cond": "((_hyper_8_2343_chunk.simulationrunid = 325) AND ((_hyper_8_2343_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 628, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2344_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2344_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2344_chunk", "Startup Cost": 0.29, "Total Cost": 462.90, "Plan Rows": 2188, "Plan Width": 101, "Actual Startup Time": 0.013, "Actual Total Time": 0.913, "Actual Rows": 2179, "Actual Loops": 1, "Output": ["_hyper_8_2344_chunk.simulationrunid", "_hyper_8_2344_chunk.componentid", "_hyper_8_2344_chunk.discriminator", "_hyper_8_2344_chunk.elementid", "_hyper_8_2344_chunk.workorderid", "_hyper_8_2344_chunk.start", "_hyper_8_2344_chunk.finish"], "Index Cond": "((_hyper_8_2344_chunk.simulationrunid = 325) AND ((_hyper_8_2344_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 791, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2345_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2345_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2345_chunk", "Startup Cost": 0.13, "Total Cost": 2.35, "Plan Rows": 1, "Plan Width": 120, "Actual Startup Time": 0.007, "Actual Total Time": 0.008, "Actual Rows": 0, "Actual Loops": 1, "Output": ["_hyper_8_2345_chunk.simulationrunid", "_hyper_8_2345_chunk.componentid", "_hyper_8_2345_chunk.discriminator", "_hyper_8_2345_chunk.elementid", "_hyper_8_2345_chunk.workorderid", "_hyper_8_2345_chunk.start", "_hyper_8_2345_chunk.finish"], "Index Cond": "((_hyper_8_2345_chunk.simulationrunid = 325) AND ((_hyper_8_2345_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 1, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2346_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2346_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2346_chunk", "Startup Cost": 0.29, "Total Cost": 219.37, "Plan Rows": 1137, "Plan Width": 96, "Actual Startup Time": 0.012, "Actual Total Time": 0.341, "Actual Rows": 1200, "Actual Loops": 1, "Output": ["_hyper_8_2346_chunk.simulationrunid", "_hyper_8_2346_chunk.componentid", "_hyper_8_2346_chunk.discriminator", "_hyper_8_2346_chunk.elementid", "_hyper_8_2346_chunk.workorderid", "_hyper_8_2346_chunk.start", "_hyper_8_2346_chunk.finish"], "Index Cond": "((_hyper_8_2346_chunk.simulationrunid = 325) AND ((_hyper_8_2346_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 193, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2347_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2347_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2347_chunk", "Startup Cost": 0.29, "Total Cost": 437.90, "Plan Rows": 2007, "Plan Width": 94, "Actual Startup Time": 0.015, "Actual Total Time": 0.718, "Actual Rows": 2237, "Actual Loops": 1, "Output": ["_hyper_8_2347_chunk.simulationrunid", "_hyper_8_2347_chunk.componentid", "_hyper_8_2347_chunk.discriminator", "_hyper_8_2347_chunk.elementid", "_hyper_8_2347_chunk.workorderid", "_hyper_8_2347_chunk.start", "_hyper_8_2347_chunk.finish"], "Index Cond": "((_hyper_8_2347_chunk.simulationrunid = 325) AND ((_hyper_8_2347_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 561, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2348_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2348_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2348_chunk", "Startup Cost": 0.29, "Total Cost": 481.02, "Plan Rows": 2712, "Plan Width": 94, "Actual Startup Time": 0.013, "Actual Total Time": 0.975, "Actual Rows": 2758, "Actual Loops": 1, "Output": ["_hyper_8_2348_chunk.simulationrunid", "_hyper_8_2348_chunk.componentid", "_hyper_8_2348_chunk.discriminator", "_hyper_8_2348_chunk.elementid", "_hyper_8_2348_chunk.workorderid", "_hyper_8_2348_chunk.start", "_hyper_8_2348_chunk.finish"], "Index Cond": "((_hyper_8_2348_chunk.simulationrunid = 325) AND ((_hyper_8_2348_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 767, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2349_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2349_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2349_chunk", "Startup Cost": 0.29, "Total Cost": 539.85, "Plan Rows": 3233, "Plan Width": 95, "Actual Startup Time": 0.015, "Actual Total Time": 1.069, "Actual Rows": 3233, "Actual Loops": 1, "Output": ["_hyper_8_2349_chunk.simulationrunid", "_hyper_8_2349_chunk.componentid", "_hyper_8_2349_chunk.discriminator", "_hyper_8_2349_chunk.elementid", "_hyper_8_2349_chunk.workorderid", "_hyper_8_2349_chunk.start", "_hyper_8_2349_chunk.finish"], "Index Cond": "((_hyper_8_2349_chunk.simulationrunid = 325) AND ((_hyper_8_2349_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 849, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2350_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2350_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2350_chunk", "Startup Cost": 0.29, "Total Cost": 569.78, "Plan Rows": 3434, "Plan Width": 95, "Actual Startup Time": 0.012, "Actual Total Time": 1.168, "Actual Rows": 3438, "Actual Loops": 1, "Output": ["_hyper_8_2350_chunk.simulationrunid", "_hyper_8_2350_chunk.componentid", "_hyper_8_2350_chunk.discriminator", "_hyper_8_2350_chunk.elementid", "_hyper_8_2350_chunk.workorderid", "_hyper_8_2350_chunk.start", "_hyper_8_2350_chunk.finish"], "Index Cond": "((_hyper_8_2350_chunk.simulationrunid = 325) AND ((_hyper_8_2350_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 931, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2351_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2351_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2351_chunk", "Startup Cost": 0.29, "Total Cost": 272.42, "Plan Rows": 1143, "Plan Width": 93, "Actual Startup Time": 0.011, "Actual Total Time": 0.448, "Actual Rows": 1131, "Actual Loops": 1, "Output": ["_hyper_8_2351_chunk.simulationrunid", "_hyper_8_2351_chunk.componentid", "_hyper_8_2351_chunk.discriminator", "_hyper_8_2351_chunk.elementid", "_hyper_8_2351_chunk.workorderid", "_hyper_8_2351_chunk.start", "_hyper_8_2351_chunk.finish"], "Index Cond": "((_hyper_8_2351_chunk.simulationrunid = 325) AND ((_hyper_8_2351_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 372, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2352_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2352_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2352_chunk", "Startup Cost": 0.29, "Total Cost": 270.47, "Plan Rows": 1232, "Plan Width": 105, "Actual Startup Time": 0.015, "Actual Total Time": 0.364, "Actual Rows": 1283, "Actual Loops": 1, "Output": ["_hyper_8_2352_chunk.simulationrunid", "_hyper_8_2352_chunk.componentid", "_hyper_8_2352_chunk.discriminator", "_hyper_8_2352_chunk.elementid", "_hyper_8_2352_chunk.workorderid", "_hyper_8_2352_chunk.start", "_hyper_8_2352_chunk.finish"], "Index Cond": "((_hyper_8_2352_chunk.simulationrunid = 325) AND ((_hyper_8_2352_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 246, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2353_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2353_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2353_chunk", "Startup Cost": 0.29, "Total Cost": 413.32, "Plan Rows": 1910, "Plan Width": 102, "Actual Startup Time": 0.021, "Actual Total Time": 0.732, "Actual Rows": 2154, "Actual Loops": 1, "Output": ["_hyper_8_2353_chunk.simulationrunid", "_hyper_8_2353_chunk.componentid", "_hyper_8_2353_chunk.discriminator", "_hyper_8_2353_chunk.elementid", "_hyper_8_2353_chunk.workorderid", "_hyper_8_2353_chunk.start", "_hyper_8_2353_chunk.finish"], "Index Cond": "((_hyper_8_2353_chunk.simulationrunid = 325) AND ((_hyper_8_2353_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 552, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2354_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2354_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2354_chunk", "Startup Cost": 0.29, "Total Cost": 503.54, "Plan Rows": 2670, "Plan Width": 102, "Actual Startup Time": 0.014, "Actual Total Time": 1.014, "Actual Rows": 2758, "Actual Loops": 1, "Output": ["_hyper_8_2354_chunk.simulationrunid", "_hyper_8_2354_chunk.componentid", "_hyper_8_2354_chunk.discriminator", "_hyper_8_2354_chunk.elementid", "_hyper_8_2354_chunk.workorderid", "_hyper_8_2354_chunk.start", "_hyper_8_2354_chunk.finish"], "Index Cond": "((_hyper_8_2354_chunk.simulationrunid = 325) AND ((_hyper_8_2354_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 795, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2355_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2355_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2355_chunk", "Startup Cost": 0.29, "Total Cost": 565.50, "Plan Rows": 3233, "Plan Width": 103, "Actual Startup Time": 0.014, "Actual Total Time": 1.140, "Actual Rows": 3233, "Actual Loops": 1, "Output": ["_hyper_8_2355_chunk.simulationrunid", "_hyper_8_2355_chunk.componentid", "_hyper_8_2355_chunk.discriminator", "_hyper_8_2355_chunk.elementid", "_hyper_8_2355_chunk.workorderid", "_hyper_8_2355_chunk.start", "_hyper_8_2355_chunk.finish"], "Index Cond": "((_hyper_8_2355_chunk.simulationrunid = 325) AND ((_hyper_8_2355_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 924, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2356_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2356_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2356_chunk", "Startup Cost": 0.41, "Total Cost": 599.76, "Plan Rows": 3441, "Plan Width": 103, "Actual Startup Time": 0.013, "Actual Total Time": 1.213, "Actual Rows": 3438, "Actual Loops": 1, "Output": ["_hyper_8_2356_chunk.simulationrunid", "_hyper_8_2356_chunk.componentid", "_hyper_8_2356_chunk.discriminator", "_hyper_8_2356_chunk.elementid", "_hyper_8_2356_chunk.workorderid", "_hyper_8_2356_chunk.start", "_hyper_8_2356_chunk.finish"], "Index Cond": "((_hyper_8_2356_chunk.simulationrunid = 325) AND ((_hyper_8_2356_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 1019, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2357_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2357_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2357_chunk", "Startup Cost": 0.29, "Total Cost": 279.73, "Plan Rows": 1131, "Plan Width": 100, "Actual Startup Time": 0.013, "Actual Total Time": 0.482, "Actual Rows": 1131, "Actual Loops": 1, "Output": ["_hyper_8_2357_chunk.simulationrunid", "_hyper_8_2357_chunk.componentid", "_hyper_8_2357_chunk.discriminator", "_hyper_8_2357_chunk.elementid", "_hyper_8_2357_chunk.workorderid", "_hyper_8_2357_chunk.start", "_hyper_8_2357_chunk.finish"], "Index Cond": "((_hyper_8_2357_chunk.simulationrunid = 325) AND ((_hyper_8_2357_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 432, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2358_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2358_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2358_chunk", "Startup Cost": 0.14, "Total Cost": 1.75, "Plan Rows": 1, "Plan Width": 100, "Actual Startup Time": 0.007, "Actual Total Time": 0.007, "Actual Rows": 0, "Actual Loops": 1, "Output": ["_hyper_8_2358_chunk.simulationrunid", "_hyper_8_2358_chunk.componentid", "_hyper_8_2358_chunk.discriminator", "_hyper_8_2358_chunk.elementid", "_hyper_8_2358_chunk.workorderid", "_hyper_8_2358_chunk.start", "_hyper_8_2358_chunk.finish"], "Index Cond": "((_hyper_8_2358_chunk.simulationrunid = 325) AND ((_hyper_8_2358_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 1, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 } ] } ] }, { "Node Type": "Values Scan", "Parent Relationship": "Inner", "Parallel Aware": false, "Async Capable": false, "Alias": "*VALUES*", "Startup Cost": 0.00, "Total Cost": 0.03, "Plan Rows": 1, "Plan Width": 12, "Actual Startup Time": 0.000, "Actual Total Time": 0.000, "Actual Rows": 1, "Actual Loops": 32352, "Output": ["\"*VALUES*\".column1", "\"*VALUES*\".column2"], "Filter": "(\"*VALUES*\".column2 > 0)", "Rows Removed by Filter": 1, "Shared Hit Blocks": 0, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 } ] } ] } ] } ] } ] } ] } ] }, { "Node Type": "Hash", "Parent Relationship": "Inner", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 35864.40, "Total Cost": 35864.40, "Plan Rows": 6, "Plan Width": 39, "Actual Startup Time": 40.818, "Actual Total Time": 40.818, "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": 20752, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": 35864.40, "Plan Rows": 6, "Plan Width": 39, "Actual Startup Time": 16.337, "Actual Total Time": 39.861, "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": 20752, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": 35861.32, "Total Cost": 35861.32, "Plan Rows": 1, "Plan Width": 39, "Actual Startup Time": 37.640, "Actual Total Time": 37.641, "Actual Rows": 2335, "Actual Loops": 1, "Output": ["lim_soft.sim_run_id", "lim_soft.component", "lim_soft.value"], "Hash Buckets": 4096, "Original Hash Buckets": 1024, "Hash Batches": 1, "Original Hash Batches": 1, "Peak Memory Usage": 146, "Shared Hit Blocks": 18452, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": 35861.32, "Plan Rows": 1, "Plan Width": 39, "Actual Startup Time": 16.114, "Actual Total Time": 37.122, "Actual Rows": 2335, "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": 18452, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": 17101.09, "Total Cost": 17268.60, "Plan Rows": 1000, "Plan Width": 125, "Actual Startup Time": 498963.266, "Actual Total Time": 499095.931, "Actual Rows": 27545, "Actual Loops": 1, "Output": ["lu_holding_buckets.simulationrunid", "lu_holding_buckets.componentid", "lu_holding_buckets.bucket_start", "((lu_holding_buckets.bucket_start + '01:00:00'::interval))", "(sum(CASE WHEN ((lu_holding_buckets.finish >= lu_holding_buckets.bucket_start) AND (lu_holding_buckets.finish < ((lu_holding_buckets.bucket_start + '01:00:00'::interval)))) THEN 1 ELSE 0 END))", "(sum(CASE WHEN (lu_holding_buckets.finish >= ((lu_holding_buckets.bucket_start + '01:00:00'::interval))) THEN 1 ELSE 0 END))", "(sum(CASE WHEN ((lu_holding_buckets.finish >= lu_holding_buckets.bucket_start) AND (lu_holding_buckets.finish < ((lu_holding_buckets.bucket_start + '01:00:00'::interval))) AND (lu_holding_buckets.finish > lu_holding_buckets.late_ref_time)) THEN 1 ELSE 0 END))", "(sum(CASE WHEN ((lu_holding_buckets.finish >= ((lu_holding_buckets.bucket_start + '01:00:00'::interval))) AND (lu_holding_buckets.late_ref_time < ((lu_holding_buckets.bucket_start + '01:00:00'::interval))) AND (lu_holding_buckets.finish > lu_holding_buckets.late_ref_time)) THEN 1 ELSE 0 END))", "(EXTRACT(epoch FROM sum((CASE WHEN (work_order_buckets.finish < ((work_order_buckets.bucket_start + '01:00:00'::interval))) THEN work_order_buckets.finish ELSE ((work_order_buckets.bucket_start + '01:00:00'::interval)) END - CASE WHEN (work_order_buckets.start > work_order_buckets.bucket_start) THEN work_order_buckets.start ELSE work_order_buckets.bucket_start END))))", "(count(DISTINCT work_order_buckets.workerid))", "(count(DISTINCT work_order_buckets.workorderid))", "(sum(CASE WHEN (work_order_buckets.finish >= ((work_order_buckets.bucket_start + '01:00:00'::interval))) THEN 1 ELSE 0 END))", "(sum(CASE WHEN ((work_order_buckets.finish >= ((work_order_buckets.bucket_start + '01:00:00'::interval))) AND (work_order_buckets.finish > work_order_buckets.late_ref_time)) THEN 1 ELSE 0 END))"], "Shared Hit Blocks": 681027273, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 1933, "Temp Written Blocks": 1934, "Plans": [ { "Node Type": "Merge Join", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Join Type": "Left", "Startup Cost": 17101.09, "Total Cost": 17266.10, "Plan Rows": 1000, "Plan Width": 125, "Actual Startup Time": 498963.245, "Actual Total Time": 499087.177, "Actual Rows": 27545, "Actual Loops": 1, "Output": ["lu_holding_buckets.simulationrunid", "lu_holding_buckets.componentid", "lu_holding_buckets.bucket_start", "((lu_holding_buckets.bucket_start + '01:00:00'::interval))", "(sum(CASE WHEN ((lu_holding_buckets.finish >= lu_holding_buckets.bucket_start) AND (lu_holding_buckets.finish < ((lu_holding_buckets.bucket_start + '01:00:00'::interval)))) THEN 1 ELSE 0 END))", "(sum(CASE WHEN (lu_holding_buckets.finish >= ((lu_holding_buckets.bucket_start + '01:00:00'::interval))) THEN 1 ELSE 0 END))", "(sum(CASE WHEN ((lu_holding_buckets.finish >= lu_holding_buckets.bucket_start) AND (lu_holding_buckets.finish < ((lu_holding_buckets.bucket_start + '01:00:00'::interval))) AND (lu_holding_buckets.finish > lu_holding_buckets.late_ref_time)) THEN 1 ELSE 0 END))", "(sum(CASE WHEN ((lu_holding_buckets.finish >= ((lu_holding_buckets.bucket_start + '01:00:00'::interval))) AND (lu_holding_buckets.late_ref_time < ((lu_holding_buckets.bucket_start + '01:00:00'::interval))) AND (lu_holding_buckets.finish > lu_holding_buckets.late_ref_time)) THEN 1 ELSE 0 END))", "(EXTRACT(epoch FROM sum((CASE WHEN (work_order_buckets.finish < ((work_order_buckets.bucket_start + '01:00:00'::interval))) THEN work_order_buckets.finish ELSE ((work_order_buckets.bucket_start + '01:00:00'::interval)) END - CASE WHEN (work_order_buckets.start > work_order_buckets.bucket_start) THEN work_order_buckets.start ELSE work_order_buckets.bucket_start END))))", "(count(DISTINCT work_order_buckets.workerid))", "(count(DISTINCT work_order_buckets.workorderid))", "(sum(CASE WHEN (work_order_buckets.finish >= ((work_order_buckets.bucket_start + '01:00:00'::interval))) THEN 1 ELSE 0 END))", "(sum(CASE WHEN ((work_order_buckets.finish >= ((work_order_buckets.bucket_start + '01:00:00'::interval))) AND (work_order_buckets.finish > work_order_buckets.late_ref_time)) THEN 1 ELSE 0 END))"], "Inner Unique": true, "Merge Cond": "((lu_holding_buckets.simulationrunid = work_order_buckets.simulationrunid) AND ((lu_holding_buckets.componentid)::text = (work_order_buckets.componentid)::text) AND (lu_holding_buckets.bucket_start = work_order_buckets.bucket_start) AND (((lu_holding_buckets.bucket_start + '01:00:00'::interval)) = ((work_order_buckets.bucket_start + '01:00:00'::interval))))", "Shared Hit Blocks": 681027273, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 1933, "Temp Written Blocks": 1934, "Plans": [ { "Node Type": "Aggregate", "Strategy": "Sorted", "Partial Mode": "Simple", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 8450.15, "Total Cost": 8520.15, "Plan Rows": 1000, "Plan Width": 61, "Actual Startup Time": 249477.527, "Actual Total Time": 249581.855, "Actual Rows": 27545, "Actual Loops": 1, "Output": ["lu_holding_buckets.simulationrunid", "lu_holding_buckets.componentid", "lu_holding_buckets.bucket_start", "((lu_holding_buckets.bucket_start + '01:00:00'::interval))", "sum(CASE WHEN ((lu_holding_buckets.finish >= lu_holding_buckets.bucket_start) AND (lu_holding_buckets.finish < ((lu_holding_buckets.bucket_start + '01:00:00'::interval)))) THEN 1 ELSE 0 END)", "sum(CASE WHEN (lu_holding_buckets.finish >= ((lu_holding_buckets.bucket_start + '01:00:00'::interval))) THEN 1 ELSE 0 END)", "sum(CASE WHEN ((lu_holding_buckets.finish >= lu_holding_buckets.bucket_start) AND (lu_holding_buckets.finish < ((lu_holding_buckets.bucket_start + '01:00:00'::interval))) AND (lu_holding_buckets.finish > lu_holding_buckets.late_ref_time)) THEN 1 ELSE 0 END)", "sum(CASE WHEN ((lu_holding_buckets.finish >= ((lu_holding_buckets.bucket_start + '01:00:00'::interval))) AND (lu_holding_buckets.late_ref_time < ((lu_holding_buckets.bucket_start + '01:00:00'::interval))) AND (lu_holding_buckets.finish > lu_holding_buckets.late_ref_time)) THEN 1 ELSE 0 END)"], "Group Key": ["lu_holding_buckets.simulationrunid", "lu_holding_buckets.componentid", "lu_holding_buckets.bucket_start", "((lu_holding_buckets.bucket_start + '01:00:00'::interval))"], "Shared Hit Blocks": 340452375, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 1933, "Temp Written Blocks": 1934, "Plans": [ { "Node Type": "Sort", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 8450.15, "Total Cost": 8452.65, "Plan Rows": 1000, "Plan Width": 45, "Actual Startup Time": 249477.511, "Actual Total Time": 249524.214, "Actual Rows": 272354, "Actual Loops": 1, "Output": ["lu_holding_buckets.simulationrunid", "lu_holding_buckets.componentid", "lu_holding_buckets.bucket_start", "((lu_holding_buckets.bucket_start + '01:00:00'::interval))", "lu_holding_buckets.finish", "lu_holding_buckets.late_ref_time"], "Sort Key": ["lu_holding_buckets.simulationrunid", "lu_holding_buckets.componentid", "lu_holding_buckets.bucket_start", "((lu_holding_buckets.bucket_start + '01:00:00'::interval))"], "Sort Method": "external merge", "Sort Space Used": 15464, "Sort Space Type": "Disk", "Shared Hit Blocks": 340452375, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 1933, "Temp Written Blocks": 1934, "Plans": [ { "Node Type": "Subquery Scan", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Alias": "lu_holding_buckets", "Startup Cost": 7.58, "Total Cost": 8400.32, "Plan Rows": 1000, "Plan Width": 45, "Actual Startup Time": 8.156, "Actual Total Time": 249219.885, "Actual Rows": 272354, "Actual Loops": 1, "Output": ["lu_holding_buckets.simulationrunid", "lu_holding_buckets.componentid", "lu_holding_buckets.bucket_start", "(lu_holding_buckets.bucket_start + '01:00:00'::interval)", "lu_holding_buckets.finish", "lu_holding_buckets.late_ref_time"], "Shared Hit Blocks": 340452375, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "ProjectSet", "Parent Relationship": "Subquery", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 7.58, "Total Cost": 8387.82, "Plan Rows": 1000, "Plan Width": 77, "Actual Startup Time": 8.154, "Actual Total Time": 249191.475, "Actual Rows": 272354, "Actual Loops": 1, "Output": ["_hyper_8_2343_chunk_1.simulationrunid", "_hyper_8_2343_chunk_1.componentid", "NULL::character varying", "NULL::timestamp with time zone", "_hyper_8_2343_chunk_1.finish", "generate_series(time_bucket('01:00:00'::interval, _hyper_8_2343_chunk_1.start), time_bucket('01:00:00'::interval, _hyper_8_2343_chunk_1.finish), '01:00:00'::interval)", "((sim_run_component_metadata.value)::timestamp with time zone)"], "Shared Hit Blocks": 340452375, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Nested Loop", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Join Type": "Left", "Startup Cost": 7.58, "Total Cost": 8382.81, "Plan Rows": 1, "Plan Width": 37, "Actual Startup Time": 8.149, "Actual Total Time": 249129.704, "Actual Rows": 32352, "Actual Loops": 1, "Output": ["_hyper_8_2343_chunk_1.start", "_hyper_8_2343_chunk_1.finish", "_hyper_8_2343_chunk_1.simulationrunid", "_hyper_8_2343_chunk_1.componentid", "((sim_run_component_metadata.value)::timestamp with time zone)"], "Inner Unique": false, "Join Filter": "(((sim_run_component_metadata.generator)::text = (e.elementcreatedatcomponentid)::text) AND ((sim_run_component_metadata.component)::text = (_hyper_8_2343_chunk_1.componentid)::text))", "Rows Removed by Join Filter": 337204896, "Shared Hit Blocks": 340452375, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Hash Join", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Join Type": "Inner", "Startup Cost": 7.02, "Total Cost": 8380.63, "Plan Rows": 1, "Plan Width": 61, "Actual Startup Time": 6.236, "Actual Total Time": 137.432, "Actual Rows": 32352, "Actual Loops": 1, "Output": ["_hyper_8_2343_chunk_1.simulationrunid", "_hyper_8_2343_chunk_1.componentid", "_hyper_8_2343_chunk_1.finish", "_hyper_8_2343_chunk_1.start", "e.elementcreatedatcomponentid"], "Inner Unique": false, "Hash Cond": "((_hyper_8_2343_chunk_1.simulationrunid = e.simulationrunid) AND ((_hyper_8_2343_chunk_1.elementid)::text = (e.elementid)::text))", "Shared Hit Blocks": 12279, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Incremental Sort", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 6.99, "Total Cost": 7827.15, "Plan Rows": 31625, "Plan Width": 99, "Actual Startup Time": 0.282, "Actual Total Time": 83.703, "Actual Rows": 32352, "Actual Loops": 1, "Output": ["_hyper_8_2343_chunk_1.simulationrunid", "_hyper_8_2343_chunk_1.componentid", "_hyper_8_2343_chunk_1.discriminator", "_hyper_8_2343_chunk_1.elementid", "_hyper_8_2343_chunk_1.workorderid", "_hyper_8_2343_chunk_1.start", "_hyper_8_2343_chunk_1.finish"], "Sort Key": ["_hyper_8_2343_chunk_1.componentid", "_hyper_8_2343_chunk_1.elementid", "_hyper_8_2343_chunk_1.workorderid", "_hyper_8_2343_chunk_1.start", "_hyper_8_2343_chunk_1.finish"], "Presorted Key": ["_hyper_8_2343_chunk_1.componentid"], "Full-sort Groups": { "Group Count": 127, "Sort Methods Used": ["quicksort"], "Sort Space Memory": { "Average Sort Space Used": 28, "Peak Sort Space Used": 28 } }, "Pre-sorted Groups": { "Group Count": 96, "Sort Methods Used": ["quicksort"], "Sort Space Memory": { "Average Sort Space Used": 60, "Peak Sort Space Used": 1172 } }, "Shared Hit Blocks": 9178, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Merge Append", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 4.74, "Total Cost": 6848.78, "Plan Rows": 31625, "Plan Width": 98, "Actual Startup Time": 0.225, "Actual Total Time": 19.111, "Actual Rows": 32352, "Actual Loops": 1, "Sort Key": ["_hyper_8_2343_chunk_1.componentid"], "Shared Hit Blocks": 9178, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Subplans Removed": 0, "Plans": [ { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2343_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2343_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2343_chunk_1", "Startup Cost": 0.29, "Total Cost": 438.10, "Plan Rows": 2146, "Plan Width": 93, "Actual Startup Time": 0.024, "Actual Total Time": 1.160, "Actual Rows": 2179, "Actual Loops": 1, "Output": ["_hyper_8_2343_chunk_1.simulationrunid", "_hyper_8_2343_chunk_1.componentid", "_hyper_8_2343_chunk_1.discriminator", "_hyper_8_2343_chunk_1.elementid", "_hyper_8_2343_chunk_1.workorderid", "_hyper_8_2343_chunk_1.start", "_hyper_8_2343_chunk_1.finish"], "Index Cond": "((_hyper_8_2343_chunk_1.simulationrunid = 325) AND ((_hyper_8_2343_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 645, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2344_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2344_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2344_chunk_1", "Startup Cost": 0.29, "Total Cost": 462.90, "Plan Rows": 2188, "Plan Width": 101, "Actual Startup Time": 0.015, "Actual Total Time": 1.264, "Actual Rows": 2179, "Actual Loops": 1, "Output": ["_hyper_8_2344_chunk_1.simulationrunid", "_hyper_8_2344_chunk_1.componentid", "_hyper_8_2344_chunk_1.discriminator", "_hyper_8_2344_chunk_1.elementid", "_hyper_8_2344_chunk_1.workorderid", "_hyper_8_2344_chunk_1.start", "_hyper_8_2344_chunk_1.finish"], "Index Cond": "((_hyper_8_2344_chunk_1.simulationrunid = 325) AND ((_hyper_8_2344_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 818, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2345_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2345_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2345_chunk_1", "Startup Cost": 0.13, "Total Cost": 2.35, "Plan Rows": 1, "Plan Width": 120, "Actual Startup Time": 0.008, "Actual Total Time": 0.008, "Actual Rows": 0, "Actual Loops": 1, "Output": ["_hyper_8_2345_chunk_1.simulationrunid", "_hyper_8_2345_chunk_1.componentid", "_hyper_8_2345_chunk_1.discriminator", "_hyper_8_2345_chunk_1.elementid", "_hyper_8_2345_chunk_1.workorderid", "_hyper_8_2345_chunk_1.start", "_hyper_8_2345_chunk_1.finish"], "Index Cond": "((_hyper_8_2345_chunk_1.simulationrunid = 325) AND ((_hyper_8_2345_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 1, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2346_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2346_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2346_chunk_1", "Startup Cost": 0.29, "Total Cost": 219.37, "Plan Rows": 1137, "Plan Width": 96, "Actual Startup Time": 0.012, "Actual Total Time": 0.357, "Actual Rows": 1200, "Actual Loops": 1, "Output": ["_hyper_8_2346_chunk_1.simulationrunid", "_hyper_8_2346_chunk_1.componentid", "_hyper_8_2346_chunk_1.discriminator", "_hyper_8_2346_chunk_1.elementid", "_hyper_8_2346_chunk_1.workorderid", "_hyper_8_2346_chunk_1.start", "_hyper_8_2346_chunk_1.finish"], "Index Cond": "((_hyper_8_2346_chunk_1.simulationrunid = 325) AND ((_hyper_8_2346_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 191, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2347_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2347_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2347_chunk_1", "Startup Cost": 0.29, "Total Cost": 437.97, "Plan Rows": 2014, "Plan Width": 94, "Actual Startup Time": 0.017, "Actual Total Time": 0.890, "Actual Rows": 2237, "Actual Loops": 1, "Output": ["_hyper_8_2347_chunk_1.simulationrunid", "_hyper_8_2347_chunk_1.componentid", "_hyper_8_2347_chunk_1.discriminator", "_hyper_8_2347_chunk_1.elementid", "_hyper_8_2347_chunk_1.workorderid", "_hyper_8_2347_chunk_1.start", "_hyper_8_2347_chunk_1.finish"], "Index Cond": "((_hyper_8_2347_chunk_1.simulationrunid = 325) AND ((_hyper_8_2347_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 558, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2348_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2348_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2348_chunk_1", "Startup Cost": 0.29, "Total Cost": 481.01, "Plan Rows": 2711, "Plan Width": 94, "Actual Startup Time": 0.015, "Actual Total Time": 1.231, "Actual Rows": 2758, "Actual Loops": 1, "Output": ["_hyper_8_2348_chunk_1.simulationrunid", "_hyper_8_2348_chunk_1.componentid", "_hyper_8_2348_chunk_1.discriminator", "_hyper_8_2348_chunk_1.elementid", "_hyper_8_2348_chunk_1.workorderid", "_hyper_8_2348_chunk_1.start", "_hyper_8_2348_chunk_1.finish"], "Index Cond": "((_hyper_8_2348_chunk_1.simulationrunid = 325) AND ((_hyper_8_2348_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 776, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2349_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2349_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2349_chunk_1", "Startup Cost": 0.29, "Total Cost": 539.85, "Plan Rows": 3233, "Plan Width": 95, "Actual Startup Time": 0.013, "Actual Total Time": 1.334, "Actual Rows": 3233, "Actual Loops": 1, "Output": ["_hyper_8_2349_chunk_1.simulationrunid", "_hyper_8_2349_chunk_1.componentid", "_hyper_8_2349_chunk_1.discriminator", "_hyper_8_2349_chunk_1.elementid", "_hyper_8_2349_chunk_1.workorderid", "_hyper_8_2349_chunk_1.start", "_hyper_8_2349_chunk_1.finish"], "Index Cond": "((_hyper_8_2349_chunk_1.simulationrunid = 325) AND ((_hyper_8_2349_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 863, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2350_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2350_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2350_chunk_1", "Startup Cost": 0.29, "Total Cost": 569.79, "Plan Rows": 3435, "Plan Width": 95, "Actual Startup Time": 0.012, "Actual Total Time": 1.442, "Actual Rows": 3438, "Actual Loops": 1, "Output": ["_hyper_8_2350_chunk_1.simulationrunid", "_hyper_8_2350_chunk_1.componentid", "_hyper_8_2350_chunk_1.discriminator", "_hyper_8_2350_chunk_1.elementid", "_hyper_8_2350_chunk_1.workorderid", "_hyper_8_2350_chunk_1.start", "_hyper_8_2350_chunk_1.finish"], "Index Cond": "((_hyper_8_2350_chunk_1.simulationrunid = 325) AND ((_hyper_8_2350_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 926, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2351_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2351_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2351_chunk_1", "Startup Cost": 0.29, "Total Cost": 272.42, "Plan Rows": 1143, "Plan Width": 93, "Actual Startup Time": 0.011, "Actual Total Time": 0.520, "Actual Rows": 1131, "Actual Loops": 1, "Output": ["_hyper_8_2351_chunk_1.simulationrunid", "_hyper_8_2351_chunk_1.componentid", "_hyper_8_2351_chunk_1.discriminator", "_hyper_8_2351_chunk_1.elementid", "_hyper_8_2351_chunk_1.workorderid", "_hyper_8_2351_chunk_1.start", "_hyper_8_2351_chunk_1.finish"], "Index Cond": "((_hyper_8_2351_chunk_1.simulationrunid = 325) AND ((_hyper_8_2351_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 382, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2352_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2352_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2352_chunk_1", "Startup Cost": 0.29, "Total Cost": 270.47, "Plan Rows": 1232, "Plan Width": 105, "Actual Startup Time": 0.014, "Actual Total Time": 0.399, "Actual Rows": 1283, "Actual Loops": 1, "Output": ["_hyper_8_2352_chunk_1.simulationrunid", "_hyper_8_2352_chunk_1.componentid", "_hyper_8_2352_chunk_1.discriminator", "_hyper_8_2352_chunk_1.elementid", "_hyper_8_2352_chunk_1.workorderid", "_hyper_8_2352_chunk_1.start", "_hyper_8_2352_chunk_1.finish"], "Index Cond": "((_hyper_8_2352_chunk_1.simulationrunid = 325) AND ((_hyper_8_2352_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 253, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2353_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2353_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2353_chunk_1", "Startup Cost": 0.29, "Total Cost": 413.31, "Plan Rows": 1909, "Plan Width": 102, "Actual Startup Time": 0.014, "Actual Total Time": 0.901, "Actual Rows": 2154, "Actual Loops": 1, "Output": ["_hyper_8_2353_chunk_1.simulationrunid", "_hyper_8_2353_chunk_1.componentid", "_hyper_8_2353_chunk_1.discriminator", "_hyper_8_2353_chunk_1.elementid", "_hyper_8_2353_chunk_1.workorderid", "_hyper_8_2353_chunk_1.start", "_hyper_8_2353_chunk_1.finish"], "Index Cond": "((_hyper_8_2353_chunk_1.simulationrunid = 325) AND ((_hyper_8_2353_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 548, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2354_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2354_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2354_chunk_1", "Startup Cost": 0.29, "Total Cost": 503.54, "Plan Rows": 2670, "Plan Width": 102, "Actual Startup Time": 0.014, "Actual Total Time": 1.268, "Actual Rows": 2758, "Actual Loops": 1, "Output": ["_hyper_8_2354_chunk_1.simulationrunid", "_hyper_8_2354_chunk_1.componentid", "_hyper_8_2354_chunk_1.discriminator", "_hyper_8_2354_chunk_1.elementid", "_hyper_8_2354_chunk_1.workorderid", "_hyper_8_2354_chunk_1.start", "_hyper_8_2354_chunk_1.finish"], "Index Cond": "((_hyper_8_2354_chunk_1.simulationrunid = 325) AND ((_hyper_8_2354_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 799, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2355_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2355_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2355_chunk_1", "Startup Cost": 0.29, "Total Cost": 565.50, "Plan Rows": 3233, "Plan Width": 103, "Actual Startup Time": 0.014, "Actual Total Time": 1.418, "Actual Rows": 3233, "Actual Loops": 1, "Output": ["_hyper_8_2355_chunk_1.simulationrunid", "_hyper_8_2355_chunk_1.componentid", "_hyper_8_2355_chunk_1.discriminator", "_hyper_8_2355_chunk_1.elementid", "_hyper_8_2355_chunk_1.workorderid", "_hyper_8_2355_chunk_1.start", "_hyper_8_2355_chunk_1.finish"], "Index Cond": "((_hyper_8_2355_chunk_1.simulationrunid = 325) AND ((_hyper_8_2355_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 938, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2356_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2356_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2356_chunk_1", "Startup Cost": 0.41, "Total Cost": 599.76, "Plan Rows": 3441, "Plan Width": 103, "Actual Startup Time": 0.013, "Actual Total Time": 1.528, "Actual Rows": 3438, "Actual Loops": 1, "Output": ["_hyper_8_2356_chunk_1.simulationrunid", "_hyper_8_2356_chunk_1.componentid", "_hyper_8_2356_chunk_1.discriminator", "_hyper_8_2356_chunk_1.elementid", "_hyper_8_2356_chunk_1.workorderid", "_hyper_8_2356_chunk_1.start", "_hyper_8_2356_chunk_1.finish"], "Index Cond": "((_hyper_8_2356_chunk_1.simulationrunid = 325) AND ((_hyper_8_2356_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 1038, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2357_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2357_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2357_chunk_1", "Startup Cost": 0.29, "Total Cost": 279.73, "Plan Rows": 1131, "Plan Width": 100, "Actual Startup Time": 0.011, "Actual Total Time": 0.572, "Actual Rows": 1131, "Actual Loops": 1, "Output": ["_hyper_8_2357_chunk_1.simulationrunid", "_hyper_8_2357_chunk_1.componentid", "_hyper_8_2357_chunk_1.discriminator", "_hyper_8_2357_chunk_1.elementid", "_hyper_8_2357_chunk_1.workorderid", "_hyper_8_2357_chunk_1.start", "_hyper_8_2357_chunk_1.finish"], "Index Cond": "((_hyper_8_2357_chunk_1.simulationrunid = 325) AND ((_hyper_8_2357_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 441, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2358_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2358_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2358_chunk_1", "Startup Cost": 0.14, "Total Cost": 1.75, "Plan Rows": 1, "Plan Width": 100, "Actual Startup Time": 0.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 = 325) AND ((_hyper_8_2358_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 1, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 } ] } ] }, { "Node Type": "Hash", "Parent Relationship": "Inner", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 0.02, "Total Cost": 0.02, "Plan Rows": 1, "Plan Width": 68, "Actual Startup Time": 5.932, "Actual Total Time": 5.933, "Actual Rows": 8088, "Actual Loops": 1, "Output": ["e.simulationrunid", "e.elementid", "e.elementcreatedatcomponentid"], "Hash Buckets": 8192, "Original Hash Buckets": 1024, "Hash Batches": 1, "Original Hash Batches": 1, "Peak Memory Usage": 939, "Shared Hit Blocks": 3101, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "CTE Scan", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "CTE Name": "filtered_elements", "Alias": "e", "Startup Cost": 0.00, "Total Cost": 0.02, "Plan Rows": 1, "Plan Width": 68, "Actual Startup Time": 0.037, "Actual Total Time": 4.359, "Actual Rows": 8088, "Actual Loops": 1, "Output": ["e.simulationrunid", "e.elementid", "e.elementcreatedatcomponentid"], "Shared Hit Blocks": 3101, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 } ] } ] }, { "Node Type": "Index Scan", "Parent Relationship": "Inner", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "sim_run_component_metadata_pkey", "Relation Name": "sim_run_component_metadata", "Schema": "public", "Alias": "sim_run_component_metadata", "Startup Cost": 0.55, "Total Cost": 2.16, "Plan Rows": 1, "Plan Width": 51, "Actual Startup Time": 0.004, "Actual Total Time": 7.058, "Actual Rows": 10424, "Actual Loops": 32352, "Output": ["NULL::bigint", "sim_run_component_metadata.generator", "sim_run_component_metadata.component", "(sim_run_component_metadata.value)::timestamp with time zone"], "Index Cond": "((sim_run_component_metadata.sim_run_id = 325) AND ((sim_run_component_metadata.key)::text = 'LATEST'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 340440096, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 } ] } ] } ] } ] } ] }, { "Node Type": "Aggregate", "Strategy": "Sorted", "Partial Mode": "Simple", "Parent Relationship": "Inner", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 8650.94, "Total Cost": 8715.94, "Plan Rows": 1000, "Plan Width": 92, "Actual Startup Time": 249485.713, "Actual Total Time": 249501.003, "Actual Rows": 2344, "Actual Loops": 1, "Output": ["work_order_buckets.simulationrunid", "work_order_buckets.componentid", "work_order_buckets.bucket_start", "((work_order_buckets.bucket_start + '01:00:00'::interval))", "EXTRACT(epoch FROM sum((CASE WHEN (work_order_buckets.finish < ((work_order_buckets.bucket_start + '01:00:00'::interval))) THEN work_order_buckets.finish ELSE ((work_order_buckets.bucket_start + '01:00:00'::interval)) END - CASE WHEN (work_order_buckets.start > work_order_buckets.bucket_start) THEN work_order_buckets.start ELSE work_order_buckets.bucket_start END)))", "count(DISTINCT work_order_buckets.workerid)", "count(DISTINCT work_order_buckets.workorderid)", "sum(CASE WHEN (work_order_buckets.finish >= ((work_order_buckets.bucket_start + '01:00:00'::interval))) THEN 1 ELSE 0 END)", "sum(CASE WHEN ((work_order_buckets.finish >= ((work_order_buckets.bucket_start + '01:00:00'::interval))) AND (work_order_buckets.finish > work_order_buckets.late_ref_time)) THEN 1 ELSE 0 END)"], "Group Key": ["work_order_buckets.simulationrunid", "work_order_buckets.componentid", "work_order_buckets.bucket_start", "((work_order_buckets.bucket_start + '01:00:00'::interval))"], "Shared Hit Blocks": 340574898, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Sort", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 8650.94, "Total Cost": 8653.44, "Plan Rows": 1000, "Plan Width": 79, "Actual Startup Time": 249485.668, "Actual Total Time": 249487.385, "Actual Rows": 32639, "Actual Loops": 1, "Output": ["work_order_buckets.simulationrunid", "work_order_buckets.componentid", "work_order_buckets.bucket_start", "((work_order_buckets.bucket_start + '01:00:00'::interval))", "work_order_buckets.finish", "work_order_buckets.start", "work_order_buckets.workerid", "work_order_buckets.workorderid", "work_order_buckets.late_ref_time"], "Sort Key": ["work_order_buckets.simulationrunid", "work_order_buckets.componentid", "work_order_buckets.bucket_start", "((work_order_buckets.bucket_start + '01:00:00'::interval))", "work_order_buckets.workerid"], "Sort Method": "quicksort", "Sort Space Used": 4338, "Sort Space Type": "Memory", "Shared Hit Blocks": 340574898, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": 8.05, "Total Cost": 8601.11, "Plan Rows": 1000, "Plan Width": 79, "Actual Startup Time": 4.268, "Actual Total Time": 249430.072, "Actual Rows": 32639, "Actual Loops": 1, "Output": ["work_order_buckets.simulationrunid", "work_order_buckets.componentid", "work_order_buckets.bucket_start", "(work_order_buckets.bucket_start + '01:00:00'::interval)", "work_order_buckets.finish", "work_order_buckets.start", "work_order_buckets.workerid", "work_order_buckets.workorderid", "work_order_buckets.late_ref_time"], "Shared Hit Blocks": 340574898, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": 8.05, "Total Cost": 8588.61, "Plan Rows": 1000, "Plan Width": 103, "Actual Startup Time": 4.267, "Actual Total Time": 249418.368, "Actual Rows": 32639, "Actual Loops": 1, "Output": ["_hyper_8_2343_chunk_2.simulationrunid", "_hyper_8_2343_chunk_2.componentid", "NULL::character varying", "_hyper_8_2343_chunk_2.workorderid", "wo.workerid", "_hyper_8_2343_chunk_2.start", "_hyper_8_2343_chunk_2.finish", "((sim_run_component_metadata_1.value)::timestamp with time zone)", "generate_series(time_bucket('01:00:00'::interval, _hyper_8_2343_chunk_2.start), time_bucket('01:00:00'::interval, _hyper_8_2343_chunk_2.finish), '01:00:00'::interval)"], "Shared Hit Blocks": 340574898, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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": 8.05, "Total Cost": 8583.60, "Plan Rows": 1, "Plan Width": 63, "Actual Startup Time": 4.263, "Actual Total Time": 249379.332, "Actual Rows": 32352, "Actual Loops": 1, "Output": ["_hyper_8_2343_chunk_2.start", "_hyper_8_2343_chunk_2.finish", "_hyper_8_2343_chunk_2.simulationrunid", "_hyper_8_2343_chunk_2.componentid", "_hyper_8_2343_chunk_2.workorderid", "wo.workerid", "((sim_run_component_metadata_1.value)::timestamp with time zone)"], "Inner Unique": false, "Join Filter": "(((sim_run_component_metadata_1.generator)::text = (e_1.elementcreatedatcomponentid)::text) AND ((sim_run_component_metadata_1.component)::text = (_hyper_8_2343_chunk_2.componentid)::text))", "Rows Removed by Join Filter": 337204896, "Shared Hit Blocks": 340574898, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Nested Loop", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Join Type": "Inner", "Startup Cost": 7.49, "Total Cost": 8581.41, "Plan Rows": 1, "Plan Width": 87, "Actual Startup Time": 2.351, "Actual Total Time": 323.949, "Actual Rows": 32352, "Actual Loops": 1, "Output": ["_hyper_8_2343_chunk_2.simulationrunid", "_hyper_8_2343_chunk_2.componentid", "_hyper_8_2343_chunk_2.workorderid", "_hyper_8_2343_chunk_2.start", "_hyper_8_2343_chunk_2.finish", "e_1.elementcreatedatcomponentid", "wo.workerid"], "Inner Unique": true, "Join Filter": "(wo.simulationrunid = e_1.simulationrunid)", "Rows Removed by Join Filter": 0, "Shared Hit Blocks": 134802, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Hash Join", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Join Type": "Inner", "Startup Cost": 7.06, "Total Cost": 8579.51, "Plan Rows": 1, "Plan Width": 68, "Actual Startup Time": 2.333, "Actual Total Time": 134.723, "Actual Rows": 32352, "Actual Loops": 1, "Output": ["_hyper_8_2343_chunk_2.simulationrunid", "_hyper_8_2343_chunk_2.componentid", "_hyper_8_2343_chunk_2.workorderid", "_hyper_8_2343_chunk_2.start", "_hyper_8_2343_chunk_2.finish", "e_1.simulationrunid", "e_1.elementcreatedatcomponentid"], "Inner Unique": false, "Hash Cond": "((_hyper_8_2343_chunk_2.simulationrunid = e_1.simulationrunid) AND ((_hyper_8_2343_chunk_2.elementid)::text = (e_1.elementid)::text))", "Shared Hit Blocks": 5394, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Incremental Sort", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 7.03, "Total Cost": 7987.51, "Plan Rows": 33826, "Plan Width": 98, "Actual Startup Time": 0.381, "Actual Total Time": 85.514, "Actual Rows": 32352, "Actual Loops": 1, "Output": ["_hyper_8_2343_chunk_2.simulationrunid", "_hyper_8_2343_chunk_2.componentid", "_hyper_8_2343_chunk_2.discriminator", "_hyper_8_2343_chunk_2.elementid", "_hyper_8_2343_chunk_2.workorderid", "_hyper_8_2343_chunk_2.start", "_hyper_8_2343_chunk_2.finish"], "Sort Key": ["_hyper_8_2343_chunk_2.componentid", "_hyper_8_2343_chunk_2.elementid", "_hyper_8_2343_chunk_2.workorderid", "_hyper_8_2343_chunk_2.start", "_hyper_8_2343_chunk_2.finish"], "Presorted Key": ["_hyper_8_2343_chunk_2.componentid"], "Full-sort Groups": { "Group Count": 127, "Sort Methods Used": ["quicksort"], "Sort Space Memory": { "Average Sort Space Used": 28, "Peak Sort Space Used": 28 } }, "Pre-sorted Groups": { "Group Count": 96, "Sort Methods Used": ["quicksort"], "Sort Space Memory": { "Average Sort Space Used": 60, "Peak Sort Space Used": 1175 } }, "Shared Hit Blocks": 5394, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "Merge Append", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 4.74, "Total Cost": 6929.18, "Plan Rows": 33826, "Plan Width": 98, "Actual Startup Time": 0.314, "Actual Total Time": 18.497, "Actual Rows": 32352, "Actual Loops": 1, "Sort Key": ["_hyper_8_2343_chunk_2.componentid"], "Shared Hit Blocks": 5394, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Subplans Removed": 0, "Plans": [ { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2343_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2343_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2343_chunk_2", "Startup Cost": 0.29, "Total Cost": 459.19, "Plan Rows": 3187, "Plan Width": 93, "Actual Startup Time": 0.027, "Actual Total Time": 1.275, "Actual Rows": 3037, "Actual Loops": 1, "Output": ["_hyper_8_2343_chunk_2.simulationrunid", "_hyper_8_2343_chunk_2.componentid", "_hyper_8_2343_chunk_2.discriminator", "_hyper_8_2343_chunk_2.elementid", "_hyper_8_2343_chunk_2.workorderid", "_hyper_8_2343_chunk_2.start", "_hyper_8_2343_chunk_2.finish"], "Index Cond": "((_hyper_8_2343_chunk_2.simulationrunid = 325) AND ((_hyper_8_2343_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 507, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2344_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2344_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2344_chunk_2", "Startup Cost": 0.29, "Total Cost": 480.82, "Plan Rows": 3027, "Plan Width": 101, "Actual Startup Time": 0.015, "Actual Total Time": 1.417, "Actual Rows": 3037, "Actual Loops": 1, "Output": ["_hyper_8_2344_chunk_2.simulationrunid", "_hyper_8_2344_chunk_2.componentid", "_hyper_8_2344_chunk_2.discriminator", "_hyper_8_2344_chunk_2.elementid", "_hyper_8_2344_chunk_2.workorderid", "_hyper_8_2344_chunk_2.start", "_hyper_8_2344_chunk_2.finish"], "Index Cond": "((_hyper_8_2344_chunk_2.simulationrunid = 325) AND ((_hyper_8_2344_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 602, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2345_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2345_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2345_chunk_2", "Startup Cost": 0.13, "Total Cost": 2.35, "Plan Rows": 1, "Plan Width": 120, "Actual Startup Time": 0.010, "Actual Total Time": 0.010, "Actual Rows": 0, "Actual Loops": 1, "Output": ["_hyper_8_2345_chunk_2.simulationrunid", "_hyper_8_2345_chunk_2.componentid", "_hyper_8_2345_chunk_2.discriminator", "_hyper_8_2345_chunk_2.elementid", "_hyper_8_2345_chunk_2.workorderid", "_hyper_8_2345_chunk_2.start", "_hyper_8_2345_chunk_2.finish"], "Index Cond": "((_hyper_8_2345_chunk_2.simulationrunid = 325) AND ((_hyper_8_2345_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 1, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2346_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2346_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2346_chunk_2", "Startup Cost": 0.29, "Total Cost": 193.74, "Plan Rows": 452, "Plan Width": 96, "Actual Startup Time": 0.051, "Actual Total Time": 0.198, "Actual Rows": 531, "Actual Loops": 1, "Output": ["_hyper_8_2346_chunk_2.simulationrunid", "_hyper_8_2346_chunk_2.componentid", "_hyper_8_2346_chunk_2.discriminator", "_hyper_8_2346_chunk_2.elementid", "_hyper_8_2346_chunk_2.workorderid", "_hyper_8_2346_chunk_2.start", "_hyper_8_2346_chunk_2.finish"], "Index Cond": "((_hyper_8_2346_chunk_2.simulationrunid = 325) AND ((_hyper_8_2346_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 69, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2347_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2347_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2347_chunk_2", "Startup Cost": 0.29, "Total Cost": 436.66, "Plan Rows": 1940, "Plan Width": 94, "Actual Startup Time": 0.022, "Actual Total Time": 0.492, "Actual Rows": 1605, "Actual Loops": 1, "Output": ["_hyper_8_2347_chunk_2.simulationrunid", "_hyper_8_2347_chunk_2.componentid", "_hyper_8_2347_chunk_2.discriminator", "_hyper_8_2347_chunk_2.elementid", "_hyper_8_2347_chunk_2.workorderid", "_hyper_8_2347_chunk_2.start", "_hyper_8_2347_chunk_2.finish"], "Index Cond": "((_hyper_8_2347_chunk_2.simulationrunid = 325) AND ((_hyper_8_2347_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 164, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2348_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2348_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2348_chunk_2", "Startup Cost": 0.29, "Total Cost": 486.42, "Plan Rows": 2971, "Plan Width": 94, "Actual Startup Time": 0.017, "Actual Total Time": 1.186, "Actual Rows": 2717, "Actual Loops": 1, "Output": ["_hyper_8_2348_chunk_2.simulationrunid", "_hyper_8_2348_chunk_2.componentid", "_hyper_8_2348_chunk_2.discriminator", "_hyper_8_2348_chunk_2.elementid", "_hyper_8_2348_chunk_2.workorderid", "_hyper_8_2348_chunk_2.start", "_hyper_8_2348_chunk_2.finish"], "Index Cond": "((_hyper_8_2348_chunk_2.simulationrunid = 325) AND ((_hyper_8_2348_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 455, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2349_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2349_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2349_chunk_2", "Startup Cost": 0.29, "Total Cost": 535.58, "Plan Rows": 3031, "Plan Width": 95, "Actual Startup Time": 0.022, "Actual Total Time": 1.243, "Actual Rows": 3031, "Actual Loops": 1, "Output": ["_hyper_8_2349_chunk_2.simulationrunid", "_hyper_8_2349_chunk_2.componentid", "_hyper_8_2349_chunk_2.discriminator", "_hyper_8_2349_chunk_2.elementid", "_hyper_8_2349_chunk_2.workorderid", "_hyper_8_2349_chunk_2.start", "_hyper_8_2349_chunk_2.finish"], "Index Cond": "((_hyper_8_2349_chunk_2.simulationrunid = 325) AND ((_hyper_8_2349_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 486, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2350_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2350_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2350_chunk_2", "Startup Cost": 0.29, "Total Cost": 565.15, "Plan Rows": 3196, "Plan Width": 95, "Actual Startup Time": 0.013, "Actual Total Time": 1.325, "Actual Rows": 3167, "Actual Loops": 1, "Output": ["_hyper_8_2350_chunk_2.simulationrunid", "_hyper_8_2350_chunk_2.componentid", "_hyper_8_2350_chunk_2.discriminator", "_hyper_8_2350_chunk_2.elementid", "_hyper_8_2350_chunk_2.workorderid", "_hyper_8_2350_chunk_2.start", "_hyper_8_2350_chunk_2.finish"], "Index Cond": "((_hyper_8_2350_chunk_2.simulationrunid = 325) AND ((_hyper_8_2350_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 507, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2351_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2351_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2351_chunk_2", "Startup Cost": 0.29, "Total Cost": 291.14, "Plan Rows": 2059, "Plan Width": 93, "Actual Startup Time": 0.013, "Actual Total Time": 0.967, "Actual Rows": 2088, "Actual Loops": 1, "Output": ["_hyper_8_2351_chunk_2.simulationrunid", "_hyper_8_2351_chunk_2.componentid", "_hyper_8_2351_chunk_2.discriminator", "_hyper_8_2351_chunk_2.elementid", "_hyper_8_2351_chunk_2.workorderid", "_hyper_8_2351_chunk_2.start", "_hyper_8_2351_chunk_2.finish"], "Index Cond": "((_hyper_8_2351_chunk_2.simulationrunid = 325) AND ((_hyper_8_2351_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 382, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2352_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2352_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2352_chunk_2", "Startup Cost": 0.29, "Total Cost": 249.78, "Plan Rows": 656, "Plan Width": 105, "Actual Startup Time": 0.031, "Actual Total Time": 0.206, "Actual Rows": 614, "Actual Loops": 1, "Output": ["_hyper_8_2352_chunk_2.simulationrunid", "_hyper_8_2352_chunk_2.componentid", "_hyper_8_2352_chunk_2.discriminator", "_hyper_8_2352_chunk_2.elementid", "_hyper_8_2352_chunk_2.workorderid", "_hyper_8_2352_chunk_2.start", "_hyper_8_2352_chunk_2.finish"], "Index Cond": "((_hyper_8_2352_chunk_2.simulationrunid = 325) AND ((_hyper_8_2352_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 73, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2353_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2353_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2353_chunk_2", "Startup Cost": 0.29, "Total Cost": 412.22, "Plan Rows": 1856, "Plan Width": 102, "Actual Startup Time": 0.021, "Actual Total Time": 0.511, "Actual Rows": 1522, "Actual Loops": 1, "Output": ["_hyper_8_2353_chunk_2.simulationrunid", "_hyper_8_2353_chunk_2.componentid", "_hyper_8_2353_chunk_2.discriminator", "_hyper_8_2353_chunk_2.elementid", "_hyper_8_2353_chunk_2.workorderid", "_hyper_8_2353_chunk_2.start", "_hyper_8_2353_chunk_2.finish"], "Index Cond": "((_hyper_8_2353_chunk_2.simulationrunid = 325) AND ((_hyper_8_2353_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 165, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2354_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2354_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2354_chunk_2", "Startup Cost": 0.29, "Total Cost": 513.52, "Plan Rows": 3162, "Plan Width": 102, "Actual Startup Time": 0.016, "Actual Total Time": 1.209, "Actual Rows": 2717, "Actual Loops": 1, "Output": ["_hyper_8_2354_chunk_2.simulationrunid", "_hyper_8_2354_chunk_2.componentid", "_hyper_8_2354_chunk_2.discriminator", "_hyper_8_2354_chunk_2.elementid", "_hyper_8_2354_chunk_2.workorderid", "_hyper_8_2354_chunk_2.start", "_hyper_8_2354_chunk_2.finish"], "Index Cond": "((_hyper_8_2354_chunk_2.simulationrunid = 325) AND ((_hyper_8_2354_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 476, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2355_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2355_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2355_chunk_2", "Startup Cost": 0.29, "Total Cost": 561.23, "Plan Rows": 3031, "Plan Width": 103, "Actual Startup Time": 0.016, "Actual Total Time": 1.304, "Actual Rows": 3031, "Actual Loops": 1, "Output": ["_hyper_8_2355_chunk_2.simulationrunid", "_hyper_8_2355_chunk_2.componentid", "_hyper_8_2355_chunk_2.discriminator", "_hyper_8_2355_chunk_2.elementid", "_hyper_8_2355_chunk_2.workorderid", "_hyper_8_2355_chunk_2.start", "_hyper_8_2355_chunk_2.finish"], "Index Cond": "((_hyper_8_2355_chunk_2.simulationrunid = 325) AND ((_hyper_8_2355_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 520, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2356_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2356_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2356_chunk_2", "Startup Cost": 0.41, "Total Cost": 594.22, "Plan Rows": 3168, "Plan Width": 103, "Actual Startup Time": 0.014, "Actual Total Time": 1.349, "Actual Rows": 3167, "Actual Loops": 1, "Output": ["_hyper_8_2356_chunk_2.simulationrunid", "_hyper_8_2356_chunk_2.componentid", "_hyper_8_2356_chunk_2.discriminator", "_hyper_8_2356_chunk_2.elementid", "_hyper_8_2356_chunk_2.workorderid", "_hyper_8_2356_chunk_2.start", "_hyper_8_2356_chunk_2.finish"], "Index Cond": "((_hyper_8_2356_chunk_2.simulationrunid = 325) AND ((_hyper_8_2356_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 555, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2357_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2357_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2357_chunk_2", "Startup Cost": 0.29, "Total Cost": 299.43, "Plan Rows": 2088, "Plan Width": 100, "Actual Startup Time": 0.013, "Actual Total Time": 1.043, "Actual Rows": 2088, "Actual Loops": 1, "Output": ["_hyper_8_2357_chunk_2.simulationrunid", "_hyper_8_2357_chunk_2.componentid", "_hyper_8_2357_chunk_2.discriminator", "_hyper_8_2357_chunk_2.elementid", "_hyper_8_2357_chunk_2.workorderid", "_hyper_8_2357_chunk_2.start", "_hyper_8_2357_chunk_2.finish"], "Index Cond": "((_hyper_8_2357_chunk_2.simulationrunid = 325) AND ((_hyper_8_2357_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 431, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_8_2358_chunk_luworkertracking_idx", "Relation Name": "_hyper_8_2358_chunk", "Schema": "_timescaledb_internal", "Alias": "_hyper_8_2358_chunk_2", "Startup Cost": 0.14, "Total Cost": 1.75, "Plan Rows": 1, "Plan Width": 100, "Actual Startup Time": 0.007, "Actual Total Time": 0.007, "Actual Rows": 0, "Actual Loops": 1, "Output": ["_hyper_8_2358_chunk_2.simulationrunid", "_hyper_8_2358_chunk_2.componentid", "_hyper_8_2358_chunk_2.discriminator", "_hyper_8_2358_chunk_2.elementid", "_hyper_8_2358_chunk_2.workorderid", "_hyper_8_2358_chunk_2.start", "_hyper_8_2358_chunk_2.finish"], "Index Cond": "((_hyper_8_2358_chunk_2.simulationrunid = 325) AND ((_hyper_8_2358_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 1, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 } ] } ] }, { "Node Type": "Hash", "Parent Relationship": "Inner", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 0.02, "Total Cost": 0.02, "Plan Rows": 1, "Plan Width": 68, "Actual Startup Time": 1.937, "Actual Total Time": 1.937, "Actual Rows": 8088, "Actual Loops": 1, "Output": ["e_1.simulationrunid", "e_1.elementid", "e_1.elementcreatedatcomponentid"], "Hash Buckets": 8192, "Original Hash Buckets": 1024, "Hash Batches": 1, "Original Hash Batches": 1, "Peak Memory Usage": 939, "Shared Hit Blocks": 0, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "Plans": [ { "Node Type": "CTE Scan", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "CTE Name": "filtered_elements", "Alias": "e_1", "Startup Cost": 0.00, "Total Cost": 0.02, "Plan Rows": 1, "Plan Width": 68, "Actual Startup Time": 0.001, "Actual Total Time": 0.609, "Actual Rows": 8088, "Actual Loops": 1, "Output": ["e_1.simulationrunid", "e_1.elementid", "e_1.elementcreatedatcomponentid"], "Shared Hit Blocks": 0, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 } ] } ] }, { "Node Type": "Index Scan", "Parent Relationship": "Inner", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "workorder_pkey", "Relation Name": "work_order", "Schema": "public", "Alias": "wo", "Startup Cost": 0.43, "Total Cost": 1.89, "Plan Rows": 1, "Plan Width": 39, "Actual Startup Time": 0.005, "Actual Total Time": 0.005, "Actual Rows": 1, "Actual Loops": 32352, "Output": ["wo.simulationrunid", "wo.componentid", "wo.workerid", "wo.workorderid", "wo.start", "wo.finish", "wo.lastupdate"], "Index Cond": "((wo.simulationrunid = _hyper_8_2343_chunk_2.simulationrunid) AND ((wo.componentid)::text = (_hyper_8_2343_chunk_2.componentid)::text) AND (wo.workorderid = _hyper_8_2343_chunk_2.workorderid))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 129408, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 } ] }, { "Node Type": "Index Scan", "Parent Relationship": "Inner", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "sim_run_component_metadata_pkey", "Relation Name": "sim_run_component_metadata", "Schema": "public", "Alias": "sim_run_component_metadata_1", "Startup Cost": 0.55, "Total Cost": 2.16, "Plan Rows": 1, "Plan Width": 51, "Actual Startup Time": 0.004, "Actual Total Time": 7.047, "Actual Rows": 10424, "Actual Loops": 32352, "Output": ["NULL::bigint", "sim_run_component_metadata_1.generator", "sim_run_component_metadata_1.component", "(sim_run_component_metadata_1.value)::timestamp with time zone"], "Index Cond": "((sim_run_component_metadata_1.sim_run_id = 325) AND ((sim_run_component_metadata_1.key)::text = 'LATEST'::text))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 340440096, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 } ] } ] } ] } ] } ] } ] } ] } ] }, "Planning": { "Shared Hit Blocks": 610, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "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.252, "Triggers": [ ], "Execution Time": 499528.734 } ]