explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HeRm

Settings
# exclusive inclusive rows x rows loops node
1. 8.882 16,257.582 ↓ 0.0 0 1

ModifyTable on public.chat_names (cost=85,884.23..88,289.51 rows=19,091 width=6) (actual time=16,257.582..16,257.582 rows=0 loops=1)

  • Buffers: shared hit=308885 read=14960 dirtied=5221 written=4577
  • I/O Timings: read=8299.679 write=843.824
2. 2,134.798 16,248.700 ↑ 5.4 3,536 1

Seq Scan on public.chat_names (cost=85,884.23..88,289.51 rows=19,091 width=6) (actual time=16,013.312..16,248.700 rows=3,536 loops=1)

  • Filter: (NOT (hashed SubPlan 1))
  • Rows Removed by Filter: 34635
  • Buffers: shared hit=301347 read=14959 dirtied=4753 written=4577
  • I/O Timings: read=8298.841 write=843.824
3.          

SubPlan (for Seq Scan)

4. 14,113.902 14,113.902 ↓ 1.0 3,224,297 1

Index Only Scan using services_pkey on public.services (cost=0.43..77,825.69 rows=3,223,419 width=4) (actual time=4.911..14,113.902 rows=3,224,297 loops=1)

  • Heap Fetches: 193107
  • Buffers: shared hit=301347 read=14477 dirtied=4746 written=4577
  • I/O Timings: read=8093.364 write=843.824