cesar-loadsmart commented on issue #16528:
URL: https://github.com/apache/superset/issues/16528#issuecomment-1237297456
We've fixed our problem by creating a specific index for this query:
```
SELECT anon_1.dashboard_id AS anon_1_dashboard_id, anon_1.slice_id AS
anon_1_slice_id, anon_1.action AS anon_1_action, anon_1.dttm AS anon_1_dttm,
dashboards.slug AS dashboard_slug, dashboards.dashboard_title AS
dashboards_dashboard_title, slices.slice_name AS slices_slice_name
FROM (SELECT logs.dashboard_id AS dashboard_id, logs.slice_id AS slice_id,
logs.action AS action, max(logs.dttm) AS dttm
FROM logs
WHERE logs.action IN ('explore', 'dashboard') AND logs.user_id = <USERID>
AND logs.dttm > '2021-08-24T17:20:50.496891'::timestamp AND (logs.dashboard_id
IS NOT NULL OR logs.slice_id IS NOT NULL) GROUP BY logs.dashboard_id,
logs.slice_id, logs.action) AS anon_1 LEFT OUTER JOIN dashboards ON
dashboards.id = anon_1.dashboard_id LEFT OUTER JOIN slices ON slices.id =
anon_1.slice_id
WHERE dashboards.dashboard_title != '' OR slices.slice_name != '' ORDER BY
anon_1.dttm DESC
LIMIT 6
```
Our Superset became faster than it was released, today we have around 400
users and more than 100 published dashboards.
--
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]
