explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YqcC

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 5.721 ↑ 80.6 22 1

Nested Loop (cost=1,101.67..26,439.06 rows=1,774 width=686) (actual time=0.780..5.721 rows=22 loops=1)

2. 0.020 0.020 ↑ 1.0 1 1

Index Scan using projects_uuid on projects p (cost=0.57..8.59 rows=1 width=231) (actual time=0.019..0.020 rows=1 loops=1)

  • Index Cond: ((uuid)::text = 'AWviof4rHo1jhXBgw4V_'::text)
3. 6.632 6.972 ↑ 80.6 22 1

Gather (cost=1,101.10..26,412.73 rows=1,774 width=476) (actual time=0.760..6.972 rows=22 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
4. 0.017 0.340 ↑ 94.9 11 2 / 2

Nested Loop (cost=101.10..25,235.33 rows=1,044 width=476) (actual time=0.149..0.340 rows=11 loops=2)

5. 0.007 0.180 ↑ 94.9 11 2 / 2

Nested Loop Left Join (cost=100.53..16,264.50 rows=1,044 width=375) (actual time=0.133..0.180 rows=11 loops=2)

6. 0.032 0.140 ↑ 94.9 11 2 / 2

Parallel Bitmap Heap Scan on issues i (cost=100.25..8,133.15 rows=1,044 width=337) (actual time=0.124..0.140 rows=11 loops=2)

  • Recheck Cond: ((component_uuid)::text = 'AWviof4rHo1jhXBgw4V_'::text)
  • Filter: ((status)::text <> 'CLOSED'::text)
  • Rows Removed by Filter: 2
  • Heap Blocks: exact=10
7. 0.108 0.108 ↑ 81.2 25 1 / 2

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

  • Index Cond: ((component_uuid)::text = 'AWviof4rHo1jhXBgw4V_'::text)
8. 0.033 0.033 ↑ 1.0 1 22 / 2

Index Scan using rules_pkey on rules r (cost=0.29..7.79 rows=1 width=42) (actual time=0.003..0.003 rows=1 loops=22)

  • Index Cond: (i.rule_id = id)
9. 0.143 0.143 ↑ 1.0 1 22 / 2

Index Scan using projects_uuid on projects root (cost=0.57..8.58 rows=1 width=122) (actual time=0.013..0.013 rows=1 loops=22)

  • Index Cond: ((uuid)::text = (i.project_uuid)::text)
Planning time : 0.580 ms
Execution time : 7.068 ms