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.

Sign up for GitHub

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

Jump to bottom

[Platform] Long queries in slow queries QueryDisplayPanel are cut off #8022

Open
andrewc-dev opened this issue Apr 13, 2021 · 1 comment
Open

[Platform] Long queries in slow queries QueryDisplayPanel are cut off #8022

andrewc-dev opened this issue Apr 13, 2021 · 1 comment
Assignees
@andrewc-dev
Labels
area/platform Yugabyte Platform priority/high High Priority
Projects
Platform
Milestone
2.7.x

Comments

@andrewc-dev
Copy link
Contributor

Maximum length of displayed query statement is too short for long queries.
@andrewc-dev andrewc-dev added the area/platform Yugabyte Platform label Apr 13, 2021
@andrewc-dev andrewc-dev self-assigned this Apr 13, 2021
@streddy-yb streddy-yb added this to To do in Platform Apr 13, 2021
@streddy-yb streddy-yb added this to the 2.7.x milestone Apr 13, 2021
@andrewc-dev
Copy link
Contributor Author

The query statement length is limited by a postgres setting called track_activity_query_size, which defaults to 1024 bytes. Setting ysql_pg_conf_csv flag to include this setting will increase the byte size limit for query statements. Since ysql_pg_conf_csv can include multiple configurations, the new key-value must be appended at the end: conf1=v1,conf2=v2,track_activity_query_size=4096.

@andrewc-dev andrewc-dev moved this from To do to Backlog in Platform Jun 24, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@andrewc-dev andrewc-dev

Labels
area/platform Yugabyte Platform priority/high High Priority
Projects
Platform
  
Backlog
Milestone
2.7.x
Development

No branches or pull requests
3 participants
@rthallamko3 @andrewc-dev @streddy-yb