explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JPPG

Settings
# exclusive inclusive rows x rows loops node
1. 0.535 117.583 ↓ 42.4 424 1

GroupAggregate (cost=40,418.01..40,418.23 rows=10 width=16) (actual time=116.837..117.583 rows=424 loops=1)

  • Group Key: label_links.label_id, (date(issues.created_at))
2. 1.445 117.048 ↓ 328.1 3,281 1

Sort (cost=40,418.01..40,418.03 rows=10 width=12) (actual time=116.829..117.048 rows=3,281 loops=1)

  • Sort Key: label_links.label_id, (date(issues.created_at))
  • Sort Method: quicksort Memory: 250kB
3. 5.840 115.603 ↓ 328.1 3,281 1

Hash Join (cost=39,176.45..40,417.84 rows=10 width=12) (actual time=100.447..115.603 rows=3,281 loops=1)

  • Hash Cond: (label_links.target_id = issues.id)
4. 25.046 106.279 ↑ 1.1 49,735 1

HashAggregate (cost=38,961.19..39,483.83 rows=52,264 width=8) (actual time=96.906..106.279 rows=49,735 loops=1)

  • Group Key: label_links.target_id, label_links.label_id
5. 81.233 81.233 ↑ 1.1 49,736 1

Index Scan using index_label_links_on_label_id on label_links (cost=0.44..38,699.42 rows=52,354 width=8) (actual time=0.043..81.233 rows=49,736 loops=1)

  • Index Cond: (label_id = ANY ('{2731248,10230929,4116705,2492649,2278648,2779806}'::integer[]))
  • Filter: ((target_type)::text = 'Issue'::text)
  • Rows Removed by Filter: 18778
6. 0.602 3.484 ↓ 1.1 3,948 1

Hash (cost=169.20..169.20 rows=3,685 width=12) (actual time=3.484..3.484 rows=3,948 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 218kB
7. 2.882 2.882 ↓ 1.1 3,948 1

Index Only Scan using index_issues_on_project_id_and_created_at_and_id_and_state on issues (cost=0.56..169.20 rows=3,685 width=12) (actual time=0.033..2.882 rows=3,948 loops=1)

  • Index Cond: ((project_id = 278964) AND (created_at <= '2019-08-01 00:00:00+00'::timestamp with time zone) AND (created_at >= '2019-05-01 00:00:00+00'::timestamp with time zone))
  • Heap Fetches: 481
Planning time : 0.371 ms
Execution time : 117.979 ms