Execution time: 1m 11s
Planning time: 4.68ms
Main Query Plan
#1 Merge Join
#3 ├ Sort
#4 │└ Hash Join
#5 │ ├ Hash Join
#6 │ │├ Simple HashAggregate
#7 │ ││└ Subquery Scan
#8 │ ││ └ ProjectSet
#9 │ ││  └ Incremental Sort
#10 │ ││   └ WindowAgg
#11 │ ││    └ Incremental Sort
#12 │ ││     └ Nested Loop
#13 │ ││      ├ Incremental Sort
#14 │ ││      │└ Merge Append
#15 │ ││      │ ├ Index Scan
#16 │ ││      │ ├ Index Scan
#17 │ ││      │ ├ Index Scan
#18 │ ││      │ ├ Index Scan
#19 │ ││      │ ├ Index Scan
#20 │ ││      │ ├ Index Scan
#21 │ ││      │ ├ Index Scan
#22 │ ││      │ ├ Index Scan
#23 │ ││      │ ├ Index Scan
#24 │ ││      │ ├ Index Scan
#25 │ ││      │ ├ Index Scan
#26 │ ││      │ ├ Index Scan
#27 │ ││      │ ├ Index Scan
#28 │ ││      │ ├ Index Scan
#29 │ ││      │ ├ Index Scan
#30 │ ││      │ └ Index Scan
#31 │ ││      └ Values Scan
#32 │ │└ Hash
#33 │ │ └ Index Scan
#34 │ └ Hash
#35 │  └ Index Scan
#36 â”” Materialize
#37  └ Merge Join
#38   ├ Simple GroupAggregate
#39   │└ Sort
#40   │ └ Subquery Scan
#41   │  └ ProjectSet
#42   │   └ Nested Loop
#43   │    ├ Hash Join
#44   │    │├ Incremental Sort
#45   │    ││└ Merge Append
#46   │    ││ ├ Index Scan
#47   │    ││ ├ Index Scan
#48   │    ││ ├ Index Scan
#49   │    ││ ├ Index Scan
#50   │    ││ ├ Index Scan
#51   │    ││ ├ Index Scan
#52   │    ││ ├ Index Scan
#53   │    ││ ├ Index Scan
#54   │    ││ ├ Index Scan
#55   │    ││ ├ Index Scan
#56   │    ││ ├ Index Scan
#57   │    ││ ├ Index Scan
#58   │    ││ ├ Index Scan
#59   │    ││ ├ Index Scan
#60   │    ││ ├ Index Scan
#61   │    ││ └ Index Scan
#62   │    │└ Hash
#63   │    │ └ CTE Scan
#64   │    └ Sort
#65   │     └ Index Scan
#66   └ Simple GroupAggregate
#67    └ Sort
#68     └ Subquery Scan
#69      └ ProjectSet
#70       └ Nested Loop
#71        ├ Nested Loop
#72        │├ Hash Join
#73        ││├ Incremental Sort
#74        │││└ Merge Append
#75        │││ ├ Index Scan
#76        │││ ├ Index Scan
#77        │││ ├ Index Scan
#78        │││ ├ Index Scan
#79        │││ ├ Index Scan
#80        │││ ├ Index Scan
#81        │││ ├ Index Scan
#82        │││ ├ Index Scan
#83        │││ ├ Index Scan
#84        │││ ├ Index Scan
#85        │││ ├ Index Scan
#86        │││ ├ Index Scan
#87        │││ ├ Index Scan
#88        │││ ├ Index Scan
#89        │││ ├ Index Scan
#90        │││ └ Index Scan
#91        ││└ Hash
#92        ││ └ CTE Scan
#93        │└ Index Scan
#94        └ Sort
#95         └ Index Scan
CTE filtered_elements
#2 Index Scan

Merge Join

Full join

Sort

by ac_buckets.simulationrunid, ac_buckets.componentid, ac_buckets.bucket_start, ((ac_buckets.bucket_start + '01:00:00'::interval))

Materialize

Hash Join

Left join
on (ac_buckets.simulationrunid = lim_soft.sim_run_id) AND ((ac_buckets.componentid)::text = (lim_soft.component)::text)

Merge Join

Left join

Hash Join

Left join
on (ac_buckets.simulationrunid = lim_hard.sim_run_id) AND ((ac_buckets.componentid)::text = (lim_hard.component)::text)

Hash

Simple GroupAggregate

by lu_holding_buckets.simulationrunid, lu_holding_buckets.componentid, lu_holding_buckets.bucket_start, (lu_holding_buckets.bucket_start + '01:00:00'::interval)

Simple GroupAggregate

by work_order_buckets.simulationrunid, work_order_buckets.componentid, work_order_buckets.bucket_start, (work_order_buckets.bucket_start + '01:00:00'::interval)

Simple HashAggregate

by ac_buckets.simulationrunid, ac_buckets.componentid, ac_buckets.bucket_start, ac_buckets.bucket_start + '01:00:00'::interval

Hash

Index Scan

on public.sim_run_component_metadata as lim_soft
using idx_simruncomponentmetadata_simrunid_key

Sort

by lu_holding_buckets.simulationrunid, lu_holding_buckets.componentid, lu_holding_buckets.bucket_start, ((lu_holding_buckets.bucket_start + '01:00:00'::interval))

Sort

by 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

Subquery Scan

on ac_buckets

Index Scan

on public.sim_run_component_metadata as lim_hard
using idx_simruncomponentmetadata_simrunid_key

Subquery Scan

on lu_holding_buckets

Subquery Scan

on work_order_buckets

ProjectSet

ProjectSet

ProjectSet

Incremental Sort

by _hyper_8_2343_chunk.componentid (presort), _hyper_8_2343_chunk.elementid, "*VALUES*".column1

Nested Loop

Left join

Nested Loop

Left join

WindowAgg

Hash Join

Inner join
on (_hyper_8_2343_chunk_1.simulationrunid = e.simulationrunid) AND ((_hyper_8_2343_chunk_1.elementid)::text = (e.elementid)::text)

Sort

by sim_run_component_metadata.generator, sim_run_component_metadata.component

Nested Loop

Inner join

Sort

by sim_run_component_metadata_1.generator, sim_run_component_metadata_1.component

Incremental Sort

by _hyper_8_2343_chunk.componentid (presort), "*VALUES*".column1

Incremental Sort

by _hyper_8_2343_chunk_1.componentid (presort), _hyper_8_2343_chunk_1.elementid, _hyper_8_2343_chunk_1.workorderid, _hyper_8_2343_chunk_1.start, _hyper_8_2343_chunk_1.finish

Hash

Index Scan

on public.sim_run_component_metadata as sim_run_component_metadata
using idx_simruncomponentmetadata_simrunid_key

Hash Join

Inner join
on (_hyper_8_2343_chunk_2.simulationrunid = e_1.simulationrunid) AND ((_hyper_8_2343_chunk_2.elementid)::text = (e_1.elementid)::text)

Index Scan

on public.work_order as wo
using workorder_pkey

Index Scan

on public.sim_run_component_metadata as sim_run_component_metadata_1
using idx_simruncomponentmetadata_simrunid_key

Nested Loop

Inner join

Merge Append

by _hyper_8_2343_chunk_1.componentid

Incremental Sort

by _hyper_8_2343_chunk_2.componentid (presort), _hyper_8_2343_chunk_2.elementid, _hyper_8_2343_chunk_2.workorderid, _hyper_8_2343_chunk_2.start, _hyper_8_2343_chunk_2.finish

Hash

Incremental Sort

by _hyper_8_2343_chunk.componentid (presort), _hyper_8_2343_chunk.elementid, _hyper_8_2343_chunk.workorderid, _hyper_8_2343_chunk.start, _hyper_8_2343_chunk.finish

Values Scan

on *VALUES*

Index Scan

on _timescaledb_internal._hyper_8_2343_chunk as _hyper_8_2343_chunk_1
using _hyper_8_2343_chunk_luworkertracking_idx

Index Scan

on _timescaledb_internal._hyper_8_2344_chunk as _hyper_8_2344_chunk_1
using _hyper_8_2344_chunk_luworkertracking_idx

Index Scan

on _timescaledb_internal._hyper_8_2345_chunk as _hyper_8_2345_chunk_1
using _hyper_8_2345_chunk_luworkertracking_idx

Index Scan

on _timescaledb_internal._hyper_8_2346_chunk as _hyper_8_2346_chunk_1
using _hyper_8_2346_chunk_luworkertracking_idx

Index Scan

on _timescaledb_internal._hyper_8_2347_chunk as _hyper_8_2347_chunk_1
using _hyper_8_2347_chunk_luworkertracking_idx

Index Scan

on _timescaledb_internal._hyper_8_2348_chunk as _hyper_8_2348_chunk_1
using _hyper_8_2348_chunk_luworkertracking_idx

Index Scan

on _timescaledb_internal._hyper_8_2349_chunk as _hyper_8_2349_chunk_1
using _hyper_8_2349_chunk_luworkertracking_idx

Index Scan

on _timescaledb_internal._hyper_8_2350_chunk as _hyper_8_2350_chunk_1
using _hyper_8_2350_chunk_luworkertracking_idx

Index Scan

on _timescaledb_internal._hyper_8_2351_chunk as _hyper_8_2351_chunk_1
using _hyper_8_2351_chunk_luworkertracking_idx

Index Scan

on _timescaledb_internal._hyper_8_2352_chunk as _hyper_8_2352_chunk_1
using _hyper_8_2352_chunk_luworkertracking_idx

Index Scan

on _timescaledb_internal._hyper_8_2353_chunk as _hyper_8_2353_chunk_1
using _hyper_8_2353_chunk_luworkertracking_idx

Index Scan

on _timescaledb_internal._hyper_8_2354_chunk as _hyper_8_2354_chunk_1
using _hyper_8_2354_chunk_luworkertracking_idx

Index Scan

on _timescaledb_internal._hyper_8_2355_chunk as _hyper_8_2355_chunk_1
using _hyper_8_2355_chunk_luworkertracking_idx

Index Scan

on _timescaledb_internal._hyper_8_2356_chunk as _hyper_8_2356_chunk_1
using _hyper_8_2356_chunk_luworkertracking_idx

Index Scan

on _timescaledb_internal._hyper_8_2357_chunk as _hyper_8_2357_chunk_1
using _hyper_8_2357_chunk_luworkertracking_idx

Index Scan

on _timescaledb_internal._hyper_8_2358_chunk as _hyper_8_2358_chunk_1
using _hyper_8_2358_chunk_luworkertracking_idx

Merge Append

by _hyper_8_2343_chunk_2.componentid

Merge Append

by _hyper_8_2343_chunk.componentid

Index Scan

on _timescaledb_internal._hyper_8_2343_chunk as _hyper_8_2343_chunk_2
using _hyper_8_2343_chunk_luworkertracking_idx

Index Scan

on _timescaledb_internal._hyper_8_2344_chunk as _hyper_8_2344_chunk_2
using _hyper_8_2344_chunk_luworkertracking_idx

Index Scan

on _timescaledb_internal._hyper_8_2345_chunk as _hyper_8_2345_chunk_2
using _hyper_8_2345_chunk_luworkertracking_idx

Index Scan

on _timescaledb_internal._hyper_8_2346_chunk as _hyper_8_2346_chunk_2
using _hyper_8_2346_chunk_luworkertracking_idx

Index Scan

on _timescaledb_internal._hyper_8_2347_chunk as _hyper_8_2347_chunk_2
using _hyper_8_2347_chunk_luworkertracking_idx

Index Scan

on _timescaledb_internal._hyper_8_2348_chunk as _hyper_8_2348_chunk_2
using _hyper_8_2348_chunk_luworkertracking_idx

Index Scan

on _timescaledb_internal._hyper_8_2349_chunk as _hyper_8_2349_chunk_2
using _hyper_8_2349_chunk_luworkertracking_idx

Index Scan

on _timescaledb_internal._hyper_8_2350_chunk as _hyper_8_2350_chunk_2
using _hyper_8_2350_chunk_luworkertracking_idx

Index Scan

on _timescaledb_internal._hyper_8_2351_chunk as _hyper_8_2351_chunk_2
using _hyper_8_2351_chunk_luworkertracking_idx

Index Scan

on _timescaledb_internal._hyper_8_2352_chunk as _hyper_8_2352_chunk_2
using _hyper_8_2352_chunk_luworkertracking_idx

Index Scan

on _timescaledb_internal._hyper_8_2353_chunk as _hyper_8_2353_chunk_2
using _hyper_8_2353_chunk_luworkertracking_idx

Index Scan

on _timescaledb_internal._hyper_8_2354_chunk as _hyper_8_2354_chunk_2
using _hyper_8_2354_chunk_luworkertracking_idx

Index Scan

on _timescaledb_internal._hyper_8_2355_chunk as _hyper_8_2355_chunk_2
using _hyper_8_2355_chunk_luworkertracking_idx

Index Scan

on _timescaledb_internal._hyper_8_2356_chunk as _hyper_8_2356_chunk_2
using _hyper_8_2356_chunk_luworkertracking_idx

Index Scan

on _timescaledb_internal._hyper_8_2357_chunk as _hyper_8_2357_chunk_2
using _hyper_8_2357_chunk_luworkertracking_idx

Index Scan

on _timescaledb_internal._hyper_8_2358_chunk as _hyper_8_2358_chunk_2
using _hyper_8_2358_chunk_luworkertracking_idx

Index Scan

on _timescaledb_internal._hyper_8_2343_chunk as _hyper_8_2343_chunk
using _hyper_8_2343_chunk_luworkertracking_idx

Index Scan

on _timescaledb_internal._hyper_8_2344_chunk as _hyper_8_2344_chunk
using _hyper_8_2344_chunk_luworkertracking_idx

Index Scan

on _timescaledb_internal._hyper_8_2345_chunk as _hyper_8_2345_chunk
using _hyper_8_2345_chunk_luworkertracking_idx

Index Scan

on _timescaledb_internal._hyper_8_2346_chunk as _hyper_8_2346_chunk
using _hyper_8_2346_chunk_luworkertracking_idx

Index Scan

on _timescaledb_internal._hyper_8_2347_chunk as _hyper_8_2347_chunk
using _hyper_8_2347_chunk_luworkertracking_idx

Index Scan

on _timescaledb_internal._hyper_8_2348_chunk as _hyper_8_2348_chunk
using _hyper_8_2348_chunk_luworkertracking_idx

Index Scan

on _timescaledb_internal._hyper_8_2349_chunk as _hyper_8_2349_chunk
using _hyper_8_2349_chunk_luworkertracking_idx

Index Scan

on _timescaledb_internal._hyper_8_2350_chunk as _hyper_8_2350_chunk
using _hyper_8_2350_chunk_luworkertracking_idx

Index Scan

on _timescaledb_internal._hyper_8_2351_chunk as _hyper_8_2351_chunk
using _hyper_8_2351_chunk_luworkertracking_idx

Index Scan

on _timescaledb_internal._hyper_8_2352_chunk as _hyper_8_2352_chunk
using _hyper_8_2352_chunk_luworkertracking_idx

Index Scan

on _timescaledb_internal._hyper_8_2353_chunk as _hyper_8_2353_chunk
using _hyper_8_2353_chunk_luworkertracking_idx

Index Scan

on _timescaledb_internal._hyper_8_2354_chunk as _hyper_8_2354_chunk
using _hyper_8_2354_chunk_luworkertracking_idx

Index Scan

on _timescaledb_internal._hyper_8_2355_chunk as _hyper_8_2355_chunk
using _hyper_8_2355_chunk_luworkertracking_idx

Index Scan

on _timescaledb_internal._hyper_8_2356_chunk as _hyper_8_2356_chunk
using _hyper_8_2356_chunk_luworkertracking_idx

Index Scan

on _timescaledb_internal._hyper_8_2357_chunk as _hyper_8_2357_chunk
using _hyper_8_2357_chunk_luworkertracking_idx

Index Scan

on _timescaledb_internal._hyper_8_2358_chunk as _hyper_8_2358_chunk
using _hyper_8_2358_chunk_luworkertracking_idx
CTE filtered_elements

Index Scan

on public.element as element
using element_pkey
[
  {
    "Plan": {
      "Node Type": "Merge Join",
      "Parallel Aware": false,
      "Async Capable": false,
      "Join Type": "Full",
      "Startup Cost": 3220156.72,
      "Total Cost": 3275667.50,
      "Plan Rows": 3161900,
      "Plan Width": 145,
      "Actual Startup Time": 71261.216,
      "Actual Total Time": 71417.537,
      "Actual Rows": 27545,
      "Actual Loops": 1,
      "Output": ["lu_holding_buckets.simulationrunid", "lu_holding_buckets.componentid", "(lu_holding_buckets.bucket_start AT TIME ZONE 'UTC'::text)", "(((lu_holding_buckets.bucket_start + '01:00:00'::interval)) AT TIME ZONE 'UTC'::text)", "(sum(CASE WHEN ((lu_holding_buckets.finish >= lu_holding_buckets.bucket_start) AND (lu_holding_buckets.finish < ((lu_holding_buckets.bucket_start + '01:00:00'::interval)))) THEN 1 ELSE 0 END))", "(sum(CASE WHEN (lu_holding_buckets.finish >= ((lu_holding_buckets.bucket_start + '01:00:00'::interval))) THEN 1 ELSE 0 END))", "(sum(CASE WHEN ((lu_holding_buckets.finish >= lu_holding_buckets.bucket_start) AND (lu_holding_buckets.finish < ((lu_holding_buckets.bucket_start + '01:00:00'::interval))) AND (lu_holding_buckets.finish > lu_holding_buckets.late_ref_time)) THEN 1 ELSE 0 END))", "(sum(CASE WHEN ((lu_holding_buckets.finish >= ((lu_holding_buckets.bucket_start + '01:00:00'::interval))) AND (lu_holding_buckets.late_ref_time < ((lu_holding_buckets.bucket_start + '01:00:00'::interval))) AND (lu_holding_buckets.finish > lu_holding_buckets.late_ref_time)) THEN 1 ELSE 0 END))", "(EXTRACT(epoch FROM sum((CASE WHEN (work_order_buckets.finish < ((work_order_buckets.bucket_start + '01:00:00'::interval))) THEN work_order_buckets.finish ELSE ((work_order_buckets.bucket_start + '01:00:00'::interval)) END - CASE WHEN (work_order_buckets.start > work_order_buckets.bucket_start) THEN work_order_buckets.start ELSE work_order_buckets.bucket_start END))))", "(count(DISTINCT work_order_buckets.workerid))", "(count(DISTINCT work_order_buckets.workorderid))", "(sum(CASE WHEN (work_order_buckets.finish >= ((work_order_buckets.bucket_start + '01:00:00'::interval))) THEN 1 ELSE 0 END))", "(sum(CASE WHEN ((work_order_buckets.finish >= ((work_order_buckets.bucket_start + '01:00:00'::interval))) AND (work_order_buckets.finish > work_order_buckets.late_ref_time)) THEN 1 ELSE 0 END))", "(max(ac_buckets.max_elements))", "(COALESCE((lim_soft.value)::integer))", "(COALESCE((lim_hard.value)::integer))", "(CASE WHEN (((max(ac_buckets.max_elements)))::double precision > COALESCE(((lim_soft.value)::integer)::double precision, 'Infinity'::double precision)) THEN 1 ELSE 0 END)"],
      "Inner Unique": false,
      "Merge Cond": "((ac_buckets.simulationrunid = lu_holding_buckets.simulationrunid) AND ((ac_buckets.componentid)::text = (lu_holding_buckets.componentid)::text) AND (ac_buckets.bucket_start = lu_holding_buckets.bucket_start) AND (((ac_buckets.bucket_start + '01:00:00'::interval)) = ((lu_holding_buckets.bucket_start + '01:00:00'::interval))))",
      "Shared Hit Blocks": 161902,
      "Shared Read Blocks": 1508,
      "Shared Dirtied Blocks": 0,
      "Shared Written Blocks": 0,
      "Local Hit Blocks": 0,
      "Local Read Blocks": 0,
      "Local Dirtied Blocks": 0,
      "Local Written Blocks": 0,
      "Temp Read Blocks": 1933,
      "Temp Written Blocks": 1934,
      "Plans": [
        {
          "Node Type": "Index Scan",
          "Parent Relationship": "InitPlan",
          "Subplan Name": "CTE filtered_elements",
          "Parallel Aware": false,
          "Async Capable": false,
          "Scan Direction": "Forward",
          "Index Name": "element_pkey",
          "Relation Name": "element",
          "Schema": "public",
          "Alias": "element",
          "Startup Cost": 0.42,
          "Total Cost": 2.64,
          "Plan Rows": 1,
          "Plan Width": 61,
          "Actual Startup Time": 0.031,
          "Actual Total Time": 1.890,
          "Actual Rows": 8088,
          "Actual Loops": 1,
          "Output": ["element.simulationrunid", "element.elementid", "element.elementcreatedatcomponentid"],
          "Index Cond": "(element.simulationrunid = 325)",
          "Rows Removed by Index Recheck": 0,
          "Shared Hit Blocks": 3101,
          "Shared Read Blocks": 0,
          "Shared Dirtied Blocks": 0,
          "Shared Written Blocks": 0,
          "Local Hit Blocks": 0,
          "Local Read Blocks": 0,
          "Local Dirtied Blocks": 0,
          "Local Written Blocks": 0,
          "Temp Read Blocks": 0,
          "Temp Written Blocks": 0
        },
        {
          "Node Type": "Sort",
          "Parent Relationship": "Outer",
          "Parallel Aware": false,
          "Async Capable": false,
          "Startup Cost": 3203053.21,
          "Total Cost": 3210957.96,
          "Plan Rows": 3161900,
          "Plan Width": 49,
          "Actual Startup Time": 338.573,
          "Actual Total Time": 341.188,
          "Actual Rows": 27545,
          "Actual Loops": 1,
          "Output": ["(max(ac_buckets.max_elements))", "ac_buckets.simulationrunid", "ac_buckets.componentid", "ac_buckets.bucket_start", "((ac_buckets.bucket_start + '01:00:00'::interval))", "(COALESCE((lim_soft.value)::integer))", "(CASE WHEN (((max(ac_buckets.max_elements)))::double precision > COALESCE(((lim_soft.value)::integer)::double precision, 'Infinity'::double precision)) THEN 1 ELSE 0 END)", "(COALESCE((lim_hard.value)::integer))"],
          "Sort Key": ["ac_buckets.simulationrunid", "ac_buckets.componentid", "ac_buckets.bucket_start", "((ac_buckets.bucket_start + '01:00:00'::interval))"],
          "Sort Method": "quicksort",
          "Sort Space Used": 2705,
          "Sort Space Type": "Memory",
          "Shared Hit Blocks": 14382,
          "Shared Read Blocks": 1507,
          "Shared Dirtied Blocks": 0,
          "Shared Written Blocks": 0,
          "Local Hit Blocks": 0,
          "Local Read Blocks": 0,
          "Local Dirtied Blocks": 0,
          "Local Written Blocks": 0,
          "Temp Read Blocks": 0,
          "Temp Written Blocks": 0,
          "Plans": [
            {
              "Node Type": "Hash Join",
              "Parent Relationship": "Outer",
              "Parallel Aware": false,
              "Async Capable": false,
              "Join Type": "Left",
              "Startup Cost": 2168378.93,
              "Total Cost": 2798388.89,
              "Plan Rows": 3161900,
              "Plan Width": 49,
              "Actual Startup Time": 283.906,
              "Actual Total Time": 302.431,
              "Actual Rows": 27545,
              "Actual Loops": 1,
              "Output": ["(max(ac_buckets.max_elements))", "ac_buckets.simulationrunid", "ac_buckets.componentid", "ac_buckets.bucket_start", "((ac_buckets.bucket_start + '01:00:00'::interval))", "COALESCE((lim_soft.value)::integer)", "CASE WHEN (((max(ac_buckets.max_elements)))::double precision > COALESCE(((lim_soft.value)::integer)::double precision, 'Infinity'::double precision)) THEN 1 ELSE 0 END", "(COALESCE((lim_hard.value)::integer))"],
              "Inner Unique": true,
              "Hash Cond": "((ac_buckets.simulationrunid = lim_soft.sim_run_id) AND ((ac_buckets.componentid)::text = (lim_soft.component)::text))",
              "Shared Hit Blocks": 14382,
              "Shared Read Blocks": 1507,
              "Shared Dirtied Blocks": 0,
              "Shared Written Blocks": 0,
              "Local Hit Blocks": 0,
              "Local Read Blocks": 0,
              "Local Dirtied Blocks": 0,
              "Local Written Blocks": 0,
              "Temp Read Blocks": 0,
              "Temp Written Blocks": 0,
              "Plans": [
                {
                  "Node Type": "Hash Join",
                  "Parent Relationship": "Outer",
                  "Parallel Aware": false,
                  "Async Capable": false,
                  "Join Type": "Left",
                  "Startup Cost": 2153520.97,
                  "Total Cost": 2751120.82,
                  "Plan Rows": 3161900,
                  "Plan Width": 41,
                  "Actual Startup Time": 281.696,
                  "Actual Total Time": 291.149,
                  "Actual Rows": 27545,
                  "Actual Loops": 1,
                  "Output": ["(max(ac_buckets.max_elements))", "ac_buckets.simulationrunid", "ac_buckets.componentid", "ac_buckets.bucket_start", "((ac_buckets.bucket_start + '01:00:00'::interval))", "COALESCE((lim_hard.value)::integer)"],
                  "Inner Unique": true,
                  "Hash Cond": "((ac_buckets.simulationrunid = lim_hard.sim_run_id) AND ((ac_buckets.componentid)::text = (lim_hard.component)::text))",
                  "Shared Hit Blocks": 12402,
                  "Shared Read Blocks": 1507,
                  "Shared Dirtied Blocks": 0,
                  "Shared Written Blocks": 0,
                  "Local Hit Blocks": 0,
                  "Local Read Blocks": 0,
                  "Local Dirtied Blocks": 0,
                  "Local Written Blocks": 0,
                  "Temp Read Blocks": 0,
                  "Temp Written Blocks": 0,
                  "Plans": [
                    {
                      "Node Type": "Aggregate",
                      "Strategy": "Hashed",
                      "Partial Mode": "Simple",
                      "Parent Relationship": "Outer",
                      "Parallel Aware": false,
                      "Async Capable": false,
                      "Startup Cost": 2137030.29,
                      "Total Cost": 2670600.92,
                      "Plan Rows": 3161900,
                      "Plan Width": 37,
                      "Actual Startup Time": 270.095,
                      "Actual Total Time": 275.885,
                      "Actual Rows": 27545,
                      "Actual Loops": 1,
                      "Output": ["ac_buckets.simulationrunid", "ac_buckets.componentid", "ac_buckets.bucket_start", "((ac_buckets.bucket_start + '01:00:00'::interval))", "max(ac_buckets.max_elements)"],
                      "Group Key": ["ac_buckets.simulationrunid", "ac_buckets.componentid", "ac_buckets.bucket_start", "(ac_buckets.bucket_start + '01:00:00'::interval)"],
                      "Planned Partitions": 16,
                      "HashAgg Batches": 1,
                      "Peak Memory Usage": 9233,
                      "Disk Usage": 0,
                      "Shared Hit Blocks": 9062,
                      "Shared Read Blocks": 0,
                      "Shared Dirtied Blocks": 0,
                      "Shared Written Blocks": 0,
                      "Local Hit Blocks": 0,
                      "Local Read Blocks": 0,
                      "Local Dirtied Blocks": 0,
                      "Local Written Blocks": 0,
                      "Temp Read Blocks": 0,
                      "Temp Written Blocks": 0,
                      "Plans": [
                        {
                          "Node Type": "Subquery Scan",
                          "Parent Relationship": "Outer",
                          "Parallel Aware": false,
                          "Async Capable": false,
                          "Alias": "ac_buckets",
                          "Startup Cost": 13.52,
                          "Total Cost": 565961.23,
                          "Plan Rows": 31619000,
                          "Plan Width": 37,
                          "Actual Startup Time": 0.708,
                          "Actual Total Time": 217.913,
                          "Actual Rows": 272237,
                          "Actual Loops": 1,
                          "Output": ["ac_buckets.simulationrunid", "ac_buckets.componentid", "ac_buckets.bucket_start", "(ac_buckets.bucket_start + '01:00:00'::interval)", "ac_buckets.max_elements"],
                          "Shared Hit Blocks": 9062,
                          "Shared Read Blocks": 0,
                          "Shared Dirtied Blocks": 0,
                          "Shared Written Blocks": 0,
                          "Local Hit Blocks": 0,
                          "Local Read Blocks": 0,
                          "Local Dirtied Blocks": 0,
                          "Local Written Blocks": 0,
                          "Temp Read Blocks": 0,
                          "Temp Written Blocks": 0,
                          "Plans": [
                            {
                              "Node Type": "ProjectSet",
                              "Parent Relationship": "Subquery",
                              "Parallel Aware": false,
                              "Async Capable": false,
                              "Startup Cost": 13.52,
                              "Total Cost": 170723.73,
                              "Plan Rows": 31619000,
                              "Plan Width": 69,
                              "Actual Startup Time": 0.707,
                              "Actual Total Time": 196.724,
                              "Actual Rows": 272237,
                              "Actual Loops": 1,
                              "Output": ["_hyper_8_2343_chunk.simulationrunid", "_hyper_8_2343_chunk.componentid", "NULL::character varying", "NULL::timestamp with time zone", "generate_series(time_bucket('01:00:00'::interval, _hyper_8_2343_chunk.start), time_bucket('01:00:00'::interval, _hyper_8_2343_chunk.finish), '01:00:00'::interval)", "(sum(\"*VALUES*\".column2) OVER (?))"],
                              "Shared Hit Blocks": 9062,
                              "Shared Read Blocks": 0,
                              "Shared Dirtied Blocks": 0,
                              "Shared Written Blocks": 0,
                              "Local Hit Blocks": 0,
                              "Local Read Blocks": 0,
                              "Local Dirtied Blocks": 0,
                              "Local Written Blocks": 0,
                              "Temp Read Blocks": 0,
                              "Temp Written Blocks": 0,
                              "Plans": [
                                {
                                  "Node Type": "Incremental Sort",
                                  "Parent Relationship": "Outer",
                                  "Parallel Aware": false,
                                  "Async Capable": false,
                                  "Startup Cost": 13.52,
                                  "Total Cost": 11917.30,
                                  "Plan Rows": 31619,
                                  "Plan Width": 90,
                                  "Actual Startup Time": 0.702,
                                  "Actual Total Time": 169.971,
                                  "Actual Rows": 32352,
                                  "Actual Loops": 1,
                                  "Output": ["_hyper_8_2343_chunk.simulationrunid", "_hyper_8_2343_chunk.componentid", "_hyper_8_2343_chunk.elementid", "_hyper_8_2343_chunk.start", "_hyper_8_2343_chunk.finish", "\"*VALUES*\".column1", "NULL::integer", "(sum(\"*VALUES*\".column2) OVER (?))"],
                                  "Sort Key": ["_hyper_8_2343_chunk.componentid", "_hyper_8_2343_chunk.elementid", "\"*VALUES*\".column1"],
                                  "Presorted Key": ["_hyper_8_2343_chunk.componentid"],
                                  "Full-sort Groups": {
                                    "Group Count": 127,
                                    "Sort Methods Used": ["quicksort"],
                                    "Sort Space Memory": {
                                      "Average Sort Space Used": 28,
                                      "Peak Sort Space Used": 28
                                    }
                                  },
                                  "Pre-sorted Groups": {
                                    "Group Count": 96,
                                    "Sort Methods Used": ["quicksort"],
                                    "Sort Space Memory": {
                                      "Average Sort Space Used": 58,
                                      "Peak Sort Space Used": 1109
                                    }
                                  },
                                  "Shared Hit Blocks": 9062,
                                  "Shared Read Blocks": 0,
                                  "Shared Dirtied Blocks": 0,
                                  "Shared Written Blocks": 0,
                                  "Local Hit Blocks": 0,
                                  "Local Read Blocks": 0,
                                  "Local Dirtied Blocks": 0,
                                  "Local Written Blocks": 0,
                                  "Temp Read Blocks": 0,
                                  "Temp Written Blocks": 0,
                                  "Plans": [
                                    {
                                      "Node Type": "WindowAgg",
                                      "Parent Relationship": "Outer",
                                      "Parallel Aware": false,
                                      "Async Capable": false,
                                      "Startup Cost": 10.02,
                                      "Total Cost": 10939.15,
                                      "Plan Rows": 31619,
                                      "Plan Width": 90,
                                      "Actual Startup Time": 0.456,
                                      "Actual Total Time": 115.534,
                                      "Actual Rows": 32352,
                                      "Actual Loops": 1,
                                      "Output": ["_hyper_8_2343_chunk.simulationrunid", "_hyper_8_2343_chunk.componentid", "_hyper_8_2343_chunk.elementid", "_hyper_8_2343_chunk.start", "_hyper_8_2343_chunk.finish", "\"*VALUES*\".column1", "NULL::integer", "sum(\"*VALUES*\".column2) OVER (?)"],
                                      "Shared Hit Blocks": 9062,
                                      "Shared Read Blocks": 0,
                                      "Shared Dirtied Blocks": 0,
                                      "Shared Written Blocks": 0,
                                      "Local Hit Blocks": 0,
                                      "Local Read Blocks": 0,
                                      "Local Dirtied Blocks": 0,
                                      "Local Written Blocks": 0,
                                      "Temp Read Blocks": 0,
                                      "Temp Written Blocks": 0,
                                      "Plans": [
                                        {
                                          "Node Type": "Incremental Sort",
                                          "Parent Relationship": "Outer",
                                          "Parallel Aware": false,
                                          "Async Capable": false,
                                          "Startup Cost": 10.02,
                                          "Total Cost": 10385.82,
                                          "Plan Rows": 31619,
                                          "Plan Width": 82,
                                          "Actual Startup Time": 0.448,
                                          "Actual Total Time": 102.621,
                                          "Actual Rows": 32352,
                                          "Actual Loops": 1,
                                          "Output": ["_hyper_8_2343_chunk.componentid", "\"*VALUES*\".column1", "_hyper_8_2343_chunk.simulationrunid", "_hyper_8_2343_chunk.elementid", "_hyper_8_2343_chunk.start", "_hyper_8_2343_chunk.finish", "\"*VALUES*\".column2"],
                                          "Sort Key": ["_hyper_8_2343_chunk.componentid", "\"*VALUES*\".column1"],
                                          "Presorted Key": ["_hyper_8_2343_chunk.componentid"],
                                          "Full-sort Groups": {
                                            "Group Count": 127,
                                            "Sort Methods Used": ["quicksort"],
                                            "Sort Space Memory": {
                                              "Average Sort Space Used": 28,
                                              "Peak Sort Space Used": 28
                                            }
                                          },
                                          "Pre-sorted Groups": {
                                            "Group Count": 96,
                                            "Sort Methods Used": ["quicksort"],
                                            "Sort Space Memory": {
                                              "Average Sort Space Used": 59,
                                              "Peak Sort Space Used": 1172
                                            }
                                          },
                                          "Shared Hit Blocks": 9062,
                                          "Shared Read Blocks": 0,
                                          "Shared Dirtied Blocks": 0,
                                          "Shared Written Blocks": 0,
                                          "Local Hit Blocks": 0,
                                          "Local Read Blocks": 0,
                                          "Local Dirtied Blocks": 0,
                                          "Local Written Blocks": 0,
                                          "Temp Read Blocks": 0,
                                          "Temp Written Blocks": 0,
                                          "Plans": [
                                            {
                                              "Node Type": "Nested Loop",
                                              "Parent Relationship": "Outer",
                                              "Parallel Aware": false,
                                              "Async Capable": false,
                                              "Join Type": "Inner",
                                              "Startup Cost": 6.99,
                                              "Total Cost": 9407.67,
                                              "Plan Rows": 31619,
                                              "Plan Width": 82,
                                              "Actual Startup Time": 0.278,
                                              "Actual Total Time": 90.601,
                                              "Actual Rows": 32352,
                                              "Actual Loops": 1,
                                              "Output": ["_hyper_8_2343_chunk.componentid", "\"*VALUES*\".column1", "_hyper_8_2343_chunk.simulationrunid", "_hyper_8_2343_chunk.elementid", "_hyper_8_2343_chunk.start", "_hyper_8_2343_chunk.finish", "\"*VALUES*\".column2"],
                                              "Inner Unique": false,
                                              "Shared Hit Blocks": 9062,
                                              "Shared Read Blocks": 0,
                                              "Shared Dirtied Blocks": 0,
                                              "Shared Written Blocks": 0,
                                              "Local Hit Blocks": 0,
                                              "Local Read Blocks": 0,
                                              "Local Dirtied Blocks": 0,
                                              "Local Written Blocks": 0,
                                              "Temp Read Blocks": 0,
                                              "Temp Written Blocks": 0,
                                              "Plans": [
                                                {
                                                  "Node Type": "Incremental Sort",
                                                  "Parent Relationship": "Outer",
                                                  "Parallel Aware": false,
                                                  "Async Capable": false,
                                                  "Startup Cost": 6.99,
                                                  "Total Cost": 7826.72,
                                                  "Plan Rows": 31619,
                                                  "Plan Width": 99,
                                                  "Actual Startup Time": 0.273,
                                                  "Actual Total Time": 68.121,
                                                  "Actual Rows": 32352,
                                                  "Actual Loops": 1,
                                                  "Output": ["_hyper_8_2343_chunk.simulationrunid", "_hyper_8_2343_chunk.componentid", "_hyper_8_2343_chunk.discriminator", "_hyper_8_2343_chunk.elementid", "_hyper_8_2343_chunk.workorderid", "_hyper_8_2343_chunk.start", "_hyper_8_2343_chunk.finish"],
                                                  "Sort Key": ["_hyper_8_2343_chunk.componentid", "_hyper_8_2343_chunk.elementid", "_hyper_8_2343_chunk.workorderid", "_hyper_8_2343_chunk.start", "_hyper_8_2343_chunk.finish"],
                                                  "Presorted Key": ["_hyper_8_2343_chunk.componentid"],
                                                  "Full-sort Groups": {
                                                    "Group Count": 127,
                                                    "Sort Methods Used": ["quicksort"],
                                                    "Sort Space Memory": {
                                                      "Average Sort Space Used": 28,
                                                      "Peak Sort Space Used": 28
                                                    }
                                                  },
                                                  "Pre-sorted Groups": {
                                                    "Group Count": 96,
                                                    "Sort Methods Used": ["quicksort"],
                                                    "Sort Space Memory": {
                                                      "Average Sort Space Used": 59,
                                                      "Peak Sort Space Used": 1172
                                                    }
                                                  },
                                                  "Shared Hit Blocks": 9062,
                                                  "Shared Read Blocks": 0,
                                                  "Shared Dirtied Blocks": 0,
                                                  "Shared Written Blocks": 0,
                                                  "Local Hit Blocks": 0,
                                                  "Local Read Blocks": 0,
                                                  "Local Dirtied Blocks": 0,
                                                  "Local Written Blocks": 0,
                                                  "Temp Read Blocks": 0,
                                                  "Temp Written Blocks": 0,
                                                  "Plans": [
                                                    {
                                                      "Node Type": "Merge Append",
                                                      "Parent Relationship": "Outer",
                                                      "Parallel Aware": false,
                                                      "Async Capable": false,
                                                      "Startup Cost": 4.74,
                                                      "Total Cost": 6848.57,
                                                      "Plan Rows": 31619,
                                                      "Plan Width": 98,
                                                      "Actual Startup Time": 0.216,
                                                      "Actual Total Time": 15.208,
                                                      "Actual Rows": 32352,
                                                      "Actual Loops": 1,
                                                      "Sort Key": ["_hyper_8_2343_chunk.componentid"],
                                                      "Shared Hit Blocks": 9062,
                                                      "Shared Read Blocks": 0,
                                                      "Shared Dirtied Blocks": 0,
                                                      "Shared Written Blocks": 0,
                                                      "Local Hit Blocks": 0,
                                                      "Local Read Blocks": 0,
                                                      "Local Dirtied Blocks": 0,
                                                      "Local Written Blocks": 0,
                                                      "Temp Read Blocks": 0,
                                                      "Temp Written Blocks": 0,
                                                      "Subplans Removed": 0,
                                                      "Plans": [
                                                        {
                                                          "Node Type": "Index Scan",
                                                          "Parent Relationship": "Member",
                                                          "Parallel Aware": false,
                                                          "Async Capable": false,
                                                          "Scan Direction": "Forward",
                                                          "Index Name": "_hyper_8_2343_chunk_luworkertracking_idx",
                                                          "Relation Name": "_hyper_8_2343_chunk",
                                                          "Schema": "_timescaledb_internal",
                                                          "Alias": "_hyper_8_2343_chunk",
                                                          "Startup Cost": 0.29,
                                                          "Total Cost": 438.10,
                                                          "Plan Rows": 2146,
                                                          "Plan Width": 93,
                                                          "Actual Startup Time": 0.019,
                                                          "Actual Total Time": 0.841,
                                                          "Actual Rows": 2179,
                                                          "Actual Loops": 1,
                                                          "Output": ["_hyper_8_2343_chunk.simulationrunid", "_hyper_8_2343_chunk.componentid", "_hyper_8_2343_chunk.discriminator", "_hyper_8_2343_chunk.elementid", "_hyper_8_2343_chunk.workorderid", "_hyper_8_2343_chunk.start", "_hyper_8_2343_chunk.finish"],
                                                          "Index Cond": "((_hyper_8_2343_chunk.simulationrunid = 325) AND ((_hyper_8_2343_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))",
                                                          "Rows Removed by Index Recheck": 0,
                                                          "Shared Hit Blocks": 628,
                                                          "Shared Read Blocks": 0,
                                                          "Shared Dirtied Blocks": 0,
                                                          "Shared Written Blocks": 0,
                                                          "Local Hit Blocks": 0,
                                                          "Local Read Blocks": 0,
                                                          "Local Dirtied Blocks": 0,
                                                          "Local Written Blocks": 0,
                                                          "Temp Read Blocks": 0,
                                                          "Temp Written Blocks": 0
                                                        },
                                                        {
                                                          "Node Type": "Index Scan",
                                                          "Parent Relationship": "Member",
                                                          "Parallel Aware": false,
                                                          "Async Capable": false,
                                                          "Scan Direction": "Forward",
                                                          "Index Name": "_hyper_8_2344_chunk_luworkertracking_idx",
                                                          "Relation Name": "_hyper_8_2344_chunk",
                                                          "Schema": "_timescaledb_internal",
                                                          "Alias": "_hyper_8_2344_chunk",
                                                          "Startup Cost": 0.29,
                                                          "Total Cost": 462.90,
                                                          "Plan Rows": 2188,
                                                          "Plan Width": 101,
                                                          "Actual Startup Time": 0.014,
                                                          "Actual Total Time": 0.927,
                                                          "Actual Rows": 2179,
                                                          "Actual Loops": 1,
                                                          "Output": ["_hyper_8_2344_chunk.simulationrunid", "_hyper_8_2344_chunk.componentid", "_hyper_8_2344_chunk.discriminator", "_hyper_8_2344_chunk.elementid", "_hyper_8_2344_chunk.workorderid", "_hyper_8_2344_chunk.start", "_hyper_8_2344_chunk.finish"],
                                                          "Index Cond": "((_hyper_8_2344_chunk.simulationrunid = 325) AND ((_hyper_8_2344_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))",
                                                          "Rows Removed by Index Recheck": 0,
                                                          "Shared Hit Blocks": 791,
                                                          "Shared Read Blocks": 0,
                                                          "Shared Dirtied Blocks": 0,
                                                          "Shared Written Blocks": 0,
                                                          "Local Hit Blocks": 0,
                                                          "Local Read Blocks": 0,
                                                          "Local Dirtied Blocks": 0,
                                                          "Local Written Blocks": 0,
                                                          "Temp Read Blocks": 0,
                                                          "Temp Written Blocks": 0
                                                        },
                                                        {
                                                          "Node Type": "Index Scan",
                                                          "Parent Relationship": "Member",
                                                          "Parallel Aware": false,
                                                          "Async Capable": false,
                                                          "Scan Direction": "Forward",
                                                          "Index Name": "_hyper_8_2345_chunk_luworkertracking_idx",
                                                          "Relation Name": "_hyper_8_2345_chunk",
                                                          "Schema": "_timescaledb_internal",
                                                          "Alias": "_hyper_8_2345_chunk",
                                                          "Startup Cost": 0.13,
                                                          "Total Cost": 2.35,
                                                          "Plan Rows": 1,
                                                          "Plan Width": 120,
                                                          "Actual Startup Time": 0.006,
                                                          "Actual Total Time": 0.007,
                                                          "Actual Rows": 0,
                                                          "Actual Loops": 1,
                                                          "Output": ["_hyper_8_2345_chunk.simulationrunid", "_hyper_8_2345_chunk.componentid", "_hyper_8_2345_chunk.discriminator", "_hyper_8_2345_chunk.elementid", "_hyper_8_2345_chunk.workorderid", "_hyper_8_2345_chunk.start", "_hyper_8_2345_chunk.finish"],
                                                          "Index Cond": "((_hyper_8_2345_chunk.simulationrunid = 325) AND ((_hyper_8_2345_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))",
                                                          "Rows Removed by Index Recheck": 0,
                                                          "Shared Hit Blocks": 1,
                                                          "Shared Read Blocks": 0,
                                                          "Shared Dirtied Blocks": 0,
                                                          "Shared Written Blocks": 0,
                                                          "Local Hit Blocks": 0,
                                                          "Local Read Blocks": 0,
                                                          "Local Dirtied Blocks": 0,
                                                          "Local Written Blocks": 0,
                                                          "Temp Read Blocks": 0,
                                                          "Temp Written Blocks": 0
                                                        },
                                                        {
                                                          "Node Type": "Index Scan",
                                                          "Parent Relationship": "Member",
                                                          "Parallel Aware": false,
                                                          "Async Capable": false,
                                                          "Scan Direction": "Forward",
                                                          "Index Name": "_hyper_8_2346_chunk_luworkertracking_idx",
                                                          "Relation Name": "_hyper_8_2346_chunk",
                                                          "Schema": "_timescaledb_internal",
                                                          "Alias": "_hyper_8_2346_chunk",
                                                          "Startup Cost": 0.29,
                                                          "Total Cost": 219.37,
                                                          "Plan Rows": 1137,
                                                          "Plan Width": 96,
                                                          "Actual Startup Time": 0.012,
                                                          "Actual Total Time": 0.340,
                                                          "Actual Rows": 1200,
                                                          "Actual Loops": 1,
                                                          "Output": ["_hyper_8_2346_chunk.simulationrunid", "_hyper_8_2346_chunk.componentid", "_hyper_8_2346_chunk.discriminator", "_hyper_8_2346_chunk.elementid", "_hyper_8_2346_chunk.workorderid", "_hyper_8_2346_chunk.start", "_hyper_8_2346_chunk.finish"],
                                                          "Index Cond": "((_hyper_8_2346_chunk.simulationrunid = 325) AND ((_hyper_8_2346_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))",
                                                          "Rows Removed by Index Recheck": 0,
                                                          "Shared Hit Blocks": 193,
                                                          "Shared Read Blocks": 0,
                                                          "Shared Dirtied Blocks": 0,
                                                          "Shared Written Blocks": 0,
                                                          "Local Hit Blocks": 0,
                                                          "Local Read Blocks": 0,
                                                          "Local Dirtied Blocks": 0,
                                                          "Local Written Blocks": 0,
                                                          "Temp Read Blocks": 0,
                                                          "Temp Written Blocks": 0
                                                        },
                                                        {
                                                          "Node Type": "Index Scan",
                                                          "Parent Relationship": "Member",
                                                          "Parallel Aware": false,
                                                          "Async Capable": false,
                                                          "Scan Direction": "Forward",
                                                          "Index Name": "_hyper_8_2347_chunk_luworkertracking_idx",
                                                          "Relation Name": "_hyper_8_2347_chunk",
                                                          "Schema": "_timescaledb_internal",
                                                          "Alias": "_hyper_8_2347_chunk",
                                                          "Startup Cost": 0.29,
                                                          "Total Cost": 437.90,
                                                          "Plan Rows": 2007,
                                                          "Plan Width": 94,
                                                          "Actual Startup Time": 0.014,
                                                          "Actual Total Time": 0.715,
                                                          "Actual Rows": 2237,
                                                          "Actual Loops": 1,
                                                          "Output": ["_hyper_8_2347_chunk.simulationrunid", "_hyper_8_2347_chunk.componentid", "_hyper_8_2347_chunk.discriminator", "_hyper_8_2347_chunk.elementid", "_hyper_8_2347_chunk.workorderid", "_hyper_8_2347_chunk.start", "_hyper_8_2347_chunk.finish"],
                                                          "Index Cond": "((_hyper_8_2347_chunk.simulationrunid = 325) AND ((_hyper_8_2347_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))",
                                                          "Rows Removed by Index Recheck": 0,
                                                          "Shared Hit Blocks": 561,
                                                          "Shared Read Blocks": 0,
                                                          "Shared Dirtied Blocks": 0,
                                                          "Shared Written Blocks": 0,
                                                          "Local Hit Blocks": 0,
                                                          "Local Read Blocks": 0,
                                                          "Local Dirtied Blocks": 0,
                                                          "Local Written Blocks": 0,
                                                          "Temp Read Blocks": 0,
                                                          "Temp Written Blocks": 0
                                                        },
                                                        {
                                                          "Node Type": "Index Scan",
                                                          "Parent Relationship": "Member",
                                                          "Parallel Aware": false,
                                                          "Async Capable": false,
                                                          "Scan Direction": "Forward",
                                                          "Index Name": "_hyper_8_2348_chunk_luworkertracking_idx",
                                                          "Relation Name": "_hyper_8_2348_chunk",
                                                          "Schema": "_timescaledb_internal",
                                                          "Alias": "_hyper_8_2348_chunk",
                                                          "Startup Cost": 0.29,
                                                          "Total Cost": 481.02,
                                                          "Plan Rows": 2712,
                                                          "Plan Width": 94,
                                                          "Actual Startup Time": 0.015,
                                                          "Actual Total Time": 0.969,
                                                          "Actual Rows": 2758,
                                                          "Actual Loops": 1,
                                                          "Output": ["_hyper_8_2348_chunk.simulationrunid", "_hyper_8_2348_chunk.componentid", "_hyper_8_2348_chunk.discriminator", "_hyper_8_2348_chunk.elementid", "_hyper_8_2348_chunk.workorderid", "_hyper_8_2348_chunk.start", "_hyper_8_2348_chunk.finish"],
                                                          "Index Cond": "((_hyper_8_2348_chunk.simulationrunid = 325) AND ((_hyper_8_2348_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))",
                                                          "Rows Removed by Index Recheck": 0,
                                                          "Shared Hit Blocks": 767,
                                                          "Shared Read Blocks": 0,
                                                          "Shared Dirtied Blocks": 0,
                                                          "Shared Written Blocks": 0,
                                                          "Local Hit Blocks": 0,
                                                          "Local Read Blocks": 0,
                                                          "Local Dirtied Blocks": 0,
                                                          "Local Written Blocks": 0,
                                                          "Temp Read Blocks": 0,
                                                          "Temp Written Blocks": 0
                                                        },
                                                        {
                                                          "Node Type": "Index Scan",
                                                          "Parent Relationship": "Member",
                                                          "Parallel Aware": false,
                                                          "Async Capable": false,
                                                          "Scan Direction": "Forward",
                                                          "Index Name": "_hyper_8_2349_chunk_luworkertracking_idx",
                                                          "Relation Name": "_hyper_8_2349_chunk",
                                                          "Schema": "_timescaledb_internal",
                                                          "Alias": "_hyper_8_2349_chunk",
                                                          "Startup Cost": 0.29,
                                                          "Total Cost": 539.85,
                                                          "Plan Rows": 3233,
                                                          "Plan Width": 95,
                                                          "Actual Startup Time": 0.015,
                                                          "Actual Total Time": 1.072,
                                                          "Actual Rows": 3233,
                                                          "Actual Loops": 1,
                                                          "Output": ["_hyper_8_2349_chunk.simulationrunid", "_hyper_8_2349_chunk.componentid", "_hyper_8_2349_chunk.discriminator", "_hyper_8_2349_chunk.elementid", "_hyper_8_2349_chunk.workorderid", "_hyper_8_2349_chunk.start", "_hyper_8_2349_chunk.finish"],
                                                          "Index Cond": "((_hyper_8_2349_chunk.simulationrunid = 325) AND ((_hyper_8_2349_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))",
                                                          "Rows Removed by Index Recheck": 0,
                                                          "Shared Hit Blocks": 849,
                                                          "Shared Read Blocks": 0,
                                                          "Shared Dirtied Blocks": 0,
                                                          "Shared Written Blocks": 0,
                                                          "Local Hit Blocks": 0,
                                                          "Local Read Blocks": 0,
                                                          "Local Dirtied Blocks": 0,
                                                          "Local Written Blocks": 0,
                                                          "Temp Read Blocks": 0,
                                                          "Temp Written Blocks": 0
                                                        },
                                                        {
                                                          "Node Type": "Index Scan",
                                                          "Parent Relationship": "Member",
                                                          "Parallel Aware": false,
                                                          "Async Capable": false,
                                                          "Scan Direction": "Forward",
                                                          "Index Name": "_hyper_8_2350_chunk_luworkertracking_idx",
                                                          "Relation Name": "_hyper_8_2350_chunk",
                                                          "Schema": "_timescaledb_internal",
                                                          "Alias": "_hyper_8_2350_chunk",
                                                          "Startup Cost": 0.29,
                                                          "Total Cost": 569.78,
                                                          "Plan Rows": 3434,
                                                          "Plan Width": 95,
                                                          "Actual Startup Time": 0.013,
                                                          "Actual Total Time": 1.168,
                                                          "Actual Rows": 3438,
                                                          "Actual Loops": 1,
                                                          "Output": ["_hyper_8_2350_chunk.simulationrunid", "_hyper_8_2350_chunk.componentid", "_hyper_8_2350_chunk.discriminator", "_hyper_8_2350_chunk.elementid", "_hyper_8_2350_chunk.workorderid", "_hyper_8_2350_chunk.start", "_hyper_8_2350_chunk.finish"],
                                                          "Index Cond": "((_hyper_8_2350_chunk.simulationrunid = 325) AND ((_hyper_8_2350_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))",
                                                          "Rows Removed by Index Recheck": 0,
                                                          "Shared Hit Blocks": 931,
                                                          "Shared Read Blocks": 0,
                                                          "Shared Dirtied Blocks": 0,
                                                          "Shared Written Blocks": 0,
                                                          "Local Hit Blocks": 0,
                                                          "Local Read Blocks": 0,
                                                          "Local Dirtied Blocks": 0,
                                                          "Local Written Blocks": 0,
                                                          "Temp Read Blocks": 0,
                                                          "Temp Written Blocks": 0
                                                        },
                                                        {
                                                          "Node Type": "Index Scan",
                                                          "Parent Relationship": "Member",
                                                          "Parallel Aware": false,
                                                          "Async Capable": false,
                                                          "Scan Direction": "Forward",
                                                          "Index Name": "_hyper_8_2351_chunk_luworkertracking_idx",
                                                          "Relation Name": "_hyper_8_2351_chunk",
                                                          "Schema": "_timescaledb_internal",
                                                          "Alias": "_hyper_8_2351_chunk",
                                                          "Startup Cost": 0.29,
                                                          "Total Cost": 272.42,
                                                          "Plan Rows": 1143,
                                                          "Plan Width": 93,
                                                          "Actual Startup Time": 0.010,
                                                          "Actual Total Time": 0.443,
                                                          "Actual Rows": 1131,
                                                          "Actual Loops": 1,
                                                          "Output": ["_hyper_8_2351_chunk.simulationrunid", "_hyper_8_2351_chunk.componentid", "_hyper_8_2351_chunk.discriminator", "_hyper_8_2351_chunk.elementid", "_hyper_8_2351_chunk.workorderid", "_hyper_8_2351_chunk.start", "_hyper_8_2351_chunk.finish"],
                                                          "Index Cond": "((_hyper_8_2351_chunk.simulationrunid = 325) AND ((_hyper_8_2351_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))",
                                                          "Rows Removed by Index Recheck": 0,
                                                          "Shared Hit Blocks": 372,
                                                          "Shared Read Blocks": 0,
                                                          "Shared Dirtied Blocks": 0,
                                                          "Shared Written Blocks": 0,
                                                          "Local Hit Blocks": 0,
                                                          "Local Read Blocks": 0,
                                                          "Local Dirtied Blocks": 0,
                                                          "Local Written Blocks": 0,
                                                          "Temp Read Blocks": 0,
                                                          "Temp Written Blocks": 0
                                                        },
                                                        {
                                                          "Node Type": "Index Scan",
                                                          "Parent Relationship": "Member",
                                                          "Parallel Aware": false,
                                                          "Async Capable": false,
                                                          "Scan Direction": "Forward",
                                                          "Index Name": "_hyper_8_2352_chunk_luworkertracking_idx",
                                                          "Relation Name": "_hyper_8_2352_chunk",
                                                          "Schema": "_timescaledb_internal",
                                                          "Alias": "_hyper_8_2352_chunk",
                                                          "Startup Cost": 0.29,
                                                          "Total Cost": 270.47,
                                                          "Plan Rows": 1232,
                                                          "Plan Width": 105,
                                                          "Actual Startup Time": 0.015,
                                                          "Actual Total Time": 0.364,
                                                          "Actual Rows": 1283,
                                                          "Actual Loops": 1,
                                                          "Output": ["_hyper_8_2352_chunk.simulationrunid", "_hyper_8_2352_chunk.componentid", "_hyper_8_2352_chunk.discriminator", "_hyper_8_2352_chunk.elementid", "_hyper_8_2352_chunk.workorderid", "_hyper_8_2352_chunk.start", "_hyper_8_2352_chunk.finish"],
                                                          "Index Cond": "((_hyper_8_2352_chunk.simulationrunid = 325) AND ((_hyper_8_2352_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))",
                                                          "Rows Removed by Index Recheck": 0,
                                                          "Shared Hit Blocks": 246,
                                                          "Shared Read Blocks": 0,
                                                          "Shared Dirtied Blocks": 0,
                                                          "Shared Written Blocks": 0,
                                                          "Local Hit Blocks": 0,
                                                          "Local Read Blocks": 0,
                                                          "Local Dirtied Blocks": 0,
                                                          "Local Written Blocks": 0,
                                                          "Temp Read Blocks": 0,
                                                          "Temp Written Blocks": 0
                                                        },
                                                        {
                                                          "Node Type": "Index Scan",
                                                          "Parent Relationship": "Member",
                                                          "Parallel Aware": false,
                                                          "Async Capable": false,
                                                          "Scan Direction": "Forward",
                                                          "Index Name": "_hyper_8_2353_chunk_luworkertracking_idx",
                                                          "Relation Name": "_hyper_8_2353_chunk",
                                                          "Schema": "_timescaledb_internal",
                                                          "Alias": "_hyper_8_2353_chunk",
                                                          "Startup Cost": 0.29,
                                                          "Total Cost": 413.32,
                                                          "Plan Rows": 1910,
                                                          "Plan Width": 102,
                                                          "Actual Startup Time": 0.013,
                                                          "Actual Total Time": 0.718,
                                                          "Actual Rows": 2154,
                                                          "Actual Loops": 1,
                                                          "Output": ["_hyper_8_2353_chunk.simulationrunid", "_hyper_8_2353_chunk.componentid", "_hyper_8_2353_chunk.discriminator", "_hyper_8_2353_chunk.elementid", "_hyper_8_2353_chunk.workorderid", "_hyper_8_2353_chunk.start", "_hyper_8_2353_chunk.finish"],
                                                          "Index Cond": "((_hyper_8_2353_chunk.simulationrunid = 325) AND ((_hyper_8_2353_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))",
                                                          "Rows Removed by Index Recheck": 0,
                                                          "Shared Hit Blocks": 552,
                                                          "Shared Read Blocks": 0,
                                                          "Shared Dirtied Blocks": 0,
                                                          "Shared Written Blocks": 0,
                                                          "Local Hit Blocks": 0,
                                                          "Local Read Blocks": 0,
                                                          "Local Dirtied Blocks": 0,
                                                          "Local Written Blocks": 0,
                                                          "Temp Read Blocks": 0,
                                                          "Temp Written Blocks": 0
                                                        },
                                                        {
                                                          "Node Type": "Index Scan",
                                                          "Parent Relationship": "Member",
                                                          "Parallel Aware": false,
                                                          "Async Capable": false,
                                                          "Scan Direction": "Forward",
                                                          "Index Name": "_hyper_8_2354_chunk_luworkertracking_idx",
                                                          "Relation Name": "_hyper_8_2354_chunk",
                                                          "Schema": "_timescaledb_internal",
                                                          "Alias": "_hyper_8_2354_chunk",
                                                          "Startup Cost": 0.29,
                                                          "Total Cost": 503.54,
                                                          "Plan Rows": 2670,
                                                          "Plan Width": 102,
                                                          "Actual Startup Time": 0.016,
                                                          "Actual Total Time": 1.015,
                                                          "Actual Rows": 2758,
                                                          "Actual Loops": 1,
                                                          "Output": ["_hyper_8_2354_chunk.simulationrunid", "_hyper_8_2354_chunk.componentid", "_hyper_8_2354_chunk.discriminator", "_hyper_8_2354_chunk.elementid", "_hyper_8_2354_chunk.workorderid", "_hyper_8_2354_chunk.start", "_hyper_8_2354_chunk.finish"],
                                                          "Index Cond": "((_hyper_8_2354_chunk.simulationrunid = 325) AND ((_hyper_8_2354_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))",
                                                          "Rows Removed by Index Recheck": 0,
                                                          "Shared Hit Blocks": 795,
                                                          "Shared Read Blocks": 0,
                                                          "Shared Dirtied Blocks": 0,
                                                          "Shared Written Blocks": 0,
                                                          "Local Hit Blocks": 0,
                                                          "Local Read Blocks": 0,
                                                          "Local Dirtied Blocks": 0,
                                                          "Local Written Blocks": 0,
                                                          "Temp Read Blocks": 0,
                                                          "Temp Written Blocks": 0
                                                        },
                                                        {
                                                          "Node Type": "Index Scan",
                                                          "Parent Relationship": "Member",
                                                          "Parallel Aware": false,
                                                          "Async Capable": false,
                                                          "Scan Direction": "Forward",
                                                          "Index Name": "_hyper_8_2355_chunk_luworkertracking_idx",
                                                          "Relation Name": "_hyper_8_2355_chunk",
                                                          "Schema": "_timescaledb_internal",
                                                          "Alias": "_hyper_8_2355_chunk",
                                                          "Startup Cost": 0.29,
                                                          "Total Cost": 565.50,
                                                          "Plan Rows": 3233,
                                                          "Plan Width": 103,
                                                          "Actual Startup Time": 0.014,
                                                          "Actual Total Time": 1.127,
                                                          "Actual Rows": 3233,
                                                          "Actual Loops": 1,
                                                          "Output": ["_hyper_8_2355_chunk.simulationrunid", "_hyper_8_2355_chunk.componentid", "_hyper_8_2355_chunk.discriminator", "_hyper_8_2355_chunk.elementid", "_hyper_8_2355_chunk.workorderid", "_hyper_8_2355_chunk.start", "_hyper_8_2355_chunk.finish"],
                                                          "Index Cond": "((_hyper_8_2355_chunk.simulationrunid = 325) AND ((_hyper_8_2355_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))",
                                                          "Rows Removed by Index Recheck": 0,
                                                          "Shared Hit Blocks": 924,
                                                          "Shared Read Blocks": 0,
                                                          "Shared Dirtied Blocks": 0,
                                                          "Shared Written Blocks": 0,
                                                          "Local Hit Blocks": 0,
                                                          "Local Read Blocks": 0,
                                                          "Local Dirtied Blocks": 0,
                                                          "Local Written Blocks": 0,
                                                          "Temp Read Blocks": 0,
                                                          "Temp Written Blocks": 0
                                                        },
                                                        {
                                                          "Node Type": "Index Scan",
                                                          "Parent Relationship": "Member",
                                                          "Parallel Aware": false,
                                                          "Async Capable": false,
                                                          "Scan Direction": "Forward",
                                                          "Index Name": "_hyper_8_2356_chunk_luworkertracking_idx",
                                                          "Relation Name": "_hyper_8_2356_chunk",
                                                          "Schema": "_timescaledb_internal",
                                                          "Alias": "_hyper_8_2356_chunk",
                                                          "Startup Cost": 0.41,
                                                          "Total Cost": 599.76,
                                                          "Plan Rows": 3441,
                                                          "Plan Width": 103,
                                                          "Actual Startup Time": 0.011,
                                                          "Actual Total Time": 1.209,
                                                          "Actual Rows": 3438,
                                                          "Actual Loops": 1,
                                                          "Output": ["_hyper_8_2356_chunk.simulationrunid", "_hyper_8_2356_chunk.componentid", "_hyper_8_2356_chunk.discriminator", "_hyper_8_2356_chunk.elementid", "_hyper_8_2356_chunk.workorderid", "_hyper_8_2356_chunk.start", "_hyper_8_2356_chunk.finish"],
                                                          "Index Cond": "((_hyper_8_2356_chunk.simulationrunid = 325) AND ((_hyper_8_2356_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))",
                                                          "Rows Removed by Index Recheck": 0,
                                                          "Shared Hit Blocks": 1019,
                                                          "Shared Read Blocks": 0,
                                                          "Shared Dirtied Blocks": 0,
                                                          "Shared Written Blocks": 0,
                                                          "Local Hit Blocks": 0,
                                                          "Local Read Blocks": 0,
                                                          "Local Dirtied Blocks": 0,
                                                          "Local Written Blocks": 0,
                                                          "Temp Read Blocks": 0,
                                                          "Temp Written Blocks": 0
                                                        },
                                                        {
                                                          "Node Type": "Index Scan",
                                                          "Parent Relationship": "Member",
                                                          "Parallel Aware": false,
                                                          "Async Capable": false,
                                                          "Scan Direction": "Forward",
                                                          "Index Name": "_hyper_8_2357_chunk_luworkertracking_idx",
                                                          "Relation Name": "_hyper_8_2357_chunk",
                                                          "Schema": "_timescaledb_internal",
                                                          "Alias": "_hyper_8_2357_chunk",
                                                          "Startup Cost": 0.29,
                                                          "Total Cost": 279.73,
                                                          "Plan Rows": 1131,
                                                          "Plan Width": 100,
                                                          "Actual Startup Time": 0.012,
                                                          "Actual Total Time": 0.484,
                                                          "Actual Rows": 1131,
                                                          "Actual Loops": 1,
                                                          "Output": ["_hyper_8_2357_chunk.simulationrunid", "_hyper_8_2357_chunk.componentid", "_hyper_8_2357_chunk.discriminator", "_hyper_8_2357_chunk.elementid", "_hyper_8_2357_chunk.workorderid", "_hyper_8_2357_chunk.start", "_hyper_8_2357_chunk.finish"],
                                                          "Index Cond": "((_hyper_8_2357_chunk.simulationrunid = 325) AND ((_hyper_8_2357_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))",
                                                          "Rows Removed by Index Recheck": 0,
                                                          "Shared Hit Blocks": 432,
                                                          "Shared Read Blocks": 0,
                                                          "Shared Dirtied Blocks": 0,
                                                          "Shared Written Blocks": 0,
                                                          "Local Hit Blocks": 0,
                                                          "Local Read Blocks": 0,
                                                          "Local Dirtied Blocks": 0,
                                                          "Local Written Blocks": 0,
                                                          "Temp Read Blocks": 0,
                                                          "Temp Written Blocks": 0
                                                        },
                                                        {
                                                          "Node Type": "Index Scan",
                                                          "Parent Relationship": "Member",
                                                          "Parallel Aware": false,
                                                          "Async Capable": false,
                                                          "Scan Direction": "Forward",
                                                          "Index Name": "_hyper_8_2358_chunk_luworkertracking_idx",
                                                          "Relation Name": "_hyper_8_2358_chunk",
                                                          "Schema": "_timescaledb_internal",
                                                          "Alias": "_hyper_8_2358_chunk",
                                                          "Startup Cost": 0.14,
                                                          "Total Cost": 1.75,
                                                          "Plan Rows": 1,
                                                          "Plan Width": 100,
                                                          "Actual Startup Time": 0.013,
                                                          "Actual Total Time": 0.013,
                                                          "Actual Rows": 0,
                                                          "Actual Loops": 1,
                                                          "Output": ["_hyper_8_2358_chunk.simulationrunid", "_hyper_8_2358_chunk.componentid", "_hyper_8_2358_chunk.discriminator", "_hyper_8_2358_chunk.elementid", "_hyper_8_2358_chunk.workorderid", "_hyper_8_2358_chunk.start", "_hyper_8_2358_chunk.finish"],
                                                          "Index Cond": "((_hyper_8_2358_chunk.simulationrunid = 325) AND ((_hyper_8_2358_chunk.discriminator)::text = 'TRACKING_TYPE_LU_AREA'::text))",
                                                          "Rows Removed by Index Recheck": 0,
                                                          "Shared Hit Blocks": 1,
                                                          "Shared Read Blocks": 0,
                                                          "Shared Dirtied Blocks": 0,
                                                          "Shared Written Blocks": 0,
                                                          "Local Hit Blocks": 0,
                                                          "Local Read Blocks": 0,
                                                          "Local Dirtied Blocks": 0,
                                                          "Local Written Blocks": 0,
                                                          "Temp Read Blocks": 0,
                                                          "Temp Written Blocks": 0
                                                        }
                                                      ]
                                                    }
                                                  ]
                                                },
                                                {
                                                  "Node Type": "Values Scan",
                                                  "Parent Relationship": "Inner",
                                                  "Parallel Aware": false,
                                                  "Async Capable": false,
                                                  "Alias": "*VALUES*",
                                                  "Startup Cost": 0.00,
                                                  "Total Cost": 0.03,
                                                  "Plan Rows": 1,
                                                  "Plan Width": 12,
                                                  "Actual Startup Time": 0.000,
                                                  "Actual Total Time": 0.000,
                                                  "Actual Rows": 1,
                                                  "Actual Loops": 32352,
                                                  "Output": ["\"*VALUES*\".column1", "\"*VALUES*\".column2"],
                                                  "Filter": "(\"*VALUES*\".column2 > 0)",
                                                  "Rows Removed by Filter": 1,
                                                  "Shared Hit Blocks": 0,
                                                  "Shared Read Blocks": 0,
                                                  "Shared Dirtied Blocks": 0,
                                                  "Shared Written Blocks": 0,
                                                  "Local Hit Blocks": 0,
                                                  "Local Read Blocks": 0,
                                                  "Local Dirtied Blocks": 0,
                                                  "Local Written Blocks": 0,
                                                  "Temp Read Blocks": 0,
                                                  "Temp Written Blocks": 0
                                                }
                                              ]
                                            }
                                          ]
                                        }
                                      ]
                                    }
                                  ]
                                }
                              ]
                            }
                          ]
                        }
                      ]
                    },
                    {
                      "Node Type": "Hash",
                      "Parent Relationship": "Inner",
                      "Parallel Aware": false,
                      "Async Capable": false,
                      "Startup Cost": 16490.59,
                      "Total Cost": 16490.59,
                      "Plan Rows": 6,
                      "Plan Width": 39,
                      "Actual Startup Time": 11.578,
                      "Actual Total Time": 11.579,
                      "Actual Rows": 4385,
                      "Actual Loops": 1,
                      "Output": ["lim_hard.sim_run_id", "lim_hard.component", "lim_hard.value"],
                      "Hash Buckets": 8192,
                      "Original Hash Buckets": 1024,
                      "Hash Batches": 1,
                      "Original Hash Batches": 1,
                      "Peak Memory Usage": 277,
                      "Shared Hit Blocks": 3340,
                      "Shared Read Blocks": 1507,
                      "Shared Dirtied Blocks": 0,
                      "Shared Written Blocks": 0,
                      "Local Hit Blocks": 0,
                      "Local Read Blocks": 0,
                      "Local Dirtied Blocks": 0,
                      "Local Written Blocks": 0,
                      "Temp Read Blocks": 0,
                      "Temp Written Blocks": 0,
                      "Plans": [
                        {
                          "Node Type": "Index Scan",
                          "Parent Relationship": "Outer",
                          "Parallel Aware": false,
                          "Async Capable": false,
                          "Scan Direction": "Forward",
                          "Index Name": "idx_simruncomponentmetadata_simrunid_key",
                          "Relation Name": "sim_run_component_metadata",
                          "Schema": "public",
                          "Alias": "lim_hard",
                          "Startup Cost": 0.43,
                          "Total Cost": 16490.59,
                          "Plan Rows": 6,
                          "Plan Width": 39,
                          "Actual Startup Time": 3.691,
                          "Actual Total Time": 10.739,
                          "Actual Rows": 4385,
                          "Actual Loops": 1,
                          "Output": ["lim_hard.sim_run_id", "lim_hard.component", "lim_hard.value"],
                          "Index Cond": "((lim_hard.key)::text = 'HARD'::text)",
                          "Rows Removed by Index Recheck": 0,
                          "Filter": "((lim_hard.generator)::text = 'AREA_CAPACITY'::text)",
                          "Rows Removed by Filter": 0,
                          "Shared Hit Blocks": 3340,
                          "Shared Read Blocks": 1507,
                          "Shared Dirtied Blocks": 0,
                          "Shared Written Blocks": 0,
                          "Local Hit Blocks": 0,
                          "Local Read Blocks": 0,
                          "Local Dirtied Blocks": 0,
                          "Local Written Blocks": 0,
                          "Temp Read Blocks": 0,
                          "Temp Written Blocks": 0
                        }
                      ]
                    }
                  ]
                },
                {
                  "Node Type": "Hash",
                  "Parent Relationship": "Inner",
                  "Parallel Aware": false,
                  "Async Capable": false,
                  "Startup Cost": 14857.95,
                  "Total Cost": 14857.95,
                  "Plan Rows": 1,
                  "Plan Width": 39,
                  "Actual Startup Time": 2.186,
                  "Actual Total Time": 2.187,
                  "Actual Rows": 2335,
                  "Actual Loops": 1,
                  "Output": ["lim_soft.sim_run_id", "lim_soft.component", "lim_soft.value"],
                  "Hash Buckets": 4096,
                  "Original Hash Buckets": 1024,
                  "Hash Batches": 1,
                  "Original Hash Batches": 1,
                  "Peak Memory Usage": 146,
                  "Shared Hit Blocks": 1980,
                  "Shared Read Blocks": 0,
                  "Shared Dirtied Blocks": 0,
                  "Shared Written Blocks": 0,
                  "Local Hit Blocks": 0,
                  "Local Read Blocks": 0,
                  "Local Dirtied Blocks": 0,
                  "Local Written Blocks": 0,
                  "Temp Read Blocks": 0,
                  "Temp Written Blocks": 0,
                  "Plans": [
                    {
                      "Node Type": "Index Scan",
                      "Parent Relationship": "Outer",
                      "Parallel Aware": false,
                      "Async Capable": false,
                      "Scan Direction": "Forward",
                      "Index Name": "idx_simruncomponentmetadata_simrunid_key",
                      "Relation Name": "sim_run_component_metadata",
                      "Schema": "public",
                      "Alias": "lim_soft",
                      "Startup Cost": 0.43,
                      "Total Cost": 14857.95,
                      "Plan Rows": 1,
                      "Plan Width": 39,
                      "Actual Startup Time": 0.582,
                      "Actual Total Time": 1.764,
                      "Actual Rows": 2335,
                      "Actual Loops": 1,
                      "Output": ["lim_soft.sim_run_id", "lim_soft.component", "lim_soft.value"],
                      "Index Cond": "((lim_soft.key)::text = 'SOFT'::text)",
                      "Rows Removed by Index Recheck": 0,
                      "Filter": "((lim_soft.generator)::text = 'AREA_CAPACITY'::text)",
                      "Rows Removed by Filter": 0,
                      "Shared Hit Blocks": 1980,
                      "Shared Read Blocks": 0,
                      "Shared Dirtied Blocks": 0,
                      "Shared Written Blocks": 0,
                      "Local Hit Blocks": 0,
                      "Local Read Blocks": 0,
                      "Local Dirtied Blocks": 0,
                      "Local Written Blocks": 0,
                      "Temp Read Blocks": 0,
                      "Temp Written Blocks": 0
                    }
                  ]
                }
              ]
            }
          ]
        },
        {
          "Node Type": "Materialize",
          "Parent Relationship": "Inner",
          "Parallel Aware": false,
          "Async Capable": false,
          "Startup Cost": 17100.87,
          "Total Cost": 17268.38,
          "Plan Rows": 1000,
          "Plan Width": 125,
          "Actual Startup Time": 70922.634,
          "Actual Total Time": 71056.269,
          "Actual Rows": 27545,
          "Actual Loops": 1,
          "Output": ["lu_holding_buckets.simulationrunid", "lu_holding_buckets.componentid", "lu_holding_buckets.bucket_start", "((lu_holding_buckets.bucket_start + '01:00:00'::interval))", "(sum(CASE WHEN ((lu_holding_buckets.finish >= lu_holding_buckets.bucket_start) AND (lu_holding_buckets.finish < ((lu_holding_buckets.bucket_start + '01:00:00'::interval)))) THEN 1 ELSE 0 END))", "(sum(CASE WHEN (lu_holding_buckets.finish >= ((lu_holding_buckets.bucket_start + '01:00:00'::interval))) THEN 1 ELSE 0 END))", "(sum(CASE WHEN ((lu_holding_buckets.finish >= lu_holding_buckets.bucket_start) AND (lu_holding_buckets.finish < ((lu_holding_buckets.bucket_start + '01:00:00'::interval))) AND (lu_holding_buckets.finish > lu_holding_buckets.late_ref_time)) THEN 1 ELSE 0 END))", "(sum(CASE WHEN ((lu_holding_buckets.finish >= ((lu_holding_buckets.bucket_start + '01:00:00'::interval))) AND (lu_holding_buckets.late_ref_time < ((lu_holding_buckets.bucket_start + '01:00:00'::interval))) AND (lu_holding_buckets.finish > lu_holding_buckets.late_ref_time)) THEN 1 ELSE 0 END))", "(EXTRACT(epoch FROM sum((CASE WHEN (work_order_buckets.finish < ((work_order_buckets.bucket_start + '01:00:00'::interval))) THEN work_order_buckets.finish ELSE ((work_order_buckets.bucket_start + '01:00:00'::interval)) END - CASE WHEN (work_order_buckets.start > work_order_buckets.bucket_start) THEN work_order_buckets.start ELSE work_order_buckets.bucket_start END))))", "(count(DISTINCT work_order_buckets.workerid))", "(count(DISTINCT work_order_buckets.workorderid))", "(sum(CASE WHEN (work_order_buckets.finish >= ((work_order_buckets.bucket_start + '01:00:00'::interval))) THEN 1 ELSE 0 END))", "(sum(CASE WHEN ((work_order_buckets.finish >= ((work_order_buckets.bucket_start + '01:00:00'::interval))) AND (work_order_buckets.finish > work_order_buckets.late_ref_time)) THEN 1 ELSE 0 END))"],
          "Shared Hit Blocks": 147520,
          "Shared Read Blocks": 1,
          "Shared Dirtied Blocks": 0,
          "Shared Written Blocks": 0,
          "Local Hit Blocks": 0,
          "Local Read Blocks": 0,
          "Local Dirtied Blocks": 0,
          "Local Written Blocks": 0,
          "Temp Read Blocks": 1933,
          "Temp Written Blocks": 1934,
          "Plans": [
            {
              "Node Type": "Merge Join",
              "Parent Relationship": "Outer",
              "Parallel Aware": false,
              "Async Capable": false,
              "Join Type": "Left",
              "Startup Cost": 17100.87,
              "Total Cost": 17265.88,
              "Plan Rows": 1000,
              "Plan Width": 125,
              "Actual Startup Time": 70922.603,
              "Actual Total Time": 71047.578,
              "Actual Rows": 27545,
              "Actual Loops": 1,
              "Output": ["lu_holding_buckets.simulationrunid", "lu_holding_buckets.componentid", "lu_holding_buckets.bucket_start", "((lu_holding_buckets.bucket_start + '01:00:00'::interval))", "(sum(CASE WHEN ((lu_holding_buckets.finish >= lu_holding_buckets.bucket_start) AND (lu_holding_buckets.finish < ((lu_holding_buckets.bucket_start + '01:00:00'::interval)))) THEN 1 ELSE 0 END))", "(sum(CASE WHEN (lu_holding_buckets.finish >= ((lu_holding_buckets.bucket_start + '01:00:00'::interval))) THEN 1 ELSE 0 END))", "(sum(CASE WHEN ((lu_holding_buckets.finish >= lu_holding_buckets.bucket_start) AND (lu_holding_buckets.finish < ((lu_holding_buckets.bucket_start + '01:00:00'::interval))) AND (lu_holding_buckets.finish > lu_holding_buckets.late_ref_time)) THEN 1 ELSE 0 END))", "(sum(CASE WHEN ((lu_holding_buckets.finish >= ((lu_holding_buckets.bucket_start + '01:00:00'::interval))) AND (lu_holding_buckets.late_ref_time < ((lu_holding_buckets.bucket_start + '01:00:00'::interval))) AND (lu_holding_buckets.finish > lu_holding_buckets.late_ref_time)) THEN 1 ELSE 0 END))", "(EXTRACT(epoch FROM sum((CASE WHEN (work_order_buckets.finish < ((work_order_buckets.bucket_start + '01:00:00'::interval))) THEN work_order_buckets.finish ELSE ((work_order_buckets.bucket_start + '01:00:00'::interval)) END - CASE WHEN (work_order_buckets.start > work_order_buckets.bucket_start) THEN work_order_buckets.start ELSE work_order_buckets.bucket_start END))))", "(count(DISTINCT work_order_buckets.workerid))", "(count(DISTINCT work_order_buckets.workorderid))", "(sum(CASE WHEN (work_order_buckets.finish >= ((work_order_buckets.bucket_start + '01:00:00'::interval))) THEN 1 ELSE 0 END))", "(sum(CASE WHEN ((work_order_buckets.finish >= ((work_order_buckets.bucket_start + '01:00:00'::interval))) AND (work_order_buckets.finish > work_order_buckets.late_ref_time)) THEN 1 ELSE 0 END))"],
              "Inner Unique": true,
              "Merge Cond": "((lu_holding_buckets.simulationrunid = work_order_buckets.simulationrunid) AND ((lu_holding_buckets.componentid)::text = (work_order_buckets.componentid)::text) AND (lu_holding_buckets.bucket_start = work_order_buckets.bucket_start) AND (((lu_holding_buckets.bucket_start + '01:00:00'::interval)) = ((work_order_buckets.bucket_start + '01:00:00'::interval))))",
              "Shared Hit Blocks": 147520,
              "Shared Read Blocks": 1,
              "Shared Dirtied Blocks": 0,
              "Shared Written Blocks": 0,
              "Local Hit Blocks": 0,
              "Local Read Blocks": 0,
              "Local Dirtied Blocks": 0,
              "Local Written Blocks": 0,
              "Temp Read Blocks": 1933,
              "Temp Written Blocks": 1934,
              "Plans": [
                {
                  "Node Type": "Aggregate",
                  "Strategy": "Sorted",
                  "Partial Mode": "Simple",
                  "Parent Relationship": "Outer",
                  "Parallel Aware": false,
                  "Async Capable": false,
                  "Startup Cost": 8450.04,
                  "Total Cost": 8520.04,
                  "Plan Rows": 1000,
                  "Plan Width": 61,
                  "Actual Startup Time": 34046.917,
                  "Actual Total Time": 34151.241,
                  "Actual Rows": 27545,
                  "Actual Loops": 1,
                  "Output": ["lu_holding_buckets.simulationrunid", "lu_holding_buckets.componentid", "lu_holding_buckets.bucket_start", "((lu_holding_buckets.bucket_start + '01:00:00'::interval))", "sum(CASE WHEN ((lu_holding_buckets.finish >= lu_holding_buckets.bucket_start) AND (lu_holding_buckets.finish < ((lu_holding_buckets.bucket_start + '01:00:00'::interval)))) THEN 1 ELSE 0 END)", "sum(CASE WHEN (lu_holding_buckets.finish >= ((lu_holding_buckets.bucket_start + '01:00:00'::interval))) THEN 1 ELSE 0 END)", "sum(CASE WHEN ((lu_holding_buckets.finish >= lu_holding_buckets.bucket_start) AND (lu_holding_buckets.finish < ((lu_holding_buckets.bucket_start + '01:00:00'::interval))) AND (lu_holding_buckets.finish > lu_holding_buckets.late_ref_time)) THEN 1 ELSE 0 END)", "sum(CASE WHEN ((lu_holding_buckets.finish >= ((lu_holding_buckets.bucket_start + '01:00:00'::interval))) AND (lu_holding_buckets.late_ref_time < ((lu_holding_buckets.bucket_start + '01:00:00'::interval))) AND (lu_holding_buckets.finish > lu_holding_buckets.late_ref_time)) THEN 1 ELSE 0 END)"],
                  "Group Key": ["lu_holding_buckets.simulationrunid", "lu_holding_buckets.componentid", "lu_holding_buckets.bucket_start", "((lu_holding_buckets.bucket_start + '01:00:00'::interval))"],
                  "Shared Hit Blocks": 12498,
                  "Shared Read Blocks": 1,
                  "Shared Dirtied Blocks": 0,
                  "Shared Written Blocks": 0,
                  "Local Hit Blocks": 0,
                  "Local Read Blocks": 0,
                  "Local Dirtied Blocks": 0,
                  "Local Written Blocks": 0,
                  "Temp Read Blocks": 1933,
                  "Temp Written Blocks": 1934,
                  "Plans": [
                    {
                      "Node Type": "Sort",
                      "Parent Relationship": "Outer",
                      "Parallel Aware": false,
                      "Async Capable": false,
                      "Startup Cost": 8450.04,
                      "Total Cost": 8452.54,
                      "Plan Rows": 1000,
                      "Plan Width": 45,
                      "Actual Startup Time": 34046.901,
                      "Actual Total Time": 34093.430,
                      "Actual Rows": 272354,
                      "Actual Loops": 1,
                      "Output": ["lu_holding_buckets.simulationrunid", "lu_holding_buckets.componentid", "lu_holding_buckets.bucket_start", "((lu_holding_buckets.bucket_start + '01:00:00'::interval))", "lu_holding_buckets.finish", "lu_holding_buckets.late_ref_time"],
                      "Sort Key": ["lu_holding_buckets.simulationrunid", "lu_holding_buckets.componentid", "lu_holding_buckets.bucket_start", "((lu_holding_buckets.bucket_start + '01:00:00'::interval))"],
                      "Sort Method": "external merge",
                      "Sort Space Used": 15464,
                      "Sort Space Type": "Disk",
                      "Shared Hit Blocks": 12498,
                      "Shared Read Blocks": 1,
                      "Shared Dirtied Blocks": 0,
                      "Shared Written Blocks": 0,
                      "Local Hit Blocks": 0,
                      "Local Read Blocks": 0,
                      "Local Dirtied Blocks": 0,
                      "Local Written Blocks": 0,
                      "Temp Read Blocks": 1933,
                      "Temp Written Blocks": 1934,
                      "Plans": [
                        {
                          "Node Type": "Subquery Scan",
                          "Parent Relationship": "Outer",
                          "Parallel Aware": false,
                          "Async Capable": false,
                          "Alias": "lu_holding_buckets",
                          "Startup Cost": 9.07,
                          "Total Cost": 8400.21,
                          "Plan Rows": 1000,
                          "Plan Width": 45,
                          "Actual Startup Time": 27.862,
                          "Actual Total Time": 33825.146,
                          "Actual Rows": 272354,
                          "Actual Loops": 1,
                          "Output": ["lu_holding_buckets.simulationrunid", "lu_holding_buckets.componentid", "lu_holding_buckets.bucket_start", "(lu_holding_buckets.bucket_start + '01:00:00'::interval)", "lu_holding_buckets.finish", "lu_holding_buckets.late_ref_time"],
                          "Shared Hit Blocks": 12498,
                          "Shared Read Blocks": 1,
                          "Shared Dirtied Blocks": 0,
                          "Shared Written Blocks": 0,
                          "Local Hit Blocks": 0,
                          "Local Read Blocks": 0,
                          "Local Dirtied Blocks": 0,
                          "Local Written Blocks": 0,
                          "Temp Read Blocks": 0,
                          "Temp Written Blocks": 0,
                          "Plans": [
                            {
                              "Node Type": "ProjectSet",
                              "Parent Relationship": "Subquery",
                              "Parallel Aware": false,
                              "Async Capable": false,
                              "Startup Cost": 9.07,
                              "Total Cost": 8387.71,
                              "Plan Rows": 1000,
                              "Plan Width": 77,
                              "Actual Startup Time": 27.860,
                              "Actual Total Time": 33802.125,
                              "Actual Rows": 272354,
                              "Actual Loops": 1,
                              "Output": ["_hyper_8_2343_chunk_1.simulationrunid", "_hyper_8_2343_chunk_1.componentid", "NULL::character varying", "NULL::timestamp with time zone", "_hyper_8_2343_chunk_1.finish", "generate_series(time_bucket('01:00:00'::interval, _hyper_8_2343_chunk_1.start), time_bucket('01:00:00'::interval, _hyper_8_2343_chunk_1.finish), '01:00:00'::interval)", "((sim_run_component_metadata.value)::timestamp with time zone)"],
                              "Shared Hit Blocks": 12498,
                              "Shared Read Blocks": 1,
                              "Shared Dirtied Blocks": 0,
                              "Shared Written Blocks": 0,
                              "Local Hit Blocks": 0,
                              "Local Read Blocks": 0,
                              "Local Dirtied Blocks": 0,
                              "Local Written Blocks": 0,
                              "Temp Read Blocks": 0,
                              "Temp Written Blocks": 0,
                              "Plans": [
                                {
                                  "Node Type": "Nested Loop",
                                  "Parent Relationship": "Outer",
                                  "Parallel Aware": false,
                                  "Async Capable": false,
                                  "Join Type": "Left",
                                  "Startup Cost": 9.07,
                                  "Total Cost": 8382.70,
                                  "Plan Rows": 1,
                                  "Plan Width": 37,
                                  "Actual Startup Time": 27.856,
                                  "Actual Total Time": 33769.441,
                                  "Actual Rows": 32352,
                                  "Actual Loops": 1,
                                  "Output": ["_hyper_8_2343_chunk_1.start", "_hyper_8_2343_chunk_1.finish", "_hyper_8_2343_chunk_1.simulationrunid", "_hyper_8_2343_chunk_1.componentid", "((sim_run_component_metadata.value)::timestamp with time zone)"],
                                  "Inner Unique": false,
                                  "Join Filter": "(((sim_run_component_metadata.generator)::text = (e.elementcreatedatcomponentid)::text) AND ((sim_run_component_metadata.component)::text = (_hyper_8_2343_chunk_1.componentid)::text))",
                                  "Rows Removed by Join Filter": 337204896,
                                  "Shared Hit Blocks": 12498,
                                  "Shared Read Blocks": 1,
                                  "Shared Dirtied Blocks": 0,
                                  "Shared Written Blocks": 0,
                                  "Local Hit Blocks": 0,
                                  "Local Read Blocks": 0,
                                  "Local Dirtied Blocks": 0,
                                  "Local Written Blocks": 0,
                                  "Temp Read Blocks": 0,
                                  "Temp Written Blocks": 0,
                                  "Plans": [
                                    {
                                      "Node Type": "Hash Join",
                                      "Parent Relationship": "Outer",
                                      "Parallel Aware": false,
                                      "Async Capable": false,
                                      "Join Type": "Inner",
                                      "Startup Cost": 7.02,
                                      "Total Cost": 8380.63,
                                      "Plan Rows": 1,
                                      "Plan Width": 61,
                                      "Actual Startup Time": 6.236,
                                      "Actual Total Time": 107.050,
                                      "Actual Rows": 32352,
                                      "Actual Loops": 1,
                                      "Output": ["_hyper_8_2343_chunk_1.simulationrunid", "_hyper_8_2343_chunk_1.componentid", "_hyper_8_2343_chunk_1.finish", "_hyper_8_2343_chunk_1.start", "e.elementcreatedatcomponentid"],
                                      "Inner Unique": false,
                                      "Hash Cond": "((_hyper_8_2343_chunk_1.simulationrunid = e.simulationrunid) AND ((_hyper_8_2343_chunk_1.elementid)::text = (e.elementid)::text))",
                                      "Shared Hit Blocks": 12279,
                                      "Shared Read Blocks": 0,
                                      "Shared Dirtied Blocks": 0,
                                      "Shared Written Blocks": 0,
                                      "Local Hit Blocks": 0,
                                      "Local Read Blocks": 0,
                                      "Local Dirtied Blocks": 0,
                                      "Local Written Blocks": 0,
                                      "Temp Read Blocks": 0,
                                      "Temp Written Blocks": 0,
                                      "Plans": [
                                        {
                                          "Node Type": "Incremental Sort",
                                          "Parent Relationship": "Outer",
                                          "Parallel Aware": false,
                                          "Async Capable": false,
                                          "Startup Cost": 6.99,
                                          "Total Cost": 7827.15,
                                          "Plan Rows": 31625,
                                          "Plan Width": 99,
                                          "Actual Startup Time": 0.284,
                                          "Actual Total Time": 78.387,
                                          "Actual Rows": 32352,
                                          "Actual Loops": 1,
                                          "Output": ["_hyper_8_2343_chunk_1.simulationrunid", "_hyper_8_2343_chunk_1.componentid", "_hyper_8_2343_chunk_1.discriminator", "_hyper_8_2343_chunk_1.elementid", "_hyper_8_2343_chunk_1.workorderid", "_hyper_8_2343_chunk_1.start", "_hyper_8_2343_chunk_1.finish"],
                                          "Sort Key": ["_hyper_8_2343_chunk_1.componentid", "_hyper_8_2343_chunk_1.elementid", "_hyper_8_2343_chunk_1.workorderid", "_hyper_8_2343_chunk_1.start", "_hyper_8_2343_chunk_1.finish"],
                                          "Presorted Key": ["_hyper_8_2343_chunk_1.componentid"],
                                          "Full-sort Groups": {
                                            "Group Count": 127,
                                            "Sort Methods Used": ["quicksort"],
                                            "Sort Space Memory": {
                                              "Average Sort Space Used": 28,
                                              "Peak Sort Space Used": 28
                                            }
                                          },
                                          "Pre-sorted Groups": {
                                            "Group Count": 96,
                                            "Sort Methods Used": ["quicksort"],
                                            "Sort Space Memory": {
                                              "Average Sort Space Used": 60,
                                              "Peak Sort Space Used": 1172
                                            }
                                          },
                                          "Shared Hit Blocks": 9178,
                                          "Shared Read Blocks": 0,
                                          "Shared Dirtied Blocks": 0,
                                          "Shared Written Blocks": 0,
                                          "Local Hit Blocks": 0,
                                          "Local Read Blocks": 0,
                                          "Local Dirtied Blocks": 0,
                                          "Local Written Blocks": 0,
                                          "Temp Read Blocks": 0,
                                          "Temp Written Blocks": 0,
                                          "Plans": [
                                            {
                                              "Node Type": "Merge Append",
                                              "Parent Relationship": "Outer",
                                              "Parallel Aware": false,
                                              "Async Capable": false,
                                              "Startup Cost": 4.74,
                                              "Total Cost": 6848.78,
                                              "Plan Rows": 31625,
                                              "Plan Width": 98,
                                              "Actual Startup Time": 0.220,
                                              "Actual Total Time": 19.596,
                                              "Actual Rows": 32352,
                                              "Actual Loops": 1,
                                              "Sort Key": ["_hyper_8_2343_chunk_1.componentid"],
                                              "Shared Hit Blocks": 9178,
                                              "Shared Read Blocks": 0,
                                              "Shared Dirtied Blocks": 0,
                                              "Shared Written Blocks": 0,
                                              "Local Hit Blocks": 0,
                                              "Local Read Blocks": 0,
                                              "Local Dirtied Blocks": 0,
                                              "Local Written Blocks": 0,
                                              "Temp Read Blocks": 0,
                                              "Temp Written Blocks": 0,
                                              "Subplans Removed": 0,
                                              "Plans": [
                                                {
                                                  "Node Type": "Index Scan",
                                                  "Parent Relationship": "Member",
                                                  "Parallel Aware": false,
                                                  "Async Capable": false,
                                                  "Scan Direction": "Forward",
                                                  "Index Name": "_hyper_8_2343_chunk_luworkertracking_idx",
                                                  "Relation Name": "_hyper_8_2343_chunk",
                                                  "Schema": "_timescaledb_internal",
                                                  "Alias": "_hyper_8_2343_chunk_1",
                                                  "Startup Cost": 0.29,
                                                  "Total Cost": 438.10,
                                                  "Plan Rows": 2146,
                                                  "Plan Width": 93,
                                                  "Actual Startup Time": 0.021,
                                                  "Actual Total Time": 1.216,
                                                  "Actual Rows": 2179,
                                                  "Actual Loops": 1,
                                                  "Output": ["_hyper_8_2343_chunk_1.simulationrunid", "_hyper_8_2343_chunk_1.componentid", "_hyper_8_2343_chunk_1.discriminator", "_hyper_8_2343_chunk_1.elementid", "_hyper_8_2343_chunk_1.workorderid", "_hyper_8_2343_chunk_1.start", "_hyper_8_2343_chunk_1.finish"],
                                                  "Index Cond": "((_hyper_8_2343_chunk_1.simulationrunid = 325) AND ((_hyper_8_2343_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))",
                                                  "Rows Removed by Index Recheck": 0,
                                                  "Shared Hit Blocks": 645,
                                                  "Shared Read Blocks": 0,
                                                  "Shared Dirtied Blocks": 0,
                                                  "Shared Written Blocks": 0,
                                                  "Local Hit Blocks": 0,
                                                  "Local Read Blocks": 0,
                                                  "Local Dirtied Blocks": 0,
                                                  "Local Written Blocks": 0,
                                                  "Temp Read Blocks": 0,
                                                  "Temp Written Blocks": 0
                                                },
                                                {
                                                  "Node Type": "Index Scan",
                                                  "Parent Relationship": "Member",
                                                  "Parallel Aware": false,
                                                  "Async Capable": false,
                                                  "Scan Direction": "Forward",
                                                  "Index Name": "_hyper_8_2344_chunk_luworkertracking_idx",
                                                  "Relation Name": "_hyper_8_2344_chunk",
                                                  "Schema": "_timescaledb_internal",
                                                  "Alias": "_hyper_8_2344_chunk_1",
                                                  "Startup Cost": 0.29,
                                                  "Total Cost": 462.90,
                                                  "Plan Rows": 2188,
                                                  "Plan Width": 101,
                                                  "Actual Startup Time": 0.013,
                                                  "Actual Total Time": 1.352,
                                                  "Actual Rows": 2179,
                                                  "Actual Loops": 1,
                                                  "Output": ["_hyper_8_2344_chunk_1.simulationrunid", "_hyper_8_2344_chunk_1.componentid", "_hyper_8_2344_chunk_1.discriminator", "_hyper_8_2344_chunk_1.elementid", "_hyper_8_2344_chunk_1.workorderid", "_hyper_8_2344_chunk_1.start", "_hyper_8_2344_chunk_1.finish"],
                                                  "Index Cond": "((_hyper_8_2344_chunk_1.simulationrunid = 325) AND ((_hyper_8_2344_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))",
                                                  "Rows Removed by Index Recheck": 0,
                                                  "Shared Hit Blocks": 818,
                                                  "Shared Read Blocks": 0,
                                                  "Shared Dirtied Blocks": 0,
                                                  "Shared Written Blocks": 0,
                                                  "Local Hit Blocks": 0,
                                                  "Local Read Blocks": 0,
                                                  "Local Dirtied Blocks": 0,
                                                  "Local Written Blocks": 0,
                                                  "Temp Read Blocks": 0,
                                                  "Temp Written Blocks": 0
                                                },
                                                {
                                                  "Node Type": "Index Scan",
                                                  "Parent Relationship": "Member",
                                                  "Parallel Aware": false,
                                                  "Async Capable": false,
                                                  "Scan Direction": "Forward",
                                                  "Index Name": "_hyper_8_2345_chunk_luworkertracking_idx",
                                                  "Relation Name": "_hyper_8_2345_chunk",
                                                  "Schema": "_timescaledb_internal",
                                                  "Alias": "_hyper_8_2345_chunk_1",
                                                  "Startup Cost": 0.13,
                                                  "Total Cost": 2.35,
                                                  "Plan Rows": 1,
                                                  "Plan Width": 120,
                                                  "Actual Startup Time": 0.007,
                                                  "Actual Total Time": 0.007,
                                                  "Actual Rows": 0,
                                                  "Actual Loops": 1,
                                                  "Output": ["_hyper_8_2345_chunk_1.simulationrunid", "_hyper_8_2345_chunk_1.componentid", "_hyper_8_2345_chunk_1.discriminator", "_hyper_8_2345_chunk_1.elementid", "_hyper_8_2345_chunk_1.workorderid", "_hyper_8_2345_chunk_1.start", "_hyper_8_2345_chunk_1.finish"],
                                                  "Index Cond": "((_hyper_8_2345_chunk_1.simulationrunid = 325) AND ((_hyper_8_2345_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))",
                                                  "Rows Removed by Index Recheck": 0,
                                                  "Shared Hit Blocks": 1,
                                                  "Shared Read Blocks": 0,
                                                  "Shared Dirtied Blocks": 0,
                                                  "Shared Written Blocks": 0,
                                                  "Local Hit Blocks": 0,
                                                  "Local Read Blocks": 0,
                                                  "Local Dirtied Blocks": 0,
                                                  "Local Written Blocks": 0,
                                                  "Temp Read Blocks": 0,
                                                  "Temp Written Blocks": 0
                                                },
                                                {
                                                  "Node Type": "Index Scan",
                                                  "Parent Relationship": "Member",
                                                  "Parallel Aware": false,
                                                  "Async Capable": false,
                                                  "Scan Direction": "Forward",
                                                  "Index Name": "_hyper_8_2346_chunk_luworkertracking_idx",
                                                  "Relation Name": "_hyper_8_2346_chunk",
                                                  "Schema": "_timescaledb_internal",
                                                  "Alias": "_hyper_8_2346_chunk_1",
                                                  "Startup Cost": 0.29,
                                                  "Total Cost": 219.37,
                                                  "Plan Rows": 1137,
                                                  "Plan Width": 96,
                                                  "Actual Startup Time": 0.014,
                                                  "Actual Total Time": 0.402,
                                                  "Actual Rows": 1200,
                                                  "Actual Loops": 1,
                                                  "Output": ["_hyper_8_2346_chunk_1.simulationrunid", "_hyper_8_2346_chunk_1.componentid", "_hyper_8_2346_chunk_1.discriminator", "_hyper_8_2346_chunk_1.elementid", "_hyper_8_2346_chunk_1.workorderid", "_hyper_8_2346_chunk_1.start", "_hyper_8_2346_chunk_1.finish"],
                                                  "Index Cond": "((_hyper_8_2346_chunk_1.simulationrunid = 325) AND ((_hyper_8_2346_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))",
                                                  "Rows Removed by Index Recheck": 0,
                                                  "Shared Hit Blocks": 191,
                                                  "Shared Read Blocks": 0,
                                                  "Shared Dirtied Blocks": 0,
                                                  "Shared Written Blocks": 0,
                                                  "Local Hit Blocks": 0,
                                                  "Local Read Blocks": 0,
                                                  "Local Dirtied Blocks": 0,
                                                  "Local Written Blocks": 0,
                                                  "Temp Read Blocks": 0,
                                                  "Temp Written Blocks": 0
                                                },
                                                {
                                                  "Node Type": "Index Scan",
                                                  "Parent Relationship": "Member",
                                                  "Parallel Aware": false,
                                                  "Async Capable": false,
                                                  "Scan Direction": "Forward",
                                                  "Index Name": "_hyper_8_2347_chunk_luworkertracking_idx",
                                                  "Relation Name": "_hyper_8_2347_chunk",
                                                  "Schema": "_timescaledb_internal",
                                                  "Alias": "_hyper_8_2347_chunk_1",
                                                  "Startup Cost": 0.29,
                                                  "Total Cost": 437.97,
                                                  "Plan Rows": 2014,
                                                  "Plan Width": 94,
                                                  "Actual Startup Time": 0.015,
                                                  "Actual Total Time": 0.939,
                                                  "Actual Rows": 2237,
                                                  "Actual Loops": 1,
                                                  "Output": ["_hyper_8_2347_chunk_1.simulationrunid", "_hyper_8_2347_chunk_1.componentid", "_hyper_8_2347_chunk_1.discriminator", "_hyper_8_2347_chunk_1.elementid", "_hyper_8_2347_chunk_1.workorderid", "_hyper_8_2347_chunk_1.start", "_hyper_8_2347_chunk_1.finish"],
                                                  "Index Cond": "((_hyper_8_2347_chunk_1.simulationrunid = 325) AND ((_hyper_8_2347_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))",
                                                  "Rows Removed by Index Recheck": 0,
                                                  "Shared Hit Blocks": 558,
                                                  "Shared Read Blocks": 0,
                                                  "Shared Dirtied Blocks": 0,
                                                  "Shared Written Blocks": 0,
                                                  "Local Hit Blocks": 0,
                                                  "Local Read Blocks": 0,
                                                  "Local Dirtied Blocks": 0,
                                                  "Local Written Blocks": 0,
                                                  "Temp Read Blocks": 0,
                                                  "Temp Written Blocks": 0
                                                },
                                                {
                                                  "Node Type": "Index Scan",
                                                  "Parent Relationship": "Member",
                                                  "Parallel Aware": false,
                                                  "Async Capable": false,
                                                  "Scan Direction": "Forward",
                                                  "Index Name": "_hyper_8_2348_chunk_luworkertracking_idx",
                                                  "Relation Name": "_hyper_8_2348_chunk",
                                                  "Schema": "_timescaledb_internal",
                                                  "Alias": "_hyper_8_2348_chunk_1",
                                                  "Startup Cost": 0.29,
                                                  "Total Cost": 481.01,
                                                  "Plan Rows": 2711,
                                                  "Plan Width": 94,
                                                  "Actual Startup Time": 0.014,
                                                  "Actual Total Time": 1.297,
                                                  "Actual Rows": 2758,
                                                  "Actual Loops": 1,
                                                  "Output": ["_hyper_8_2348_chunk_1.simulationrunid", "_hyper_8_2348_chunk_1.componentid", "_hyper_8_2348_chunk_1.discriminator", "_hyper_8_2348_chunk_1.elementid", "_hyper_8_2348_chunk_1.workorderid", "_hyper_8_2348_chunk_1.start", "_hyper_8_2348_chunk_1.finish"],
                                                  "Index Cond": "((_hyper_8_2348_chunk_1.simulationrunid = 325) AND ((_hyper_8_2348_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))",
                                                  "Rows Removed by Index Recheck": 0,
                                                  "Shared Hit Blocks": 776,
                                                  "Shared Read Blocks": 0,
                                                  "Shared Dirtied Blocks": 0,
                                                  "Shared Written Blocks": 0,
                                                  "Local Hit Blocks": 0,
                                                  "Local Read Blocks": 0,
                                                  "Local Dirtied Blocks": 0,
                                                  "Local Written Blocks": 0,
                                                  "Temp Read Blocks": 0,
                                                  "Temp Written Blocks": 0
                                                },
                                                {
                                                  "Node Type": "Index Scan",
                                                  "Parent Relationship": "Member",
                                                  "Parallel Aware": false,
                                                  "Async Capable": false,
                                                  "Scan Direction": "Forward",
                                                  "Index Name": "_hyper_8_2349_chunk_luworkertracking_idx",
                                                  "Relation Name": "_hyper_8_2349_chunk",
                                                  "Schema": "_timescaledb_internal",
                                                  "Alias": "_hyper_8_2349_chunk_1",
                                                  "Startup Cost": 0.29,
                                                  "Total Cost": 539.85,
                                                  "Plan Rows": 3233,
                                                  "Plan Width": 95,
                                                  "Actual Startup Time": 0.013,
                                                  "Actual Total Time": 1.352,
                                                  "Actual Rows": 3233,
                                                  "Actual Loops": 1,
                                                  "Output": ["_hyper_8_2349_chunk_1.simulationrunid", "_hyper_8_2349_chunk_1.componentid", "_hyper_8_2349_chunk_1.discriminator", "_hyper_8_2349_chunk_1.elementid", "_hyper_8_2349_chunk_1.workorderid", "_hyper_8_2349_chunk_1.start", "_hyper_8_2349_chunk_1.finish"],
                                                  "Index Cond": "((_hyper_8_2349_chunk_1.simulationrunid = 325) AND ((_hyper_8_2349_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))",
                                                  "Rows Removed by Index Recheck": 0,
                                                  "Shared Hit Blocks": 863,
                                                  "Shared Read Blocks": 0,
                                                  "Shared Dirtied Blocks": 0,
                                                  "Shared Written Blocks": 0,
                                                  "Local Hit Blocks": 0,
                                                  "Local Read Blocks": 0,
                                                  "Local Dirtied Blocks": 0,
                                                  "Local Written Blocks": 0,
                                                  "Temp Read Blocks": 0,
                                                  "Temp Written Blocks": 0
                                                },
                                                {
                                                  "Node Type": "Index Scan",
                                                  "Parent Relationship": "Member",
                                                  "Parallel Aware": false,
                                                  "Async Capable": false,
                                                  "Scan Direction": "Forward",
                                                  "Index Name": "_hyper_8_2350_chunk_luworkertracking_idx",
                                                  "Relation Name": "_hyper_8_2350_chunk",
                                                  "Schema": "_timescaledb_internal",
                                                  "Alias": "_hyper_8_2350_chunk_1",
                                                  "Startup Cost": 0.29,
                                                  "Total Cost": 569.79,
                                                  "Plan Rows": 3435,
                                                  "Plan Width": 95,
                                                  "Actual Startup Time": 0.011,
                                                  "Actual Total Time": 1.514,
                                                  "Actual Rows": 3438,
                                                  "Actual Loops": 1,
                                                  "Output": ["_hyper_8_2350_chunk_1.simulationrunid", "_hyper_8_2350_chunk_1.componentid", "_hyper_8_2350_chunk_1.discriminator", "_hyper_8_2350_chunk_1.elementid", "_hyper_8_2350_chunk_1.workorderid", "_hyper_8_2350_chunk_1.start", "_hyper_8_2350_chunk_1.finish"],
                                                  "Index Cond": "((_hyper_8_2350_chunk_1.simulationrunid = 325) AND ((_hyper_8_2350_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))",
                                                  "Rows Removed by Index Recheck": 0,
                                                  "Shared Hit Blocks": 926,
                                                  "Shared Read Blocks": 0,
                                                  "Shared Dirtied Blocks": 0,
                                                  "Shared Written Blocks": 0,
                                                  "Local Hit Blocks": 0,
                                                  "Local Read Blocks": 0,
                                                  "Local Dirtied Blocks": 0,
                                                  "Local Written Blocks": 0,
                                                  "Temp Read Blocks": 0,
                                                  "Temp Written Blocks": 0
                                                },
                                                {
                                                  "Node Type": "Index Scan",
                                                  "Parent Relationship": "Member",
                                                  "Parallel Aware": false,
                                                  "Async Capable": false,
                                                  "Scan Direction": "Forward",
                                                  "Index Name": "_hyper_8_2351_chunk_luworkertracking_idx",
                                                  "Relation Name": "_hyper_8_2351_chunk",
                                                  "Schema": "_timescaledb_internal",
                                                  "Alias": "_hyper_8_2351_chunk_1",
                                                  "Startup Cost": 0.29,
                                                  "Total Cost": 272.42,
                                                  "Plan Rows": 1143,
                                                  "Plan Width": 93,
                                                  "Actual Startup Time": 0.012,
                                                  "Actual Total Time": 0.537,
                                                  "Actual Rows": 1131,
                                                  "Actual Loops": 1,
                                                  "Output": ["_hyper_8_2351_chunk_1.simulationrunid", "_hyper_8_2351_chunk_1.componentid", "_hyper_8_2351_chunk_1.discriminator", "_hyper_8_2351_chunk_1.elementid", "_hyper_8_2351_chunk_1.workorderid", "_hyper_8_2351_chunk_1.start", "_hyper_8_2351_chunk_1.finish"],
                                                  "Index Cond": "((_hyper_8_2351_chunk_1.simulationrunid = 325) AND ((_hyper_8_2351_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))",
                                                  "Rows Removed by Index Recheck": 0,
                                                  "Shared Hit Blocks": 382,
                                                  "Shared Read Blocks": 0,
                                                  "Shared Dirtied Blocks": 0,
                                                  "Shared Written Blocks": 0,
                                                  "Local Hit Blocks": 0,
                                                  "Local Read Blocks": 0,
                                                  "Local Dirtied Blocks": 0,
                                                  "Local Written Blocks": 0,
                                                  "Temp Read Blocks": 0,
                                                  "Temp Written Blocks": 0
                                                },
                                                {
                                                  "Node Type": "Index Scan",
                                                  "Parent Relationship": "Member",
                                                  "Parallel Aware": false,
                                                  "Async Capable": false,
                                                  "Scan Direction": "Forward",
                                                  "Index Name": "_hyper_8_2352_chunk_luworkertracking_idx",
                                                  "Relation Name": "_hyper_8_2352_chunk",
                                                  "Schema": "_timescaledb_internal",
                                                  "Alias": "_hyper_8_2352_chunk_1",
                                                  "Startup Cost": 0.29,
                                                  "Total Cost": 270.47,
                                                  "Plan Rows": 1232,
                                                  "Plan Width": 105,
                                                  "Actual Startup Time": 0.014,
                                                  "Actual Total Time": 0.414,
                                                  "Actual Rows": 1283,
                                                  "Actual Loops": 1,
                                                  "Output": ["_hyper_8_2352_chunk_1.simulationrunid", "_hyper_8_2352_chunk_1.componentid", "_hyper_8_2352_chunk_1.discriminator", "_hyper_8_2352_chunk_1.elementid", "_hyper_8_2352_chunk_1.workorderid", "_hyper_8_2352_chunk_1.start", "_hyper_8_2352_chunk_1.finish"],
                                                  "Index Cond": "((_hyper_8_2352_chunk_1.simulationrunid = 325) AND ((_hyper_8_2352_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))",
                                                  "Rows Removed by Index Recheck": 0,
                                                  "Shared Hit Blocks": 253,
                                                  "Shared Read Blocks": 0,
                                                  "Shared Dirtied Blocks": 0,
                                                  "Shared Written Blocks": 0,
                                                  "Local Hit Blocks": 0,
                                                  "Local Read Blocks": 0,
                                                  "Local Dirtied Blocks": 0,
                                                  "Local Written Blocks": 0,
                                                  "Temp Read Blocks": 0,
                                                  "Temp Written Blocks": 0
                                                },
                                                {
                                                  "Node Type": "Index Scan",
                                                  "Parent Relationship": "Member",
                                                  "Parallel Aware": false,
                                                  "Async Capable": false,
                                                  "Scan Direction": "Forward",
                                                  "Index Name": "_hyper_8_2353_chunk_luworkertracking_idx",
                                                  "Relation Name": "_hyper_8_2353_chunk",
                                                  "Schema": "_timescaledb_internal",
                                                  "Alias": "_hyper_8_2353_chunk_1",
                                                  "Startup Cost": 0.29,
                                                  "Total Cost": 413.31,
                                                  "Plan Rows": 1909,
                                                  "Plan Width": 102,
                                                  "Actual Startup Time": 0.014,
                                                  "Actual Total Time": 0.923,
                                                  "Actual Rows": 2154,
                                                  "Actual Loops": 1,
                                                  "Output": ["_hyper_8_2353_chunk_1.simulationrunid", "_hyper_8_2353_chunk_1.componentid", "_hyper_8_2353_chunk_1.discriminator", "_hyper_8_2353_chunk_1.elementid", "_hyper_8_2353_chunk_1.workorderid", "_hyper_8_2353_chunk_1.start", "_hyper_8_2353_chunk_1.finish"],
                                                  "Index Cond": "((_hyper_8_2353_chunk_1.simulationrunid = 325) AND ((_hyper_8_2353_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))",
                                                  "Rows Removed by Index Recheck": 0,
                                                  "Shared Hit Blocks": 548,
                                                  "Shared Read Blocks": 0,
                                                  "Shared Dirtied Blocks": 0,
                                                  "Shared Written Blocks": 0,
                                                  "Local Hit Blocks": 0,
                                                  "Local Read Blocks": 0,
                                                  "Local Dirtied Blocks": 0,
                                                  "Local Written Blocks": 0,
                                                  "Temp Read Blocks": 0,
                                                  "Temp Written Blocks": 0
                                                },
                                                {
                                                  "Node Type": "Index Scan",
                                                  "Parent Relationship": "Member",
                                                  "Parallel Aware": false,
                                                  "Async Capable": false,
                                                  "Scan Direction": "Forward",
                                                  "Index Name": "_hyper_8_2354_chunk_luworkertracking_idx",
                                                  "Relation Name": "_hyper_8_2354_chunk",
                                                  "Schema": "_timescaledb_internal",
                                                  "Alias": "_hyper_8_2354_chunk_1",
                                                  "Startup Cost": 0.29,
                                                  "Total Cost": 503.54,
                                                  "Plan Rows": 2670,
                                                  "Plan Width": 102,
                                                  "Actual Startup Time": 0.016,
                                                  "Actual Total Time": 1.367,
                                                  "Actual Rows": 2758,
                                                  "Actual Loops": 1,
                                                  "Output": ["_hyper_8_2354_chunk_1.simulationrunid", "_hyper_8_2354_chunk_1.componentid", "_hyper_8_2354_chunk_1.discriminator", "_hyper_8_2354_chunk_1.elementid", "_hyper_8_2354_chunk_1.workorderid", "_hyper_8_2354_chunk_1.start", "_hyper_8_2354_chunk_1.finish"],
                                                  "Index Cond": "((_hyper_8_2354_chunk_1.simulationrunid = 325) AND ((_hyper_8_2354_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))",
                                                  "Rows Removed by Index Recheck": 0,
                                                  "Shared Hit Blocks": 799,
                                                  "Shared Read Blocks": 0,
                                                  "Shared Dirtied Blocks": 0,
                                                  "Shared Written Blocks": 0,
                                                  "Local Hit Blocks": 0,
                                                  "Local Read Blocks": 0,
                                                  "Local Dirtied Blocks": 0,
                                                  "Local Written Blocks": 0,
                                                  "Temp Read Blocks": 0,
                                                  "Temp Written Blocks": 0
                                                },
                                                {
                                                  "Node Type": "Index Scan",
                                                  "Parent Relationship": "Member",
                                                  "Parallel Aware": false,
                                                  "Async Capable": false,
                                                  "Scan Direction": "Forward",
                                                  "Index Name": "_hyper_8_2355_chunk_luworkertracking_idx",
                                                  "Relation Name": "_hyper_8_2355_chunk",
                                                  "Schema": "_timescaledb_internal",
                                                  "Alias": "_hyper_8_2355_chunk_1",
                                                  "Startup Cost": 0.29,
                                                  "Total Cost": 565.50,
                                                  "Plan Rows": 3233,
                                                  "Plan Width": 103,
                                                  "Actual Startup Time": 0.014,
                                                  "Actual Total Time": 1.476,
                                                  "Actual Rows": 3233,
                                                  "Actual Loops": 1,
                                                  "Output": ["_hyper_8_2355_chunk_1.simulationrunid", "_hyper_8_2355_chunk_1.componentid", "_hyper_8_2355_chunk_1.discriminator", "_hyper_8_2355_chunk_1.elementid", "_hyper_8_2355_chunk_1.workorderid", "_hyper_8_2355_chunk_1.start", "_hyper_8_2355_chunk_1.finish"],
                                                  "Index Cond": "((_hyper_8_2355_chunk_1.simulationrunid = 325) AND ((_hyper_8_2355_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))",
                                                  "Rows Removed by Index Recheck": 0,
                                                  "Shared Hit Blocks": 938,
                                                  "Shared Read Blocks": 0,
                                                  "Shared Dirtied Blocks": 0,
                                                  "Shared Written Blocks": 0,
                                                  "Local Hit Blocks": 0,
                                                  "Local Read Blocks": 0,
                                                  "Local Dirtied Blocks": 0,
                                                  "Local Written Blocks": 0,
                                                  "Temp Read Blocks": 0,
                                                  "Temp Written Blocks": 0
                                                },
                                                {
                                                  "Node Type": "Index Scan",
                                                  "Parent Relationship": "Member",
                                                  "Parallel Aware": false,
                                                  "Async Capable": false,
                                                  "Scan Direction": "Forward",
                                                  "Index Name": "_hyper_8_2356_chunk_luworkertracking_idx",
                                                  "Relation Name": "_hyper_8_2356_chunk",
                                                  "Schema": "_timescaledb_internal",
                                                  "Alias": "_hyper_8_2356_chunk_1",
                                                  "Startup Cost": 0.41,
                                                  "Total Cost": 599.76,
                                                  "Plan Rows": 3441,
                                                  "Plan Width": 103,
                                                  "Actual Startup Time": 0.016,
                                                  "Actual Total Time": 1.613,
                                                  "Actual Rows": 3438,
                                                  "Actual Loops": 1,
                                                  "Output": ["_hyper_8_2356_chunk_1.simulationrunid", "_hyper_8_2356_chunk_1.componentid", "_hyper_8_2356_chunk_1.discriminator", "_hyper_8_2356_chunk_1.elementid", "_hyper_8_2356_chunk_1.workorderid", "_hyper_8_2356_chunk_1.start", "_hyper_8_2356_chunk_1.finish"],
                                                  "Index Cond": "((_hyper_8_2356_chunk_1.simulationrunid = 325) AND ((_hyper_8_2356_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))",
                                                  "Rows Removed by Index Recheck": 0,
                                                  "Shared Hit Blocks": 1038,
                                                  "Shared Read Blocks": 0,
                                                  "Shared Dirtied Blocks": 0,
                                                  "Shared Written Blocks": 0,
                                                  "Local Hit Blocks": 0,
                                                  "Local Read Blocks": 0,
                                                  "Local Dirtied Blocks": 0,
                                                  "Local Written Blocks": 0,
                                                  "Temp Read Blocks": 0,
                                                  "Temp Written Blocks": 0
                                                },
                                                {
                                                  "Node Type": "Index Scan",
                                                  "Parent Relationship": "Member",
                                                  "Parallel Aware": false,
                                                  "Async Capable": false,
                                                  "Scan Direction": "Forward",
                                                  "Index Name": "_hyper_8_2357_chunk_luworkertracking_idx",
                                                  "Relation Name": "_hyper_8_2357_chunk",
                                                  "Schema": "_timescaledb_internal",
                                                  "Alias": "_hyper_8_2357_chunk_1",
                                                  "Startup Cost": 0.29,
                                                  "Total Cost": 279.73,
                                                  "Plan Rows": 1131,
                                                  "Plan Width": 100,
                                                  "Actual Startup Time": 0.012,
                                                  "Actual Total Time": 0.606,
                                                  "Actual Rows": 1131,
                                                  "Actual Loops": 1,
                                                  "Output": ["_hyper_8_2357_chunk_1.simulationrunid", "_hyper_8_2357_chunk_1.componentid", "_hyper_8_2357_chunk_1.discriminator", "_hyper_8_2357_chunk_1.elementid", "_hyper_8_2357_chunk_1.workorderid", "_hyper_8_2357_chunk_1.start", "_hyper_8_2357_chunk_1.finish"],
                                                  "Index Cond": "((_hyper_8_2357_chunk_1.simulationrunid = 325) AND ((_hyper_8_2357_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))",
                                                  "Rows Removed by Index Recheck": 0,
                                                  "Shared Hit Blocks": 441,
                                                  "Shared Read Blocks": 0,
                                                  "Shared Dirtied Blocks": 0,
                                                  "Shared Written Blocks": 0,
                                                  "Local Hit Blocks": 0,
                                                  "Local Read Blocks": 0,
                                                  "Local Dirtied Blocks": 0,
                                                  "Local Written Blocks": 0,
                                                  "Temp Read Blocks": 0,
                                                  "Temp Written Blocks": 0
                                                },
                                                {
                                                  "Node Type": "Index Scan",
                                                  "Parent Relationship": "Member",
                                                  "Parallel Aware": false,
                                                  "Async Capable": false,
                                                  "Scan Direction": "Forward",
                                                  "Index Name": "_hyper_8_2358_chunk_luworkertracking_idx",
                                                  "Relation Name": "_hyper_8_2358_chunk",
                                                  "Schema": "_timescaledb_internal",
                                                  "Alias": "_hyper_8_2358_chunk_1",
                                                  "Startup Cost": 0.14,
                                                  "Total Cost": 1.75,
                                                  "Plan Rows": 1,
                                                  "Plan Width": 100,
                                                  "Actual Startup Time": 0.007,
                                                  "Actual Total Time": 0.007,
                                                  "Actual Rows": 0,
                                                  "Actual Loops": 1,
                                                  "Output": ["_hyper_8_2358_chunk_1.simulationrunid", "_hyper_8_2358_chunk_1.componentid", "_hyper_8_2358_chunk_1.discriminator", "_hyper_8_2358_chunk_1.elementid", "_hyper_8_2358_chunk_1.workorderid", "_hyper_8_2358_chunk_1.start", "_hyper_8_2358_chunk_1.finish"],
                                                  "Index Cond": "((_hyper_8_2358_chunk_1.simulationrunid = 325) AND ((_hyper_8_2358_chunk_1.discriminator)::text = 'TRACKING_TYPE_LU_COMPONENT'::text))",
                                                  "Rows Removed by Index Recheck": 0,
                                                  "Shared Hit Blocks": 1,
                                                  "Shared Read Blocks": 0,
                                                  "Shared Dirtied Blocks": 0,
                                                  "Shared Written Blocks": 0,
                                                  "Local Hit Blocks": 0,
                                                  "Local Read Blocks": 0,
                                                  "Local Dirtied Blocks": 0,
                                                  "Local Written Blocks": 0,
                                                  "Temp Read Blocks": 0,
                                                  "Temp Written Blocks": 0
                                                }
                                              ]
                                            }
                                          ]
                                        },
                                        {
                                          "Node Type": "Hash",
                                          "Parent Relationship": "Inner",
                                          "Parallel Aware": false,
                                          "Async Capable": false,
                                          "Startup Cost": 0.02,
                                          "Total Cost": 0.02,
                                          "Plan Rows": 1,
                                          "Plan Width": 68,
                                          "Actual Startup Time": 5.931,
                                          "Actual Total Time": 5.931,
                                          "Actual Rows": 8088,
                                          "Actual Loops": 1,
                                          "Output": ["e.simulationrunid", "e.elementid", "e.elementcreatedatcomponentid"],
                                          "Hash Buckets": 8192,
                                          "Original Hash Buckets": 1024,
                                          "Hash Batches": 1,
                                          "Original Hash Batches": 1,
                                          "Peak Memory Usage": 939,
                                          "Shared Hit Blocks": 3101,
                                          "Shared Read Blocks": 0,
                                          "Shared Dirtied Blocks": 0,
                                          "Shared Written Blocks": 0,
                                          "Local Hit Blocks": 0,
                                          "Local Read Blocks": 0,
                                          "Local Dirtied Blocks": 0,
                                          "Local Written Blocks": 0,
                                          "Temp Read Blocks": 0,
                                          "Temp Written Blocks": 0,
                                          "Plans": [
                                            {
                                              "Node Type": "CTE Scan",
                                              "Parent Relationship": "Outer",
                                              "Parallel Aware": false,
                                              "Async Capable": false,
                                              "CTE Name": "filtered_elements",
                                              "Alias": "e",
                                              "Startup Cost": 0.00,
                                              "Total Cost": 0.02,
                                              "Plan Rows": 1,
                                              "Plan Width": 68,
                                              "Actual Startup Time": 0.034,
                                              "Actual Total Time": 4.356,
                                              "Actual Rows": 8088,
                                              "Actual Loops": 1,
                                              "Output": ["e.simulationrunid", "e.elementid", "e.elementcreatedatcomponentid"],
                                              "Shared Hit Blocks": 3101,
                                              "Shared Read Blocks": 0,
                                              "Shared Dirtied Blocks": 0,
                                              "Shared Written Blocks": 0,
                                              "Local Hit Blocks": 0,
                                              "Local Read Blocks": 0,
                                              "Local Dirtied Blocks": 0,
                                              "Local Written Blocks": 0,
                                              "Temp Read Blocks": 0,
                                              "Temp Written Blocks": 0
                                            }
                                          ]
                                        }
                                      ]
                                    },
                                    {
                                      "Node Type": "Sort",
                                      "Parent Relationship": "Inner",
                                      "Parallel Aware": false,
                                      "Async Capable": false,
                                      "Startup Cost": 2.04,
                                      "Total Cost": 2.05,
                                      "Plan Rows": 1,
                                      "Plan Width": 51,
                                      "Actual Startup Time": 0.001,
                                      "Actual Total Time": 0.366,
                                      "Actual Rows": 10424,
                                      "Actual Loops": 32352,
                                      "Output": ["NULL::bigint", "sim_run_component_metadata.generator", "sim_run_component_metadata.component", "((sim_run_component_metadata.value)::timestamp with time zone)"],
                                      "Sort Key": ["sim_run_component_metadata.generator", "sim_run_component_metadata.component"],
                                      "Sort Method": "quicksort",
                                      "Sort Space Used": 1158,
                                      "Sort Space Type": "Memory",
                                      "Shared Hit Blocks": 219,
                                      "Shared Read Blocks": 1,
                                      "Shared Dirtied Blocks": 0,
                                      "Shared Written Blocks": 0,
                                      "Local Hit Blocks": 0,
                                      "Local Read Blocks": 0,
                                      "Local Dirtied Blocks": 0,
                                      "Local Written Blocks": 0,
                                      "Temp Read Blocks": 0,
                                      "Temp Written Blocks": 0,
                                      "Plans": [
                                        {
                                          "Node Type": "Index Scan",
                                          "Parent Relationship": "Outer",
                                          "Parallel Aware": false,
                                          "Async Capable": false,
                                          "Scan Direction": "Forward",
                                          "Index Name": "idx_simruncomponentmetadata_simrunid_key",
                                          "Relation Name": "sim_run_component_metadata",
                                          "Schema": "public",
                                          "Alias": "sim_run_component_metadata",
                                          "Startup Cost": 0.43,
                                          "Total Cost": 2.03,
                                          "Plan Rows": 1,
                                          "Plan Width": 51,
                                          "Actual Startup Time": 0.045,
                                          "Actual Total Time": 5.287,
                                          "Actual Rows": 10424,
                                          "Actual Loops": 1,
                                          "Output": ["NULL::bigint", "sim_run_component_metadata.generator", "sim_run_component_metadata.component", "(sim_run_component_metadata.value)::timestamp with time zone"],
                                          "Index Cond": "((sim_run_component_metadata.sim_run_id = 325) AND ((sim_run_component_metadata.key)::text = 'LATEST'::text))",
                                          "Rows Removed by Index Recheck": 0,
                                          "Shared Hit Blocks": 219,
                                          "Shared Read Blocks": 1,
                                          "Shared Dirtied Blocks": 0,
                                          "Shared Written Blocks": 0,
                                          "Local Hit Blocks": 0,
                                          "Local Read Blocks": 0,
                                          "Local Dirtied Blocks": 0,
                                          "Local Written Blocks": 0,
                                          "Temp Read Blocks": 0,
                                          "Temp Written Blocks": 0
                                        }
                                      ]
                                    }
                                  ]
                                }
                              ]
                            }
                          ]
                        }
                      ]
                    }
                  ]
                },
                {
                  "Node Type": "Aggregate",
                  "Strategy": "Sorted",
                  "Partial Mode": "Simple",
                  "Parent Relationship": "Inner",
                  "Parallel Aware": false,
                  "Async Capable": false,
                  "Startup Cost": 8650.83,
                  "Total Cost": 8715.83,
                  "Plan Rows": 1000,
                  "Plan Width": 92,
                  "Actual Startup Time": 36875.680,
                  "Actual Total Time": 36891.879,
                  "Actual Rows": 2344,
                  "Actual Loops": 1,
                  "Output": ["work_order_buckets.simulationrunid", "work_order_buckets.componentid", "work_order_buckets.bucket_start", "((work_order_buckets.bucket_start + '01:00:00'::interval))", "EXTRACT(epoch FROM sum((CASE WHEN (work_order_buckets.finish < ((work_order_buckets.bucket_start + '01:00:00'::interval))) THEN work_order_buckets.finish ELSE ((work_order_buckets.bucket_start + '01:00:00'::interval)) END - CASE WHEN (work_order_buckets.start > work_order_buckets.bucket_start) THEN work_order_buckets.start ELSE work_order_buckets.bucket_start END)))", "count(DISTINCT work_order_buckets.workerid)", "count(DISTINCT work_order_buckets.workorderid)", "sum(CASE WHEN (work_order_buckets.finish >= ((work_order_buckets.bucket_start + '01:00:00'::interval))) THEN 1 ELSE 0 END)", "sum(CASE WHEN ((work_order_buckets.finish >= ((work_order_buckets.bucket_start + '01:00:00'::interval))) AND (work_order_buckets.finish > work_order_buckets.late_ref_time)) THEN 1 ELSE 0 END)"],
                  "Group Key": ["work_order_buckets.simulationrunid", "work_order_buckets.componentid", "work_order_buckets.bucket_start", "((work_order_buckets.bucket_start + '01:00:00'::interval))"],
                  "Shared Hit Blocks": 135022,
                  "Shared Read Blocks": 0,
                  "Shared Dirtied Blocks": 0,
                  "Shared Written Blocks": 0,
                  "Local Hit Blocks": 0,
                  "Local Read Blocks": 0,
                  "Local Dirtied Blocks": 0,
                  "Local Written Blocks": 0,
                  "Temp Read Blocks": 0,
                  "Temp Written Blocks": 0,
                  "Plans": [
                    {
                      "Node Type": "Sort",
                      "Parent Relationship": "Outer",
                      "Parallel Aware": false,
                      "Async Capable": false,
                      "Startup Cost": 8650.83,
                      "Total Cost": 8653.33,
                      "Plan Rows": 1000,
                      "Plan Width": 79,
                      "Actual Startup Time": 36875.603,
                      "Actual Total Time": 36877.348,
                      "Actual Rows": 32639,
                      "Actual Loops": 1,
                      "Output": ["work_order_buckets.simulationrunid", "work_order_buckets.componentid", "work_order_buckets.bucket_start", "((work_order_buckets.bucket_start + '01:00:00'::interval))", "work_order_buckets.finish", "work_order_buckets.start", "work_order_buckets.workerid", "work_order_buckets.workorderid", "work_order_buckets.late_ref_time"],
                      "Sort Key": ["work_order_buckets.simulationrunid", "work_order_buckets.componentid", "work_order_buckets.bucket_start", "((work_order_buckets.bucket_start + '01:00:00'::interval))", "work_order_buckets.workerid"],
                      "Sort Method": "quicksort",
                      "Sort Space Used": 4338,
                      "Sort Space Type": "Memory",
                      "Shared Hit Blocks": 135022,
                      "Shared Read Blocks": 0,
                      "Shared Dirtied Blocks": 0,
                      "Shared Written Blocks": 0,
                      "Local Hit Blocks": 0,
                      "Local Read Blocks": 0,
                      "Local Dirtied Blocks": 0,
                      "Local Written Blocks": 0,
                      "Temp Read Blocks": 0,
                      "Temp Written Blocks": 0,
                      "Plans": [
                        {
                          "Node Type": "Subquery Scan",
                          "Parent Relationship": "Outer",
                          "Parallel Aware": false,
                          "Async Capable": false,
                          "Alias": "work_order_buckets",
                          "Startup Cost": 9.54,
                          "Total Cost": 8601.00,
                          "Plan Rows": 1000,
                          "Plan Width": 79,
                          "Actual Startup Time": 23.939,
                          "Actual Total Time": 36836.499,
                          "Actual Rows": 32639,
                          "Actual Loops": 1,
                          "Output": ["work_order_buckets.simulationrunid", "work_order_buckets.componentid", "work_order_buckets.bucket_start", "(work_order_buckets.bucket_start + '01:00:00'::interval)", "work_order_buckets.finish", "work_order_buckets.start", "work_order_buckets.workerid", "work_order_buckets.workorderid", "work_order_buckets.late_ref_time"],
                          "Shared Hit Blocks": 135022,
                          "Shared Read Blocks": 0,
                          "Shared Dirtied Blocks": 0,
                          "Shared Written Blocks": 0,
                          "Local Hit Blocks": 0,
                          "Local Read Blocks": 0,
                          "Local Dirtied Blocks": 0,
                          "Local Written Blocks": 0,
                          "Temp Read Blocks": 0,
                          "Temp Written Blocks": 0,
                          "Plans": [
                            {
                              "Node Type": "ProjectSet",
                              "Parent Relationship": "Subquery",
                              "Parallel Aware": false,
                              "Async Capable": false,
                              "Startup Cost": 9.54,
                              "Total Cost": 8588.50,
                              "Plan Rows": 1000,
                              "Plan Width": 103,
                              "Actual Startup Time": 23.937,
                              "Actual Total Time": 36827.999,
                              "Actual Rows": 32639,
                              "Actual Loops": 1,
                              "Output": ["_hyper_8_2343_chunk_2.simulationrunid", "_hyper_8_2343_chunk_2.componentid", "NULL::character varying", "_hyper_8_2343_chunk_2.workorderid", "wo.workerid", "_hyper_8_2343_chunk_2.start", "_hyper_8_2343_chunk_2.finish", "((sim_run_component_metadata_1.value)::timestamp with time zone)", "generate_series(time_bucket('01:00:00'::interval, _hyper_8_2343_chunk_2.start), time_bucket('01:00:00'::interval, _hyper_8_2343_chunk_2.finish), '01:00:00'::interval)"],
                              "Shared Hit Blocks": 135022,
                              "Shared Read Blocks": 0,
                              "Shared Dirtied Blocks": 0,
                              "Shared Written Blocks": 0,
                              "Local Hit Blocks": 0,
                              "Local Read Blocks": 0,
                              "Local Dirtied Blocks": 0,
                              "Local Written Blocks": 0,
                              "Temp Read Blocks": 0,
                              "Temp Written Blocks": 0,
                              "Plans": [
                                {
                                  "Node Type": "Nested Loop",
                                  "Parent Relationship": "Outer",
                                  "Parallel Aware": false,
                                  "Async Capable": false,
                                  "Join Type": "Left",
                                  "Startup Cost": 9.54,
                                  "Total Cost": 8583.49,
                                  "Plan Rows": 1,
                                  "Plan Width": 63,
                                  "Actual Startup Time": 23.933,
                                  "Actual Total Time": 36806.789,
                                  "Actual Rows": 32352,
                                  "Actual Loops": 1,
                                  "Output": ["_hyper_8_2343_chunk_2.start", "_hyper_8_2343_chunk_2.finish", "_hyper_8_2343_chunk_2.simulationrunid", "_hyper_8_2343_chunk_2.componentid", "_hyper_8_2343_chunk_2.workorderid", "wo.workerid", "((sim_run_component_metadata_1.value)::timestamp with time zone)"],
                                  "Inner Unique": false,
                                  "Join Filter": "(((sim_run_component_metadata_1.generator)::text = (e_1.elementcreatedatcomponentid)::text) AND ((sim_run_component_metadata_1.component)::text = (_hyper_8_2343_chunk_2.componentid)::text))",
                                  "Rows Removed by Join Filter": 337204896,
                                  "Shared Hit Blocks": 135022,
                                  "Shared Read Blocks": 0,
                                  "Shared Dirtied Blocks": 0,
                                  "Shared Written Blocks": 0,
                                  "Local Hit Blocks": 0,
                                  "Local Read Blocks": 0,
                                  "Local Dirtied Blocks": 0,
                                  "Local Written Blocks": 0,
                                  "Temp Read Blocks": 0,
                                  "Temp Written Blocks": 0,
                                  "Plans": [
                                    {
                                      "Node Type": "Nested Loop",
                                      "Parent Relationship": "Outer",
                                      "Parallel Aware": false,
                                      "Async Capable": false,
                                      "Join Type": "Inner",
                                      "Startup Cost": 7.49,
                                      "Total Cost": 8581.41,
                                      "Plan Rows": 1,
                                      "Plan Width": 87,
                                      "Actual Startup Time": 2.429,
                                      "Actual Total Time": 242.277,
                                      "Actual Rows": 32352,
                                      "Actual Loops": 1,
                                      "Output": ["_hyper_8_2343_chunk_2.simulationrunid", "_hyper_8_2343_chunk_2.componentid", "_hyper_8_2343_chunk_2.workorderid", "_hyper_8_2343_chunk_2.start", "_hyper_8_2343_chunk_2.finish", "e_1.elementcreatedatcomponentid", "wo.workerid"],
                                      "Inner Unique": true,
                                      "Join Filter": "(wo.simulationrunid = e_1.simulationrunid)",
                                      "Rows Removed by Join Filter": 0,
                                      "Shared Hit Blocks": 134802,
                                      "Shared Read Blocks": 0,
                                      "Shared Dirtied Blocks": 0,
                                      "Shared Written Blocks": 0,
                                      "Local Hit Blocks": 0,
                                      "Local Read Blocks": 0,
                                      "Local Dirtied Blocks": 0,
                                      "Local Written Blocks": 0,
                                      "Temp Read Blocks": 0,
                                      "Temp Written Blocks": 0,
                                      "Plans": [
                                        {
                                          "Node Type": "Hash Join",
                                          "Parent Relationship": "Outer",
                                          "Parallel Aware": false,
                                          "Async Capable": false,
                                          "Join Type": "Inner",
                                          "Startup Cost": 7.06,
                                          "Total Cost": 8579.51,
                                          "Plan Rows": 1,
                                          "Plan Width": 68,
                                          "Actual Startup Time": 2.410,
                                          "Actual Total Time": 109.791,
                                          "Actual Rows": 32352,
                                          "Actual Loops": 1,
                                          "Output": ["_hyper_8_2343_chunk_2.simulationrunid", "_hyper_8_2343_chunk_2.componentid", "_hyper_8_2343_chunk_2.workorderid", "_hyper_8_2343_chunk_2.start", "_hyper_8_2343_chunk_2.finish", "e_1.simulationrunid", "e_1.elementcreatedatcomponentid"],
                                          "Inner Unique": false,
                                          "Hash Cond": "((_hyper_8_2343_chunk_2.simulationrunid = e_1.simulationrunid) AND ((_hyper_8_2343_chunk_2.elementid)::text = (e_1.elementid)::text))",
                                          "Shared Hit Blocks": 5394,
                                          "Shared Read Blocks": 0,
                                          "Shared Dirtied Blocks": 0,
                                          "Shared Written Blocks": 0,
                                          "Local Hit Blocks": 0,
                                          "Local Read Blocks": 0,
                                          "Local Dirtied Blocks": 0,
                                          "Local Written Blocks": 0,
                                          "Temp Read Blocks": 0,
                                          "Temp Written Blocks": 0,
                                          "Plans": [
                                            {
                                              "Node Type": "Incremental Sort",
                                              "Parent Relationship": "Outer",
                                              "Parallel Aware": false,
                                              "Async Capable": false,
                                              "Startup Cost": 7.03,
                                              "Total Cost": 7987.51,
                                              "Plan Rows": 33826,
                                              "Plan Width": 98,
                                              "Actual Startup Time": 0.364,
                                              "Actual Total Time": 81.228,
                                              "Actual Rows": 32352,
                                              "Actual Loops": 1,
                                              "Output": ["_hyper_8_2343_chunk_2.simulationrunid", "_hyper_8_2343_chunk_2.componentid", "_hyper_8_2343_chunk_2.discriminator", "_hyper_8_2343_chunk_2.elementid", "_hyper_8_2343_chunk_2.workorderid", "_hyper_8_2343_chunk_2.start", "_hyper_8_2343_chunk_2.finish"],
                                              "Sort Key": ["_hyper_8_2343_chunk_2.componentid", "_hyper_8_2343_chunk_2.elementid", "_hyper_8_2343_chunk_2.workorderid", "_hyper_8_2343_chunk_2.start", "_hyper_8_2343_chunk_2.finish"],
                                              "Presorted Key": ["_hyper_8_2343_chunk_2.componentid"],
                                              "Full-sort Groups": {
                                                "Group Count": 127,
                                                "Sort Methods Used": ["quicksort"],
                                                "Sort Space Memory": {
                                                  "Average Sort Space Used": 28,
                                                  "Peak Sort Space Used": 28
                                                }
                                              },
                                              "Pre-sorted Groups": {
                                                "Group Count": 96,
                                                "Sort Methods Used": ["quicksort"],
                                                "Sort Space Memory": {
                                                  "Average Sort Space Used": 60,
                                                  "Peak Sort Space Used": 1175
                                                }
                                              },
                                              "Shared Hit Blocks": 5394,
                                              "Shared Read Blocks": 0,
                                              "Shared Dirtied Blocks": 0,
                                              "Shared Written Blocks": 0,
                                              "Local Hit Blocks": 0,
                                              "Local Read Blocks": 0,
                                              "Local Dirtied Blocks": 0,
                                              "Local Written Blocks": 0,
                                              "Temp Read Blocks": 0,
                                              "Temp Written Blocks": 0,
                                              "Plans": [
                                                {
                                                  "Node Type": "Merge Append",
                                                  "Parent Relationship": "Outer",
                                                  "Parallel Aware": false,
                                                  "Async Capable": false,
                                                  "Startup Cost": 4.74,
                                                  "Total Cost": 6929.18,
                                                  "Plan Rows": 33826,
                                                  "Plan Width": 98,
                                                  "Actual Startup Time": 0.296,
                                                  "Actual Total Time": 18.604,
                                                  "Actual Rows": 32352,
                                                  "Actual Loops": 1,
                                                  "Sort Key": ["_hyper_8_2343_chunk_2.componentid"],
                                                  "Shared Hit Blocks": 5394,
                                                  "Shared Read Blocks": 0,
                                                  "Shared Dirtied Blocks": 0,
                                                  "Shared Written Blocks": 0,
                                                  "Local Hit Blocks": 0,
                                                  "Local Read Blocks": 0,
                                                  "Local Dirtied Blocks": 0,
                                                  "Local Written Blocks": 0,
                                                  "Temp Read Blocks": 0,
                                                  "Temp Written Blocks": 0,
                                                  "Subplans Removed": 0,
                                                  "Plans": [
                                                    {
                                                      "Node Type": "Index Scan",
                                                      "Parent Relationship": "Member",
                                                      "Parallel Aware": false,
                                                      "Async Capable": false,
                                                      "Scan Direction": "Forward",
                                                      "Index Name": "_hyper_8_2343_chunk_luworkertracking_idx",
                                                      "Relation Name": "_hyper_8_2343_chunk",
                                                      "Schema": "_timescaledb_internal",
                                                      "Alias": "_hyper_8_2343_chunk_2",
                                                      "Startup Cost": 0.29,
                                                      "Total Cost": 459.19,
                                                      "Plan Rows": 3187,
                                                      "Plan Width": 93,
                                                      "Actual Startup Time": 0.028,
                                                      "Actual Total Time": 1.320,
                                                      "Actual Rows": 3037,
                                                      "Actual Loops": 1,
                                                      "Output": ["_hyper_8_2343_chunk_2.simulationrunid", "_hyper_8_2343_chunk_2.componentid", "_hyper_8_2343_chunk_2.discriminator", "_hyper_8_2343_chunk_2.elementid", "_hyper_8_2343_chunk_2.workorderid", "_hyper_8_2343_chunk_2.start", "_hyper_8_2343_chunk_2.finish"],
                                                      "Index Cond": "((_hyper_8_2343_chunk_2.simulationrunid = 325) AND ((_hyper_8_2343_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))",
                                                      "Rows Removed by Index Recheck": 0,
                                                      "Shared Hit Blocks": 507,
                                                      "Shared Read Blocks": 0,
                                                      "Shared Dirtied Blocks": 0,
                                                      "Shared Written Blocks": 0,
                                                      "Local Hit Blocks": 0,
                                                      "Local Read Blocks": 0,
                                                      "Local Dirtied Blocks": 0,
                                                      "Local Written Blocks": 0,
                                                      "Temp Read Blocks": 0,
                                                      "Temp Written Blocks": 0
                                                    },
                                                    {
                                                      "Node Type": "Index Scan",
                                                      "Parent Relationship": "Member",
                                                      "Parallel Aware": false,
                                                      "Async Capable": false,
                                                      "Scan Direction": "Forward",
                                                      "Index Name": "_hyper_8_2344_chunk_luworkertracking_idx",
                                                      "Relation Name": "_hyper_8_2344_chunk",
                                                      "Schema": "_timescaledb_internal",
                                                      "Alias": "_hyper_8_2344_chunk_2",
                                                      "Startup Cost": 0.29,
                                                      "Total Cost": 480.82,
                                                      "Plan Rows": 3027,
                                                      "Plan Width": 101,
                                                      "Actual Startup Time": 0.014,
                                                      "Actual Total Time": 1.454,
                                                      "Actual Rows": 3037,
                                                      "Actual Loops": 1,
                                                      "Output": ["_hyper_8_2344_chunk_2.simulationrunid", "_hyper_8_2344_chunk_2.componentid", "_hyper_8_2344_chunk_2.discriminator", "_hyper_8_2344_chunk_2.elementid", "_hyper_8_2344_chunk_2.workorderid", "_hyper_8_2344_chunk_2.start", "_hyper_8_2344_chunk_2.finish"],
                                                      "Index Cond": "((_hyper_8_2344_chunk_2.simulationrunid = 325) AND ((_hyper_8_2344_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))",
                                                      "Rows Removed by Index Recheck": 0,
                                                      "Shared Hit Blocks": 602,
                                                      "Shared Read Blocks": 0,
                                                      "Shared Dirtied Blocks": 0,
                                                      "Shared Written Blocks": 0,
                                                      "Local Hit Blocks": 0,
                                                      "Local Read Blocks": 0,
                                                      "Local Dirtied Blocks": 0,
                                                      "Local Written Blocks": 0,
                                                      "Temp Read Blocks": 0,
                                                      "Temp Written Blocks": 0
                                                    },
                                                    {
                                                      "Node Type": "Index Scan",
                                                      "Parent Relationship": "Member",
                                                      "Parallel Aware": false,
                                                      "Async Capable": false,
                                                      "Scan Direction": "Forward",
                                                      "Index Name": "_hyper_8_2345_chunk_luworkertracking_idx",
                                                      "Relation Name": "_hyper_8_2345_chunk",
                                                      "Schema": "_timescaledb_internal",
                                                      "Alias": "_hyper_8_2345_chunk_2",
                                                      "Startup Cost": 0.13,
                                                      "Total Cost": 2.35,
                                                      "Plan Rows": 1,
                                                      "Plan Width": 120,
                                                      "Actual Startup Time": 0.006,
                                                      "Actual Total Time": 0.007,
                                                      "Actual Rows": 0,
                                                      "Actual Loops": 1,
                                                      "Output": ["_hyper_8_2345_chunk_2.simulationrunid", "_hyper_8_2345_chunk_2.componentid", "_hyper_8_2345_chunk_2.discriminator", "_hyper_8_2345_chunk_2.elementid", "_hyper_8_2345_chunk_2.workorderid", "_hyper_8_2345_chunk_2.start", "_hyper_8_2345_chunk_2.finish"],
                                                      "Index Cond": "((_hyper_8_2345_chunk_2.simulationrunid = 325) AND ((_hyper_8_2345_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))",
                                                      "Rows Removed by Index Recheck": 0,
                                                      "Shared Hit Blocks": 1,
                                                      "Shared Read Blocks": 0,
                                                      "Shared Dirtied Blocks": 0,
                                                      "Shared Written Blocks": 0,
                                                      "Local Hit Blocks": 0,
                                                      "Local Read Blocks": 0,
                                                      "Local Dirtied Blocks": 0,
                                                      "Local Written Blocks": 0,
                                                      "Temp Read Blocks": 0,
                                                      "Temp Written Blocks": 0
                                                    },
                                                    {
                                                      "Node Type": "Index Scan",
                                                      "Parent Relationship": "Member",
                                                      "Parallel Aware": false,
                                                      "Async Capable": false,
                                                      "Scan Direction": "Forward",
                                                      "Index Name": "_hyper_8_2346_chunk_luworkertracking_idx",
                                                      "Relation Name": "_hyper_8_2346_chunk",
                                                      "Schema": "_timescaledb_internal",
                                                      "Alias": "_hyper_8_2346_chunk_2",
                                                      "Startup Cost": 0.29,
                                                      "Total Cost": 193.74,
                                                      "Plan Rows": 452,
                                                      "Plan Width": 96,
                                                      "Actual Startup Time": 0.049,
                                                      "Actual Total Time": 0.185,
                                                      "Actual Rows": 531,
                                                      "Actual Loops": 1,
                                                      "Output": ["_hyper_8_2346_chunk_2.simulationrunid", "_hyper_8_2346_chunk_2.componentid", "_hyper_8_2346_chunk_2.discriminator", "_hyper_8_2346_chunk_2.elementid", "_hyper_8_2346_chunk_2.workorderid", "_hyper_8_2346_chunk_2.start", "_hyper_8_2346_chunk_2.finish"],
                                                      "Index Cond": "((_hyper_8_2346_chunk_2.simulationrunid = 325) AND ((_hyper_8_2346_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))",
                                                      "Rows Removed by Index Recheck": 0,
                                                      "Shared Hit Blocks": 69,
                                                      "Shared Read Blocks": 0,
                                                      "Shared Dirtied Blocks": 0,
                                                      "Shared Written Blocks": 0,
                                                      "Local Hit Blocks": 0,
                                                      "Local Read Blocks": 0,
                                                      "Local Dirtied Blocks": 0,
                                                      "Local Written Blocks": 0,
                                                      "Temp Read Blocks": 0,
                                                      "Temp Written Blocks": 0
                                                    },
                                                    {
                                                      "Node Type": "Index Scan",
                                                      "Parent Relationship": "Member",
                                                      "Parallel Aware": false,
                                                      "Async Capable": false,
                                                      "Scan Direction": "Forward",
                                                      "Index Name": "_hyper_8_2347_chunk_luworkertracking_idx",
                                                      "Relation Name": "_hyper_8_2347_chunk",
                                                      "Schema": "_timescaledb_internal",
                                                      "Alias": "_hyper_8_2347_chunk_2",
                                                      "Startup Cost": 0.29,
                                                      "Total Cost": 436.66,
                                                      "Plan Rows": 1940,
                                                      "Plan Width": 94,
                                                      "Actual Startup Time": 0.020,
                                                      "Actual Total Time": 0.492,
                                                      "Actual Rows": 1605,
                                                      "Actual Loops": 1,
                                                      "Output": ["_hyper_8_2347_chunk_2.simulationrunid", "_hyper_8_2347_chunk_2.componentid", "_hyper_8_2347_chunk_2.discriminator", "_hyper_8_2347_chunk_2.elementid", "_hyper_8_2347_chunk_2.workorderid", "_hyper_8_2347_chunk_2.start", "_hyper_8_2347_chunk_2.finish"],
                                                      "Index Cond": "((_hyper_8_2347_chunk_2.simulationrunid = 325) AND ((_hyper_8_2347_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))",
                                                      "Rows Removed by Index Recheck": 0,
                                                      "Shared Hit Blocks": 164,
                                                      "Shared Read Blocks": 0,
                                                      "Shared Dirtied Blocks": 0,
                                                      "Shared Written Blocks": 0,
                                                      "Local Hit Blocks": 0,
                                                      "Local Read Blocks": 0,
                                                      "Local Dirtied Blocks": 0,
                                                      "Local Written Blocks": 0,
                                                      "Temp Read Blocks": 0,
                                                      "Temp Written Blocks": 0
                                                    },
                                                    {
                                                      "Node Type": "Index Scan",
                                                      "Parent Relationship": "Member",
                                                      "Parallel Aware": false,
                                                      "Async Capable": false,
                                                      "Scan Direction": "Forward",
                                                      "Index Name": "_hyper_8_2348_chunk_luworkertracking_idx",
                                                      "Relation Name": "_hyper_8_2348_chunk",
                                                      "Schema": "_timescaledb_internal",
                                                      "Alias": "_hyper_8_2348_chunk_2",
                                                      "Startup Cost": 0.29,
                                                      "Total Cost": 486.42,
                                                      "Plan Rows": 2971,
                                                      "Plan Width": 94,
                                                      "Actual Startup Time": 0.020,
                                                      "Actual Total Time": 1.178,
                                                      "Actual Rows": 2717,
                                                      "Actual Loops": 1,
                                                      "Output": ["_hyper_8_2348_chunk_2.simulationrunid", "_hyper_8_2348_chunk_2.componentid", "_hyper_8_2348_chunk_2.discriminator", "_hyper_8_2348_chunk_2.elementid", "_hyper_8_2348_chunk_2.workorderid", "_hyper_8_2348_chunk_2.start", "_hyper_8_2348_chunk_2.finish"],
                                                      "Index Cond": "((_hyper_8_2348_chunk_2.simulationrunid = 325) AND ((_hyper_8_2348_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))",
                                                      "Rows Removed by Index Recheck": 0,
                                                      "Shared Hit Blocks": 455,
                                                      "Shared Read Blocks": 0,
                                                      "Shared Dirtied Blocks": 0,
                                                      "Shared Written Blocks": 0,
                                                      "Local Hit Blocks": 0,
                                                      "Local Read Blocks": 0,
                                                      "Local Dirtied Blocks": 0,
                                                      "Local Written Blocks": 0,
                                                      "Temp Read Blocks": 0,
                                                      "Temp Written Blocks": 0
                                                    },
                                                    {
                                                      "Node Type": "Index Scan",
                                                      "Parent Relationship": "Member",
                                                      "Parallel Aware": false,
                                                      "Async Capable": false,
                                                      "Scan Direction": "Forward",
                                                      "Index Name": "_hyper_8_2349_chunk_luworkertracking_idx",
                                                      "Relation Name": "_hyper_8_2349_chunk",
                                                      "Schema": "_timescaledb_internal",
                                                      "Alias": "_hyper_8_2349_chunk_2",
                                                      "Startup Cost": 0.29,
                                                      "Total Cost": 535.58,
                                                      "Plan Rows": 3031,
                                                      "Plan Width": 95,
                                                      "Actual Startup Time": 0.015,
                                                      "Actual Total Time": 1.232,
                                                      "Actual Rows": 3031,
                                                      "Actual Loops": 1,
                                                      "Output": ["_hyper_8_2349_chunk_2.simulationrunid", "_hyper_8_2349_chunk_2.componentid", "_hyper_8_2349_chunk_2.discriminator", "_hyper_8_2349_chunk_2.elementid", "_hyper_8_2349_chunk_2.workorderid", "_hyper_8_2349_chunk_2.start", "_hyper_8_2349_chunk_2.finish"],
                                                      "Index Cond": "((_hyper_8_2349_chunk_2.simulationrunid = 325) AND ((_hyper_8_2349_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))",
                                                      "Rows Removed by Index Recheck": 0,
                                                      "Shared Hit Blocks": 486,
                                                      "Shared Read Blocks": 0,
                                                      "Shared Dirtied Blocks": 0,
                                                      "Shared Written Blocks": 0,
                                                      "Local Hit Blocks": 0,
                                                      "Local Read Blocks": 0,
                                                      "Local Dirtied Blocks": 0,
                                                      "Local Written Blocks": 0,
                                                      "Temp Read Blocks": 0,
                                                      "Temp Written Blocks": 0
                                                    },
                                                    {
                                                      "Node Type": "Index Scan",
                                                      "Parent Relationship": "Member",
                                                      "Parallel Aware": false,
                                                      "Async Capable": false,
                                                      "Scan Direction": "Forward",
                                                      "Index Name": "_hyper_8_2350_chunk_luworkertracking_idx",
                                                      "Relation Name": "_hyper_8_2350_chunk",
                                                      "Schema": "_timescaledb_internal",
                                                      "Alias": "_hyper_8_2350_chunk_2",
                                                      "Startup Cost": 0.29,
                                                      "Total Cost": 565.15,
                                                      "Plan Rows": 3196,
                                                      "Plan Width": 95,
                                                      "Actual Startup Time": 0.012,
                                                      "Actual Total Time": 1.306,
                                                      "Actual Rows": 3167,
                                                      "Actual Loops": 1,
                                                      "Output": ["_hyper_8_2350_chunk_2.simulationrunid", "_hyper_8_2350_chunk_2.componentid", "_hyper_8_2350_chunk_2.discriminator", "_hyper_8_2350_chunk_2.elementid", "_hyper_8_2350_chunk_2.workorderid", "_hyper_8_2350_chunk_2.start", "_hyper_8_2350_chunk_2.finish"],
                                                      "Index Cond": "((_hyper_8_2350_chunk_2.simulationrunid = 325) AND ((_hyper_8_2350_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))",
                                                      "Rows Removed by Index Recheck": 0,
                                                      "Shared Hit Blocks": 507,
                                                      "Shared Read Blocks": 0,
                                                      "Shared Dirtied Blocks": 0,
                                                      "Shared Written Blocks": 0,
                                                      "Local Hit Blocks": 0,
                                                      "Local Read Blocks": 0,
                                                      "Local Dirtied Blocks": 0,
                                                      "Local Written Blocks": 0,
                                                      "Temp Read Blocks": 0,
                                                      "Temp Written Blocks": 0
                                                    },
                                                    {
                                                      "Node Type": "Index Scan",
                                                      "Parent Relationship": "Member",
                                                      "Parallel Aware": false,
                                                      "Async Capable": false,
                                                      "Scan Direction": "Forward",
                                                      "Index Name": "_hyper_8_2351_chunk_luworkertracking_idx",
                                                      "Relation Name": "_hyper_8_2351_chunk",
                                                      "Schema": "_timescaledb_internal",
                                                      "Alias": "_hyper_8_2351_chunk_2",
                                                      "Startup Cost": 0.29,
                                                      "Total Cost": 291.14,
                                                      "Plan Rows": 2059,
                                                      "Plan Width": 93,
                                                      "Actual Startup Time": 0.010,
                                                      "Actual Total Time": 0.986,
                                                      "Actual Rows": 2088,
                                                      "Actual Loops": 1,
                                                      "Output": ["_hyper_8_2351_chunk_2.simulationrunid", "_hyper_8_2351_chunk_2.componentid", "_hyper_8_2351_chunk_2.discriminator", "_hyper_8_2351_chunk_2.elementid", "_hyper_8_2351_chunk_2.workorderid", "_hyper_8_2351_chunk_2.start", "_hyper_8_2351_chunk_2.finish"],
                                                      "Index Cond": "((_hyper_8_2351_chunk_2.simulationrunid = 325) AND ((_hyper_8_2351_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))",
                                                      "Rows Removed by Index Recheck": 0,
                                                      "Shared Hit Blocks": 382,
                                                      "Shared Read Blocks": 0,
                                                      "Shared Dirtied Blocks": 0,
                                                      "Shared Written Blocks": 0,
                                                      "Local Hit Blocks": 0,
                                                      "Local Read Blocks": 0,
                                                      "Local Dirtied Blocks": 0,
                                                      "Local Written Blocks": 0,
                                                      "Temp Read Blocks": 0,
                                                      "Temp Written Blocks": 0
                                                    },
                                                    {
                                                      "Node Type": "Index Scan",
                                                      "Parent Relationship": "Member",
                                                      "Parallel Aware": false,
                                                      "Async Capable": false,
                                                      "Scan Direction": "Forward",
                                                      "Index Name": "_hyper_8_2352_chunk_luworkertracking_idx",
                                                      "Relation Name": "_hyper_8_2352_chunk",
                                                      "Schema": "_timescaledb_internal",
                                                      "Alias": "_hyper_8_2352_chunk_2",
                                                      "Startup Cost": 0.29,
                                                      "Total Cost": 249.78,
                                                      "Plan Rows": 656,
                                                      "Plan Width": 105,
                                                      "Actual Startup Time": 0.028,
                                                      "Actual Total Time": 0.241,
                                                      "Actual Rows": 614,
                                                      "Actual Loops": 1,
                                                      "Output": ["_hyper_8_2352_chunk_2.simulationrunid", "_hyper_8_2352_chunk_2.componentid", "_hyper_8_2352_chunk_2.discriminator", "_hyper_8_2352_chunk_2.elementid", "_hyper_8_2352_chunk_2.workorderid", "_hyper_8_2352_chunk_2.start", "_hyper_8_2352_chunk_2.finish"],
                                                      "Index Cond": "((_hyper_8_2352_chunk_2.simulationrunid = 325) AND ((_hyper_8_2352_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))",
                                                      "Rows Removed by Index Recheck": 0,
                                                      "Shared Hit Blocks": 73,
                                                      "Shared Read Blocks": 0,
                                                      "Shared Dirtied Blocks": 0,
                                                      "Shared Written Blocks": 0,
                                                      "Local Hit Blocks": 0,
                                                      "Local Read Blocks": 0,
                                                      "Local Dirtied Blocks": 0,
                                                      "Local Written Blocks": 0,
                                                      "Temp Read Blocks": 0,
                                                      "Temp Written Blocks": 0
                                                    },
                                                    {
                                                      "Node Type": "Index Scan",
                                                      "Parent Relationship": "Member",
                                                      "Parallel Aware": false,
                                                      "Async Capable": false,
                                                      "Scan Direction": "Forward",
                                                      "Index Name": "_hyper_8_2353_chunk_luworkertracking_idx",
                                                      "Relation Name": "_hyper_8_2353_chunk",
                                                      "Schema": "_timescaledb_internal",
                                                      "Alias": "_hyper_8_2353_chunk_2",
                                                      "Startup Cost": 0.29,
                                                      "Total Cost": 412.22,
                                                      "Plan Rows": 1856,
                                                      "Plan Width": 102,
                                                      "Actual Startup Time": 0.021,
                                                      "Actual Total Time": 0.611,
                                                      "Actual Rows": 1522,
                                                      "Actual Loops": 1,
                                                      "Output": ["_hyper_8_2353_chunk_2.simulationrunid", "_hyper_8_2353_chunk_2.componentid", "_hyper_8_2353_chunk_2.discriminator", "_hyper_8_2353_chunk_2.elementid", "_hyper_8_2353_chunk_2.workorderid", "_hyper_8_2353_chunk_2.start", "_hyper_8_2353_chunk_2.finish"],
                                                      "Index Cond": "((_hyper_8_2353_chunk_2.simulationrunid = 325) AND ((_hyper_8_2353_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))",
                                                      "Rows Removed by Index Recheck": 0,
                                                      "Shared Hit Blocks": 165,
                                                      "Shared Read Blocks": 0,
                                                      "Shared Dirtied Blocks": 0,
                                                      "Shared Written Blocks": 0,
                                                      "Local Hit Blocks": 0,
                                                      "Local Read Blocks": 0,
                                                      "Local Dirtied Blocks": 0,
                                                      "Local Written Blocks": 0,
                                                      "Temp Read Blocks": 0,
                                                      "Temp Written Blocks": 0
                                                    },
                                                    {
                                                      "Node Type": "Index Scan",
                                                      "Parent Relationship": "Member",
                                                      "Parallel Aware": false,
                                                      "Async Capable": false,
                                                      "Scan Direction": "Forward",
                                                      "Index Name": "_hyper_8_2354_chunk_luworkertracking_idx",
                                                      "Relation Name": "_hyper_8_2354_chunk",
                                                      "Schema": "_timescaledb_internal",
                                                      "Alias": "_hyper_8_2354_chunk_2",
                                                      "Startup Cost": 0.29,
                                                      "Total Cost": 513.52,
                                                      "Plan Rows": 3162,
                                                      "Plan Width": 102,
                                                      "Actual Startup Time": 0.014,
                                                      "Actual Total Time": 1.198,
                                                      "Actual Rows": 2717,
                                                      "Actual Loops": 1,
                                                      "Output": ["_hyper_8_2354_chunk_2.simulationrunid", "_hyper_8_2354_chunk_2.componentid", "_hyper_8_2354_chunk_2.discriminator", "_hyper_8_2354_chunk_2.elementid", "_hyper_8_2354_chunk_2.workorderid", "_hyper_8_2354_chunk_2.start", "_hyper_8_2354_chunk_2.finish"],
                                                      "Index Cond": "((_hyper_8_2354_chunk_2.simulationrunid = 325) AND ((_hyper_8_2354_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))",
                                                      "Rows Removed by Index Recheck": 0,
                                                      "Shared Hit Blocks": 476,
                                                      "Shared Read Blocks": 0,
                                                      "Shared Dirtied Blocks": 0,
                                                      "Shared Written Blocks": 0,
                                                      "Local Hit Blocks": 0,
                                                      "Local Read Blocks": 0,
                                                      "Local Dirtied Blocks": 0,
                                                      "Local Written Blocks": 0,
                                                      "Temp Read Blocks": 0,
                                                      "Temp Written Blocks": 0
                                                    },
                                                    {
                                                      "Node Type": "Index Scan",
                                                      "Parent Relationship": "Member",
                                                      "Parallel Aware": false,
                                                      "Async Capable": false,
                                                      "Scan Direction": "Forward",
                                                      "Index Name": "_hyper_8_2355_chunk_luworkertracking_idx",
                                                      "Relation Name": "_hyper_8_2355_chunk",
                                                      "Schema": "_timescaledb_internal",
                                                      "Alias": "_hyper_8_2355_chunk_2",
                                                      "Startup Cost": 0.29,
                                                      "Total Cost": 561.23,
                                                      "Plan Rows": 3031,
                                                      "Plan Width": 103,
                                                      "Actual Startup Time": 0.019,
                                                      "Actual Total Time": 1.287,
                                                      "Actual Rows": 3031,
                                                      "Actual Loops": 1,
                                                      "Output": ["_hyper_8_2355_chunk_2.simulationrunid", "_hyper_8_2355_chunk_2.componentid", "_hyper_8_2355_chunk_2.discriminator", "_hyper_8_2355_chunk_2.elementid", "_hyper_8_2355_chunk_2.workorderid", "_hyper_8_2355_chunk_2.start", "_hyper_8_2355_chunk_2.finish"],
                                                      "Index Cond": "((_hyper_8_2355_chunk_2.simulationrunid = 325) AND ((_hyper_8_2355_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))",
                                                      "Rows Removed by Index Recheck": 0,
                                                      "Shared Hit Blocks": 520,
                                                      "Shared Read Blocks": 0,
                                                      "Shared Dirtied Blocks": 0,
                                                      "Shared Written Blocks": 0,
                                                      "Local Hit Blocks": 0,
                                                      "Local Read Blocks": 0,
                                                      "Local Dirtied Blocks": 0,
                                                      "Local Written Blocks": 0,
                                                      "Temp Read Blocks": 0,
                                                      "Temp Written Blocks": 0
                                                    },
                                                    {
                                                      "Node Type": "Index Scan",
                                                      "Parent Relationship": "Member",
                                                      "Parallel Aware": false,
                                                      "Async Capable": false,
                                                      "Scan Direction": "Forward",
                                                      "Index Name": "_hyper_8_2356_chunk_luworkertracking_idx",
                                                      "Relation Name": "_hyper_8_2356_chunk",
                                                      "Schema": "_timescaledb_internal",
                                                      "Alias": "_hyper_8_2356_chunk_2",
                                                      "Startup Cost": 0.41,
                                                      "Total Cost": 594.22,
                                                      "Plan Rows": 3168,
                                                      "Plan Width": 103,
                                                      "Actual Startup Time": 0.012,
                                                      "Actual Total Time": 1.371,
                                                      "Actual Rows": 3167,
                                                      "Actual Loops": 1,
                                                      "Output": ["_hyper_8_2356_chunk_2.simulationrunid", "_hyper_8_2356_chunk_2.componentid", "_hyper_8_2356_chunk_2.discriminator", "_hyper_8_2356_chunk_2.elementid", "_hyper_8_2356_chunk_2.workorderid", "_hyper_8_2356_chunk_2.start", "_hyper_8_2356_chunk_2.finish"],
                                                      "Index Cond": "((_hyper_8_2356_chunk_2.simulationrunid = 325) AND ((_hyper_8_2356_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))",
                                                      "Rows Removed by Index Recheck": 0,
                                                      "Shared Hit Blocks": 555,
                                                      "Shared Read Blocks": 0,
                                                      "Shared Dirtied Blocks": 0,
                                                      "Shared Written Blocks": 0,
                                                      "Local Hit Blocks": 0,
                                                      "Local Read Blocks": 0,
                                                      "Local Dirtied Blocks": 0,
                                                      "Local Written Blocks": 0,
                                                      "Temp Read Blocks": 0,
                                                      "Temp Written Blocks": 0
                                                    },
                                                    {
                                                      "Node Type": "Index Scan",
                                                      "Parent Relationship": "Member",
                                                      "Parallel Aware": false,
                                                      "Async Capable": false,
                                                      "Scan Direction": "Forward",
                                                      "Index Name": "_hyper_8_2357_chunk_luworkertracking_idx",
                                                      "Relation Name": "_hyper_8_2357_chunk",
                                                      "Schema": "_timescaledb_internal",
                                                      "Alias": "_hyper_8_2357_chunk_2",
                                                      "Startup Cost": 0.29,
                                                      "Total Cost": 299.43,
                                                      "Plan Rows": 2088,
                                                      "Plan Width": 100,
                                                      "Actual Startup Time": 0.013,
                                                      "Actual Total Time": 1.000,
                                                      "Actual Rows": 2088,
                                                      "Actual Loops": 1,
                                                      "Output": ["_hyper_8_2357_chunk_2.simulationrunid", "_hyper_8_2357_chunk_2.componentid", "_hyper_8_2357_chunk_2.discriminator", "_hyper_8_2357_chunk_2.elementid", "_hyper_8_2357_chunk_2.workorderid", "_hyper_8_2357_chunk_2.start", "_hyper_8_2357_chunk_2.finish"],
                                                      "Index Cond": "((_hyper_8_2357_chunk_2.simulationrunid = 325) AND ((_hyper_8_2357_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))",
                                                      "Rows Removed by Index Recheck": 0,
                                                      "Shared Hit Blocks": 431,
                                                      "Shared Read Blocks": 0,
                                                      "Shared Dirtied Blocks": 0,
                                                      "Shared Written Blocks": 0,
                                                      "Local Hit Blocks": 0,
                                                      "Local Read Blocks": 0,
                                                      "Local Dirtied Blocks": 0,
                                                      "Local Written Blocks": 0,
                                                      "Temp Read Blocks": 0,
                                                      "Temp Written Blocks": 0
                                                    },
                                                    {
                                                      "Node Type": "Index Scan",
                                                      "Parent Relationship": "Member",
                                                      "Parallel Aware": false,
                                                      "Async Capable": false,
                                                      "Scan Direction": "Forward",
                                                      "Index Name": "_hyper_8_2358_chunk_luworkertracking_idx",
                                                      "Relation Name": "_hyper_8_2358_chunk",
                                                      "Schema": "_timescaledb_internal",
                                                      "Alias": "_hyper_8_2358_chunk_2",
                                                      "Startup Cost": 0.14,
                                                      "Total Cost": 1.75,
                                                      "Plan Rows": 1,
                                                      "Plan Width": 100,
                                                      "Actual Startup Time": 0.007,
                                                      "Actual Total Time": 0.007,
                                                      "Actual Rows": 0,
                                                      "Actual Loops": 1,
                                                      "Output": ["_hyper_8_2358_chunk_2.simulationrunid", "_hyper_8_2358_chunk_2.componentid", "_hyper_8_2358_chunk_2.discriminator", "_hyper_8_2358_chunk_2.elementid", "_hyper_8_2358_chunk_2.workorderid", "_hyper_8_2358_chunk_2.start", "_hyper_8_2358_chunk_2.finish"],
                                                      "Index Cond": "((_hyper_8_2358_chunk_2.simulationrunid = 325) AND ((_hyper_8_2358_chunk_2.discriminator)::text = 'TRACKING_TYPE_WORK_TIME'::text))",
                                                      "Rows Removed by Index Recheck": 0,
                                                      "Shared Hit Blocks": 1,
                                                      "Shared Read Blocks": 0,
                                                      "Shared Dirtied Blocks": 0,
                                                      "Shared Written Blocks": 0,
                                                      "Local Hit Blocks": 0,
                                                      "Local Read Blocks": 0,
                                                      "Local Dirtied Blocks": 0,
                                                      "Local Written Blocks": 0,
                                                      "Temp Read Blocks": 0,
                                                      "Temp Written Blocks": 0
                                                    }
                                                  ]
                                                }
                                              ]
                                            },
                                            {
                                              "Node Type": "Hash",
                                              "Parent Relationship": "Inner",
                                              "Parallel Aware": false,
                                              "Async Capable": false,
                                              "Startup Cost": 0.02,
                                              "Total Cost": 0.02,
                                              "Plan Rows": 1,
                                              "Plan Width": 68,
                                              "Actual Startup Time": 2.024,
                                              "Actual Total Time": 2.024,
                                              "Actual Rows": 8088,
                                              "Actual Loops": 1,
                                              "Output": ["e_1.simulationrunid", "e_1.elementid", "e_1.elementcreatedatcomponentid"],
                                              "Hash Buckets": 8192,
                                              "Original Hash Buckets": 1024,
                                              "Hash Batches": 1,
                                              "Original Hash Batches": 1,
                                              "Peak Memory Usage": 939,
                                              "Shared Hit Blocks": 0,
                                              "Shared Read Blocks": 0,
                                              "Shared Dirtied Blocks": 0,
                                              "Shared Written Blocks": 0,
                                              "Local Hit Blocks": 0,
                                              "Local Read Blocks": 0,
                                              "Local Dirtied Blocks": 0,
                                              "Local Written Blocks": 0,
                                              "Temp Read Blocks": 0,
                                              "Temp Written Blocks": 0,
                                              "Plans": [
                                                {
                                                  "Node Type": "CTE Scan",
                                                  "Parent Relationship": "Outer",
                                                  "Parallel Aware": false,
                                                  "Async Capable": false,
                                                  "CTE Name": "filtered_elements",
                                                  "Alias": "e_1",
                                                  "Startup Cost": 0.00,
                                                  "Total Cost": 0.02,
                                                  "Plan Rows": 1,
                                                  "Plan Width": 68,
                                                  "Actual Startup Time": 0.002,
                                                  "Actual Total Time": 0.627,
                                                  "Actual Rows": 8088,
                                                  "Actual Loops": 1,
                                                  "Output": ["e_1.simulationrunid", "e_1.elementid", "e_1.elementcreatedatcomponentid"],
                                                  "Shared Hit Blocks": 0,
                                                  "Shared Read Blocks": 0,
                                                  "Shared Dirtied Blocks": 0,
                                                  "Shared Written Blocks": 0,
                                                  "Local Hit Blocks": 0,
                                                  "Local Read Blocks": 0,
                                                  "Local Dirtied Blocks": 0,
                                                  "Local Written Blocks": 0,
                                                  "Temp Read Blocks": 0,
                                                  "Temp Written Blocks": 0
                                                }
                                              ]
                                            }
                                          ]
                                        },
                                        {
                                          "Node Type": "Index Scan",
                                          "Parent Relationship": "Inner",
                                          "Parallel Aware": false,
                                          "Async Capable": false,
                                          "Scan Direction": "Forward",
                                          "Index Name": "workorder_pkey",
                                          "Relation Name": "work_order",
                                          "Schema": "public",
                                          "Alias": "wo",
                                          "Startup Cost": 0.43,
                                          "Total Cost": 1.89,
                                          "Plan Rows": 1,
                                          "Plan Width": 39,
                                          "Actual Startup Time": 0.003,
                                          "Actual Total Time": 0.003,
                                          "Actual Rows": 1,
                                          "Actual Loops": 32352,
                                          "Output": ["wo.simulationrunid", "wo.componentid", "wo.workerid", "wo.workorderid", "wo.start", "wo.finish", "wo.lastupdate"],
                                          "Index Cond": "((wo.simulationrunid = _hyper_8_2343_chunk_2.simulationrunid) AND ((wo.componentid)::text = (_hyper_8_2343_chunk_2.componentid)::text) AND (wo.workorderid = _hyper_8_2343_chunk_2.workorderid))",
                                          "Rows Removed by Index Recheck": 0,
                                          "Shared Hit Blocks": 129408,
                                          "Shared Read Blocks": 0,
                                          "Shared Dirtied Blocks": 0,
                                          "Shared Written Blocks": 0,
                                          "Local Hit Blocks": 0,
                                          "Local Read Blocks": 0,
                                          "Local Dirtied Blocks": 0,
                                          "Local Written Blocks": 0,
                                          "Temp Read Blocks": 0,
                                          "Temp Written Blocks": 0
                                        }
                                      ]
                                    },
                                    {
                                      "Node Type": "Sort",
                                      "Parent Relationship": "Inner",
                                      "Parallel Aware": false,
                                      "Async Capable": false,
                                      "Startup Cost": 2.04,
                                      "Total Cost": 2.05,
                                      "Plan Rows": 1,
                                      "Plan Width": 51,
                                      "Actual Startup Time": 0.001,
                                      "Actual Total Time": 0.435,
                                      "Actual Rows": 10424,
                                      "Actual Loops": 32352,
                                      "Output": ["NULL::bigint", "sim_run_component_metadata_1.generator", "sim_run_component_metadata_1.component", "((sim_run_component_metadata_1.value)::timestamp with time zone)"],
                                      "Sort Key": ["sim_run_component_metadata_1.generator", "sim_run_component_metadata_1.component"],
                                      "Sort Method": "quicksort",
                                      "Sort Space Used": 1158,
                                      "Sort Space Type": "Memory",
                                      "Shared Hit Blocks": 220,
                                      "Shared Read Blocks": 0,
                                      "Shared Dirtied Blocks": 0,
                                      "Shared Written Blocks": 0,
                                      "Local Hit Blocks": 0,
                                      "Local Read Blocks": 0,
                                      "Local Dirtied Blocks": 0,
                                      "Local Written Blocks": 0,
                                      "Temp Read Blocks": 0,
                                      "Temp Written Blocks": 0,
                                      "Plans": [
                                        {
                                          "Node Type": "Index Scan",
                                          "Parent Relationship": "Outer",
                                          "Parallel Aware": false,
                                          "Async Capable": false,
                                          "Scan Direction": "Forward",
                                          "Index Name": "idx_simruncomponentmetadata_simrunid_key",
                                          "Relation Name": "sim_run_component_metadata",
                                          "Schema": "public",
                                          "Alias": "sim_run_component_metadata_1",
                                          "Startup Cost": 0.43,
                                          "Total Cost": 2.03,
                                          "Plan Rows": 1,
                                          "Plan Width": 51,
                                          "Actual Startup Time": 0.024,
                                          "Actual Total Time": 5.212,
                                          "Actual Rows": 10424,
                                          "Actual Loops": 1,
                                          "Output": ["NULL::bigint", "sim_run_component_metadata_1.generator", "sim_run_component_metadata_1.component", "(sim_run_component_metadata_1.value)::timestamp with time zone"],
                                          "Index Cond": "((sim_run_component_metadata_1.sim_run_id = 325) AND ((sim_run_component_metadata_1.key)::text = 'LATEST'::text))",
                                          "Rows Removed by Index Recheck": 0,
                                          "Shared Hit Blocks": 220,
                                          "Shared Read Blocks": 0,
                                          "Shared Dirtied Blocks": 0,
                                          "Shared Written Blocks": 0,
                                          "Local Hit Blocks": 0,
                                          "Local Read Blocks": 0,
                                          "Local Dirtied Blocks": 0,
                                          "Local Written Blocks": 0,
                                          "Temp Read Blocks": 0,
                                          "Temp Written Blocks": 0
                                        }
                                      ]
                                    }
                                  ]
                                }
                              ]
                            }
                          ]
                        }
                      ]
                    }
                  ]
                }
              ]
            }
          ]
        }
      ]
    },
    "Planning": {
      "Shared Hit Blocks": 675,
      "Shared Read Blocks": 1,
      "Shared Dirtied Blocks": 8,
      "Shared Written Blocks": 0,
      "Local Hit Blocks": 0,
      "Local Read Blocks": 0,
      "Local Dirtied Blocks": 0,
      "Local Written Blocks": 0,
      "Temp Read Blocks": 0,
      "Temp Written Blocks": 0
    },
    "Planning Time": 4.678,
    "Triggers": [
    ],
    "Execution Time": 71423.588
  }
]
with
    filtered_elements as (
        select
            simulationrunid,
            elementid,
            elementcreatedatcomponentid
        from element
        where simulationrunid = 325
        order by elementid
    ),
    filtered_component_metadata as NOT materialized (
        select
            sim_run_id,
            generator,
            component,
            cast(value as timestamptz) as late_ref_time
        from sim_run_component_metadata
        where sim_run_id = 325
        and key = 'LATEST'
        order by generator, component
    )
    -- select * from filtered_component_metadata;
    ,
    lwt_lu_comp as (
    /* filter data for sim run as early as possible to reduce amount of data */
        select
            simulationrunid,
            componentid,
            discriminator,
            elementid,
            workorderid,
            start,
            finish
        from lu_worker_tracking
        where simulationrunid = 325
        and discriminator = 'TRACKING_TYPE_LU_COMPONENT'
        order by
            componentid,
            discriminator,
            elementid,
            workorderid,
            start,
            finish
    ),
    lwt_lu_area as (
    /* filter data for sim run as early as possible to reduce amount of data */
        select
            simulationrunid,
            componentid,
            discriminator,
            elementid,
            workorderid,
            start,
            finish
        from lu_worker_tracking
        where simulationrunid = 325
        and discriminator = 'TRACKING_TYPE_LU_AREA'
        order by
            componentid,
            discriminator,
            elementid,
            workorderid,
            start,
            finish
    ),
    lwt_work_time as (
    /* filter data for sim run as early as possible to reduce amount of data */
        select
            simulationrunid,
            componentid,
            discriminator,
            elementid,
            workorderid,
            start,
            finish
        from lu_worker_tracking
        where simulationrunid = 325
        and discriminator = 'TRACKING_TYPE_WORK_TIME'
        order by
            componentid,
            discriminator,
            elementid,
            workorderid,
            start,
            finish
    ),
    lu_holding as (
    /* calculate amount of LUs in component on end_of_bucket (finished/in_area, evaluated late against ref_time) */
        select
            simulationrunid,
            componentid,
            bucket_start,
            bucket_start + '1 hour'::interval as bucket_end,
            sum(case when finish >= bucket_start and finish < bucket_start + '1 hour'::interval then 1 else 0 end) as finished_on_end,
            sum(case when finish >= bucket_start + '1 hour'::interval then 1 else 0 end) as in_area_on_end,
            sum(case when finish >= bucket_start and finish < bucket_start + '1 hour'::interval and finish > late_ref_time then 1 else 0 end) as finished_late_on_end,
            sum(case when finish >= bucket_start + '1 hour'::interval and late_ref_time < bucket_start + '1 hour'::interval  and finish > late_ref_time then 1 else 0 end) as in_area_late_on_end
        from (
            select
            lwt.simulationrunid,
            lwt.componentid,
            lwt.elementid,
            lwt.start,
            lwt.finish,
            generate_series(time_bucket('1 hour', lwt.start), time_bucket('1 hour', lwt.finish), '1 hour'::interval) bucket_start,
            --CAST(m_latest.value AS timestamptz) AS late_ref_time
            m_latest.late_ref_time
            from lwt_lu_comp lwt
            join filtered_elements e on (e.simulationrunid = lwt.simulationrunid and e.elementid = lwt.elementid)
            --left join sim_run_component_metadata m_latest on (m_latest.sim_run_id = lwt.simulationrunid and m_latest.generator = e.elementcreatedatcomponentid and m_latest.component = lwt.componentid and m_latest.key = 'LATEST')
            left join filtered_component_metadata m_latest on (m_latest.generator = e.elementcreatedatcomponentid and m_latest.component = lwt.componentid)
        ) as lu_holding_buckets
        group by simulationrunid, componentid, bucket_start, bucket_end
    )
    ,
    work_time as (
    /* calculate worked time and work time capacity from shifts */
        select
            simulationrunid,
            componentid,
            bucket_start,
            bucket_end,
            extract(epoch from sum(work_time_end - work_time_start)) as work_time_sec,
            count(distinct workerid) workers,
            count(distinct workorderid) workorders,
            sum(in_progress_on_end) as in_progress_on_end,
            sum(in_progress_late_on_end) as in_progress_late_on_end
        from (
            select
                simulationrunid,
                componentid,
                elementid,
                workorderid,
                workerid,
                start,
                finish,
                late_ref_time,
                bucket_start,
                bucket_start + '1 hour'::interval as bucket_end,
                case when start > bucket_start then start else bucket_start end as work_time_start,
                case when finish < bucket_start + '1 hour'::interval then finish else bucket_start + '1 hour'::interval end as work_time_end,
                case when finish >= bucket_start + '1 hour'::interval then 1 else 0 end as in_progress_on_end,
                case when finish >= bucket_start + '1 hour'::interval and finish > late_ref_time then 1 else 0 end as in_progress_late_on_end
            from (
                select
                lwt.simulationrunid,
                lwt.componentid,
                lwt.elementid,
                lwt.workorderid,
                wo.workerid,
                lwt.start,
                lwt.finish,
                --CAST(m_latest.value AS timestamptz) AS late_ref_time,
                m_latest.late_ref_time,
                generate_series(time_bucket('1 hour', lwt.start), time_bucket('1 hour', lwt.finish), '1 hour'::interval) bucket_start
                from lwt_work_time lwt
                join filtered_elements e on (e.simulationrunid = lwt.simulationrunid and e.elementid = lwt.elementid)
                join work_order wo on (wo.simulationrunid = lwt.simulationrunid and wo.componentid = lwt.componentid and wo.workorderid = lwt.workorderid)
                --left join sim_run_component_metadata m_latest on (m_latest.sim_run_id = lwt.simulationrunid and m_latest.generator = e.elementcreatedatcomponentid and m_latest.component = lwt.componentid and m_latest.key = 'LATEST')
                left join filtered_component_metadata m_latest on (m_latest.generator = e.elementcreatedatcomponentid and m_latest.component = lwt.componentid)
            ) as work_order_buckets
        ) as work_order_aggregated
        group by simulationrunid, componentid, bucket_start, bucket_end
    ),
    ac_enter_leave_events AS (
    /* create rows for enter and leave event for each element to create change history over time */
            SELECT
                lwt.simulationrunid,
                lwt.componentid,
                lwt.elementid,
                lwt.start,
                lwt.finish,
                event_time,
                element_change,
                SUM(element_change) OVER ( /* calculate cumulative sum over change history */
                    PARTITION BY lwt.componentid
                    ORDER BY event_time
                    ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
                ) AS max_elements
            FROM lwt_lu_area lwt
            CROSS JOIN LATERAL (
                VALUES
                    (lwt.start, 1),
                    (lwt.finish, -1)
            ) AS event(event_time, element_change)
        where element_change > 0 /* we consider only enter events, which contribute to max elements in bucket/component */
        order by
            componentid,
            elementid,
            event_time
    )
    --select * from ac_enter_leave_events;
    ,
    ac_expand_timeline_to_buckets AS (
    /* distribute events across bucketized timeline */
        select
            simulationrunid,
            componentid,
            elementid,
            event_time,
            bucket_start,
            bucket_start + INTERVAL '1 hour' AS bucket_end,
            max_elements
        from (
            SELECT
                e.simulationrunid,
                e.componentid,
                e.elementid,
                e.event_time,
                generate_series(time_bucket('1 hour', e.start), time_bucket('1 hour', e.finish), '1 hour'::interval) bucket_start,
                e.max_elements
            FROM ac_enter_leave_events e
        ) as ac_buckets
    ),
    ac_aggregated_buckets AS (
    /* group events to buckets per component */
        SELECT
            e.simulationrunid,
            e.componentid,
            e.bucket_start,
            e.bucket_end,
            MAX(e.max_elements) AS elements_max
        FROM ac_expand_timeline_to_buckets e
        GROUP BY e.simulationrunid, e.componentid, e.bucket_start, e.bucket_end
    )            ,
    area_capacity AS (
    /* get area limits and evaluate amount of LUs against limits */
        SELECT
            a.simulationrunid,
            a.componentid,
            a.bucket_start,
            a.bucket_end,
            a.elements_max,
            COALESCE(CAST(lim_soft.value AS INTEGER), NULL) AS limit_soft,
            COALESCE(CAST(lim_hard.value AS INTEGER), NULL) AS limit_hard,
            CASE
                WHEN a.elements_max > COALESCE(CAST(lim_soft.value AS INTEGER), 'infinity'::float8) THEN 1
                ELSE 0
            END AS limit_soft_exceeded
        FROM ac_aggregated_buckets a
        LEFT JOIN sim_run_component_metadata lim_soft
            ON lim_soft.sim_run_id = a.simulationrunid
            AND lim_soft.component = a.componentid
            AND lim_soft.generator = 'AREA_CAPACITY'
            AND lim_soft.key = 'SOFT'
        LEFT JOIN sim_run_component_metadata lim_hard
            ON lim_hard.sim_run_id = a.simulationrunid
            AND lim_hard.component = a.componentid
            AND lim_hard.generator = 'AREA_CAPACITY'
            AND lim_hard.key = 'HARD'
    )
    select
    lu.simulationrunid,
    lu.componentid,
    lu.bucket_start at time zone 'UTC' bucket_start,
    lu.bucket_end at time zone 'UTC' bucket_end,
    lu.finished_on_end,
    lu.in_area_on_end,
    lu.finished_late_on_end,
    lu.in_area_late_on_end,
    wt.work_time_sec as worked_time_sec,
    wt.workers,
    wt.workorders,
    wt.in_progress_on_end,
    wt.in_progress_late_on_end,
    ac.elements_max,
    ac.limit_soft,
    ac.limit_hard,
    ac.limit_soft_exceeded
    from lu_holding lu
    left join work_time wt on (wt.simulationrunid = lu.simulationrunid and wt.componentid = lu.componentid and wt.bucket_start = lu.bucket_start and wt.bucket_end = lu.bucket_end)
    full join area_capacity ac on (ac.simulationrunid = lu.simulationrunid and ac.componentid = lu.componentid and ac.bucket_start = lu.bucket_start and ac.bucket_end = lu.bucket_end)
    ;
Table Count Time
work_order 1 97.1ms 0%
#93 Index Scan 97.1ms 0%
sim_run_component_metadata 4 23ms 0%
#33 Index Scan 10.7ms 0%
#65 Index Scan 5.29ms 0%
#95 Index Scan 5.21ms 0%
#35 Index Scan 1.76ms 0%
_hyper_8_2356_chunk 3 4.19ms 0%
#59 Index Scan 1.61ms 0%
#88 Index Scan 1.37ms 0%
#28 Index Scan 1.21ms 0%
_hyper_8_2350_chunk 3 3.99ms 0%
#53 Index Scan 1.51ms 0%
#82 Index Scan 1.31ms 0%
#22 Index Scan 1.17ms 0%
_hyper_8_2355_chunk 3 3.89ms 0%
#58 Index Scan 1.48ms 0%
#87 Index Scan 1.29ms 0%
#27 Index Scan 1.13ms 0%
_hyper_8_2344_chunk 3 3.73ms 0%
#76 Index Scan 1.45ms 0%
#47 Index Scan 1.35ms 0%
#16 Index Scan 0.927ms 0%
_hyper_8_2349_chunk 3 3.66ms 0%
#52 Index Scan 1.35ms 0%
#81 Index Scan 1.23ms 0%
#21 Index Scan 1.07ms 0%
_hyper_8_2354_chunk 3 3.58ms 0%
#57 Index Scan 1.37ms 0%
#86 Index Scan 1.2ms 0%
#26 Index Scan 1.01ms 0%
_hyper_8_2348_chunk 3 3.44ms 0%
#51 Index Scan 1.3ms 0%
#80 Index Scan 1.18ms 0%
#20 Index Scan 0.969ms 0%
_hyper_8_2343_chunk 3 3.38ms 0%
#75 Index Scan 1.32ms 0%
#46 Index Scan 1.22ms 0%
#15 Index Scan 0.841ms 0%
_hyper_8_2353_chunk 3 2.25ms 0%
#56 Index Scan 0.923ms 0%
#25 Index Scan 0.718ms 0%
#85 Index Scan 0.611ms 0%
_hyper_8_2347_chunk 3 2.15ms 0%
#50 Index Scan 0.939ms 0%
#19 Index Scan 0.715ms 0%
#79 Index Scan 0.492ms 0%
_hyper_8_2357_chunk 3 2.09ms 0%
#89 Index Scan 1ms 0%
#60 Index Scan 0.606ms 0%
#29 Index Scan 0.484ms 0%
_hyper_8_2351_chunk 3 1.97ms 0%
#83 Index Scan 0.986ms 0%
#54 Index Scan 0.537ms 0%
#23 Index Scan 0.443ms 0%
element 1 1.89ms 0%
#2 Index Scan 1.89ms 0%
_hyper_8_2352_chunk 3 1.02ms 0%
#55 Index Scan 0.414ms 0%
#24 Index Scan 0.364ms 0%
#84 Index Scan 0.241ms 0%
_hyper_8_2346_chunk 3 0.927ms 0%
#49 Index Scan 0.402ms 0%
#18 Index Scan 0.34ms 0%
#78 Index Scan 0.185ms 0%
_hyper_8_2358_chunk 3 0.027ms 0%
#30 Index Scan 0.013ms 0%
#90 Index Scan 0.007ms 0%
#61 Index Scan 0.007ms 0%
_hyper_8_2345_chunk 3 0.021ms 0%
#77 Index Scan 0.007ms 0%
#48 Index Scan 0.007ms 0%
#17 Index Scan 0.007ms 0%
Function Count Time
No function used
Node Type Count Time
Nested Loop 4 44s 371ms 62%
#70 Nested Loop 22s 491ms 31%
#42 Nested Loop 21s 822ms 31%
#71 Nested Loop 35.4ms 0%
#12 Nested Loop 22.5ms 0%
Sort 5 26s 251ms 37%
#94 Sort 14s 67.9ms 20%
#64 Sort 11s 836ms 17%
#39 Sort 268ms 0%
#67 Sort 40.8ms 0%
#3 Sort 38.8ms 0%
Incremental Sort 5 241ms 0%
#73 Incremental Sort 62.6ms 0%
#44 Incremental Sort 58.8ms 0%
#9 Incremental Sort 54.4ms 0%
#13 Incremental Sort 52.9ms 0%
#11 Incremental Sort 12ms 0%
Index Scan 54 162ms 0%
#93 Index Scan 97.1ms 0%
#33 Index Scan 10.7ms 0%
#65 Index Scan 5.29ms 0%
#95 Index Scan 5.21ms 0%
#2 Index Scan 1.89ms 0%
#35 Index Scan 1.76ms 0%
#59 Index Scan 1.61ms 0%
#53 Index Scan 1.51ms 0%
#58 Index Scan 1.48ms 0%
#76 Index Scan 1.45ms 0%
#88 Index Scan 1.37ms 0%
#57 Index Scan 1.37ms 0%
#52 Index Scan 1.35ms 0%
#47 Index Scan 1.35ms 0%
#75 Index Scan 1.32ms 0%
#82 Index Scan 1.31ms 0%
#51 Index Scan 1.3ms 0%
#87 Index Scan 1.29ms 0%
#81 Index Scan 1.23ms 0%
#46 Index Scan 1.22ms 0%
#28 Index Scan 1.21ms 0%
#86 Index Scan 1.2ms 0%
#80 Index Scan 1.18ms 0%
#22 Index Scan 1.17ms 0%
#27 Index Scan 1.13ms 0%
#21 Index Scan 1.07ms 0%
#26 Index Scan 1.01ms 0%
#89 Index Scan 1ms 0%
#83 Index Scan 0.986ms 0%
#20 Index Scan 0.969ms 0%
#50 Index Scan 0.939ms 0%
#16 Index Scan 0.927ms 0%
#56 Index Scan 0.923ms 0%
#15 Index Scan 0.841ms 0%
#25 Index Scan 0.718ms 0%
#19 Index Scan 0.715ms 0%
#85 Index Scan 0.611ms 0%
#60 Index Scan 0.606ms 0%
#54 Index Scan 0.537ms 0%
#79 Index Scan 0.492ms 0%
#29 Index Scan 0.484ms 0%
#23 Index Scan 0.443ms 0%
#55 Index Scan 0.414ms 0%
#49 Index Scan 0.402ms 0%
#24 Index Scan 0.364ms 0%
#18 Index Scan 0.34ms 0%
#84 Index Scan 0.241ms 0%
#78 Index Scan 0.185ms 0%
#30 Index Scan 0.013ms 0%
#90 Index Scan 0.007ms 0%
#77 Index Scan 0.007ms 0%
#61 Index Scan 0.007ms 0%
#48 Index Scan 0.007ms 0%
#17 Index Scan 0.007ms 0%
ProjectSet 3 80.6ms 0%
#41 ProjectSet 32.7ms 0%
#8 ProjectSet 26.8ms 0%
#69 ProjectSet 21.2ms 0%
GroupAggregate 2 72.3ms 0%
#38 GroupAggregate 57.8ms 0%
#66 GroupAggregate 14.5ms 0%
Hash Join 4 62.1ms 0%
#72 Hash Join 26.5ms 0%
#43 Hash Join 22.7ms 0%
#4 Hash Join 9.09ms 0%
#5 Hash Join 3.69ms 0%
HashAggregate 1 58ms 0%
#6 HashAggregate 58ms 0%
Subquery Scan 3 52.7ms 0%
#40 Subquery Scan 23ms 0%
#7 Subquery Scan 21.2ms 0%
#68 Subquery Scan 8.5ms 0%
Merge Join 2 24.5ms 0%
#1 Merge Join 20.1ms 0%
#37 Merge Join 4.46ms 0%
Merge Append 3 13.1ms 0%
#74 Merge Append 4.73ms 0%
#45 Merge Append 4.57ms 0%
#14 Merge Append 3.8ms 0%
WindowAgg 1 12.9ms 0%
#10 WindowAgg 12.9ms 0%
Materialize 1 8.69ms 0%
#36 Materialize 8.69ms 0%
Hash 4 4.24ms 0%
#62 Hash 1.58ms 0%
#91 Hash 1.4ms 0%
#32 Hash 0.84ms 0%
#34 Hash 0.423ms 0%
CTE Scan 2 3.09ms 0%
#63 CTE Scan 2.7ms 0%
#92 CTE Scan 0.389ms 0%
Values Scan 1 0ms 0%
#31 Values Scan 0ms 0%
Index Count Time
workorder_pkey 1 97.1ms 0%
#93 Index Scan 97.1ms 0%
idx_simruncomponentmetadata_simrunid_key 4 23ms 0%
#33 Index Scan 10.7ms 0%
#65 Index Scan 5.29ms 0%
#95 Index Scan 5.21ms 0%
#35 Index Scan 1.76ms 0%
_hyper_8_2356_chunk_luworkertracking_idx 3 4.19ms 0%
#59 Index Scan 1.61ms 0%
#88 Index Scan 1.37ms 0%
#28 Index Scan 1.21ms 0%
_hyper_8_2350_chunk_luworkertracking_idx 3 3.99ms 0%
#53 Index Scan 1.51ms 0%
#82 Index Scan 1.31ms 0%
#22 Index Scan 1.17ms 0%
_hyper_8_2355_chunk_luworkertracking_idx 3 3.89ms 0%
#58 Index Scan 1.48ms 0%
#87 Index Scan 1.29ms 0%
#27 Index Scan 1.13ms 0%
_hyper_8_2344_chunk_luworkertracking_idx 3 3.73ms 0%
#76 Index Scan 1.45ms 0%
#47 Index Scan 1.35ms 0%
#16 Index Scan 0.927ms 0%
_hyper_8_2349_chunk_luworkertracking_idx 3 3.66ms 0%
#52 Index Scan 1.35ms 0%
#81 Index Scan 1.23ms 0%
#21 Index Scan 1.07ms 0%
_hyper_8_2354_chunk_luworkertracking_idx 3 3.58ms 0%
#57 Index Scan 1.37ms 0%
#86 Index Scan 1.2ms 0%
#26 Index Scan 1.01ms 0%
_hyper_8_2348_chunk_luworkertracking_idx 3 3.44ms 0%
#51 Index Scan 1.3ms 0%
#80 Index Scan 1.18ms 0%
#20 Index Scan 0.969ms 0%
_hyper_8_2343_chunk_luworkertracking_idx 3 3.38ms 0%
#75 Index Scan 1.32ms 0%
#46 Index Scan 1.22ms 0%
#15 Index Scan 0.841ms 0%
_hyper_8_2353_chunk_luworkertracking_idx 3 2.25ms 0%
#56 Index Scan 0.923ms 0%
#25 Index Scan 0.718ms 0%
#85 Index Scan 0.611ms 0%
_hyper_8_2347_chunk_luworkertracking_idx 3 2.15ms 0%
#50 Index Scan 0.939ms 0%
#19 Index Scan 0.715ms 0%
#79 Index Scan 0.492ms 0%
_hyper_8_2357_chunk_luworkertracking_idx 3 2.09ms 0%
#89 Index Scan 1ms 0%
#60 Index Scan 0.606ms 0%
#29 Index Scan 0.484ms 0%
_hyper_8_2351_chunk_luworkertracking_idx 3 1.97ms 0%
#83 Index Scan 0.986ms 0%
#54 Index Scan 0.537ms 0%
#23 Index Scan 0.443ms 0%
element_pkey 1 1.89ms 0%
#2 Index Scan 1.89ms 0%
_hyper_8_2352_chunk_luworkertracking_idx 3 1.02ms 0%
#55 Index Scan 0.414ms 0%
#24 Index Scan 0.364ms 0%
#84 Index Scan 0.241ms 0%
_hyper_8_2346_chunk_luworkertracking_idx 3 0.927ms 0%
#49 Index Scan 0.402ms 0%
#18 Index Scan 0.34ms 0%
#78 Index Scan 0.185ms 0%
_hyper_8_2358_chunk_luworkertracking_idx 3 0.027ms 0%
#30 Index Scan 0.013ms 0%
#90 Index Scan 0.007ms 0%
#61 Index Scan 0.007ms 0%
_hyper_8_2345_chunk_luworkertracking_idx 3 0.021ms 0%
#77 Index Scan 0.007ms 0%
#48 Index Scan 0.007ms 0%
#17 Index Scan 0.007ms 0%