explain.depesz.com

PostgreSQL's explain analyze made readable

Result: m4ei : TEST

Settings
# exclusive inclusive rows x rows loops node
1. 1.962 2,958.236 ↓ 1,821.0 1,821 1

Sort (cost=98.47..98.48 rows=1 width=64) (actual time=2,958.039..2,958.236 rows=1,821 loops=1)

  • Sort Key: prm.svccmd_id
  • Sort Method: quicksort Memory: 205kB
  • Buffers: shared hit=5317 read=706 dirtied=5
2. 2.511 2,956.274 ↓ 1,821.0 1,821 1

Nested Loop (cost=86.42..98.46 rows=1 width=64) (actual time=68.476..2,956.274 rows=1,821 loops=1)

  • Buffers: shared hit=5314 read=706 dirtied=5
3. 428.567 428.567 ↓ 326.0 326 1

Index Scan using svccmd_projet_art_id on svccmd svc (cost=0.43..8.45 rows=1 width=4) (actual time=11.489..428.567 rows=326 loops=1)

  • Index Cond: ((projet_id = 129461) AND (article_id = 46591))
  • Filter: (stg_id = 122)
  • Buffers: shared hit=119 read=190
4. 2,154.534 2,525.196 ↓ 6.0 6 326

Bitmap Heap Scan on svccmd_param prm (cost=85.99..90.00 rows=1 width=64) (actual time=3.153..7.746 rows=6 loops=326)

  • Recheck Cond: ((svccmd_id = svc.svccmd_id) AND (art_grp_id = 628868))
  • Filter: is_visible
  • Heap Blocks: exact=1443
  • Buffers: shared hit=5195 read=516 dirtied=5
5. 0.978 370.662 ↓ 0.0 0 326

BitmapAnd (cost=85.99..85.99 rows=1 width=0) (actual time=1.137..1.137 rows=0 loops=326)

  • Buffers: shared hit=4210 read=58
6. 279.382 279.382 ↑ 8.1 30 326

Bitmap Index Scan on fk_svccmd_id_param (cost=0.00..6.39 rows=243 width=0) (actual time=0.857..0.857 rows=30 loops=326)

  • Index Cond: (svccmd_id = svc.svccmd_id)
  • Buffers: shared hit=1284 read=50
7. 90.302 90.302 ↑ 2.0 1,992 326

Bitmap Index Scan on svccmd_param_art_grp_id (cost=0.00..78.39 rows=3,977 width=0) (actual time=0.277..0.277 rows=1,992 loops=326)

  • Index Cond: (art_grp_id = 628868)
  • Buffers: shared hit=2926 read=8
Planning time : 3.305 ms
Execution time : 2,958.407 ms