explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qRbd

Settings
# exclusive inclusive rows x rows loops node
1. 1.702 17,710.997 ↑ 1.0 1 1

Aggregate (cost=1,234,316.92..1,234,316.93 rows=1 width=4) (actual time=17,710.997..17,710.997 rows=1 loops=1)

  • Buffers: shared hit=2846889 read=447807
  • I/O Timings: read=10951.945
2. 1,414.175 17,709.295 ↑ 1.5 12,436 1

Hash Join (cost=577,368.27..1,234,270.62 rows=18,521 width=4) (actual time=16,424.208..17,709.295 rows=12,436 loops=1)

  • Hash Cond: (services.project_id = projects.id)
  • Buffers: shared hit=2846889 read=447807
  • I/O Timings: read=10951.945
3. 6,093.506 6,093.506 ↑ 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.010..6,093.506 rows=486,691 loops=1)

  • Filter: services.active
  • Rows Removed by Filter: 3189835
  • Buffers: shared hit=2704954 read=138184
  • I/O Timings: read=2577.941
4. 351.747 10,201.614 ↓ 1.2 433,668 1

Hash (cost=567,434.29..567,434.29 rows=353,074 width=8) (actual time=10,201.614..10,201.614 rows=433,668 loops=1)

  • Buckets: 524288 Batches: 2 Memory Usage: 12601kB
  • Buffers: shared hit=141935 read=309623
  • I/O Timings: read=8374.004
5. 9,849.867 9,849.867 ↓ 1.2 433,668 1

Index Scan using index_projects_api_created_at_id_desc on public.projects (cost=0.56..567,434.29 rows=353,074 width=8) (actual time=0.435..9,849.867 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=141935 read=309623
  • I/O Timings: read=8374.004