explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 87bo

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

HashAggregate (cost=5,304,479.07..5,306,499.84 rows=161,662 width=22) (actual rows= loops=)

  • Group Key: quitd.dequipol_numero_quittance, quitd.dequipol_code_garantie
2. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=3,683,785.53..5,302,862.45 rows=161,662 width=22) (actual rows= loops=)

  • Hash Cond: (((comm.comdet_source)::text = (quitd.dequipol_source)::text) AND (comm.comdet_numero_quittance = quitd.dequipol_numero_quittance) AND ((comm.comdet_code_regroupement)::text = (quitd.dequipol_code_garantie)::text))
3. 0.000 0.000 ↓ 0.0

Seq Scan on commission_detail comm (cost=0.00..668,159.82 rows=161,662 width=20) (actual rows= loops=)

  • Filter: (((comdet_source)::text = 'AUXIA'::text) AND (comdet_numero_agent = '237'::numeric))
4. 0.000 0.000 ↓ 0.0

Hash (cost=2,503,841.60..2,503,841.60 rows=48,485,653 width=27) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on detail_quittance quitd (cost=0.00..2,503,841.60 rows=48,485,653 width=27) (actual rows= loops=)

  • Filter: ((dequipol_source)::text = 'AUXIA'::text)