explain.depesz.com

PostgreSQL's explain analyze made readable

Result: da2X : q344

Settings
# exclusive inclusive rows x rows loops node
1. 37.991 98.706 ↓ 344.0 344 1

Update on public._ckindsdn44164 (cost=0.62..31.38 rows=1 width=61) (actual time=25.884..98.706 rows=344 loops=1)

  • Output: 0
  • Buffers: shared hit=84,225 read=1 dirtied=3
  • I/O Timings: read=0.060
2. 0.373 60.715 ↓ 344.0 344 1

Nested Loop Anti Join (cost=0.62..31.38 rows=1 width=61) (actual time=25.576..60.715 rows=344 loops=1)

  • Output: _ckindsdn44164._ckrefrref, '1'::numeric(10,0), _ckindsdn44164._fld1434, _ckindsdn44164.ctid, t10.ctid, t11.ctid, t12.ctid
  • Buffers: shared hit=8,600
3. 0.615 14.292 ↓ 614.0 614 1

Nested Loop (cost=0.28..16.34 rows=1 width=54) (actual time=0.079..14.292 rows=614 loops=1)

  • Output: _ckindsdn44164._ckrefrref, _ckindsdn44164._fld1434, _ckindsdn44164.ctid, t10.ctid, t10._idrref, t10._fld1434
  • Inner Unique: true
  • Buffers: shared hit=3,296
4. 11.221 11.221 ↓ 614.0 614 1

Index Scan using _ckindsdn44164_2 on public._ckindsdn44164 (cost=0.17..8.18 rows=1 width=27) (actual time=0.056..11.221 rows=614 loops=1)

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

Index Scan using _ckinds1421_s_hpk on public._ckinds1421 t10 (cost=0.11..8.13 rows=1 width=27) (actual time=0.004..0.004 rows=1 loops=614)

  • Output: t10.ctid, t10._idrref, t10._fld1434
  • Index Cond: ((t10._fld1434 = '8470'::numeric) AND (t10._idrref = _ckindsdn44164._ckrefrref))
  • Buffers: shared hit=1,847
6. 10.310 46.050 ↓ 0.0 0 614

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

  • Output: t11.ctid, t11._ckinds1421_idrref, t11._fld1434, t12.ctid
  • Inner Unique: true
  • Join Filter: (t11._displacedckdisplckrref = t12._ckrefrref)
  • Rows Removed by Join Filter: 138
  • Buffers: shared hit=5,304
7. 3.070 3.070 ↓ 0.0 0 614

Index Scan using _ckinds1421_displacedck_sk on public._ckinds1421_displacedck t11 (cost=0.17..6.83 rows=1 width=44) (actual time=0.005..0.005 rows=0 loops=614)

  • Output: t11.ctid, t11._displacedckdisplckrref, t11._ckinds1421_idrref, t11._fld1434
  • Index Cond: ((t11._fld1434 = t10._fld1434) AND (t11._fld1434 = '8470'::numeric) AND (t10._idrref = t11._ckinds1421_idrref))
  • Buffers: shared hit=2,161
8. 32.670 32.670 ↓ 315.0 315 270

Index Scan using _ckindsdn44164_2 on public._ckindsdn44164 t12 (cost=0.17..8.18 rows=1 width=23) (actual time=0.025..0.121 rows=315 loops=270)

  • Output: t12.ctid, t12._ckrefrref
  • Index Cond: ((t12._fld1434 = '8470'::numeric) AND (t12._displnumber = '0'::numeric))
  • Buffers: shared hit=3,143
Planning time : 0.779 ms
Execution time : 98.823 ms