Sort (cost=10.07..10.07 rows=1 width=21) |
Sort Key: u.name |
-> Group (cost=10.04..10.06 rows=1 width=21) |
Group Key: s.id, u.id |
-> Sort (cost=10.04..10.05 rows=1 width=21) |
Sort Key: s.id, u.id |
-> Hash Join (cost=2.18..10.04 rows=1 width=21) |
Hash Cond: (u.id = s.accessible_user) |
-> Seq Scan on tbl_users u (cost=0.00..7.74 rows=30 width=13) |
Filter: (user_status = '1'::type_global_user_status) |
-> Hash (cost=2.16..2.16 rows=1 width=8) |
-> Seq Scan on tbl_visible_approves s (cost=0.00..2.16 rows=1 width=8) |
Filter: ((accessible_user IS NOT NULL) AND (user_id = 5295)) |