Skip to content

Instantly share code, notes, and snippets.

@akuzm

akuzm/chunk-exclusion-explain.json

Created May 30, 2025 11:10
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save akuzm/612a1ab0094a804cd38b27d5cb3841c7 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save akuzm/612a1ab0094a804cd38b27d5cb3841c7 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
chunk-exclusion-explain.json
[
{
"Plan": {
"Node Type": "Limit",
"Parallel Aware": false,
"Startup Cost": 106.72,
"Total Cost": 106.72,
"Plan Rows": 1,
"Plan Width": 318,
"Actual Startup Time": 1.796,
"Actual Total Time": 1.819,
"Actual Rows": 100,
"Actual Loops": 1,
"Plans": [
{
"Node Type": "Sort",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Startup Cost": 106.72,
"Total Cost": 106.72,
"Plan Rows": 1,
"Plan Width": 318,
"Actual Startup Time": 1.795,
"Actual Total Time": 1.809,
"Actual Rows": 100,
"Actual Loops": 1,
"Sort Key": ["_hyper_5_34873_chunk.\"time\" DESC"],
"Sort Method": "top-N heapsort",
"Sort Space Used": 51,
"Sort Space Type": "Memory",
"Plans": [
{
"Node Type": "Nested Loop",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Join Type": "Inner",
"Startup Cost": 0.99,
"Total Cost": 106.71,
"Plan Rows": 1,
"Plan Width": 318,
"Actual Startup Time": 0.127,
"Actual Total Time": 1.568,
"Actual Rows": 218,
"Actual Loops": 1,
"Inner Unique": true,
"Join Filter": "(l.location_id = p.location_id)",
"Rows Removed by Join Filter": 0,
"Plans": [
{
"Node Type": "Nested Loop",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Join Type": "Inner",
"Startup Cost": 0.71,
"Total Cost": 53.66,
"Plan Rows": 34,
"Plan Width": 238,
"Actual Startup Time": 0.113,
"Actual Total Time": 1.030,
"Actual Rows": 218,
"Actual Loops": 1,
"Inner Unique": false,
"Plans": [
{
"Node Type": "Index Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "locations_name_k",
"Relation Name": "locations",
"Alias": "l",
"Startup Cost": 0.14,
"Total Cost": 2.16,
"Plan Rows": 1,
"Plan Width": 176,
"Actual Startup Time": 0.019,
"Actual Total Time": 0.021,
"Actual Rows": 1,
"Actual Loops": 1,
"Index Cond": "(location_name = 'Max Home'::text)",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Append",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Startup Cost": 0.56,
"Total Cost": 51.18,
"Plan Rows": 32,
"Plan Width": 62,
"Actual Startup Time": 0.090,
"Actual Total Time": 0.941,
"Actual Rows": 218,
"Actual Loops": 1,
"Subplans Removed": 0,
"Plans": [
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34873_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34873_chunk",
"Alias": "_hyper_5_34873_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.32,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.044,
"Actual Total Time": 0.044,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)) AND (\"time\" >= '2023-01-01 00:00:00+00'::timestamp with time zone) AND (\"time\" <= '2023-01-04 23:59:59+00'::timestamp with time zone))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34872_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34872_chunk",
"Alias": "_hyper_5_34872_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.40,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.035,
"Actual Total Time": 0.169,
"Actual Rows": 33,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)) AND (\"time\" >= '2023-01-01 00:00:00+00'::timestamp with time zone) AND (\"time\" <= '2023-01-04 23:59:59+00'::timestamp with time zone))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34869_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34869_chunk",
"Alias": "_hyper_5_34869_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.36,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.052,
"Actual Total Time": 0.220,
"Actual Rows": 64,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)) AND (\"time\" >= '2023-01-01 00:00:00+00'::timestamp with time zone) AND (\"time\" <= '2023-01-04 23:59:59+00'::timestamp with time zone))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34868_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34868_chunk",
"Alias": "_hyper_5_34868_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.40,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.060,
"Actual Total Time": 0.215,
"Actual Rows": 75,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)) AND (\"time\" >= '2023-01-01 00:00:00+00'::timestamp with time zone) AND (\"time\" <= '2023-01-04 23:59:59+00'::timestamp with time zone))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34867_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34867_chunk",
"Alias": "_hyper_5_34867_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.36,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.051,
"Actual Total Time": 0.143,
"Actual Rows": 46,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)) AND (\"time\" >= '2023-01-01 00:00:00+00'::timestamp with time zone) AND (\"time\" <= '2023-01-04 23:59:59+00'::timestamp with time zone))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34864_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34864_chunk",
"Alias": "_hyper_5_34864_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.40,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.029,
"Actual Total Time": 0.030,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)) AND (\"time\" >= '2023-01-01 00:00:00+00'::timestamp with time zone) AND (\"time\" <= '2023-01-04 23:59:59+00'::timestamp with time zone))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34861_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34861_chunk",
"Alias": "_hyper_5_34861_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.34,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.028,
"Actual Total Time": 0.028,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)) AND (\"time\" >= '2023-01-01 00:00:00+00'::timestamp with time zone) AND (\"time\" <= '2023-01-04 23:59:59+00'::timestamp with time zone))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34855_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34855_chunk",
"Alias": "_hyper_5_34855_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.40,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.027,
"Actual Total Time": 0.028,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)) AND (\"time\" >= '2023-01-01 00:00:00+00'::timestamp with time zone) AND (\"time\" <= '2023-01-04 23:59:59+00'::timestamp with time zone))",
"Rows Removed by Index Recheck": 0
}
]
}
]
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "positions_pkey",
"Relation Name": "positions",
"Alias": "p",
"Startup Cost": 0.29,
"Total Cost": 1.55,
"Plan Rows": 1,
"Plan Width": 80,
"Actual Startup Time": 0.002,
"Actual Total Time": 0.002,
"Actual Rows": 1,
"Actual Loops": 218,
"Index Cond": "(position_id = _hyper_5_34873_chunk.position_id)",
"Rows Removed by Index Recheck": 0
}
]
}
]
}
]
},
"Planning Time": 3.770,
"Triggers": [
],
"Execution Time": 2.030
}
]
Bad plan:
Without the extra constant time bounds in the query the resulting plan is looking at every single chunk in the table instead of excluding them according to the timebounds of the query. The query runs significantly slower because of this.
EXPLAIN (ANALYSE, FORMAT JSON)
SELECT *
FROM node_measurements
join positions p ON node_measurements.position_id = p.position_id
join locations l on p.location_id = l.location_id
WHERE time between timezone(l.timezone , '2023-01-02 00:00:00+0000'::timestamptz) and timezone(l.timezone,'2023-01-03 23:59:59+0000'::timestamptz)
AND location_name = 'Max Home'
AND measurement_type = 'temperature_set'
AND src_mac_id = 'FFFF14B4577FE5F0'
ORDER by time DESC limit 100;
Output:
[
{
"Plan": {
"Node Type": "Limit",
"Parallel Aware": false,
"Startup Cost": 1815.14,
"Total Cost": 1815.16,
"Plan Rows": 6,
"Plan Width": 318,
"Actual Startup Time": 24.407,
"Actual Total Time": 24.571,
"Actual Rows": 100,
"Actual Loops": 1,
"Plans": [
{
"Node Type": "Sort",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Startup Cost": 1815.14,
"Total Cost": 1815.16,
"Plan Rows": 6,
"Plan Width": 318,
"Actual Startup Time": 24.405,
"Actual Total Time": 24.558,
"Actual Rows": 100,
"Actual Loops": 1,
"Sort Key": ["_hyper_5_34905_chunk.\"time\" DESC"],
"Sort Method": "top-N heapsort",
"Sort Space Used": 78,
"Sort Space Type": "Memory",
"Plans": [
{
"Node Type": "Hash Join",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Join Type": "Inner",
"Startup Cost": 952.14,
"Total Cost": 1815.07,
"Plan Rows": 6,
"Plan Width": 318,
"Actual Startup Time": 11.216,
"Actual Total Time": 24.257,
"Actual Rows": 218,
"Actual Loops": 1,
"Inner Unique": false,
"Hash Cond": "((p.position_id = _hyper_5_34905_chunk.position_id) AND (p.location_id = l.location_id))",
"Plans": [
{
"Node Type": "Seq Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Relation Name": "positions",
"Alias": "p",
"Startup Cost": 0.00,
"Total Cost": 654.21,
"Plan Rows": 27821,
"Plan Width": 80,
"Actual Startup Time": 0.016,
"Actual Total Time": 4.395,
"Actual Rows": 27860,
"Actual Loops": 1
},
{
"Node Type": "Hash",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Startup Cost": 942.75,
"Total Cost": 942.75,
"Plan Rows": 626,
"Plan Width": 238,
"Actual Startup Time": 9.866,
"Actual Total Time": 10.001,
"Actual Rows": 218,
"Actual Loops": 1,
"Hash Buckets": 1024,
"Original Hash Buckets": 1024,
"Hash Batches": 1,
"Original Hash Batches": 1,
"Peak Memory Usage": 50,
"Plans": [
{
"Node Type": "Nested Loop",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Join Type": "Inner",
"Startup Cost": 0.56,
"Total Cost": 942.75,
"Plan Rows": 626,
"Plan Width": 238,
"Actual Startup Time": 1.226,
"Actual Total Time": 9.782,
"Actual Rows": 218,
"Actual Loops": 1,
"Inner Unique": false,
"Plans": [
{
"Node Type": "Seq Scan",
"Parent Relationship": "Outer",
"Parallel Aware": false,
"Relation Name": "locations",
"Alias": "l",
"Startup Cost": 0.00,
"Total Cost": 8.22,
"Plan Rows": 1,
"Plan Width": 176,
"Actual Startup Time": 0.042,
"Actual Total Time": 0.055,
"Actual Rows": 1,
"Actual Loops": 1,
"Filter": "(location_name = 'Max Home'::text)",
"Rows Removed by Filter": 99
},
{
"Node Type": "Append",
"Parent Relationship": "Inner",
"Parallel Aware": false,
"Startup Cost": 0.56,
"Total Cost": 928.45,
"Plan Rows": 607,
"Plan Width": 62,
"Actual Startup Time": 1.128,
"Actual Total Time": 9.553,
"Actual Rows": 218,
"Actual Loops": 1,
"Subplans Removed": 0,
"Plans": [
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34905_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34905_chunk",
"Alias": "_hyper_5_34905_chunk",
"Startup Cost": 0.56,
"Total Cost": 2.69,
"Plan Rows": 1,
"Plan Width": 62,
"Actual Startup Time": 0.044,
"Actual Total Time": 0.045,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34904_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34904_chunk",
"Alias": "_hyper_5_34904_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.16,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.051,
"Actual Total Time": 0.052,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34903_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34903_chunk",
"Alias": "_hyper_5_34903_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.14,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.039,
"Actual Total Time": 0.040,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34902_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34902_chunk",
"Alias": "_hyper_5_34902_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.19,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.064,
"Actual Total Time": 0.064,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34901_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34901_chunk",
"Alias": "_hyper_5_34901_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.16,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.042,
"Actual Total Time": 0.042,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34899_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34899_chunk",
"Alias": "_hyper_5_34899_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.16,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.050,
"Actual Total Time": 0.051,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34896_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34896_chunk",
"Alias": "_hyper_5_34896_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.17,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.038,
"Actual Total Time": 0.038,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34894_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34894_chunk",
"Alias": "_hyper_5_34894_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.17,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.044,
"Actual Total Time": 0.044,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34893_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34893_chunk",
"Alias": "_hyper_5_34893_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.16,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.045,
"Actual Total Time": 0.046,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34891_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34891_chunk",
"Alias": "_hyper_5_34891_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.16,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.061,
"Actual Total Time": 0.061,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34890_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34890_chunk",
"Alias": "_hyper_5_34890_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.17,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.057,
"Actual Total Time": 0.057,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34887_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34887_chunk",
"Alias": "_hyper_5_34887_chunk",
"Startup Cost": 0.56,
"Total Cost": 31.01,
"Plan Rows": 24,
"Plan Width": 62,
"Actual Startup Time": 0.092,
"Actual Total Time": 0.092,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34884_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34884_chunk",
"Alias": "_hyper_5_34884_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.16,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.056,
"Actual Total Time": 0.056,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34883_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34883_chunk",
"Alias": "_hyper_5_34883_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.20,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.085,
"Actual Total Time": 0.085,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34882_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34882_chunk",
"Alias": "_hyper_5_34882_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.14,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.043,
"Actual Total Time": 0.043,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34881_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34881_chunk",
"Alias": "_hyper_5_34881_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.17,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.053,
"Actual Total Time": 0.054,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34878_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34878_chunk",
"Alias": "_hyper_5_34878_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.16,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.043,
"Actual Total Time": 0.043,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34875_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34875_chunk",
"Alias": "_hyper_5_34875_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.17,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.085,
"Actual Total Time": 0.086,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34873_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34873_chunk",
"Alias": "_hyper_5_34873_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.14,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.041,
"Actual Total Time": 0.041,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34872_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34872_chunk",
"Alias": "_hyper_5_34872_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.20,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.034,
"Actual Total Time": 0.111,
"Actual Rows": 33,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34869_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34869_chunk",
"Alias": "_hyper_5_34869_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.17,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.082,
"Actual Total Time": 0.244,
"Actual Rows": 64,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34868_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34868_chunk",
"Alias": "_hyper_5_34868_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.20,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.048,
"Actual Total Time": 0.197,
"Actual Rows": 75,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34867_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34867_chunk",
"Alias": "_hyper_5_34867_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.17,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.062,
"Actual Total Time": 0.150,
"Actual Rows": 46,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34864_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34864_chunk",
"Alias": "_hyper_5_34864_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.20,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.040,
"Actual Total Time": 0.040,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34861_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34861_chunk",
"Alias": "_hyper_5_34861_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.16,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.038,
"Actual Total Time": 0.039,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34855_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34855_chunk",
"Alias": "_hyper_5_34855_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.20,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.032,
"Actual Total Time": 0.032,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34854_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34854_chunk",
"Alias": "_hyper_5_34854_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.14,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.034,
"Actual Total Time": 0.035,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34850_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34850_chunk",
"Alias": "_hyper_5_34850_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.16,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.034,
"Actual Total Time": 0.034,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34849_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34849_chunk",
"Alias": "_hyper_5_34849_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.14,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.037,
"Actual Total Time": 0.038,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34846_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34846_chunk",
"Alias": "_hyper_5_34846_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.20,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.195,
"Actual Total Time": 0.195,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34843_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34843_chunk",
"Alias": "_hyper_5_34843_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.16,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.054,
"Actual Total Time": 0.055,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34842_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34842_chunk",
"Alias": "_hyper_5_34842_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.19,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.060,
"Actual Total Time": 0.060,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34841_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34841_chunk",
"Alias": "_hyper_5_34841_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.16,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.051,
"Actual Total Time": 0.051,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34840_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34840_chunk",
"Alias": "_hyper_5_34840_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.16,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.057,
"Actual Total Time": 0.057,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34838_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34838_chunk",
"Alias": "_hyper_5_34838_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.13,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.045,
"Actual Total Time": 0.046,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34834_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34834_chunk",
"Alias": "_hyper_5_34834_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.16,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.062,
"Actual Total Time": 0.063,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34831_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34831_chunk",
"Alias": "_hyper_5_34831_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.16,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.049,
"Actual Total Time": 0.049,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34830_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34830_chunk",
"Alias": "_hyper_5_34830_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.19,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.070,
"Actual Total Time": 0.070,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34828_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34828_chunk",
"Alias": "_hyper_5_34828_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.16,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.050,
"Actual Total Time": 0.050,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34825_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34825_chunk",
"Alias": "_hyper_5_34825_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.19,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.045,
"Actual Total Time": 0.045,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34823_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34823_chunk",
"Alias": "_hyper_5_34823_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.19,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.049,
"Actual Total Time": 0.049,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34820_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34820_chunk",
"Alias": "_hyper_5_34820_chunk",
"Startup Cost": 0.56,
"Total Cost": 7.23,
"Plan Rows": 5,
"Plan Width": 62,
"Actual Startup Time": 0.026,
"Actual Total Time": 0.026,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34817_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34817_chunk",
"Alias": "_hyper_5_34817_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.19,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.044,
"Actual Total Time": 0.044,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34814_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34814_chunk",
"Alias": "_hyper_5_34814_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.19,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.048,
"Actual Total Time": 0.048,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34813_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34813_chunk",
"Alias": "_hyper_5_34813_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.17,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.043,
"Actual Total Time": 0.044,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34812_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34812_chunk",
"Alias": "_hyper_5_34812_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.16,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.060,
"Actual Total Time": 0.060,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34811_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34811_chunk",
"Alias": "_hyper_5_34811_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.17,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.048,
"Actual Total Time": 0.048,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34809_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34809_chunk",
"Alias": "_hyper_5_34809_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.17,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.057,
"Actual Total Time": 0.057,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34806_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34806_chunk",
"Alias": "_hyper_5_34806_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.20,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.048,
"Actual Total Time": 0.048,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34805_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34805_chunk",
"Alias": "_hyper_5_34805_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.16,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.064,
"Actual Total Time": 0.064,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34803_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34803_chunk",
"Alias": "_hyper_5_34803_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.17,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.045,
"Actual Total Time": 0.045,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34802_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34802_chunk",
"Alias": "_hyper_5_34802_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.17,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.027,
"Actual Total Time": 0.027,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34799_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34799_chunk",
"Alias": "_hyper_5_34799_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.16,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.026,
"Actual Total Time": 0.027,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34793_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34793_chunk",
"Alias": "_hyper_5_34793_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.16,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.045,
"Actual Total Time": 0.045,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34791_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34791_chunk",
"Alias": "_hyper_5_34791_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.17,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.026,
"Actual Total Time": 0.026,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34790_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34790_chunk",
"Alias": "_hyper_5_34790_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.19,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.025,
"Actual Total Time": 0.026,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34789_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34789_chunk",
"Alias": "_hyper_5_34789_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.19,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.028,
"Actual Total Time": 0.028,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34787_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34787_chunk",
"Alias": "_hyper_5_34787_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.19,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.025,
"Actual Total Time": 0.025,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34786_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34786_chunk",
"Alias": "_hyper_5_34786_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.16,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.066,
"Actual Total Time": 0.067,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34778_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34778_chunk",
"Alias": "_hyper_5_34778_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.14,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.333,
"Actual Total Time": 0.334,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34775_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34775_chunk",
"Alias": "_hyper_5_34775_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.14,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.057,
"Actual Total Time": 0.058,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34773_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34773_chunk",
"Alias": "_hyper_5_34773_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.16,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.057,
"Actual Total Time": 0.058,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34771_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34771_chunk",
"Alias": "_hyper_5_34771_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.17,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.059,
"Actual Total Time": 0.059,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34737_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34737_chunk",
"Alias": "_hyper_5_34737_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.16,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.036,
"Actual Total Time": 0.036,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34736_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34736_chunk",
"Alias": "_hyper_5_34736_chunk",
"Startup Cost": 0.56,
"Total Cost": 7.23,
"Plan Rows": 5,
"Plan Width": 62,
"Actual Startup Time": 0.026,
"Actual Total Time": 0.026,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34730_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34730_chunk",
"Alias": "_hyper_5_34730_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.17,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.027,
"Actual Total Time": 0.027,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34726_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34726_chunk",
"Alias": "_hyper_5_34726_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.14,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.030,
"Actual Total Time": 0.030,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34723_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34723_chunk",
"Alias": "_hyper_5_34723_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.17,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.037,
"Actual Total Time": 0.038,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34722_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34722_chunk",
"Alias": "_hyper_5_34722_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.16,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.025,
"Actual Total Time": 0.025,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34720_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34720_chunk",
"Alias": "_hyper_5_34720_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.14,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.028,
"Actual Total Time": 0.028,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34719_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34719_chunk",
"Alias": "_hyper_5_34719_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.13,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.025,
"Actual Total Time": 0.026,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34717_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34717_chunk",
"Alias": "_hyper_5_34717_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.19,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.026,
"Actual Total Time": 0.027,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34714_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34714_chunk",
"Alias": "_hyper_5_34714_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.16,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.026,
"Actual Total Time": 0.027,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34713_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34713_chunk",
"Alias": "_hyper_5_34713_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.19,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.022,
"Actual Total Time": 0.023,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34712_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34712_chunk",
"Alias": "_hyper_5_34712_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.16,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.022,
"Actual Total Time": 0.023,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34711_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34711_chunk",
"Alias": "_hyper_5_34711_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.19,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.029,
"Actual Total Time": 0.029,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34710_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34710_chunk",
"Alias": "_hyper_5_34710_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.17,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.030,
"Actual Total Time": 0.031,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34705_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34705_chunk",
"Alias": "_hyper_5_34705_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.20,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.037,
"Actual Total Time": 0.037,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34702_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34702_chunk",
"Alias": "_hyper_5_34702_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.17,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.023,
"Actual Total Time": 0.023,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34700_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34700_chunk",
"Alias": "_hyper_5_34700_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.17,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.030,
"Actual Total Time": 0.030,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34699_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34699_chunk",
"Alias": "_hyper_5_34699_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.16,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.023,
"Actual Total Time": 0.023,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34695_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34695_chunk",
"Alias": "_hyper_5_34695_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.20,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.026,
"Actual Total Time": 0.027,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34694_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34694_chunk",
"Alias": "_hyper_5_34694_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.17,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.027,
"Actual Total Time": 0.027,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34692_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34692_chunk",
"Alias": "_hyper_5_34692_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.19,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.026,
"Actual Total Time": 0.027,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34689_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34689_chunk",
"Alias": "_hyper_5_34689_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.17,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.026,
"Actual Total Time": 0.027,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34688_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34688_chunk",
"Alias": "_hyper_5_34688_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.19,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.027,
"Actual Total Time": 0.028,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34687_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34687_chunk",
"Alias": "_hyper_5_34687_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.16,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.027,
"Actual Total Time": 0.028,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34685_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34685_chunk",
"Alias": "_hyper_5_34685_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.19,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.044,
"Actual Total Time": 0.044,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34684_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34684_chunk",
"Alias": "_hyper_5_34684_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.17,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.037,
"Actual Total Time": 0.037,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34682_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34682_chunk",
"Alias": "_hyper_5_34682_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.20,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.030,
"Actual Total Time": 0.030,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34679_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34679_chunk",
"Alias": "_hyper_5_34679_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.17,
"Plan Rows": 4,
"Plan Width": 63,
"Actual Startup Time": 0.045,
"Actual Total Time": 0.045,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34677_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34677_chunk",
"Alias": "_hyper_5_34677_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.17,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.061,
"Actual Total Time": 0.061,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34676_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34676_chunk",
"Alias": "_hyper_5_34676_chunk",
"Startup Cost": 0.56,
"Total Cost": 7.23,
"Plan Rows": 5,
"Plan Width": 62,
"Actual Startup Time": 0.062,
"Actual Total Time": 0.062,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34674_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34674_chunk",
"Alias": "_hyper_5_34674_chunk",
"Startup Cost": 0.56,
"Total Cost": 7.23,
"Plan Rows": 5,
"Plan Width": 62,
"Actual Startup Time": 0.059,
"Actual Total Time": 0.059,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34673_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34673_chunk",
"Alias": "_hyper_5_34673_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.19,
"Plan Rows": 4,
"Plan Width": 63,
"Actual Startup Time": 0.042,
"Actual Total Time": 0.042,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34670_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34670_chunk",
"Alias": "_hyper_5_34670_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.17,
"Plan Rows": 4,
"Plan Width": 63,
"Actual Startup Time": 0.050,
"Actual Total Time": 0.050,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34667_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34667_chunk",
"Alias": "_hyper_5_34667_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.20,
"Plan Rows": 4,
"Plan Width": 63,
"Actual Startup Time": 0.043,
"Actual Total Time": 0.044,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34666_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34666_chunk",
"Alias": "_hyper_5_34666_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.20,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.219,
"Actual Total Time": 0.220,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34664_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34664_chunk",
"Alias": "_hyper_5_34664_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.19,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.057,
"Actual Total Time": 0.057,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34663_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34663_chunk",
"Alias": "_hyper_5_34663_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.17,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.069,
"Actual Total Time": 0.069,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34662_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34662_chunk",
"Alias": "_hyper_5_34662_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.19,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.056,
"Actual Total Time": 0.057,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34658_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34658_chunk",
"Alias": "_hyper_5_34658_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.20,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.060,
"Actual Total Time": 0.060,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34657_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34657_chunk",
"Alias": "_hyper_5_34657_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.19,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.049,
"Actual Total Time": 0.050,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34655_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34655_chunk",
"Alias": "_hyper_5_34655_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.20,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.071,
"Actual Total Time": 0.071,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34653_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34653_chunk",
"Alias": "_hyper_5_34653_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.17,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.056,
"Actual Total Time": 0.056,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34652_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34652_chunk",
"Alias": "_hyper_5_34652_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.19,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.079,
"Actual Total Time": 0.080,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34651_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34651_chunk",
"Alias": "_hyper_5_34651_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.20,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.048,
"Actual Total Time": 0.048,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34645_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34645_chunk",
"Alias": "_hyper_5_34645_chunk",
"Startup Cost": 0.56,
"Total Cost": 7.23,
"Plan Rows": 5,
"Plan Width": 62,
"Actual Startup Time": 0.071,
"Actual Total Time": 0.071,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34641_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34641_chunk",
"Alias": "_hyper_5_34641_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.19,
"Plan Rows": 4,
"Plan Width": 63,
"Actual Startup Time": 0.048,
"Actual Total Time": 0.048,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34639_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34639_chunk",
"Alias": "_hyper_5_34639_chunk",
"Startup Cost": 0.56,
"Total Cost": 7.23,
"Plan Rows": 5,
"Plan Width": 62,
"Actual Startup Time": 0.039,
"Actual Total Time": 0.040,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34638_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34638_chunk",
"Alias": "_hyper_5_34638_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.20,
"Plan Rows": 4,
"Plan Width": 63,
"Actual Startup Time": 0.047,
"Actual Total Time": 0.047,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34637_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34637_chunk",
"Alias": "_hyper_5_34637_chunk",
"Startup Cost": 0.56,
"Total Cost": 7.23,
"Plan Rows": 5,
"Plan Width": 62,
"Actual Startup Time": 0.054,
"Actual Total Time": 0.054,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34636_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34636_chunk",
"Alias": "_hyper_5_34636_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.20,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.042,
"Actual Total Time": 0.042,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34634_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34634_chunk",
"Alias": "_hyper_5_34634_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.17,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.045,
"Actual Total Time": 0.045,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34631_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34631_chunk",
"Alias": "_hyper_5_34631_chunk",
"Startup Cost": 0.56,
"Total Cost": 7.23,
"Plan Rows": 5,
"Plan Width": 62,
"Actual Startup Time": 0.106,
"Actual Total Time": 0.107,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34630_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34630_chunk",
"Alias": "_hyper_5_34630_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.19,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.055,
"Actual Total Time": 0.055,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34628_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34628_chunk",
"Alias": "_hyper_5_34628_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.20,
"Plan Rows": 4,
"Plan Width": 63,
"Actual Startup Time": 0.046,
"Actual Total Time": 0.047,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34627_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34627_chunk",
"Alias": "_hyper_5_34627_chunk",
"Startup Cost": 0.56,
"Total Cost": 7.23,
"Plan Rows": 5,
"Plan Width": 62,
"Actual Startup Time": 0.052,
"Actual Total Time": 0.053,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34626_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34626_chunk",
"Alias": "_hyper_5_34626_chunk",
"Startup Cost": 0.56,
"Total Cost": 7.23,
"Plan Rows": 5,
"Plan Width": 63,
"Actual Startup Time": 0.043,
"Actual Total Time": 0.044,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34619_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34619_chunk",
"Alias": "_hyper_5_34619_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.20,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.062,
"Actual Total Time": 0.062,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34617_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34617_chunk",
"Alias": "_hyper_5_34617_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.19,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.038,
"Actual Total Time": 0.038,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34616_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34616_chunk",
"Alias": "_hyper_5_34616_chunk",
"Startup Cost": 0.56,
"Total Cost": 7.24,
"Plan Rows": 5,
"Plan Width": 62,
"Actual Startup Time": 0.061,
"Actual Total Time": 0.061,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34615_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34615_chunk",
"Alias": "_hyper_5_34615_chunk",
"Startup Cost": 0.56,
"Total Cost": 7.23,
"Plan Rows": 5,
"Plan Width": 63,
"Actual Startup Time": 0.055,
"Actual Total Time": 0.055,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34613_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34613_chunk",
"Alias": "_hyper_5_34613_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.20,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.076,
"Actual Total Time": 0.076,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34612_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34612_chunk",
"Alias": "_hyper_5_34612_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.19,
"Plan Rows": 4,
"Plan Width": 63,
"Actual Startup Time": 0.095,
"Actual Total Time": 0.095,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34609_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34609_chunk",
"Alias": "_hyper_5_34609_chunk",
"Startup Cost": 0.56,
"Total Cost": 7.24,
"Plan Rows": 5,
"Plan Width": 62,
"Actual Startup Time": 0.967,
"Actual Total Time": 0.968,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34606_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34606_chunk",
"Alias": "_hyper_5_34606_chunk",
"Startup Cost": 0.56,
"Total Cost": 7.23,
"Plan Rows": 5,
"Plan Width": 63,
"Actual Startup Time": 0.053,
"Actual Total Time": 0.054,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34605_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34605_chunk",
"Alias": "_hyper_5_34605_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.19,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.049,
"Actual Total Time": 0.049,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34604_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34604_chunk",
"Alias": "_hyper_5_34604_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.20,
"Plan Rows": 4,
"Plan Width": 63,
"Actual Startup Time": 0.041,
"Actual Total Time": 0.041,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34603_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34603_chunk",
"Alias": "_hyper_5_34603_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.20,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.053,
"Actual Total Time": 0.054,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34601_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34601_chunk",
"Alias": "_hyper_5_34601_chunk",
"Startup Cost": 0.56,
"Total Cost": 7.23,
"Plan Rows": 5,
"Plan Width": 62,
"Actual Startup Time": 0.050,
"Actual Total Time": 0.050,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34598_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34598_chunk",
"Alias": "_hyper_5_34598_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.19,
"Plan Rows": 4,
"Plan Width": 63,
"Actual Startup Time": 0.098,
"Actual Total Time": 0.102,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34596_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34596_chunk",
"Alias": "_hyper_5_34596_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.20,
"Plan Rows": 4,
"Plan Width": 63,
"Actual Startup Time": 0.070,
"Actual Total Time": 0.071,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34595_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34595_chunk",
"Alias": "_hyper_5_34595_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.20,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.075,
"Actual Total Time": 0.075,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34594_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34594_chunk",
"Alias": "_hyper_5_34594_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.19,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.049,
"Actual Total Time": 0.049,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34593_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34593_chunk",
"Alias": "_hyper_5_34593_chunk",
"Startup Cost": 0.56,
"Total Cost": 7.24,
"Plan Rows": 5,
"Plan Width": 62,
"Actual Startup Time": 0.063,
"Actual Total Time": 0.063,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34592_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34592_chunk",
"Alias": "_hyper_5_34592_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.17,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.064,
"Actual Total Time": 0.064,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34589_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34589_chunk",
"Alias": "_hyper_5_34589_chunk",
"Startup Cost": 0.56,
"Total Cost": 7.26,
"Plan Rows": 5,
"Plan Width": 62,
"Actual Startup Time": 0.063,
"Actual Total Time": 0.064,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34586_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34586_chunk",
"Alias": "_hyper_5_34586_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.20,
"Plan Rows": 4,
"Plan Width": 62,
"Actual Startup Time": 0.059,
"Actual Total Time": 0.060,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34585_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34585_chunk",
"Alias": "_hyper_5_34585_chunk",
"Startup Cost": 0.56,
"Total Cost": 7.23,
"Plan Rows": 5,
"Plan Width": 63,
"Actual Startup Time": 0.086,
"Actual Total Time": 0.086,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34584_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34584_chunk",
"Alias": "_hyper_5_34584_chunk",
"Startup Cost": 0.56,
"Total Cost": 6.20,
"Plan Rows": 4,
"Plan Width": 63,
"Actual Startup Time": 0.075,
"Actual Total Time": 0.076,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34583_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34583_chunk",
"Alias": "_hyper_5_34583_chunk",
"Startup Cost": 0.56,
"Total Cost": 7.26,
"Plan Rows": 5,
"Plan Width": 62,
"Actual Startup Time": 0.058,
"Actual Total Time": 0.058,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text) AND (\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Index Recheck": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34892_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34892_chunk",
"Alias": "_hyper_5_34892_chunk",
"Startup Cost": 0.15,
"Total Cost": 2.18,
"Plan Rows": 1,
"Plan Width": 124,
"Actual Startup Time": 0.011,
"Actual Total Time": 0.012,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text))",
"Rows Removed by Index Recheck": 0,
"Filter": "((\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Filter": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34895_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34895_chunk",
"Alias": "_hyper_5_34895_chunk",
"Startup Cost": 0.15,
"Total Cost": 2.18,
"Plan Rows": 1,
"Plan Width": 124,
"Actual Startup Time": 0.019,
"Actual Total Time": 0.019,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text))",
"Rows Removed by Index Recheck": 0,
"Filter": "((\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Filter": 0
},
{
"Node Type": "Index Scan",
"Parent Relationship": "Member",
"Parallel Aware": false,
"Scan Direction": "Forward",
"Index Name": "_hyper_5_34889_chunk_node_measurements_unique_idx",
"Relation Name": "_hyper_5_34889_chunk",
"Alias": "_hyper_5_34889_chunk",
"Startup Cost": 0.27,
"Total Cost": 2.29,
"Plan Rows": 1,
"Plan Width": 62,
"Actual Startup Time": 0.022,
"Actual Total Time": 0.022,
"Actual Rows": 0,
"Actual Loops": 1,
"Index Cond": "((src_mac_id = 'FFFF14B4577FE5F0'::text) AND (measurement_type = 'temperature_set'::text))",
"Rows Removed by Index Recheck": 0,
"Filter": "((\"time\" >= timezone(l.timezone, '2023-01-02 00:00:00+00'::timestamp with time zone)) AND (\"time\" <= timezone(l.timezone, '2023-01-03 23:59:59+00'::timestamp with time zone)))",
"Rows Removed by Filter": 0
}
]
}
]
}
]
}
]
}
]
}
]
},
"Planning Time": 60.039,
"Triggers": [
],
"Execution Time": 26.876
}
]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment