Tableau Admin

In this article, we explore how to query the Tableau Server Workgroup PostgreSQL repository to analyze load times for worksheet views. Tableau aggregates performance data daily and monthly in materialized views. By executing these queries, you can monitor the average load times for each worksheet view and gain insights into performance trends.

1. Data Source Overview

The performance data for worksheet views is stored in two key tables:

• public.materialized_views_sheet_performance: This table contains daily aggregated statistics. Each row includes data such as the total load time for a view on a given day, the number of loads, and other related metrics.
• public.materialized_views_sheet_performance_monthly: This table contains monthly aggregated performance data with similar metrics aggregated on a monthly basis.

2. Daily Aggregated Load Time Query

The following query calculates the average load time per worksheet view on a daily basis. It uses the public.materialized_views_sheet_performance table, dividing the total load time by the load count for each worksheet view:

SELECT 
    workbook_id,
    view_id,
    day_timestamp,
    CASE 
        WHEN load_count > 0 THEN total_load_time_in_seconds / load_count 
        ELSE NULL 
    END AS average_load_time_seconds,
    load_count
FROM public.materialized_views_sheet_performance
ORDER BY day_timestamp DESC;

This query helps you identify which worksheet views are performing slowly on a day-to-day basis.

3. Monthly Aggregated Load Time Query

For a broader view of performance trends, use the following query to compute the average load time per worksheet view on a monthly basis using the public.materialized_views_sheet_performance_monthly table:

SELECT 
    workbook_id,
    view_id,
    month_timestamp,
    CASE 
        WHEN load_count > 0 THEN total_load_time_in_seconds / load_count 
        ELSE NULL 
    END AS average_load_time_seconds,
    load_count
FROM public.materialized_views_sheet_performance_monthly
ORDER BY month_timestamp DESC;

This monthly aggregation provides a high-level overview and can help in identifying long-term trends and potential performance bottlenecks.

4. Next Steps

Once you have these queries running, consider the following next steps:

• Integrate the query results into custom dashboards for real-time monitoring.
• Schedule the queries as part of regular performance reports.
• Correlate load times with other server metrics to diagnose performance issues.

5. Conclusion

By executing these load time queries on the Tableau Workgroup database, you gain valuable insights into the performance of individual worksheet views. This analysis is essential for maintaining optimal server performance and ensuring a smooth user experience. For further details and advanced usage, refer to Tableau’s official documentation and best practices.