system_history.profile_history

Query performance deep-dive analytics - Detailed execution profiles and statistics for every SQL query. Essential for:

• Performance Optimization: Identify bottlenecks and optimize slow queries
• Resource Planning: Understand memory, CPU, and I/O usage patterns
• Execution Analysis: Analyze query plans and execution statistics
• Capacity Management: Monitor resource consumption trends over time

Fields

Examples

The profiles field can be used to extract specific information. For example, to get the OutputRows value for every physical plan, the following query can be used:

SELECT jq('[.[] | {id, output_rows: .statistics[4]}]', profiles ) AS result FROM system_history.profile_history LIMIT 1;

*************************** 1. row ***************************
result: [{"id":0,"output_rows":1},{"id":3,"output_rows":8},{"id":1,"output_rows":1},{"id":2,"output_rows":1}]