explain.depesz.com

PostgreSQL's explain analyze made readable

Result: evlQq

Settings
# exclusive inclusive rows x rows loops node
1. 0.082 10.534 ↓ 39.0 39 1

Nested Loop Anti Join (cost=2.41..2,129.37 rows=1 width=12) (actual time=0.352..10.534 rows=39 loops=1)

  • Join Filter: (review.pro_id = depart.pro_id)
2.          

Initplan (forNested Loop Anti Join)

3. 0.003 0.003 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=1)

4. 0.034 10.317 ↓ 44.0 44 1

Nested Loop (cost=2.11..2,128.97 rows=1 width=23) (actual time=0.334..10.317 rows=44 loops=1)

5. 0.000 10.019 ↓ 44.0 44 1

Nested Loop (cost=1.69..2,128.22 rows=1 width=23) (actual time=0.322..10.019 rows=44 loops=1)

6. 0.485 7.170 ↓ 6.0 1,038 1

Nested Loop (cost=1.27..2,036.73 rows=173 width=12) (actual time=0.056..7.170 rows=1,038 loops=1)

7. 0.275 2.435 ↓ 7.3 850 1

Nested Loop (cost=0.84..1,945.83 rows=117 width=8) (actual time=0.045..2.435 rows=850 loops=1)

8. 0.360 0.360 ↓ 4.5 200 1

Index Scan using depart_pro_id_fkey on depart (cost=0.42..164.59 rows=44 width=8) (actual time=0.030..0.360 rows=200 loops=1)

  • Index Cond: (pro_id = 249)
9. 1.800 1.800 ↑ 2.2 4 200

Index Scan using dossier_dep_id_fkey on dossier (cost=0.42..40.39 rows=9 width=8) (actual time=0.004..0.009 rows=4 loops=200)

  • Index Cond: (dep_id = depart.dep_id)
10. 4.250 4.250 ↑ 3.0 1 850

Index Scan using dossier_participant_dos_id_fkey on dossier_participant (cost=0.42..0.75 rows=3 width=12) (actual time=0.005..0.005 rows=1 loops=850)

  • Index Cond: (dos_id = dossier.dos_id)
11. 3.114 3.114 ↓ 0.0 0 1,038

Index Scan using interview_reponse_dop_id_fkey on interview_reponse (cost=0.42..0.52 rows=1 width=19) (actual time=0.003..0.003 rows=0 loops=1,038)

  • Index Cond: (dop_id = dossier_participant.dop_id)
  • Filter: ((inr_satisfaction_globale IS NOT NULL) AND (inr_date_reponse >= $0) AND (inr_date_reponse >= (now() - '760 days'::interval)))
  • Rows Removed by Filter: 0
12. 0.264 0.264 ↑ 1.0 1 44

Index Scan using idx_utilisateur_id_utilisateur_atacama on utilisateur (cost=0.42..0.74 rows=1 width=8) (actual time=0.006..0.006 rows=1 loops=44)

  • Index Cond: (id_utilisateur_atacama = dossier_participant.per_id)
13. 0.132 0.132 ↓ 0.0 0 44

Index Scan using idx_43f2f406f675f31b on review (cost=0.28..0.31 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=44)

  • Index Cond: (author_id = utilisateur.id)
  • Filter: ((COALESCE(value, '0'::double precision) > '0'::double precision) AND (pro_id = 249))
  • Rows Removed by Filter: 0