explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7QW

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

Nested Loop (cost=84.17..1,160.57 rows=27 width=4) (actual time=0.016..0.016 rows=0 loops=1)

  • Join Filter: (pdd.id_droit = dr.id_droit)
2. 0.001 0.016 ↓ 0.0 0 1

Nested Loop (cost=84.17..1,137.89 rows=409 width=33) (actual time=0.016..0.016 rows=0 loops=1)

3. 0.000 0.015 ↓ 0.0 0 1

Nested Loop (cost=83.76..1,085.75 rows=15 width=33) (actual time=0.015..0.015 rows=0 loops=1)

4. 0.000 0.015 ↓ 0.0 0 1

Hash Join (cost=78.64..1,052.22 rows=6 width=165) (actual time=0.015..0.015 rows=0 loops=1)

  • Hash Cond: (ah.id_affectation_serie = afs.id_affectation_serie)
5. 0.002 0.015 ↓ 0.0 0 1

Bitmap Heap Scan on t_affectation_history ah (cost=15.20..987.38 rows=359 width=264) (actual time=0.015..0.015 rows=0 loops=1)

  • Recheck Cond: (id_dossier = 'aaa'::bpchar)
6. 0.013 0.013 ↓ 0.0 0 1

Bitmap Index Scan on t_affectation_history_id_dossier_idx (cost=0.00..15.11 rows=359 width=0) (actual time=0.013..0.013 rows=0 loops=1)

  • Index Cond: (id_dossier = 'aaa'::bpchar)
7. 0.000 0.000 ↓ 0.0 0

Hash (cost=60.60..60.60 rows=227 width=66) (never executed)

8. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.70..60.60 rows=227 width=66) (never executed)

9. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.41..16.71 rows=1 width=165) (never executed)

10. 0.000 0.000 ↓ 0.0 0

Index Scan using t_user_pkey on t_user u (cost=0.27..8.29 rows=1 width=66) (never executed)

  • Index Cond: (id_user = 'aaaaaaa'::bpchar)
  • Filter: ((NOT boo_supprime) AND (NOT boo_en_migration))
11. 0.000 0.000 ↓ 0.0 0

Index Scan using t_abonne_pkey on t_abonne ab (cost=0.14..8.16 rows=1 width=264) (never executed)

  • Index Cond: (id_abonne = u.id_abonne)
12. 0.000 0.000 ↓ 0.0 0

Index Scan using t_affectation_serie_id_org_prestataire_idx on t_affectation_serie afs (cost=0.29..41.17 rows=272 width=66) (never executed)

  • Index Cond: (id_org_prestataire = ab.id_org)
  • Filter: ((type_traitement)::text = ANY ('{VALIDATION_AR,VALIDATION_ATTR,REFUS_ATTR,FERME}'::text[]))
13. 0.000 0.000 ↓ 0.0 0

Materialize (cost=5.13..33.31 rows=3 width=99) (never executed)

14. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=5.13..33.30 rows=3 width=99) (never executed)

15. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..22.62 rows=1 width=99) (never executed)

16. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.69..14.45 rows=1 width=132) (never executed)

17. 0.000 0.000 ↓ 0.0 0

Index Scan using t_dossier_pkey on t_dossier d (cost=0.42..8.44 rows=1 width=33) (never executed)

  • Index Cond: (id_dossier = 'aaa'::bpchar)
  • Filter: ((NOT boo_supprime) AND (NOT boo_en_migration))
18. 0.000 0.000 ↓ 0.0 0

Index Scan using t_role_org_utilisateurs_id_role_idx on t_role_organisations_utilisateurs rou (cost=0.27..6.01 rows=1 width=99) (never executed)

  • Index Cond: (id_role = 'aaa'::bpchar)
  • Filter: ((NOT boo_supprime) AND (NOT boo_en_migration) AND (id_user = 'aaaaaaa'::bpchar))
19. 0.000 0.000 ↓ 0.0 0

Index Scan using t_role_code_tech_role_idx on t_role r (cost=0.14..8.16 rows=1 width=132) (never executed)

  • Index Cond: ((code_tech_role)::text = 'ECSS'::text)
  • Filter: (id_role = 'aaa'::bpchar)
20. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on t_profil_droits pd (cost=4.29..10.65 rows=2 width=66) (never executed)

  • Recheck Cond: (id_role_user = rou.id_role_organisations_utilisateurs)
  • Filter: ((NOT boo_supprime) AND (NOT boo_en_migration))
21. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on t_profil_droits_id_role_user_idx (cost=0.00..4.29 rows=2 width=0) (never executed)

  • Index Cond: (id_role_user = rou.id_role_organisations_utilisateurs)
22. 0.000 0.000 ↓ 0.0 0

Index Scan using t_profil_droits_lnk_t_droit_id_profil_droits_idx on t_profil_droits_lnk_t_droit pdd (cost=0.41..3.20 rows=28 width=66) (never executed)

  • Index Cond: (id_profil_droits = pd.id_profil_droits)
23. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..10.46 rows=2 width=132) (never executed)

24. 0.000 0.000 ↓ 0.0 0

Seq Scan on t_droit dr (cost=0.00..10.45 rows=2 width=132) (never executed)

  • Filter: (((lib_technique)::text = 'MNG_DOSSIERS'::text) OR ((lib_technique)::text = 'READ_DOSSIERS'::text))