xneg opened a new pull request, #19532: URL: https://github.com/apache/superset/pull/19532
### SUMMARY When opening welcome page (`/superset/welcome/`) it took between 10 and 20 seconds to show first results. This is because of `/superset/recent_activity` endpoint and query against `logs` table inside it. To speed up this query I suggest to add composite index from `user_id` and `dttm` to this table. ### ADDITIONAL INFORMATION <!--- Check any relevant boxes with "x" --> <!--- HINT: Include "Fixes #nnn" if you are fixing an existing issue --> - [x] Includes DB Migration (follow approval process in [SIP-59](https://github.com/apache/superset/issues/13351)) - [x] Migration is atomic, supports rollback & is backwards-compatible - [x] Confirm DB migration upgrade and downgrade tested -- 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. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
