Nested Loop Left Join (cost=0.00..31.93 rows=2 width=253) |
Join Filter: (u.enterprise_id = e.id) |
Filter: ((COALESCE(e.schema_id, 'global'::character varying))::text <> 'global'::text) |
-> Seq Scan on tbl_logins u (cost=0.00..30.54 rows=2 width=216) |
Filter: (((email)::text = 'gaojunyang@toast.com.cn'::text) OR ((mobile)::text = 'gaojunyang@toast.com.cn'::text)) |
-> Materialize (cost=0.00..1.12 rows=8 width=64) |
-> Seq Scan on tbl_enterprises e (cost=0.00..1.08 rows=8 width=64) |