explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rejJ

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.002 15,054.190 ↓ 0.0 0 1

Update on transaction_ligne (cost=118,805.83..971,464.25 rows=634,881 width=3,261) (actual time=15,054.190..15,054.190 rows=0 loops=1)

  • Buffers: shared hit=2601348 read=304047 dirtied=569
2. 350.355 15,054.188 ↓ 0.0 0 1

Hash Join (cost=118,805.83..971,464.25 rows=634,881 width=3,261) (actual time=15,054.188..15,054.188 rows=0 loops=1)

  • Hash Cond: (produit.pro_nmc_id = nomenclature_niveau.nmc_id)
  • Join Filter: ((transaction_ligne.trl_nmc_serial)::text <> (nomenclature_niveau.nmc_serial)::text)
  • Rows Removed by Join Filter: 638725
  • Buffers: shared hit=2601348 read=304047 dirtied=569
3. 562.092 14,691.753 ↓ 1.0 638,725 1

Nested Loop (cost=118,023.37..957,192.33 rows=634,919 width=2,243) (actual time=838.644..14,691.753 rows=638,725 loops=1)

  • Buffers: shared hit=2600998 read=303994 dirtied=569
4. 6,972.335 7,742.411 ↓ 1.0 638,725 1

Bitmap Heap Scan on transaction_ligne (cost=118,022.95..622,383.48 rows=634,919 width=2,233) (actual time=838.567..7,742.411 rows=638,725 loops=1)

  • Recheck Cond: ((trl_mag_id)::text = '012'::text)
  • Rows Removed by Index Recheck: 992809
  • Heap Blocks: exact=206694 lossy=107428
  • Buffers: shared hit=55935 read=289488 dirtied=559
5. 770.076 770.076 ↓ 1.0 643,715 1

Bitmap Index Scan on idx_trl_date_retrait (cost=0.00..117,864.22 rows=634,919 width=0) (actual time=770.076..770.076 rows=643,715 loops=1)

  • Index Cond: ((trl_mag_id)::text = '012'::text)
  • Buffers: shared hit=200 read=31101
6. 6,387.250 6,387.250 ↑ 1.0 1 638,725

Index Scan using produit_pkey on produit (cost=0.42..0.52 rows=1 width=18) (actual time=0.010..0.010 rows=1 loops=638,725)

  • Index Cond: ((pro_codeinterne)::text = (transaction_ligne.trl_pro_codeinterne)::text)
  • Buffers: shared hit=2545063 read=14506 dirtied=10
7. 3.450 12.080 ↑ 1.0 16,998 1

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

  • Buckets: 32768 Batches: 1 Memory Usage: 1243kB
  • Buffers: shared hit=347 read=53
8. 8.630 8.630 ↑ 1.0 16,998 1

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

  • Buffers: shared hit=347 read=53