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

Per-panel saved search sample size #3220

Closed
mkliu opened this issue Mar 1, 2015 · 21 comments
Closed

Per-panel saved search sample size #3220

mkliu opened this issue Mar 1, 2015 · 21 comments
Labels
Feature:Dashboard Dashboard related features Feature:Discover Discover Application release_note:enhancement Team:Visualizations Visualization editors, elastic-charts and infrastructure

Comments

@mkliu
Copy link

mkliu commented Mar 1, 2015

In K3 we could control paging and how many to query. But K4 the saved search always tries to load the entire data and slows the entire dashboard down. I tried to change the query to put a limit on size in the settings but looks like it doesn't work.

@rashidkpc
Copy link
Contributor

I'm not seeing this issue, discover:sampleSize seems to limit the size of the dashboard tables as well. That said, it would be nice to have this on a per-panel basis

image

@rashidkpc rashidkpc changed the title limiting saved search size? Per-panel saved search sample size Mar 2, 2015
@agirbal
Copy link

agirbal commented Mar 3, 2015

the search panel seems to have a big impact on overall speed of dashboard, esp if user has higher latency to servers. In one simple dashboard with fairly large docs (~5KB), all panels load in 30ms but the search panel takes 30 seconds, making dashboard tough to use.

@mkliu
Copy link
Author

mkliu commented Mar 5, 2015

ya, and i really miss the collapsible panels in K3, though I know you guys changed design. But the collapsible rows really make the dashboard easy to use. Now I have to do lots of scrolling.

@cdahlqvist
Copy link

When adding a saved search to a dashboard, it would be very useful to be able to control the sample size as well as page size used on this particular dashboard rather than just have it driven off the global configuration parameter.

@mkliu
Copy link
Author

mkliu commented Aug 14, 2015

+1

@agirbal
Copy link

agirbal commented Dec 22, 2015

Seeing this issue again, where Kibana is far away from the ES cluster (+100ms) and the search panel makes the dashboard very slow (minutes). It doesnt seem like it is possible to paginate like in discover, and going to discover disrupts the flow a lot. The only solution is to use 1 ES cluster per location + a queue for distant replication. What do you think? Thanks

@jakommo
Copy link
Contributor

jakommo commented Nov 3, 2016

+1 on this. Tried to manually add a "size": 10 to kibanaSavedObjectMeta.searchSourceJSON for this saved search, but that seems to be ignored.

@TraderApophis
Copy link

+1

@Bargs Bargs added the Feature:Dashboard Dashboard related features label Feb 11, 2017
@goveebee
Copy link

goveebee commented Oct 6, 2017

+1, It would be a really nice feature.

@jpertejo
Copy link

jpertejo commented Nov 8, 2017

+1

5 similar comments
@NeVraX182
Copy link

+1

@netanel246
Copy link

+1

@jarrettj
Copy link

jarrettj commented Apr 6, 2018

+1

@tomas0svk
Copy link

+1

@tylermos
Copy link

+1

@timroes timroes added Feature:Discover Discover Application Team:Visualizations Visualization editors, elastic-charts and infrastructure and removed :Discovery labels Sep 16, 2018
@lukasolson
Copy link
Member

Dupe of #4060.

@SoujanyaRama
Copy link

Nice feature to have. Set size for individual saved search.

@ravitandur
Copy link

Is this implemented?

@rickreesrr
Copy link

Comment on #4060 to upvote

@AndrewStickler
Copy link

I have a dashboard saved search panel showing individual documents. My users are only interested in the most recent ones, but if they extend the dashboard date range, this saved search returns thousands of results, unnecessarily, slowing it down.
I believe the featured discussed in this issue would address my problem, so +1.

jughosta added a commit that referenced this issue Oct 19, 2023
…th a saved search (#157269)

- Closes #94140
- #11758
- #4060
- #3220
- #23307
- Closes #131130 

## Summary

This PR allows to change current sample size right from Discover page,
no need to modify the global default value.

Saved search panels on Dashboard will also use the saved value to fetch
only the requested sample size. This customisation was requested by many
customers as it will allow to load Dashboards faster.

Current range for the slider: from 10 to 1000 (with a step 10).

<img width="400" alt="Screenshot 2023-10-09 at 11 10 52"
src="https://github.com/elastic/kibana/assets/1415710/74e2e4ad-9929-4a44-8d85-c2baafccbaa6">


### Checklist

- [x] Any text added follows [EUI's writing
guidelines](https://elastic.github.io/eui/#/guidelines/writing), uses
sentence case text and includes [i18n
support](https://github.com/elastic/kibana/blob/main/packages/kbn-i18n/README.md)
- [x] [Unit or functional
tests](https://www.elastic.co/guide/en/kibana/master/development-tests.html)
were updated or added to match the most common scenarios
- [x] This renders correctly on smaller devices using a responsive
layout. (You can test this [in your
browser](https://www.browserstack.com/guide/responsive-testing-on-local-server))
- [x] This was checked for [cross-browser
compatibility](https://www.elastic.co/support/matrix#matrix_browsers)
@jughosta
Copy link
Contributor

Implemented via #157269 and will be available in 8.12

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Feature:Dashboard Dashboard related features Feature:Discover Discover Application release_note:enhancement Team:Visualizations Visualization editors, elastic-charts and infrastructure
Projects
None yet
Development

No branches or pull requests