Repository navigation
Commit dfe1420
console: Resolve freshness object names client-side
The cluster freshness query joined mz_objects, mz_clusters and
mz_object_fully_qualified_names to name its lag readings. That last one
is a view over three more relations, so one request planned as three
full scans and no lookup.
The useAllObjects subscribe already holds every name, schema, database
and type, so useClusterFreshness now takes the objects to report on and
sends only their IDs. On v26.45.0-dev that goes from five indexes and
three full scans to a single index lookup.
A literal IN list is the only form that reaches a lookup. It degrades to
a full scan past 330 IDs, where an unnested array would hold a
differential join. Taking the common case rather than encoding that
threshold in our code.
buildLagHistoryQuery keeps its joins for Environment Overview and the
object panel, which do read names from SQL.
Co-Authored-By: Claude Opus 5 (1M context) <[email protected]>1 parent d69a1ea commit dfe1420
4 files changed
Lines changed: 270 additions & 122 deletions
File tree
- console/src
- api/materialize/freshness
- platform
- clusters
- ClusterOverview
- freshness
| Original file line number | Diff line number | Diff line change | |
|---|---|---|---|
| |||
45 | 45 | | |
46 | 46 | | |
47 | 47 | | |
| 48 | + | |
| 49 | + | |
| 50 | + | |
| 51 | + | |
| 52 | + | |
| 53 | + | |
| 54 | + | |
| 55 | + | |
| 56 | + | |
| 57 | + | |
| 58 | + | |
| 59 | + | |
| 60 | + | |
| 61 | + | |
| 62 | + | |
| 63 | + | |
| 64 | + | |
| 65 | + | |
| 66 | + | |
| 67 | + | |
| 68 | + | |
| 69 | + | |
| 70 | + | |
| 71 | + | |
| 72 | + | |
| 73 | + | |
| 74 | + | |
| 75 | + | |
| 76 | + | |
| 77 | + | |
| 78 | + | |
| 79 | + | |
| 80 | + | |
| 81 | + | |
| 82 | + | |
| 83 | + | |
| 84 | + | |
| 85 | + | |
| 86 | + | |
| 87 | + | |
| 88 | + | |
| 89 | + | |
| 90 | + | |
| 91 | + | |
| 92 | + | |
| 93 | + | |
| 94 | + | |
| 95 | + | |
| 96 | + | |
| 97 | + | |
| 98 | + | |
| 99 | + | |
| 100 | + | |
| 101 | + | |
| 102 | + | |
| 103 | + | |
| 104 | + | |
| 105 | + | |
| 106 | + | |
| 107 | + | |
| 108 | + | |
| 109 | + | |
| 110 | + | |
| 111 | + | |
| 112 | + | |
| 113 | + | |
| 114 | + | |
| 115 | + | |
| 116 | + | |
| 117 | + | |
| 118 | + | |
| 119 | + | |
| 120 | + | |
| 121 | + | |
| 122 | + | |
| 123 | + | |
| 124 | + | |
| 125 | + | |
| 126 | + | |
| 127 | + | |
48 | 128 | | |
49 | 129 | | |
50 | 130 | | |
| |||
| Original file line number | Diff line number | Diff line change | |
|---|---|---|---|
| |||
41 | 41 | | |
42 | 42 | | |
43 | 43 | | |
| 44 | + | |
44 | 45 | | |
45 | 46 | | |
46 | 47 | | |
| |||
114 | 115 | | |
115 | 116 | | |
116 | 117 | | |
| 118 | + | |
117 | 119 | | |
118 | 120 | | |
119 | | - | |
120 | | - | |
121 | | - | |
122 | | - | |
| 121 | + | |
123 | 122 | | |
124 | 123 | | |
125 | 124 | | |
| |||
0 commit comments