explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6uJS

Settings
# exclusive inclusive rows x rows loops node
1. 1.681 233,398.864 ↑ 1.0 1 1

Aggregate (cost=616,276.72..616,276.73 rows=1 width=4) (actual time=233,398.864..233,398.864 rows=1 loops=1)

  • Buffers: shared hit=259763 read=301027
  • I/O Timings: read=228660.770
2. 248.590 233,397.183 ↑ 1.1 12,436 1

Hash Join (cost=577,348.87..616,243.51 rows=13,283 width=4) (actual time=232,953.517..233,397.183 rows=12,436 loops=1)

  • Hash Cond: (services.project_id = projects.id)
  • Buffers: shared hit=259763 read=301027
  • I/O Timings: read=228660.770
3. 2,367.276 2,367.276 ↓ 1.0 486,691 1

Index Only Scan using index_active_services_on_project_id on public.services (cost=0.42..16,398.21 rows=481,073 width=4) (actual time=0.023..2,367.276 rows=486,691 loops=1)

  • Heap Fetches: 14253
  • Buffers: shared hit=104028 read=5204
  • I/O Timings: read=2215.554
4. 695.698 230,781.317 ↓ 1.2 433,668 1

Hash (cost=567,415.23..567,415.23 rows=353,057 width=8) (actual time=230,781.317..230,781.317 rows=433,668 loops=1)

  • Buckets: 524288 Batches: 2 Memory Usage: 12601kB
  • Buffers: shared hit=155735 read=295823
  • I/O Timings: read=226445.216
5. 230,085.619 230,085.619 ↓ 1.2 433,668 1

Index Scan using index_projects_api_created_at_id_desc on public.projects (cost=0.56..567,415.23 rows=353,057 width=8) (actual time=5.372..230,085.619 rows=433,668 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))
  • Filter: projects.service_desk_enabled
  • Rows Removed by Filter: 3415
  • Buffers: shared hit=155735 read=295823
  • I/O Timings: read=226445.216