explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jk63 : TEST

Settings
# exclusive inclusive rows x rows loops node
1. 0.023 0.117 ↓ 4.0 28 1

Hash Join (cost=19.24..21.76 rows=7 width=8) (actual time=0.101..0.117 rows=28 loops=1)

  • Hash Cond: (vrs.art_modele_id = art.article_modele_id)
  • Buffers: shared hit=11
2. 0.043 0.043 ↑ 1.0 83 1

Seq Scan on art_modele_vrs vrs (cost=0.00..1.83 rows=83 width=8) (actual time=0.035..0.043 rows=83 loops=1)

  • Buffers: shared hit=1
3. 0.006 0.051 ↓ 3.8 15 1

Hash (cost=19.19..19.19 rows=4 width=8) (actual time=0.051..0.051 rows=15 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=10
4. 0.045 0.045 ↓ 3.8 15 1

Index Scan using fki_art_cat on article_client art (cost=0.29..19.19 rows=4 width=8) (actual time=0.022..0.045 rows=15 loops=1)

  • Index Cond: (cat_id = 9278)
  • Filter: (article_modele_id IS NOT NULL)
  • Buffers: shared hit=10
Planning time : 0.220 ms
Execution time : 0.174 ms