QUERY PLAN ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [ + { + "Plan": { + "Node Type": "Limit", + "Parallel Aware": false, + "Async Capable": false, + "Startup Cost": 19842989.05, + "Total Cost": 19842991.55, + "Plan Rows": 1001, + "Plan Width": 601, + "Actual Startup Time": 311603.552, + "Actual Total Time": 311604.128, + "Actual Rows": 1001, + "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"], + "Shared Hit Blocks": 24, + "Shared Read Blocks": 19045840, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 758, + "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": 272015.492, + "I/O Write Time": 37.159, + "Plans": [ + { + "Node Type": "Sort", + "Parent Relationship": "Outer", + "Parallel Aware": false, + "Async Capable": false, + "Startup Cost": 19842989.05, + "Total Cost": 19846347.14, + "Plan Rows": 1343236, + "Plan Width": 601, + "Actual Startup Time": 309424.834, + "Actual Total Time": 309425.333, + "Actual Rows": 1001, + "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"], + "Sort Key": ["a_30.auditid DESC"], + "Sort Method": "quicksort", + "Sort Space Used": 1153, + "Sort Space Type": "Memory", + "Shared Hit Blocks": 24, + "Shared Read Blocks": 19045840, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 758, + "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": 272015.492, + "I/O Write Time": 37.159, + "Plans": [ + { + "Node Type": "Gather", + "Parent Relationship": "Outer", + "Parallel Aware": false, + "Async Capable": false, + "Startup Cost": 93571.10, + "Total Cost": 19769331.19, + "Plan Rows": 1343236, + "Plan Width": 601, + "Actual Startup Time": 8.263, + "Actual Total Time": 309423.115, + "Actual Rows": 1224, + "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"], + "Workers Planned": 4, + "Workers Launched": 0, + "Single Copy": false, + "Shared Hit Blocks": 21, + "Shared Read Blocks": 19045840, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 758, + "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": 272015.492, + "I/O Write Time": 37.159, + "Plans": [ + { + "Node Type": "Append", + "Parent Relationship": "Outer", + "Parallel Aware": true, + "Async Capable": false, + "Startup Cost": 92571.10, + "Total Cost": 19634007.59, + "Plan Rows": 345309, + "Plan Width": 600, + "Actual Startup Time": 1.300, + "Actual Total Time": 309415.685, + "Actual Rows": 1224, + "Actual Loops": 1, + "Shared Hit Blocks": 21, + "Shared Read Blocks": 19045840, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 758, + "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": 272015.492, + "I/O Write Time": 37.159, + "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_30", + "Startup Cost": 96806.88, + "Total Cost": 96806.88, + "Plan Rows": 1000, + "Plan Width": 1026, + "Actual Startup Time": 1465.600, + "Actual Total Time": 1465.603, + "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": 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": 1261.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_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": 1465.597, + "Actual Total Time": 1465.598, + "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": 1261.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_6909_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_26", + "Startup Cost": 93156.24, + "Total Cost": 93156.24, + "Plan Rows": 1000, + "Plan Width": 1026, + "Actual Startup Time": 1466.101, + "Actual Total Time": 1466.102, + "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": 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": 1261.304, + "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": 1466.098, + "Actual Total Time": 1466.099, + "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": 1261.304, + "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_29", + "Startup Cost": 92902.76, + "Total Cost": 92902.76, + "Plan Rows": 1000, + "Plan Width": 1026, + "Actual Startup Time": 1497.787, + "Actual Total Time": 1497.788, + "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": 90020, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 758, + "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": 1257.220, + "I/O Write Time": 37.159, + "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": 1497.784, + "Actual Total Time": 1497.785, + "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": 758, + "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": 1257.220, + "I/O Write Time": 37.159, + "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_37", + "Startup Cost": 92571.10, + "Total Cost": 92571.10, + "Plan Rows": 1000, + "Plan Width": 1026, + "Actual Startup Time": 1478.755, + "Actual Total Time": 1478.756, + "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": 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": 1281.097, + "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": 1478.752, + "Actual Total Time": 1478.752, + "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": 1281.097, + "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_40", + "Startup Cost": 91763.00, + "Total Cost": 91763.00, + "Plan Rows": 1000, + "Plan Width": 1026, + "Actual Startup Time": 1482.275, + "Actual Total Time": 1482.276, + "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": 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": 1292.776, + "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": 1482.272, + "Actual Total Time": 1482.272, + "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": 1292.776, + "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_36", + "Startup Cost": 91013.72, + "Total Cost": 91013.72, + "Plan Rows": 1000, + "Plan Width": 1026, + "Actual Startup Time": 1454.937, + "Actual Total Time": 1454.938, + "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": 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": 1270.627, + "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": 1454.934, + "Actual Total Time": 1454.934, + "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": 1270.627, + "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_39", + "Startup Cost": 90423.71, + "Total Cost": 90423.71, + "Plan Rows": 1000, + "Plan Width": 1026, + "Actual Startup Time": 1427.178, + "Actual Total Time": 1427.179, + "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": 87544, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "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": 1237.274, + "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_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": 1427.175, + "Actual Total Time": 1427.175, + "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": 0, + "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": 1237.274, + "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_6892_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_38", + "Startup Cost": 90338.13, + "Total Cost": 90338.13, + "Plan Rows": 1000, + "Plan Width": 1026, + "Actual Startup Time": 1437.884, + "Actual Total Time": 1437.886, + "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": 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": 1244.922, + "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": 1437.882, + "Actual Total Time": 1437.882, + "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": 1244.922, + "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_32", + "Startup Cost": 90035.41, + "Total Cost": 90035.41, + "Plan Rows": 1000, + "Plan Width": 1026, + "Actual Startup Time": 1490.410, + "Actual Total Time": 1490.411, + "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": 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": 1302.832, + "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": 1490.407, + "Actual Total Time": 1490.407, + "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": 1302.832, + "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_35", + "Startup Cost": 89137.10, + "Total Cost": 89137.10, + "Plan Rows": 1000, + "Plan Width": 1026, + "Actual Startup Time": 1465.414, + "Actual Total Time": 1465.415, + "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": 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": 1280.403, + "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": 1465.411, + "Actual Total Time": 1465.411, + "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": 1280.403, + "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_31", + "Startup Cost": 89133.67, + "Total Cost": 89133.67, + "Plan Rows": 1000, + "Plan Width": 1026, + "Actual Startup Time": 1497.473, + "Actual Total Time": 1497.474, + "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": 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": 1314.154, + "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": 1497.470, + "Actual Total Time": 1497.470, + "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": 1314.154, + "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_25", + "Startup Cost": 89044.83, + "Total Cost": 89044.83, + "Plan Rows": 1000, + "Plan Width": 1026, + "Actual Startup Time": 1509.205, + "Actual Total Time": 1509.206, + "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": 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": 1324.056, + "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": 1509.202, + "Actual Total Time": 1509.203, + "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": 1324.056, + "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_28", + "Startup Cost": 88879.05, + "Total Cost": 88879.05, + "Plan Rows": 1000, + "Plan Width": 1026, + "Actual Startup Time": 1528.422, + "Actual Total Time": 1528.423, + "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": 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": 1335.911, + "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": 1528.419, + "Actual Total Time": 1528.419, + "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": 1335.911, + "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_27", + "Startup Cost": 86715.17, + "Total Cost": 86715.17, + "Plan Rows": 1000, + "Plan Width": 1026, + "Actual Startup Time": 2471.461, + "Actual Total Time": 2471.463, + "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": 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": 2262.667, + "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": 2471.459, + "Actual Total Time": 2471.459, + "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": 2262.667, + "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_10", + "Startup Cost": 74016.28, + "Total Cost": 74016.28, + "Plan Rows": 1000, + "Plan Width": 1026, + "Actual Startup Time": 1490.764, + "Actual Total Time": 1490.765, + "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": 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": 1325.721, + "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": 1490.762, + "Actual Total Time": 1490.762, + "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": 1325.721, + "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_24", + "Startup Cost": 64438.46, + "Total Cost": 128876.91, + "Plan Rows": 2000, + "Plan Width": 1026, + "Actual Startup Time": 2360.228, + "Actual Total Time": 2360.229, + "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": 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": 2054.132, + "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": 2360.225, + "Actual Total Time": 2360.225, + "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": 2054.132, + "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_19", + "Startup Cost": 62740.29, + "Total Cost": 125480.57, + "Plan Rows": 2000, + "Plan Width": 1026, + "Actual Startup Time": 2231.038, + "Actual Total Time": 2231.039, + "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": 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": 1927.836, + "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": 2231.035, + "Actual Total Time": 2231.035, + "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": 1927.836, + "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_11", + "Startup Cost": 61827.23, + "Total Cost": 123654.46, + "Plan Rows": 2000, + "Plan Width": 1026, + "Actual Startup Time": 2077.032, + "Actual Total Time": 2077.034, + "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": 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": 1793.887, + "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": 2077.030, + "Actual Total Time": 2077.030, + "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": 1793.887, + "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_22", + "Startup Cost": 59847.96, + "Total Cost": 119695.93, + "Plan Rows": 2000, + "Plan Width": 1026, + "Actual Startup Time": 2032.086, + "Actual Total Time": 2032.087, + "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": 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": 1750.307, + "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": 2032.083, + "Actual Total Time": 2032.083, + "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": 1750.307, + "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_12", + "Startup Cost": 58446.69, + "Total Cost": 116893.38, + "Plan Rows": 2000, + "Plan Width": 1026, + "Actual Startup Time": 2000.560, + "Actual Total Time": 2000.561, + "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": 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": 1737.314, + "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": 2000.557, + "Actual Total Time": 2000.557, + "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": 1737.314, + "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_13", + "Startup Cost": 58148.63, + "Total Cost": 116297.26, + "Plan Rows": 2000, + "Plan Width": 1026, + "Actual Startup Time": 1925.629, + "Actual Total Time": 1925.630, + "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": 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": 1639.453, + "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": 1925.626, + "Actual Total Time": 1925.627, + "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": 1639.453, + "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_51", + "Startup Cost": 58100.05, + "Total Cost": 1162000.95, + "Plan Rows": 20000, + "Plan Width": 1026, + "Actual Startup Time": 17537.454, + "Actual Total Time": 17537.455, + "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": 0, + "Shared Read Blocks": 1127620, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "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": 15422.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_7050_chunk", + "Schema": "_timescaledb_internal", + "Alias": "compress_hyper_18_7050_chunk", + "Startup Cost": 0.00, + "Total Cost": 1162000.95, + "Plan Rows": 20, + "Plan Width": 357, + "Actual Startup Time": 17537.451, + "Actual Total Time": 17537.451, + "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": 0, + "Shared Read Blocks": 1127620, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "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": 15422.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_6910_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_23", + "Startup Cost": 57386.79, + "Total Cost": 114773.58, + "Plan Rows": 2000, + "Plan Width": 1026, + "Actual Startup Time": 1794.780, + "Actual Total Time": 1794.781, + "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": 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": 1526.357, + "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": 1794.777, + "Actual Total Time": 1794.778, + "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": 1526.357, + "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_18", + "Startup Cost": 57307.14, + "Total Cost": 114614.28, + "Plan Rows": 2000, + "Plan Width": 1026, + "Actual Startup Time": 1742.915, + "Actual Total Time": 1742.916, + "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": 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": 1488.001, + "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": 1742.913, + "Actual Total Time": 1742.913, + "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": 1488.001, + "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_52", + "Startup Cost": 57176.53, + "Total Cost": 1143530.53, + "Plan Rows": 20000, + "Plan Width": 1026, + "Actual Startup Time": 16941.793, + "Actual Total Time": 16941.795, + "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": 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": 14856.273, + "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": 1143530.53, + "Plan Rows": 20, + "Plan Width": 357, + "Actual Startup Time": 16941.792, + "Actual Total Time": 16941.792, + "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": 14856.273, + "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_16", + "Startup Cost": 56957.12, + "Total Cost": 113914.24, + "Plan Rows": 2000, + "Plan Width": 1026, + "Actual Startup Time": 1763.311, + "Actual Total Time": 1763.312, + "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": 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": 1505.906, + "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": 1763.309, + "Actual Total Time": 1763.309, + "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": 1505.906, + "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_20", + "Startup Cost": 56807.95, + "Total Cost": 113615.90, + "Plan Rows": 2000, + "Plan Width": 1026, + "Actual Startup Time": 1801.402, + "Actual Total Time": 1801.403, + "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": 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": 1554.408, + "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": 1801.400, + "Actual Total Time": 1801.400, + "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": 1554.408, + "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_17", + "Startup Cost": 56806.47, + "Total Cost": 113612.93, + "Plan Rows": 2000, + "Plan Width": 1026, + "Actual Startup Time": 1782.464, + "Actual Total Time": 1782.466, + "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": 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": 1532.771, + "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": 1782.463, + "Actual Total Time": 1782.463, + "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": 1532.771, + "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_50", + "Startup Cost": 56733.12, + "Total Cost": 1191395.48, + "Plan Rows": 21000, + "Plan Width": 1026, + "Actual Startup Time": 17650.207, + "Actual Total Time": 17650.209, + "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": 1156500, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "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": 15510.395, + "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": 1191395.48, + "Plan Rows": 21, + "Plan Width": 357, + "Actual Startup Time": 17650.205, + "Actual Total Time": 17650.205, + "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": 0, + "Shared Read Blocks": 1156500, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "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": 15510.395, + "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_54", + "Startup Cost": 56690.91, + "Total Cost": 1133818.18, + "Plan Rows": 20000, + "Plan Width": 1026, + "Actual Startup Time": 17553.427, + "Actual Total Time": 17553.429, + "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": 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": 15538.259, + "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": 1133818.18, + "Plan Rows": 20, + "Plan Width": 358, + "Actual Startup Time": 17553.426, + "Actual Total Time": 17553.426, + "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": 15538.259, + "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_53", + "Startup Cost": 56464.95, + "Total Cost": 1129299.00, + "Plan Rows": 20000, + "Plan Width": 1026, + "Actual Startup Time": 17675.753, + "Actual Total Time": 17675.755, + "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": 1095933, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "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": 15579.457, + "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": 1129299.00, + "Plan Rows": 20, + "Plan Width": 357, + "Actual Startup Time": 17675.751, + "Actual Total Time": 17675.751, + "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": 0, + "Shared Read Blocks": 1095933, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "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": 15579.457, + "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_49", + "Startup Cost": 55955.91, + "Total Cost": 1175074.19, + "Plan Rows": 21000, + "Plan Width": 1026, + "Actual Startup Time": 17445.997, + "Actual Total Time": 17445.999, + "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": 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": 15328.843, + "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": 1175074.19, + "Plan Rows": 21, + "Plan Width": 357, + "Actual Startup Time": 17445.995, + "Actual Total Time": 17445.995, + "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": 15328.843, + "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_21", + "Startup Cost": 55510.42, + "Total Cost": 111020.83, + "Plan Rows": 2000, + "Plan Width": 1026, + "Actual Startup Time": 1749.534, + "Actual Total Time": 1749.536, + "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": 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": 1491.413, + "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": 1749.532, + "Actual Total Time": 1749.532, + "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": 1491.413, + "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_44", + "Startup Cost": 55304.02, + "Total Cost": 1271992.39, + "Plan Rows": 23000, + "Plan Width": 1026, + "Actual Startup Time": 20103.520, + "Actual Total Time": 20103.522, + "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": 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": 17929.091, + "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": 1271992.39, + "Plan Rows": 23, + "Plan Width": 357, + "Actual Startup Time": 20103.518, + "Actual Total Time": 20103.518, + "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": 17929.091, + "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_48", + "Startup Cost": 55283.32, + "Total Cost": 1160949.73, + "Plan Rows": 21000, + "Plan Width": 1026, + "Actual Startup Time": 17923.640, + "Actual Total Time": 17923.641, + "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": 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": 15782.398, + "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": 1160949.73, + "Plan Rows": 21, + "Plan Width": 357, + "Actual Startup Time": 17923.638, + "Actual Total Time": 17923.638, + "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": 15782.398, + "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_46", + "Startup Cost": 55192.70, + "Total Cost": 1159046.74, + "Plan Rows": 21000, + "Plan Width": 1026, + "Actual Startup Time": 18303.216, + "Actual Total Time": 18303.218, + "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": 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": 16215.289, + "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.74, + "Plan Rows": 21, + "Plan Width": 357, + "Actual Startup Time": 18303.214, + "Actual Total Time": 18303.214, + "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": 16215.289, + "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_41", + "Startup Cost": 55168.23, + "Total Cost": 662018.81, + "Plan Rows": 12000, + "Plan Width": 1026, + "Actual Startup Time": 10723.160, + "Actual Total Time": 10723.161, + "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": 642244, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "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": 9142.055, + "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": 662018.81, + "Plan Rows": 12, + "Plan Width": 357, + "Actual Startup Time": 10723.158, + "Actual Total Time": 10723.158, + "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": 0, + "Shared Read Blocks": 642244, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "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": 9142.055, + "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_45", + "Startup Cost": 55150.06, + "Total Cost": 1268451.42, + "Plan Rows": 23000, + "Plan Width": 1026, + "Actual Startup Time": 20200.800, + "Actual Total Time": 20200.801, + "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": 1231072, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "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": 17905.538, + "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": 1268451.42, + "Plan Rows": 23, + "Plan Width": 357, + "Actual Startup Time": 20200.797, + "Actual Total Time": 20200.797, + "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": 0, + "Shared Read Blocks": 1231072, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "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": 17905.538, + "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_47", + "Startup Cost": 54979.67, + "Total Cost": 1154573.03, + "Plan Rows": 21000, + "Plan Width": 1026, + "Actual Startup Time": 17495.168, + "Actual Total Time": 17495.170, + "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": 1120349, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "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": 15400.937, + "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": 1154573.03, + "Plan Rows": 21, + "Plan Width": 357, + "Actual Startup Time": 17495.166, + "Actual Total Time": 17495.167, + "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": 0, + "Shared Read Blocks": 1120349, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "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": 15400.937, + "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_43", + "Startup Cost": 54824.54, + "Total Cost": 1315788.98, + "Plan Rows": 24000, + "Plan Width": 1026, + "Actual Startup Time": 20843.198, + "Actual Total Time": 20843.200, + "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": 0, + "Shared Read Blocks": 1276804, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "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": 18475.048, + "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": 1315788.98, + "Plan Rows": 24, + "Plan Width": 357, + "Actual Startup Time": 20843.196, + "Actual Total Time": 20843.196, + "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": 0, + "Shared Read Blocks": 1276804, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "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": 18475.048, + "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_42", + "Startup Cost": 54601.42, + "Total Cost": 1310434.14, + "Plan Rows": 24000, + "Plan Width": 1026, + "Actual Startup Time": 21460.094, + "Actual Total Time": 21460.095, + "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": 0, + "Shared Read Blocks": 1271594, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "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": 19115.422, + "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": 1310434.14, + "Plan Rows": 24, + "Plan Width": 357, + "Actual Startup Time": 21460.091, + "Actual Total Time": 21460.091, + "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": 0, + "Shared Read Blocks": 1271594, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "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": 19115.422, + "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_14", + "Startup Cost": 54174.38, + "Total Cost": 108348.76, + "Plan Rows": 2000, + "Plan Width": 1026, + "Actual Startup Time": 1961.135, + "Actual Total Time": 1961.137, + "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": 104925, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "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": 1701.145, + "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": 1961.133, + "Actual Total Time": 1961.134, + "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": 0, + "Shared Read Blocks": 104925, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "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": 1701.145, + "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_15", + "Startup Cost": 51032.10, + "Total Cost": 102064.20, + "Plan Rows": 2000, + "Plan Width": 1026, + "Actual Startup Time": 1745.559, + "Actual Total Time": 1745.561, + "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": 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": 1510.388, + "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": 1745.557, + "Actual Total Time": 1745.557, + "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": 1510.388, + "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_33", + "Startup Cost": 47744.53, + "Total Cost": 95489.05, + "Plan Rows": 2000, + "Plan Width": 1026, + "Actual Startup Time": 1571.900, + "Actual Total Time": 1571.901, + "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": 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": 1327.516, + "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": 1571.898, + "Actual Total Time": 1571.898, + "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": 1327.516, + "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_34", + "Startup Cost": 47627.06, + "Total Cost": 95254.11, + "Plan Rows": 2000, + "Plan Width": 1026, + "Actual Startup Time": 1506.573, + "Actual Total Time": 1506.575, + "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": 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": 1280.220, + "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": 1506.571, + "Actual Total Time": 1506.571, + "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": 1280.220, + "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_5", + "Startup Cost": 35363.26, + "Total Cost": 35363.26, + "Plan Rows": 1000, + "Plan Width": 1026, + "Actual Startup Time": 623.447, + "Actual Total Time": 623.449, + "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": 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": 535.623, + "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": 623.445, + "Actual Total Time": 623.445, + "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": 535.623, + "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_8", + "Startup Cost": 34365.16, + "Total Cost": 34365.16, + "Plan Rows": 1000, + "Plan Width": 1026, + "Actual Startup Time": 597.162, + "Actual Total Time": 597.163, + "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": 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": 515.433, + "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": 597.160, + "Actual Total Time": 597.160, + "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": 515.433, + "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_9", + "Startup Cost": 33822.71, + "Total Cost": 33822.71, + "Plan Rows": 1000, + "Plan Width": 1026, + "Actual Startup Time": 630.178, + "Actual Total Time": 630.180, + "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": 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": 534.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_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": 630.177, + "Actual Total Time": 630.177, + "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": 534.962, + "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_7", + "Startup Cost": 33375.42, + "Total Cost": 33375.42, + "Plan Rows": 1000, + "Plan Width": 1026, + "Actual Startup Time": 620.181, + "Actual Total Time": 620.182, + "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": 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": 527.311, + "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": 620.179, + "Actual Total Time": 620.179, + "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": 527.311, + "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_3", + "Startup Cost": 33258.53, + "Total Cost": 33258.53, + "Plan Rows": 1000, + "Plan Width": 628, + "Actual Startup Time": 661.063, + "Actual Total Time": 661.064, + "Actual Rows": 0, + "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"], + "Vectorized Filter": "((a_3.clock >= 1735654733) AND (a_3.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": 575.291, + "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": 661.061, + "Actual Total Time": 661.061, + "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": 575.291, + "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_4", + "Startup Cost": 32193.56, + "Total Cost": 32193.56, + "Plan Rows": 1000, + "Plan Width": 1026, + "Actual Startup Time": 583.462, + "Actual Total Time": 583.463, + "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": 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": 510.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_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": 583.460, + "Actual Total Time": 583.460, + "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": 510.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_6893_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_6", + "Startup Cost": 31861.24, + "Total Cost": 31861.24, + "Plan Rows": 1000, + "Plan Width": 1026, + "Actual Startup Time": 610.251, + "Actual Total Time": 610.252, + "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": 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": 519.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_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": 610.249, + "Actual Total Time": 610.249, + "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": 519.877, + "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_2", + "Startup Cost": 0.29, + "Total Cost": 121.65, + "Plan Rows": 726, + "Plan Width": 582, + "Actual Startup Time": 1.287, + "Actual Total Time": 22.384, + "Actual Rows": 1224, + "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"], + "Index Cond": "((a_2.clock >= 1735654733) AND (a_2.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": 21.142, + "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_171_chunk_auditlog_2", + "Relation Name": "_hyper_16_171_chunk", + "Schema": "_timescaledb_internal", + "Alias": "a_1", + "Startup Cost": 0.29, + "Total Cost": 2.51, + "Plan Rows": 1, + "Plan Width": 570, + "Actual Startup Time": 0.011, + "Actual Total Time": 0.011, + "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": 24875, + "Shared Read Blocks": 885, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "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": 247.831, + "I/O Write Time": 0.000 + }, + "Planning Time": 3381.605, + "Triggers": [ + ], + "JIT": { + "Functions": 113, + "Options": { + "Inlining": true, + "Optimization": true, + "Expressions": true, + "Deforming": true + }, + "Timing": { + "Generation": 10.508, + "Inlining": 63.126, + "Optimization": 1309.106, + "Emission": 807.693, + "Total": 2190.434 + } + }, + "Execution Time": 311649.130 + } + ] (1 row) schemaname | relname | n_live_tup | n_dead_tup | last_autovacuum -----------------------+------------------------+------------+------------+------------------------------- _timescaledb_internal | _hyper_2_6856_chunk | 134176879 | 161833 | 2025-01-03 21:06:13.89718+00 public | events | 43848574 | 113381 | 2025-01-08 12:03:42.239889+00 _timescaledb_internal | _hyper_1_6857_chunk | 42845060 | 49211 | 2025-01-04 01:03:10.565669+00 public | event_tag | 7725650 | 31201 | 2025-01-08 02:00:52.626166+00 public | alerts | 1058728 | 9369 | 2025-01-07 20:49:31.969946+00 public | event_recovery | 1511425 | 8923 | 2025-01-07 20:49:29.143687+00 public | item_rtdata | 451080 | 3721 | 2025-01-08 18:47:08.970016+00 public | functions | 350627 | 3295 | 2025-01-07 06:51:58.400502+00 public | items | 507177 | 2702 | 2025-01-08 16:18:29.021498+00 public | item_rtname | 439113 | 2528 | 2025-01-08 14:18:28.569449+00 public | item_tag | 676751 | 1836 | 2025-01-08 17:03:28.71322+00 public | graphs_items | 146180 | 935 | 2025-01-08 13:03:27.575669+00 _timescaledb_internal | _hyper_16_171_chunk | 193452 | 744 | 2025-01-08 13:33:28.959278+00 _timescaledb_internal | _hyper_6_121_chunk | 60793087 | 627 | 2024-12-30 20:04:48.800439+00 public | trigger_tag | 134823 | 573 | 2025-01-08 01:33:28.413553+00 public | triggers | 200860 | 562 | 2025-01-08 19:22:17.336368+00 public | trigger_depends | 34 | 534 | public | graphs | 50333 | 344 | 2025-01-08 12:03:27.91497+00 public | item_preproc | 297083 | 310 | 2025-01-08 18:33:27.376618+00 public | item_discovery | 568749 | 200 | 2025-01-08 19:29:21.156774+00 _timescaledb_internal | _hyper_7_122_chunk | 134195265 | 180 | 2024-12-30 20:05:29.878427+00 public | item_condition | 0 | 170 | public | profiles | 17136 | 158 | 2025-01-04 07:35:11.531478+00 public | trigger_discovery | 116566 | 141 | 2025-01-08 19:29:20.684552+00 public | hosts_groups | 1 | 141 | pg_catalog | pg_class | 9194 | 131 | 2025-01-06 00:00:03.09407+00 pg_catalog | pg_depend | 41682 | 129 | 2025-01-07 00:27:33.123024+00 pg_catalog | pg_shdepend | 6337 | 104 | 2025-01-04 00:21:07.223835+00 pg_catalog | pg_attrdef | 5260 | 95 | 2025-01-03 00:59:20.875135+00 public | hosts_templates | 0 | 93 | public | host_rtdata | 7471 | 90 | 2025-01-07 08:08:59.786556+00 pg_catalog | pg_index | 5294 | 88 | 2025-01-04 00:21:07.124681+00 public | hosts | 10753 | 81 | 2025-01-07 15:30:00.015463+00 pg_catalog | pg_type | 5013 | 80 | 2025-01-04 00:21:07.060084+00 public | interface | 7604 | 79 | 2025-01-08 19:27:23.167952+00 public | dhosts | 4165 | 72 | public | host_hgset | 1 | 65 | public | dservices | 5345 | 60 | 2025-01-02 00:22:19.683709+00 _timescaledb_catalog | chunk_index | 2214 | 50 | 2025-01-04 00:00:01.300949+00 public | interface_snmp | 4 | 49 | public | maintenances_hosts | 6 | 48 | _timescaledb_catalog | compression_settings | 0 | 45 | _timescaledb_catalog | compression_chunk_size | 0 | 45 | public | service_problem | 6 | 42 | 2025-01-04 20:15:58.154891+00 public | graph_discovery | 35812 | 39 | 2025-01-08 19:29:20.746202+00 public | host_tag | 1 | 38 | public | escalations | 193 | 35 | 2025-01-08 19:27:58.830108+00 public | ids | 110 | 33 | 2025-01-08 19:16:57.432863+00 public | services | 232 | 30 | 2025-01-06 08:47:10.299813+00 public | hostmacro | 3914 | 30 | 2025-01-07 06:47:01.05989+00 _timescaledb_catalog | chunk | 1941 | 30 | 2025-01-05 00:44:11.617153+00 public | acknowledges | 255 | 28 | public | timeperiods | 5 | 26 | public | maintenances_windows | 5 | 26 | public | maintenances | 5 | 22 | public | group_discovery | 9 | 20 | 2025-01-08 16:39:08.191382+00 public | proxy_rtdata | 16 | 16 | 2025-01-08 19:29:20.56457+00 public | task_check_now | 8 | 16 | 2025-01-08 13:08:20.1748+00 public | task_close_problem | 4 | 14 | public | problem | 2286 | 13 | 2025-01-08 19:08:56.572163+00 public | maintenances_groups | 0 | 10 | _timescaledb_catalog | chunk_constraint | 1081 | 10 | 2025-01-06 00:05:20.292105+00 _timescaledb_catalog | dimension_slice | 1027 | 10 | 2025-01-06 00:05:20.267697+00 pg_catalog | pg_inherits | 1027 | 10 | 2025-01-06 00:05:20.245138+00 public | task_acknowledge | 90 | 9 | 2025-01-08 01:08:20.507131+00 public | task_result | 18 | 9 | 2025-01-08 08:08:21.643518+00 public | task_data | 18 | 9 | 2025-01-08 08:08:21.619227+00 public | service_alarms | 239 | 8 | _timescaledb_catalog | dimension | 0 | 8 | public | token | 91 | 8 | 2025-01-08 19:29:20.704187+00 public | host_inventory | 5653 | 6 | 2025-01-08 19:29:20.545881+00 public | config | 1 | 6 | public | host_discovery | 74 | 6 | 2025-01-08 18:39:10.075989+00 pg_catalog | pg_constraint | 1733 | 5 | 2025-01-08 00:00:00.003946+00 public | ha_node | 2 | 4 | 2025-01-08 19:29:20.525284+00 pg_toast | pg_toast_408599544 | 2 | 4 | public | autoreg_host | 0 | 3 | public | lld_macro_path | 3 | 2 | public | media_type | 0 | 1 | pg_catalog | pg_proc | 0 | 1 | public | sessions | 212 | 1 | 2025-01-08 19:29:20.587576+00 _timescaledb_internal | _hyper_16_7105_chunk | 262006 | 1 | 2025-01-01 13:03:28.842781+00 public | proxy_group_rtdata | 0 | 1 | (83 rows)