Skip to content

Duplicate query_id in redshift_query_attribution_vw #2

@hienlt21293

Description

@hienlt21293

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:

SELECT query_id, COUNT(*)
FROM redshift_query_attribution_vw 
GROUP BY query_id
HAVING COUNT(*) > 1;

Results
image


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;
image

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?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions