Performance Troubleshooting

A. "My report takes too long to load"

Try to narrow down to symptom B, C, or E.

B. "My report takes too long at Pending status"

Cause(s):

• Your Report job queue is overloaded
• And/or this user has reached their Per-user Report Job Limit

Resolution:

1. Validate the cause using Blocked Jobs Analysis of Job Performance Analytics
2. Possible optimizations:
   • Optimize slow Jobs (see symptom C) to free up Report workers
   • Disable Dashboard Auto-run
   • Increase the Per-user Report Job Limit
   • Request to increase your Report Workers
   • Adjust Unused Job Timeout

C. "My report takes too long at Running query... status"

Cause(s):

• The query execution is taking long on your Data Warehouse -> Go to section D
• The query result is too big and hence it is slow to fetch the result to Holistics -> Try to
  • Migrate to a Holistics Data Center that is physically closer to your Data Warehouse
  • Reduce the number of data points

Notes:

• How to validate the cause?
  • Compare Holistics Job Logs against your Data Warehouse logs. (Holistics Job Logs are accessible in Job Monitoring page)
  • Compare against the execution/query plan on the Data Warehouse (e.g. using EXPLAIN ANALYZE). Learn more
  • Try downloading the data from the Data Warehouse console and time the download

D. "My query takes too long to run on the Data Warehouse"

Cause(s):

• The query is costly/complex and hence it is slow by itself
  • -> Check the execution/query plan on the Data Warehouse (e.g. using EXPLAIN ANALYZE). Learn more
  • Possible optimizations:
    • Pre-aggregate data
    • Use Query Parameters to push down predicates and utilize database indexing more efficiently.
    • Add indexes/clustering/partitioning on the Data Warehouse. Learn more
• The Data Warehouse is overloaded
  • -> Increase resources (e.g. CPU, Memory) of the Data Warehouse

E. "My report takes too long at Processing result status"

• The query result is too big and hence it is slow to fetch the result to Holistics -> Try to Reduce the number of data points

F. "My users complain about performance but I don't know where to start"

Use Job Performance Analytics

Others

If:

• Your performance issue does not match any symptom above
• Or the suggested solutions do not work for you

Please reach out to Support for Slow Jobs.

Appendix

Checking execution/query plan on Data Warehouse

• Tips:
  • You can find the Executed Query in the bottom section of an expanded widget, or in your Job Logs
  • You can run EXPLAIN ANALYZE directly in Holistics SQL Editor with option Non-select query enabled
• References:
  • Postgresql
  • BigQuery
  • Snowflake
  • Redshift
  • Athena

Indexing/Clustering/Partitioning