QUERY ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ select * from network_data where dataspace = 'dataspace-10' and schema_set = 'schema-set-10' and payload @> '{ "interface:interface" : { "name": "Itf-1" } }' order by timestamp desc limit 100; QUERY PLAN ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ Limit (cost=1303.50..1303.57 rows=28 width=193) (actual time=58.442..59.560 rows=21 loops=1) -> Sort (cost=1303.50..1303.57 rows=28 width=193) (actual time=58.430..59.352 rows=21 loops=1) Sort Key: _hyper_1_24_chunk."timestamp" DESC Sort Method: quicksort Memory: 30kB -> Append (cost=12.90..1302.83 rows=28 width=193) (actual time=2.214..59.119 rows=21 loops=1) -> Bitmap Heap Scan on _hyper_1_24_chunk (cost=12.90..14.02 rows=1 width=141) (actual time=2.203..2.239 rows=1 loops=1) Recheck Cond: (((dataspace)::text = 'dataspace-10'::text) AND ((schema_set)::text = 'schema-set-10'::text) AND (payload @> '{"interface:interface": {"name": "Itf-1"}}'::jsonb)) Heap Blocks: exact=1 -> BitmapAnd (cost=12.90..12.90 rows=1 width=0) (actual time=2.175..2.198 rows=0 loops=1) -> Bitmap Index Scan on _hyper_1_24_chunk_network_data_dataspace_schema_set_timestamp_i (cost=0.00..2.12 rows=61 width=0) (actual time=0.034..0.039 rows=64 loops=1) Index Cond: (((dataspace)::text = 'dataspace-10'::text) AND ((schema_set)::text = 'schema-set-10'::text)) -> Bitmap Index Scan on _hyper_1_24_chunk_network_data_payload_idx (cost=0.00..10.53 rows=377 width=0) (actual time=2.105..2.109 rows=607 loops=1) Index Cond: (payload @> '{"interface:interface": {"name": "Itf-1"}}'::jsonb) -> Bitmap Heap Scan on _hyper_1_23_chunk (cost=74.57..75.69 rows=1 width=141) (actual time=4.120..4.162 rows=1 loops=1) Recheck Cond: (((dataspace)::text = 'dataspace-10'::text) AND ((schema_set)::text = 'schema-set-10'::text) AND (payload @> '{"interface:interface": {"name": "Itf-1"}}'::jsonb)) Heap Blocks: exact=1 -> BitmapAnd (cost=74.57..74.57 rows=1 width=0) (actual time=4.101..4.128 rows=0 loops=1) -> Bitmap Index Scan on _hyper_1_23_chunk_network_data_dataspace_schema_set_timestamp_i (cost=0.00..2.43 rows=91 width=0) (actual time=0.026..0.030 rows=82 loops=1) Index Cond: (((dataspace)::text = 'dataspace-10'::text) AND ((schema_set)::text = 'schema-set-10'::text)) -> Bitmap Index Scan on _hyper_1_23_chunk_network_data_payload_idx (cost=0.00..71.89 rows=492 width=0) (actual time=4.040..4.044 rows=1008 loops=1) Index Cond: (payload @> '{"interface:interface": {"name": "Itf-1"}}'::jsonb) -> Bitmap Heap Scan on _hyper_1_22_chunk (cost=19.83..20.94 rows=1 width=141) (actual time=3.352..3.411 rows=4 loops=1) Recheck Cond: (((dataspace)::text = 'dataspace-10'::text) AND ((schema_set)::text = 'schema-set-10'::text) AND (payload @> '{"interface:interface": {"name": "Itf-1"}}'::jsonb)) Heap Blocks: exact=4 -> BitmapAnd (cost=19.83..19.83 rows=1 width=0) (actual time=3.334..3.356 rows=0 loops=1) -> Bitmap Index Scan on _hyper_1_22_chunk_network_data_dataspace_schema_set_timestamp_i (cost=0.00..2.52 rows=100 width=0) (actual time=0.028..0.032 rows=92 loops=1) Index Cond: (((dataspace)::text = 'dataspace-10'::text) AND ((schema_set)::text = 'schema-set-10'::text)) -> Bitmap Index Scan on _hyper_1_22_chunk_network_data_payload_idx (cost=0.00..17.06 rows=1101 width=0) (actual time=3.271..3.276 rows=1028 loops=1) Index Cond: (payload @> '{"interface:interface": {"name": "Itf-1"}}'::jsonb) -> Bitmap Heap Scan on _hyper_1_21_chunk (cost=73.02..74.13 rows=1 width=141) (actual time=3.594..3.630 rows=1 loops=1) Recheck Cond: (((dataspace)::text = 'dataspace-10'::text) AND ((schema_set)::text = 'schema-set-10'::text) AND (payload @> '{"interface:interface": {"name": "Itf-1"}}'::jsonb)) Heap Blocks: exact=1 -> BitmapAnd (cost=73.02..73.02 rows=1 width=0) (actual time=3.575..3.597 rows=0 loops=1) -> Bitmap Index Scan on _hyper_1_21_chunk_network_data_dataspace_schema_set_timestamp_i (cost=0.00..2.58 rows=106 width=0) (actual time=0.041..0.045 rows=92 loops=1) Index Cond: (((dataspace)::text = 'dataspace-10'::text) AND ((schema_set)::text = 'schema-set-10'::text)) -> Bitmap Index Scan on _hyper_1_21_chunk_network_data_payload_idx (cost=0.00..70.19 rows=852 width=0) (actual time=3.501..3.505 rows=1061 loops=1) Index Cond: (payload @> '{"interface:interface": {"name": "Itf-1"}}'::jsonb) -> Bitmap Heap Scan on _hyper_1_20_chunk (cost=87.47..89.70 rows=2 width=141) (actual time=4.074..4.105 rows=0 loops=1) Recheck Cond: (((dataspace)::text = 'dataspace-10'::text) AND ((schema_set)::text = 'schema-set-10'::text) AND (payload @> '{"interface:interface": {"name": "Itf-1"}}'::jsonb)) -> BitmapAnd (cost=87.47..87.47 rows=2 width=0) (actual time=4.063..4.085 rows=0 loops=1) -> Bitmap Index Scan on _hyper_1_20_chunk_network_data_dataspace_schema_set_timestamp_i (cost=0.00..2.62 rows=110 width=0) (actual time=0.027..0.031 rows=103 loops=1) Index Cond: (((dataspace)::text = 'dataspace-10'::text) AND ((schema_set)::text = 'schema-set-10'::text)) -> Bitmap Index Scan on _hyper_1_20_chunk_network_data_payload_idx (cost=0.00..84.60 rows=1894 width=0) (actual time=3.998..4.002 rows=1167 loops=1) Index Cond: (payload @> '{"interface:interface": {"name": "Itf-1"}}'::jsonb) -> Bitmap Heap Scan on _hyper_1_19_chunk (cost=21.04..22.15 rows=1 width=141) (actual time=3.179..3.215 rows=1 loops=1) Recheck Cond: (((dataspace)::text = 'dataspace-10'::text) AND ((schema_set)::text = 'schema-set-10'::text) AND (payload @> '{"interface:interface": {"name": "Itf-1"}}'::jsonb)) Heap Blocks: exact=1 -> BitmapAnd (cost=21.04..21.04 rows=1 width=0) (actual time=3.159..3.181 rows=0 loops=1) -> Bitmap Index Scan on _hyper_1_19_chunk_network_data_dataspace_schema_set_timestamp_i (cost=0.00..2.50 rows=98 width=0) (actual time=0.028..0.033 rows=97 loops=1) Index Cond: (((dataspace)::text = 'dataspace-10'::text) AND ((schema_set)::text = 'schema-set-10'::text)) -> Bitmap Index Scan on _hyper_1_19_chunk_network_data_payload_idx (cost=0.00..18.29 rows=1265 width=0) (actual time=3.097..3.101 rows=1025 loops=1) Index Cond: (payload @> '{"interface:interface": {"name": "Itf-1"}}'::jsonb) -> Bitmap Heap Scan on _hyper_1_18_chunk (cost=99.71..100.83 rows=1 width=141) (actual time=3.444..3.475 rows=0 loops=1) Recheck Cond: (((dataspace)::text = 'dataspace-10'::text) AND ((schema_set)::text = 'schema-set-10'::text) AND (payload @> '{"interface:interface": {"name": "Itf-1"}}'::jsonb)) -> BitmapAnd (cost=99.71..99.71 rows=1 width=0) (actual time=3.434..3.456 rows=0 loops=1) -> Bitmap Index Scan on _hyper_1_18_chunk_network_data_dataspace_schema_set_timestamp_i (cost=0.00..2.45 rows=93 width=0) (actual time=0.041..0.045 rows=93 loops=1) Index Cond: (((dataspace)::text = 'dataspace-10'::text) AND ((schema_set)::text = 'schema-set-10'::text)) -> Bitmap Index Scan on _hyper_1_18_chunk_network_data_payload_idx (cost=0.00..97.01 rows=762 width=0) (actual time=3.367..3.371 rows=909 loops=1) Index Cond: (payload @> '{"interface:interface": {"name": "Itf-1"}}'::jsonb) -> Bitmap Heap Scan on _hyper_1_17_chunk (cost=76.28..77.40 rows=1 width=141) (actual time=3.034..3.065 rows=0 loops=1) Recheck Cond: (((dataspace)::text = 'dataspace-10'::text) AND ((schema_set)::text = 'schema-set-10'::text) AND (payload @> '{"interface:interface": {"name": "Itf-1"}}'::jsonb)) -> BitmapAnd (cost=76.28..76.28 rows=1 width=0) (actual time=3.015..3.037 rows=0 loops=1) -> Bitmap Index Scan on _hyper_1_17_chunk_network_data_dataspace_schema_set_timestamp_i (cost=0.00..2.47 rows=95 width=0) (actual time=0.028..0.032 rows=110 loops=1) Index Cond: (((dataspace)::text = 'dataspace-10'::text) AND ((schema_set)::text = 'schema-set-10'::text)) -> Bitmap Index Scan on _hyper_1_17_chunk_network_data_payload_idx (cost=0.00..73.57 rows=1009 width=0) (actual time=2.961..2.966 rows=1037 loops=1) Index Cond: (payload @> '{"interface:interface": {"name": "Itf-1"}}'::jsonb) -> Bitmap Heap Scan on _hyper_1_16_chunk (cost=20.50..21.62 rows=1 width=141) (actual time=2.647..2.678 rows=0 loops=1) Recheck Cond: (((dataspace)::text = 'dataspace-10'::text) AND ((schema_set)::text = 'schema-set-10'::text) AND (payload @> '{"interface:interface": {"name": "Itf-1"}}'::jsonb)) -> BitmapAnd (cost=20.50..20.50 rows=1 width=0) (actual time=2.636..2.658 rows=0 loops=1) -> Bitmap Index Scan on _hyper_1_16_chunk_network_data_dataspace_schema_set_timestamp_i (cost=0.00..2.58 rows=106 width=0) (actual time=0.026..0.030 rows=95 loops=1) Index Cond: (((dataspace)::text = 'dataspace-10'::text) AND ((schema_set)::text = 'schema-set-10'::text)) -> Bitmap Index Scan on _hyper_1_16_chunk_network_data_payload_idx (cost=0.00..17.67 rows=1183 width=0) (actual time=2.530..2.534 rows=1153 loops=1) Index Cond: (payload @> '{"interface:interface": {"name": "Itf-1"}}'::jsonb) -> Bitmap Heap Scan on _hyper_1_15_chunk (cost=86.79..87.91 rows=1 width=141) (actual time=2.999..3.052 rows=2 loops=1) Recheck Cond: (((dataspace)::text = 'dataspace-10'::text) AND ((schema_set)::text = 'schema-set-10'::text) AND (payload @> '{"interface:interface": {"name": "Itf-1"}}'::jsonb)) Heap Blocks: exact=2 -> BitmapAnd (cost=86.79..86.79 rows=1 width=0) (actual time=2.980..3.012 rows=0 loops=1) -> Bitmap Index Scan on _hyper_1_15_chunk_network_data_dataspace_schema_set_timestamp_i (cost=0.00..2.46 rows=94 width=0) (actual time=0.042..0.047 rows=103 loops=1) Index Cond: (((dataspace)::text = 'dataspace-10'::text) AND ((schema_set)::text = 'schema-set-10'::text)) -> Bitmap Index Scan on _hyper_1_15_chunk_network_data_payload_idx (cost=0.00..84.08 rows=651 width=0) (actual time=2.912..2.926 rows=958 loops=1) Index Cond: (payload @> '{"interface:interface": {"name": "Itf-1"}}'::jsonb) -> Bitmap Heap Scan on _hyper_1_14_chunk (cost=27.99..30.22 rows=2 width=141) (actual time=2.470..2.529 rows=4 loops=1) Recheck Cond: (((dataspace)::text = 'dataspace-10'::text) AND ((schema_set)::text = 'schema-set-10'::text) AND (payload @> '{"interface:interface": {"name": "Itf-1"}}'::jsonb)) Heap Blocks: exact=4 -> BitmapAnd (cost=27.99..27.99 rows=2 width=0) (actual time=2.451..2.473 rows=0 loops=1) -> Bitmap Index Scan on _hyper_1_14_chunk_network_data_dataspace_schema_set_timestamp_i (cost=0.00..2.61 rows=109 width=0) (actual time=0.026..0.031 rows=110 loops=1) Index Cond: (((dataspace)::text = 'dataspace-10'::text) AND ((schema_set)::text = 'schema-set-10'::text)) -> Bitmap Index Scan on _hyper_1_14_chunk_network_data_payload_idx (cost=0.00..25.13 rows=2178 width=0) (actual time=2.384..2.389 rows=1224 loops=1) Index Cond: (payload @> '{"interface:interface": {"name": "Itf-1"}}'::jsonb) -> Bitmap Heap Scan on _hyper_1_13_chunk (cost=21.31..22.43 rows=1 width=141) (actual time=3.136..3.167 rows=0 loops=1) Recheck Cond: (((dataspace)::text = 'dataspace-10'::text) AND ((schema_set)::text = 'schema-set-10'::text) AND (payload @> '{"interface:interface": {"name": "Itf-1"}}'::jsonb)) -> BitmapAnd (cost=21.31..21.31 rows=1 width=0) (actual time=3.126..3.148 rows=0 loops=1) -> Bitmap Index Scan on _hyper_1_13_chunk_network_data_dataspace_schema_set_timestamp_i (cost=0.00..2.72 rows=120 width=0) (actual time=0.026..0.030 rows=90 loops=1) Index Cond: (((dataspace)::text = 'dataspace-10'::text) AND ((schema_set)::text = 'schema-set-10'::text)) -> Bitmap Index Scan on _hyper_1_13_chunk_network_data_payload_idx (cost=0.00..18.34 rows=1272 width=0) (actual time=3.062..3.066 rows=1274 loops=1) Index Cond: (payload @> '{"interface:interface": {"name": "Itf-1"}}'::jsonb) -> Bitmap Heap Scan on _hyper_1_12_chunk (cost=2.45..103.39 rows=1 width=141) (actual time=0.142..0.202 rows=2 loops=1) Recheck Cond: (((dataspace)::text = 'dataspace-10'::text) AND ((schema_set)::text = 'schema-set-10'::text)) Filter: (payload @> '{"interface:interface": {"name": "Itf-1"}}'::jsonb) Rows Removed by Filter: 90 Heap Blocks: exact=89 -> Bitmap Index Scan on _hyper_1_12_chunk_network_data_dataspace_schema_set_timestamp_i (cost=0.00..2.45 rows=93 width=0) (actual time=0.039..0.044 rows=92 loops=1) Index Cond: (((dataspace)::text = 'dataspace-10'::text) AND ((schema_set)::text = 'schema-set-10'::text)) -> Bitmap Heap Scan on _hyper_1_11_chunk (cost=16.99..18.11 rows=1 width=141) (actual time=2.475..2.511 rows=1 loops=1) Recheck Cond: (((dataspace)::text = 'dataspace-10'::text) AND ((schema_set)::text = 'schema-set-10'::text) AND (payload @> '{"interface:interface": {"name": "Itf-1"}}'::jsonb)) Heap Blocks: exact=1 -> BitmapAnd (cost=16.99..16.99 rows=1 width=0) (actual time=2.458..2.480 rows=0 loops=1) -> Bitmap Index Scan on _hyper_1_11_chunk_network_data_dataspace_schema_set_timestamp_i (cost=0.00..2.37 rows=85 width=0) (actual time=0.032..0.036 rows=84 loops=1) Index Cond: (((dataspace)::text = 'dataspace-10'::text) AND ((schema_set)::text = 'schema-set-10'::text)) -> Bitmap Index Scan on _hyper_1_11_chunk_network_data_payload_idx (cost=0.00..14.37 rows=743 width=0) (actual time=2.401..2.405 rows=944 loops=1) Index Cond: (payload @> '{"interface:interface": {"name": "Itf-1"}}'::jsonb) -> Bitmap Heap Scan on _hyper_1_10_chunk (cost=15.15..16.27 rows=1 width=141) (actual time=3.056..3.141 rows=0 loops=1) Recheck Cond: (((dataspace)::text = 'dataspace-10'::text) AND ((schema_set)::text = 'schema-set-10'::text) AND (payload @> '{"interface:interface": {"name": "Itf-1"}}'::jsonb)) -> BitmapAnd (cost=15.15..15.15 rows=1 width=0) (actual time=3.046..3.121 rows=0 loops=1) -> Bitmap Index Scan on _hyper_1_10_chunk_network_data_dataspace_schema_set_timestamp_i (cost=0.00..2.58 rows=106 width=0) (actual time=0.029..0.033 rows=115 loops=1) Index Cond: (((dataspace)::text = 'dataspace-10'::text) AND ((schema_set)::text = 'schema-set-10'::text)) -> Bitmap Index Scan on _hyper_1_10_chunk_network_data_payload_idx (cost=0.00..12.32 rows=469 width=0) (actual time=2.972..2.977 rows=1067 loops=1) Index Cond: (payload @> '{"interface:interface": {"name": "Itf-1"}}'::jsonb) -> Bitmap Heap Scan on _hyper_1_9_chunk (cost=25.45..27.68 rows=2 width=141) (actual time=2.280..2.315 rows=1 loops=1) Recheck Cond: (((dataspace)::text = 'dataspace-10'::text) AND ((schema_set)::text = 'schema-set-10'::text) AND (payload @> '{"interface:interface": {"name": "Itf-1"}}'::jsonb)) Heap Blocks: exact=1 -> BitmapAnd (cost=25.45..25.45 rows=2 width=0) (actual time=2.262..2.284 rows=0 loops=1) -> Bitmap Index Scan on _hyper_1_9_chunk_network_data_dataspace_schema_set_timestamp_id (cost=0.00..2.60 rows=108 width=0) (actual time=0.044..0.048 rows=117 loops=1) Index Cond: (((dataspace)::text = 'dataspace-10'::text) AND ((schema_set)::text = 'schema-set-10'::text)) -> Bitmap Index Scan on _hyper_1_9_chunk_network_data_payload_idx (cost=0.00..22.60 rows=1841 width=0) (actual time=2.180..2.184 rows=1151 loops=1) Index Cond: (payload @> '{"interface:interface": {"name": "Itf-1"}}'::jsonb) -> Bitmap Heap Scan on _hyper_1_8_chunk (cost=15.78..16.89 rows=1 width=141) (actual time=2.290..2.320 rows=0 loops=1) Recheck Cond: (((dataspace)::text = 'dataspace-10'::text) AND ((schema_set)::text = 'schema-set-10'::text) AND (payload @> '{"interface:interface": {"name": "Itf-1"}}'::jsonb)) -> BitmapAnd (cost=15.78..15.78 rows=1 width=0) (actual time=2.279..2.301 rows=0 loops=1) -> Bitmap Index Scan on _hyper_1_8_chunk_network_data_dataspace_schema_set_timestamp_id (cost=0.00..2.61 rows=109 width=0) (actual time=0.025..0.029 rows=103 loops=1) Index Cond: (((dataspace)::text = 'dataspace-10'::text) AND ((schema_set)::text = 'schema-set-10'::text)) -> Bitmap Index Scan on _hyper_1_8_chunk_network_data_payload_idx (cost=0.00..12.92 rows=549 width=0) (actual time=2.228..2.232 rows=1130 loops=1) Index Cond: (payload @> '{"interface:interface": {"name": "Itf-1"}}'::jsonb) -> Bitmap Heap Scan on _hyper_1_7_chunk (cost=22.52..23.64 rows=1 width=141) (actual time=2.522..2.557 rows=1 loops=1) Recheck Cond: (((dataspace)::text = 'dataspace-10'::text) AND ((schema_set)::text = 'schema-set-10'::text) AND (payload @> '{"interface:interface": {"name": "Itf-1"}}'::jsonb)) Heap Blocks: exact=1 -> BitmapAnd (cost=22.52..22.52 rows=1 width=0) (actual time=2.500..2.522 rows=0 loops=1) -> Bitmap Index Scan on _hyper_1_7_chunk_network_data_dataspace_schema_set_timestamp_id (cost=0.00..2.61 rows=109 width=0) (actual time=0.028..0.033 rows=110 loops=1) Index Cond: (((dataspace)::text = 'dataspace-10'::text) AND ((schema_set)::text = 'schema-set-10'::text)) -> Bitmap Index Scan on _hyper_1_7_chunk_network_data_payload_idx (cost=0.00..19.67 rows=1449 width=0) (actual time=2.433..2.438 rows=1221 loops=1) Index Cond: (payload @> '{"interface:interface": {"name": "Itf-1"}}'::jsonb) -> Bitmap Heap Scan on _hyper_1_6_chunk (cost=27.77..30.00 rows=2 width=141) (actual time=2.869..2.905 rows=1 loops=1) Recheck Cond: (((dataspace)::text = 'dataspace-10'::text) AND ((schema_set)::text = 'schema-set-10'::text) AND (payload @> '{"interface:interface": {"name": "Itf-1"}}'::jsonb)) Heap Blocks: exact=1 -> BitmapAnd (cost=27.77..27.77 rows=2 width=0) (actual time=2.852..2.874 rows=0 loops=1) -> Bitmap Index Scan on _hyper_1_6_chunk_network_data_dataspace_schema_set_timestamp_id (cost=0.00..2.74 rows=122 width=0) (actual time=0.043..0.047 rows=117 loops=1) Index Cond: (((dataspace)::text = 'dataspace-10'::text) AND ((schema_set)::text = 'schema-set-10'::text)) -> Bitmap Index Scan on _hyper_1_6_chunk_network_data_payload_idx (cost=0.00..24.78 rows=2131 width=0) (actual time=2.770..2.774 rows=1403 loops=1) Index Cond: (payload @> '{"interface:interface": {"name": "Itf-1"}}'::jsonb) -> Bitmap Heap Scan on _hyper_1_5_chunk (cost=105.08..106.20 rows=1 width=141) (actual time=3.339..3.369 rows=0 loops=1) Recheck Cond: (((dataspace)::text = 'dataspace-10'::text) AND ((schema_set)::text = 'schema-set-10'::text) AND (payload @> '{"interface:interface": {"name": "Itf-1"}}'::jsonb)) -> BitmapAnd (cost=105.08..105.08 rows=1 width=0) (actual time=3.328..3.350 rows=0 loops=1) -> Bitmap Index Scan on _hyper_1_5_chunk_network_data_dataspace_schema_set_timestamp_id (cost=0.00..2.53 rows=101 width=0) (actual time=0.025..0.029 rows=93 loops=1) Index Cond: (((dataspace)::text = 'dataspace-10'::text) AND ((schema_set)::text = 'schema-set-10'::text)) -> Bitmap Index Scan on _hyper_1_5_chunk_network_data_payload_idx (cost=0.00..102.31 rows=1321 width=0) (actual time=3.277..3.282 rows=1079 loops=1) Index Cond: (payload @> '{"interface:interface": {"name": "Itf-1"}}'::jsonb) -> Bitmap Heap Scan on _hyper_1_4_chunk (cost=2.27..83.51 rows=1 width=141) (actual time=0.160..0.173 rows=0 loops=1) Recheck Cond: (((dataspace)::text = 'dataspace-10'::text) AND ((schema_set)::text = 'schema-set-10'::text)) Filter: (payload @> '{"interface:interface": {"name": "Itf-1"}}'::jsonb) Rows Removed by Filter: 86 Heap Blocks: exact=85 -> Bitmap Index Scan on _hyper_1_4_chunk_network_data_dataspace_schema_set_timestamp_id (cost=0.00..2.27 rows=75 width=0) (actual time=0.024..0.028 rows=86 loops=1) Index Cond: (((dataspace)::text = 'dataspace-10'::text) AND ((schema_set)::text = 'schema-set-10'::text)) -> Bitmap Heap Scan on _hyper_1_3_chunk (cost=2.24..80.16 rows=1 width=141) (actual time=0.116..0.146 rows=1 loops=1) Recheck Cond: (((dataspace)::text = 'dataspace-10'::text) AND ((schema_set)::text = 'schema-set-10'::text)) Filter: (payload @> '{"interface:interface": {"name": "Itf-1"}}'::jsonb) Rows Removed by Filter: 67 Heap Blocks: exact=65 -> Bitmap Index Scan on _hyper_1_3_chunk_network_data_dataspace_schema_set_timestamp_id (cost=0.00..2.24 rows=72 width=0) (actual time=0.025..0.030 rows=68 loops=1) Index Cond: (((dataspace)::text = 'dataspace-10'::text) AND ((schema_set)::text = 'schema-set-10'::text)) -> Bitmap Heap Scan on _hyper_1_2_chunk (cost=4.05..158.77 rows=1 width=141) (actual time=0.237..0.254 rows=0 loops=1) Recheck Cond: (((dataspace)::text = 'dataspace-10'::text) AND ((schema_set)::text = 'schema-set-10'::text)) Filter: (payload @> '{"interface:interface": {"name": "Itf-1"}}'::jsonb) Rows Removed by Filter: 115 Heap Blocks: exact=113 -> Bitmap Index Scan on _hyper_1_2_chunk_network_data_dataspace_schema_set_timestamp_id (cost=0.00..4.05 rows=143 width=0) (actual time=0.032..0.040 rows=115 loops=1) Index Cond: (((dataspace)::text = 'dataspace-10'::text) AND ((schema_set)::text = 'schema-set-10'::text)) -> Seq Scan on _hyper_1_1_chunk (cost=0.00..1.02 rows=1 width=1596) (actual time=0.033..0.038 rows=0 loops=1) Filter: ((payload @> '{"interface:interface": {"name": "Itf-1"}}'::jsonb) AND ((dataspace)::text = 'dataspace-10'::text) AND ((schema_set)::text = 'schema-set-10'::text)) Rows Removed by Filter: 1 Planning Time: 19.197 ms Execution Time: 61.625 ms (182 rows)