explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dbu4 : q202

Settings
# exclusive inclusive rows x rows loops node
1. 35.846 64,198.533 ↓ 202.0 202 1

Update on public._ckindsdn44164 (cost=0.62..31.38 rows=1 width=61) (actual time=276.309..64,198.533 rows=202 loops=1)

  • Output: 0
  • Buffers: shared hit=9,359,333 read=1 dirtied=2
  • I/O Timings: read=0.181
2. 0.755 64,162.687 ↓ 202.0 202 1

Nested Loop Anti Join (cost=0.62..31.38 rows=1 width=61) (actual time=276.100..64,162.687 rows=202 loops=1)

  • Output: _ckindsdn44164._ckrefrref, '5'::numeric(10,0), _ckindsdn44164._fld1434, _ckindsdn44164.ctid, t3.ctid, t4.ctid, t5.ctid
  • Buffers: shared hit=9,315,416
3. 0.869 13.326 ↓ 206.0 206 1

Nested Loop (cost=0.28..16.34 rows=1 width=54) (actual time=0.067..13.326 rows=206 loops=1)

  • Output: _ckindsdn44164._ckrefrref, _ckindsdn44164._fld1434, _ckindsdn44164.ctid, t3.ctid, t3._idrref, t3._fld1434
  • Inner Unique: true
  • Buffers: shared hit=2,054
4. 9.985 9.985 ↓ 206.0 206 1

Index Scan using _ckindsdn44164_2 on public._ckindsdn44164 (cost=0.17..8.18 rows=1 width=27) (actual time=0.055..9.985 rows=206 loops=1)

  • Output: _ckindsdn44164._ckrefrref, _ckindsdn44164._fld1434, _ckindsdn44164.ctid
  • Index Cond: ((_ckindsdn44164._fld1434 = '8470'::numeric) AND (_ckindsdn44164._displnumber = '0'::numeric))
  • Buffers: shared hit=1,435
5. 2.472 2.472 ↑ 1.0 1 206

Index Scan using _ckinds1421_s_hpk on public._ckinds1421 t3 (cost=0.11..8.13 rows=1 width=27) (actual time=0.012..0.012 rows=1 loops=206)

  • Output: t3.ctid, t3._idrref, t3._fld1434
  • Index Cond: ((t3._fld1434 = '8470'::numeric) AND (t3._idrref = _ckindsdn44164._ckrefrref))
  • Buffers: shared hit=619
6. 166.244 64,148.606 ↓ 0.0 0 206

Nested Loop (cost=0.33..15.03 rows=1 width=33) (actual time=311.401..311.401 rows=0 loops=206)

  • Output: t4.ctid, t4._ckinds1421_idrref, t4._fld1434, t5.ctid
  • Inner Unique: true
  • Join Filter: (t4._displacedckdisplckrref = t5._ckrefrref)
  • Rows Removed by Join Filter: 6,490
  • Buffers: shared hit=9,313,362
7. 16.686 16.686 ↓ 32.0 32 206

Index Scan using _ckinds1421_displacedck_sk on public._ckinds1421_displacedck t4 (cost=0.17..6.83 rows=1 width=44) (actual time=0.013..0.081 rows=32 loops=206)

  • Output: t4.ctid, t4._displacedckdisplckrref, t4._ckinds1421_idrref, t4._fld1434
  • Index Cond: ((t4._fld1434 = t3._fld1434) AND (t4._fld1434 = '8470'::numeric) AND (t3._idrref = t4._ckinds1421_idrref))
  • Buffers: shared hit=3,034
8. 63,965.676 63,965.676 ↓ 206.0 206 6,492

Index Scan using _ckindsdn44164_2 on public._ckindsdn44164 t5 (cost=0.17..8.18 rows=1 width=23) (actual time=0.038..9.853 rows=206 loops=6,492)

  • Output: t5.ctid, t5._ckrefrref
  • Index Cond: ((t5._fld1434 = '8470'::numeric) AND (t5._displnumber = '0'::numeric))
  • Buffers: shared hit=9,310,328
Planning time : 0.761 ms
Execution time : 64,198.704 ms