explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SoTB

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0 0 1

Update on _accrgat213272 (cost=0.27..747,789.10 rows=1 width=380) (actual rows=0 loops=1)

2. 0.000 0.000 ↓ 29,985.0 29,985 1

Nested Loop (cost=0.27..747,789.10 rows=1 width=380) (actual rows=29,985 loops=1)

3. 0.000 0.000 ↑ 1.0 29,985 1

Seq Scan on tt8 t2 (cost=0.00..1,424.88 rows=29,985 width=164) (actual rows=29,985 loops=1)

  • Filter: (_edcount = '2'::numeric)
  • Rows Removed by Filter: 14,550
4. 0.000 0.000 ↑ 1.0 1 29,985

Index Scan using _accr213272_byperiod_trrrrrn on _accrgat213272 (cost=0.27..24.88 rows=1 width=176) (actual rows=1 loops=29,985)

  • Index Cond: ((_period = t2._period) AND (_accountrref = t2._accountrref) AND (_fld13249rref = t2._fld13249rref) AND (_splitter = '0'::numeric))
  • Filter: ((t2._fld13250rref == _fld13250rref) AND (t2._value1_type == _value1_type) AND (t2._value1_rtref == _value1_rtref) AND (t2._value1_rrref == _value1_rrref) AND (t2._value2_type == _value2_type) AND (t2._value2_rtref == _value2_rtref) AND (t2._value2_rrref == _value2_rrref))
  • Rows Removed by Filter: 12,782