QUERY PLAN
Aggregate (cost=24.27..24.28 rows=1 width=8)
-> Unique (cost=22.17..23.90 rows=30 width=2588)
-> Sort (cost=22.17..22.25 rows=30 width=2588)
Sort Key: s.updated_at DESC, s.id, s.name, s.abbr, s.pinyin_shortcut, s.main_products, s.company_nature, s.website, s.established_at, s.capital, s.corp_rep, s.reg_address, s.telephone, s.fax, s.description, s.main_contact, s.created_by, s.created_at, s.working_address, s.capital_currency, s.payment_cycle, s.account_number
-> HashAggregate (cost=21.14..21.44 rows=30 width=2588)
Group Key: s.id
-> Hash Left Join (cost=10.45..21.06 rows=30 width=2588)
Hash Cond: (s.id = c.supplier_id)
-> Seq Scan on tbl_suppliers s (cost=0.00..10.30 rows=30 width=2588)
-> Hash (cost=10.20..10.20 rows=20 width=4)
-> Seq Scan on tbl_contacts c (cost=0.00..10.20 rows=20 width=4)
Filter: (supplier_id IS NOT NULL)