| Aggregate (cost=209.94..209.95 rows=1 width=8) |
| -> Group (cost=209.72..209.78 rows=13 width=2967) |
| Group Key: c.id |
| -> Sort (cost=209.72..209.75 rows=13 width=4) |
| Sort Key: c.id |
| -> Hash Join (cost=75.79..209.48 rows=13 width=4) |
| Hash Cond: (c.id = cm.contact_id) |
| -> Seq Scan on tbl_contacts c (cost=0.00..132.49 rows=213 width=4) |
| Filter: ((client_id IS NOT NULL) AND is_mp_bind) |
| -> Hash (cost=72.24..72.24 rows=284 width=4) |
| -> Seq Scan on tbl_contact_mobiles cm (cost=0.00..72.24 rows=284 width=4) |
| Filter: (mp_open_id IS NOT NULL) |