explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wPZf

Settings
# exclusive inclusive rows x rows loops node
1. 0.029 153.196 ↓ 16.0 16 1

Sort (cost=103,420.74..103,420.74 rows=1 width=124) (actual time=153.195..153.196 rows=16 loops=1)

  • Sort Key: article.article_id
  • Sort Method: quicksort Memory: 27kB
2. 0.011 153.167 ↓ 16.0 16 1

Nested Loop Left Join (cost=103,278.11..103,420.73 rows=1 width=124) (actual time=152.753..153.167 rows=16 loops=1)

3. 0.006 152.932 ↓ 16.0 16 1

Nested Loop Left Join (cost=103,278.11..103,415.72 rows=1 width=88) (actual time=152.742..152.932 rows=16 loops=1)

4. 0.003 152.878 ↓ 16.0 16 1

Nested Loop Left Join (cost=103,277.67..103,409.63 rows=1 width=60) (actual time=152.735..152.878 rows=16 loops=1)

5. 0.006 152.795 ↓ 16.0 16 1

Nested Loop (cost=103,277.23..103,403.81 rows=1 width=32) (actual time=152.723..152.795 rows=16 loops=1)

6. 0.043 152.709 ↓ 1.1 16 1

HashAggregate (cost=103,276.80..103,276.95 rows=15 width=4) (actual time=152.704..152.709 rows=16 loops=1)

  • Group Key: tag.tag_article_id
7. 152.666 152.666 ↓ 1.1 16 1

Index Only Scan using tag_ak on tag (cost=0.56..103,276.76 rows=15 width=4) (actual time=6.488..152.666 rows=16 loops=1)

  • Index Cond: ((tag_dossier_id = 26) AND (tag_code = 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[])))
  • Heap Fetches: 16
8. 0.080 0.080 ↑ 1.0 1 16

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=16)

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

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

  • 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.048 0.048 ↓ 0.0 0 16

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

  • 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.224 0.224 ↑ 1.0 1 16

Seq Scan on etablissement (cost=0.00..5.00 rows=1 width=36) (actual time=0.004..0.014 rows=1 loops=16)

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