explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5QIF

Settings
# exclusive inclusive rows x rows loops node
1. 2.967 303,167.396 ↑ 1.0 1 1

Aggregate (cost=1,262,238.27..1,262,238.28 rows=1 width=8) (actual time=303,167.396..303,167.396 rows=1 loops=1)

  • Buffers: shared hit=1,541,184 read=443,460 dirtied=9,231 written=2
  • I/O Timings: read=294,973.182 write=0.129
2. 540.380 303,164.429 ↑ 1.8 1,055 1

Nested Loop (cost=0.86..1,262,233.47 rows=1,917 width=4) (actual time=2,896.655..303,164.429 rows=1,055 loops=1)

  • Buffers: shared hit=1,541,184 read=443,460 dirtied=9,231 written=2
  • I/O Timings: read=294,973.182 write=0.129
3. 63,617.156 63,617.156 ↓ 1.0 484,801 1

Index Scan using index_services_on_type_and_id_and_template on public.services (cost=0.42..349,568.68 rows=481,037 width=4) (actual time=6.590..63,617.156 rows=484,801 loops=1)

  • Buffers: shared hit=66,130 read=128,120 written=1
  • I/O Timings: read=62,194.524 write=0.060
4. 239,006.893 239,006.893 ↓ 0.0 0 484,801

Index Scan using index_projects_on_id_service_desk_enabled on public.projects (cost=0.43..1.89 rows=1 width=8) (actual time=0.493..0.493 rows=0 loops=484,801)

  • Index Cond: (projects.id = services.project_id)
  • Filter: ((projects.creator_id >= 1) AND (projects.creator_id <= 10,000))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=1,475,054 read=315,340 dirtied=9,231 written=1
  • I/O Timings: read=232,778.658 write=0.069