Sort (cost=9.96..9.96 rows=1 width=21) |
Sort Key: u.name |
-> Group (cost=9.94..9.95 rows=1 width=21) |
Group Key: s.id, u.id |
-> Sort (cost=9.94..9.94 rows=1 width=21) |
Sort Key: s.id, u.id |
-> Hash Join (cost=2.06..9.93 rows=1 width=21) |
Hash Cond: (u.id = s.accessible_user) |
-> Seq Scan on tbl_users u (cost=0.00..7.76 rows=25 width=13) |
Filter: (user_status = '1'::type_global_user_status) |
-> Hash (cost=2.05..2.05 rows=1 width=8) |
-> Seq Scan on tbl_visible_approves s (cost=0.00..2.05 rows=1 width=8) |
Filter: ((accessible_user IS NOT NULL) AND (user_id = 5252)) |