explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YeWQ

Settings
# exclusive inclusive rows x rows loops node
1. 36.129 4,891.017 ↑ 1.0 1 1

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

  • Buffers: shared hit=9265421 read=30
  • I/O Timings: read=3.168
2. 952.891 4,854.888 ↑ 1.2 331,138 1

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

  • Merge Cond: (projects.id = services.project_id)
  • Buffers: shared hit=9265421 read=30
  • I/O Timings: read=3.168
3. 3,790.205 3,790.205 ↑ 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.215..3,790.205 rows=10,402,663 loops=1)

  • Heap Fetches: 827761
  • Buffers: shared hit=9153631 read=30
  • I/O Timings: read=3.168
4. 111.792 111.792 ↓ 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.023..111.792 rows=488,539 loops=1)

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