explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JQDe

Settings
# exclusive inclusive rows x rows loops node
1. 0.443 77.721 ↑ 1.0 1 1

Aggregate (cost=19,852.04..19,852.05 rows=1 width=8) (actual time=77.721..77.721 rows=1 loops=1)

2. 1.246 77.278 ↓ 416.8 4,585 1

Nested Loop (cost=1.56..19,852.01 rows=11 width=0) (actual time=0.074..77.278 rows=4,585 loops=1)

3. 66.862 66.862 ↓ 416.8 4,585 1

Nested Loop (cost=1.12..19,837.26 rows=11 width=4) (actual time=0.061..66.862 rows=4,585 loops=1)

  • -> Index Only Scan using idx_issues_on_project_id_and_created_at_and_id_and_state_id on issues (cost=0.56..290.92 rows=4411 width=4) (actual
  • Index Cond: ((project_id = 278964) AND (created_at > '2019-08-01 00:00:00+00'::timestamp with time zone))
  • Heap Fetches: 908
  • -> Index Scan using index_label_links_on_target_id_and_target_type on label_links (cost=0.56..4.42 rows=1 width=8) (actual time=0.008..0.009
  • 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
4. 9.170 9.170 ↑ 1.0 1 4,585

Index Only Scan using labels_pkey on labels (cost=0.43..1.33 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=4,585)

  • Index Cond: (id = label_links.label_id)
  • Heap Fetches: 2028
Planning time : 0.879 ms
Execution time : 77.774 ms