explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jfpH

Settings
# exclusive inclusive rows x rows loops node
1. 5,118.700 330,028.860 ↑ 1.0 1 1

Aggregate (cost=11,531,481.89..11,531,481.90 rows=1 width=8) (actual time=330,028.860..330,028.860 rows=1 loops=1)

2. 18,234.850 324,910.160 ↓ 4,969.2 11,493,749 1

Nested Loop (cost=0.56..11,531,479.58 rows=2,313 width=22) (actual time=0.095..324,910.160 rows=11,493,749 loops=1)

3. 90,554.646 203,231.569 ↑ 1.2 11,493,749 1

GroupAggregate (cost=0.28..4,610,959.16 rows=13,616,415 width=64) (actual time=0.073..203,231.569 rows=11,493,749 loops=1)

  • Group Key: t3._fld4258rref, t3._fld4259, t3._fld4267rref
4. 112,676.923 112,676.923 ↓ 1.0 136,426,338 1

Index Only Scan using _inforg4257_2 on _inforg4257 t3 (cost=0.28..3,930,138.41 rows=136,164,148 width=64) (actual time=0.062..112,676.923 rows=136,426,338 loops=1)

  • Index Cond: (_fld1922 = '0'::numeric)
  • Heap Fetches: 125691
5. 103,443.741 103,443.741 ↑ 1.0 1 11,493,749

Index Only Scan using _inforg4257_2 on _inforg4257 t4 (cost=0.28..0.50 rows=1 width=64) (actual time=0.009..0.009 rows=1 loops=11,493,749)

  • Index Cond: ((_fld1922 = '0'::numeric) AND (_fld4258rref = t3._fld4258rref) AND (_fld4259 = t3._fld4259) AND (_fld4267rref = t3._fld4267rref) AND (_period = (max(t3._period))))
  • Heap Fetches: 125602