explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZBr

Settings
# exclusive inclusive rows x rows loops node
1. 689.044 721.642 ↓ 0.0 0 1

Update on ent_vente_tmp (cost=4.70..630.47 rows=416 width=3,773) (actual time=721.642..721.642 rows=0 loops=1)

  • Recheck Cond: (numero_commande IS NULL)
  • Heap Blocks: exact=1204
  • Index Cond: (numero_commande IS NULL)
2. 28.184 28.184 ↓ 24.0 9,991 1

Bitmap Heap Scan on ent_vente_tmp (cost=4.70..630.47 rows=416 width=3,773) (actual time=13.064..28.184 rows=9,991 loops=1)

3. 4.414 4.414 ↓ 72.1 29,980 1

Bitmap Index Scan on ent_vente_tmp_numero_integre (cost=0.00..4.68 rows=416 width=0) (actual time=4.414..4.414 rows=29,980 loops=1)