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