explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 74vV : Optimization for: req delete 1; plan #0fS2

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 9.464 15.853 ↓ 0.0 0 1

Delete on histo_routeur_intranet (cost=70.94..11,017.52 rows=2,887 width=6) (actual time=15.853..15.853 rows=0 loops=1)

2. 3.391 6.389 ↓ 3.2 9,213 1

Bitmap Heap Scan on histo_routeur_intranet (cost=70.94..11,017.52 rows=2,887 width=6) (actual time=3.059..6.389 rows=9,213 loops=1)

  • Recheck Cond: ((feuillet)::text = 'CD015W2ECE'::text)
  • Heap Blocks: exact=164
3. 2.998 2.998 ↓ 3.2 9,213 1

Bitmap Index Scan on idx_feuillet (cost=0.00..70.22 rows=2,887 width=0) (actual time=2.998..2.998 rows=9,213 loops=1)

  • Index Cond: ((feuillet)::text = 'CD015W2ECE'::text)