QUERY PLAN
Unique (cost=19.79..19.80 rows=1 width=4)
-> Sort (cost=19.79..19.79 rows=1 width=4)
Sort Key: u.id
-> Nested Loop (cost=4.16..19.78 rows=1 width=4)
Join Filter: (u.id = aa.user_id)
-> Seq Scan on tbl_users u (cost=0.00..10.25 rows=1 width=4)
Filter: (user_status = '1'::type_global_user_status)
-> Bitmap Heap Scan on tbl_auth_assignments aa (cost=4.16..9.50 rows=2 width=4)
Recheck Cond: ((item_name)::text = 'Admin'::text)
-> Bitmap Index Scan on tbl_auth_assignments_pkey (cost=0.00..4.16 rows=2 width=0)
Index Cond: ((item_name)::text = 'Admin'::text)