Skip to content

ui: add 99.9th and 99.99th SQL latency charts#92591

Merged
craig[bot] merged 1 commit intocockroachdb:masterfrom
maryliag:latency-charts
Nov 30, 2022
Merged

ui: add 99.9th and 99.99th SQL latency charts#92591
craig[bot] merged 1 commit intocockroachdb:masterfrom
maryliag:latency-charts

Conversation

@maryliag
Copy link
Copy Markdown
Contributor

This commit introduces the charts for:
Service Latency: SQL Statements, 99.99th percentile and
Service Latency: SQL Statements, 99.9th percentile on Metrics page under SQL view.

Fixes #74247

Screen Shot 2022-11-28 at 12 23 56 PM

Release note (ui change): Added charts
Service Latency: SQL Statements, 99.9th percentile and Service Latency: SQL Statements, 99.99th percentile to Metrics page, under SQL view.

This commit introduces the charts for:
`Service Latency: SQL Statements, 99.99th percentile`
and
`Service Latency: SQL Statements, 99.9th percentile`
on Metrics page under SQL view.

Fixes cockroachdb#74247

Release note (ui change): Added charts
`Service Latency: SQL Statements, 99.9th percentile` and
`Service Latency: SQL Statements, 99.99th percentile` to Metrics
page, under SQL view.
@maryliag maryliag requested a review from a team November 28, 2022 17:26
@cockroach-teamcity
Copy link
Copy Markdown
Member

This change is Reviewable

Copy link
Copy Markdown
Contributor

@j82w j82w left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Reviewed 1 of 1 files at r1.
Reviewable status: :shipit: complete! 0 of 0 LGTMs obtained (waiting on @maryliag)


-- commits line 7 at r1:
Is it possible to have all of them in a single graph to make it easier to compare p99, p99.9, and p99.99? Having them in 3 separate graphs makes it kind of hard to compare the different percentiles. The different percentiles could have different color/shapes for the lines to make them distinguishable.

@maryliag
Copy link
Copy Markdown
Contributor Author

replying here because reviewable is not working atm
Each of those charts already have different lines per node, so combining all of them into one would need some adjustments . For the issue itself we decided to just add the separate chart as the V1, and then Dongni will work on some new design that can accommodate having different percentiles and nodes lines on the same chart

Copy link
Copy Markdown
Contributor

@j82w j82w left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Reviewed all commit messages.
Reviewable status: :shipit: complete! 0 of 0 LGTMs obtained (waiting on @maryliag)


pkg/ui/workspaces/db-console/src/views/cluster/containers/nodeGraphs/dashboards/sql.tsx line 217 at r1 (raw file):

      tooltip={
        <div>
          Over the last minute, this node executed 99.99% of SQL statements

Shouldn't this be 5 minutes? When hovering over the graph it jumps by 5 minute intervals.

Copy link
Copy Markdown
Contributor Author

@maryliag maryliag left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Reviewable status: :shipit: complete! 0 of 0 LGTMs obtained (waiting on @j82w)


pkg/ui/workspaces/db-console/src/views/cluster/containers/nodeGraphs/dashboards/sql.tsx line 217 at r1 (raw file):

Previously, j82w wrote…

Shouldn't this be 5 minutes? When hovering over the graph it jumps by 5 minute intervals.

I do see data every minute. This is the same tooltip used on all other charts, so I kept the same

Screen Shot 2022-11-29 at 1.04.56 PM.png

Screen Shot 2022-11-29 at 1.05.06 PM.png

@maryliag
Copy link
Copy Markdown
Contributor Author

TFTR!
bors r+

@j82w
Copy link
Copy Markdown
Contributor

j82w commented Nov 29, 2022

see data every minute. This is the same tooltip used on all other charts, so I kept the sam

I can't seem to reply on Reviewable, but the interval changes based on the time range that is selected.

@craig
Copy link
Copy Markdown
Contributor

craig bot commented Nov 29, 2022

Build failed (retrying...):

@craig
Copy link
Copy Markdown
Contributor

craig bot commented Nov 30, 2022

Build succeeded:

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

Provide finer granularity in SQL Service latency with P999 and P9999 (99.9th and 99.99th)

3 participants