explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rfCX

Settings
# exclusive inclusive rows x rows loops node
1. 192,032.000 270,461.759 ↓ 0.0 0 1

Update on public._accrgat23840 (cost=3,456.38..12,491,935.65 rows=1 width=412) (actual time=270,461.758..270,461.759 rows=0 loops=1)

  • Buffers: shared hit=78481 read=453346 dirtied=19027, local read=1224
2. 9,632.561 78,429.759 ↓ 21,600.0 21,600 1

Hash Join (cost=3,456.38..12,491,935.65 rows=1 width=412) (actual time=94.011..78,429.759 rows=21,600 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
  • Hash Cond: ((_accrgat23840._fld3822rref == t2._fld3822rref) AND (_accrgat23840._value1_type == t2._value1_type) AND (_accrgat23840._value1_rtref == t2._value1_rtref) AND (_accrgat23840._value1_rrref == t2._value1_rrref) AND (_accrgat23840._value2_type == t2._value2_type) AND (_accrgat23840._value2_rtref == t2._value2_rtref) AND (_accrgat23840._value2_rrref == t2._value2_rrref) AND (_accrgat23840._period = t2._period) AND (_accrgat23840._accountrref = t2._accountrref) AND (_accrgat23840._fld3844 = t2._fld3844) AND (_accrgat23840._fld5750rref = t2._fld5750rref) AND (_accrgat23840._fld5751rref = t2._fld5751rref) AND (_accrgat23840._fld6299rref = t2._fld6299rref))
  • Buffers: shared hit=314 read=436206 dirtied=1021, local read=1224
3. 68,733.908 68,733.908 ↓ 1.0 7,842,228 1

Seq Scan on public._accrgat23840 (cost=0.00..950,873.59 rows=7,785,159 width=190) (actual time=30.554..68,733.908 rows=7,842,228 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, _accrgat23840._turnoverdt3830, _accrgat23840._turnoverct3831, _accrgat23840._turnover3832, _accrgat23840._fld3824, _accrgat23840._turnoverdt3833, _accrgat23840._turnoverct3834, _accrgat23840._turnover3835, _accrgat23840._fld3825, _accrgat23840._turnoverdt3836, _accrgat23840._turnoverct3837, _accrgat23840._turnover3838, _accrgat23840.ctid
  • Buffers: shared hit=305 read=436206 dirtied=1021
4. 30.365 63.290 ↓ 1.0 21,600 1

Hash (cost=2,961.22..2,961.22 rows=21,529 width=192) (actual time=63.289..63.290 rows=21,600 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
  • Buckets: 32768 Batches: 1 Memory Usage: 4785kB
  • Buffers: local read=1224
5. 32.925 32.925 ↓ 1.0 21,600 1

Seq Scan on pg_temp_8.tt9 t2 (cost=0.00..2,961.22 rows=21,529 width=192) (actual time=0.016..32.925 rows=21,600 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: 25056
  • Buffers: local read=1224