explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oH1t

Settings
# exclusive inclusive rows x rows loops node
1. 21.413 476.051 ↓ 0.0 0 1

Update on sale_earning (cost=42,144.52..49,687.12 rows=1 width=175) (actual time=476.051..476.051 rows=0 loops=1)

  • Buffers: shared hit=5428 read=46 dirtied=50, local read=9795, temp read=1461 written=1459
2. 19.166 454.638 ↓ 63.0 63 1

Hash Join (cost=42,144.52..49,687.12 rows=1 width=175) (actual time=402.616..454.638 rows=63 loops=1)

  • Buffers: shared hit=5141, local read=9795, temp read=1461 written=1459
3. 39.768 39.768 ↑ 1.2 115,684 1

Seq Scan on sale_earning sale_earning (cost=0..6,512.05 rows=137,405 width=147) (actual time=0.016..39.768 rows=115,684 loops=1)

  • Buffers: shared hit=5138
4. 0.070 395.704 ↓ 21.0 21 1

Hash (cost=42,144.51..42,144.51 rows=1 width=84) (actual time=395.704..395.704 rows=21 loops=1)

  • Buffers: shared hit=3, local read=9795, temp read=1461 written=1459
5. 217.562 395.634 ↓ 21.0 21 1

Hash Join (cost=7,972.16..42,144.51 rows=1 width=84) (actual time=160.746..395.634 rows=21 loops=1)

  • Buffers: shared hit=3, local read=9795, temp read=1461 written=1459
6. 58.395 58.395 ↑ 3.2 108,488 1

Seq Scan on t_sales_potential_earnings s (cost=0..11,125.73 rows=344,773 width=139) (actual time=9.714..58.395 rows=108,488 loops=1)

  • Buffers: local read=7678
7. 85.386 119.677 ↑ 1.0 109,079 1

Hash (cost=3,207.79..3,207.79 rows=109,079 width=87) (actual time=119.677..119.677 rows=109,079 loops=1)

  • Buffers: local read=2117, temp written=730
8. 34.291 34.291 ↑ 1.0 109,079 1

Seq Scan on t_existing_earnings ee (cost=0..3,207.79 rows=109,079 width=87) (actual time=0.012..34.291 rows=109,079 loops=1)

  • Buffers: local read=2117
Planning time : 27.812 ms
Execution time : 477.597 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
RI_ConstraintTrigger_c_411214617 1.337 ms 42 0.032 ms