explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JRx6

Settings
# exclusive inclusive rows x rows loops node
1. 1.262 750.765 ↑ 9.7 40 1

GroupAggregate (cost=37,115.87..37,128.41 rows=386 width=36) (actual time=749.217..750.765 rows=40 loops=1)

  • Group Key: i.issue_type, i.severity, i.resolution, i.status, ((i.issue_creation_date >= 0))
2. 4.214 749.503 ↓ 16.6 6,423 1

Sort (cost=37,115.87..37,116.83 rows=386 width=24) (actual time=749.206..749.503 rows=6,423 loops=1)

  • Sort Key: i.issue_type, i.severity, i.resolution, i.status, ((i.issue_creation_date >= 0))
  • Sort Method: quicksort Memory: 689kB
3. 2.218 745.289 ↓ 16.6 6,423 1

Hash Semi Join (cost=10,552.37..37,099.28 rows=386 width=24) (actual time=571.652..745.289 rows=6,423 loops=1)

  • Hash Cond: ((i.component_uuid)::text = (p.uuid)::text)
4. 175.727 175.727 ↑ 1.2 6,423 1

Index Scan using issues_closed on issues i (cost=0.57..26,522.17 rows=7,639 width=52) (actual time=4.281..175.727 rows=6,423 loops=1)

  • Index Cond: ((project_uuid)::text = 'AWviof4rHo1jhXBgw4V_'::text)
5. 2.873 567.344 ↓ 3.2 11,094 1

Hash (cost=10,508.06..10,508.06 rows=3,499 width=21) (actual time=567.344..567.344 rows=11,094 loops=1)

  • Buckets: 16,384 (originally 4096) Batches: 1 (originally 1) Memory Usage: 703kB
6. 564.471 564.471 ↓ 3.2 11,094 1

Index Scan using projects_project_uuid on projects p (cost=0.57..10,508.06 rows=3,499 width=21) (actual time=4.458..564.471 rows=11,094 loops=1)

  • Index Cond: ((project_uuid)::text = 'AWviof4rHo1jhXBgw4V_'::text)
  • Filter: (((uuid_path)::text ~~ '.%'::text) OR ((uuid)::text = 'AWviof4rHo1jhXBgw4V_'::text))
Planning time : 1.765 ms
Execution time : 750.994 ms