explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qmcA

Settings
# exclusive inclusive rows x rows loops node
1. 1.392 557.778 ↑ 1.0 1 1

Aggregate (cost=207,289.11..207,289.12 rows=1 width=8) (actual time=557.778..557.778 rows=1 loops=1)

  • Buffers: shared hit=174197 read=2
  • I/O Timings: read=0.970
2. 39.025 556.386 ↑ 1.7 1,059 1

Merge Join (cost=0.86..207,284.48 rows=1,852 width=4) (actual time=0.198..556.386 rows=1,059 loops=1)

  • Merge Cond: (projects.id = services.project_id)
  • Buffers: shared hit=174194
3. 424.887 424.887 ↑ 2.0 24,399 1

Index Only Scan using index_service_desk_enabled_projects_on_id_creator_id_and_create on public.projects (cost=0.43..191,668.85 rows=49,390 width=8) (actual time=0.023..424.887 rows=24,399 loops=1)

  • Index Cond: ((projects.creator_id >= 1) AND (projects.creator_id <= 10000))
  • Heap Fetches: 1910
  • Buffers: shared hit=62404
4. 92.474 92.474 ↓ 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.021..92.474 rows=488,539 loops=1)

  • Heap Fetches: 16234
  • Buffers: shared hit=111790