explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JJrG

Settings
# exclusive inclusive rows x rows loops node
1. 58.242 354.676 ↓ 1.4 48,451 1

Hash Right Join (cost=16,735.47..18,154.86 rows=33,866 width=260) (actual time=299.753..354.676 rows=48,451 loops=1)

  • Hash Cond: ((cpl.venture_id = acc.venture_id) AND (cpl.client_id = acc.client_id))
2. 0.907 0.907 ↑ 1.0 7,227 1

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

3. 90.213 295.527 ↓ 1.4 48,451 1

Hash (cost=15,565.48..15,565.48 rows=33,866 width=131) (actual time=295.527..295.527 rows=48,451 loops=1)

  • Buckets: 32768 Batches: 2 Memory Usage: 3296kB
4. 27.764 205.314 ↓ 1.4 48,451 1

Hash Right Join (cost=14,631.93..15,565.48 rows=33,866 width=131) (actual time=183.547..205.314 rows=48,451 loops=1)

  • Hash Cond: ((sls.venture_id = acc.venture_id) AND (sls.account_id = acc.id))
5. 1.211 1.211 ↑ 1.0 8,313 1

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

6. 63.119 176.339 ↓ 1.4 48,451 1

Hash (cost=13,659.94..13,659.94 rows=33,866 width=82) (actual time=176.339..176.339 rows=48,451 loops=1)

  • Buckets: 32768 Batches: 2 Memory Usage: 3003kB
7. 9.420 113.220 ↓ 1.4 48,451 1

Hash Join (cost=3.28..13,659.94 rows=33,866 width=82) (actual time=2.225..113.220 rows=48,451 loops=1)

  • Hash Cond: (ven.country_id = cou.id)
8. 10.783 103.780 ↑ 1.9 48,451 1

Hash Join (cost=1.99..13,390.32 rows=91,179 width=79) (actual time=2.190..103.780 rows=48,451 loops=1)

  • Hash Cond: (acc.venture_id = ven.id)
9. 92.592 92.592 ↑ 1.9 48,451 1

Seq Scan on accounts acc (cost=0.00..13,125.94 rows=91,179 width=71) (actual time=1.133..92.592 rows=48,451 loops=1)

  • 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)))
  • Rows Removed by Filter: 165851
10. 0.392 0.405 ↑ 1.0 44 1

Hash (cost=1.44..1.44 rows=44 width=12) (actual time=0.404..0.405 rows=44 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
11. 0.013 0.013 ↑ 1.0 44 1

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

12. 0.005 0.020 ↑ 1.0 13 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
13. 0.015 0.015 ↑ 1.0 13 1

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