Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add time selector to the Diagnostics tab including collection time #92417

Closed
kevin-v-ngo opened this issue Nov 23, 2022 · 0 comments · Fixed by #101489
Closed

Add time selector to the Diagnostics tab including collection time #92417

kevin-v-ngo opened this issue Nov 23, 2022 · 0 comments · Fixed by #101489
Assignees
Labels
C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)

Comments

@kevin-v-ngo
Copy link

kevin-v-ngo commented Nov 23, 2022

This issue breaks down #90292 and #82896 (comment) in the context of statement bundles.

The time selector and selected ranges should persist across all console pages to allow for correlation, especially for scenarios when troubleshooting outliers.

Related issues

Epic: CRDB-8649

Jira issue: CRDB-21756

@kevin-v-ngo kevin-v-ngo added the C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) label Nov 23, 2022
@maryliag maryliag self-assigned this Apr 13, 2023
maryliag added a commit to maryliag/cockroach that referenced this issue Apr 14, 2023
Fixes cockroachdb#92417

This commit adds a time scale picker to the Diagnostics
tab on Statement Details page. The time scale is aligned
with the other ones, and now is possible to see bundles
from only the selected period.

This commit also makes some UX updates on the same tab,
making it use the same SortedTable component as other pages,
removing the white background and title to align with
all other pages that no longer have those items.

Release note (ui change): Add a time scale selector to the Diagnostics
tab under the Statement Details page, make it possible to see bundles
only from the selected period.
craig bot pushed a commit that referenced this issue Apr 18, 2023
101489: ui: add timescale to diag details page r=maryliag a=maryliag

Fixes #92417

This commit adds a time scale picker to the Diagnostics
tab on Statement Details page. The time scale is aligned
with the other ones, and now is possible to see bundles
from only the selected period.

This commit also makes some UX updates on the same tab,
making it use the same SortedTable component as other pages,
removing the white background and title to align with
all other pages that no longer have those items.

Before
<img width="1539" alt="Screenshot 2023-04-13 at 11 12 04 AM" src="https://user-images.githubusercontent.com/1017486/231869218-75499e39-6bdd-4814-b53f-4c4ddce2c299.png">


After
<img width="1539" alt="Screenshot 2023-04-13 at 3 47 12 PM" src="https://user-images.githubusercontent.com/1017486/231869268-d3c659c4-fdcf-4a23-afb7-50553854c1ed.png">
<img width="1546" alt="Screenshot 2023-04-13 at 3 47 21 PM" src="https://user-images.githubusercontent.com/1017486/231869270-ed585ffb-2b85-46a2-8eb3-bc157389880f.png">

https://www.loom.com/share/69f024c0523c4a8c814276f2786ab8a8


Release note (ui change): Add a time scale selector to the Diagnostics
tab under the Statement Details page, make it possible to see bundles
only from the selected period.

101780: sql: use curDB as test session db instead of hard coded string r=chengxiong-ruan a=chengxiong-ruan

Previously, a mistake was made that "defaultdb" is always used as the session current db when constructing the reference provider. This commit fixes it to use the input `curDB`.

Epic: None
Release note: None

101791: rowexec: fix projection on top of EXPORT r=yuzefovich a=yuzefovich

Previously, in the EXPORT processors we hard-coded empty `PostProcessSpec`. This was incorrect in case we have a projection or rendering on top of the EXPORT - in such a scenario we would still simply push out rows as they were produced by the EXPORT core (meaning have exactly `ExportColumns` schema with three columns). This could either lead to panics (like index out of bounds) or incorrect results (say we asked for `length(filename)` instead of `filename` column itself). This is now fixed.

Fixes: #101733.

Release note (bug fix): CockroachDB previously incorrectly evaluated EXPORT statements that had projection or rendering on top of the EXPORT (e.g. `WITH cte AS (EXPORT INTO CSV 'nodelocal://1/export1/' FROM SELECT * FROM t) SELECT filename FROM cte;` wouldn't work) - such statements would result in panics or incorrect query results. Note that the exported data wasn't affected, only the presentation of the query result. The bug has been present since 22.1 or earlier.

Co-authored-by: maryliag <[email protected]>
Co-authored-by: Chengxiong Ruan <[email protected]>
Co-authored-by: Yahor Yuzefovich <[email protected]>
@craig craig bot closed this as completed in 788eace Apr 18, 2023
blathers-crl bot pushed a commit that referenced this issue Apr 18, 2023
Fixes #92417

This commit adds a time scale picker to the Diagnostics
tab on Statement Details page. The time scale is aligned
with the other ones, and now is possible to see bundles
from only the selected period.

This commit also makes some UX updates on the same tab,
making it use the same SortedTable component as other pages,
removing the white background and title to align with
all other pages that no longer have those items.

Release note (ui change): Add a time scale selector to the Diagnostics
tab under the Statement Details page, make it possible to see bundles
only from the selected period.
blathers-crl bot pushed a commit that referenced this issue Apr 18, 2023
Fixes #92417

This commit adds a time scale picker to the Diagnostics
tab on Statement Details page. The time scale is aligned
with the other ones, and now is possible to see bundles
from only the selected period.

This commit also makes some UX updates on the same tab,
making it use the same SortedTable component as other pages,
removing the white background and title to align with
all other pages that no longer have those items.

Release note (ui change): Add a time scale selector to the Diagnostics
tab under the Statement Details page, make it possible to see bundles
only from the selected period.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants