| HashAggregate (cost=41.34..41.56 rows=22 width=4) |
| Group Key: aa.user_id |
| -> Hash Join (cost=36.55..41.29 rows=22 width=4) |
| Hash Cond: ((aa.item_name)::text = (aic.parent)::text) |
| -> Seq Scan on tbl_auth_assignments aa (cost=0.00..4.07 rows=207 width=15) |
| -> Hash (cost=36.53..36.53 rows=2 width=11) |
| -> Seq Scan on tbl_auth_item_child aic (cost=0.00..36.53 rows=2 width=11) |
| Filter: ((child)::text = 'viewOperation'::text) |