explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2Oaq

Settings

Optimization(s) for this plan:

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

Aggregate (cost=4,281,686,764,203.85..4,281,686,764,203.86 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Seq Scan on fichier_trv f (cost=2,068,622.87..4,281,686,759,751.72 rows=1,780,851 width=0) (actual rows= loops=)

  • Filter: (NOT (SubPlan 1))
3.          

SubPlan (for Seq Scan)

4. 0.000 0.000 ↓ 0.0

Materialize (cost=2,068,622.87..4,376,626.70 rows=38,514,999 width=274) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Merge Join (cost=2,068,622.87..2,754,783.70 rows=38,514,999 width=274) (actual rows= loops=)

  • Merge Cond: (((i.ideper)::text = (f_1.ideper)::text) AND ((a.codtrt)::text = (f_1.codtrt)::text))
6. 0.000 0.000 ↓ 0.0

Sort (cost=357,064.03..358,145.39 rows=432,546 width=548) (actual rows= loops=)

  • Sort Key: i.ideper, a.codtrt
7. 0.000 0.000 ↓ 0.0

Merge Join (cost=0.85..240,537.33 rows=432,546 width=548) (actual rows= loops=)

  • Merge Cond: (i.ideind = a.ideind)
8. 0.000 0.000 ↓ 0.0

Index Scan using individu_pk on individu i (cost=0.43..197,335.11 rows=3,614,712 width=282) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Index Scan using accord_trv_fk1 on accord_trv a (cost=0.42..28,758.61 rows=432,546 width=282) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Materialize (cost=1,711,558.84..1,729,367.35 rows=3,561,702 width=548) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Sort (cost=1,711,558.84..1,720,463.10 rows=3,561,702 width=548) (actual rows= loops=)

  • Sort Key: f_1.ideper, f_1.codtrt
12. 0.000 0.000 ↓ 0.0

Seq Scan on fichier_trv f_1 (cost=0.00..71,807.02 rows=3,561,702 width=548) (actual rows= loops=)