{
"QUERY_HISTORY_SUMMARY": {
"QUERY_ID": "01b12345-0000-0000-0001-abc123456789",
"QUERY_HASH": "a1b2c3d4e5f6g7h8i9j0",
"QUERY_PARAMETERIZED_HASH": "x1y2z3w4q5r6t7u8v9w0",
"QUERY_TEXT_PREVIEW": "SELECT * FROM sales WHERE date = '2025-08-07'...",
"QUERY_TYPE": "SELECT",
"QUERY_TAG": "sales_report",
"START_TIME": "2025-08-07T10:00:00Z",
"END_TIME": "2025-08-07T10:00:15Z",
"TOTAL_ELAPSED_TIME": 15000,
"COMPILATION_TIME": 2000,
"EXECUTION_TIME": 13000,
"USER_NAME": "john.doe",
"USER_TYPE": "HUMAN",
"ROLE_NAME": "ANALYST",
"ROLE_TYPE": "USER",
"SESSION_ID": "1234567890",
"WAREHOUSE_ID": "WH123",
"WAREHOUSE_NAME": "ANALYTICS_WH",
"WAREHOUSE_SIZE": "MEDIUM",
"WAREHOUSE_TYPE": "STANDARD",
"CLUSTER_NUMBER": 1,
"DATABASE_ID": "DB123",
"DATABASE_NAME": "SALES_DB",
"SCHEMA_ID": "SCH123",
"SCHEMA_NAME": "PUBLIC",
"USER_DATABASE_NAME": "SALES_DB",
"USER_SCHEMA_NAME": "PUBLIC",
"EXECUTION_STATUS": "SUCCESS",
"ERROR_CODE": null,
"ERROR_MESSAGE_PREVIEW": null,
"BYTES_SCANNED": 104857600,
"PERCENTAGE_SCANNED_FROM_CACHE": 80,
"BYTES_WRITTEN": 5242880,
"ROWS_PRODUCED": 1000,
"ROWS_INSERTED": 0,
"ROWS_UPDATED": 0,
"ROWS_DELETED": 0,
"CREDITS_USED_CLOUD_SERVICES": 0.5,
"BYTES_SPILLED_TO_LOCAL_STORAGE": 0,
"BYTES_SPILLED_TO_REMOTE_STORAGE": 0,
"PARTITIONS_SCANNED": 10,
"PARTITIONS_TOTAL": 100,
"QUEUED_PROVISIONING_TIME": 0,
"QUEUED_REPAIR_TIME": 0,
"QUEUED_OVERLOAD_TIME": 0,
"TRANSACTION_BLOCKED_TIME": 0,
"DURATION_BUCKET": "10-20 seconds",
"CREDIT_BUCKET": "40-60 cents",
"SPILL_STATUS": "NO_SPILL",
"QUEUE_STATUS": "NOT_QUEUED",
"ANALYSIS_TIMESTAMP": "2025-08-08T05:07:00Z",
"ANALYSIS_DATE": "2025-08-07"
},
"QUERY_DETAILS_COMPLETE": {
"QUERY_ID": "01b12345-0000-0000-0001-abc123456789",
"QUERY_TEXT": "SELECT * FROM sales WHERE date = '2025-08-07' ORDER BY revenue DESC LIMIT 1000",
"QUERY_HASH": "a1b2c3d4e5f6g7h8i9j0",
"QUERY_HASH_VERSION": 2,
"QUERY_PARAMETERIZED_HASH": "x1y2z3w4q5r6t7u8v9w0",
"QUERY_PARAMETERIZED_HASH_VERSION": 2,
"QUERY_TYPE": "SELECT",
"QUERY_TAG": "sales_report",
"START_TIME": "2025-08-07T10:00:00Z",
"END_TIME": "2025-08-07T10:00:15Z",
"TOTAL_ELAPSED_TIME": 15000,
"COMPILATION_TIME": 2000,
"EXECUTION_TIME": 13000,
"QUEUED_PROVISIONING_TIME": 0,
"QUEUED_REPAIR_TIME": 0,
"QUEUED_OVERLOAD_TIME": 0,
"TRANSACTION_BLOCKED_TIME": 0,
"CHILD_QUERIES_WAIT_TIME": 0,
"QUERY_RETRY_TIME": 0,
"QUERY_RETRY_CAUSE": null,
"FAULT_HANDLING_TIME": 0,
"LIST_EXTERNAL_FILES_TIME": 0,
"USER_NAME": "john.doe",
"USER_TYPE": "HUMAN",
"ROLE_NAME": "ANALYST",
"ROLE_TYPE": "USER",
"SECONDARY_ROLE_STATS": null,
"SESSION_ID": "1234567890",
"WAREHOUSE_ID": "WH123",
"WAREHOUSE_NAME": "ANALYTICS_WH",
"WAREHOUSE_SIZE": "MEDIUM",
"WAREHOUSE_TYPE": "STANDARD",
"CLUSTER_NUMBER": 1,
"QUERY_LOAD_PERCENT": 10,
"DATABASE_ID": "DB123",
"DATABASE_NAME": "SALES_DB",
"SCHEMA_ID": "SCH123",
"SCHEMA_NAME": "PUBLIC",
"USER_DATABASE_ID": "DB123",
"USER_DATABASE_NAME": "SALES_DB",
"USER_SCHEMA_ID": "SCH123",
"USER_SCHEMA_NAME": "PUBLIC",
"EXECUTION_STATUS": "SUCCESS",
"ERROR_CODE": null,
"ERROR_MESSAGE": null,
"IS_CLIENT_GENERATED_STATEMENT": false,
"BYTES_SCANNED": 104857600,
"PERCENTAGE_SCANNED_FROM_CACHE": 80,
"BYTES_WRITTEN": 5242880,
"BYTES_WRITTEN_TO_RESULT": 5242880,
"BYTES_READ_FROM_RESULT": 5242880,
"ROWS_PRODUCED": 1000,
"ROWS_WRITTEN_TO_RESULT": 1000,
"ROWS_INSERTED": 0,
"ROWS_UPDATED": 0,
"ROWS_DELETED": 0,
"ROWS_UNLOADED": 0,
"BYTES_DELETED": 0,
"PARTITIONS_SCANNED": 10,
"PARTITIONS_TOTAL": 100,
"PARTITION_SCAN_PERCENTAGE": 10,
"BYTES_SPILLED_TO_LOCAL_STORAGE": 0,
"BYTES_SPILLED_TO_REMOTE_STORAGE": 0,
"BYTES_SENT_OVER_THE_NETWORK": 5242880,
"CREDITS_USED_CLOUD_SERVICES": 0.5,
"OUTBOUND_DATA_TRANSFER_CLOUD": null,
"OUTBOUND_DATA_TRANSFER_REGION": null,
"OUTBOUND_DATA_TRANSFER_BYTES": 0,
"INBOUND_DATA_TRANSFER_CLOUD": null,
"INBOUND_DATA_TRANSFER_REGION": null,
"INBOUND_DATA_TRANSFER_BYTES": 0,
"EXTERNAL_FUNCTION_TOTAL_INVOCATIONS": 0,
"EXTERNAL_FUNCTION_TOTAL_SENT_ROWS": 0,
"EXTERNAL_FUNCTION_TOTAL_RECEIVED_ROWS": 0,
"EXTERNAL_FUNCTION_TOTAL_SENT_BYTES": 0,
"EXTERNAL_FUNCTION_TOTAL_RECEIVED_BYTES": 0,
"QUERY_ACCELERATION_BYTES_SCANNED": 0,
"QUERY_ACCELERATION_PARTITIONS_SCANNED": 0,
"QUERY_ACCELERATION_UPPER_LIMIT_SCALE_FACTOR": 0,
"TRANSACTION_ID": null,
"RELEASE_VERSION": "7.0.0",
"COMPILATION_TIME_PERCENTAGE": 13.33,
"EXECUTION_TIME_PERCENTAGE": 86.67,
"ROWS_PER_MB_SCANNED": 10,
"PERFORMANCE_CATEGORY": "FAST",
"CACHE_EFFICIENCY": "MEDIUM_CACHE_HIT",
"SPILL_CLASSIFICATION": "NO_SPILL",
"ANALYSIS_TIMESTAMP": "2025-08-08T05:07:00Z",
"ANALYSIS_DATE": "2025-08-07"
},
"WAREHOUSE_ANALYTICS_DASHBOARD_with_queries": {
"WAREHOUSE_ID": "WH123",
"WAREHOUSE_NAME": "ANALYTICS_WH",
"WAREHOUSE_SIZE": "MEDIUM",
"WAREHOUSE_TYPE": "STANDARD",
"CLUSTER_COUNT": 1,
"SUSPEND_POLICY": null,
"MIN_CLUSTER_COUNT": null,
"MAX_CLUSTER_COUNT": null,
"QUERIES_1_10_SEC": 50,
"QUERIES_10_20_SEC": 20,
"QUERIES_20_60_SEC": 10,
"QUERIES_1_3_MIN": 5,
"QUERIES_3_5_MIN": 2,
"QUERIES_5_PLUS_MIN": 1,
"QUEUED_1_2_MIN": 3,
"QUEUED_2_5_MIN": 1,
"QUEUED_5_10_MIN": 0,
"QUEUED_10_20_MIN": 0,
"QUEUED_20_PLUS_MIN": 0,
"QUERIES_SPILLED_LOCAL": 2,
"QUERIES_SPILLED_REMOTE": 1,
"TOTAL_BYTES_SPILLED_LOCAL": 1048576,
"TOTAL_BYTES_SPILLED_REMOTE": 524288,
"FAILED_QUERIES": 5,
"SUCCESSFUL_QUERIES": 80,
"RUNNING_QUERIES": 3,
"QUERIES_0_20_CENTS": 40,
"QUERIES_20_40_CENTS": 20,
"QUERIES_40_60_CENTS": 10,
"QUERIES_60_80_CENTS": 5,
"QUERIES_80_100_CENTS": 3,
"QUERIES_100_PLUS_CENTS": 2,
"QUERY_IDS": {
"1-10_sec_ids": ["01b12345-0000-0000-0001-abc123456789", "01b12345-0000-0000-0001-pqr123456789"],
"10-20_sec_ids": ["01b12345-0000-0000-0002-def123456789"],
"20-60_sec_ids": [],
"1-3_min_ids": [],
"3-5_min_ids": [],
"5_plus_min_ids": [],
"queued_1-2_min_ids": ["01b12345-0000-0000-0003-ghi123456789"],
"queued_2-5_min_ids": [],
"queued_5-10_min_ids": [],
"queued_10-20_min_ids": [],
"queued_20_plus_min_ids": [],
"spilled_local_ids": ["01b12345-0000-0000-0004-jkl123456789"],
"spilled_remote_ids": [],
"failed_queries_ids": ["01b12345-0000-0000-0005-mno123456789"],
"successful_queries_ids": ["01b12345-0000-0000-0001-abc123456789", "01b12345-0000-0000-0002-def123456789"],
"credit_0-20_cents_ids": ["01b12345-0000-0000-0001-abc123456789"],
"credit_20-40_cents_ids": [],
"credit_40-60_cents_ids": ["01b12345-0000-0000-0002-def123456789"],
"credit_60-80_cents_ids": [],
"credit_80-100_cents_ids": [],
"credit_100_plus_cents_ids": []
},
"TOTAL_QUERIES": 88,
"TOTAL_CREDITS_USED": 25.5,
"TOTAL_COMPUTE_CREDITS": 20.0,
"TOTAL_CLOUD_SERVICES_CREDITS": 5.5,
"ANALYSIS_TIMESTAMP": "2025-08-08T05:07:00Z",
"ANALYSIS_DATE": "2025-08-07"
},
"user_query_performance_report": {
"user_name": "john.doe",
"total_queries": 100,
"warehouses_used": 2,
"databases_accessed": 3,
"total_credits": 30.5,
"avg_execution_time_ms": 15000,
"avg_bytes_per_row": 104857.6,
"total_data_scanned_gb": 10.5,
"failure_cancellation_rate_pct": 5.0,
"spilled_queries": 3,
"over_provisioned_queries": 2,
"peak_hour_long_running_queries": 1,
"select_star_queries": 5,
"unpartitioned_scan_queries": 2,
"repeated_queries": 10,
"complex_join_queries": 4,
"zero_result_queries": 3,
"high_compile_queries": 2,
"untagged_queries": 15,
"unlimited_order_by_queries": 1,
"large_group_by_queries": 2,
"slow_queries": 5,
"expensive_distinct_queries": 1,
"inefficient_like_queries": 2,
"no_results_with_scan_queries": 3,
"cartesian_join_queries": 0,
"high_compile_ratio_queries": 2,
"weighted_score": 45.5,
"cost_status": "Normal",
"recommendations": [
"Optimize memory usage or increase warehouse size.",
"Specify columns instead of SELECT *."
],
"query_samples": {
"spilled": [
{
"query_id": "01b12345-0000-0000-0004-jkl123456789",
"query_text": "SELECT * FROM large_table JOIN huge_table",
"execution_time_ms": 300000,
"bytes_scanned": 1073741824,
"bytes_spilled_to_local_storage": 1048576,
"bytes_spilled_to_remote_storage": 0,
"warehouse_size": "LARGE",
"start_time": "2025-08-07T10:00:00Z"
}
],
"slow_query": [
{
"query_id": "01b12345-0000-0000-0001-abc123456789",
"query_text": "SELECT * FROM sales WHERE date = '2025-08-07' ORDER BY revenue DESC",
"execution_time_ms": 15000,
"bytes_scanned": 104857600,
"warehouse_size": "MEDIUM",
"start_time": "2025-08-07T10:00:00Z"
}
],
"over_provisioned": [],
"peak_hour_long_running": [],
"select_star": [
{
"query_id": "01b12345-0000-0000-0001-abc123456789",
"query_text": "SELECT * FROM sales WHERE date = '2025-08-07' ORDER BY revenue DESC",
"execution_time_ms": 15000,
"bytes_scanned": 104857600,
"warehouse_size": "MEDIUM",
"start_time": "2025-08-07T10:00:00Z"
}
],
"unpartitioned_scan": [],
"failed_cancelled": [],
"zero_result_query": [],
"high_compile_time": [],
"untagged_query": [],
"unlimited_order_by": [],
"large_group_by": [],
"expensive_distinct": [],
"inefficient_like": [],
"no_results_with_scan": [],
"cartesian_join": [],
"high_compile_ratio": []
}
}
}
Armaan Khan
Posted on
sampel data
For further actions, you may consider blocking this person and/or reporting abuse
Top comments (0)