explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WFer

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=16,735.47..18,154.86 rows=33,866 width=260) (actual rows= loops=)

  • Hash Cond: ((cpl.venture_id = acc.venture_id) AND (cpl.client_id = acc.client_id))
2. 0.000 0.000 ↓ 0.0

Seq Scan on tmp_rcf_cpl cpl (cost=0.00..126.27 rows=7,227 width=77) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Hash (cost=15,565.48..15,565.48 rows=33,866 width=131) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=14,631.93..15,565.48 rows=33,866 width=131) (actual rows= loops=)

  • Hash Cond: ((sls.venture_id = acc.venture_id) AND (sls.account_id = acc.id))
5. 0.000 0.000 ↓ 0.0

Seq Scan on tmp_rcf_slistings sls (cost=0.00..179.13 rows=8,313 width=85) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash (cost=13,659.94..13,659.94 rows=33,866 width=82) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash Join (cost=3.28..13,659.94 rows=33,866 width=82) (actual rows= loops=)

  • Hash Cond: (ven.country_id = cou.id)
8. 0.000 0.000 ↓ 0.0

Hash Join (cost=1.99..13,390.32 rows=91,179 width=79) (actual rows= loops=)

  • Hash Cond: (acc.venture_id = ven.id)
9. 0.000 0.000 ↓ 0.0

Seq Scan on accounts acc (cost=0.00..13,125.94 rows=91,179 width=71) (actual rows= loops=)

  • Filter: ((num_account = 1) AND (venture_id = ANY ('{3600,4840,6081,6080}'::integer[])) AND (lower(sales_stage) <> ALL ('{"99. invalid","0. never contacted","00. never contacted"}'::text[])) AND ((company_type ~~ 'Agent%'::text) OR (company_type = 'Developer'::text) OR (company_type = 'Private / Individual'::text)))
10. 0.000 0.000 ↓ 0.0

Hash (cost=1.44..1.44 rows=44 width=12) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Seq Scan on ventures ven (cost=0.00..1.44 rows=44 width=12) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Hash (cost=1.13..1.13 rows=13 width=7) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Seq Scan on countries cou (cost=0.00..1.13 rows=13 width=7) (actual rows= loops=)