explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lubv

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 0.840 ↓ 2.0 2 1

GroupAggregate (cost=490.84..490.87 rows=1 width=35) (actual time=0.839..0.840 rows=2 loops=1)

  • Group Key: i.issue_type, i.severity, i.resolution, i.status
2. 0.023 0.832 ↓ 22.0 22 1

Sort (cost=490.84..490.84 rows=1 width=23) (actual time=0.831..0.832 rows=22 loops=1)

  • Sort Key: i.issue_type, i.severity, i.resolution, i.status
  • Sort Method: quicksort Memory: 26kB
3. 0.007 0.809 ↓ 22.0 22 1

Nested Loop (cost=478.78..490.83 rows=1 width=23) (actual time=0.616..0.809 rows=22 loops=1)

4. 0.025 0.604 ↓ 22.0 22 1

Bitmap Heap Scan on issues i (cost=478.21..482.23 rows=1 width=65) (actual time=0.585..0.604 rows=22 loops=1)

  • Recheck Cond: (((component_uuid)::text = 'AWviof4rHo1jhXBgw4V_'::text) AND ((project_uuid)::text = 'AWviof4rHo1jhXBgw4V_'::text))
  • Filter: ((status)::text <> 'CLOSED'::text)
  • Rows Removed by Filter: 3
  • Heap Blocks: exact=10
5. 0.003 0.579 ↓ 0.0 0 1

BitmapAnd (cost=478.21..478.21 rows=1 width=0) (actual time=0.579..0.579 rows=0 loops=1)

6. 0.024 0.024 ↑ 81.2 25 1

Bitmap Index Scan on issues_component_uuid (cost=0.00..99.80 rows=2,031 width=0) (actual time=0.024..0.024 rows=25 loops=1)

  • Index Cond: ((component_uuid)::text = 'AWviof4rHo1jhXBgw4V_'::text)
7. 0.552 0.552 ↑ 1.3 6,702 1

Bitmap Index Scan on issues_project_uuid (cost=0.00..378.16 rows=8,745 width=0) (actual time=0.552..0.552 rows=6,702 loops=1)

  • Index Cond: ((project_uuid)::text = 'AWviof4rHo1jhXBgw4V_'::text)
8. 0.198 0.198 ↑ 1.0 1 22

Index Scan using projects_uuid on projects p (cost=0.57..8.59 rows=1 width=42) (actual time=0.009..0.009 rows=1 loops=22)

  • Index Cond: ((uuid)::text = 'AWviof4rHo1jhXBgw4V_'::text)
  • Filter: ((project_uuid)::text = 'AWviof4rHo1jhXBgw4V_'::text)
Planning time : 0.230 ms
Execution time : 0.883 ms