databendlabs/databend

Feature: allow user to query on spilled storage size on system.query_log table

Open

#15,269 opened on Apr 18, 2024

View on GitHub
 (4 comments) (0 reactions) (0 assignees)Rust (880 forks)github user discovery
C-featuregood first issue

Repository metrics

Stars
 (9,314 stars)
PR merge metrics
 (Avg merge 4d 18h) (99 merged PRs in 30d)

Description

Summary

Description for this feature. Consider to add two fields bytes_spilled_to_local_storage and bytes_spilled_to_remote_storage to system.query_log table allow user to checkout the number of bytes spilled to local storage and remote storage could help them troubleshooting their query performance issue when query consume too much time.

Ref: https://docs.snowflake.com/en/user-guide/performance-query-warehouse-memory

Contributor guide

Research direction
Examine the system.query log table schema and identify where to add the spilled storage fields. Look for existing spill tracking variables in the query execution pipeline.
Tech stack
rust
Domain
database
Issue type
Feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
Half day
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Active
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Mostly clear
Prerequisites
RustSQL
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
60