explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5SyY

Settings
# exclusive inclusive rows x rows loops node
1. 0.625 12,311.847 ↑ 1.0 1 1

Aggregate (cost=86,868.44..86,868.45 rows=1 width=8) (actual time=12,311.847..12,311.847 rows=1 loops=1)

  • Buffers: shared hit=301655 read=14618 dirtied=4754 written=6893
  • I/O Timings: read=6800.731 write=1428.201
2. 2,306.948 12,311.222 ↑ 5.4 3,536 1

Index Only Scan using index_chat_names_on_user_id_and_service_id on public.chat_names (cost=85,884.52..86,820.71 rows=19,091 width=0) (actual time=12,099.030..12,311.222 rows=3,536 loops=1)

  • Heap Fetches: 544
  • Filter: (NOT (hashed SubPlan 1))
  • Rows Removed by Filter: 34635
  • Buffers: shared hit=301655 read=14618 dirtied=4754 written=6893
  • I/O Timings: read=6800.731 write=1428.201
3.          

SubPlan (for Index Only Scan)

4. 10,004.274 10,004.274 ↓ 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.548..10,004.274 rows=3,224,297 loops=1)

  • Heap Fetches: 193107
  • Buffers: shared hit=301347 read=14477 dirtied=4746 written=6893
  • I/O Timings: read=6627.816 write=1428.201