AI metrics via PG: Create time-range partitioned table for events.
Problem
Proposal
As part of #474469 (closed):
Create a time-range partitioned database table called ai_code_suggestion_events
(and the AR model) where we keep old data for 3 months (retention config). The table does not require foreign keys.
List of events:
-
user_id
- bigint -
event
(requested, accepted, rejected) - smallint -
namespace_path
(group/project pointer) - string, maybe we use route path here -
timestamp
- timestamp -
unique_tracking_id
- uuid -
language
- smallint -
suggestion_size
(?) - bigint
Edited by Adam Hegyi