explain.depesz.com

A tool for finding a real cause for slow queries.

Result: zc9

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Limit (cost=309,804,005.99..309,804,020.67 rows=10 width=246) (actual time=.. rows= loops=)

2. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=309,804,005.99..329,640,911.85 rows=13,517,118 width=246) (actual time=.. rows= loops=)

3. 0.000 0.000 ↓ 0.0

Sort (cost=309,804,005.99..312,618,539.52 rows=1,125,813,410 width=246) (actual time=.. rows= loops=)

  • Sort Key: s.name, s.source_id, cp.nomreel, mv.partner_id
4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=241.76..9,715,579.30 rows=1,125,813,410 width=246) (actual time=.. rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash Join (cost=241.76..106,716.25 rows=784,814 width=242) (actual time=.. rows= loops=)

  • Hash Cond: (identites_to_sources.source_id = s.source_id)
6. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=240.55..95,923.85 rows=784,814 width=24) (actual time=.. rows= loops=)

  • Hash Cond: (mv.partner_id = cp.partner_id)
7. 0.000 0.000 ↓ 0.0

Merge Join (cost=28.74..84,920.85 rows=784,814 width=12) (actual time=.. rows= loops=)

  • Merge Cond: (identites_to_sources.idmembre = mv.idmembre)
8. 0.000 0.000 ↓ 0.0

Index Scan using identites_to_sources_idmembre_idx on identites_to_sources (cost=0.00..2,679.79 rows=62,256 width=16) (actual time=.. rows= loops=)

9. 0.000 0.000 ↓ 0.0

Index Scan using ix_member_visits_to_partner_idmembre on member_visits_to_partners mv (cost=0.00..72,019.63 rows=781,768 width=21) (actual time=.. rows= loops=)

10. 0.000 0.000 ↓ 0.0

Hash (cost=194.14..194.14 rows=1,414 width=16) (actual time=.. rows= loops=)

11. 0.000 0.000 ↓ 0.0

Seq Scan on cash_partner cp (cost=0.00..194.14 rows=1,414 width=16) (actual time=.. rows= loops=)

12. 0.000 0.000 ↓ 0.0

Hash (cost=1.09..1.09 rows=9 width=222) (actual time=.. rows= loops=)

13. 0.000 0.000 ↓ 0.0

Seq Scan on sources s (cost=0.00..1.09 rows=9 width=222) (actual time=.. rows= loops=)

14. 0.000 0.000 ↓ 0.0

Index Scan using cash_gain_partner_id_idx on cash_gain cg (cost=0.00..7.27 rows=398 width=8) (actual time=.. rows= loops=)

  • Index Cond: (partner_id = mv.partner_id)