VACUUM QUERY PLAN ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [ + { + "Plan": { + "Node Type": "Limit", + "Parallel Aware": false, + "Async Capable": false, + "Startup Cost": 19872026.53, + "Total Cost": 19872029.03, + "Plan Rows": 1001, + "Plan Width": 600, + "Actual Startup Time": 340609.577, + "Actual Total Time": 340610.006, + "Actual Rows": 1001, + "Actual Loops": 1, + "Output": ["a_31.auditid", "a_31.userid", "a_31.username", "a_31.clock", "a_31.action", "a_31.resourcetype", "a_31.ip", "a_31.resourceid", "a_31.resourcename", "a_31.details", "a_31.recordsetid"], + "Shared Hit Blocks": 201815, + "Shared Read Blocks": 18871735, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 74, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 296814.097, + "I/O Write Time": 59.441, + "Plans": [ + { + "Node Type": "Sort", + "Parent Relationship": "Outer", + "Parallel Aware": false, + "Async Capable": false, + "Startup Cost": 19872026.53, + "Total Cost": 19875389.61, + "Plan Rows": 1345231, + "Plan Width": 600, + "Actual Startup Time": 338308.591, + "Actual Total Time": 338308.943, + "Actual Rows": 1001, + "Actual Loops": 1, + "Output": ["a_31.auditid", "a_31.userid", "a_31.username", "a_31.clock", "a_31.action", "a_31.resourcetype", "a_31.ip", "a_31.resourceid", "a_31.resourcename", "a_31.details", "a_31.recordsetid"], + "Sort Key": ["a_31.auditid DESC"], + "Sort Method": "quicksort", + "Sort Space Used": 1153, + "Sort Space Type": "Memory", + "Shared Hit Blocks": 201815, + "Shared Read Blocks": 18871735, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 74, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 296814.097, + "I/O Write Time": 59.441, + "Plans": [ + { + "Node Type": "Gather", + "Parent Relationship": "Outer", + "Parallel Aware": false, + "Async Capable": false, + "Startup Cost": 93571.10, + "Total Cost": 19798259.27, + "Plan Rows": 1345231, + "Plan Width": 600, + "Actual Startup Time": 10.788, + "Actual Total Time": 338307.445, + "Actual Rows": 1224, + "Actual Loops": 1, + "Output": ["a_31.auditid", "a_31.userid", "a_31.username", "a_31.clock", "a_31.action", "a_31.resourcetype", "a_31.ip", "a_31.resourceid", "a_31.resourcename", "a_31.details", "a_31.recordsetid"], + "Workers Planned": 4, + "Workers Launched": 0, + "Single Copy": false, + "Shared Hit Blocks": 201815, + "Shared Read Blocks": 18871735, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 74, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 296814.097, + "I/O Write Time": 59.441, + "Plans": [ + { + "Node Type": "Append", + "Parent Relationship": "Outer", + "Parallel Aware": true, + "Async Capable": false, + "Startup Cost": 92571.10, + "Total Cost": 19662736.17, + "Plan Rows": 346508, + "Plan Width": 599, + "Actual Startup Time": 4.515, + "Actual Total Time": 338300.887, + "Actual Rows": 1224, + "Actual Loops": 1, + "Shared Hit Blocks": 201815, + "Shared Read Blocks": 18871735, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 74, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 296814.097, + "I/O Write Time": 59.441, + "Workers": [ + { + "Worker Number": 0 + }, + { + "Worker Number": 1 + }, + { + "Worker Number": 2 + }, + { + "Worker Number": 3 + } + ], + "Subplans Removed": 0, + "Plans": [ + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6903_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_31", + "Startup Cost": 96806.88, + "Total Cost": 96806.88, + "Plan Rows": 1000, + "Plan Width": 1026, + "Actual Startup Time": 1679.967, + "Actual Total Time": 1679.969, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_31.auditid", "a_31.userid", "a_31.username", "a_31.clock", "a_31.action", "a_31.resourcetype", "a_31.ip", "a_31.resourceid", "a_31.resourcename", "a_31.details", "a_31.recordsetid"], + "Vectorized Filter": "((a_31.clock >= 1735654733) AND (a_31.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 93751, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 1449.691, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_7033_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_7033_chunk", + "Startup Cost": 0.00, + "Total Cost": 96806.88, + "Plan Rows": 1, + "Plan Width": 357, + "Actual Startup Time": 1679.964, + "Actual Total Time": 1679.965, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_7033_chunk._ts_meta_count", "compress_hyper_18_7033_chunk._ts_meta_sequence_num", "compress_hyper_18_7033_chunk.auditid", "compress_hyper_18_7033_chunk._ts_meta_v2_min_userid", "compress_hyper_18_7033_chunk._ts_meta_v2_max_userid", "compress_hyper_18_7033_chunk.userid", "compress_hyper_18_7033_chunk.username", "compress_hyper_18_7033_chunk._ts_meta_min_1", "compress_hyper_18_7033_chunk._ts_meta_max_1", "compress_hyper_18_7033_chunk.clock", "compress_hyper_18_7033_chunk._ts_meta_v2_min_ip", "compress_hyper_18_7033_chunk._ts_meta_v2_max_ip", "compress_hyper_18_7033_chunk.ip", "compress_hyper_18_7033_chunk.action", "compress_hyper_18_7033_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_7033_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_7033_chunk.resourcetype", "compress_hyper_18_7033_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_7033_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_7033_chunk.resourceid", "compress_hyper_18_7033_chunk.resource_cuid", "compress_hyper_18_7033_chunk.resourcename", "compress_hyper_18_7033_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_7033_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_7033_chunk.recordsetid", "compress_hyper_18_7033_chunk.details"],+ "Filter": "((compress_hyper_18_7033_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_7033_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 814902, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 93751, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 1449.691, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6909_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_27", + "Startup Cost": 93156.24, + "Total Cost": 93156.24, + "Plan Rows": 1000, + "Plan Width": 1026, + "Actual Startup Time": 1579.520, + "Actual Total Time": 1579.521, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_27.auditid", "a_27.userid", "a_27.username", "a_27.clock", "a_27.action", "a_27.resourcetype", "a_27.ip", "a_27.resourceid", "a_27.resourcename", "a_27.details", "a_27.recordsetid"], + "Vectorized Filter": "((a_27.clock >= 1735654733) AND (a_27.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 90170, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 1356.505, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_7039_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_7039_chunk", + "Startup Cost": 0.00, + "Total Cost": 93156.24, + "Plan Rows": 1, + "Plan Width": 357, + "Actual Startup Time": 1579.518, + "Actual Total Time": 1579.518, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_7039_chunk._ts_meta_count", "compress_hyper_18_7039_chunk._ts_meta_sequence_num", "compress_hyper_18_7039_chunk.auditid", "compress_hyper_18_7039_chunk._ts_meta_v2_min_userid", "compress_hyper_18_7039_chunk._ts_meta_v2_max_userid", "compress_hyper_18_7039_chunk.userid", "compress_hyper_18_7039_chunk.username", "compress_hyper_18_7039_chunk._ts_meta_min_1", "compress_hyper_18_7039_chunk._ts_meta_max_1", "compress_hyper_18_7039_chunk.clock", "compress_hyper_18_7039_chunk._ts_meta_v2_min_ip", "compress_hyper_18_7039_chunk._ts_meta_v2_max_ip", "compress_hyper_18_7039_chunk.ip", "compress_hyper_18_7039_chunk.action", "compress_hyper_18_7039_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_7039_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_7039_chunk.resourcetype", "compress_hyper_18_7039_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_7039_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_7039_chunk.resourceid", "compress_hyper_18_7039_chunk.resource_cuid", "compress_hyper_18_7039_chunk.resourcename", "compress_hyper_18_7039_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_7039_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_7039_chunk.recordsetid", "compress_hyper_18_7039_chunk.details"],+ "Filter": "((compress_hyper_18_7039_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_7039_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 796332, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 90170, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 1356.505, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6905_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_30", + "Startup Cost": 92902.76, + "Total Cost": 92902.76, + "Plan Rows": 1000, + "Plan Width": 1026, + "Actual Startup Time": 1593.050, + "Actual Total Time": 1593.051, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_30.auditid", "a_30.userid", "a_30.username", "a_30.clock", "a_30.action", "a_30.resourcetype", "a_30.ip", "a_30.resourceid", "a_30.resourcename", "a_30.details", "a_30.recordsetid"], + "Vectorized Filter": "((a_30.clock >= 1735654733) AND (a_30.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 90020, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 1394.645, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_7035_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_7035_chunk", + "Startup Cost": 0.00, + "Total Cost": 92902.76, + "Plan Rows": 1, + "Plan Width": 357, + "Actual Startup Time": 1593.048, + "Actual Total Time": 1593.048, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_7035_chunk._ts_meta_count", "compress_hyper_18_7035_chunk._ts_meta_sequence_num", "compress_hyper_18_7035_chunk.auditid", "compress_hyper_18_7035_chunk._ts_meta_v2_min_userid", "compress_hyper_18_7035_chunk._ts_meta_v2_max_userid", "compress_hyper_18_7035_chunk.userid", "compress_hyper_18_7035_chunk.username", "compress_hyper_18_7035_chunk._ts_meta_min_1", "compress_hyper_18_7035_chunk._ts_meta_max_1", "compress_hyper_18_7035_chunk.clock", "compress_hyper_18_7035_chunk._ts_meta_v2_min_ip", "compress_hyper_18_7035_chunk._ts_meta_v2_max_ip", "compress_hyper_18_7035_chunk.ip", "compress_hyper_18_7035_chunk.action", "compress_hyper_18_7035_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_7035_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_7035_chunk.resourcetype", "compress_hyper_18_7035_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_7035_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_7035_chunk.resourceid", "compress_hyper_18_7035_chunk.resource_cuid", "compress_hyper_18_7035_chunk.resourcename", "compress_hyper_18_7035_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_7035_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_7035_chunk.recordsetid", "compress_hyper_18_7035_chunk.details"],+ "Filter": "((compress_hyper_18_7035_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_7035_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 768735, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 90020, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 1394.645, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6894_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_38", + "Startup Cost": 92571.10, + "Total Cost": 92571.10, + "Plan Rows": 1000, + "Plan Width": 1026, + "Actual Startup Time": 1672.932, + "Actual Total Time": 1672.933, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_38.auditid", "a_38.userid", "a_38.username", "a_38.clock", "a_38.action", "a_38.resourcetype", "a_38.ip", "a_38.resourceid", "a_38.resourcename", "a_38.details", "a_38.recordsetid"], + "Vectorized Filter": "((a_38.clock >= 1735654733) AND (a_38.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 89625, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 1453.882, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_7024_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_7024_chunk", + "Startup Cost": 0.00, + "Total Cost": 92571.10, + "Plan Rows": 1, + "Plan Width": 357, + "Actual Startup Time": 1672.929, + "Actual Total Time": 1672.929, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_7024_chunk._ts_meta_count", "compress_hyper_18_7024_chunk._ts_meta_sequence_num", "compress_hyper_18_7024_chunk.auditid", "compress_hyper_18_7024_chunk._ts_meta_v2_min_userid", "compress_hyper_18_7024_chunk._ts_meta_v2_max_userid", "compress_hyper_18_7024_chunk.userid", "compress_hyper_18_7024_chunk.username", "compress_hyper_18_7024_chunk._ts_meta_min_1", "compress_hyper_18_7024_chunk._ts_meta_max_1", "compress_hyper_18_7024_chunk.clock", "compress_hyper_18_7024_chunk._ts_meta_v2_min_ip", "compress_hyper_18_7024_chunk._ts_meta_v2_max_ip", "compress_hyper_18_7024_chunk.ip", "compress_hyper_18_7024_chunk.action", "compress_hyper_18_7024_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_7024_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_7024_chunk.resourcetype", "compress_hyper_18_7024_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_7024_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_7024_chunk.resourceid", "compress_hyper_18_7024_chunk.resource_cuid", "compress_hyper_18_7024_chunk.resourcename", "compress_hyper_18_7024_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_7024_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_7024_chunk.recordsetid", "compress_hyper_18_7024_chunk.details"],+ "Filter": "((compress_hyper_18_7024_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_7024_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 785627, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 89625, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 1453.882, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6886_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_41", + "Startup Cost": 91763.00, + "Total Cost": 91763.00, + "Plan Rows": 1000, + "Plan Width": 1026, + "Actual Startup Time": 1606.517, + "Actual Total Time": 1606.518, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_41.auditid", "a_41.userid", "a_41.username", "a_41.clock", "a_41.action", "a_41.resourcetype", "a_41.ip", "a_41.resourceid", "a_41.resourcename", "a_41.details", "a_41.recordsetid"], + "Vectorized Filter": "((a_41.clock >= 1735654733) AND (a_41.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 88880, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 1398.183, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_7016_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_7016_chunk", + "Startup Cost": 0.00, + "Total Cost": 91763.00, + "Plan Rows": 1, + "Plan Width": 357, + "Actual Startup Time": 1606.514, + "Actual Total Time": 1606.514, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_7016_chunk._ts_meta_count", "compress_hyper_18_7016_chunk._ts_meta_sequence_num", "compress_hyper_18_7016_chunk.auditid", "compress_hyper_18_7016_chunk._ts_meta_v2_min_userid", "compress_hyper_18_7016_chunk._ts_meta_v2_max_userid", "compress_hyper_18_7016_chunk.userid", "compress_hyper_18_7016_chunk.username", "compress_hyper_18_7016_chunk._ts_meta_min_1", "compress_hyper_18_7016_chunk._ts_meta_max_1", "compress_hyper_18_7016_chunk.clock", "compress_hyper_18_7016_chunk._ts_meta_v2_min_ip", "compress_hyper_18_7016_chunk._ts_meta_v2_max_ip", "compress_hyper_18_7016_chunk.ip", "compress_hyper_18_7016_chunk.action", "compress_hyper_18_7016_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_7016_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_7016_chunk.resourcetype", "compress_hyper_18_7016_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_7016_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_7016_chunk.resourceid", "compress_hyper_18_7016_chunk.resource_cuid", "compress_hyper_18_7016_chunk.resourcename", "compress_hyper_18_7016_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_7016_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_7016_chunk.recordsetid", "compress_hyper_18_7016_chunk.details"],+ "Filter": "((compress_hyper_18_7016_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_7016_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 768799, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 88880, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 1398.183, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6896_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_37", + "Startup Cost": 91013.72, + "Total Cost": 91013.72, + "Plan Rows": 1000, + "Plan Width": 1026, + "Actual Startup Time": 1554.992, + "Actual Total Time": 1554.993, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_37.auditid", "a_37.userid", "a_37.username", "a_37.clock", "a_37.action", "a_37.resourcetype", "a_37.ip", "a_37.resourceid", "a_37.resourcename", "a_37.details", "a_37.recordsetid"], + "Vectorized Filter": "((a_37.clock >= 1735654733) AND (a_37.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 88121, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 1364.877, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_7026_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_7026_chunk", + "Startup Cost": 0.00, + "Total Cost": 91013.72, + "Plan Rows": 1, + "Plan Width": 357, + "Actual Startup Time": 1554.989, + "Actual Total Time": 1554.989, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_7026_chunk._ts_meta_count", "compress_hyper_18_7026_chunk._ts_meta_sequence_num", "compress_hyper_18_7026_chunk.auditid", "compress_hyper_18_7026_chunk._ts_meta_v2_min_userid", "compress_hyper_18_7026_chunk._ts_meta_v2_max_userid", "compress_hyper_18_7026_chunk.userid", "compress_hyper_18_7026_chunk.username", "compress_hyper_18_7026_chunk._ts_meta_min_1", "compress_hyper_18_7026_chunk._ts_meta_max_1", "compress_hyper_18_7026_chunk.clock", "compress_hyper_18_7026_chunk._ts_meta_v2_min_ip", "compress_hyper_18_7026_chunk._ts_meta_v2_max_ip", "compress_hyper_18_7026_chunk.ip", "compress_hyper_18_7026_chunk.action", "compress_hyper_18_7026_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_7026_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_7026_chunk.resourcetype", "compress_hyper_18_7026_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_7026_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_7026_chunk.resourceid", "compress_hyper_18_7026_chunk.resource_cuid", "compress_hyper_18_7026_chunk.resourcename", "compress_hyper_18_7026_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_7026_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_7026_chunk.recordsetid", "compress_hyper_18_7026_chunk.details"],+ "Filter": "((compress_hyper_18_7026_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_7026_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 771392, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 88121, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 1364.877, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6889_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_40", + "Startup Cost": 90423.71, + "Total Cost": 90423.71, + "Plan Rows": 1000, + "Plan Width": 1026, + "Actual Startup Time": 1576.912, + "Actual Total Time": 1576.912, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_40.auditid", "a_40.userid", "a_40.username", "a_40.clock", "a_40.action", "a_40.resourcetype", "a_40.ip", "a_40.resourceid", "a_40.resourcename", "a_40.details", "a_40.recordsetid"], + "Vectorized Filter": "((a_40.clock >= 1735654733) AND (a_40.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 87544, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 74, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 1330.774, + "I/O Write Time": 59.441, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_7019_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_7019_chunk", + "Startup Cost": 0.00, + "Total Cost": 90423.71, + "Plan Rows": 1, + "Plan Width": 357, + "Actual Startup Time": 1576.909, + "Actual Total Time": 1576.909, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_7019_chunk._ts_meta_count", "compress_hyper_18_7019_chunk._ts_meta_sequence_num", "compress_hyper_18_7019_chunk.auditid", "compress_hyper_18_7019_chunk._ts_meta_v2_min_userid", "compress_hyper_18_7019_chunk._ts_meta_v2_max_userid", "compress_hyper_18_7019_chunk.userid", "compress_hyper_18_7019_chunk.username", "compress_hyper_18_7019_chunk._ts_meta_min_1", "compress_hyper_18_7019_chunk._ts_meta_max_1", "compress_hyper_18_7019_chunk.clock", "compress_hyper_18_7019_chunk._ts_meta_v2_min_ip", "compress_hyper_18_7019_chunk._ts_meta_v2_max_ip", "compress_hyper_18_7019_chunk.ip", "compress_hyper_18_7019_chunk.action", "compress_hyper_18_7019_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_7019_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_7019_chunk.resourcetype", "compress_hyper_18_7019_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_7019_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_7019_chunk.resourceid", "compress_hyper_18_7019_chunk.resource_cuid", "compress_hyper_18_7019_chunk.resourcename", "compress_hyper_18_7019_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_7019_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_7019_chunk.recordsetid", "compress_hyper_18_7019_chunk.details"],+ "Filter": "((compress_hyper_18_7019_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_7019_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 767922, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 87544, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 74, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 1330.774, + "I/O Write Time": 59.441, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6892_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_39", + "Startup Cost": 90338.13, + "Total Cost": 90338.13, + "Plan Rows": 1000, + "Plan Width": 1026, + "Actual Startup Time": 1577.117, + "Actual Total Time": 1577.118, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_39.auditid", "a_39.userid", "a_39.username", "a_39.clock", "a_39.action", "a_39.resourcetype", "a_39.ip", "a_39.resourceid", "a_39.resourcename", "a_39.details", "a_39.recordsetid"], + "Vectorized Filter": "((a_39.clock >= 1735654733) AND (a_39.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 87456, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 1384.562, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_7022_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_7022_chunk", + "Startup Cost": 0.00, + "Total Cost": 90338.13, + "Plan Rows": 1, + "Plan Width": 357, + "Actual Startup Time": 1577.114, + "Actual Total Time": 1577.114, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_7022_chunk._ts_meta_count", "compress_hyper_18_7022_chunk._ts_meta_sequence_num", "compress_hyper_18_7022_chunk.auditid", "compress_hyper_18_7022_chunk._ts_meta_v2_min_userid", "compress_hyper_18_7022_chunk._ts_meta_v2_max_userid", "compress_hyper_18_7022_chunk.userid", "compress_hyper_18_7022_chunk.username", "compress_hyper_18_7022_chunk._ts_meta_min_1", "compress_hyper_18_7022_chunk._ts_meta_max_1", "compress_hyper_18_7022_chunk.clock", "compress_hyper_18_7022_chunk._ts_meta_v2_min_ip", "compress_hyper_18_7022_chunk._ts_meta_v2_max_ip", "compress_hyper_18_7022_chunk.ip", "compress_hyper_18_7022_chunk.action", "compress_hyper_18_7022_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_7022_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_7022_chunk.resourcetype", "compress_hyper_18_7022_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_7022_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_7022_chunk.resourceid", "compress_hyper_18_7022_chunk.resource_cuid", "compress_hyper_18_7022_chunk.resourcename", "compress_hyper_18_7022_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_7022_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_7022_chunk.recordsetid", "compress_hyper_18_7022_chunk.details"],+ "Filter": "((compress_hyper_18_7022_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_7022_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 768568, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 87456, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 1384.562, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6890_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_33", + "Startup Cost": 90035.41, + "Total Cost": 90035.41, + "Plan Rows": 1000, + "Plan Width": 1026, + "Actual Startup Time": 1571.289, + "Actual Total Time": 1571.290, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_33.auditid", "a_33.userid", "a_33.username", "a_33.clock", "a_33.action", "a_33.resourcetype", "a_33.ip", "a_33.resourceid", "a_33.resourcename", "a_33.details", "a_33.recordsetid"], + "Vectorized Filter": "((a_33.clock >= 1735654733) AND (a_33.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 87196, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 1377.305, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_7020_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_7020_chunk", + "Startup Cost": 0.00, + "Total Cost": 90035.41, + "Plan Rows": 1, + "Plan Width": 357, + "Actual Startup Time": 1571.287, + "Actual Total Time": 1571.287, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_7020_chunk._ts_meta_count", "compress_hyper_18_7020_chunk._ts_meta_sequence_num", "compress_hyper_18_7020_chunk.auditid", "compress_hyper_18_7020_chunk._ts_meta_v2_min_userid", "compress_hyper_18_7020_chunk._ts_meta_v2_max_userid", "compress_hyper_18_7020_chunk.userid", "compress_hyper_18_7020_chunk.username", "compress_hyper_18_7020_chunk._ts_meta_min_1", "compress_hyper_18_7020_chunk._ts_meta_max_1", "compress_hyper_18_7020_chunk.clock", "compress_hyper_18_7020_chunk._ts_meta_v2_min_ip", "compress_hyper_18_7020_chunk._ts_meta_v2_max_ip", "compress_hyper_18_7020_chunk.ip", "compress_hyper_18_7020_chunk.action", "compress_hyper_18_7020_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_7020_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_7020_chunk.resourcetype", "compress_hyper_18_7020_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_7020_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_7020_chunk.resourceid", "compress_hyper_18_7020_chunk.resource_cuid", "compress_hyper_18_7020_chunk.resourcename", "compress_hyper_18_7020_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_7020_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_7020_chunk.recordsetid", "compress_hyper_18_7020_chunk.details"],+ "Filter": "((compress_hyper_18_7020_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_7020_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 757177, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 87196, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 1377.305, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6897_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_36", + "Startup Cost": 89137.10, + "Total Cost": 89137.10, + "Plan Rows": 1000, + "Plan Width": 1026, + "Actual Startup Time": 1548.106, + "Actual Total Time": 1548.108, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_36.auditid", "a_36.userid", "a_36.username", "a_36.clock", "a_36.action", "a_36.resourcetype", "a_36.ip", "a_36.resourceid", "a_36.resourcename", "a_36.details", "a_36.recordsetid"], + "Vectorized Filter": "((a_36.clock >= 1735654733) AND (a_36.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 86290, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 1363.806, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_7027_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_7027_chunk", + "Startup Cost": 0.00, + "Total Cost": 89137.10, + "Plan Rows": 1, + "Plan Width": 357, + "Actual Startup Time": 1548.104, + "Actual Total Time": 1548.104, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_7027_chunk._ts_meta_count", "compress_hyper_18_7027_chunk._ts_meta_sequence_num", "compress_hyper_18_7027_chunk.auditid", "compress_hyper_18_7027_chunk._ts_meta_v2_min_userid", "compress_hyper_18_7027_chunk._ts_meta_v2_max_userid", "compress_hyper_18_7027_chunk.userid", "compress_hyper_18_7027_chunk.username", "compress_hyper_18_7027_chunk._ts_meta_min_1", "compress_hyper_18_7027_chunk._ts_meta_max_1", "compress_hyper_18_7027_chunk.clock", "compress_hyper_18_7027_chunk._ts_meta_v2_min_ip", "compress_hyper_18_7027_chunk._ts_meta_v2_max_ip", "compress_hyper_18_7027_chunk.ip", "compress_hyper_18_7027_chunk.action", "compress_hyper_18_7027_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_7027_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_7027_chunk.resourcetype", "compress_hyper_18_7027_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_7027_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_7027_chunk.resourceid", "compress_hyper_18_7027_chunk.resource_cuid", "compress_hyper_18_7027_chunk.resourcename", "compress_hyper_18_7027_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_7027_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_7027_chunk.recordsetid", "compress_hyper_18_7027_chunk.details"],+ "Filter": "((compress_hyper_18_7027_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_7027_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 759226, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 86290, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 1363.806, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6902_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_32", + "Startup Cost": 89133.67, + "Total Cost": 89133.67, + "Plan Rows": 1000, + "Plan Width": 1026, + "Actual Startup Time": 1555.906, + "Actual Total Time": 1555.907, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_32.auditid", "a_32.userid", "a_32.username", "a_32.clock", "a_32.action", "a_32.resourcetype", "a_32.ip", "a_32.resourceid", "a_32.resourcename", "a_32.details", "a_32.recordsetid"], + "Vectorized Filter": "((a_32.clock >= 1735654733) AND (a_32.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 86304, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 1359.497, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_7032_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_7032_chunk", + "Startup Cost": 0.00, + "Total Cost": 89133.67, + "Plan Rows": 1, + "Plan Width": 357, + "Actual Startup Time": 1555.904, + "Actual Total Time": 1555.904, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_7032_chunk._ts_meta_count", "compress_hyper_18_7032_chunk._ts_meta_sequence_num", "compress_hyper_18_7032_chunk.auditid", "compress_hyper_18_7032_chunk._ts_meta_v2_min_userid", "compress_hyper_18_7032_chunk._ts_meta_v2_max_userid", "compress_hyper_18_7032_chunk.userid", "compress_hyper_18_7032_chunk.username", "compress_hyper_18_7032_chunk._ts_meta_min_1", "compress_hyper_18_7032_chunk._ts_meta_max_1", "compress_hyper_18_7032_chunk.clock", "compress_hyper_18_7032_chunk._ts_meta_v2_min_ip", "compress_hyper_18_7032_chunk._ts_meta_v2_max_ip", "compress_hyper_18_7032_chunk.ip", "compress_hyper_18_7032_chunk.action", "compress_hyper_18_7032_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_7032_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_7032_chunk.resourcetype", "compress_hyper_18_7032_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_7032_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_7032_chunk.resourceid", "compress_hyper_18_7032_chunk.resource_cuid", "compress_hyper_18_7032_chunk.resourcename", "compress_hyper_18_7032_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_7032_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_7032_chunk.recordsetid", "compress_hyper_18_7032_chunk.details"],+ "Filter": "((compress_hyper_18_7032_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_7032_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 754578, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 86304, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 1359.497, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6904_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_26", + "Startup Cost": 89044.83, + "Total Cost": 89044.83, + "Plan Rows": 1000, + "Plan Width": 1026, + "Actual Startup Time": 1554.717, + "Actual Total Time": 1554.718, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_26.auditid", "a_26.userid", "a_26.username", "a_26.clock", "a_26.action", "a_26.resourcetype", "a_26.ip", "a_26.resourceid", "a_26.resourcename", "a_26.details", "a_26.recordsetid"], + "Vectorized Filter": "((a_26.clock >= 1735654733) AND (a_26.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 86244, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 1365.013, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_7034_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_7034_chunk", + "Startup Cost": 0.00, + "Total Cost": 89044.83, + "Plan Rows": 1, + "Plan Width": 357, + "Actual Startup Time": 1554.714, + "Actual Total Time": 1554.714, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_7034_chunk._ts_meta_count", "compress_hyper_18_7034_chunk._ts_meta_sequence_num", "compress_hyper_18_7034_chunk.auditid", "compress_hyper_18_7034_chunk._ts_meta_v2_min_userid", "compress_hyper_18_7034_chunk._ts_meta_v2_max_userid", "compress_hyper_18_7034_chunk.userid", "compress_hyper_18_7034_chunk.username", "compress_hyper_18_7034_chunk._ts_meta_min_1", "compress_hyper_18_7034_chunk._ts_meta_max_1", "compress_hyper_18_7034_chunk.clock", "compress_hyper_18_7034_chunk._ts_meta_v2_min_ip", "compress_hyper_18_7034_chunk._ts_meta_v2_max_ip", "compress_hyper_18_7034_chunk.ip", "compress_hyper_18_7034_chunk.action", "compress_hyper_18_7034_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_7034_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_7034_chunk.resourcetype", "compress_hyper_18_7034_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_7034_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_7034_chunk.resourceid", "compress_hyper_18_7034_chunk.resource_cuid", "compress_hyper_18_7034_chunk.resourcename", "compress_hyper_18_7034_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_7034_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_7034_chunk.recordsetid", "compress_hyper_18_7034_chunk.details"],+ "Filter": "((compress_hyper_18_7034_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_7034_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 746887, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 86244, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 1365.013, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6907_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_29", + "Startup Cost": 88879.05, + "Total Cost": 88879.05, + "Plan Rows": 1000, + "Plan Width": 1026, + "Actual Startup Time": 1635.187, + "Actual Total Time": 1635.188, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_29.auditid", "a_29.userid", "a_29.username", "a_29.clock", "a_29.action", "a_29.resourcetype", "a_29.ip", "a_29.resourceid", "a_29.resourcename", "a_29.details", "a_29.recordsetid"], + "Vectorized Filter": "((a_29.clock >= 1735654733) AND (a_29.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 86213, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 1433.901, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_7037_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_7037_chunk", + "Startup Cost": 0.00, + "Total Cost": 88879.05, + "Plan Rows": 1, + "Plan Width": 357, + "Actual Startup Time": 1635.184, + "Actual Total Time": 1635.184, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_7037_chunk._ts_meta_count", "compress_hyper_18_7037_chunk._ts_meta_sequence_num", "compress_hyper_18_7037_chunk.auditid", "compress_hyper_18_7037_chunk._ts_meta_v2_min_userid", "compress_hyper_18_7037_chunk._ts_meta_v2_max_userid", "compress_hyper_18_7037_chunk.userid", "compress_hyper_18_7037_chunk.username", "compress_hyper_18_7037_chunk._ts_meta_min_1", "compress_hyper_18_7037_chunk._ts_meta_max_1", "compress_hyper_18_7037_chunk.clock", "compress_hyper_18_7037_chunk._ts_meta_v2_min_ip", "compress_hyper_18_7037_chunk._ts_meta_v2_max_ip", "compress_hyper_18_7037_chunk.ip", "compress_hyper_18_7037_chunk.action", "compress_hyper_18_7037_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_7037_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_7037_chunk.resourcetype", "compress_hyper_18_7037_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_7037_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_7037_chunk.resourceid", "compress_hyper_18_7037_chunk.resource_cuid", "compress_hyper_18_7037_chunk.resourcename", "compress_hyper_18_7037_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_7037_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_7037_chunk.recordsetid", "compress_hyper_18_7037_chunk.details"],+ "Filter": "((compress_hyper_18_7037_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_7037_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 710947, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 86213, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 1433.901, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6908_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_28", + "Startup Cost": 86715.17, + "Total Cost": 86715.17, + "Plan Rows": 1000, + "Plan Width": 1026, + "Actual Startup Time": 1525.629, + "Actual Total Time": 1525.630, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_28.auditid", "a_28.userid", "a_28.username", "a_28.clock", "a_28.action", "a_28.resourcetype", "a_28.ip", "a_28.resourceid", "a_28.resourcename", "a_28.details", "a_28.recordsetid"], + "Vectorized Filter": "((a_28.clock >= 1735654733) AND (a_28.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 84100, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 1340.438, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_7038_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_7038_chunk", + "Startup Cost": 0.00, + "Total Cost": 86715.17, + "Plan Rows": 1, + "Plan Width": 357, + "Actual Startup Time": 1525.626, + "Actual Total Time": 1525.626, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_7038_chunk._ts_meta_count", "compress_hyper_18_7038_chunk._ts_meta_sequence_num", "compress_hyper_18_7038_chunk.auditid", "compress_hyper_18_7038_chunk._ts_meta_v2_min_userid", "compress_hyper_18_7038_chunk._ts_meta_v2_max_userid", "compress_hyper_18_7038_chunk.userid", "compress_hyper_18_7038_chunk.username", "compress_hyper_18_7038_chunk._ts_meta_min_1", "compress_hyper_18_7038_chunk._ts_meta_max_1", "compress_hyper_18_7038_chunk.clock", "compress_hyper_18_7038_chunk._ts_meta_v2_min_ip", "compress_hyper_18_7038_chunk._ts_meta_v2_max_ip", "compress_hyper_18_7038_chunk.ip", "compress_hyper_18_7038_chunk.action", "compress_hyper_18_7038_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_7038_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_7038_chunk.resourcetype", "compress_hyper_18_7038_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_7038_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_7038_chunk.resourceid", "compress_hyper_18_7038_chunk.resource_cuid", "compress_hyper_18_7038_chunk.resourcename", "compress_hyper_18_7038_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_7038_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_7038_chunk.recordsetid", "compress_hyper_18_7038_chunk.details"],+ "Filter": "((compress_hyper_18_7038_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_7038_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 697378, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 84100, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 1340.438, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6884_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_11", + "Startup Cost": 74016.28, + "Total Cost": 74016.28, + "Plan Rows": 1000, + "Plan Width": 1026, + "Actual Startup Time": 1359.163, + "Actual Total Time": 1359.164, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_11.auditid", "a_11.userid", "a_11.username", "a_11.clock", "a_11.action", "a_11.resourcetype", "a_11.ip", "a_11.resourceid", "a_11.resourcename", "a_11.details", "a_11.recordsetid"], + "Vectorized Filter": "((a_11.clock >= 1735654733) AND (a_11.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 71707, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 1194.877, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_7014_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_7014_chunk", + "Startup Cost": 0.00, + "Total Cost": 74016.28, + "Plan Rows": 1, + "Plan Width": 357, + "Actual Startup Time": 1359.160, + "Actual Total Time": 1359.160, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_7014_chunk._ts_meta_count", "compress_hyper_18_7014_chunk._ts_meta_sequence_num", "compress_hyper_18_7014_chunk.auditid", "compress_hyper_18_7014_chunk._ts_meta_v2_min_userid", "compress_hyper_18_7014_chunk._ts_meta_v2_max_userid", "compress_hyper_18_7014_chunk.userid", "compress_hyper_18_7014_chunk.username", "compress_hyper_18_7014_chunk._ts_meta_min_1", "compress_hyper_18_7014_chunk._ts_meta_max_1", "compress_hyper_18_7014_chunk.clock", "compress_hyper_18_7014_chunk._ts_meta_v2_min_ip", "compress_hyper_18_7014_chunk._ts_meta_v2_max_ip", "compress_hyper_18_7014_chunk.ip", "compress_hyper_18_7014_chunk.action", "compress_hyper_18_7014_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_7014_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_7014_chunk.resourcetype", "compress_hyper_18_7014_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_7014_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_7014_chunk.resourceid", "compress_hyper_18_7014_chunk.resource_cuid", "compress_hyper_18_7014_chunk.resourcename", "compress_hyper_18_7014_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_7014_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_7014_chunk.recordsetid", "compress_hyper_18_7014_chunk.details"],+ "Filter": "((compress_hyper_18_7014_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_7014_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 615809, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 71707, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 1194.877, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6906_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_25", + "Startup Cost": 64438.46, + "Total Cost": 128876.91, + "Plan Rows": 2000, + "Plan Width": 1026, + "Actual Startup Time": 2288.810, + "Actual Total Time": 2288.811, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_25.auditid", "a_25.userid", "a_25.username", "a_25.clock", "a_25.action", "a_25.resourcetype", "a_25.ip", "a_25.resourceid", "a_25.resourcename", "a_25.details", "a_25.recordsetid"], + "Vectorized Filter": "((a_25.clock >= 1735654733) AND (a_25.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 124887, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 2012.891, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_7036_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_7036_chunk", + "Startup Cost": 0.00, + "Total Cost": 128876.91, + "Plan Rows": 2, + "Plan Width": 357, + "Actual Startup Time": 2288.807, + "Actual Total Time": 2288.807, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_7036_chunk._ts_meta_count", "compress_hyper_18_7036_chunk._ts_meta_sequence_num", "compress_hyper_18_7036_chunk.auditid", "compress_hyper_18_7036_chunk._ts_meta_v2_min_userid", "compress_hyper_18_7036_chunk._ts_meta_v2_max_userid", "compress_hyper_18_7036_chunk.userid", "compress_hyper_18_7036_chunk.username", "compress_hyper_18_7036_chunk._ts_meta_min_1", "compress_hyper_18_7036_chunk._ts_meta_max_1", "compress_hyper_18_7036_chunk.clock", "compress_hyper_18_7036_chunk._ts_meta_v2_min_ip", "compress_hyper_18_7036_chunk._ts_meta_v2_max_ip", "compress_hyper_18_7036_chunk.ip", "compress_hyper_18_7036_chunk.action", "compress_hyper_18_7036_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_7036_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_7036_chunk.resourcetype", "compress_hyper_18_7036_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_7036_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_7036_chunk.resourceid", "compress_hyper_18_7036_chunk.resource_cuid", "compress_hyper_18_7036_chunk.resourcename", "compress_hyper_18_7036_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_7036_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_7036_chunk.recordsetid", "compress_hyper_18_7036_chunk.details"],+ "Filter": "((compress_hyper_18_7036_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_7036_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 1063976, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 124887, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 2012.891, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6914_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_20", + "Startup Cost": 62740.29, + "Total Cost": 125480.57, + "Plan Rows": 2000, + "Plan Width": 1026, + "Actual Startup Time": 2152.751, + "Actual Total Time": 2152.752, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_20.auditid", "a_20.userid", "a_20.username", "a_20.clock", "a_20.action", "a_20.resourcetype", "a_20.ip", "a_20.resourceid", "a_20.resourcename", "a_20.details", "a_20.recordsetid"], + "Vectorized Filter": "((a_20.clock >= 1735654733) AND (a_20.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 121503, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 1880.689, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_7044_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_7044_chunk", + "Startup Cost": 0.00, + "Total Cost": 125480.57, + "Plan Rows": 2, + "Plan Width": 357, + "Actual Startup Time": 2152.748, + "Actual Total Time": 2152.748, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_7044_chunk._ts_meta_count", "compress_hyper_18_7044_chunk._ts_meta_sequence_num", "compress_hyper_18_7044_chunk.auditid", "compress_hyper_18_7044_chunk._ts_meta_v2_min_userid", "compress_hyper_18_7044_chunk._ts_meta_v2_max_userid", "compress_hyper_18_7044_chunk.userid", "compress_hyper_18_7044_chunk.username", "compress_hyper_18_7044_chunk._ts_meta_min_1", "compress_hyper_18_7044_chunk._ts_meta_max_1", "compress_hyper_18_7044_chunk.clock", "compress_hyper_18_7044_chunk._ts_meta_v2_min_ip", "compress_hyper_18_7044_chunk._ts_meta_v2_max_ip", "compress_hyper_18_7044_chunk.ip", "compress_hyper_18_7044_chunk.action", "compress_hyper_18_7044_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_7044_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_7044_chunk.resourcetype", "compress_hyper_18_7044_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_7044_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_7044_chunk.resourceid", "compress_hyper_18_7044_chunk.resource_cuid", "compress_hyper_18_7044_chunk.resourcename", "compress_hyper_18_7044_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_7044_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_7044_chunk.recordsetid", "compress_hyper_18_7044_chunk.details"],+ "Filter": "((compress_hyper_18_7044_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_7044_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 1060686, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 121503, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 1880.689, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6878_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_12", + "Startup Cost": 61827.23, + "Total Cost": 123654.46, + "Plan Rows": 2000, + "Plan Width": 1026, + "Actual Startup Time": 2119.584, + "Actual Total Time": 2119.586, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_12.auditid", "a_12.userid", "a_12.username", "a_12.clock", "a_12.action", "a_12.resourcetype", "a_12.ip", "a_12.resourceid", "a_12.resourcename", "a_12.details", "a_12.recordsetid"], + "Vectorized Filter": "((a_12.clock >= 1735654733) AND (a_12.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 119729, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 1856.960, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_7008_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_7008_chunk", + "Startup Cost": 0.00, + "Total Cost": 123654.46, + "Plan Rows": 2, + "Plan Width": 357, + "Actual Startup Time": 2119.582, + "Actual Total Time": 2119.582, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_7008_chunk._ts_meta_count", "compress_hyper_18_7008_chunk._ts_meta_sequence_num", "compress_hyper_18_7008_chunk.auditid", "compress_hyper_18_7008_chunk._ts_meta_v2_min_userid", "compress_hyper_18_7008_chunk._ts_meta_v2_max_userid", "compress_hyper_18_7008_chunk.userid", "compress_hyper_18_7008_chunk.username", "compress_hyper_18_7008_chunk._ts_meta_min_1", "compress_hyper_18_7008_chunk._ts_meta_max_1", "compress_hyper_18_7008_chunk.clock", "compress_hyper_18_7008_chunk._ts_meta_v2_min_ip", "compress_hyper_18_7008_chunk._ts_meta_v2_max_ip", "compress_hyper_18_7008_chunk.ip", "compress_hyper_18_7008_chunk.action", "compress_hyper_18_7008_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_7008_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_7008_chunk.resourcetype", "compress_hyper_18_7008_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_7008_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_7008_chunk.resourceid", "compress_hyper_18_7008_chunk.resource_cuid", "compress_hyper_18_7008_chunk.resourcename", "compress_hyper_18_7008_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_7008_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_7008_chunk.recordsetid", "compress_hyper_18_7008_chunk.details"],+ "Filter": "((compress_hyper_18_7008_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_7008_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 1046790, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 119729, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 1856.960, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6911_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_23", + "Startup Cost": 59847.96, + "Total Cost": 119695.93, + "Plan Rows": 2000, + "Plan Width": 1026, + "Actual Startup Time": 2021.156, + "Actual Total Time": 2021.157, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_23.auditid", "a_23.userid", "a_23.username", "a_23.clock", "a_23.action", "a_23.resourcetype", "a_23.ip", "a_23.resourceid", "a_23.resourcename", "a_23.details", "a_23.recordsetid"], + "Vectorized Filter": "((a_23.clock >= 1735654733) AND (a_23.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 115879, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 1763.315, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_7041_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_7041_chunk", + "Startup Cost": 0.00, + "Total Cost": 119695.93, + "Plan Rows": 2, + "Plan Width": 357, + "Actual Startup Time": 2021.153, + "Actual Total Time": 2021.153, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_7041_chunk._ts_meta_count", "compress_hyper_18_7041_chunk._ts_meta_sequence_num", "compress_hyper_18_7041_chunk.auditid", "compress_hyper_18_7041_chunk._ts_meta_v2_min_userid", "compress_hyper_18_7041_chunk._ts_meta_v2_max_userid", "compress_hyper_18_7041_chunk.userid", "compress_hyper_18_7041_chunk.username", "compress_hyper_18_7041_chunk._ts_meta_min_1", "compress_hyper_18_7041_chunk._ts_meta_max_1", "compress_hyper_18_7041_chunk.clock", "compress_hyper_18_7041_chunk._ts_meta_v2_min_ip", "compress_hyper_18_7041_chunk._ts_meta_v2_max_ip", "compress_hyper_18_7041_chunk.ip", "compress_hyper_18_7041_chunk.action", "compress_hyper_18_7041_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_7041_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_7041_chunk.resourcetype", "compress_hyper_18_7041_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_7041_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_7041_chunk.resourceid", "compress_hyper_18_7041_chunk.resource_cuid", "compress_hyper_18_7041_chunk.resourcename", "compress_hyper_18_7041_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_7041_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_7041_chunk.recordsetid", "compress_hyper_18_7041_chunk.details"],+ "Filter": "((compress_hyper_18_7041_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_7041_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 1017847, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 115879, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 1763.315, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6877_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_13", + "Startup Cost": 58446.69, + "Total Cost": 116893.38, + "Plan Rows": 2000, + "Plan Width": 1026, + "Actual Startup Time": 2078.836, + "Actual Total Time": 2078.837, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_13.auditid", "a_13.userid", "a_13.username", "a_13.clock", "a_13.action", "a_13.resourcetype", "a_13.ip", "a_13.resourceid", "a_13.resourcename", "a_13.details", "a_13.recordsetid"], + "Vectorized Filter": "((a_13.clock >= 1735654733) AND (a_13.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 113186, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 1809.168, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_7007_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_7007_chunk", + "Startup Cost": 0.00, + "Total Cost": 116893.38, + "Plan Rows": 2, + "Plan Width": 357, + "Actual Startup Time": 2078.834, + "Actual Total Time": 2078.834, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_7007_chunk._ts_meta_count", "compress_hyper_18_7007_chunk._ts_meta_sequence_num", "compress_hyper_18_7007_chunk.auditid", "compress_hyper_18_7007_chunk._ts_meta_v2_min_userid", "compress_hyper_18_7007_chunk._ts_meta_v2_max_userid", "compress_hyper_18_7007_chunk.userid", "compress_hyper_18_7007_chunk.username", "compress_hyper_18_7007_chunk._ts_meta_min_1", "compress_hyper_18_7007_chunk._ts_meta_max_1", "compress_hyper_18_7007_chunk.clock", "compress_hyper_18_7007_chunk._ts_meta_v2_min_ip", "compress_hyper_18_7007_chunk._ts_meta_v2_max_ip", "compress_hyper_18_7007_chunk.ip", "compress_hyper_18_7007_chunk.action", "compress_hyper_18_7007_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_7007_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_7007_chunk.resourcetype", "compress_hyper_18_7007_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_7007_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_7007_chunk.resourceid", "compress_hyper_18_7007_chunk.resource_cuid", "compress_hyper_18_7007_chunk.resourcename", "compress_hyper_18_7007_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_7007_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_7007_chunk.recordsetid", "compress_hyper_18_7007_chunk.details"],+ "Filter": "((compress_hyper_18_7007_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_7007_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 988634, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 113186, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 1809.168, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6875_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_14", + "Startup Cost": 58148.63, + "Total Cost": 116297.26, + "Plan Rows": 2000, + "Plan Width": 1026, + "Actual Startup Time": 2339.023, + "Actual Total Time": 2339.023, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_14.auditid", "a_14.userid", "a_14.username", "a_14.clock", "a_14.action", "a_14.resourcetype", "a_14.ip", "a_14.resourceid", "a_14.resourcename", "a_14.details", "a_14.recordsetid"], + "Vectorized Filter": "((a_14.clock >= 1735654733) AND (a_14.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 112615, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 2015.526, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_7005_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_7005_chunk", + "Startup Cost": 0.00, + "Total Cost": 116297.26, + "Plan Rows": 2, + "Plan Width": 357, + "Actual Startup Time": 2339.019, + "Actual Total Time": 2339.020, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_7005_chunk._ts_meta_count", "compress_hyper_18_7005_chunk._ts_meta_sequence_num", "compress_hyper_18_7005_chunk.auditid", "compress_hyper_18_7005_chunk._ts_meta_v2_min_userid", "compress_hyper_18_7005_chunk._ts_meta_v2_max_userid", "compress_hyper_18_7005_chunk.userid", "compress_hyper_18_7005_chunk.username", "compress_hyper_18_7005_chunk._ts_meta_min_1", "compress_hyper_18_7005_chunk._ts_meta_max_1", "compress_hyper_18_7005_chunk.clock", "compress_hyper_18_7005_chunk._ts_meta_v2_min_ip", "compress_hyper_18_7005_chunk._ts_meta_v2_max_ip", "compress_hyper_18_7005_chunk.ip", "compress_hyper_18_7005_chunk.action", "compress_hyper_18_7005_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_7005_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_7005_chunk.resourcetype", "compress_hyper_18_7005_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_7005_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_7005_chunk.resourceid", "compress_hyper_18_7005_chunk.resource_cuid", "compress_hyper_18_7005_chunk.resourcename", "compress_hyper_18_7005_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_7005_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_7005_chunk.recordsetid", "compress_hyper_18_7005_chunk.details"],+ "Filter": "((compress_hyper_18_7005_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_7005_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 981935, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 112615, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 2015.526, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6919_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_52", + "Startup Cost": 58099.90, + "Total Cost": 1161997.98, + "Plan Rows": 20000, + "Plan Width": 1026, + "Actual Startup Time": 20706.932, + "Actual Total Time": 20706.933, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_52.auditid", "a_52.userid", "a_52.username", "a_52.clock", "a_52.action", "a_52.resourcetype", "a_52.ip", "a_52.resourceid", "a_52.resourcename", "a_52.details", "a_52.recordsetid"], + "Vectorized Filter": "((a_52.clock >= 1735654733) AND (a_52.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 727, + "Shared Read Blocks": 1126893, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 18508.008, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_7050_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_7050_chunk", + "Startup Cost": 0.00, + "Total Cost": 1161997.98, + "Plan Rows": 20, + "Plan Width": 357, + "Actual Startup Time": 20706.929, + "Actual Total Time": 20706.929, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_7050_chunk._ts_meta_count", "compress_hyper_18_7050_chunk._ts_meta_sequence_num", "compress_hyper_18_7050_chunk.auditid", "compress_hyper_18_7050_chunk._ts_meta_v2_min_userid", "compress_hyper_18_7050_chunk._ts_meta_v2_max_userid", "compress_hyper_18_7050_chunk.userid", "compress_hyper_18_7050_chunk.username", "compress_hyper_18_7050_chunk._ts_meta_min_1", "compress_hyper_18_7050_chunk._ts_meta_max_1", "compress_hyper_18_7050_chunk.clock", "compress_hyper_18_7050_chunk._ts_meta_v2_min_ip", "compress_hyper_18_7050_chunk._ts_meta_v2_max_ip", "compress_hyper_18_7050_chunk.ip", "compress_hyper_18_7050_chunk.action", "compress_hyper_18_7050_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_7050_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_7050_chunk.resourcetype", "compress_hyper_18_7050_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_7050_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_7050_chunk.resourceid", "compress_hyper_18_7050_chunk.resource_cuid", "compress_hyper_18_7050_chunk.resourcename", "compress_hyper_18_7050_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_7050_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_7050_chunk.recordsetid", "compress_hyper_18_7050_chunk.details"],+ "Filter": "((compress_hyper_18_7050_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_7050_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 9165781, + "Shared Hit Blocks": 727, + "Shared Read Blocks": 1126893, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 18508.008, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6910_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_24", + "Startup Cost": 57386.79, + "Total Cost": 114773.58, + "Plan Rows": 2000, + "Plan Width": 1026, + "Actual Startup Time": 2049.147, + "Actual Total Time": 2049.148, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_24.auditid", "a_24.userid", "a_24.username", "a_24.clock", "a_24.action", "a_24.resourcetype", "a_24.ip", "a_24.resourceid", "a_24.resourcename", "a_24.details", "a_24.recordsetid"], + "Vectorized Filter": "((a_24.clock >= 1735654733) AND (a_24.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 111176, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 1784.930, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_7040_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_7040_chunk", + "Startup Cost": 0.00, + "Total Cost": 114773.58, + "Plan Rows": 2, + "Plan Width": 357, + "Actual Startup Time": 2049.144, + "Actual Total Time": 2049.144, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_7040_chunk._ts_meta_count", "compress_hyper_18_7040_chunk._ts_meta_sequence_num", "compress_hyper_18_7040_chunk.auditid", "compress_hyper_18_7040_chunk._ts_meta_v2_min_userid", "compress_hyper_18_7040_chunk._ts_meta_v2_max_userid", "compress_hyper_18_7040_chunk.userid", "compress_hyper_18_7040_chunk.username", "compress_hyper_18_7040_chunk._ts_meta_min_1", "compress_hyper_18_7040_chunk._ts_meta_max_1", "compress_hyper_18_7040_chunk.clock", "compress_hyper_18_7040_chunk._ts_meta_v2_min_ip", "compress_hyper_18_7040_chunk._ts_meta_v2_max_ip", "compress_hyper_18_7040_chunk.ip", "compress_hyper_18_7040_chunk.action", "compress_hyper_18_7040_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_7040_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_7040_chunk.resourcetype", "compress_hyper_18_7040_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_7040_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_7040_chunk.resourceid", "compress_hyper_18_7040_chunk.resource_cuid", "compress_hyper_18_7040_chunk.resourcename", "compress_hyper_18_7040_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_7040_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_7040_chunk.recordsetid", "compress_hyper_18_7040_chunk.details"],+ "Filter": "((compress_hyper_18_7040_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_7040_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 959355, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 111176, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 1784.930, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6915_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_19", + "Startup Cost": 57307.14, + "Total Cost": 114614.28, + "Plan Rows": 2000, + "Plan Width": 1026, + "Actual Startup Time": 2085.803, + "Actual Total Time": 2085.804, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_19.auditid", "a_19.userid", "a_19.username", "a_19.clock", "a_19.action", "a_19.resourcetype", "a_19.ip", "a_19.resourceid", "a_19.resourcename", "a_19.details", "a_19.recordsetid"], + "Vectorized Filter": "((a_19.clock >= 1735654733) AND (a_19.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 110997, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 1837.976, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_7045_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_7045_chunk", + "Startup Cost": 0.00, + "Total Cost": 114614.28, + "Plan Rows": 2, + "Plan Width": 357, + "Actual Startup Time": 2085.800, + "Actual Total Time": 2085.801, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_7045_chunk._ts_meta_count", "compress_hyper_18_7045_chunk._ts_meta_sequence_num", "compress_hyper_18_7045_chunk.auditid", "compress_hyper_18_7045_chunk._ts_meta_v2_min_userid", "compress_hyper_18_7045_chunk._ts_meta_v2_max_userid", "compress_hyper_18_7045_chunk.userid", "compress_hyper_18_7045_chunk.username", "compress_hyper_18_7045_chunk._ts_meta_min_1", "compress_hyper_18_7045_chunk._ts_meta_max_1", "compress_hyper_18_7045_chunk.clock", "compress_hyper_18_7045_chunk._ts_meta_v2_min_ip", "compress_hyper_18_7045_chunk._ts_meta_v2_max_ip", "compress_hyper_18_7045_chunk.ip", "compress_hyper_18_7045_chunk.action", "compress_hyper_18_7045_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_7045_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_7045_chunk.resourcetype", "compress_hyper_18_7045_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_7045_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_7045_chunk.resourceid", "compress_hyper_18_7045_chunk.resource_cuid", "compress_hyper_18_7045_chunk.resourcename", "compress_hyper_18_7045_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_7045_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_7045_chunk.recordsetid", "compress_hyper_18_7045_chunk.details"],+ "Filter": "((compress_hyper_18_7045_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_7045_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 964608, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 110997, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 1837.976, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6882_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_53", + "Startup Cost": 57177.19, + "Total Cost": 1143543.75, + "Plan Rows": 20000, + "Plan Width": 1026, + "Actual Startup Time": 19321.374, + "Actual Total Time": 19321.375, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_53.auditid", "a_53.userid", "a_53.username", "a_53.clock", "a_53.action", "a_53.resourcetype", "a_53.ip", "a_53.resourceid", "a_53.resourcename", "a_53.details", "a_53.recordsetid"], + "Vectorized Filter": "((a_53.clock >= 1735654733) AND (a_53.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 1109758, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 17250.381, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_7012_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_7012_chunk", + "Startup Cost": 0.00, + "Total Cost": 1143543.75, + "Plan Rows": 20, + "Plan Width": 357, + "Actual Startup Time": 19321.371, + "Actual Total Time": 19321.371, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_7012_chunk._ts_meta_count", "compress_hyper_18_7012_chunk._ts_meta_sequence_num", "compress_hyper_18_7012_chunk.auditid", "compress_hyper_18_7012_chunk._ts_meta_v2_min_userid", "compress_hyper_18_7012_chunk._ts_meta_v2_max_userid", "compress_hyper_18_7012_chunk.userid", "compress_hyper_18_7012_chunk.username", "compress_hyper_18_7012_chunk._ts_meta_min_1", "compress_hyper_18_7012_chunk._ts_meta_max_1", "compress_hyper_18_7012_chunk.clock", "compress_hyper_18_7012_chunk._ts_meta_v2_min_ip", "compress_hyper_18_7012_chunk._ts_meta_v2_max_ip", "compress_hyper_18_7012_chunk.ip", "compress_hyper_18_7012_chunk.action", "compress_hyper_18_7012_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_7012_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_7012_chunk.resourcetype", "compress_hyper_18_7012_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_7012_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_7012_chunk.resourceid", "compress_hyper_18_7012_chunk.resource_cuid", "compress_hyper_18_7012_chunk.resourcename", "compress_hyper_18_7012_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_7012_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_7012_chunk.recordsetid", "compress_hyper_18_7012_chunk.details"],+ "Filter": "((compress_hyper_18_7012_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_7012_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 9006918, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 1109758, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 17250.381, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6869_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_17", + "Startup Cost": 56957.12, + "Total Cost": 113914.24, + "Plan Rows": 2000, + "Plan Width": 1026, + "Actual Startup Time": 2372.383, + "Actual Total Time": 2372.385, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_17.auditid", "a_17.userid", "a_17.username", "a_17.clock", "a_17.action", "a_17.resourcetype", "a_17.ip", "a_17.resourceid", "a_17.resourcename", "a_17.details", "a_17.recordsetid"], + "Vectorized Filter": "((a_17.clock >= 1735654733) AND (a_17.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 110311, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 2101.130, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_6999_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_6999_chunk", + "Startup Cost": 0.00, + "Total Cost": 113914.24, + "Plan Rows": 2, + "Plan Width": 357, + "Actual Startup Time": 2372.381, + "Actual Total Time": 2372.381, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_6999_chunk._ts_meta_count", "compress_hyper_18_6999_chunk._ts_meta_sequence_num", "compress_hyper_18_6999_chunk.auditid", "compress_hyper_18_6999_chunk._ts_meta_v2_min_userid", "compress_hyper_18_6999_chunk._ts_meta_v2_max_userid", "compress_hyper_18_6999_chunk.userid", "compress_hyper_18_6999_chunk.username", "compress_hyper_18_6999_chunk._ts_meta_min_1", "compress_hyper_18_6999_chunk._ts_meta_max_1", "compress_hyper_18_6999_chunk.clock", "compress_hyper_18_6999_chunk._ts_meta_v2_min_ip", "compress_hyper_18_6999_chunk._ts_meta_v2_max_ip", "compress_hyper_18_6999_chunk.ip", "compress_hyper_18_6999_chunk.action", "compress_hyper_18_6999_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_6999_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_6999_chunk.resourcetype", "compress_hyper_18_6999_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_6999_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_6999_chunk.resourceid", "compress_hyper_18_6999_chunk.resource_cuid", "compress_hyper_18_6999_chunk.resourcename", "compress_hyper_18_6999_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_6999_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_6999_chunk.recordsetid", "compress_hyper_18_6999_chunk.details"],+ "Filter": "((compress_hyper_18_6999_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_6999_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 960863, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 110311, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 2101.130, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6913_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_21", + "Startup Cost": 56807.95, + "Total Cost": 113615.90, + "Plan Rows": 2000, + "Plan Width": 1026, + "Actual Startup Time": 4069.652, + "Actual Total Time": 4069.653, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_21.auditid", "a_21.userid", "a_21.username", "a_21.clock", "a_21.action", "a_21.resourcetype", "a_21.ip", "a_21.resourceid", "a_21.resourcename", "a_21.details", "a_21.recordsetid"], + "Vectorized Filter": "((a_21.clock >= 1735654733) AND (a_21.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 110013, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 3799.994, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_7043_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_7043_chunk", + "Startup Cost": 0.00, + "Total Cost": 113615.90, + "Plan Rows": 2, + "Plan Width": 357, + "Actual Startup Time": 4069.650, + "Actual Total Time": 4069.650, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_7043_chunk._ts_meta_count", "compress_hyper_18_7043_chunk._ts_meta_sequence_num", "compress_hyper_18_7043_chunk.auditid", "compress_hyper_18_7043_chunk._ts_meta_v2_min_userid", "compress_hyper_18_7043_chunk._ts_meta_v2_max_userid", "compress_hyper_18_7043_chunk.userid", "compress_hyper_18_7043_chunk.username", "compress_hyper_18_7043_chunk._ts_meta_min_1", "compress_hyper_18_7043_chunk._ts_meta_max_1", "compress_hyper_18_7043_chunk.clock", "compress_hyper_18_7043_chunk._ts_meta_v2_min_ip", "compress_hyper_18_7043_chunk._ts_meta_v2_max_ip", "compress_hyper_18_7043_chunk.ip", "compress_hyper_18_7043_chunk.action", "compress_hyper_18_7043_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_7043_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_7043_chunk.resourcetype", "compress_hyper_18_7043_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_7043_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_7043_chunk.resourceid", "compress_hyper_18_7043_chunk.resource_cuid", "compress_hyper_18_7043_chunk.resourcename", "compress_hyper_18_7043_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_7043_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_7043_chunk.recordsetid", "compress_hyper_18_7043_chunk.details"],+ "Filter": "((compress_hyper_18_7043_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_7043_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 960772, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 110013, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 3799.994, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6868_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_18", + "Startup Cost": 56806.47, + "Total Cost": 113612.93, + "Plan Rows": 2000, + "Plan Width": 1026, + "Actual Startup Time": 2168.743, + "Actual Total Time": 2168.745, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_18.auditid", "a_18.userid", "a_18.username", "a_18.clock", "a_18.action", "a_18.resourcetype", "a_18.ip", "a_18.resourceid", "a_18.resourcename", "a_18.details", "a_18.recordsetid"], + "Vectorized Filter": "((a_18.clock >= 1735654733) AND (a_18.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 110014, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 1925.674, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_6998_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_6998_chunk", + "Startup Cost": 0.00, + "Total Cost": 113612.93, + "Plan Rows": 2, + "Plan Width": 357, + "Actual Startup Time": 2168.741, + "Actual Total Time": 2168.741, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_6998_chunk._ts_meta_count", "compress_hyper_18_6998_chunk._ts_meta_sequence_num", "compress_hyper_18_6998_chunk.auditid", "compress_hyper_18_6998_chunk._ts_meta_v2_min_userid", "compress_hyper_18_6998_chunk._ts_meta_v2_max_userid", "compress_hyper_18_6998_chunk.userid", "compress_hyper_18_6998_chunk.username", "compress_hyper_18_6998_chunk._ts_meta_min_1", "compress_hyper_18_6998_chunk._ts_meta_max_1", "compress_hyper_18_6998_chunk.clock", "compress_hyper_18_6998_chunk._ts_meta_v2_min_ip", "compress_hyper_18_6998_chunk._ts_meta_v2_max_ip", "compress_hyper_18_6998_chunk.ip", "compress_hyper_18_6998_chunk.action", "compress_hyper_18_6998_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_6998_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_6998_chunk.resourcetype", "compress_hyper_18_6998_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_6998_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_6998_chunk.resourceid", "compress_hyper_18_6998_chunk.resource_cuid", "compress_hyper_18_6998_chunk.resourcename", "compress_hyper_18_6998_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_6998_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_6998_chunk.recordsetid", "compress_hyper_18_6998_chunk.details"],+ "Filter": "((compress_hyper_18_6998_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_6998_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 959716, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 110014, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 1925.674, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6923_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_51", + "Startup Cost": 56733.58, + "Total Cost": 1191405.09, + "Plan Rows": 21000, + "Plan Width": 1026, + "Actual Startup Time": 21715.940, + "Actual Total Time": 21715.942, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_51.auditid", "a_51.userid", "a_51.username", "a_51.clock", "a_51.action", "a_51.resourcetype", "a_51.ip", "a_51.resourceid", "a_51.resourcename", "a_51.details", "a_51.recordsetid"], + "Vectorized Filter": "((a_51.clock >= 1735654733) AND (a_51.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 2088, + "Shared Read Blocks": 1154412, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 19522.491, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_7054_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_7054_chunk", + "Startup Cost": 0.00, + "Total Cost": 1191405.09, + "Plan Rows": 21, + "Plan Width": 357, + "Actual Startup Time": 21715.939, + "Actual Total Time": 21715.939, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_7054_chunk._ts_meta_count", "compress_hyper_18_7054_chunk._ts_meta_sequence_num", "compress_hyper_18_7054_chunk.auditid", "compress_hyper_18_7054_chunk._ts_meta_v2_min_userid", "compress_hyper_18_7054_chunk._ts_meta_v2_max_userid", "compress_hyper_18_7054_chunk.userid", "compress_hyper_18_7054_chunk.username", "compress_hyper_18_7054_chunk._ts_meta_min_1", "compress_hyper_18_7054_chunk._ts_meta_max_1", "compress_hyper_18_7054_chunk.clock", "compress_hyper_18_7054_chunk._ts_meta_v2_min_ip", "compress_hyper_18_7054_chunk._ts_meta_v2_max_ip", "compress_hyper_18_7054_chunk.ip", "compress_hyper_18_7054_chunk.action", "compress_hyper_18_7054_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_7054_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_7054_chunk.resourcetype", "compress_hyper_18_7054_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_7054_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_7054_chunk.resourceid", "compress_hyper_18_7054_chunk.resource_cuid", "compress_hyper_18_7054_chunk.resourcename", "compress_hyper_18_7054_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_7054_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_7054_chunk.recordsetid", "compress_hyper_18_7054_chunk.details"],+ "Filter": "((compress_hyper_18_7054_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_7054_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 9308002, + "Shared Hit Blocks": 2088, + "Shared Read Blocks": 1154412, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 19522.491, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6871_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_55", + "Startup Cost": 56691.46, + "Total Cost": 1133829.29, + "Plan Rows": 20000, + "Plan Width": 1026, + "Actual Startup Time": 20096.815, + "Actual Total Time": 20096.817, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_55.auditid", "a_55.userid", "a_55.username", "a_55.clock", "a_55.action", "a_55.resourcetype", "a_55.ip", "a_55.resourceid", "a_55.resourcename", "a_55.details", "a_55.recordsetid"], + "Vectorized Filter": "((a_55.clock >= 1735654733) AND (a_55.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 1100296, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 18001.966, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_7001_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_7001_chunk", + "Startup Cost": 0.00, + "Total Cost": 1133829.29, + "Plan Rows": 20, + "Plan Width": 358, + "Actual Startup Time": 20096.813, + "Actual Total Time": 20096.813, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_7001_chunk._ts_meta_count", "compress_hyper_18_7001_chunk._ts_meta_sequence_num", "compress_hyper_18_7001_chunk.auditid", "compress_hyper_18_7001_chunk._ts_meta_v2_min_userid", "compress_hyper_18_7001_chunk._ts_meta_v2_max_userid", "compress_hyper_18_7001_chunk.userid", "compress_hyper_18_7001_chunk.username", "compress_hyper_18_7001_chunk._ts_meta_min_1", "compress_hyper_18_7001_chunk._ts_meta_max_1", "compress_hyper_18_7001_chunk.clock", "compress_hyper_18_7001_chunk._ts_meta_v2_min_ip", "compress_hyper_18_7001_chunk._ts_meta_v2_max_ip", "compress_hyper_18_7001_chunk.ip", "compress_hyper_18_7001_chunk.action", "compress_hyper_18_7001_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_7001_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_7001_chunk.resourcetype", "compress_hyper_18_7001_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_7001_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_7001_chunk.resourceid", "compress_hyper_18_7001_chunk.resource_cuid", "compress_hyper_18_7001_chunk.resourcename", "compress_hyper_18_7001_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_7001_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_7001_chunk.recordsetid", "compress_hyper_18_7001_chunk.details"],+ "Filter": "((compress_hyper_18_7001_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_7001_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 8941521, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 1100296, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 18001.966, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6922_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_54", + "Startup Cost": 56465.01, + "Total Cost": 1129300.11, + "Plan Rows": 20000, + "Plan Width": 1026, + "Actual Startup Time": 19678.157, + "Actual Total Time": 19678.159, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_54.auditid", "a_54.userid", "a_54.username", "a_54.clock", "a_54.action", "a_54.resourcetype", "a_54.ip", "a_54.resourceid", "a_54.resourcename", "a_54.details", "a_54.recordsetid"], + "Vectorized Filter": "((a_54.clock >= 1735654733) AND (a_54.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 490, + "Shared Read Blocks": 1095443, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 17571.326, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_7053_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_7053_chunk", + "Startup Cost": 0.00, + "Total Cost": 1129300.11, + "Plan Rows": 20, + "Plan Width": 357, + "Actual Startup Time": 19678.155, + "Actual Total Time": 19678.155, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_7053_chunk._ts_meta_count", "compress_hyper_18_7053_chunk._ts_meta_sequence_num", "compress_hyper_18_7053_chunk.auditid", "compress_hyper_18_7053_chunk._ts_meta_v2_min_userid", "compress_hyper_18_7053_chunk._ts_meta_v2_max_userid", "compress_hyper_18_7053_chunk.userid", "compress_hyper_18_7053_chunk.username", "compress_hyper_18_7053_chunk._ts_meta_min_1", "compress_hyper_18_7053_chunk._ts_meta_max_1", "compress_hyper_18_7053_chunk.clock", "compress_hyper_18_7053_chunk._ts_meta_v2_min_ip", "compress_hyper_18_7053_chunk._ts_meta_v2_max_ip", "compress_hyper_18_7053_chunk.ip", "compress_hyper_18_7053_chunk.action", "compress_hyper_18_7053_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_7053_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_7053_chunk.resourcetype", "compress_hyper_18_7053_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_7053_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_7053_chunk.resourceid", "compress_hyper_18_7053_chunk.resource_cuid", "compress_hyper_18_7053_chunk.resourcename", "compress_hyper_18_7053_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_7053_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_7053_chunk.recordsetid", "compress_hyper_18_7053_chunk.details"],+ "Filter": "((compress_hyper_18_7053_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_7053_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 8898215, + "Shared Hit Blocks": 490, + "Shared Read Blocks": 1095443, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 17571.326, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6881_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_50", + "Startup Cost": 55955.55, + "Total Cost": 1175066.45, + "Plan Rows": 21000, + "Plan Width": 1026, + "Actual Startup Time": 20610.260, + "Actual Total Time": 20610.262, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_50.auditid", "a_50.userid", "a_50.username", "a_50.clock", "a_50.action", "a_50.resourcetype", "a_50.ip", "a_50.resourceid", "a_50.resourcename", "a_50.details", "a_50.recordsetid"], + "Vectorized Filter": "((a_50.clock >= 1735654733) AND (a_50.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 1140149, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 18230.765, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_7011_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_7011_chunk", + "Startup Cost": 0.00, + "Total Cost": 1175066.45, + "Plan Rows": 21, + "Plan Width": 357, + "Actual Startup Time": 20610.259, + "Actual Total Time": 20610.259, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_7011_chunk._ts_meta_count", "compress_hyper_18_7011_chunk._ts_meta_sequence_num", "compress_hyper_18_7011_chunk.auditid", "compress_hyper_18_7011_chunk._ts_meta_v2_min_userid", "compress_hyper_18_7011_chunk._ts_meta_v2_max_userid", "compress_hyper_18_7011_chunk.userid", "compress_hyper_18_7011_chunk.username", "compress_hyper_18_7011_chunk._ts_meta_min_1", "compress_hyper_18_7011_chunk._ts_meta_max_1", "compress_hyper_18_7011_chunk.clock", "compress_hyper_18_7011_chunk._ts_meta_v2_min_ip", "compress_hyper_18_7011_chunk._ts_meta_v2_max_ip", "compress_hyper_18_7011_chunk.ip", "compress_hyper_18_7011_chunk.action", "compress_hyper_18_7011_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_7011_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_7011_chunk.resourcetype", "compress_hyper_18_7011_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_7011_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_7011_chunk.resourceid", "compress_hyper_18_7011_chunk.resource_cuid", "compress_hyper_18_7011_chunk.resourcename", "compress_hyper_18_7011_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_7011_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_7011_chunk.recordsetid", "compress_hyper_18_7011_chunk.details"],+ "Filter": "((compress_hyper_18_7011_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_7011_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 9310700, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 1140149, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 18230.765, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6912_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_22", + "Startup Cost": 55510.42, + "Total Cost": 111020.83, + "Plan Rows": 2000, + "Plan Width": 1026, + "Actual Startup Time": 2184.689, + "Actual Total Time": 2184.690, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_22.auditid", "a_22.userid", "a_22.username", "a_22.clock", "a_22.action", "a_22.resourcetype", "a_22.ip", "a_22.resourceid", "a_22.resourcename", "a_22.details", "a_22.recordsetid"], + "Vectorized Filter": "((a_22.clock >= 1735654733) AND (a_22.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 107496, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 1927.733, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_7042_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_7042_chunk", + "Startup Cost": 0.00, + "Total Cost": 111020.83, + "Plan Rows": 2, + "Plan Width": 357, + "Actual Startup Time": 2184.687, + "Actual Total Time": 2184.687, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_7042_chunk._ts_meta_count", "compress_hyper_18_7042_chunk._ts_meta_sequence_num", "compress_hyper_18_7042_chunk.auditid", "compress_hyper_18_7042_chunk._ts_meta_v2_min_userid", "compress_hyper_18_7042_chunk._ts_meta_v2_max_userid", "compress_hyper_18_7042_chunk.userid", "compress_hyper_18_7042_chunk.username", "compress_hyper_18_7042_chunk._ts_meta_min_1", "compress_hyper_18_7042_chunk._ts_meta_max_1", "compress_hyper_18_7042_chunk.clock", "compress_hyper_18_7042_chunk._ts_meta_v2_min_ip", "compress_hyper_18_7042_chunk._ts_meta_v2_max_ip", "compress_hyper_18_7042_chunk.ip", "compress_hyper_18_7042_chunk.action", "compress_hyper_18_7042_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_7042_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_7042_chunk.resourcetype", "compress_hyper_18_7042_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_7042_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_7042_chunk.resourceid", "compress_hyper_18_7042_chunk.resource_cuid", "compress_hyper_18_7042_chunk.resourcename", "compress_hyper_18_7042_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_7042_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_7042_chunk.recordsetid", "compress_hyper_18_7042_chunk.details"],+ "Filter": "((compress_hyper_18_7042_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_7042_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 939955, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 107496, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 1927.733, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6876_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_45", + "Startup Cost": 55303.06, + "Total Cost": 1271970.35, + "Plan Rows": 23000, + "Plan Width": 1026, + "Actual Startup Time": 23073.327, + "Actual Total Time": 23073.329, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_45.auditid", "a_45.userid", "a_45.username", "a_45.clock", "a_45.action", "a_45.resourcetype", "a_45.ip", "a_45.resourceid", "a_45.resourcename", "a_45.details", "a_45.recordsetid"], + "Vectorized Filter": "((a_45.clock >= 1735654733) AND (a_45.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 1234494, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 20654.021, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_7006_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_7006_chunk", + "Startup Cost": 0.00, + "Total Cost": 1271970.35, + "Plan Rows": 23, + "Plan Width": 357, + "Actual Startup Time": 23073.325, + "Actual Total Time": 23073.325, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_7006_chunk._ts_meta_count", "compress_hyper_18_7006_chunk._ts_meta_sequence_num", "compress_hyper_18_7006_chunk.auditid", "compress_hyper_18_7006_chunk._ts_meta_v2_min_userid", "compress_hyper_18_7006_chunk._ts_meta_v2_max_userid", "compress_hyper_18_7006_chunk.userid", "compress_hyper_18_7006_chunk.username", "compress_hyper_18_7006_chunk._ts_meta_min_1", "compress_hyper_18_7006_chunk._ts_meta_max_1", "compress_hyper_18_7006_chunk.clock", "compress_hyper_18_7006_chunk._ts_meta_v2_min_ip", "compress_hyper_18_7006_chunk._ts_meta_v2_max_ip", "compress_hyper_18_7006_chunk.ip", "compress_hyper_18_7006_chunk.action", "compress_hyper_18_7006_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_7006_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_7006_chunk.resourcetype", "compress_hyper_18_7006_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_7006_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_7006_chunk.resourceid", "compress_hyper_18_7006_chunk.resource_cuid", "compress_hyper_18_7006_chunk.resourcename", "compress_hyper_18_7006_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_7006_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_7006_chunk.recordsetid", "compress_hyper_18_7006_chunk.details"],+ "Filter": "((compress_hyper_18_7006_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_7006_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 9996101, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 1234494, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 20654.021, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6872_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_49", + "Startup Cost": 55282.93, + "Total Cost": 1160941.57, + "Plan Rows": 21000, + "Plan Width": 1026, + "Actual Startup Time": 20621.466, + "Actual Total Time": 20621.468, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_49.auditid", "a_49.userid", "a_49.username", "a_49.clock", "a_49.action", "a_49.resourcetype", "a_49.ip", "a_49.resourceid", "a_49.resourcename", "a_49.details", "a_49.recordsetid"], + "Vectorized Filter": "((a_49.clock >= 1735654733) AND (a_49.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 1126434, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 18516.028, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_7002_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_7002_chunk", + "Startup Cost": 0.00, + "Total Cost": 1160941.57, + "Plan Rows": 21, + "Plan Width": 357, + "Actual Startup Time": 20621.464, + "Actual Total Time": 20621.464, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_7002_chunk._ts_meta_count", "compress_hyper_18_7002_chunk._ts_meta_sequence_num", "compress_hyper_18_7002_chunk.auditid", "compress_hyper_18_7002_chunk._ts_meta_v2_min_userid", "compress_hyper_18_7002_chunk._ts_meta_v2_max_userid", "compress_hyper_18_7002_chunk.userid", "compress_hyper_18_7002_chunk.username", "compress_hyper_18_7002_chunk._ts_meta_min_1", "compress_hyper_18_7002_chunk._ts_meta_max_1", "compress_hyper_18_7002_chunk.clock", "compress_hyper_18_7002_chunk._ts_meta_v2_min_ip", "compress_hyper_18_7002_chunk._ts_meta_v2_max_ip", "compress_hyper_18_7002_chunk.ip", "compress_hyper_18_7002_chunk.action", "compress_hyper_18_7002_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_7002_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_7002_chunk.resourcetype", "compress_hyper_18_7002_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_7002_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_7002_chunk.resourceid", "compress_hyper_18_7002_chunk.resource_cuid", "compress_hyper_18_7002_chunk.resourcename", "compress_hyper_18_7002_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_7002_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_7002_chunk.recordsetid", "compress_hyper_18_7002_chunk.details"],+ "Filter": "((compress_hyper_18_7002_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_7002_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 9203907, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 1126434, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 18516.028, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6899_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_47", + "Startup Cost": 55192.69, + "Total Cost": 1159046.46, + "Plan Rows": 21000, + "Plan Width": 1026, + "Actual Startup Time": 20319.738, + "Actual Total Time": 20319.739, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_47.auditid", "a_47.userid", "a_47.username", "a_47.clock", "a_47.action", "a_47.resourcetype", "a_47.ip", "a_47.resourceid", "a_47.resourcename", "a_47.details", "a_47.recordsetid"], + "Vectorized Filter": "((a_47.clock >= 1735654733) AND (a_47.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 1124732, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 18189.064, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_7029_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_7029_chunk", + "Startup Cost": 0.00, + "Total Cost": 1159046.46, + "Plan Rows": 21, + "Plan Width": 357, + "Actual Startup Time": 20319.736, + "Actual Total Time": 20319.736, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_7029_chunk._ts_meta_count", "compress_hyper_18_7029_chunk._ts_meta_sequence_num", "compress_hyper_18_7029_chunk.auditid", "compress_hyper_18_7029_chunk._ts_meta_v2_min_userid", "compress_hyper_18_7029_chunk._ts_meta_v2_max_userid", "compress_hyper_18_7029_chunk.userid", "compress_hyper_18_7029_chunk.username", "compress_hyper_18_7029_chunk._ts_meta_min_1", "compress_hyper_18_7029_chunk._ts_meta_max_1", "compress_hyper_18_7029_chunk.clock", "compress_hyper_18_7029_chunk._ts_meta_v2_min_ip", "compress_hyper_18_7029_chunk._ts_meta_v2_max_ip", "compress_hyper_18_7029_chunk.ip", "compress_hyper_18_7029_chunk.action", "compress_hyper_18_7029_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_7029_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_7029_chunk.resourcetype", "compress_hyper_18_7029_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_7029_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_7029_chunk.resourceid", "compress_hyper_18_7029_chunk.resource_cuid", "compress_hyper_18_7029_chunk.resourcename", "compress_hyper_18_7029_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_7029_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_7029_chunk.recordsetid", "compress_hyper_18_7029_chunk.details"],+ "Filter": "((compress_hyper_18_7029_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_7029_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 9150598, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 1124732, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 18189.064, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6885_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_42", + "Startup Cost": 55168.30, + "Total Cost": 662019.63, + "Plan Rows": 12000, + "Plan Width": 1026, + "Actual Startup Time": 15368.037, + "Actual Total Time": 15368.039, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_42.auditid", "a_42.userid", "a_42.username", "a_42.clock", "a_42.action", "a_42.resourcetype", "a_42.ip", "a_42.resourceid", "a_42.resourcename", "a_42.details", "a_42.recordsetid"], + "Vectorized Filter": "((a_42.clock >= 1735654733) AND (a_42.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 118611, + "Shared Read Blocks": 523633, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 12099.573, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_7015_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_7015_chunk", + "Startup Cost": 0.00, + "Total Cost": 662019.63, + "Plan Rows": 12, + "Plan Width": 357, + "Actual Startup Time": 15368.035, + "Actual Total Time": 15368.035, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_7015_chunk._ts_meta_count", "compress_hyper_18_7015_chunk._ts_meta_sequence_num", "compress_hyper_18_7015_chunk.auditid", "compress_hyper_18_7015_chunk._ts_meta_v2_min_userid", "compress_hyper_18_7015_chunk._ts_meta_v2_max_userid", "compress_hyper_18_7015_chunk.userid", "compress_hyper_18_7015_chunk.username", "compress_hyper_18_7015_chunk._ts_meta_min_1", "compress_hyper_18_7015_chunk._ts_meta_max_1", "compress_hyper_18_7015_chunk.clock", "compress_hyper_18_7015_chunk._ts_meta_v2_min_ip", "compress_hyper_18_7015_chunk._ts_meta_v2_max_ip", "compress_hyper_18_7015_chunk.ip", "compress_hyper_18_7015_chunk.action", "compress_hyper_18_7015_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_7015_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_7015_chunk.resourcetype", "compress_hyper_18_7015_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_7015_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_7015_chunk.resourceid", "compress_hyper_18_7015_chunk.resource_cuid", "compress_hyper_18_7015_chunk.resourcename", "compress_hyper_18_7015_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_7015_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_7015_chunk.recordsetid", "compress_hyper_18_7015_chunk.details"],+ "Filter": "((compress_hyper_18_7015_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_7015_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 5274082, + "Shared Hit Blocks": 118611, + "Shared Read Blocks": 523633, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 12099.573, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6887_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_46", + "Startup Cost": 55149.42, + "Total Cost": 1268436.73, + "Plan Rows": 23000, + "Plan Width": 1026, + "Actual Startup Time": 21388.586, + "Actual Total Time": 21388.588, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_46.auditid", "a_46.userid", "a_46.username", "a_46.clock", "a_46.action", "a_46.resourcetype", "a_46.ip", "a_46.resourceid", "a_46.resourcename", "a_46.details", "a_46.recordsetid"], + "Vectorized Filter": "((a_46.clock >= 1735654733) AND (a_46.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 1378, + "Shared Read Blocks": 1229694, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 19043.410, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_7017_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_7017_chunk", + "Startup Cost": 0.00, + "Total Cost": 1268436.73, + "Plan Rows": 23, + "Plan Width": 357, + "Actual Startup Time": 21388.584, + "Actual Total Time": 21388.584, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_7017_chunk._ts_meta_count", "compress_hyper_18_7017_chunk._ts_meta_sequence_num", "compress_hyper_18_7017_chunk.auditid", "compress_hyper_18_7017_chunk._ts_meta_v2_min_userid", "compress_hyper_18_7017_chunk._ts_meta_v2_max_userid", "compress_hyper_18_7017_chunk.userid", "compress_hyper_18_7017_chunk.username", "compress_hyper_18_7017_chunk._ts_meta_min_1", "compress_hyper_18_7017_chunk._ts_meta_max_1", "compress_hyper_18_7017_chunk.clock", "compress_hyper_18_7017_chunk._ts_meta_v2_min_ip", "compress_hyper_18_7017_chunk._ts_meta_v2_max_ip", "compress_hyper_18_7017_chunk.ip", "compress_hyper_18_7017_chunk.action", "compress_hyper_18_7017_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_7017_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_7017_chunk.resourcetype", "compress_hyper_18_7017_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_7017_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_7017_chunk.resourceid", "compress_hyper_18_7017_chunk.resource_cuid", "compress_hyper_18_7017_chunk.resourcename", "compress_hyper_18_7017_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_7017_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_7017_chunk.recordsetid", "compress_hyper_18_7017_chunk.details"],+ "Filter": "((compress_hyper_18_7017_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_7017_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 9966141, + "Shared Hit Blocks": 1378, + "Shared Read Blocks": 1229694, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 19043.410, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6900_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_48", + "Startup Cost": 54979.73, + "Total Cost": 1154574.39, + "Plan Rows": 21000, + "Plan Width": 1026, + "Actual Startup Time": 19744.218, + "Actual Total Time": 19744.220, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_48.auditid", "a_48.userid", "a_48.username", "a_48.clock", "a_48.action", "a_48.resourcetype", "a_48.ip", "a_48.resourceid", "a_48.resourcename", "a_48.details", "a_48.recordsetid"], + "Vectorized Filter": "((a_48.clock >= 1735654733) AND (a_48.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 908, + "Shared Read Blocks": 1119441, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 17519.377, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_7030_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_7030_chunk", + "Startup Cost": 0.00, + "Total Cost": 1154574.39, + "Plan Rows": 21, + "Plan Width": 357, + "Actual Startup Time": 19744.216, + "Actual Total Time": 19744.216, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_7030_chunk._ts_meta_count", "compress_hyper_18_7030_chunk._ts_meta_sequence_num", "compress_hyper_18_7030_chunk.auditid", "compress_hyper_18_7030_chunk._ts_meta_v2_min_userid", "compress_hyper_18_7030_chunk._ts_meta_v2_max_userid", "compress_hyper_18_7030_chunk.userid", "compress_hyper_18_7030_chunk.username", "compress_hyper_18_7030_chunk._ts_meta_min_1", "compress_hyper_18_7030_chunk._ts_meta_max_1", "compress_hyper_18_7030_chunk.clock", "compress_hyper_18_7030_chunk._ts_meta_v2_min_ip", "compress_hyper_18_7030_chunk._ts_meta_v2_max_ip", "compress_hyper_18_7030_chunk.ip", "compress_hyper_18_7030_chunk.action", "compress_hyper_18_7030_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_7030_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_7030_chunk.resourcetype", "compress_hyper_18_7030_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_7030_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_7030_chunk.resourceid", "compress_hyper_18_7030_chunk.resource_cuid", "compress_hyper_18_7030_chunk.resourcename", "compress_hyper_18_7030_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_7030_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_7030_chunk.recordsetid", "compress_hyper_18_7030_chunk.details"],+ "Filter": "((compress_hyper_18_7030_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_7030_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 9127791, + "Shared Hit Blocks": 908, + "Shared Read Blocks": 1119441, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 17519.377, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6920_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_44", + "Startup Cost": 54824.63, + "Total Cost": 1315791.18, + "Plan Rows": 24000, + "Plan Width": 1026, + "Actual Startup Time": 20852.223, + "Actual Total Time": 20852.224, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_44.auditid", "a_44.userid", "a_44.username", "a_44.clock", "a_44.action", "a_44.resourcetype", "a_44.ip", "a_44.resourceid", "a_44.resourcename", "a_44.details", "a_44.recordsetid"], + "Vectorized Filter": "((a_44.clock >= 1735654733) AND (a_44.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 2502, + "Shared Read Blocks": 1274302, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 18351.845, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_7051_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_7051_chunk", + "Startup Cost": 0.00, + "Total Cost": 1315791.18, + "Plan Rows": 24, + "Plan Width": 357, + "Actual Startup Time": 20852.219, + "Actual Total Time": 20852.220, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_7051_chunk._ts_meta_count", "compress_hyper_18_7051_chunk._ts_meta_sequence_num", "compress_hyper_18_7051_chunk.auditid", "compress_hyper_18_7051_chunk._ts_meta_v2_min_userid", "compress_hyper_18_7051_chunk._ts_meta_v2_max_userid", "compress_hyper_18_7051_chunk.userid", "compress_hyper_18_7051_chunk.username", "compress_hyper_18_7051_chunk._ts_meta_min_1", "compress_hyper_18_7051_chunk._ts_meta_max_1", "compress_hyper_18_7051_chunk.clock", "compress_hyper_18_7051_chunk._ts_meta_v2_min_ip", "compress_hyper_18_7051_chunk._ts_meta_v2_max_ip", "compress_hyper_18_7051_chunk.ip", "compress_hyper_18_7051_chunk.action", "compress_hyper_18_7051_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_7051_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_7051_chunk.resourcetype", "compress_hyper_18_7051_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_7051_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_7051_chunk.resourceid", "compress_hyper_18_7051_chunk.resource_cuid", "compress_hyper_18_7051_chunk.resourcename", "compress_hyper_18_7051_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_7051_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_7051_chunk.recordsetid", "compress_hyper_18_7051_chunk.details"],+ "Filter": "((compress_hyper_18_7051_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_7051_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 10397612, + "Shared Hit Blocks": 2502, + "Shared Read Blocks": 1274302, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 18351.845, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6924_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_43", + "Startup Cost": 54600.94, + "Total Cost": 1310422.68, + "Plan Rows": 24000, + "Plan Width": 1026, + "Actual Startup Time": 5777.091, + "Actual Total Time": 5777.092, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_43.auditid", "a_43.userid", "a_43.username", "a_43.clock", "a_43.action", "a_43.resourcetype", "a_43.ip", "a_43.resourceid", "a_43.resourcename", "a_43.details", "a_43.recordsetid"], + "Vectorized Filter": "((a_43.clock >= 1735654733) AND (a_43.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 1043, + "Shared Read Blocks": 1270551, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 3877.417, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_7065_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_7065_chunk", + "Startup Cost": 0.00, + "Total Cost": 1310422.68, + "Plan Rows": 24, + "Plan Width": 357, + "Actual Startup Time": 5777.088, + "Actual Total Time": 5777.088, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_7065_chunk._ts_meta_count", "compress_hyper_18_7065_chunk._ts_meta_sequence_num", "compress_hyper_18_7065_chunk.auditid", "compress_hyper_18_7065_chunk._ts_meta_v2_min_userid", "compress_hyper_18_7065_chunk._ts_meta_v2_max_userid", "compress_hyper_18_7065_chunk.userid", "compress_hyper_18_7065_chunk.username", "compress_hyper_18_7065_chunk._ts_meta_min_1", "compress_hyper_18_7065_chunk._ts_meta_max_1", "compress_hyper_18_7065_chunk.clock", "compress_hyper_18_7065_chunk._ts_meta_v2_min_ip", "compress_hyper_18_7065_chunk._ts_meta_v2_max_ip", "compress_hyper_18_7065_chunk.ip", "compress_hyper_18_7065_chunk.action", "compress_hyper_18_7065_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_7065_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_7065_chunk.resourcetype", "compress_hyper_18_7065_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_7065_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_7065_chunk.resourceid", "compress_hyper_18_7065_chunk.resource_cuid", "compress_hyper_18_7065_chunk.resourcename", "compress_hyper_18_7065_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_7065_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_7065_chunk.recordsetid", "compress_hyper_18_7065_chunk.details"],+ "Filter": "((compress_hyper_18_7065_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_7065_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 10354983, + "Shared Hit Blocks": 1043, + "Shared Read Blocks": 1270551, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 3877.417, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6874_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_15", + "Startup Cost": 54174.38, + "Total Cost": 108348.76, + "Plan Rows": 2000, + "Plan Width": 1026, + "Actual Startup Time": 2897.199, + "Actual Total Time": 2897.202, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_15.auditid", "a_15.userid", "a_15.username", "a_15.clock", "a_15.action", "a_15.resourcetype", "a_15.ip", "a_15.resourceid", "a_15.resourcename", "a_15.details", "a_15.recordsetid"], + "Vectorized Filter": "((a_15.clock >= 1735654733) AND (a_15.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 74047, + "Shared Read Blocks": 30878, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 846.642, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_7004_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_7004_chunk", + "Startup Cost": 0.00, + "Total Cost": 108348.76, + "Plan Rows": 2, + "Plan Width": 357, + "Actual Startup Time": 2897.196, + "Actual Total Time": 2897.197, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_7004_chunk._ts_meta_count", "compress_hyper_18_7004_chunk._ts_meta_sequence_num", "compress_hyper_18_7004_chunk.auditid", "compress_hyper_18_7004_chunk._ts_meta_v2_min_userid", "compress_hyper_18_7004_chunk._ts_meta_v2_max_userid", "compress_hyper_18_7004_chunk.userid", "compress_hyper_18_7004_chunk.username", "compress_hyper_18_7004_chunk._ts_meta_min_1", "compress_hyper_18_7004_chunk._ts_meta_max_1", "compress_hyper_18_7004_chunk.clock", "compress_hyper_18_7004_chunk._ts_meta_v2_min_ip", "compress_hyper_18_7004_chunk._ts_meta_v2_max_ip", "compress_hyper_18_7004_chunk.ip", "compress_hyper_18_7004_chunk.action", "compress_hyper_18_7004_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_7004_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_7004_chunk.resourcetype", "compress_hyper_18_7004_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_7004_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_7004_chunk.resourceid", "compress_hyper_18_7004_chunk.resource_cuid", "compress_hyper_18_7004_chunk.resourcename", "compress_hyper_18_7004_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_7004_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_7004_chunk.recordsetid", "compress_hyper_18_7004_chunk.details"],+ "Filter": "((compress_hyper_18_7004_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_7004_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 913003, + "Shared Hit Blocks": 74047, + "Shared Read Blocks": 30878, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 846.642, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6873_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_16", + "Startup Cost": 51032.10, + "Total Cost": 102064.20, + "Plan Rows": 2000, + "Plan Width": 1026, + "Actual Startup Time": 2858.821, + "Actual Total Time": 2858.822, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_16.auditid", "a_16.userid", "a_16.username", "a_16.clock", "a_16.action", "a_16.resourcetype", "a_16.ip", "a_16.resourceid", "a_16.resourcename", "a_16.details", "a_16.recordsetid"], + "Vectorized Filter": "((a_16.clock >= 1735654733) AND (a_16.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 98832, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 2616.882, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_7003_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_7003_chunk", + "Startup Cost": 0.00, + "Total Cost": 102064.20, + "Plan Rows": 2, + "Plan Width": 357, + "Actual Startup Time": 2858.819, + "Actual Total Time": 2858.819, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_7003_chunk._ts_meta_count", "compress_hyper_18_7003_chunk._ts_meta_sequence_num", "compress_hyper_18_7003_chunk.auditid", "compress_hyper_18_7003_chunk._ts_meta_v2_min_userid", "compress_hyper_18_7003_chunk._ts_meta_v2_max_userid", "compress_hyper_18_7003_chunk.userid", "compress_hyper_18_7003_chunk.username", "compress_hyper_18_7003_chunk._ts_meta_min_1", "compress_hyper_18_7003_chunk._ts_meta_max_1", "compress_hyper_18_7003_chunk.clock", "compress_hyper_18_7003_chunk._ts_meta_v2_min_ip", "compress_hyper_18_7003_chunk._ts_meta_v2_max_ip", "compress_hyper_18_7003_chunk.ip", "compress_hyper_18_7003_chunk.action", "compress_hyper_18_7003_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_7003_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_7003_chunk.resourcetype", "compress_hyper_18_7003_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_7003_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_7003_chunk.resourceid", "compress_hyper_18_7003_chunk.resource_cuid", "compress_hyper_18_7003_chunk.resourcename", "compress_hyper_18_7003_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_7003_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_7003_chunk.recordsetid", "compress_hyper_18_7003_chunk.details"],+ "Filter": "((compress_hyper_18_7003_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_7003_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 861921, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 98832, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 2616.882, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6901_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_34", + "Startup Cost": 47744.53, + "Total Cost": 95489.05, + "Plan Rows": 2000, + "Plan Width": 1026, + "Actual Startup Time": 2845.916, + "Actual Total Time": 2845.917, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_34.auditid", "a_34.userid", "a_34.username", "a_34.clock", "a_34.action", "a_34.resourcetype", "a_34.ip", "a_34.resourceid", "a_34.resourcename", "a_34.details", "a_34.recordsetid"], + "Vectorized Filter": "((a_34.clock >= 1735654733) AND (a_34.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 92466, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 2631.948, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_7031_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_7031_chunk", + "Startup Cost": 0.00, + "Total Cost": 95489.05, + "Plan Rows": 2, + "Plan Width": 357, + "Actual Startup Time": 2845.914, + "Actual Total Time": 2845.914, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_7031_chunk._ts_meta_count", "compress_hyper_18_7031_chunk._ts_meta_sequence_num", "compress_hyper_18_7031_chunk.auditid", "compress_hyper_18_7031_chunk._ts_meta_v2_min_userid", "compress_hyper_18_7031_chunk._ts_meta_v2_max_userid", "compress_hyper_18_7031_chunk.userid", "compress_hyper_18_7031_chunk.username", "compress_hyper_18_7031_chunk._ts_meta_min_1", "compress_hyper_18_7031_chunk._ts_meta_max_1", "compress_hyper_18_7031_chunk.clock", "compress_hyper_18_7031_chunk._ts_meta_v2_min_ip", "compress_hyper_18_7031_chunk._ts_meta_v2_max_ip", "compress_hyper_18_7031_chunk.ip", "compress_hyper_18_7031_chunk.action", "compress_hyper_18_7031_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_7031_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_7031_chunk.resourcetype", "compress_hyper_18_7031_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_7031_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_7031_chunk.resourceid", "compress_hyper_18_7031_chunk.resource_cuid", "compress_hyper_18_7031_chunk.resourcename", "compress_hyper_18_7031_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_7031_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_7031_chunk.recordsetid", "compress_hyper_18_7031_chunk.details"],+ "Filter": "((compress_hyper_18_7031_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_7031_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 806147, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 92466, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 2631.948, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6898_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_35", + "Startup Cost": 47627.06, + "Total Cost": 95254.11, + "Plan Rows": 2000, + "Plan Width": 1026, + "Actual Startup Time": 2452.174, + "Actual Total Time": 2452.176, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_35.auditid", "a_35.userid", "a_35.username", "a_35.clock", "a_35.action", "a_35.resourcetype", "a_35.ip", "a_35.resourceid", "a_35.resourcename", "a_35.details", "a_35.recordsetid"], + "Vectorized Filter": "((a_35.clock >= 1735654733) AND (a_35.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 92290, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 2229.624, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_7028_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_7028_chunk", + "Startup Cost": 0.00, + "Total Cost": 95254.11, + "Plan Rows": 2, + "Plan Width": 357, + "Actual Startup Time": 2452.173, + "Actual Total Time": 2452.173, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_7028_chunk._ts_meta_count", "compress_hyper_18_7028_chunk._ts_meta_sequence_num", "compress_hyper_18_7028_chunk.auditid", "compress_hyper_18_7028_chunk._ts_meta_v2_min_userid", "compress_hyper_18_7028_chunk._ts_meta_v2_max_userid", "compress_hyper_18_7028_chunk.userid", "compress_hyper_18_7028_chunk.username", "compress_hyper_18_7028_chunk._ts_meta_min_1", "compress_hyper_18_7028_chunk._ts_meta_max_1", "compress_hyper_18_7028_chunk.clock", "compress_hyper_18_7028_chunk._ts_meta_v2_min_ip", "compress_hyper_18_7028_chunk._ts_meta_v2_max_ip", "compress_hyper_18_7028_chunk.ip", "compress_hyper_18_7028_chunk.action", "compress_hyper_18_7028_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_7028_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_7028_chunk.resourcetype", "compress_hyper_18_7028_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_7028_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_7028_chunk.resourceid", "compress_hyper_18_7028_chunk.resource_cuid", "compress_hyper_18_7028_chunk.resourcename", "compress_hyper_18_7028_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_7028_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_7028_chunk.recordsetid", "compress_hyper_18_7028_chunk.details"],+ "Filter": "((compress_hyper_18_7028_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_7028_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 790430, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 92290, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 2229.624, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6880_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_6", + "Startup Cost": 35363.26, + "Total Cost": 35363.26, + "Plan Rows": 1000, + "Plan Width": 1026, + "Actual Startup Time": 877.442, + "Actual Total Time": 877.444, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_6.auditid", "a_6.userid", "a_6.username", "a_6.clock", "a_6.action", "a_6.resourcetype", "a_6.ip", "a_6.resourceid", "a_6.resourcename", "a_6.details", "a_6.recordsetid"], + "Vectorized Filter": "((a_6.clock >= 1735654733) AND (a_6.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 34378, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 800.929, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_7010_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_7010_chunk", + "Startup Cost": 0.00, + "Total Cost": 35363.26, + "Plan Rows": 1, + "Plan Width": 357, + "Actual Startup Time": 877.440, + "Actual Total Time": 877.440, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_7010_chunk._ts_meta_count", "compress_hyper_18_7010_chunk._ts_meta_sequence_num", "compress_hyper_18_7010_chunk.auditid", "compress_hyper_18_7010_chunk._ts_meta_v2_min_userid", "compress_hyper_18_7010_chunk._ts_meta_v2_max_userid", "compress_hyper_18_7010_chunk.userid", "compress_hyper_18_7010_chunk.username", "compress_hyper_18_7010_chunk._ts_meta_min_1", "compress_hyper_18_7010_chunk._ts_meta_max_1", "compress_hyper_18_7010_chunk.clock", "compress_hyper_18_7010_chunk._ts_meta_v2_min_ip", "compress_hyper_18_7010_chunk._ts_meta_v2_max_ip", "compress_hyper_18_7010_chunk.ip", "compress_hyper_18_7010_chunk.action", "compress_hyper_18_7010_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_7010_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_7010_chunk.resourcetype", "compress_hyper_18_7010_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_7010_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_7010_chunk.resourceid", "compress_hyper_18_7010_chunk.resource_cuid", "compress_hyper_18_7010_chunk.resourcename", "compress_hyper_18_7010_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_7010_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_7010_chunk.recordsetid", "compress_hyper_18_7010_chunk.details"],+ "Filter": "((compress_hyper_18_7010_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_7010_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 262736, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 34378, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 800.929, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6879_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_9", + "Startup Cost": 34365.16, + "Total Cost": 34365.16, + "Plan Rows": 1000, + "Plan Width": 1026, + "Actual Startup Time": 666.269, + "Actual Total Time": 666.270, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_9.auditid", "a_9.userid", "a_9.username", "a_9.clock", "a_9.action", "a_9.resourcetype", "a_9.ip", "a_9.resourceid", "a_9.resourcename", "a_9.details", "a_9.recordsetid"], + "Vectorized Filter": "((a_9.clock >= 1735654733) AND (a_9.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 33431, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 593.642, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_7009_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_7009_chunk", + "Startup Cost": 0.00, + "Total Cost": 34365.16, + "Plan Rows": 1, + "Plan Width": 357, + "Actual Startup Time": 666.267, + "Actual Total Time": 666.267, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_7009_chunk._ts_meta_count", "compress_hyper_18_7009_chunk._ts_meta_sequence_num", "compress_hyper_18_7009_chunk.auditid", "compress_hyper_18_7009_chunk._ts_meta_v2_min_userid", "compress_hyper_18_7009_chunk._ts_meta_v2_max_userid", "compress_hyper_18_7009_chunk.userid", "compress_hyper_18_7009_chunk.username", "compress_hyper_18_7009_chunk._ts_meta_min_1", "compress_hyper_18_7009_chunk._ts_meta_max_1", "compress_hyper_18_7009_chunk.clock", "compress_hyper_18_7009_chunk._ts_meta_v2_min_ip", "compress_hyper_18_7009_chunk._ts_meta_v2_max_ip", "compress_hyper_18_7009_chunk.ip", "compress_hyper_18_7009_chunk.action", "compress_hyper_18_7009_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_7009_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_7009_chunk.resourcetype", "compress_hyper_18_7009_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_7009_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_7009_chunk.resourceid", "compress_hyper_18_7009_chunk.resource_cuid", "compress_hyper_18_7009_chunk.resourcename", "compress_hyper_18_7009_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_7009_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_7009_chunk.recordsetid", "compress_hyper_18_7009_chunk.details"],+ "Filter": "((compress_hyper_18_7009_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_7009_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 249110, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 33431, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 593.642, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6888_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_10", + "Startup Cost": 33822.71, + "Total Cost": 33822.71, + "Plan Rows": 1000, + "Plan Width": 1026, + "Actual Startup Time": 661.662, + "Actual Total Time": 661.664, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_10.auditid", "a_10.userid", "a_10.username", "a_10.clock", "a_10.action", "a_10.resourcetype", "a_10.ip", "a_10.resourceid", "a_10.resourcename", "a_10.details", "a_10.recordsetid"], + "Vectorized Filter": "((a_10.clock >= 1735654733) AND (a_10.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 32898, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 590.015, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_7018_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_7018_chunk", + "Startup Cost": 0.00, + "Total Cost": 33822.71, + "Plan Rows": 1, + "Plan Width": 357, + "Actual Startup Time": 661.661, + "Actual Total Time": 661.661, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_7018_chunk._ts_meta_count", "compress_hyper_18_7018_chunk._ts_meta_sequence_num", "compress_hyper_18_7018_chunk.auditid", "compress_hyper_18_7018_chunk._ts_meta_v2_min_userid", "compress_hyper_18_7018_chunk._ts_meta_v2_max_userid", "compress_hyper_18_7018_chunk.userid", "compress_hyper_18_7018_chunk.username", "compress_hyper_18_7018_chunk._ts_meta_min_1", "compress_hyper_18_7018_chunk._ts_meta_max_1", "compress_hyper_18_7018_chunk.clock", "compress_hyper_18_7018_chunk._ts_meta_v2_min_ip", "compress_hyper_18_7018_chunk._ts_meta_v2_max_ip", "compress_hyper_18_7018_chunk.ip", "compress_hyper_18_7018_chunk.action", "compress_hyper_18_7018_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_7018_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_7018_chunk.resourcetype", "compress_hyper_18_7018_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_7018_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_7018_chunk.resourceid", "compress_hyper_18_7018_chunk.resource_cuid", "compress_hyper_18_7018_chunk.resourcename", "compress_hyper_18_7018_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_7018_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_7018_chunk.recordsetid", "compress_hyper_18_7018_chunk.details"],+ "Filter": "((compress_hyper_18_7018_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_7018_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 246589, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 32898, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 590.015, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6891_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_8", + "Startup Cost": 33375.42, + "Total Cost": 33375.42, + "Plan Rows": 1000, + "Plan Width": 1026, + "Actual Startup Time": 762.901, + "Actual Total Time": 762.902, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_8.auditid", "a_8.userid", "a_8.username", "a_8.clock", "a_8.action", "a_8.resourcetype", "a_8.ip", "a_8.resourceid", "a_8.resourcename", "a_8.details", "a_8.recordsetid"], + "Vectorized Filter": "((a_8.clock >= 1735654733) AND (a_8.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 32455, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 681.201, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_7021_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_7021_chunk", + "Startup Cost": 0.00, + "Total Cost": 33375.42, + "Plan Rows": 1, + "Plan Width": 357, + "Actual Startup Time": 762.899, + "Actual Total Time": 762.899, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_7021_chunk._ts_meta_count", "compress_hyper_18_7021_chunk._ts_meta_sequence_num", "compress_hyper_18_7021_chunk.auditid", "compress_hyper_18_7021_chunk._ts_meta_v2_min_userid", "compress_hyper_18_7021_chunk._ts_meta_v2_max_userid", "compress_hyper_18_7021_chunk.userid", "compress_hyper_18_7021_chunk.username", "compress_hyper_18_7021_chunk._ts_meta_min_1", "compress_hyper_18_7021_chunk._ts_meta_max_1", "compress_hyper_18_7021_chunk.clock", "compress_hyper_18_7021_chunk._ts_meta_v2_min_ip", "compress_hyper_18_7021_chunk._ts_meta_v2_max_ip", "compress_hyper_18_7021_chunk.ip", "compress_hyper_18_7021_chunk.action", "compress_hyper_18_7021_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_7021_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_7021_chunk.resourcetype", "compress_hyper_18_7021_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_7021_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_7021_chunk.resourceid", "compress_hyper_18_7021_chunk.resource_cuid", "compress_hyper_18_7021_chunk.resourcename", "compress_hyper_18_7021_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_7021_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_7021_chunk.recordsetid", "compress_hyper_18_7021_chunk.details"],+ "Filter": "((compress_hyper_18_7021_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_7021_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 245446, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 32455, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 681.201, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6975_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_4", + "Startup Cost": 33258.53, + "Total Cost": 33258.53, + "Plan Rows": 1000, + "Plan Width": 628, + "Actual Startup Time": 206.722, + "Actual Total Time": 206.723, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_4.auditid", "a_4.userid", "a_4.username", "a_4.clock", "a_4.action", "a_4.resourcetype", "a_4.ip", "a_4.resourceid", "a_4.resourcename", "a_4.details", "a_4.recordsetid"], + "Vectorized Filter": "((a_4.clock >= 1735654733) AND (a_4.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 32341, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 138.308, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_18_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_18_chunk", + "Startup Cost": 0.00, + "Total Cost": 33258.53, + "Plan Rows": 1, + "Plan Width": 357, + "Actual Startup Time": 206.720, + "Actual Total Time": 206.720, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_18_chunk._ts_meta_count", "compress_hyper_18_18_chunk.auditid", "compress_hyper_18_18_chunk._ts_meta_v2_min_userid", "compress_hyper_18_18_chunk._ts_meta_v2_max_userid", "compress_hyper_18_18_chunk.userid", "compress_hyper_18_18_chunk.username", "compress_hyper_18_18_chunk._ts_meta_min_1", "compress_hyper_18_18_chunk._ts_meta_max_1", "compress_hyper_18_18_chunk.clock", "compress_hyper_18_18_chunk._ts_meta_v2_min_ip", "compress_hyper_18_18_chunk._ts_meta_v2_max_ip", "compress_hyper_18_18_chunk.ip", "compress_hyper_18_18_chunk.action", "compress_hyper_18_18_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_18_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_18_chunk.resourcetype", "compress_hyper_18_18_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_18_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_18_chunk.resourceid", "compress_hyper_18_18_chunk.resource_cuid", "compress_hyper_18_18_chunk.resourcename", "compress_hyper_18_18_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_18_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_18_chunk.recordsetid", "compress_hyper_18_18_chunk.details"], + "Filter": "((compress_hyper_18_18_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_18_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 244674, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 32341, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 138.308, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6895_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_5", + "Startup Cost": 32193.56, + "Total Cost": 32193.56, + "Plan Rows": 1000, + "Plan Width": 1026, + "Actual Startup Time": 1521.625, + "Actual Total Time": 1521.627, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_5.auditid", "a_5.userid", "a_5.username", "a_5.clock", "a_5.action", "a_5.resourcetype", "a_5.ip", "a_5.resourceid", "a_5.resourcename", "a_5.details", "a_5.recordsetid"], + "Vectorized Filter": "((a_5.clock >= 1735654733) AND (a_5.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 31309, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 1442.756, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_7025_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_7025_chunk", + "Startup Cost": 0.00, + "Total Cost": 32193.56, + "Plan Rows": 1, + "Plan Width": 357, + "Actual Startup Time": 1521.624, + "Actual Total Time": 1521.624, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_7025_chunk._ts_meta_count", "compress_hyper_18_7025_chunk._ts_meta_sequence_num", "compress_hyper_18_7025_chunk.auditid", "compress_hyper_18_7025_chunk._ts_meta_v2_min_userid", "compress_hyper_18_7025_chunk._ts_meta_v2_max_userid", "compress_hyper_18_7025_chunk.userid", "compress_hyper_18_7025_chunk.username", "compress_hyper_18_7025_chunk._ts_meta_min_1", "compress_hyper_18_7025_chunk._ts_meta_max_1", "compress_hyper_18_7025_chunk.clock", "compress_hyper_18_7025_chunk._ts_meta_v2_min_ip", "compress_hyper_18_7025_chunk._ts_meta_v2_max_ip", "compress_hyper_18_7025_chunk.ip", "compress_hyper_18_7025_chunk.action", "compress_hyper_18_7025_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_7025_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_7025_chunk.resourcetype", "compress_hyper_18_7025_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_7025_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_7025_chunk.resourceid", "compress_hyper_18_7025_chunk.resource_cuid", "compress_hyper_18_7025_chunk.resourcename", "compress_hyper_18_7025_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_7025_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_7025_chunk.recordsetid", "compress_hyper_18_7025_chunk.details"],+ "Filter": "((compress_hyper_18_7025_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_7025_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 235883, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 31309, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 1442.756, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_6893_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_7", + "Startup Cost": 31861.24, + "Total Cost": 31861.24, + "Plan Rows": 1000, + "Plan Width": 1026, + "Actual Startup Time": 1320.165, + "Actual Total Time": 1320.166, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_7.auditid", "a_7.userid", "a_7.username", "a_7.clock", "a_7.action", "a_7.resourcetype", "a_7.ip", "a_7.resourceid", "a_7.resourcename", "a_7.details", "a_7.recordsetid"], + "Vectorized Filter": "((a_7.clock >= 1735654733) AND (a_7.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 30989, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 1249.369, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_7023_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_7023_chunk", + "Startup Cost": 0.00, + "Total Cost": 31861.24, + "Plan Rows": 1, + "Plan Width": 357, + "Actual Startup Time": 1320.162, + "Actual Total Time": 1320.162, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_7023_chunk._ts_meta_count", "compress_hyper_18_7023_chunk._ts_meta_sequence_num", "compress_hyper_18_7023_chunk.auditid", "compress_hyper_18_7023_chunk._ts_meta_v2_min_userid", "compress_hyper_18_7023_chunk._ts_meta_v2_max_userid", "compress_hyper_18_7023_chunk.userid", "compress_hyper_18_7023_chunk.username", "compress_hyper_18_7023_chunk._ts_meta_min_1", "compress_hyper_18_7023_chunk._ts_meta_max_1", "compress_hyper_18_7023_chunk.clock", "compress_hyper_18_7023_chunk._ts_meta_v2_min_ip", "compress_hyper_18_7023_chunk._ts_meta_v2_max_ip", "compress_hyper_18_7023_chunk.ip", "compress_hyper_18_7023_chunk.action", "compress_hyper_18_7023_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_7023_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_7023_chunk.resourcetype", "compress_hyper_18_7023_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_7023_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_7023_chunk.resourceid", "compress_hyper_18_7023_chunk.resource_cuid", "compress_hyper_18_7023_chunk.resourcename", "compress_hyper_18_7023_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_7023_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_7023_chunk.recordsetid", "compress_hyper_18_7023_chunk.details"],+ "Filter": "((compress_hyper_18_7023_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_7023_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 232596, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 30989, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 1249.369, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_171_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_2", + "Startup Cost": 27144.96, + "Total Cost": 27144.96, + "Plan Rows": 1000, + "Plan Width": 571, + "Actual Startup Time": 412.483, + "Actual Total Time": 412.485, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_2.auditid", "a_2.userid", "a_2.username", "a_2.clock", "a_2.action", "a_2.resourcetype", "a_2.ip", "a_2.resourceid", "a_2.resourcename", "a_2.details", "a_2.recordsetid"], + "Vectorized Filter": "((a_2.clock >= 1735654733) AND (a_2.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 26185, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 355.438, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_221_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_221_chunk", + "Startup Cost": 0.00, + "Total Cost": 27144.96, + "Plan Rows": 1, + "Plan Width": 357, + "Actual Startup Time": 412.481, + "Actual Total Time": 412.481, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_221_chunk._ts_meta_count", "compress_hyper_18_221_chunk.auditid", "compress_hyper_18_221_chunk._ts_meta_v2_min_userid", "compress_hyper_18_221_chunk._ts_meta_v2_max_userid", "compress_hyper_18_221_chunk.userid", "compress_hyper_18_221_chunk.username", "compress_hyper_18_221_chunk._ts_meta_min_1", "compress_hyper_18_221_chunk._ts_meta_max_1", "compress_hyper_18_221_chunk.clock", "compress_hyper_18_221_chunk._ts_meta_v2_min_ip", "compress_hyper_18_221_chunk._ts_meta_v2_max_ip", "compress_hyper_18_221_chunk.ip", "compress_hyper_18_221_chunk.action", "compress_hyper_18_221_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_221_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_221_chunk.resourcetype", "compress_hyper_18_221_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_221_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_221_chunk.resourceid", "compress_hyper_18_221_chunk.resource_cuid", "compress_hyper_18_221_chunk.resourcename", "compress_hyper_18_221_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_221_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_221_chunk.recordsetid", "compress_hyper_18_221_chunk.details"], + "Filter": "((compress_hyper_18_221_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_221_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 198392, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 26185, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 355.438, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Custom Scan", + "Parent Relationship": "Member", + "Custom Plan Provider": "DecompressChunk", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "_hyper_16_207_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_1", + "Startup Cost": 1605.61, + "Total Cost": 1605.61, + "Plan Rows": 1000, + "Plan Width": 590, + "Actual Startup Time": 15.163, + "Actual Total Time": 15.165, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_1.auditid", "a_1.userid", "a_1.username", "a_1.clock", "a_1.action", "a_1.resourcetype", "a_1.ip", "a_1.resourceid", "a_1.resourcename", "a_1.details", "a_1.recordsetid"], + "Vectorized Filter": "((a_1.clock >= 1735654733) AND (a_1.clock <= 1735658333))", + "Rows Removed by Filter": 0, + "Batches Removed by Filter": 0, + "Bulk Decompression": true, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 1504, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 11.962, + "I/O Write Time": 0.000, + "Workers": [ + ], + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "child", + "Parallel Aware": true, + "Async Capable": false, + "Relation Name": "compress_hyper_18_210_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_210_chunk", + "Startup Cost": 0.00, + "Total Cost": 1605.61, + "Plan Rows": 1, + "Plan Width": 357, + "Actual Startup Time": 15.161, + "Actual Total Time": 15.161, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["compress_hyper_18_210_chunk._ts_meta_count", "compress_hyper_18_210_chunk.auditid", "compress_hyper_18_210_chunk._ts_meta_v2_min_userid", "compress_hyper_18_210_chunk._ts_meta_v2_max_userid", "compress_hyper_18_210_chunk.userid", "compress_hyper_18_210_chunk.username", "compress_hyper_18_210_chunk._ts_meta_min_1", "compress_hyper_18_210_chunk._ts_meta_max_1", "compress_hyper_18_210_chunk.clock", "compress_hyper_18_210_chunk._ts_meta_v2_min_ip", "compress_hyper_18_210_chunk._ts_meta_v2_max_ip", "compress_hyper_18_210_chunk.ip", "compress_hyper_18_210_chunk.action", "compress_hyper_18_210_chunk._ts_meta_v2_min_resourcetype", "compress_hyper_18_210_chunk._ts_meta_v2_max_resourcetype", "compress_hyper_18_210_chunk.resourcetype", "compress_hyper_18_210_chunk._ts_meta_v2_min_resourceid", "compress_hyper_18_210_chunk._ts_meta_v2_max_resourceid", "compress_hyper_18_210_chunk.resourceid", "compress_hyper_18_210_chunk.resource_cuid", "compress_hyper_18_210_chunk.resourcename", "compress_hyper_18_210_chunk._ts_meta_v2_min_recordsetid", "compress_hyper_18_210_chunk._ts_meta_v2_max_recordsetid", "compress_hyper_18_210_chunk.recordsetid", "compress_hyper_18_210_chunk.details"], + "Filter": "((compress_hyper_18_210_chunk._ts_meta_max_1 >= 1735654733) AND (compress_hyper_18_210_chunk._ts_meta_min_1 <= 1735658333))", + "Rows Removed by Filter": 11516, + "Shared Hit Blocks": 0, + "Shared Read Blocks": 1504, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 11.962, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + }, + { + "Node Type": "Index Scan", + "Parent Relationship": "Member", + "Parallel Aware": true, + "Async Capable": false, + "Scan Direction": "Forward", + "Index Name": "_hyper_16_7105_chunk_auditlog_2", + "Relation Name": "_hyper_16_7105_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_3", + "Startup Cost": 0.29, + "Total Cost": 121.57, + "Plan Rows": 724, + "Plan Width": 581, + "Actual Startup Time": 4.501, + "Actual Total Time": 6.290, + "Actual Rows": 1224, + "Actual Loops": 1, + "Output": ["a_3.auditid", "a_3.userid", "a_3.username", "a_3.clock", "a_3.action", "a_3.resourcetype", "a_3.ip", "a_3.resourceid", "a_3.resourcename", "a_3.details", "a_3.recordsetid"], + "Index Cond": "((a_3.clock >= 1735654733) AND (a_3.clock <= 1735658333))", + "Rows Removed by Index Recheck": 0, + "Shared Hit Blocks": 19, + "Shared Read Blocks": 120, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 5.769, + "I/O Write Time": 0.000, + "Workers": [ + ] + }, + { + "Node Type": "Index Scan", + "Parent Relationship": "Member", + "Parallel Aware": true, + "Async Capable": false, + "Scan Direction": "Forward", + "Index Name": "_hyper_16_207_chunk_auditlog_2", + "Relation Name": "_hyper_16_207_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_1", + "Startup Cost": 0.29, + "Total Cost": 2.51, + "Plan Rows": 1, + "Plan Width": 590, + "Actual Startup Time": 0.013, + "Actual Total Time": 0.013, + "Actual Rows": 0, + "Actual Loops": 1, + "Output": ["a_1.auditid", "a_1.userid", "a_1.username", "a_1.clock", "a_1.action", "a_1.resourcetype", "a_1.ip", "a_1.resourceid", "a_1.resourcename", "a_1.details", "a_1.recordsetid"], + "Index Cond": "((a_1.clock >= 1735654733) AND (a_1.clock <= 1735658333))", + "Rows Removed by Index Recheck": 0, + "Shared Hit Blocks": 2, + "Shared Read Blocks": 0, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 0.000, + "I/O Write Time": 0.000, + "Workers": [ + ] + } + ] + } + ] + } + ] + } + ] + }, + "Query Identifier": -851584254924611179, + "Planning": { + "Shared Hit Blocks": 16727, + "Shared Read Blocks": 85, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "I/O Read Time": 50.178, + "I/O Write Time": 0.000 + }, + "Planning Time": 133.614, + "Triggers": [ + ], + "JIT": { + "Functions": 117, + "Options": { + "Inlining": true, + "Optimization": true, + "Expressions": true, + "Deforming": true + }, + "Timing": { + "Generation": 10.764, + "Inlining": 65.667, + "Optimization": 1344.117, + "Emission": 892.413, + "Total": 2312.960 + } + }, + "Execution Time": 340845.420 + } + ] (1 row)