explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ihkG : Optimization for: Optimization for: plan #6nS7; plan #bN2q

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 21.102 8,038.228 ↓ 7,096.0 7,096 1

Nested Loop (cost=0.00..907.95 rows=1 width=154) (actual time=0.513..8,038.228 rows=7,096 loops=1)

2. 25.470 7,952.671 ↓ 6,445.5 12,891 1

Nested Loop (cost=0.00..907.38 rows=2 width=158) (actual time=0.482..7,952.671 rows=12,891 loops=1)

3. 14.306 100.313 ↓ 7,096.0 7,096 1

Nested Loop (cost=0.00..540.65 rows=1 width=142) (actual time=0.042..100.313 rows=7,096 loops=1)

4. 21.552 21.552 ↓ 12,891.0 12,891 1

Seq Scan on t_gfr_vente (cost=0.00..532.37 rows=1 width=134) (actual time=0.019..21.552 rows=12,891 loops=1)

  • Filter: ((statut_action = statut_action) AND (statut_facture = statut_facture))
5. 64.455 64.455 ↑ 1.0 1 12,891

Index Scan using pk_t_gfr_produit3 on t_gfr_produit (cost=0.00..8.27 rows=1 width=12) (actual time=0.004..0.005 rows=1 loops=12,891)

  • Index Cond: (produit_id = public.t_gfr_vente.produit_id)
  • Filter: ((code_source)::text = ANY ('{U,W}'::text[]))
6. 7,826.888 7,826.888 ↑ 1.0 2 7,096

Index Scan using gfr_vente_index on t_gfr_vente (cost=0.00..366.71 rows=2 width=29) (actual time=0.550..1.103 rows=2 loops=7,096)

  • Index Cond: ((num_contrat)::text = (public.t_gfr_vente.num_contrat)::text)
7. 64.455 64.455 ↑ 1.0 1 12,891

Index Scan using pk_t_gfr_produit3 on t_gfr_produit (cost=0.00..0.27 rows=1 width=4) (actual time=0.004..0.005 rows=1 loops=12,891)

  • Index Cond: (produit_id = public.t_gfr_vente.produit_id)
  • Filter: ((code_source)::text = ANY ('{D,W}'::text[]))