explain.depesz.com

PostgreSQL's explain analyze made readable

Result: L9E : Avant

Settings
# exclusive inclusive rows x rows loops node
1. 0.192 11,288.107 ↓ 267.0 267 1

WindowAgg (cost=4,015.82..4,015.86 rows=1 width=61) (actual time=11,288.041..11,288.107 rows=267 loops=1)

2. 1.076 11,287.915 ↓ 267.0 267 1

HashAggregate (cost=4,015.82..4,015.84 rows=1 width=61) (actual time=11,287.841..11,287.915 rows=267 loops=1)

3. 0.564 11,286.839 ↓ 267.0 267 1

Nested Loop Left Join (cost=0.99..4,015.81 rows=1 width=61) (actual time=12.773..11,286.839 rows=267 loops=1)

  • Filter: ((groupeclie10_.id IS NULL) OR (groupeclie10_.id = ANY ('{16,56}'::bigint[])))
4. 0.339 11,286.275 ↓ 267.0 267 1

Nested Loop Left Join (cost=0.99..4,015.52 rows=1 width=69) (actual time=12.764..11,286.275 rows=267 loops=1)

5. 0.301 11,285.135 ↓ 267.0 267 1

Nested Loop Left Join (cost=0.99..4,015.13 rows=1 width=61) (actual time=12.745..11,285.135 rows=267 loops=1)

6. 0.349 11,282.965 ↓ 267.0 267 1

Nested Loop Left Join (cost=0.99..4,007.90 rows=1 width=49) (actual time=12.732..11,282.965 rows=267 loops=1)

7. 0.543 11,282.616 ↓ 267.0 267 1

Nested Loop (cost=0.99..4,007.11 rows=1 width=54) (actual time=12.731..11,282.616 rows=267 loops=1)

8. 0.456 11,281.085 ↓ 494.0 494 1

Nested Loop (cost=0.99..4,006.82 rows=1 width=62) (actual time=12.724..11,281.085 rows=494 loops=1)

9. 0.710 11,278.653 ↓ 494.0 494 1

Nested Loop (cost=0.99..4,006.48 rows=1 width=62) (actual time=12.714..11,278.653 rows=494 loops=1)

10. 30.260 11,274.979 ↓ 494.0 494 1

Nested Loop (cost=0.99..4,000.59 rows=1 width=61) (actual time=12.698..11,274.979 rows=494 loops=1)

11. 412.791 1,242.715 ↓ 4,513.5 2,500,501 1

Nested Loop (cost=0.99..3,340.15 rows=554 width=23) (actual time=0.063..1,242.715 rows=2,500,501 loops=1)

12. 16.923 57.174 ↓ 315.4 15,455 1

Merge Join (cost=0.99..2,539.42 rows=49 width=23) (actual time=0.046..57.174 rows=15,455 loops=1)

  • Merge Cond: (referencep5_.fk_informationreferencetabac = informatio6_.id)
13. 30.488 30.488 ↑ 1.4 15,456 1

Index Scan using idx_informationreferencetabac_referenceproduitfournisseur on referenceproduitfournisseur referencep5_ (cost=0.00..34,045.30 rows=21,158 width=24) (actual time=0.024..30.488 rows=15,456 loops=1)

  • Filter: ((fk_informationreferenceerecharge IS NULL) AND (groupeid = ANY ('{1,16844}'::integer[])))
  • Rows Removed by Filter: 44166
14. 9.763 9.763 ↑ 1.0 15,455 1

Index Scan using informationreferencetabac_pkey on informationreferencetabac informatio6_ (cost=0.00..917.70 rows=15,455 width=15) (actual time=0.014..9.763 rows=15,455 loops=1)

  • Index Cond: (id IS NOT NULL)
15. 772.750 772.750 ↑ 2.1 162 15,455

Index Scan using idx_referenceproduitfournisseur_re_produitref on re_produit_referenceproduitfournisseur referencep4_ (cost=0.00..12.94 rows=340 width=16) (actual time=0.004..0.050 rows=162 loops=15,455)

  • Index Cond: (fk_referenceproduitfournisseur = referencep5_.id)
16. 10,002.004 10,002.004 ↓ 0.0 0 2,500,501

Index Scan using produit_pkey on produit produit0_ (cost=0.00..1.18 rows=1 width=46) (actual time=0.004..0.004 rows=0 loops=2,500,501)

  • Index Cond: (id = referencep4_.fk_produit)
  • Filter: ((NOT estproduitgenerique) AND estreference AND (fk_produitparent IS NULL) AND estactif AND (datesuppression IS NULL) AND (groupeid = ANY ('{1,16844}'::integer[])) AND ((localiteclientstrator IS NULL) OR (localiteclientstrator = 'ESPAGNE'::text)))
  • Rows Removed by Filter: 1
17. 2.964 2.964 ↑ 1.0 1 494

Index Scan using categoriefamille_pkey on categoriefamille categorief1_ (cost=0.00..5.87 rows=1 width=17) (actual time=0.005..0.006 rows=1 loops=494)

  • Index Cond: (id = produit0_.fk_categoriefamille)
18. 1.976 1.976 ↑ 1.0 1 494

Index Scan using categoriemetier_pkey on categorieactivite categoriea2_ (cost=0.00..0.34 rows=1 width=16) (actual time=0.004..0.004 rows=1 loops=494)

  • Index Cond: (id = categorief1_.fk_categorieactivite)
19. 0.988 0.988 ↑ 1.0 1 494

Index Scan using metiernational_pkey on metiernational metiernati3_ (cost=0.00..0.27 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=494)

  • Index Cond: (id = categoriea2_.fk_metiernational)
  • Filter: (codemetiernational = '010'::text)
  • Rows Removed by Filter: 0
20. 0.000 0.000 ↓ 0.0 0 267

Index Scan using informationreferenceautre_pkey on informationreferenceautre informatio7_ (cost=0.00..0.78 rows=1 width=11) (actual time=0.000..0.000 rows=0 loops=267)

  • Index Cond: (referencep5_.fk_informationreferenceautre = id)
21. 1.869 1.869 ↑ 1.0 1 267

Index Scan using fk_produit_unique on stock stock8_ (cost=0.00..7.22 rows=1 width=20) (actual time=0.006..0.007 rows=1 loops=267)

  • Index Cond: (produit0_.id = fk_produit)
  • Filter: (groupeid = ANY ('{1,16844}'::integer[]))
22. 0.801 0.801 ↓ 0.0 0 267

Index Only Scan using idx_produit_groupeclientstrator on re_produit_groupeclientstrator groupeclie9_ (cost=0.00..0.38 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=267)

  • Index Cond: (fk_produit = produit0_.id)
  • Heap Fetches: 0
23. 0.000 0.000 ↓ 0.0 0 267

Index Only Scan using groupeclientstrator_pkey on groupeclientstrator groupeclie10_ (cost=0.00..0.27 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=267)

  • Index Cond: (id = groupeclie9_.fk_groupeclientstrator)
  • Heap Fetches: 0