explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 42xE

Settings
# exclusive inclusive rows x rows loops node
1. 1,293.284 584,752.747 ↓ 0.0 0 1

Update on public._accrgat13839 (cost=0.22..225,866.27 rows=4,989 width=388) (actual time=584,752.746..584,752.747 rows=0 loops=1)

  • Buffers: shared hit=369555264 read=22361 dirtied=19573, local read=1224 written=75
2. 251.417 583,459.463 ↓ 5.0 24,784 1

Nested Loop (cost=0.22..225,866.27 rows=4,989 width=388) (actual time=4,826.622..583,459.463 rows=24,784 loops=1)

  • Output: _accrgat13839._accountrref, _accrgat13839._period, _accrgat13839._fld3822rref, _accrgat13839._fld3844, _accrgat13839._fld5750rref, _accrgat13839._fld5751rref, _accrgat13839._fld6299rref, _accrgat13839._value1_type, _accrgat13839._value1_rtref, _accrgat13839._value1_rrref, (_accrgat13839._fld3823 + t2._fld3823), (_accrgat13839._turnoverdt3830 + t2._turnoverdt3830), (_accrgat13839._turnoverct3831 + t2._turnoverct3831), (_accrgat13839._turnover3832 + t2._turnover3832), (_accrgat13839._fld3824 + t2._fld3824), (_accrgat13839._turnoverdt3833 + t2._turnoverdt3833), (_accrgat13839._turnoverct3834 + t2._turnoverct3834), (_accrgat13839._turnover3835 + t2._turnover3835), (_accrgat13839._fld3825 + t2._fld3825), (_accrgat13839._turnoverdt3836 + t2._turnoverdt3836), (_accrgat13839._turnoverct3837 + t2._turnoverct3837), (_accrgat13839._turnover3838 + t2._turnover3838), _accrgat13839.ctid, t2.ctid
  • Buffers: shared hit=369473067 read=21979 dirtied=9318, local read=1224 written=75
3. 90.094 90.094 ↑ 1.0 24,784 1

Seq Scan on pg_temp_8.tt9 t2 (cost=0.00..2,961.22 rows=24,854 width=168) (actual time=0.020..90.094 rows=24,784 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
  • Filter: (t2._edcount = '1'::numeric)
  • Rows Removed by Filter: 21872
  • Buffers: local read=1224 written=75
4. 583,117.952 583,117.952 ↑ 1.0 1 24,784

Index Scan using _accrgat13839_byperiod_rtnrrrrr on public._accrgat13839 (cost=0.22..8.95 rows=1 width=171) (actual time=12.590..23.528 rows=1 loops=24,784)

  • Output: _accrgat13839._accountrref, _accrgat13839._period, _accrgat13839._fld3822rref, _accrgat13839._fld3844, _accrgat13839._fld5750rref, _accrgat13839._fld5751rref, _accrgat13839._fld6299rref, _accrgat13839._value1_type, _accrgat13839._value1_rtref, _accrgat13839._value1_rrref, _accrgat13839._fld3823, _accrgat13839._turnoverdt3830, _accrgat13839._turnoverct3831, _accrgat13839._turnover3832, _accrgat13839._fld3824, _accrgat13839._turnoverdt3833, _accrgat13839._turnoverct3834, _accrgat13839._turnover3835, _accrgat13839._fld3825, _accrgat13839._turnoverdt3836, _accrgat13839._turnoverct3837, _accrgat13839._turnover3838, _accrgat13839.ctid
  • Index Cond: ((_accrgat13839._accountrref = t2._accountrref) AND (_accrgat13839._period = t2._period) AND (_accrgat13839._fld3844 = t2._fld3844) AND (_accrgat13839._fld5750rref = t2._fld5750rref) AND (_accrgat13839._fld5751rref = t2._fld5751rref) AND (_accrgat13839._fld6299rref = t2._fld6299rref))
  • Filter: ((t2._fld3822rref == _accrgat13839._fld3822rref) AND (t2._value1_type == _accrgat13839._value1_type) AND (t2._value1_rtref == _accrgat13839._value1_rtref) AND (t2._value1_rrref == _accrgat13839._value1_rrref))
  • Rows Removed by Filter: 18139
  • Buffers: shared hit=369473067 read=21979 dirtied=9318