explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mwyR

Settings
# exclusive inclusive rows x rows loops node
1. 0.013 8,555.932 ↑ 1.0 1 1

Aggregate (cost=673,868.55..673,868.56 rows=1 width=8) (actual time=8,555.932..8,555.932 rows=1 loops=1)

2. 0.008 8,555.919 ↓ 1.2 10 1

Nested Loop Left Join (cost=1.71..673,868.53 rows=8 width=0) (actual time=108.357..8,555.919 rows=10 loops=1)

  • Join Filter: ((profiltarif.profiltarif_id = tarifvente.tarifvente_profiltarif_id) OR ((profiltarif.profiltarif_id IS NULL) AND (tarifvente.tarifvente_profiltarif_id IS NULL)))
3. 0.023 8,555.861 ↓ 1.2 10 1

Nested Loop Anti Join (cost=1.28..673,767.37 rows=8 width=8) (actual time=108.349..8,555.861 rows=10 loops=1)

  • Join Filter: (tarifventeactuel.tarifventeactuel_profiltarif_id = profiltarif.profiltarif_id)
  • Rows Removed by Join Filter: 160
4. 0.021 8,555.818 ↓ 1.1 10 1

Nested Loop Left Join (cost=1.28..673,764.01 rows=9 width=8) (actual time=108.335..8,555.818 rows=10 loops=1)

5. 0.008 8,555.687 ↓ 1.1 10 1

Nested Loop (cost=0.85..673,723.63 rows=9 width=4) (actual time=108.309..8,555.687 rows=10 loops=1)

6. 0.022 0.022 ↑ 1.0 1 1

Index Only Scan using produit_pk on produit (cost=0.43..8.45 rows=1 width=4) (actual time=0.021..0.022 rows=1 loops=1)

  • Index Cond: (produit_id = 1788900)
  • Heap Fetches: 1
7. 1.877 8,555.657 ↓ 1.1 10 1

Index Scan using article_produit_sk on article (cost=0.43..673,715.09 rows=9 width=8) (actual time=108.287..8,555.657 rows=10 loops=1)

  • Index Cond: ((article_dossier_id = 189) AND (article_produit_id = 1788900))
  • Filter: ((article_etat = 0) AND (article_type = 20) AND (SubPlan 1))
  • Rows Removed by Filter: 81
8.          

SubPlan (forIndex Scan)

9. 6,380.550 8,553.780 ↓ 32.6 163 90

Bitmap Heap Scan on artgrilleval (cost=4,320.66..17,762.12 rows=5 width=4) (actual time=81.097..95.042 rows=163 loops=90)

  • Recheck Cond: (artgrilleval_dossier_id = article.article_dossier_id)
  • Filter: (artgrilleval_grillevaleur_id = 233953)
  • Rows Removed by Filter: 694249
  • Heap Blocks: exact=880443
10. 2,173.230 2,173.230 ↓ 6.1 747,594 90

Bitmap Index Scan on artgrilleval_article_id_sk (cost=0.00..4,320.66 rows=121,631 width=0) (actual time=24.147..24.147 rows=747,594 loops=90)

  • Index Cond: (artgrilleval_dossier_id = article.article_dossier_id)
11. 0.110 0.110 ↑ 1.0 1 10

Index Only Scan using tarifventeactuel_ak on tarifventeactuel (cost=0.43..4.48 rows=1 width=8) (actual time=0.010..0.011 rows=1 loops=10)

  • Index Cond: ((tarifventeactuel_article_id = article.article_id) AND (tarifventeactuel_etablissement_id = 342))
  • Heap Fetches: 3
12. 0.013 0.020 ↑ 1.0 16 10

Materialize (cost=0.00..1.24 rows=16 width=4) (actual time=0.001..0.002 rows=16 loops=10)

13. 0.007 0.007 ↑ 1.0 16 1

Seq Scan on profiltarif (cost=0.00..1.16 rows=16 width=4) (actual time=0.005..0.007 rows=16 loops=1)

14. 0.050 0.050 ↓ 0.0 0 10

Index Scan using tarifvente_article_sk on tarifvente (cost=0.42..12.62 rows=2 width=8) (actual time=0.005..0.005 rows=0 loops=10)

  • Index Cond: (tarifvente_article_id = article.article_id)
  • Filter: (('2019-08-09 17:38:57'::timestamp without time zone >= tarifvente_debut) AND ('2019-08-09 17:38:57'::timestamp without time zone <= tarifvente_fin) AND (tarifvente_prixcalcule = 0))
Planning time : 1.150 ms