explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6n9n

Settings
# exclusive inclusive rows x rows loops node
1. 0.428 71.491 ↑ 1.0 1 1

Aggregate (cost=18,661.06..18,661.07 rows=1 width=8) (actual time=71.490..71.491 rows=1 loops=1)

2. 2.743 71.063 ↓ 416.5 4,581 1

Nested Loop (cost=1.12..18,661.03 rows=11 width=0) (actual time=0.060..71.063 rows=4,581 loops=1)

3. 5.340 5.340 ↓ 1.5 6,298 1

Index Only Scan using idx_issues_on_project_id_and_created_at_and_id_and_state_id on issues (cost=0.56..133.21 rows=4,178 width=4) (actual time=0.022..5.340 rows=6,298 loops=1)

  • Index Cond: ((project_id = 278964) AND (created_at > '2019-08-01 00:00:00+00'::timestamp with time zone))
  • Heap Fetches: 746
4. 62.980 62.980 ↑ 1.0 1 6,298

Index Scan using index_label_links_on_target_id_and_target_type on label_links (cost=0.56..4.42 rows=1 width=4) (actual time=0.009..0.010 rows=1 loops=6,298)

  • Index Cond: ((target_id = issues.id) AND ((target_type)::text = 'Issue'::text))
  • Filter: (label_id = ANY ('{2731248,10230929,4116705,2492649,2278648,2779806}'::integer[]))
  • Rows Removed by Filter: 4
Planning time : 0.566 ms
Execution time : 71.533 ms