explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LVn5

Settings
# exclusive inclusive rows x rows loops node
1. 0.018 73.503 ↓ 17.0 17 1

Sort (cost=9,319.03..9,319.03 rows=1 width=124) (actual time=73.501..73.503 rows=17 loops=1)

  • Sort Key: article.article_id
  • Sort Method: quicksort Memory: 27kB
2. 0.011 73.485 ↓ 17.0 17 1

Nested Loop Left Join (cost=9,183.65..9,319.02 rows=1 width=124) (actual time=72.991..73.485 rows=17 loops=1)

3. 0.000 73.185 ↓ 17.0 17 1

Nested Loop Left Join (cost=9,183.65..9,313.01 rows=1 width=88) (actual time=72.977..73.185 rows=17 loops=1)

4. 0.015 73.136 ↓ 17.0 17 1

Nested Loop Left Join (cost=9,183.21..9,307.02 rows=1 width=60) (actual time=72.972..73.136 rows=17 loops=1)

5. 0.010 73.036 ↓ 17.0 17 1

Nested Loop (cost=9,182.77..9,301.02 rows=1 width=32) (actual time=72.957..73.036 rows=17 loops=1)

6. 0.020 72.941 ↓ 1.2 17 1

HashAggregate (cost=9,182.34..9,182.48 rows=14 width=4) (actual time=72.937..72.941 rows=17 loops=1)

  • Group Key: tag.tag_article_id
7. 72.921 72.921 ↓ 1.2 17 1

Index Only Scan using tag_ak on tag (cost=0.56..9,182.30 rows=14 width=4) (actual time=6.642..72.921 rows=17 loops=1)

  • Index Cond: (tag_dossier_id = 26)
  • Filter: ((tag_code)::text = ANY ('{FBEKA-16304204,FBRABA-12.72.67,FBRABA-48.05.84,FBRABA-48.07.44,FCHEVA-752,FDEBUY-3353.00,FEMSA-504180,FEMSA-618101600,FEMSA-618351600,FEMSA-618501600,FEMSA-618701600,FFRATE-27140263,FN2J-2320-M122,FOPINE-001381,FOPINE-001532,FOPINE-001626,FOPINE-001903,FOPINE-001904,FOPINE-001905,FOPINE-001906,FOPINE-001907,FOPINE-001913,FOPINE-001914,FOPINE-001916,FOPINE-001932,FOPINE-001939,FOPINE-002040,FPSP-29920,FRIVIE-QPL370,FTELLI-N3008X}'::text[]))
  • Rows Removed by Filter: 112160
  • Heap Fetches: 591
8. 0.085 0.085 ↑ 1.0 1 17

Index Scan using article_pk on article (cost=0.43..8.46 rows=1 width=32) (actual time=0.005..0.005 rows=1 loops=17)

  • Index Cond: (article_id = tag.tag_article_id)
  • Filter: ((article_dossier_id = 26) AND (article_etat = 0))
9. 0.085 0.085 ↑ 1.0 1 17

Index Scan using stock_article_id_sk on stock stock_depottous_ (cost=0.44..5.98 rows=1 width=32) (actual time=0.005..0.005 rows=1 loops=17)

  • Index Cond: ((stock_dossier_id = 26) AND (article.article_id = stock_article_id))
  • Filter: ((stock_depotidx = 0) AND (stock_etablissement_id = 36))
  • Rows Removed by Filter: 1
10. 0.051 0.051 ↓ 0.0 0 17

Index Scan using stock_article_id_sk on stock stock_depotweb_ (cost=0.44..5.98 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=17)

  • Index Cond: ((stock_dossier_id = 26) AND (article.article_id = stock_article_id))
  • Filter: ((stock_depotidx = '-1'::integer) AND (stock_etablissement_id = 36))
  • Rows Removed by Filter: 2
11. 0.289 0.289 ↑ 1.0 1 17

Seq Scan on etablissement (cost=0.00..6.00 rows=1 width=36) (actual time=0.005..0.017 rows=1 loops=17)

  • Filter: (etablissement_id = 36)
  • Rows Removed by Filter: 160