optimizing-query-by-id

What problem does it solve?

It eliminates slow, resource-heavy Snowflake queries by turning a query_id into actionable performance diagnostics and an optimized rewritten SQL.

Core Features & Use Cases

• Fetch & analyze query performance from query_id: Retrieves query text and key metrics like execution time, bytes scanned, spillage, and partition pruning.
• Inspect operator-level bottlenecks: Uses query operator statistics to spot row explosions, heavy scans, and spillage-causing operators.
• Rewrite and verify improvements: Produces an optimized query, validates via EXPLAIN, and summarizes expected gains against performance thresholds.

Use Case: You have a previously executed Snowflake query that is slow; provide its query_id and receive an optimized SQL rewrite with before/after plan comparison guidance.

Quick Start

Provide the Snowflake query_id to analyze and rewrite, then ask the assistant to return the optimized SQL plus a concise summary of expected performance improvements.