explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1lJt

Settings
# exclusive inclusive rows x rows loops node
1. 0.029 410.486 ↑ 1.0 1 1

Aggregate (cost=239,481.48..239,481.49 rows=1 width=8) (actual time=410.486..410.486 rows=1 loops=1)

  • Buffers: shared hit=42740
2. 0.000 410.457 ↑ 13.6 5 1

Nested Loop (cost=0.86..239,481.31 rows=68 width=4) (actual time=397.735..410.457 rows=5 loops=1)

  • Buffers: shared hit=42740
3. 409.107 409.107 ↑ 2.5 715 1

Index Only Scan using index_service_desk_enabled_projects_on_id_creator_id_and_create on public.projects (cost=0.43..236,446.16 rows=1,807 width=8) (actual time=388.285..409.107 rows=715 loops=1)

  • Index Cond: ((projects.creator_id >= 0) AND (projects.creator_id <= 9999) AND (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: 104
  • Buffers: shared hit=40590
4. 1.430 1.430 ↓ 0.0 0 715

Index Only Scan using index_active_services_on_project_id on public.services (cost=0.42..1.67 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=715)

  • Index Cond: (services.project_id = projects.id)
  • Heap Fetches: 3
  • Buffers: shared hit=2150