explain.depesz.com

PostgreSQL's explain analyze made readable

Result: W1JV

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

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

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

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

3. 404.413 4,178.447 ↓ 2.7 1,525,509 1

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

  • Buckets: 32768 Batches: 32 Memory Usage: 4041kB
4. 402.101 3,774.034 ↓ 2.7 1,525,509 1

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

  • Hash Cond: ((pv.venture_id = usr.venture_id) AND (pv.client_id = usr.id))
5. 8.929 8.929 ↑ 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.019..8.929 rows=79,740 loops=1)

6. 416.118 3,363.004 ↓ 2.7 1,525,509 1

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

  • Buckets: 65536 (originally 65536) Batches: 64 (originally 32) Memory Usage: 3585kB
7. 397.446 2,946.886 ↓ 2.7 1,525,509 1

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

  • Hash Cond: ((lac.venture_id = usr.venture_id) AND (lac.client_id = usr.id))
8. 61.570 61.570 ↑ 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.554..61.570 rows=74,902 loops=1)

9. 414.684 2,487.870 ↓ 2.7 1,525,509 1

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

  • Buckets: 65536 (originally 65536) Batches: 64 (originally 32) Memory Usage: 3585kB
10. 509.370 2,073.186 ↓ 2.7 1,525,509 1

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

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

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

12. 440.892 1,538.934 ↓ 2.7 1,525,509 1

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

  • Buckets: 65536 (originally 65536) Batches: 32 (originally 16) Memory Usage: 3881kB
13. 282.763 1,098.042 ↓ 2.7 1,525,509 1

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

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

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

  • Hash Cond: (usr.venture_id = ven.id)
15. 443.453 443.453 ↑ 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.430..443.453 rows=1,525,509 loops=1)

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

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
17. 0.446 0.446 ↑ 1.0 44 1

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

18. 0.003 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: 1024 Batches: 1 Memory Usage: 9kB
19. 0.012 0.012 ↑ 1.0 13 1

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

Planning time : 46.326 ms
Execution time : 5,853.966 ms