| Aggregate (cost=215.05..215.06 rows=1 width=8) |
| -> Group (cost=214.83..214.89 rows=13 width=2967) |
| Group Key: c.id |
| -> Sort (cost=214.83..214.86 rows=13 width=4) |
| Sort Key: c.id |
| -> Hash Join (cost=77.81..214.58 rows=13 width=4) |
| Hash Cond: (c.id = cm.contact_id) |
| -> Seq Scan on tbl_contacts c (cost=0.00..135.58 rows=213 width=4) |
| Filter: ((client_id IS NOT NULL) AND is_mp_bind) |
| -> Hash (cost=74.26..74.26 rows=284 width=4) |
| -> Seq Scan on tbl_contact_mobiles cm (cost=0.00..74.26 rows=284 width=4) |
| Filter: (mp_open_id IS NOT NULL) |