Hacker News new | ask | show | jobs
by rockostrich 3285 days ago
I think you can get the "data scanned per query" from Redshift by querying the STL_QUERY_METRICS table.

http://docs.aws.amazon.com/redshift/latest/dg/r_STL_QUERY_ME...

I would be interested in seeing the settings for the table in Redshift. I don't know much about how BigQuery works, but Redshift relies heavily on distribution and sort keys to efficiently query data.

1 comments

I will look into that, thanks