codeant-ai-for-open-source[bot] commented on PR #34513:
URL: https://github.com/apache/superset/pull/34513#issuecomment-3894224221
## **Sequence Diagram**
This PR maps PostgreSQL INTERVAL to a numeric type and normalizes interval
values (timedelta/numeric) to milliseconds so backend returns numeric metrics
that bar/pie charts can render correctly.
```mermaid
sequenceDiagram
participant DB as PostgreSQL
participant Backend as PostgresEngineSpec
participant API as Backend API
participant Frontend as Chart Renderer
Frontend->>API: Request chart data (uses INTERVAL metric)
API->>DB: Execute query returning INTERVAL column
DB-->>API: INTERVAL values (timedelta or numeric)
API->>Backend: Apply column_type_mutators for INTERVAL
Backend-->>API: Normalized numeric values (milliseconds or None)
API-->>Frontend: JSON payload with numeric metric values
Frontend-->>Frontend: Render bar/pie using numeric durations
```
---
*Generated by [CodeAnt AI](https://codeant.ai)*
--
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
