explain.depesz.com

PostgreSQL's explain analyze made readable

Result: M9lE

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 33,242.407 ↓ 0.0 0 1

Limit (cost=409,703.63..442,317.97 rows=1 width=807) (actual time=33,242.407..33,242.407 rows=0 loops=1)

2. 0.001 33,242.406 ↓ 0.0 0 1

Nested Loop Left Join (cost=409,703.63..442,317.97 rows=1 width=807) (actual time=33,242.406..33,242.406 rows=0 loops=1)

3. 0.000 33,242.405 ↓ 0.0 0 1

Nested Loop (cost=409,703.20..442,312.70 rows=1 width=377) (actual time=33,242.405..33,242.405 rows=0 loops=1)

  • Join Filter: (trtt.id_language = lang.id_language)
4. 0.001 33,242.405 ↓ 0.0 0 1

Nested Loop Left Join (cost=409,703.20..442,311.66 rows=1 width=410) (actual time=33,242.405..33,242.405 rows=0 loops=1)

  • Filter: ((ccpm.boo_supprime IS NOT TRUE) AND (ccpm.boo_en_migration IS NOT TRUE))
5. 0.001 33,242.404 ↓ 0.0 0 1

Merge Join (cost=409,702.92..442,307.32 rows=1 width=395) (actual time=33,242.404..33,242.404 rows=0 loops=1)

  • Merge Cond: (lien.id_role_tier_payant = trtt.id_tier_role_type)
6. 0.000 33,242.403 ↓ 0.0 0 1

Nested Loop (cost=409,698.18..898,763.45 rows=15 width=381) (actual time=33,242.403..33,242.403 rows=0 loops=1)

  • Join Filter: (t.id_tier = lien.id_tier)
7. 0.000 33,273.053 ↓ 0.0 0 1

Gather Merge (cost=1,000.53..323,172.06 rows=8 width=66) (actual time=33,242.402..33,273.053 rows=0 loops=1)

  • Workers Planned: 6
  • Workers Launched: 6
8. 232,644.993 232,644.993 ↓ 0.0 0 7

Parallel Index Scan using t_tier_lien_dossier_id_tier_role_type_idx on t_tier_lien_dossier lien (cost=0.43..322,170.99 rows=1 width=66) (actual time=33,234.999..33,234.999 rows=0 loops=7)

  • Filter: (id_dossier ~~ '10'::text)
  • Rows Removed by Filter: 484862
9. 0.000 0.000 ↓ 0.0 0

Materialize (cost=408,697.65..532,821.37 rows=97,464 width=348) (never executed)

10. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=408,697.65..527,860.05 rows=97,464 width=348) (never executed)

  • Hash Cond: (t.id_tier = t1.id_tier)
11. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=296,378.97..414,208.17 rows=95,614 width=333) (never executed)

  • Hash Cond: (t1_1.id_tier = t.id_tier)
12. 0.000 0.000 ↓ 0.0 0

Gather (cost=4,549.05..121,062.69 rows=95,844 width=264) (never executed)

  • Workers Planned: 5
  • Workers Launched: 0
13. 0.000 0.000 ↓ 0.0 0

Hash Left Join (cost=3,549.05..110,478.29 rows=19,169 width=264) (never executed)

  • Hash Cond: (tel1.id_telephone_type = telt.id_telephone_type)
14. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=3,547.78..110,408.94 rows=19,169 width=79) (never executed)

  • Hash Cond: (tel1.id_compte_client_personne = (t1_1.id_entity)::bpchar)
15. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on t_telephone tel1 (cost=0.00..104,382.66 rows=304,908 width=79) (never executed)

  • Filter: (boo_principale AND (boo_supprime IS NOT TRUE) AND (boo_en_migration IS NOT TRUE))
16. 0.000 0.000 ↓ 0.0 0

Hash (cost=2,886.79..2,886.79 rows=52,879 width=66) (never executed)

17. 0.000 0.000 ↓ 0.0 0

Seq Scan on t_tier t1_1 (cost=0.00..2,886.79 rows=52,879 width=66) (never executed)

18. 0.000 0.000 ↓ 0.0 0

Hash (cost=1.12..1.12 rows=12 width=350) (never executed)

19. 0.000 0.000 ↓ 0.0 0

Seq Scan on t_telephone_type telt (cost=0.00..1.12 rows=12 width=350) (never executed)

20. 0.000 0.000 ↓ 0.0 0

Hash (cost=291,170.52..291,170.52 rows=52,752 width=102) (never executed)

21. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=231,771.72..291,170.52 rows=52,752 width=102) (never executed)

  • Hash Cond: (ccpp.id_compte_client_personne = (t.id_entity)::bpchar)
  • Filter: ((ccpp.boo_supprime IS NOT TRUE) AND (ccpp.boo_en_migration IS NOT TRUE))
22. 0.000 0.000 ↓ 0.0 0

Seq Scan on t_compte_client_personne_physique ccpp (cost=0.00..46,149.02 rows=1,696,302 width=50) (never executed)

23. 0.000 0.000 ↓ 0.0 0

Hash (cost=231,112.32..231,112.32 rows=52,752 width=87) (never executed)

24. 0.000 0.000 ↓ 0.0 0

Gather Merge (cost=1,004.72..231,112.32 rows=52,752 width=87) (never executed)

  • Workers Planned: 3
  • Workers Launched: 0
25. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=4.68..223,913.92 rows=17,017 width=87) (never executed)

  • Filter: ((ccp.boo_supprime IS NOT TRUE) AND (ccp.boo_en_migration IS NOT TRUE))
26. 0.000 0.000 ↓ 0.0 0

Parallel Index Scan using t_tier_pkey on t_tier t (cost=0.41..82,876.81 rows=17,017 width=66) (never executed)

  • Filter: ((boo_supprime IS NOT TRUE) AND (boo_en_migration IS NOT TRUE) AND ((lib_entity_type)::text = 'TIER_CC'::text))
27. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on t_compte_client_personne ccp (cost=4.27..8.28 rows=1 width=56) (never executed)

  • Recheck Cond: (id_compte_client_personne = (t.id_entity)::bpchar)
28. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on t_compte_client_personne_pkey (cost=0.00..4.27 rows=1 width=0) (never executed)

  • Index Cond: (id_compte_client_personne = (t.id_entity)::bpchar)
29. 0.000 0.000 ↓ 0.0 0

Hash (cost=111,644.91..111,644.91 rows=53,902 width=48) (never executed)

30. 0.000 0.000 ↓ 0.0 0

Gather (cost=4,547.78..111,644.91 rows=53,902 width=48) (never executed)

  • Workers Planned: 5
  • Workers Launched: 0
31. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=3,547.78..105,254.71 rows=10,780 width=48) (never executed)

  • Hash Cond: (ac1.id_compte_client_personne = (t1.id_entity)::bpchar)
32. 0.000 0.000 ↓ 0.0 0

Parallel Seq Scan on t_adresse_courrier ac1 (cost=0.00..99,134.95 rows=328,557 width=48) (never executed)

  • Filter: (boo_principale AND (boo_supprime IS NOT TRUE) AND (boo_en_migration IS NOT TRUE))
33. 0.000 0.000 ↓ 0.0 0

Hash (cost=2,886.79..2,886.79 rows=52,879 width=66) (never executed)

34. 0.000 0.000 ↓ 0.0 0

Seq Scan on t_tier t1 (cost=0.00..2,886.79 rows=52,879 width=66) (never executed)

35. 0.000 0.000 ↓ 0.0 0

Sort (cost=4.47..4.62 rows=62 width=80) (never executed)

  • Sort Key: trtt.id_tier_role_type
36. 0.000 0.000 ↓ 0.0 0

Seq Scan on t_tier_role_type_traductions trtt (cost=0.00..2.62 rows=62 width=80) (never executed)

  • Filter: ((boo_supprime IS NOT TRUE) AND (boo_en_migration IS NOT TRUE))
37. 0.000 0.000 ↓ 0.0 0

Index Scan using t_compte_client_personne_morale_id_compte_client_personne_idx on t_compte_client_personne_morale ccpm (cost=0.29..4.33 rows=1 width=50) (never executed)

  • Index Cond: (id_compte_client_personne = (t.id_entity)::bpchar)
38. 0.000 0.000 ↓ 0.0 0

Seq Scan on t_language lang (cost=0.00..1.02 rows=1 width=132) (never executed)

  • Filter: ((boo_supprime IS NOT TRUE) AND (boo_en_migration IS NOT TRUE) AND ((lib_nom)::text ~~ '10'::text))
39. 0.000 0.000 ↓ 0.0 0

Index Scan using t_adresse_mail_id_compte_client_personne_idx on t_adresse_mail mai (cost=0.42..5.26 rows=1 width=57) (never executed)

  • Index Cond: (id_compte_client_personne = (t.id_entity)::bpchar)
  • Filter: (boo_active AND (boo_supprime IS NOT TRUE) AND (boo_en_migration IS NOT TRUE))