explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Nnxo

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Update on transaction_ligne (cost=116,417.68..980,444.28 rows=650,957 width=3,762) (actual rows= loops=)

  • LOG: duration: 129652.697 ms statement: UPDATE transaction_ligne
2. 0.000 0.000 ↓ 0.0

Hash Join (cost=116,417.68..980,444.28 rows=650,957 width=3,762) (actual rows= loops=)

  • Hash Cond: (produit.pro_nmc_id = nomenclature_niveau.nmc_id)
  • Join Filter: ((transaction_ligne.trl_nmc_serial)::text <> (nomenclature_niveau.nmc_serial)::text)
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=115,635.22..965,831.61 rows=650,996 width=2,744) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on transaction_ligne (cost=115,634.80..623,791.92 rows=650,996 width=2,734) (actual rows= loops=)

  • Recheck Cond: ((trl_mag_id)::text = '012'::text)
5. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on idx_trl_date_retrait (cost=0.00..115,472.05 rows=650,996 width=0) (actual rows= loops=)

  • Index Cond: ((trl_mag_id)::text = '012'::text)
6. 0.000 0.000 ↓ 0.0

Index Scan using produit_pkey on produit (cost=0.42..0.52 rows=1 width=18) (actual rows= loops=)

  • Index Cond: ((pro_codeinterne)::text = (transaction_ligne.trl_pro_codeinterne)::text)
7. 0.000 0.000 ↓ 0.0

Hash (cost=569.98..569.98 rows=16,998 width=25) (actual rows= loops=)

  • Buckets: 32768 Batches: 1 Memory Usage: 1243kB
8. 0.000 0.000 ↓ 0.0

Seq Scan on nomenclature_niveau (cost=0.00..569.98 rows=16,998 width=25) (actual rows= loops=)