explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jSrG

Settings
# exclusive inclusive rows x rows loops node
1. 810.302 55,037.599 ↓ 0.0 0 1

Insert on tt7 (cost=585,466.77..5,743,928.13 rows=1,843 width=95) (actual time=55,037.599..55,037.599 rows=0 loops=1)

2. 163.400 54,227.297 ↓ 66.7 122,971 1

Hash Left Join (cost=585,466.77..5,743,928.13 rows=1,843 width=95) (actual time=25,704.530..54,227.297 rows=122,971 loops=1)

  • Hash Cond: (t4._fld4267rref = t6._idrref)
3. 2,507.003 54,063.739 ↓ 66.7 122,971 1

Hash Join (cost=585,462.74..5,743,896.56 rows=1,843 width=62) (actual time=25,704.344..54,063.739 rows=122,971 loops=1)

  • Hash Cond: ((t4._fld4258rref = t3._fld4258rref) AND (t4._fld4259 = t3._fld4259) AND (t4._fld4267rref = t3._fld4267rref) AND (t4._period = (max(t3._period))))
4. 1,241.617 25,864.320 ↑ 23.6 1,258,859 1

Nested Loop (cost=0.28..3,799,041.03 rows=29,657,540 width=91) (actual time=1.812..25,864.320 rows=1,258,859 loops=1)

5. 13.448 13.448 ↑ 1.0 15,429 1

Seq Scan on tt6 t5 (cost=0.00..625.29 rows=15,429 width=21) (actual time=0.006..13.448 rows=15,429 loops=1)

6. 24,609.255 24,609.255 ↑ 23.5 82 15,429

Index Scan using _inforg4257_4 on _inforg4257 t4 (cost=0.28..226.96 rows=1,923 width=70) (actual time=1.067..1.595 rows=82 loops=15,429)

  • Index Cond: ((_fld1922 = '0'::numeric) AND (_fld4259 = t5._q_000_f_003))
7. 3,301.193 25,692.416 ↑ 2.2 2,912,038 1

Hash (cost=425,657.59..425,657.59 rows=6,458,777 width=64) (actual time=25,692.416..25,692.416 rows=2,912,038 loops=1)

  • Buckets: 2097152 Batches: 8 Memory Usage: 51100kB
8. 7,290.207 22,391.223 ↑ 2.2 2,912,038 1

GroupAggregate (cost=0.28..361,069.82 rows=6,458,777 width=64) (actual time=11.042..22,391.223 rows=2,912,038 loops=1)

  • Group Key: t3._fld4258rref, t3._fld4259, t3._fld4267rref
9. 15,101.016 15,101.016 ↓ 1.0 8,600,322 1

Index Only Scan using _inforg4257_2 on _inforg4257 t3 (cost=0.28..262,557.91 rows=8,481,034 width=64) (actual time=11.024..15,101.016 rows=8,600,322 loops=1)

  • Index Cond: ((_fld1922 = '0'::numeric) AND (_fld4258rref = '\\xa60771d272a0518c41a9816e943da548'::bytea) AND (_period <= '2019-11-01 00:00:00'::timestamp without time zone))
  • Heap Fetches: 0
10. 0.068 0.158 ↑ 1.0 92 1

Hash (cost=3.01..3.01 rows=92 width=60) (actual time=0.158..0.158 rows=92 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
11. 0.090 0.090 ↑ 1.0 92 1

Seq Scan on _reference33 t6 (cost=0.00..3.01 rows=92 width=60) (actual time=0.016..0.090 rows=92 loops=1)

  • Filter: (_fld1922 = '0'::numeric)