explain.depesz.com

PostgreSQL's explain analyze made readable

Result: izvJ

Settings
# exclusive inclusive rows x rows loops node
1. 7,125.259 7,125.259 ↓ 10.0 10 1

CTE Scan on promoted_epics (cost=20,088.65..20,088.67 rows=1 width=8) (actual time=7,057.540..7,125.259 rows=10 loops=1)

  • Buffers: shared hit=562331
2.          

CTE promotion_notes

3. 0.026 7,107.674 ↑ 2.4 10 1

Nested Loop (cost=19,398.42..19,671.05 rows=24 width=116) (actual time=7,055.021..7,107.674 rows=10 loops=1)

  • Buffers: shared hit=557629
4. 52.570 7,107.508 ↑ 2.4 10 1

Bitmap Heap Scan on public.notes (cost=19,397.98..19,563.95 rows=24 width=116) (actual time=7,054.980..7,107.508 rows=10 loops=1)

  • Filter: (notes.system AND ((notes.noteable_type)::text = 'Issue'::text))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=557589
5. 4.571 7,054.938 ↓ 0.0 0 1

BitmapAnd (cost=19,397.98..19,397.98 rows=82 width=0) (actual time=7,054.938..7,054.938 rows=0 loops=1)

  • Buffers: shared hit=555760
6. 6,557.980 6,557.980 ↑ 6.3 2,741 1

Bitmap Index Scan using index_notes_on_note_trigram (cost=0.00..1,228.96 rows=17,195 width=0) (actual time=6,557.980..6,557.980 rows=2,741 loops=1)

  • Index Cond: (notes.note ~~ 'promoted to epic%'::text)
  • Buffers: shared hit=552020
7. 492.387 492.387 ↓ 1.0 1,167,297 1

Bitmap Index Scan using notes_pkey (cost=0.00..18,168.76 rows=1,140,819 width=0) (actual time=492.387..492.387 rows=1,167,297 loops=1)

  • Index Cond: ((notes.id >= 168890616) AND (notes.id <= 170219140))
  • Buffers: shared hit=3740
8. 0.140 0.140 ↑ 1.0 1 10

Index Scan using projects_pkey on public.projects (cost=0.43..4.45 rows=1 width=8) (actual time=0.013..0.014 rows=1 loops=10)

  • Index Cond: (projects.id = notes.project_id)
  • Buffers: shared hit=40
9.          

CTE promoted_epics

10. 0.023 7,125.245 ↓ 10.0 10 1

Nested Loop (cost=0.29..417.60 rows=1 width=8) (actual time=7,057.537..7,125.245 rows=10 loops=1)

  • Buffers: shared hit=562331
11. 7,107.692 7,107.692 ↑ 2.4 10 1

CTE Scan on promotion_notes (cost=0.00..0.48 rows=24 width=40) (actual time=7,055.024..7,107.692 rows=10 loops=1)

  • Buffers: shared hit=557629
12. 17.530 17.530 ↑ 1.0 1 10

Index Scan using index_epics_on_group_id on public.epics (cost=0.29..17.37 rows=1 width=12) (actual time=1.244..1.753 rows=1 loops=10)

  • Index Cond: (epics.group_id = promotion_notes.epic_group_id)
  • Filter: (promotion_notes.promotion_note = concat('promoted to epic &', epics.iid))
  • Rows Removed by Filter: 572
  • Buffers: shared hit=4702