Query inspector for dashboard charts (SQL, response, and execution stats)

[jsk1004ha]

Problem

When a dashboard chart returns unexpected data or is slower than expected, troubleshooting is split across separate actions. “View query” shows generated SQL and “View as table” shows the tabular result, but there is no single place to inspect the cached chart response and basic execution statistics.

Grafana’s panel inspector provides a useful precedent: it groups query details, response data, and statistics so a user can debug a panel without leaving the dashboard.

Proposed Superset MVP

Enhance the existing dashboard “View query” modal into a “Query inspector” with:

• Query — preserve the current generated-SQL behavior.
• Response — display and copy the chart's cached queriesResponse as formatted JSON, without issuing another data query.
• Stats — show query count, returned payload rows, cached-query count, serialized response size, and chart update duration.

The existing “View as table” action remains unchanged and continues to be the user-friendly data view. The Response tab is intended for debugging the actual chart-data payload.

Permissions

The inspector should preserve existing permission boundaries:

• Users with can_view_query can access generated SQL and non-sensitive aggregate stats.
• Raw response JSON is only shown when the user can already explore the chart or use “View as table”.

Implementation notes

• Reuse the queriesResponse, chartUpdateStartTime, and chartUpdateEndTime already stored in the dashboard chart state.
• Do not repeat the chart data request to populate Response or Stats.
• Keep the existing query-generation request and error handling unchanged.
• Add focused React Testing Library coverage for stats and permission-aware response visibility.

Would this be a useful direction for consolidating dashboard chart troubleshooting? A first implementation is ready and intentionally limits scope to cached response data and metrics Superset already records.

Implementation: #43376