explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Gswx

Settings
# exclusive inclusive rows x rows loops node
1. 0.261 5.106 ↓ 1.2 804 1

Hash Join (cost=80.33..5,587.85 rows=663 width=131) (actual time=0.611..5.106 rows=804 loops=1)

  • Hash Cond: (jim.magasin_id = m.id)
2. 0.159 4.311 ↓ 1.2 804 1

Nested Loop (cost=2.80..5,508.58 rows=663 width=139) (actual time=0.070..4.311 rows=804 loops=1)

3. 0.307 2.544 ↓ 1.2 804 1

Hash Join (cost=2.37..5,186.95 rows=663 width=139) (actual time=0.061..2.544 rows=804 loops=1)

  • Hash Cond: (igai.groupe_article_id = ga.id)
4. 0.265 2.218 ↓ 1.2 804 1

Nested Loop (cost=0.85..5,183.37 rows=663 width=147) (actual time=0.032..2.218 rows=804 loops=1)

5. 0.345 0.345 ↓ 1.2 804 1

Index Scan using inventaire_date_inventaire_idx on inventaire i (cost=0.43..71.36 rows=663 width=131) (actual time=0.021..0.345 rows=804 loops=1)

  • Index Cond: (date_inventaire = (CURRENT_DATE - 1))
6. 1.608 1.608 ↑ 1.0 1 804

Index Scan using join_inventaire_groupe_article_inventaire_idx on join_inventaire_groupe_article igai (cost=0.42..7.70 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=804)

  • Index Cond: (inventaire_id = i.id)
7. 0.006 0.019 ↑ 1.0 23 1

Hash (cost=1.23..1.23 rows=23 width=8) (actual time=0.019..0.019 rows=23 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
8. 0.013 0.013 ↑ 1.0 23 1

Seq Scan on groupe_article ga (cost=0.00..1.23 rows=23 width=8) (actual time=0.010..0.013 rows=23 loops=1)

9. 1.608 1.608 ↑ 1.0 1 804

Index Scan using join_inventaire_magasin_inventaire_idx on join_inventaire_magasin jim (cost=0.42..0.48 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=804)

  • Index Cond: (inventaire_id = igai.inventaire_id)
10. 0.215 0.534 ↑ 1.0 1,357 1

Hash (cost=60.57..60.57 rows=1,357 width=8) (actual time=0.534..0.534 rows=1,357 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 70kB
11. 0.319 0.319 ↑ 1.0 1,357 1

Seq Scan on magasin m (cost=0.00..60.57 rows=1,357 width=8) (actual time=0.013..0.319 rows=1,357 loops=1)

Planning time : 1.596 ms
Execution time : 5.222 ms