{
  "groups": [
    {
      "groupId": 2294,
      "attributes": []
    },
    {
      "groupId": null,
      "attributes": [
        {
          "condition": "EQ",
          "attributeId": 5,
          "attributeValue": "JBL"
        }
      ]
    },
    {
      "groupId": null,
      "attributes": [
        {
          "condition": "CONTAINS_SUBSTR",
          "attributeId": 9,
          "attributeValue": "Reflect Fit"
        }
      ]
    }
  ]
}

select distinct
	collection_id,
	jsonb_array_elements( rules ->'groups' )->>'groupId' as group_id,
	jsonb_array_elements( jsonb_array_elements( rules ->'groups' )#>'{attributes}' )->>'attributeId' as attribute_id
from
	collection

	jsonb_array_elements( jsonb_array_elements( rules ->'groups' )#>'{attributes}' )->>'attributeId' as attribute_id

with groups as (
select
	collection_id,
	jsonb_array_elements( rules_wo_operators ->'groups' ) as groups_data
from
	collection ),
group_data as (
select 
	collection_id,
	groups_data ->>'groupId' as group_id,
	jsonb_array_elements( groups_data ->'attributes') as attributes_data ----тут уже отличается
from
	groups ),
attribute_data as (
select
	collection_id,
	group_id,
	attributes_data ->>'attributeId' as attribute_id
from
	group_data ),
attribute_rules as (
select
	collection_id,
	group_id,
	attribute_id
from
	attribute_data )
select * from attribute_rules

CREATE INDEX collection_rules_groups_gin_idx ON collection USING gin ((rules-> 'groups'));
CREATE INDEX collection_rules_attrs_gin_idx ON collection USING gin ((rules-> 'attributeId'));

CREATE INDEX collection_rules_groups_gin_idx ON collection (((rules->> 'groupId')::int));
CREATE INDEX collection_rules_attrs_gin_idx ON collection (((rules->> 'attributeId')::int));

REINDEX TABLE collection;