dimas-b commented on code in PR #3385:
URL: https://github.com/apache/polaris/pull/3385#discussion_r2828462623
##########
persistence/relational-jdbc/src/main/resources/postgres/schema-metrics-v1.sql:
##########
@@ -175,3 +180,8 @@ COMMENT ON COLUMN commit_metrics_report.otel_trace_id IS
'OpenTelemetry trace ID
-- Index for retention cleanup by timestamp
CREATE INDEX IF NOT EXISTS idx_commit_report_timestamp
ON commit_metrics_report(realm_id, timestamp_ms DESC);
+
+-- Index for query lookups by catalog_id and table_id
+-- This index is critical for efficient queries that filter by catalog_id and
table_id
+CREATE INDEX IF NOT EXISTS idx_commit_report_lookup
Review Comment:
nice catch!
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
