explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qqhb

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Aggregate (cost=2,792.58..2,792.60 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.99..2,791.33 rows=167 width=24) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.56..101.02 rows=607 width=12) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

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

5. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (id = 13083)
6. 0.000 0.000 ↓ 0.0

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

  • Index Cond: ((source_type = 'Namespace'::text) AND (source_id = projects.namespace_id))
7. 0.000 0.000 ↓ 0.0

Index Only Scan using index_issues_on_project_id_and_created_at_and_id_and_state on issues (cost=0.56..79.83 rows=1,215 width=16) (actual rows= loops=)

  • Index Cond: ((project_id = 13083) AND (created_at >= '2019-07-08 10:49:57.023743+00'::timestamp with time zone))
8. 0.000 0.000 ↓ 0.0

Index Scan using index_issue_metrics on issue_metrics (cost=0.43..4.42 rows=1 width=20) (actual rows= loops=)

  • Index Cond: (issue_id = issues.id)
  • Filter: (((COALESCE(first_associated_with_milestone_at, first_added_to_board_at))::timestamp with time zone - issues.created_at) > '00:00:00'::interval)