[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-25 UTC."],[],[],null,["# Looker performance documents\n\nThis page lists Looker documentation pages that include information about optimizing Looker performance.\n\nOverview\n--------\n\nThe following page provides a high-level view of issues that can affect Looker performance.\n\n- [Performance overview](/looker/docs/2512/best-practices/how-to-optimize-looker-performance)\n\nDashboard performance\n---------------------\n\nThe following page provides tips on how to design Looker dashboards to optimize performance.\n\n- [Considerations when building performant Looker dashboards](/looker/docs/2512/best-practices/considerations-when-building-performant-dashboards)\n\nQuery performance\n-----------------\n\nThe following pages provide information on how to design LookML models to optimize query performance.\n\n- [Optimize query performance](/looker/docs/2512/best-practices/how-to-optimize-looker-server-performance#optimize-query-performance)\n- [Caching queries](/looker/docs/2512/caching-and-datagroups)\n- [Aggregate awareness](/looker/docs/2512/aggregate_awareness)\n- [Aggregate awareness tutorial](/looker/docs/2512/best-practices/aggregate-awareness-tutorial)\n- [Accelerate your queries with Looker aggregate awareness](https://cloud.google.com/blog/products/data-analytics/accelerate-queries-looker-aggregate-awareness)\n- [Incremental PDTs](/looker/docs/2512/incremental-pdts)\n- [How to Optimize SQL with EXPLAIN](https://www.googlecloudcommunity.com/gc/Technical-Tips-Tricks/How-to-Optimize-SQL-with-EXPLAIN/ta-p/587526)\n- [suggestions (for fields)](/looker/docs/2512/reference/param-field-suggestions)\n\nInstance performance\n--------------------\n\nThis section includes information on ways Looker admins can optimize the Looker instance.\n\n- [Optimize Looker server performance](/looker/docs/2512/best-practices/how-to-optimize-looker-server-performance#optimize-looker-server-performance)\n- [Max number of PDT builder connections](/looker/docs/2512/connecting-to-your-db#max_number_of_pdt_builder_connections)\n- [Fetch Information Schema For SQL Writing](/looker/docs/2512/connecting-to-your-db#fetch_information_schema_for_sql_writing)\n\n### Customer-hosted instances\n\nThis section includes performance information that is specific to customer-hosted instances.\n\n- [Recommended Java memory settings](/looker/docs/2512/recommended-java-memory-settings)\n- [Migrating the Looker backend database to MySQL](/looker/docs/2512/migrating-looker-backend-db-to-mysql)\n\nDatabase performance\n--------------------\n\nThis section includes both general and dialect-specific information about optimizing database performance for use with Looker.\n\n- [Database connection pooling](/looker/docs/2512/db-connection-pooling)\n\n### BigQuery\n\n- [Job labels and context comments for BigQuery connections](/looker/docs/2512/db-config-google-bigquery#job-labels-and-context-comments-for)\n\n### Amazon Redshift\n\n- [Optionally accessing data in S3 using Amazon Redshift Spectrum](/looker/docs/2512/db-config-amazon-redshift#optionally_accessing_data_in_s3_using_amazon_redshift_spectrum)\n\n### Amazon RDS for MySQL\n\n- [Amazon RDS for MySQL](/looker/docs/2512/db-config-mysql-on-amazon-rds)\n\nPerformance monitoring\n----------------------\n\nThis section includes information about how to monitor the performance of a Looker instance.\n\n- [Understanding query performance metrics](/looker/docs/2512/query-performance-metrics)\n\n### System activity dashboards\n\n- [Database Performance dashboard](/looker/docs/2512/system-activity-dashboards#dashboard_performance_dashboard)\n- [Instance Performance dashboard](/looker/docs/2512/system-activity-dashboards#instance_performance_dashboard)\n- [Performance Recommendations dashboard](/looker/docs/2512/system-activity-dashboards#performance_recommendations_dashboard)\n\n### Looker Marketplace\n\n- [Google BigQuery Performance block](https://marketplace.looker.com/marketplace/detail/datatonic-bq-performance-v2)"]]
