explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lEb9

Settings

Optimization(s) for this plan:

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

Limit (cost=0.85..118,987.59 rows=1 width=6,051) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.85..118,987.59 rows=1 width=6,051) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.42..118,987.09 rows=1 width=6,055) (actual rows= loops=)

  • Join Filter: (v.id_brand = b.id_brand)
4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.42..118,986.07 rows=1 width=6,059) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on client c (cost=0.00..56,130.91 rows=4,181 width=6,051) (actual rows= loops=)

  • Filter: ((id_type_client <> 3) AND (lower((prenom)::text) ~~ '%yves%'::text))
6. 0.000 0.000 ↓ 0.0

Index Scan using ix_relationship34 on vente v (cost=0.42..15.02 rows=1 width=12) (actual rows= loops=)

  • Index Cond: (id_client = c.id_client)
  • Filter: ((SubPlan 1) = id_vente)
7.          

SubPlan (for Index Scan)

8. 0.000 0.000 ↓ 0.0

Aggregate (cost=8.45..8.46 rows=1 width=4) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Index Scan using ix_relationship34 on vente sv (cost=0.42..8.44 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id_client = c.id_client)
10. 0.000 0.000 ↓ 0.0

Seq Scan on brand b (cost=0.00..1.01 rows=1 width=4) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Index Scan using pfx_sale_address_id_sale on sale_address sa (cost=0.42..0.49 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id_sale = v.id_vente)