Skip to content

Migrate mentions for design notes

Number of rows affected

Design notes with mentions ~652

  explain select id from notes where noteable_type = DesignManagement::Design and note like %\@%

Index Scan using index_notes_on_noteable_id_and_noteable_type on public.notes  (cost=0.57..4519075.97 rows=3936 width=4) (actual time=7.361..952352.359 rows=652 loops=1)
   Index Cond: ((notes.noteable_type)::text = 'DesignManagement::Design'::text)
   Filter: (notes.note ~~ '%\@%'::text)
   Rows Removed by Filter: 1535
   Buffers: shared hit=107 read=1362816 dirtied=17
   I/O Timings: read=938952.612
Edited by Alexandru Croitor