All Queries
This page provides a searchable, filterable view of all queries executed on your Snowflake account. This enables data engineers to understand overall query volume, execution patterns and identify the most expensive or slowest queries.
Executed Queries
Query Statistics
The top section displays key metrics about your queries:
- Total Queries - Total number of executed queries
- Success - Number of successfully executed queries
- Failed - Number of queries that encountered errors
Filters and Search
Date Range Filter
Filter queries by time period:
- All - Shows all queries regardless of date (default)
- Last 24 hours - Shows queries executed in the past 24 hours
- Last 7 days - Shows queries executed in the past week
- Last 30 days - Shows queries executed in the past month
- Custom range - Select specific start and end dates for filtering
Status Filter
Filter queries by execution status:
- All - Shows queries with any status (default)
- Success - Shows only successfully completed queries
- Failed - Shows only queries that encountered errors
Query Type Filter
Filter queries by operation type:
- SELECT* - Queries using SELECT with wildcard (SELECT *)
- WHERE - Queries with WHERE clause filtering
- JOIN - Queries performing table joins
- Aggregation - Queries using aggregate functions (SUM, COUNT, AVG, etc.)
Query ID Search
Search for specific query by entering full query ID. Results update as you type.
Edit Columns
Customize which table columns are visible. Show or hide specific data fields to personalize your view.
Table Columns
| Column | Description | Use Case |
|---|---|---|
| Query ID | Unique identifier for each query | Click to view query details or use copy button to share query reference |
| User Name | Snowflake user who executed the query | Identify query ownership and analyze performance patterns by user |
| Warehouse | Warehouse used to execute the query | Identify compute resources used and optimize warehouse allocation |
| Credits | Number of credits consumed by the query | Track query credit and prioritize optimization for expensive queries |
| Duration | Query execution time in milliseconds | Identify slow queries and measure optimization impact |
Table Features
Sorting
Click column headers to sort queries in ascending or descending order. Sorting is available for:
- User Name - Sort alphabetically by user
- Warehouse - Sort alphabetically by warehouse name
- Credits - Sort by credit consumption (low to high or high to low)
- Duration - Sort by execution time (shortest to longest or longest to shortest)
Additional Features
- Clickable Query IDs - Click any query ID to view full query details and analysis
- Copy Query ID - Single click to copy query ID to clipboard
Available Actions
The Actions column displays a three-dot menu icon (⋮) for each query, providing quick access to query operations.
Query Details
Opens the detailed query information page showing complete query text, execution plan, and performance metrics.
Analyze
Opens the Query Analyzer tool with the selected query pre-loaded to evaluate execution patterns, resource usage, and identify performance inefficiencies.
Optimize
Opens the Query Optimizer tool with the selected query pre-loaded to receive AI-powered optimization suggestions and query restructuring recommendations.
Query Details
The Query Details page provides a complete breakdown of a selected query, including performance metrics, warehouse usage, resource consumption, and executed SQL text. This helps you understand execution behavior, identify performance issues, and analyze resource usage.
Key Metrics
The top section displays core execution statistics:
| Metric | Description |
|---|---|
| Duration | Total time taken to execute the query |
| Credits | Number of Snowflake credits consumed by the query |
| Bytes Scanned | Amount of data scanned during execution |
| Bytes Written | Data written as part of the query output |
Execution Information
| Field | Description |
|---|---|
| Warehouse | The warehouse used to execute the query |
| Start Time | The timestamp when execution began |
| End Time | The timestamp when execution completed |
| Query Tag | Custom tag applied to the query (if available) |
Executed Query
Displays the full SQL text executed by the user.
Use the copy icon to copy the entire query to clipboard for sharing or further analysis.
Next Steps
Click Analyze to open the Query Analyzer with the executed query preloaded.
Use Analyzer to review execution plan, understand performance characteristics, and identify optimization opportunities.