Skip to content

sqlstats: record idle latency for transactions#92695

Merged
craig[bot] merged 1 commit intocockroachdb:masterfrom
matthewtodd:idle_lat-txn
Nov 30, 2022
Merged

sqlstats: record idle latency for transactions#92695
craig[bot] merged 1 commit intocockroachdb:masterfrom
matthewtodd:idle_lat-txn

Conversation

@matthewtodd
Copy link
Copy Markdown

Part of #86667
Follows #91098

Release note (sql change): A new NumericStat, idleLat, was introduced to the statistics column of crdb_internal.transaction_statistics, reporting the time spent waiting for the client to send statements while holding a transaction open.

@cockroach-teamcity
Copy link
Copy Markdown
Member

This change is Reviewable

Part of #86667
Follows #91098

Release note (sql change): A new NumericStat, idleLat, was introduced to
the statistics column of crdb_internal.transaction_statistics, reporting
the time spent waiting for the client to send statements while
holding a transaction open.
@matthewtodd matthewtodd marked this pull request as ready for review November 30, 2022 19:10
@matthewtodd matthewtodd requested a review from a team November 30, 2022 19:10
@matthewtodd matthewtodd requested a review from a team as a code owner November 30, 2022 19:10
Copy link
Copy Markdown
Contributor

@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.

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


-- commits line 8 at r1:
should you also add this info to the node_transaction_statistics?

Copy link
Copy Markdown
Author

@matthewtodd matthewtodd 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 @maryliag)


-- commits line 8 at r1:

Previously, maryliag (Marylia Gutierrez) wrote…

should you also add this info to the node_transaction_statistics?

Yes! Was planning to do that in a separate PR.

@matthewtodd
Copy link
Copy Markdown
Author

GitHub CI lint error is unrelated, fixed here.

Copy link
Copy Markdown
Contributor

@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.

Nice work!
:lgtm:

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


-- commits line 8 at r1:

Previously, matthewtodd (Matthew Todd) wrote…

Yes! Was planning to do that in a separate PR.

Sounds good!

@matthewtodd
Copy link
Copy Markdown
Author

Thank you!

bors r+

@craig
Copy link
Copy Markdown
Contributor

craig bot commented Nov 30, 2022

Build succeeded:

@craig craig bot merged commit 21ec411 into cockroachdb:master Nov 30, 2022
@matthewtodd matthewtodd deleted the idle_lat-txn branch December 1, 2022 19:33
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.

3 participants