QUERY PLAN
Sort (cost=23.33..23.34 rows=1 width=254)
Sort Key: a.user_id
-> Hash Join (cost=7.94..23.32 rows=1 width=254)
Hash Cond: ((a.item_name)::text = (b.name)::text)
-> Seq Scan on tbl_auth_assignments a (cost=0.00..15.38 rows=4 width=150)
Filter: (user_id = ANY ('{5493,5495}'::integer[]))
-> Hash (cost=7.85..7.85 rows=7 width=250)
-> Seq Scan on tbl_auth_items b (cost=0.00..7.85 rows=7 width=250)
Filter: (type = 1)