explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Qlkd

Settings
# exclusive inclusive rows x rows loops node
1. 0.041 6,691.894 ↑ 1.0 1 1

Aggregate (cost=582,766.03..582,766.04 rows=1 width=8) (actual time=6,691.894..6,691.894 rows=1 loops=1)

  • Buffers: shared hit=143981 read=310416
  • I/O Timings: read=5434.565
2. 2.492 6,691.853 ↑ 29.0 3 1

Nested Loop (cost=1.12..582,765.81 rows=87 width=4) (actual time=3,658.906..6,691.853 rows=3 loops=1)

  • Buffers: shared hit=143981 read=310416
  • I/O Timings: read=5434.565
3. 6,672.411 6,672.411 ↑ 2.4 678 1

Index Scan using index_projects_api_created_at_id_desc on public.projects (cost=0.56..569,612.97 rows=1,661 width=8) (actual time=16.455..6,672.411 rows=678 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 AND (projects.creator_id >= 0) AND (projects.creator_id <= 9999))
  • Rows Removed by Filter: 436405
  • Buffers: shared hit=141401 read=310157
  • I/O Timings: read=5424.495
4. 16.950 16.950 ↓ 0.0 0 678

Index Scan using index_services_on_project_id_and_type on public.services (cost=0.56..7.91 rows=1 width=4) (actual time=0.025..0.025 rows=0 loops=678)

  • Index Cond: (services.project_id = projects.id)
  • Filter: services.active
  • Rows Removed by Filter: 0
  • Buffers: shared hit=2580 read=259
  • I/O Timings: read=10.070