explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Cb2H

Settings
# exclusive inclusive rows x rows loops node
1. 20,897.805 85,186.685 ↑ 2.1 21,504 1

HashAggregate (cost=162,667.76..163,122.62 rows=45,486 width=1,249) (actual time=85,157.272..85,186.685 rows=21,504 loops=1)

  • Group Key: issues.id, issues.title, issues.author_id, issues.project_id, issues.created_at, issues.updated_at, issues.description, issues.milestone_id, issues.iid, issues.updated_by_id, issues.weight, issues.confidential, issues.moved_to_id, issues.due_date, issues.lock_version, issues.title_html, issues.description_html, issues.time_estimate, issues.relative_position, issues.service_desk_reply_to, issues.cached_markdown_version, issues.last_edited_at, issues.last_edited_by_id, issues.discussion_locked, issues.closed_at, issues.closed_by_id, issues.state_id, issues.duplicated_to_id, issues.promoted_to_epic_id, issues.health_status, issues.external_key, issues.sprint_id, issues.issue_type
  • Buffers: shared hit=384,218 read=48,474 dirtied=3,292
  • I/O Timings: read=80,126.511
2. 289.291 64,288.880 ↓ 1.0 45,579 1

Nested Loop (cost=0.98..158,915.16 rows=45,486 width=1,249) (actual time=9.327..64,288.880 rows=45,579 loops=1)

  • Buffers: shared hit=215,867 read=37,618 dirtied=3,042
  • I/O Timings: read=61,793.041
3. 1,099.189 1,099.189 ↓ 1.0 45,580 1

Index Only Scan using index_design_management_designs_on_issue_id_and_filename on public.design_management_designs (cost=0.41..1,978.07 rows=45,486 width=4) (actual time=0.043..1,099.189 rows=45,580 loops=1)

  • Heap Fetches: 25,956
  • Buffers: shared hit=24,853 read=733 dirtied=240
  • I/O Timings: read=781.583
4. 62,900.400 62,900.400 ↑ 1.0 1 45,580

Index Scan using issues_pkey on public.issues (cost=0.56..3.45 rows=1 width=1,249) (actual time=1.380..1.380 rows=1 loops=45,580)

  • Index Cond: (issues.id = design_management_designs.issue_id)
  • Buffers: shared hit=191,013 read=36,885 dirtied=2,801
  • I/O Timings: read=61,011.458