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

Example/Explain length in QAN limited to 20KB #2599

Open
1 task done
pgodinic opened this issue Nov 6, 2023 · 0 comments
Open
1 task done

Example/Explain length in QAN limited to 20KB #2599

pgodinic opened this issue Nov 6, 2023 · 0 comments
Assignees
Labels
bug Bug report

Comments

@pgodinic
Copy link

pgodinic commented Nov 6, 2023

Description

Looks like that Example/Explain length is limited to 20KB. We are using --query-source=slowlog --size-slow-logs=2GiB --disable-tablestats --max-query-length=-1 in PMM agent. 
Most of the queries are shorter than this but we have few that we can't show. In slow query log file i can see whole query.
This is an example of the query.
pmm_20KB

Here is a query lenght from ClickHouse.
9912770ce518 :) select max(length(fingerprint)),max(length(example)) from pmm.metrics where queryid='33BB234C144D56BE' limit 1;

SELECT
max(length(fingerprint)),
max(length(example))
FROM pmm.metrics
WHERE queryid = '33BB234C144D56BE'
LIMIT 1

Query id: 0b59e7da-cf30-4b47-9477-3dd1e0707e67

┌─max(length(fingerprint))─┬─max(length(example))─┐
│ 27706 │ 20480 │
└──────────────────────────┴──────────────────────┘

Expected Results

Example/Explain should not be truncated on 20KB

Actual Results

Example/Explain were truncated.

  • I can see whole query when i hover over query info icon

Version

PMM Server 2.40.1, PMM agent 2.40.1-6.bullseye

Steps to reproduce

Simply run query that is longer than 20KB. It will be truncated on QAN.

Relevant logs

No response

Code of Conduct

  • I agree to follow Percona Community Code of Conduct
@pgodinic pgodinic added the bug Bug report label Nov 6, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Bug report
Projects
None yet
Development

No branches or pull requests

3 participants