explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Q3WH

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.011 ↓ 0.0 0 1

Update on issues (cost=10.57..12.61 rows=1 width=454) (actual time=0.011..0.011 rows=0 loops=1)

2.          

CTE promotion_notes

3. 0.001 0.009 ↓ 0.0 0 1

Nested Loop (cost=0.27..4.41 rows=1 width=43) (actual time=0.008..0.009 rows=0 loops=1)

4. 0.008 0.008 ↓ 0.0 0 1

Index Scan using t1 on notes (cost=0.12..2.15 rows=1 width=43) (actual time=0.008..0.008 rows=0 loops=1)

  • Filter: (system AND (id >= 1) AND (id <= 3) AND ((noteable_type)::text = 'Issue'::text))
5. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_projects_on_repository_storage_last_repository_updated_at on projects (cost=0.14..2.16 rows=1 width=8) (never executed)

  • Index Cond: (id = notes.project_id)
6.          

CTE promoted_epics

7. 0.000 0.009 ↓ 0.0 0 1

Nested Loop (cost=0.14..5.89 rows=1 width=8) (actual time=0.009..0.009 rows=0 loops=1)

8. 0.009 0.009 ↓ 0.0 0 1

CTE Scan on promotion_notes (cost=0.00..0.02 rows=1 width=40) (actual time=0.009..0.009 rows=0 loops=1)

9. 0.000 0.000 ↓ 0.0 0

Index Scan using index_epics_on_group_id on epics (cost=0.14..5.86 rows=1 width=12) (never executed)

  • Index Cond: (group_id = promotion_notes.epic_group_id)
  • Filter: (promotion_notes.promotion_note = concat('promoted to epic &', iid))
10. 0.000 0.010 ↓ 0.0 0 1

Nested Loop (cost=0.28..2.32 rows=1 width=454) (actual time=0.010..0.010 rows=0 loops=1)

11. 0.010 0.010 ↓ 0.0 0 1

CTE Scan on promoted_epics (cost=0.00..0.02 rows=1 width=40) (actual time=0.010..0.010 rows=0 loops=1)

12. 0.000 0.000 ↓ 0.0 0

Index Scan using issues_pkey on issues (cost=0.28..2.30 rows=1 width=418) (never executed)

  • Index Cond: (id = promoted_epics.issue_id)
  • Filter: (promoted_to_epic_id IS NULL)
Planning time : 7.836 ms
Execution time : 0.235 ms