Comments (4)
I checked and both queries correctly use the indices in both local and the preview env.
On the preview env, there is 22 millions logs in the table, which is huge regarding the sizing of the database so there is little we can do except purging the table or allowing more resources to the database.
The database instance is never purged so there is one year of history in it.
There may be a slight performance improvement doable in one of the two queries thought, I can propose it but it will not any huge improvement in the dashboard as it is really an issue with the database instance that is too small to cope with such a large table.
from kestra.
@anna-geller as I said, this is due to a too small database instance / not purged database, I think this visualization provides useful information so I don't think it'll be a good idea to remove it just be we deploy Kestra with a too small database and don't purge our preview instance (I'm working on it).
If you still think we should remove it, we can remove the list of error logs and keep the logs histogram, this is the slowest visualization of the two, this will reduce load on the database (also those calls are made twice, I already opened an issue about it).
from kestra.
We should remove it because there is a risk some users don't purge the logs and their main dashboard doesn't load then. We will find a smarter way to present that information, a topic for the onsite:)
from kestra.
superseded by #3822
from kestra.
Related Issues (20)
- Send "HTTP 413 Payload Too Large" response when webhook trigger receives a too large payload
- Wrong evaluation of If condition HOT 2
- Fix python log levels
- [UI] Refactor trigger variables data to use the same columnar expand-collapse format as in the Outputs tab
- Trigger preview should only retrieve top number of attributes HOT 2
- The "+Create" button is missing on the Namespace -> Flows page
- Triggers logs - flicker on page refresh HOT 1
- `io.kestra.plugin.kubernetes.PodCreate` fails with outputFiles using a glob pattern eg `*.txt` HOT 1
- Automate creation of a PR to SchemaStore after each release to keep the schema for Neovim up to date
- Fix typos in the API schema HOT 2
- No results for the current selection - replace with "No logs emitted" HOT 2
- Outputs don't show up randomly HOT 1
- [Epic] Inputs Enhancements
- Provide a clearer error message when WaitFor task is called from other Flowable like the If block HOT 1
- The curl command displayed in the Execute modal fills default values incorrectly for inputs of type FILE, DURATION, TIME and DATE HOT 2
- 400 response code on Delete flow logs
- Introduce new filter/search bar for Flows and Executions
- Blueprints page is broken on develop HOT 1
- Input validation error regression
- Error Stack-trace on Debug Outputs is hidden (too narrow column to show full error message, no scroll)
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from kestra.