explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HsRI

Settings
# exclusive inclusive rows x rows loops node
1. 10,762.165 9,800,209.756 ↓ 0.0 0 1

Update on public._accrgat23840 (cost=0.27..597,126.72 rows=2 width=412) (actual time=9,800,209.756..9,800,209.756 rows=0 loops=1)

  • Buffers: shared hit=4723535047 read=553456 dirtied=65769, local read=1404
2. 465.722 9,789,447.591 ↓ 14,895.0 29,790 1

Nested Loop (cost=0.27..597,126.72 rows=2 width=412) (actual time=96,663.149..9,789,447.591 rows=29,790 loops=1)

  • Output: _accrgat23840._accountrref, _accrgat23840._period, _accrgat23840._fld3822rref, _accrgat23840._fld3844, _accrgat23840._fld5750rref, _accrgat23840._fld5751rref, _accrgat23840._fld6299rref, _accrgat23840._value1_type, _accrgat23840._value1_rtref, _accrgat23840._value1_rrref, _accrgat23840._value2_type, _accrgat23840._value2_rtref, _accrgat23840._value2_rrref, (_accrgat23840._fld3823 + t2._fld3823), (_accrgat23840._turnoverdt3830 + t2._turnoverdt3830), (_accrgat23840._turnoverct3831 + t2._turnoverct3831), (_accrgat23840._turnover3832 + t2._turnover3832), (_accrgat23840._fld3824 + t2._fld3824), (_accrgat23840._turnoverdt3833 + t2._turnoverdt3833), (_accrgat23840._turnoverct3834 + t2._turnoverct3834), (_accrgat23840._turnover3835 + t2._turnover3835), (_accrgat23840._fld3825 + t2._fld3825), (_accrgat23840._turnoverdt3836 + t2._turnoverdt3836), (_accrgat23840._turnoverct3837 + t2._turnoverct3837), (_accrgat23840._turnover3838 + t2._turnover3838), _accrgat23840.ctid, t2.ctid
  • Buffers: shared hit=4723338376 read=545482 dirtied=34948, local read=1404
3. 166.609 166.609 ↓ 1.0 29,790 1

Seq Scan on pg_temp_10.tt32 t2 (cost=0.00..3,398.53 rows=29,786 width=192) (actual time=0.015..166.609 rows=29,790 loops=1)

  • Output: t2._fld3823, t2._turnoverdt3830, t2._turnoverct3831, t2._turnover3832, t2._fld3824, t2._turnoverdt3833, t2._turnoverct3834, t2._turnover3835, t2._fld3825, t2._turnoverdt3836, t2._turnoverct3837, t2._turnover3838, t2.ctid, t2._period, t2._accountrref, t2._fld3822rref, t2._fld3844, t2._fld5750rref, t2._fld5751rref, t2._fld6299rref, 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: 23895
  • Buffers: local read=1404
4. 9,788,815.260 9,788,815.260 ↑ 1.0 1 29,790

Index Scan using _accrgat23840_byperiod_rtnrrrrrr on public._accrgat23840 (cost=0.27..19.92 rows=1 width=190) (actual time=169.214..328.594 rows=1 loops=29,790)

  • Output: _accrgat23840._accountrref, _accrgat23840._period, _accrgat23840._fld3822rref, _accrgat23840._fld3844, _accrgat23840._fld5750rref, _accrgat23840._fld5751rref, _accrgat23840._fld6299rref, _accrgat23840._value1_type, _accrgat23840._value1_rtref, _accrgat23840._value1_rrref, _accrgat23840._value2_type, _accrgat23840._value2_rtref, _accrgat23840._value2_rrref, _accrgat23840._fld3823, _accrgat23840._turnoverdt3830, _accrgat23840._turnoverct3831, _accrgat23840._turnover3832, _accrgat23840._fld3824, _accrgat23840._turnoverdt3833, _accrgat23840._turnoverct3834, _accrgat23840._turnover3835, _accrgat23840._fld3825, _accrgat23840._turnoverdt3836, _accrgat23840._turnoverct3837, _accrgat23840._turnover3838, _accrgat23840.ctid
  • Index Cond: ((_accrgat23840._accountrref = t2._accountrref) AND (_accrgat23840._period = t2._period) AND (_accrgat23840._fld3844 = t2._fld3844) AND (_accrgat23840._fld5750rref = t2._fld5750rref) AND (_accrgat23840._fld5751rref = t2._fld5751rref) AND (_accrgat23840._fld6299rref = t2._fld6299rref))
  • Filter: ((t2._fld3822rref == _accrgat23840._fld3822rref) AND (t2._value1_type == _accrgat23840._value1_type) AND (t2._value1_rtref == _accrgat23840._value1_rtref) AND (t2._value1_rrref == _accrgat23840._value1_rrref) AND (t2._value2_type == _accrgat23840._value2_type) AND (t2._value2_rtref == _accrgat23840._value2_rtref) AND (t2._value2_rrref == _accrgat23840._value2_rrref))
  • Rows Removed by Filter: 195799
  • Buffers: shared hit=4723338376 read=545482 dirtied=34948