Terug naar Utils
Snowflake · View
expensive_queries
Queries met een uitvoertijd van 60 seconden of langer, inclusief mislukte queries. De drempel van 60 seconden kan worden aangepast door de view opnieuw aan te maken met een andere waarde voor total_elapsed_time.
Bron: SNOWFLAKE.ACCOUNT_USAGE.QUERY_HISTORY · Latentie: ~45min
| Kolom | Beschrijving |
|---|---|
| date | Datum |
| user_name | Gebruiker |
| role_name | Rol |
| warehouse_name | Warehouse |
| query_type | Bijv. SELECT, INSERT |
| execution_status | SUCCESS, FAIL of INCIDENT |
| execution_seconds | Totale uitvoertijd in seconden |
| gb_scanned | Gescande data in GB |
| partitions_scanned | Gescande micropartities |
| partitions_total | Totale beschikbare micropartities |
| credits_used_cloud_services | Cloud services credits voor deze query |
| statement | Volledige querytekst |
Broncode
create_admin_views.sql
create or replace view expensive_queries
comment = 'Queries with execution time >= 60 seconds (source: SNOWFLAKE.ACCOUNT_USAGE)'
as
select start_time::date as date
, user_name
, role_name
, warehouse_name
, query_type
, execution_status
, round(total_elapsed_time / 1000.0, 1) as execution_seconds
, round(bytes_scanned / 1024.0 / 1024 / 1024, 2) as gb_scanned
, partitions_scanned
, partitions_total
, credits_used_cloud_services
, query_text as statement
from snowflake.account_usage.query_history
where total_elapsed_time >= 60000
order by total_elapsed_time desc;