explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1om9

Settings
# exclusive inclusive rows x rows loops node
1. 5,260.774 412,650.765 ↑ 1.0 1 1

Aggregate (cost=11,667,584.85..11,667,584.86 rows=1 width=8) (actual time=412,650.765..412,650.765 rows=1 loops=1)

2. 16,012.361 407,389.991 ↓ 4,969.2 11,493,749 1

Nested Loop (cost=0.56..11,667,582.54 rows=2,313 width=22) (actual time=0.084..407,389.991 rows=11,493,749 loops=1)

3. 90,774.887 276,440.140 ↑ 1.2 11,493,749 1

GroupAggregate (cost=0.28..4,747,066.48 rows=13,616,408 width=64) (actual time=0.069..276,440.140 rows=11,493,749 loops=1)

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

Index Only Scan using _inforg4257_2 on _inforg4257 t3 (cost=0.28..4,066,260.62 rows=136,160,445 width=64) (actual time=0.059..185,665.253 rows=136,426,338 loops=1)

  • Index Cond: ((_fld1922 = '0'::numeric) AND (_period <= '2019-11-06 00:00:00'::timestamp without time zone))
  • Heap Fetches: 125562
5. 114,937.490 114,937.490 ↑ 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.010..0.010 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: 125474