explain.depesz.com

PostgreSQL's explain analyze made readable

Result: j3Lj

Settings
# exclusive inclusive rows x rows loops node
1. 155.056 152,336.304 ↑ 1.0 1 1

Aggregate (cost=1,772,455.93..1,772,455.94 rows=1 width=4) (actual time=152,336.297..152,336.304 rows=1 loops=1)

  • Buffers: shared hit=4176935 read=457595
  • I/O Timings: read=142010.134
2. 460.868 152,181.248 ↑ 1.6 329,445 1

Nested Loop (cost=0.99..1,771,097.14 rows=543,516 width=4) (actual time=1,607.687..152,181.248 rows=329,445 loops=1)

  • Buffers: shared hit=4176935 read=457595
  • I/O Timings: read=142010.134
3. 95,750.915 95,750.915 ↑ 1.4 486,691 1

Index Scan using index_services_on_project_id_and_type on public.services (cost=0.56..627,714.32 rows=670,765 width=4) (actual time=0.007..95,750.915 rows=486,691 loops=1)

  • Filter: services.active
  • Rows Removed by Filter: 3189835
  • Buffers: shared hit=2665142 read=177996
  • I/O Timings: read=89385.497
4. 55,969.465 55,969.465 ↑ 1.0 1 486,691

Index Scan using index_projects_on_id_service_desk_enabled on public.projects (cost=0.43..1.69 rows=1 width=8) (actual time=0.114..0.115 rows=1 loops=486,691)

  • Index Cond: (projects.id = services.project_id)
  • Buffers: shared hit=1511793 read=279599
  • I/O Timings: read=52624.637