explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PLR7 : Price

Settings
# exclusive inclusive rows x rows loops node
1. 1,283.490 43,773.726 ↑ 1.0 1 1

Aggregate (cost=4,338,445.60..4,338,445.61 rows=1 width=8) (actual time=43,773.725..43,773.726 rows=1 loops=1)

2. 3,654.843 42,490.236 ↓ 2,649.7 2,912,038 1

Nested Loop (cost=0.56..4,338,444.50 rows=1,099 width=22) (actual time=0.086..42,490.236 rows=2,912,038 loops=1)

3. 6,868.858 12,627.051 ↑ 2.2 2,912,038 1

GroupAggregate (cost=0.28..361,549.11 rows=6,472,473 width=64) (actual time=0.070..12,627.051 rows=2,912,038 loops=1)

  • Group Key: t3._fld4258rref, t3._fld4259, t3._fld4267rref
4. 5,758.193 5,758.193 ↓ 1.0 8,600,322 1

Index Only Scan using _inforg4257_2 on _inforg4257 t3 (cost=0.28..262,802.43 rows=8,505,489 width=64) (actual time=0.061..5,758.193 rows=8,600,322 loops=1)

  • Index Cond: ((_fld1922 = '0'::numeric) AND (_fld4258rref = '\\xa60771d272a0518c41a9816e943da548'::bytea) AND (_period <= '2019-11-06 00:00:00'::timestamp without time zone))
  • Heap Fetches: 0
5. 26,208.342 26,208.342 ↑ 1.0 1 2,912,038

Index Only Scan using _inforg4257_2 on _inforg4257 t4 (cost=0.28..0.60 rows=1 width=64) (actual time=0.009..0.009 rows=1 loops=2,912,038)

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