amazon-redshift-utils icon indicating copy to clipboard operation
amazon-redshift-utils copied to clipboard

Published 20 hours ago • verified publisher icon awslabs

min_block_sec and max_block_sec aggregate different measures

Open mike-weinberg opened this issue 4 years ago • 1 comments

https://github.com/awslabs/amazon-redshift-utils/blob/bfe6b021e3c292723f52e4c7f81c5278e37737c4/src/AdminViews/v_get_blocking_locks.sql#L64

Is this really correct? Why use transaction time for one and waiting time for the other? annotations on this view would be great, because I don't understand it well enough to know if it is correct.

mike-weinberg avatar Aug 16 '20 00:08 mike-weinberg

looking at this, it's not referenced anywhere, so maybe it is just very old copypasta

mike-weinberg avatar Aug 17 '20 21:08 mike-weinberg