explain.depesz.com

PostgreSQL's explain analyze made readable

Result: msLi

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 8,830.983 ↓ 0.0 0 1

Update on sale_earning (cost=538,068.33..757,764.49 rows=1 width=191) (actual time=8,830.982..8,830.983 rows=0 loops=1)

  • Buffers: shared hit=12 read=1, local read=314169, temp read=44726 written=44664
2. 0.044 8,830.980 ↓ 0.0 0 1

Hash Join (cost=538,068.33..757,764.49 rows=1 width=191) (actual time=8,830.98..8,830.98 rows=0 loops=1)

  • Buffers: shared hit=12 read=1, local read=314169, temp read=44726 written=44664
3. 0.356 0.356 ↑ 3,445,037.0 1 1

Seq Scan on sale_earning sale_earning (cost=0..193,858.37 rows=3,445,037 width=155) (actual time=0.356..0.356 rows=1 loops=1)

  • Buffers: shared read=1
4. 0.002 8,830.580 ↓ 0.0 0 1

Hash (cost=538,068.32..538,068.32 rows=1 width=98) (actual time=8,830.58..8,830.58 rows=0 loops=1)

  • Buffers: shared hit=6, local read=314169, temp read=44726 written=44664
5. 3,767.866 8,830.578 ↓ 0.0 0 1

Hash Join (cost=120,102.63..538,068.32 rows=1 width=98) (actual time=8,830.578..8,830.578 rows=0 loops=1)

  • Buffers: shared hit=6, local read=314169, temp read=44726 written=44664
6. 3,027.166 3,027.166 ↑ 1.0 1,373,074 1

Seq Scan on _sales_potential_earnings s (cost=0..295,229.74 rows=1,373,074 width=162) (actual time=389.499..3,027.166 rows=1,373,074 loops=1)

  • Buffers: local read=281499
7. 1,529.041 2,035.546 ↑ 1.0 1,479,356 1

Hash (cost=47,463.56..47,463.56 rows=1,479,356 width=111) (actual time=2,035.546..2,035.546 rows=1,479,356 loops=1)

  • Buffers: local read=32670, temp written=23063
8. 506.505 506.505 ↑ 1.0 1,479,356 1

Seq Scan on _existing_earnings ee (cost=0..47,463.56 rows=1,479,356 width=111) (actual time=0.014..506.505 rows=1,479,356 loops=1)

  • Buffers: local read=32670
Planning time : 32.42 ms
Execution time : 8,831.148 ms