explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bSZ5J

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

Seq Scan on valorisation_article valorisati0_ (cost=0..49.21 rows=1 width=302) (never executed)

  • Filter: (identifiant_si_valorisation_article = (SubPlan 2))
2.          

SubPlan (for Seq Scan)

3. 0.000 0.000 ↓ 0.0

Seq Scan on suivi_application_cession suiviappli1_ (cost=1.27..2.52 rows=1 width=16) (never executed)

  • Filter: ((date_debut_application_cession = $2) AND (valorisati0_.identifiant_si_valorisation_article = identifiant_si_valorisation_article))
4.          

Initplan (for Seq Scan)

5. 0.000 0.000 ↓ 0.0

Aggregate (cost=1.26..1.27 rows=1 width=8) (never executed)

6. 0.000 0.000 ↓ 0.0

Result (cost=0..1.26 rows=1 width=8) (never executed)

7. 0.000 0.000 ↓ 0.0

Seq Scan on suivi_application_cession suiviappli2_ (cost=0..1.26 rows=1 width=8) (never executed)

  • Filter: ((date_debut_application_cession <= '2020-03-25 12:17:49+01'::timestamp with time zone) AND (valorisati0_.identifiant_si_valorisation_article = identifiant_si_valorisation_article))