QUERY PLAN
HashAggregate (cost=35.84..36.08 rows=24 width=4)
Group Key: aa.user_id
-> Hash Join (cost=31.00..35.78 rows=24 width=4)
Hash Cond: ((aa.item_name)::text = (aic.parent)::text)
-> Seq Scan on tbl_auth_assignments aa (cost=0.00..4.10 rows=210 width=15)
-> Hash (cost=30.98..30.98 rows=2 width=11)
-> Seq Scan on tbl_auth_item_child aic (cost=0.00..30.98 rows=2 width=11)
Filter: ((child)::text = 'viewOperation'::text)