Skip to content

Web: Query Tag Usage prints raw ISO timestamps and a relation name, and the Queries tab still says "effective_start (see hints)" (#5644 W8/W20 leftovers) #6831

Closed

Description

@erikdarlingdata

Claude posting for Erik Darling.

What happens

Two web pages still show text written for MCP callers. One is new since v3.11.0.

What I saw

3.11.0-nightly.20261027.595 (99cbad9), a headless sweep of the same 54 pages as the v3.11.0 retest.

Query Tag Usage (new since v3.11.0). The page shows a tier note with raw ISO stamps at 100 ns precision and an internal relation name:

collect.query_stats_io_hourly (hourly rollup) | hourly buckets start on the hour: no bucket before 2026-10-26T13:00:00.0000000Z: the data from 2026-10-26T12:50:01.0234751Z to 2026-10-26T13:00:00.0000000Z is not included; served from 2026-10-26T13:00:00.0000000Z to 2026-10-27T11:00:00.0000000Z; the hourly rollup is materialized only to 2026-10-27T11:00:00.0000000Z; nothing after it was read

The v3.11.0 sweep had no raw ISO stamp on any of the 54 pages (W20).

Query Store section (coming with #6825). #6825 is a draft that is not merged yet. It gives the Query Store section of this page the same kind of note, window_edges_note with the same wording, and the source name collect.query_store_hash_hourly + collect.query_store_interval_wide. The fix for this issue covers that section too.

Server Queries tab. The empty Query Store regressions panel says:

Nothing in the part of the window the store covers; the store's data for this read starts at effective_start (see hints), so the stretch before it is not a report that nothing happened.

The page does not show effective_start or any hints.

Smaller, same class: "1431 scheduler_monitor_system_health_ring_buffer_recorded event(s) were captured" on System Events, and "3 database(s) with low IO latency" on FinOps Recommendations.

Where

Suggested fix

  • Put the tier note through plainText, or build a page sentence from its fields: "Hourly data from Oct 26, 9:00 am to Oct 27, 7:00 am. The 10 minutes before the first full hour are not included." Use the page's own time format and zone.
  • Rewrite "starts at effective_start (see hints)" on the page as the time itself: "the store's data for this read starts at Oct 22, 8:02 pm".

How to verify

Search the rendered text of every page for \d{4}-\d\d-\d\dT\d\d:\d\d:\d\d, effective_start, (see hints) and collect.. None should match.

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't workingowner:pm-worker-helperLaptop helper session: click-test fixes. Other sessions leave these alone.

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions