We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
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
I applied these views to my cluster, and I notice that there are rows with same query_id in the view redshift_query_attribution_vw
redshift_query_attribution_vw
List of duplicate query_id:
SELECT query_id, COUNT(*) FROM redshift_query_attribution_vw GROUP BY query_id HAVING COUNT(*) > 1;
Results
Check details of a duplicated query_id
SELECT query_id, db_user_id, redshift_query_cost FROM redshift_query_attribution_vw where query_id = 164726352;
Why are there these duplicate values? Does it mean the cost of the query equals the sum of all redshift_query_cost of that query_id in the view?
The text was updated successfully, but these errors were encountered:
No branches or pull requests
I applied these views to my cluster, and I notice that there are rows with same query_id in the view
redshift_query_attribution_vw
List of duplicate query_id:
Results
![image](https://private-user-images.githubusercontent.com/33282493/307250237-2d6a6369-38a1-474a-8c76-2bccb45230e3.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3Mzk1MzgyMDgsIm5iZiI6MTczOTUzNzkwOCwicGF0aCI6Ii8zMzI4MjQ5My8zMDcyNTAyMzctMmQ2YTYzNjktMzhhMS00NzRhLThjNzYtMmJjY2I0NTIzMGUzLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAyMTQlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMjE0VDEyNTgyOFomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTcwZTJkOGEwMzQ1NjczMWEyNzBiMDhkZjgxNGM2MWE4ZjlhNDZkZWZjMzUzMzg0MWI0Y2E3ZmIyNDFkOWM2NGImWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.y0v_PPGBUVfOriVdyzqd2jDVcQuhQJEKAJzmLFo02fQ)
Check details of a duplicated query_id
Why are there these duplicate values?
Does it mean the cost of the query equals the sum of all redshift_query_cost of that query_id in the view?
The text was updated successfully, but these errors were encountered: