How to get schema/database/table names associated with rows in STL_UTILITYTEXT

Is there a table that maps xid/pid to table id/schema name/database name? I found SVV_TRANSACTIONS, but that only has data on currently running transactions/locks and I want something that preferably covers 2-5 days of history like the STL tables.

主题

分析

标签

Amazon Redshift

语言

English

rePost-User-6605802

已提问 1 年前212 查看次数

1 回答

最新
投票最多
评论最多

这些答案有用吗？为正确答案投票，以帮助社区从您的知识中受益。

Hi,

Have you tried STL_TR_CONFLICT? https://docs.aws.amazon.com/redshift/latest/dg/r_STL_TR_CONFLICT.html

Regards,

专家

Ziad

已回答 1 年前

rePost-User-6605802
1 年前
Hi, is it guaranteed that all processes/transactions will be in STL_TR_CONFLICT? I thought that wasn't the case since not all transactions will conflict with others.
Ziad 专家
1 年前
Hi, It contains all the transactions that faced conflicts. Are you looking also for transactions without conflicts?
rePost-User-6605802
1 年前
Yes, is that possible?
Ziad 专家
1 年前
Not that I'm aware of.

How to get schema/database/table names associated with rows in STL_UTILITYTEXT

相关内容