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

Canvas usage-data query is expensive when workpads have images #34513

Closed
peterschretlen opened this issue Apr 4, 2019 · 3 comments
Closed

Canvas usage-data query is expensive when workpads have images #34513

peterschretlen opened this issue Apr 4, 2019 · 3 comments
Assignees
Labels
bug Fixes for quality problems that affect the customer experience Feature:Canvas Team:Presentation Presentation Team for Dashboard, Input Controls, and Canvas

Comments

@peterschretlen
Copy link
Contributor

peterschretlen commented Apr 4, 2019

Kibana version: 6.7

Elasticsearch version: 6.7

Server OS version: macOS

Original install method: source

Describe the bug:
Canvas usage-data query to elasticsearch returns assets. If the asset is large, say a 10MB image, the query is slow and response is huge.

Steps to reproduce:

  1. Turn on monitoring
  2. Turn on usage data
  3. Create new workpad
  4. Insert an image element, upload an image

Expected behavior:
usage-data queries should not return large objects like assets.

Screenshots (if relevant):
Image being returned by query:
image

Any additional context:
Could we exclude assets from the source returned? This seems to address the issue

GET .kibana/_search?filter_path=hits.hits._source.canvas-workpad,-hits.hits._source.canvas-workpad.assets
{
  "query": {
    "bool": {
      "filter": {
        "term": {
          "type": "canvas-workpad"
        }
      }
    }
  }
}
@peterschretlen peterschretlen added bug Fixes for quality problems that affect the customer experience Team:Presentation Presentation Team for Dashboard, Input Controls, and Canvas labels Apr 4, 2019
@elasticmachine
Copy link
Contributor

Pinging @elastic/kibana-canvas

peterschretlen pushed a commit to peterschretlen/kibana that referenced this issue Apr 4, 2019
@epixa
Copy link
Contributor

epixa commented Apr 4, 2019

We can exclude fields with the saved object client, so unless I’m missing something this should be a one line fix.

@shaunmcgough
Copy link

@clintandrewhall

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Fixes for quality problems that affect the customer experience Feature:Canvas Team:Presentation Presentation Team for Dashboard, Input Controls, and Canvas
Projects
None yet
Development

No branches or pull requests

5 participants