explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dEgv

Settings
# exclusive inclusive rows x rows loops node
1. 40.542 6,259.530 ↑ 1.0 1 1

Aggregate (cost=357,335.20..357,335.21 rows=1 width=4) (actual time=6,259.530..6,259.530 rows=1 loops=1)

  • Buffers: shared hit=9,195,638 read=69,813
  • I/O Timings: read=1,223.171
2. 970.701 6,218.988 ↑ 1.2 331,138 1

Merge Join (cost=0.86..356,359.61 rows=390,234 width=4) (actual time=0.421..6,218.988 rows=331,138 loops=1)

  • Merge Cond: (projects.id = services.project_id)
  • Buffers: shared hit=9,195,638 read=69,813
  • I/O Timings: read=1,223.171
3. 5,106.665 5,106.665 ↑ 1.0 10,402,663 1

Index Only Scan using index_service_desk_enabled_projects_on_id_creator_id_and_create on public.projects (cost=0.43..312,309.07 rows=10,407,366 width=8) (actual time=0.115..5,106.665 rows=10,402,663 loops=1)

  • Heap Fetches: 827,761
  • Buffers: shared hit=9,084,583 read=69,078
  • I/O Timings: read=1,202.871
4. 141.622 141.622 ↓ 1.0 488,539 1

Index Only Scan using index_active_services_on_project_id on public.services (cost=0.42..16,026.36 rows=480,995 width=4) (actual time=0.159..141.622 rows=488,539 loops=1)

  • Heap Fetches: 16,234
  • Buffers: shared hit=111,055 read=735
  • I/O Timings: read=20.300