Sync project info to security_inventory_filters table

What does this MR do and why?

Sync project info to security_inventory_filters table

Changelog: changed EE: true

Query plans

The table is brand new with no actual data yet, so expect the plan to show 0 affected rows.

Security::InventoryFilter.by_project_id(<id>).update(project_name: self.name)

Raw SQL
UPDATE "security_inventory_filters" SET "project_name" = 'New Project Name' WHERE "security_inventory_filters"."id" = 1
Plan

See full plan here.

 ModifyTable on public.security_inventory_filters  (cost=0.15..3.17 rows=0 width=0) (actual time=0.023..0.024 rows=0 loops=1)
   Buffers: shared hit=5
   I/O Timings: read=0.000 write=0.000
   ->  Index Scan using security_inventory_filters_pkey on public.security_inventory_filters  (cost=0.15..3.17 rows=1 width=38) (actual time=0.022..0.022 rows=0 loops=1)
         Index Cond: (security_inventory_filters.id = 1)
         Buffers: shared hit=5
         I/O Timings: read=0.000 write=0.000
Settings: random_page_cost = '1.5', jit = 'off', seq_page_cost = '4', work_mem = '100MB', effective_cache_size = '338688MB'

MR acceptance checklist

Evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

Related to #554135 (closed)

Edited by Gal Katz

Merge request reports

Loading