Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Return how long each statement takes inside a stored procedure or a UDF as part of EXPLAIN ANALYZE. #124169

Open
dikshant opened this issue May 14, 2024 · 0 comments
Open

Return how long each statement takes inside a stored procedure or a UDF as part of EXPLAIN ANALYZE. #124169

dikshant opened this issue May 14, 2024 · 0 comments
Labels
A-sql-udf C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) T-sql-queries SQL Queries Team

Comments

@dikshant
Copy link

dikshant commented May 14, 2024 •
edited

Right now we return an aggregate latency on how long a UDF/Stored Procedure takes to execute. We should improve explain analyze to show how long each statement inside a stored procedure/UDF takes to execute. This would make debugging slow UDFs/Stored Procedures easier and help narrow down the slow statement.

Jira issue: CRDB-38741
@dikshant dikshant added C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) T-sql-queries SQL Queries Team A-sql-udf labels May 14, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
A-sql-udf C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) T-sql-queries SQL Queries Team
Projects
SQL Queries
Status: 24.2 Release
Milestone
No milestone
Development

No branches or pull requests
1 participant
@dikshant