Technologies/Redis/snowflake_count_elapsed_time_avg
RedisRedisMetric

snowflake_count_elapsed_time_avg

Total wall-clock time from submission to result
Dimensions:None

Technical Annotations (37)

Configuration Parameters (4)
STATEMENT_TIMEOUT_IN_SECONDSrecommended: 3600
Sets maximum query execution time; increase for long operations
WAREHOUSE_SIZErecommended: LARGE
Scale up for resource-intensive queries
AUTO_SUSPENDrecommended: 60
Optimal timeout to avoid repeated 60-second minimum charges while preventing warehouse sprawl
STATEMENT_QUEUED_TIMEOUT_IN_SECONDSrecommended: varies by workload
Maximum time query can remain queued before cancellation
Error Signatures (3)
100038error code
Query Execution Timeoutlog pattern
version mismatch errorserror code
CLI Commands (8)
ALTER SESSION SET STATEMENT_TIMEOUT_IN_SECONDS = 3600;remediation
ALTER WAREHOUSE my_warehouse SET WAREHOUSE_SIZE = 'LARGE';remediation
SELECT warehouse_name, user_name, COUNT(query_id) AS query_count, MEDIAN(execution_seconds) AS median_execution_seconds FROM (SELECT warehouse_name, user_name, query_id, execution_time / 1000 AS execution_seconds FROM snowflake.account_usage.query_history WHERE start_time >= DATEADD('day', -30, CURRENT_TIMESTAMP()) AND warehouse_name IS NOT NULL AND execution_status = 'SUCCESS') GROUP BY warehouse_name, user_name ORDER BY query_count DESCdiagnostic
ALTER WAREHOUSE LOAD_WH SET STATEMENT_TIMEOUT_IN_SECONDS= 3600;remediation
SHOW PARAMETERS IN WAREHOUSE LOAD_WH;diagnostic
SELECT query_id, query_text, execution_time, total_elapsed_time, bytes_scanned FROM snowflake.account_usage.query_history WHERE start_time > DATEADD(day, -7, CURRENT_DATE()) ORDER BY execution_time DESC;diagnostic
EXPLAIN SELECT * FROM my_table WHERE column1 = 'value1';diagnostic
select system$clustering_information('table_name','(column_name)')diagnostic
Technical References (22)
Query ProfilecomponentQUERY_HISTORY viewcomponentmicro-partitioningconceptclustering keysconceptvirtual warehousecomponentcredit consumptionconceptBI dashboardconceptrefresh frequencyconceptquery_historycomponentaccount_usagecomponentfrozen clustercomponentsnowflake.account_usage.query_historycomponentEXPLAINcommandSYSTEM$CLUSTERING_INFORMATIONcomponentaverage_depthconceptaverage_overlapsconceptmicro-partitionsconceptCartesian joinconceptpartition hotspotsconceptQUERY_HISTORYcomponentRELATIVE_PERFORMANCE_COSTconceptWAREHOUSE_SIZEcomponent
Related Insights (15)
Query execution timeout exceeds statement limitwarning
▸
Query performance degradation without profiling analysiswarning
▸
Operations take extended time to complete during version mismatchwarning
▸
Poor query optimization degrades performance despite auto-partitioningwarning
▸
Unoptimized joins and missing pruning increase compute costswarning
▸
Poor data organization post-migration degrades query performancewarning
▸
60-second minimum charge inflates costs for short querieswarning
▸
High-frequency dashboard refreshes accumulate disproportionate compute costswarning
▸
Query history analysis enables cost-effective workload routinginfo
▸
Missing statement timeout parameters allow runaway querieswarning
▸
Slow-running queries degrading Snowflake performancewarning
▸
Poor clustering depth and overlap degrade query performancewarning
▸
Skewed joins and Cartesian products spike warehouse runtimewarning
▸
Unoptimized queries drive unpredictable Snowflake credit consumptionwarning
▸
Expensive queries consuming excessive credits relative to warehouse sizewarning
▸