explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fFi3a

Settings
# exclusive inclusive rows x rows loops node
1. 1,117,813.510 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=44170271 read=1993801 dirtied=2718146
  • I/O Timings: read=1041619.518
  • -> Index Scan using emails_pkey on emails (cost=0.58..302142.77 rows=864994 width=200) (actual time=0.029..5057.954 rows=999810 loops=
  • Index Cond: ((id >= 33000000) AND (id < 34000000))
  • Buffers: shared hit=1587611 read=12756 dirtied=9
  • I/O Timings: read=3595.483
Planning time : 0.097 ms
Execution time : 1,117,813.548 ms