explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tKql

Settings
# exclusive inclusive rows x rows loops node
1. 0.257 4.860 ↓ 1.2 804 1

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

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

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

3. 0.250 2.452 ↓ 1.2 804 1

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

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

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

5. 0.366 0.366 ↓ 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.022..0.366 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.017 ↑ 1.0 23 1

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

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

Seq Scan on groupe_article ga (cost=0.00..1.23 rows=23 width=8) (actual time=0.008..0.011 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.216 0.499 ↑ 1.0 1,357 1

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

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

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

Planning time : 1.284 ms
Execution time : 4.984 ms