boot superset

[charlieLin552]

After the superset is started, dashboards and charts are automatically queried. As a result, junk SQL statements are encountered within a period of time after the superset is started, which causes the CPU usage of the clickhouse to skyrocket. What can I do to avoid automatically querying dashboards or charts?

[charlieLin552]

I started the celery boot and celery woker

[dosubot[bot]]

To prevent Superset from automatically querying dashboards and charts upon startup, you can adjust the refresh intervals and settings. Here are some steps you can take:

1. Configure Dashboard Auto-Refresh Intervals: You can modify the DASHBOARD_AUTO_REFRESH_INTERVALS setting in the Superset configuration file to set longer refresh intervals. This will reduce the frequency of automatic queries and help manage CPU usage on ClickHouse. For example, you can start with a minimum interval of 5 minutes instead of shorter intervals like 10 seconds ^[1].

2. Check for Configuration Settings: While I couldn't find a specific setting in the repository to prevent automatic querying on startup, you might want to review your Superset configuration files for any settings related to dashboard or chart loading behavior.

These adjustments should help in managing the load on your ClickHouse database by reducing the frequency of automatic queries.

To continue talking to Dosu, mention @dosu.

---

^{Help Dosu learn! Give it feedback: Great Response | Irrelevant Answer | Incorrect Sources | Too Verbose | Hallucination | Other}