explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fVf

Settings
# exclusive inclusive rows x rows loops node
1. 31.651 752.533 ↓ 0.0 0 1

ModifyTable on public.user_details (cost=0.42..78,690.51 rows=42,534 width=458) (actual time=752.533..752.533 rows=0 loops=1)

  • Buffers: shared hit=10090 read=1006 dirtied=17
  • I/O Timings: read=709.175
2. 720.882 720.882 ↑ 42.4 1,002 1

Index Scan using tmp_idx_on_user_id_where_bio_is_filled on public.users (cost=0.42..78,690.51 rows=42,534 width=458) (actual time=0.046..720.882 rows=1,002 loops=1)

  • Index Cond: ((users.id >= 35149) AND (users.id <= 79126))
  • Buffers: shared hit=7 read=996 dirtied=7
  • I/O Timings: read=709.175