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

相關內容