explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HPTM

Settings
# exclusive inclusive rows x rows loops node
1. 1.506 604.117 ↑ 1.0 1 1

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

  • Buffers: shared hit=604581
2. 78.725 602.611 ↑ 1.1 13,517 1

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

  • Merge Cond: (projects.id = services.project_id)
  • Buffers: shared hit=604581
3. 432.247 432.247 ↓ 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=216.804..432.247 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. 91.639 91.639 ↓ 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.024..91.639 rows=488,260 loops=1)

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