explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pJTg

Settings
# exclusive inclusive rows x rows loops node
1. 61.301 11,442.655 ↑ 1.0 1 1

Aggregate (cost=366,791.00..366,791.01 rows=1 width=4) (actual time=11,442.655..11,442.655 rows=1 loops=1)

  • Buffers: shared hit=1844528 read=27833
  • I/O Timings: read=9593.424
2. 0.083 11,381.354 ↑ 1.2 329,445 1

Nested Loop (cost=0.86..365,816.47 rows=389,810 width=4) (actual time=4.262..11,381.354 rows=329,445 loops=1)

  • Buffers: shared hit=1844528 read=27833
  • I/O Timings: read=9593.424
3. 187.378 187.378 ↓ 1.0 486,691 1

Index Only Scan using index_active_services_on_project_id on public.services (cost=0.42..16,398.21 rows=481,073 width=4) (actual time=0.069..187.378 rows=486,691 loops=1)

  • Heap Fetches: 14253
  • Buffers: shared hit=109040 read=192
  • I/O Timings: read=31.848
4. 11,193.893 11,193.893 ↑ 1.0 1 486,691

Index Only Scan using index_service_desk_enabled_projects_on_id_and_creator_id on public.projects (cost=0.43..0.72 rows=1 width=8) (actual time=0.022..0.023 rows=1 loops=486,691)

  • Index Cond: (projects.id = services.project_id)
  • Heap Fetches: 48938
  • Buffers: shared hit=1735488 read=27641
  • I/O Timings: read=9561.576