Terug naar Utils
Snowflake · View
spilling_queries
Queries die data naar een externe schijf hebben gespoeld. Remote spill is een teken dat het warehouse te klein is voor de query, of dat de query meer data scant dan noodzakelijk.
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_seconds | Totale uitvoertijd in seconden |
| gb_spilled_local | Data gespoeld naar lokale schijf in GB |
| gb_spilled_remote | Data gespoeld naar externe schijf in GB |
| gb_scanned | Gescande data in GB |
| statement | Volledige querytekst |
Broncode
create_admin_views.sql
create or replace view spilling_queries
comment = 'Queries that spilled to remote disk (source: SNOWFLAKE.ACCOUNT_USAGE)'
as
select start_time::date as date
, user_name
, role_name
, warehouse_name
, query_type
, round(total_elapsed_time / 1000.0, 1) as execution_seconds
, round(bytes_spilled_to_local_storage / 1024.0 / 1024 / 1024, 2) as gb_spilled_local
, round(bytes_spilled_to_remote_storage / 1024.0 / 1024 / 1024, 2) as gb_spilled_remote
, round(bytes_scanned / 1024.0 / 1024 / 1024, 2) as gb_scanned
, query_text as statement
from snowflake.account_usage.query_history
where bytes_spilled_to_remote_storage > 0
order by bytes_spilled_to_remote_storage desc;