explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dkJv

Settings
# exclusive inclusive rows x rows loops node
1. 1,546.504 5,488.030 ↓ 2.7 1,525,509 1

Hash Right Join (cost=163,531.08..178,322.96 rows=566,770 width=185) (actual time=3,936.811..5,488.030 rows=1,525,509 loops=1)

  • Hash Cond: ((lal.venture_id = usr.venture_id) AND (lal.client_id = usr.id))
2. 4.920 4.920 ↑ 1.0 33,015 1

Seq Scan on tmp_rcf_lall lal (cost=0.00..544.15 rows=33,015 width=46) (actual time=0.023..4.920 rows=33,015 loops=1)

3. 403.546 3,936.606 ↓ 2.7 1,525,509 1

Hash (cost=147,280.53..147,280.53 rows=566,770 width=81) (actual time=3,936.606..3,936.606 rows=1,525,509 loops=1)

  • Buckets: 32,768 Batches: 32 Memory Usage: 4,041kB
4. 402.944 3,533.060 ↓ 2.7 1,525,509 1

Hash Right Join (cost=137,473.68..147,280.53 rows=566,770 width=81) (actual time=3,119.981..3,533.060 rows=1,525,509 loops=1)

  • Hash Cond: ((pv.venture_id = usr.venture_id) AND (pv.client_id = usr.id))
5. 10.605 10.605 ↑ 1.0 79,740 1

Seq Scan on tmp_rcf_pageviews pv (cost=0.00..1,229.40 rows=79,740 width=14) (actual time=0.017..10.605 rows=79,740 loops=1)

6. 390.764 3,119.511 ↓ 2.7 1,525,509 1

Hash (cost=121,776.13..121,776.13 rows=566,770 width=73) (actual time=3,119.511..3,119.511 rows=1,525,509 loops=1)

  • Buckets: 65,536 (originally 65536) Batches: 64 (originally 32) Memory Usage: 3,585kB
7. 389.478 2,728.747 ↓ 2.7 1,525,509 1

Hash Right Join (cost=112,683.16..121,776.13 rows=566,770 width=73) (actual time=2,329.746..2,728.747 rows=1,525,509 loops=1)

  • Hash Cond: ((lac.venture_id = usr.venture_id) AND (lac.client_id = usr.id))
8. 10.044 10.044 ↑ 1.0 74,902 1

Seq Scan on tmp_rcf_alistings lac (cost=0.00..1,154.02 rows=74,902 width=16) (actual time=0.025..10.044 rows=74,902 loops=1)

9. 384.898 2,329.225 ↓ 2.7 1,525,509 1

Hash (cost=97,539.61..97,539.61 rows=566,770 width=65) (actual time=2,329.225..2,329.225 rows=1,525,509 loops=1)

  • Buckets: 65,536 (originally 65536) Batches: 64 (originally 32) Memory Usage: 3,585kB
10. 519.308 1,944.327 ↓ 2.7 1,525,509 1

Hash Right Join (cost=90,460.42..97,539.61 rows=566,770 width=65) (actual time=1,421.336..1,944.327 rows=1,525,509 loops=1)

  • Hash Cond: ((lld.venture_id = usr.venture_id) AND (lld.client_id = usr.id))
11. 3.804 3.804 ↑ 1.0 30,223 1

Seq Scan on tmp_rcf_ldlistings lld (cost=0.00..466.23 rows=30,223 width=16) (actual time=0.015..3.804 rows=30,223 loops=1)

12. 433.455 1,421.215 ↓ 2.7 1,525,509 1

Hash (cost=75,869.87..75,869.87 rows=566,770 width=57) (actual time=1,421.215..1,421.215 rows=1,525,509 loops=1)

  • Buckets: 65,536 (originally 65536) Batches: 32 (originally 16) Memory Usage: 3,881kB
13. 297.124 987.760 ↓ 2.7 1,525,509 1

Hash Join (cost=3.28..75,869.87 rows=566,770 width=57) (actual time=0.152..987.760 rows=1,525,509 loops=1)

  • Hash Cond: (ven.country_id = cou.id)
14. 364.118 690.621 ↑ 1.0 1,525,509 1

Hash Join (cost=1.99..71,378.01 rows=1,525,920 width=54) (actual time=0.132..690.621 rows=1,525,509 loops=1)

  • Hash Cond: (usr.venture_id = ven.id)
15. 326.479 326.479 ↑ 1.0 1,525,509 1

Seq Scan on users usr (cost=0.00..66,984.66 rows=1,525,920 width=46) (actual time=0.099..326.479 rows=1,525,509 loops=1)

  • Filter: (venture_id = ANY ('{3600,4840,6080,6081}'::integer[]))
  • Rows Removed by Filter: 7,939
16. 0.010 0.024 ↑ 1.0 44 1

Hash (cost=1.44..1.44 rows=44 width=12) (actual time=0.023..0.024 rows=44 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
17. 0.014 0.014 ↑ 1.0 44 1

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

18. 0.004 0.015 ↑ 1.0 13 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
19. 0.011 0.011 ↑ 1.0 13 1

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