explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZsFT

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 253.134 ↓ 0.0 0 1

Update on _sales_potential_earnings (cost=893,813.49..1,242,265.22 rows=1 width=264) (actual time=253.134..253.134 rows=0 loops=1)

  • Buffers: shared hit=16, local hit=1 read=73241 dirtied=1 written=1023
2. 0.082 253.131 ↓ 0.0 0 1

Hash Join (cost=893,813.49..1,242,265.22 rows=1 width=264) (actual time=253.131..253.131 rows=0 loops=1)

  • Buffers: shared hit=16, local hit=1 read=73241 dirtied=1 written=1023
3. 135.114 135.114 ↑ 3,825,869.0 1 1

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

  • Buffers: local read=36621 dirtied=1 written=1023
4. 0.002 117.935 ↓ 0.0 0 1

Hash (cost=893,813.48..893,813.48 rows=1 width=108) (actual time=117.935..117.935 rows=0 loops=1)

  • Buffers: local hit=1 read=36620
5. 0.024 117.933 ↓ 0.0 0 1

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

  • Buffers: local hit=1 read=36620
6. 117.901 117.901 ↑ 3,825,869.0 1 1

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

  • Buffers: local hit=1 read=36620
7. 0.001 0.008 ↓ 0.0 0 1

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

8. 0.007 0.007 ↓ 0.0 0 1

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

Planning time : 5.335 ms
Execution time : 253.294 ms