explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4Y1u : test1

Settings
# exclusive inclusive rows x rows loops node
1. 2,185.354 13,287.916 ↓ 11.2 237,939 1

Merge Join (cost=0.98..1,175,916.44 rows=21,269 width=434) (actual time=0.132..13,287.916 rows=237,939 loops=1)

  • Merge Cond: ((thxd.codepersonne)::text = (ta_rep_dw.codepersonne)::text)
  • Join Filter: (COALESCE(NULLIF(thxd.nochronorep, '-1'::integer), ta_rep_dw.nochrono) = ta_rep_dw.nochrono)
  • Rows Removed by Join Filter: 11845
2. 53.939 53.939 ↑ 1.0 79,336 1

Index Scan using ix_ta_histo_xml_dw_codep_3 on ta_histo_xml_dw thxd (cost=0.42..11,911.41 rows=79,336 width=434) (actual time=0.062..53.939 rows=79,336 loops=1)

3. 1,297.416 11,048.623 ↓ 8.6 8,356,019 1

Materialize (cost=0.56..1,081,151.64 rows=967,724 width=14) (actual time=0.065..11,048.623 rows=8,356,019 loops=1)

4. 3,135.575 9,751.207 ↓ 8.5 8,188,667 1

GroupAggregate (cost=0.56..1,069,055.09 rows=967,724 width=15) (actual time=0.060..9,751.207 rows=8,188,667 loops=1)

  • Group Key: ta_rep_dw.codepersonne, ta_rep_dw.nochrono, ta_rep_dw.codepm
5. 6,615.632 6,615.632 ↑ 1.0 9,515,849 1

Index Only Scan using ix_ta_rep_dw_clepm on ta_rep_dw (cost=0.56..986,798.62 rows=9,677,231 width=15) (actual time=0.043..6,615.632 rows=9,515,849 loops=1)

  • Heap Fetches: 9515849