explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fFi3a

Settings
# exclusive inclusive rows x rows loops node
1. 1,112,755.556 1,117,813.510 ↓ 0.0 0 1

Update on emails (cost=0.58..302,142.77 rows=864,994 width=200) (actual time=1,117,813.509..1,117,813.510 rows=0 loops=1)

  • Buffers: shared hit=44,170,271 read=1,993,801 dirtied=2,718,146
  • I/O Timings: read=1,041,619.518
2. 5,057.954 5,057.954 ↓ 1.2 999,810 1

Index Scan using emails_pkey on emails (cost=0.58..302,142.77 rows=864,994 width=200) (actual time=0.029..5,057.954 rows=999,810 loops=1)

  • Index Cond: ((id >= 33,000,000) AND (id < 34000000))
  • Buffers: shared hit=1,587,611 read=12,756 dirtied=9
  • I/O Timings: read=3,595.483
Planning time : 0.097 ms
Execution time : 1,117,813.548 ms