[[["容易理解","easyToUnderstand","thumb-up"],["確實解決了我的問題","solvedMyProblem","thumb-up"],["其他","otherUp","thumb-up"]],[["難以理解","hardToUnderstand","thumb-down"],["資訊或程式碼範例有誤","incorrectInformationOrSampleCode","thumb-down"],["缺少我需要的資訊/範例","missingTheInformationSamplesINeed","thumb-down"],["翻譯問題","translationIssue","thumb-down"],["其他","otherDown","thumb-down"]],["上次更新時間:2025-09-05 (世界標準時間)。"],[],[],null,["# Admin settings: Content guardrails\n\nThe **Content guardrails** page lets Looker admins:\n\n- Disable or set limits on [merged results](/looker/docs/merged-results) queries.\n\n Merged results queries are calculated post-query processing. Excessive calculations can compete for Java memory on the Looker instance, causing the Looker instance to respond more slowly.\n- Limit the use of the dashboard [autorefresh](/looker/docs/editing-user-defined-dashboards#autorefresh) option.\n\n Looker dashboards can also be configured to\n [autorefresh](/looker/docs/editing-user-defined-dashboards#autorefresh), which\n refreshes the displayed data at automatic intervals. Each time a dashboard tile refreshes its data, the system generates and sends a\n query to the database. When a dashboard refreshes, the system generates queries\n for each tile on the dashboard. Frequent dashboard refreshes, especially on\n large dashboards, can significantly strain database systems and cause\n performance issues. Similarly, when multiple users access a dashboard with\n autorefresh enabled, performance might be impeded.\n\nFor more information and recommendations about building performant dashboards, see [Considerations when building performant Looker\ndashboards](/looker/docs/best-practices/considerations-when-building-performant-dashboards).\n\nThe **Content guardrails** page has the following options:\n\n- [Limit users from adding new Merged Results queries to dashboards](#limit_users_from_adding_new_merged_results_queries_to_dashboards)\n- [Limit users from executing existing Merged Results queries](#limit_users_from_executing_existing_merged_results_queries)\n- [Limit the automatic dashboard refresh option](#limit_the_automatic_dashboard_refresh_option)\n- [Set a minimum refresh interval for autorefreshing dashboards and tiles globally](#set_a_minimum_refresh_interval_for_autorefreshing_dashboards_and_tiles_globally)\n\nLimit users from adding new Merged Results queries to dashboards\n----------------------------------------------------------------\n\nWhen you enable this option, Looker prevents users from saving new [Merged\nResults](/looker/docs/merged-results) queries to dashboards. Dashboards with\nexisting Merged Results queries remain functional.\n\nLimit users from executing existing Merged Results queries\n----------------------------------------------------------\n\nWhen you enable this option, Looker stops executing [Merged\nResults](/looker/docs/merged-results) queries and reports an error instead.\nExisting dashboards with Merged Results queries will report `No Results` and show an\nerror for the corresponding elements. If Looker encounters these errors, Looker won't complete scheduled deliveries of dashboards that have Merged Results queries.\n\nLimit the automatic dashboard refresh option\n--------------------------------------------\n\nWhen this option is enabled, only Looker admins can configure dashboards to\n[autorefresh](/looker/docs/editing-user-defined-dashboards#autorefresh).\n\nSet a minimum refresh interval for autorefreshing dashboards and tiles globally\n-------------------------------------------------------------------------------\n\nThe **Limit the minimum refresh interval for auto-refreshing dashboards and\ntiles globally** field lets you set a minimum time interval for the dashboard\nautorefresh option. This setting applies to all dashboards in the Looker instance.\n\nAny dashboards that are configured to autorefresh more frequently than the time interval\nin this field won't autorefresh any more frequently than the value that's configured in this field.\n\nAs an example, if you have a dashboard that is configured to autorefresh more frequently that your database ETL process occurs, then any time the dashboard refreshes before the next ETL occurs, the dashboard won't retrieve any new data. To prevent these unnecessary queries, you could use this field to set the minimum dashboard refresh time to match the time between your database ETL processes, so that when the dashboard refreshes, it will be retrieving new data.\n\nTo set a minimum time for dashboard autorefresh, select a time interval\n(seconds, minutes, hours, or days). Then, enter the number of the selected time\ninterval that constitutes the minimum time between dashboard autorefreshes.\nAfter you enter the minimum time interval, click **Save**.\n\nSet this field to **0** or leave it blank to enable unlimited dashboard autorefresh\ntimes."]]