[ { "Plan": { "Node Type": "Limit", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 25268.59, "Total Cost": 25268.60, "Plan Rows": 4, "Plan Width": 20, "Actual Startup Time": 0.331, "Actual Total Time": 0.333, "Actual Rows": 0, "Actual Loops": 1, "Output": ["m_1.ts", "s.type", "m_1.val"], "Shared Hit Blocks": 59, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0, "Plans": [ { "Node Type": "Sort", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 25268.59, "Total Cost": 25270.70, "Plan Rows": 842, "Plan Width": 20, "Actual Startup Time": 0.330, "Actual Total Time": 0.332, "Actual Rows": 0, "Actual Loops": 1, "Output": ["m_1.ts", "s.type", "m_1.val"], "Sort Key": ["m_1.ts DESC"], "Sort Method": "quicksort", "Sort Space Used": 25, "Sort Space Type": "Memory", "Shared Hit Blocks": 59, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0, "Plans": [ { "Node Type": "Nested Loop", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Join Type": "Inner", "Startup Cost": 0.42, "Total Cost": 25255.96, "Plan Rows": 842, "Plan Width": 20, "Actual Startup Time": 0.322, "Actual Total Time": 0.324, "Actual Rows": 0, "Actual Loops": 1, "Output": ["m_1.ts", "s.type", "m_1.val"], "Inner Unique": false, "Shared Hit Blocks": 59, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0, "Plans": [ { "Node Type": "Seq Scan", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Relation Name": "measure_sensor", "Schema": "public", "Alias": "s", "Startup Cost": 0.00, "Total Cost": 5.10, "Plan Rows": 1, "Plan Width": 6, "Actual Startup Time": 0.011, "Actual Total Time": 0.022, "Actual Rows": 1, "Actual Loops": 1, "Output": ["s.id", "s.type", "s.unit", "s.model", "s.min", "s.max", "s.multiplier", "s.round", "s.created_at", "s.updated_at", "s.deleted_at"], "Filter": "(s.type = 'ca1'::text)", "Rows Removed by Filter": 167, "Shared Hit Blocks": 3, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0 }, { "Node Type": "Nested Loop", "Parent Relationship": "Inner", "Parallel Aware": false, "Async Capable": false, "Join Type": "Inner", "Startup Cost": 0.42, "Total Cost": 24918.74, "Plan Rows": 33212, "Plan Width": 18, "Actual Startup Time": 0.299, "Actual Total Time": 0.300, "Actual Rows": 0, "Actual Loops": 1, "Output": ["m_1.ts", "m_1.val", "m_1.sensor_id"], "Inner Unique": false, "Shared Hit Blocks": 56, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0, "Plans": [ { "Node Type": "Seq Scan", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Relation Name": "node", "Schema": "public", "Alias": "n", "Startup Cost": 0.00, "Total Cost": 20.61, "Plan Rows": 1, "Plan Width": 8, "Actual Startup Time": 0.078, "Actual Total Time": 0.079, "Actual Rows": 1, "Actual Loops": 1, "Output": ["n.id", "n.serial", "n.name", "n.active", "n.timezone", "n.created_at", "n.updated_at", "n.deleted_at"], "Filter": "(n.serial = 'TEST0000003'::text)", "Rows Removed by Filter": 848, "Shared Hit Blocks": 10, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0 }, { "Node Type": "Append", "Parent Relationship": "Inner", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 0.42, "Total Cost": 24566.01, "Plan Rows": 33212, "Plan Width": 26, "Actual Startup Time": 0.219, "Actual Total Time": 0.220, "Actual Rows": 0, "Actual Loops": 1, "Shared Hit Blocks": 46, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0, "Subplans Removed": 0, "Plans": [ { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_9_1252_chunk_idx_measure_node_sensor_ts", "Relation Name": "_hyper_9_1252_chunk", "Schema": "_timescaledb_internal", "Alias": "m_1", "Startup Cost": 0.42, "Total Cost": 1166.12, "Plan Rows": 1123, "Plan Width": 26, "Actual Startup Time": 0.019, "Actual Total Time": 0.019, "Actual Rows": 0, "Actual Loops": 1, "Output": ["m_1.ts", "m_1.val", "m_1.node_id", "m_1.sensor_id"], "Index Cond": "((m_1.node_id = n.id) AND (m_1.sensor_id = s.id) AND (m_1.ts <= '2025-04-01 12:51:02+00'::timestamp with time zone) AND (m_1.ts >= '2020-03-03 11:55:00+00'::timestamp with time zone))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 3, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_9_1221_chunk_idx_measure_node_sensor_ts", "Relation Name": "_hyper_9_1221_chunk", "Schema": "_timescaledb_internal", "Alias": "m_2", "Startup Cost": 0.56, "Total Cost": 423.41, "Plan Rows": 801, "Plan Width": 26, "Actual Startup Time": 0.014, "Actual Total Time": 0.014, "Actual Rows": 0, "Actual Loops": 1, "Output": ["m_2.ts", "m_2.val", "m_2.node_id", "m_2.sensor_id"], "Index Cond": "((m_2.node_id = n.id) AND (m_2.sensor_id = s.id) AND (m_2.ts <= '2025-04-01 12:51:02+00'::timestamp with time zone) AND (m_2.ts >= '2020-03-03 11:55:00+00'::timestamp with time zone))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 4, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_9_1223_chunk_idx_measure_node_sensor_ts", "Relation Name": "_hyper_9_1223_chunk", "Schema": "_timescaledb_internal", "Alias": "m_3", "Startup Cost": 0.56, "Total Cost": 898.42, "Plan Rows": 1675, "Plan Width": 26, "Actual Startup Time": 0.018, "Actual Total Time": 0.018, "Actual Rows": 0, "Actual Loops": 1, "Output": ["m_3.ts", "m_3.val", "m_3.node_id", "m_3.sensor_id"], "Index Cond": "((m_3.node_id = n.id) AND (m_3.sensor_id = s.id) AND (m_3.ts <= '2025-04-01 12:51:02+00'::timestamp with time zone) AND (m_3.ts >= '2020-03-03 11:55:00+00'::timestamp with time zone))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 4, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_9_1222_chunk_idx_measure_node_sensor_ts", "Relation Name": "_hyper_9_1222_chunk", "Schema": "_timescaledb_internal", "Alias": "m_4", "Startup Cost": 0.56, "Total Cost": 1122.90, "Plan Rows": 2084, "Plan Width": 26, "Actual Startup Time": 0.014, "Actual Total Time": 0.014, "Actual Rows": 0, "Actual Loops": 1, "Output": ["m_4.ts", "m_4.val", "m_4.node_id", "m_4.sensor_id"], "Index Cond": "((m_4.node_id = n.id) AND (m_4.sensor_id = s.id) AND (m_4.ts <= '2025-04-01 12:51:02+00'::timestamp with time zone) AND (m_4.ts >= '2020-03-03 11:55:00+00'::timestamp with time zone))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 4, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_9_1227_chunk_idx_measure_node_sensor_ts", "Relation Name": "_hyper_9_1227_chunk", "Schema": "_timescaledb_internal", "Alias": "m_5", "Startup Cost": 0.56, "Total Cost": 1117.98, "Plan Rows": 2185, "Plan Width": 26, "Actual Startup Time": 0.023, "Actual Total Time": 0.023, "Actual Rows": 0, "Actual Loops": 1, "Output": ["m_5.ts", "m_5.val", "m_5.node_id", "m_5.sensor_id"], "Index Cond": "((m_5.node_id = n.id) AND (m_5.sensor_id = s.id) AND (m_5.ts <= '2025-04-01 12:51:02+00'::timestamp with time zone) AND (m_5.ts >= '2020-03-03 11:55:00+00'::timestamp with time zone))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 4, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_9_1226_chunk_idx_measure_node_sensor_ts", "Relation Name": "_hyper_9_1226_chunk", "Schema": "_timescaledb_internal", "Alias": "m_6", "Startup Cost": 0.56, "Total Cost": 1355.83, "Plan Rows": 2662, "Plan Width": 26, "Actual Startup Time": 0.019, "Actual Total Time": 0.019, "Actual Rows": 0, "Actual Loops": 1, "Output": ["m_6.ts", "m_6.val", "m_6.node_id", "m_6.sensor_id"], "Index Cond": "((m_6.node_id = n.id) AND (m_6.sensor_id = s.id) AND (m_6.ts <= '2025-04-01 12:51:02+00'::timestamp with time zone) AND (m_6.ts >= '2020-03-03 11:55:00+00'::timestamp with time zone))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 4, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_9_1225_chunk_idx_measure_node_sensor_ts", "Relation Name": "_hyper_9_1225_chunk", "Schema": "_timescaledb_internal", "Alias": "m_7", "Startup Cost": 0.56, "Total Cost": 1001.66, "Plan Rows": 1954, "Plan Width": 26, "Actual Startup Time": 0.020, "Actual Total Time": 0.020, "Actual Rows": 0, "Actual Loops": 1, "Output": ["m_7.ts", "m_7.val", "m_7.node_id", "m_7.sensor_id"], "Index Cond": "((m_7.node_id = n.id) AND (m_7.sensor_id = s.id) AND (m_7.ts <= '2025-04-01 12:51:02+00'::timestamp with time zone) AND (m_7.ts >= '2020-03-03 11:55:00+00'::timestamp with time zone))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 4, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_9_1224_chunk_idx_measure_node_sensor_ts", "Relation Name": "_hyper_9_1224_chunk", "Schema": "_timescaledb_internal", "Alias": "m_8", "Startup Cost": 0.56, "Total Cost": 892.68, "Plan Rows": 1708, "Plan Width": 26, "Actual Startup Time": 0.016, "Actual Total Time": 0.016, "Actual Rows": 0, "Actual Loops": 1, "Output": ["m_8.ts", "m_8.val", "m_8.node_id", "m_8.sensor_id"], "Index Cond": "((m_8.node_id = n.id) AND (m_8.sensor_id = s.id) AND (m_8.ts <= '2025-04-01 12:51:02+00'::timestamp with time zone) AND (m_8.ts >= '2020-03-03 11:55:00+00'::timestamp with time zone))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 4, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_9_1228_chunk_idx_measure_node_sensor_ts", "Relation Name": "_hyper_9_1228_chunk", "Schema": "_timescaledb_internal", "Alias": "m_9", "Startup Cost": 0.56, "Total Cost": 1443.88, "Plan Rows": 2635, "Plan Width": 26, "Actual Startup Time": 0.021, "Actual Total Time": 0.021, "Actual Rows": 0, "Actual Loops": 1, "Output": ["m_9.ts", "m_9.val", "m_9.node_id", "m_9.sensor_id"], "Index Cond": "((m_9.node_id = n.id) AND (m_9.sensor_id = s.id) AND (m_9.ts <= '2025-04-01 12:51:02+00'::timestamp with time zone) AND (m_9.ts >= '2020-03-03 11:55:00+00'::timestamp with time zone))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 4, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_9_1235_chunk_idx_measure_node_sensor_ts", "Relation Name": "_hyper_9_1235_chunk", "Schema": "_timescaledb_internal", "Alias": "m_10", "Startup Cost": 0.56, "Total Cost": 1260.54, "Plan Rows": 2034, "Plan Width": 26, "Actual Startup Time": 0.024, "Actual Total Time": 0.024, "Actual Rows": 0, "Actual Loops": 1, "Output": ["m_10.ts", "m_10.val", "m_10.node_id", "m_10.sensor_id"], "Index Cond": "((m_10.node_id = n.id) AND (m_10.sensor_id = s.id) AND (m_10.ts <= '2025-04-01 12:51:02+00'::timestamp with time zone) AND (m_10.ts >= '2020-03-03 11:55:00+00'::timestamp with time zone))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 4, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0 }, { "Node Type": "Index Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Scan Direction": "Forward", "Index Name": "_hyper_9_1230_chunk_idx_measure_node_sensor_ts", "Relation Name": "_hyper_9_1230_chunk", "Schema": "_timescaledb_internal", "Alias": "m_11", "Startup Cost": 0.56, "Total Cost": 11318.52, "Plan Rows": 12101, "Plan Width": 26, "Actual Startup Time": 0.012, "Actual Total Time": 0.012, "Actual Rows": 0, "Actual Loops": 1, "Output": ["m_11.ts", "m_11.val", "m_11.node_id", "m_11.sensor_id"], "Index Cond": "((m_11.node_id = n.id) AND (m_11.sensor_id = s.id) AND (m_11.ts <= '2025-04-01 12:51:02+00'::timestamp with time zone) AND (m_11.ts >= '2020-03-03 11:55:00+00'::timestamp with time zone))", "Rows Removed by Index Recheck": 0, "Shared Hit Blocks": 4, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0 }, { "Node Type": "Bitmap Heap Scan", "Parent Relationship": "Member", "Parallel Aware": false, "Async Capable": false, "Relation Name": "_hyper_9_1231_chunk", "Schema": "_timescaledb_internal", "Alias": "m_12", "Startup Cost": 47.94, "Total Cost": 2398.02, "Plan Rows": 2250, "Plan Width": 26, "Actual Startup Time": 0.013, "Actual Total Time": 0.013, "Actual Rows": 0, "Actual Loops": 1, "Output": ["m_12.ts", "m_12.val", "m_12.node_id", "m_12.sensor_id"], "Recheck Cond": "((m_12.node_id = n.id) AND (m_12.sensor_id = s.id) AND (m_12.ts <= '2025-04-01 12:51:02+00'::timestamp with time zone) AND (m_12.ts >= '2020-03-03 11:55:00+00'::timestamp with time zone))", "Rows Removed by Index Recheck": 0, "Exact Heap Blocks": 0, "Lossy Heap Blocks": 0, "Shared Hit Blocks": 3, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0, "Plans": [ { "Node Type": "Bitmap Index Scan", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Index Name": "_hyper_9_1231_chunk_idx_measure_node_sensor_ts", "Startup Cost": 0.00, "Total Cost": 47.38, "Plan Rows": 2250, "Plan Width": 0, "Actual Startup Time": 0.011, "Actual Total Time": 0.011, "Actual Rows": 0, "Actual Loops": 1, "Index Cond": "((m_12.node_id = n.id) AND (m_12.sensor_id = s.id) AND (m_12.ts <= '2025-04-01 12:51:02+00'::timestamp with time zone) AND (m_12.ts >= '2020-03-03 11:55:00+00'::timestamp with time zone))", "Shared Hit Blocks": 3, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0, "WAL Records": 0, "WAL FPI": 0, "WAL Bytes": 0 } ] } ] } ] } ] } ] } ] }, "Settings": { "effective_io_concurrency": "256", "random_page_cost": "1.1", "jit": "off", "effective_cache_size": "38400MB", "work_mem": "10922kB", "max_parallel_workers_per_gather": "4", "max_parallel_workers": "14" }, "Query Identifier": 1475796811927846356, "Planning": { "Shared Hit Blocks": 300, "Shared Read Blocks": 0, "Shared Dirtied Blocks": 0, "Shared Written Blocks": 0, "Local Hit Blocks": 0, "Local Read Blocks": 0, "Local Dirtied Blocks": 0, "Local Written Blocks": 0, "Temp Read Blocks": 0, "Temp Written Blocks": 0 }, "Planning Time": 2.129, "Triggers": [ ], "Execution Time": 0.466 } ]