explain.depesz.com

PostgreSQL's explain analyze made readable

Result: y5Zs

Settings
# exclusive inclusive rows x rows loops node
1. 102.769 16,581.944 ↑ 1.0 1 1

Aggregate (cost=1,772,455.93..1,772,455.94 rows=1 width=4) (actual time=16,581.944..16,581.944 rows=1 loops=1)

  • Buffers: shared hit=4201891 read=432639 written=1777
  • I/O Timings: read=9326.977 write=115.832
2. 319.623 16,479.175 ↑ 1.6 329,445 1

Nested Loop (cost=0.99..1,771,097.14 rows=543,516 width=4) (actual time=24.903..16,479.175 rows=329,445 loops=1)

  • Buffers: shared hit=4201891 read=432639 written=1777
  • I/O Timings: read=9326.977 write=115.832
3. 7,885.805 7,885.805 ↑ 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.006..7,885.805 rows=486,691 loops=1)

  • Filter: services.active
  • Rows Removed by Filter: 3189835
  • Buffers: shared hit=2691389 read=151749 written=518
  • I/O Timings: read=3343.728 write=33.521
4. 8,273.747 8,273.747 ↑ 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.017..0.017 rows=1 loops=486,691)

  • Index Cond: (projects.id = services.project_id)
  • Buffers: shared hit=1510502 read=280890 written=1259
  • I/O Timings: read=5983.249 write=82.311