explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RfHl

Settings
# exclusive inclusive rows x rows loops node
1. 1.757 114,252.420 ↑ 1.0 1 1

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

  • Buffers: shared hit=2895426 read=413704 dirtied=3371 written=11
  • I/O Timings: read=106025.657 write=1.007
2. 487.149 114,250.663 ↑ 1.5 12,436 1

Hash Join (cost=577,368.27..1,234,270.62 rows=18,521 width=4) (actual time=113,907.431..114,250.663 rows=12,436 loops=1)

  • Hash Cond: (services.project_id = projects.id)
  • Buffers: shared hit=2895426 read=413704 dirtied=3371 written=11
  • I/O Timings: read=106025.657 write=1.007
3. 93,390.508 93,390.508 ↑ 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.008..93,390.508 rows=486,691 loops=1)

  • Filter: services.active
  • Rows Removed by Filter: 3189835
  • Buffers: shared hit=2704905 read=138233 written=11
  • I/O Timings: read=87682.188 write=1.007
4. 380.059 20,373.006 ↓ 1.2 433,668 1

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

  • Buckets: 524288 Batches: 2 Memory Usage: 12601kB
  • Buffers: shared hit=190521 read=275471 dirtied=3371
  • I/O Timings: read=18343.469
5. 19,992.947 19,992.947 ↓ 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=3.076..19,992.947 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=190521 read=275471 dirtied=3371
  • I/O Timings: read=18343.469