| Unique (cost=377.59..377.66 rows=1 width=540) |
| -> Sort (cost=377.59..377.59 rows=1 width=540) |
| Sort Key: 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.updated_at, s.working_address, s.capital_currency, s.payment_cycle, s.account_number, (sum((sum(pc.amount)))), (sum((sum(CASE WHEN (pcp.collected IS NOT NULL) THEN pcp.collected ELSE '0'::numeric END)))), ((sum((sum(pc.amount))) - sum((sum(CASE WHEN (pcp.collected IS NOT NULL) THEN pcp.collected ELSE '0'::numeric END))))), (sum((sum(CASE WHEN (pci.invoiced IS NOT NULL) THEN pci.invoiced ELSE '0'::numeric END)))), ((sum((sum(pc.amount))) - sum((sum(CASE WHEN (pci.invoiced IS NOT NULL) THEN pci.invoiced ELSE '0'::numeric END))))) |
| -> GroupAggregate (cost=377.52..377.58 rows=1 width=540) |
| Group Key: s.id |
| -> Sort (cost=377.52..377.53 rows=1 width=476) |
| Sort Key: s.id |
| -> Hash Right Join (cost=365.63..377.51 rows=1 width=476) |
| Hash Cond: (pc.supplier_id = s.id) |
| -> HashAggregate (cost=359.50..366.40 rows=394 width=100) |
| Group Key: pc.supplier_id |
| -> Hash Left Join (cost=247.27..340.83 rows=1867 width=74) |
| Hash Cond: (pc.id = pci.contract_id) |
| -> Hash Left Join (cost=107.65..196.30 rows=1867 width=46) |
| Hash Cond: (pc.id = pcp.contract_id) |
| -> Seq Scan on tbl_purchase_contracts pc (cost=0.00..83.74 rows=1867 width=14) |
| Filter: (NOT is_chargeback) |
| -> Hash (cost=84.90..84.90 rows=1820 width=36) |
| -> Subquery Scan on pcp (cost=43.95..84.90 rows=1820 width=36) |
| -> HashAggregate (cost=43.95..66.70 rows=1820 width=36) |
| Group Key: tbl_purchase_contract_payments.contract_id |
| -> Seq Scan on tbl_purchase_contract_payments (cost=0.00..34.30 rows=1930 width=10) |
| -> Hash (cost=116.92..116.92 rows=1816 width=36) |
| -> Subquery Scan on pci (cost=76.06..116.92 rows=1816 width=36) |
| -> HashAggregate (cost=76.06..98.76 rows=1816 width=36) |
| Group Key: tbl_purchase_contract_invoices.contract_id |
| -> Seq Scan on tbl_purchase_contract_invoices (cost=0.00..66.04 rows=2004 width=10) |
| -> Hash (cost=6.11..6.11 rows=1 width=380) |
| -> Index Scan using tbl_suppliers_pkey on tbl_suppliers s (cost=0.28..6.11 rows=1 width=380) |
| Index Cond: (id IS NULL) |