explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bmKg

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 125.232 ↓ 0.0 0 1

Update on _sales_potential_earnings x (cost=24.5..893,813.48 rows=1 width=258) (actual time=125.232..125.232 rows=0 loops=1)

  • Buffers: local read=36621 written=1
2. 0.024 125.230 ↓ 0.0 0 1

Hash Join (cost=24.5..893,813.48 rows=1 width=258) (actual time=125.23..125.23 rows=0 loops=1)

  • Buffers: local read=36621 written=1
3. 125.199 125.199 ↑ 3,825,869.0 1 1

Seq Scan on _sales_potential_earnings x (cost=0..319,757.69 rows=3,825,869 width=220) (actual time=125.199..125.199 rows=1 loops=1)

  • Buffers: local read=36621 written=1
4. 0.001 0.007 ↓ 0.0 0 1

Hash (cost=15.8..15.8 rows=580 width=118) (actual time=0.007..0.007 rows=0 loops=1)

5. 0.006 0.006 ↓ 0.0 0 1

Seq Scan on _contractee_exclusions ce (cost=0..15.8 rows=580 width=118) (actual time=0.006..0.006 rows=0 loops=1)

Planning time : 0.339 ms
Execution time : 125.336 ms