explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DHEs

Settings
# exclusive inclusive rows x rows loops node
1. 3,272.510 5,610.017 ↓ 0.0 0 1

Hash Join (cost=93,578.29..481,532.99 rows=1,599 width=206) (actual time=5,610.017..5,610.017 rows=0 loops=1)

  • Buffers: local read=314169, temp read=39735 written=39673
2. 1,297.865 1,297.865 ↑ 1.0 1,373,074 1

Seq Scan on _sales_potential_earnings s (cost=0..295,229.74 rows=1,373,074 width=156) (actual time=118.089..1,297.865 rows=1,373,074 loops=1)

  • Buffers: local read=281499
3. 594.714 1,039.642 ↑ 1.0 1,479,356 1

Hash (cost=47,463.56..47,463.56 rows=1,479,356 width=88) (actual time=1,039.642..1,039.642 rows=1,479,356 loops=1)

  • Buffers: local read=32670, temp written=19043
4. 444.928 444.928 ↑ 1.0 1,479,356 1

Seq Scan on _existing_earnings ee (cost=0..47,463.56 rows=1,479,356 width=88) (actual time=0.012..444.928 rows=1,479,356 loops=1)

  • Buffers: local read=32670
Planning time : 3.761 ms
Execution time : 5,610.117 ms