explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PVUG

Settings
# exclusive inclusive rows x rows loops node
1. 125,564.019 330,305.050 ↓ 0.0 0 1

Update on public._accrgat25654 (cost=0.27..224,126.55 rows=103,931 width=557) (actual time=330,305.049..330,305.050 rows=0 loops=1)

  • Buffers: shared hit=413977 read=42486 dirtied=37097, local hit=877
2. 469.005 204,741.031 ↑ 3.8 27,660 1

Nested Loop (cost=0.27..224,126.55 rows=103,931 width=557) (actual time=37.203..204,741.031 rows=27,660 loops=1)

  • Output: _accrgat25654._accountrref, _accrgat25654._period, _accrgat25654._fld5622rref, _accrgat25654._fld5623rref, _accrgat25654._fld5624rref, _accrgat25654._fld5625rref, _accrgat25654._value1_type, _accrgat25654._value1_rtref, _accrgat25654._value1_rrref, _accrgat25654._value2_type, _accrgat25654._value2_rtref, _accrgat25654._value2_rrref, (_accrgat25654._fld5627 + t2._fld5627), (_accrgat25654._turnoverdt5641 + t2._turnoverdt5641), (_accrgat25654._turnoverct5642 + t2._turnoverct5642), (_accrgat25654._turnover5643 + t2._turnover5643), (_accrgat25654._fld5629 + t2._fld5629), (_accrgat25654._turnoverdt5647 + t2._turnoverdt5647), (_accrgat25654._turnoverct5648 + t2._turnoverct5648), (_accrgat25654._turnover5649 + t2._turnover5649), (_accrgat25654._fld5630 + t2._fld5630), (_accrgat25654._turnoverdt5650 + t2._turnoverdt5650), (_accrgat25654._turnoverct5651 + t2._turnoverct5651), (_accrgat25654._turnover5652 + t2._turnover5652), (_accrgat25654._fld6179 + t2._fld6179), (_accrgat25654._turnoverdt6183 + t2._turnoverdt6183), (_accrgat25654._turnoverct6184 + t2._turnoverct6184), (_accrgat25654._turnover6185 + t2._turnover6185), (_accrgat25654._fld6180 + t2._fld6180), (_accrgat25654._turnoverdt6186 + t2._turnoverdt6186), (_accrgat25654._turnoverct6187 + t2._turnoverct6187), (_accrgat25654._turnover6188 + t2._turnover6188), _accrgat25654._splitter, _accrgat25654.ctid, t2.ctid
  • Buffers: shared hit=197278 read=26163 dirtied=9861, local hit=877
3. 113.566 113.566 ↑ 1.0 27,660 1

Seq Scan on pg_temp_10.tt25 t2 (cost=0.00..2,062.72 rows=27,660 width=216) (actual time=0.011..113.566 rows=27,660 loops=1)

  • Output: t2._fld5627, t2._turnoverdt5641, t2._turnoverct5642, t2._turnover5643, t2._fld5629, t2._turnoverdt5647, t2._turnoverct5648, t2._turnover5649, t2._fld5630, t2._turnoverdt5650, t2._turnoverct5651, t2._turnover5652, t2._fld6179, t2._turnoverdt6183, t2._turnoverct6184, t2._turnover6185, t2._fld6180, t2._turnoverdt6186, t2._turnoverct6187, t2._turnover6188, t2.ctid, t2._period, t2._accountrref, t2._fld5622rref, t2._fld5623rref, t2._fld5624rref, t2._fld5625rref, t2._value1_type, t2._value1_rtref, t2._value1_rrref, t2._value2_type, t2._value2_rtref, t2._value2_rrref
  • Filter: (t2._edcount = '2'::numeric)
  • Rows Removed by Filter: 405
  • Buffers: local hit=877
4. 204,158.460 204,158.460 ↑ 1.0 1 27,660

Index Scan using _accrgat25654_byperiod_rtrrrrrrn on public._accrgat25654 (cost=0.27..7.87 rows=1 width=215) (actual time=6.736..7.381 rows=1 loops=27,660)

  • Output: _accrgat25654._accountrref, _accrgat25654._period, _accrgat25654._fld5622rref, _accrgat25654._fld5623rref, _accrgat25654._fld5624rref, _accrgat25654._fld5625rref, _accrgat25654._value1_type, _accrgat25654._value1_rtref, _accrgat25654._value1_rrref, _accrgat25654._value2_type, _accrgat25654._value2_rtref, _accrgat25654._value2_rrref, _accrgat25654._fld5627, _accrgat25654._turnoverdt5641, _accrgat25654._turnoverct5642, _accrgat25654._turnover5643, _accrgat25654._fld5629, _accrgat25654._turnoverdt5647, _accrgat25654._turnoverct5648, _accrgat25654._turnover5649, _accrgat25654._fld5630, _accrgat25654._turnoverdt5650, _accrgat25654._turnoverct5651, _accrgat25654._turnover5652, _accrgat25654._fld6179, _accrgat25654._turnoverdt6183, _accrgat25654._turnoverct6184, _accrgat25654._turnover6185, _accrgat25654._fld6180, _accrgat25654._turnoverdt6186, _accrgat25654._turnoverct6187, _accrgat25654._turnover6188, _accrgat25654._splitter, _accrgat25654.ctid
  • Index Cond: ((_accrgat25654._accountrref = t2._accountrref) AND (_accrgat25654._period = t2._period) AND (_accrgat25654._fld5622rref = t2._fld5622rref) AND (_accrgat25654._fld5624rref = t2._fld5624rref) AND (_accrgat25654._fld5625rref = t2._fld5625rref) AND (_accrgat25654._value1_type = t2._value1_type) AND (_accrgat25654._value1_rtref = t2._value1_rtref) AND (_accrgat25654._value1_rrref = t2._value1_rrref) AND (_accrgat25654._value2_type = t2._value2_type) AND (_accrgat25654._value2_rtref = t2._value2_rtref) AND (_accrgat25654._value2_rrref = t2._value2_rrref) AND (_accrgat25654._splitter = '0'::numeric))
  • Filter: (t2._fld5623rref == _accrgat25654._fld5623rref)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=197278 read=26163 dirtied=9861