explain.depesz.com

PostgreSQL's explain analyze made readable

Result: a3h

Settings
# exclusive inclusive rows x rows loops node
1. 351.291 665.515 ↑ 1.0 875,523 1

Hash Join (cost=2,592.39..24,461.48 rows=875,523 width=20) (actual time=46.5..665.515 rows=875,523 loops=1)

  • Buffers: shared hit=7 read=7006
2. 269.458 269.458 ↑ 1.0 875,523 1

Seq Scan on dm_loyalty_points_change_final a (cost=0..15,193.23 rows=875,523 width=20) (actual time=0.745..269.458 rows=875,523 loops=1)

  • Buffers: shared hit=2 read=6436
3. 20.219 44.766 ↑ 1.0 89,795 1

Hash (cost=1,469.95..1,469.95 rows=89,795 width=12) (actual time=44.765..44.766 rows=89,795 loops=1)

  • Buffers: shared hit=2 read=570
4. 24.547 24.547 ↑ 1.0 89,795 1

Seq Scan on dm_loyalty_points_change_step1 dm_loyalty_points_change_step1 (cost=0..1,469.95 rows=89,795 width=12) (actual time=0.84..24.547 rows=89,795 loops=1)

  • Buffers: shared hit=2 read=570
Planning time : 22.681 ms
Execution time : 707.828 ms