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 |
[
{
"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% |
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% |