explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Z5sH

Settings
# exclusive inclusive rows x rows loops node
1. 1.806 604.352 ↑ 1.0 1 1

Aggregate (cost=244,589.67..244,589.68 rows=1 width=4) (actual time=604.351..604.352 rows=1 loops=1)

  • Buffers: shared hit=604581
2. 80.316 602.546 ↑ 1.1 13,517 1

Merge Join (cost=0.86..244,553.98 rows=14,276 width=4) (actual time=319.689..602.546 rows=13,517 loops=1)

  • Merge Cond: (projects.id = services.project_id)
  • Buffers: shared hit=604581
3. 431.636 431.636 ↓ 1.2 465,253 1

Index Only Scan using index_service_desk_enabled_projects_on_id_creator_id_and_create on public.projects (cost=0.43..228,330.38 rows=380,742 width=8) (actual time=201.760..431.636 rows=465,253 loops=1)

  • Index Cond: ((projects.created_at >= '2020-02-24 12:06:40.982089+00'::timestamp with time zone) AND (projects.created_at <= '2020-03-23 12:06:40.982261+00'::timestamp with time zone))
  • Heap Fetches: 61617
  • Buffers: shared hit=493069
4. 90.594 90.594 ↓ 1.0 488,260 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..90.594 rows=488,260 loops=1)

  • Heap Fetches: 15955
  • Buffers: shared hit=111512