You can check the statement execution duration from the Snowflake.account_usage.query_history view by using the required filters
Sample query
select query_id, total_elapsed_time from snowflake.account_usage.query_history;
https://docs.snowflake.com/en/sql-reference/account-usage/query_history