| Aggregate (cost=218.39..218.40 rows=1 width=8) |
| -> Group (cost=218.16..218.23 rows=13 width=2967) |
| Group Key: c.id |
| -> Sort (cost=218.16..218.20 rows=13 width=4) |
| Sort Key: c.id |
| -> Hash Join (cost=78.48..217.92 rows=13 width=4) |
| Hash Cond: (c.id = cm.contact_id) |
| -> Seq Scan on tbl_contacts c (cost=0.00..138.24 rows=214 width=4) |
| Filter: ((client_id IS NOT NULL) AND is_mp_bind) |
| -> Hash (cost=74.92..74.92 rows=285 width=4) |
| -> Seq Scan on tbl_contact_mobiles cm (cost=0.00..74.92 rows=285 width=4) |
| Filter: (mp_open_id IS NOT NULL) |