explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1XGQ

Settings
# exclusive inclusive rows x rows loops node
1. 68.216 1,277.690 ↓ 6.2 399 1

Nested Loop (cost=1.99..1,986.62 rows=64 width=16) (actual time=104.809..1,277.690 rows=399 loops=1)

  • Buffers: shared dirtied=61 hit=1378 read=940
  • Execution time: 1.278 s
  • Total Cost: 1986.62
  • Buffers Hit: 1378
  • Buffers Written: 0
  • Buffers Read: 940
2. 0.418 159.930 ↓ 1.1 452 1

Nested Loop (cost=1.56..74.88 rows=430 width=12) (actual time=33.397..159.930 rows=452 loops=1)

  • Buffers: shared dirtied=3 hit=281 read=223
3. 0.037 17.984 ↑ 1.0 1 1

Nested Loop (cost=1.00..9.04 rows=1 width=4) (actual time=17.978..17.984 rows=1 loops=1)

  • Buffers: shared hit=4 read=6
4. 0.173 0.173 ↑ 1.0 1 1

Index Scan using projects_pkey on public.projects (cost=0.43..4.45 rows=1 width=8) (actual time=0.169..0.173 rows=1 loops=1)

  • Index Cond: (projects.id = 13083)
  • Buffers: shared hit=4
5. 17.774 17.774 ↑ 1.0 1 1

Index Only Scan using index_routes_on_source_type_and_source_id on public.routes (cost=0.56..4.58 rows=1 width=4) (actual time=17.772..17.774 rows=1 loops=1)

  • Index Cond: ((routes.source_type = 'Namespace'::text) AND (routes.source_id = projects.namespace_id))
  • Buffers: shared read=6
6. 141.528 141.528 ↑ 1.9 452 1

Index Only Scan using index_issues_on_project_id_and_created_at_and_id_and_state on public.issues (cost=0.56..57.23 rows=860 width=16) (actual time=15.410..141.528 rows=452 loops=1)

  • Index Cond: ((issues.project_id = 13083) AND (issues.created_at >= '2019-07-12 19:22:57.572717+00'::timestamp with time zone))
  • Buffers: shared dirtied=3 hit=277 read=217
7. 1,049.544 1,049.544 ↑ 1.0 1 452

Index Scan using index_issue_metrics on public.issue_metrics (cost=0.43..4.43 rows=1 width=20) (actual time=2.316..2.322 rows=1 loops=452)

  • Index Cond: (issue_metrics.issue_id = issues.id)
  • Filter: (((issue_metrics.first_added_to_board_at IS NOT NULL) OR (issue_metrics.first_associated_with_milestone_at IS NOT NULL)) AND (((COALESCE(issue_metrics.first_associated_with_milestone_at, issue_metrics.first_added_to_board_at))::timestamp with time zone - COALESCE(issues.created_at)) >= '00:00:00'::interval))
  • Rows Removed by Filter: 0
  • Buffers: shared dirtied=58 hit=1097 read=717
Planning time : 9.185 ms