[GitHub] [incubator-superset] SyamprasadNakka opened a new issue #8548: Dashboard results are very slow when pointed to Postgres Database

[GitBox <gi...@apache.org>]

SyamprasadNakka opened a new issue #8548: Dashboard results are very slow when pointed to Postgres Database
URL: https://github.com/apache/incubator-superset/issues/8548
 
 
   ###  A clear and concise description of what the bug is.
   
   We have pointed the **SQLALCHEMY_DATABASE_URI** to **POSTGRES** database in superset and created the slices using Oracle database connection. 
   When we accessing the slices from the Charts menu, getting the results in less than 5 seconds. 
   
   But when we place the slices in dashboard and access it from the "Dashboards" menu reports are loading very slow and taking more than 50 seconds to see the data.
   
   
   Are there any pre-requisites to follow to point Superset to Postgres database or any other configurations needs to perform to solve the server slowness issue.
   
   ### Expected results
   
   Results should show in the dashboard screen less than 10 seconds.
   
   ### Actual results
   
   Report performance is very slow when we place it in dashboard and taking more than 50 sec to load.
   
   #### Screenshots
   
   
   
   #### How to reproduce the bug
   
   1. Go to '...'
   2. Click on '....'
   3. Scroll down to '....'
   4. See error
   
   ### Environment
   
   (please complete the following information):
   - OS Details : `Redhat Linux - 7`
   - superset version: `unofficial-superset:0.33.010402`
   - python version: `3.7.3`
   - postgres version: `9.2.24`
   - node.js version: `node -v`
   - npm version: `npm -v`
   
   ### Checklist
   
   Make sure these boxes are checked before submitting your issue - thank you!
   
   - [ ] I have checked the superset logs for python stacktraces and included it here as text if there are any.
   - [ ] I have reproduced the issue with at least the latest released version of superset.
   - [ ] I have checked the issue tracker for the same issue and I haven't found one similar.
   
   ### Additional context
   
   Appreciate your quick response.
   

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org