Redshift Observatory

System Table Tracker

System view pg_catalog.stl_federated_query_redacted version 1.0.77028 / 2024-10-24

schema	name	column	data type
pg_catalog	stl_federated_query_redacted	database	char(30)
pg_catalog	stl_federated_query_redacted	duration	int8
pg_catalog	stl_federated_query_redacted	node	int4
pg_catalog	stl_federated_query_redacted	num_bytes	int8
pg_catalog	stl_federated_query_redacted	num_rows	int8
pg_catalog	stl_federated_query_redacted	pid	int4
pg_catalog	stl_federated_query_redacted	query	int4
pg_catalog	stl_federated_query_redacted	querytext_redacted	char(4000)
pg_catalog	stl_federated_query_redacted	recordtime	timestamp
pg_catalog	stl_federated_query_redacted	segment	int4
pg_catalog	stl_federated_query_redacted	slice	int4
pg_catalog	stl_federated_query_redacted	sourcetype	char(30)
pg_catalog	stl_federated_query_redacted	userid	int4
pg_catalog	stl_federated_query_redacted	xid	int8

View Text

SELECT stll_federated_query_redacted.userid,
       stll_federated_query_redacted.xid,
       stll_federated_query_redacted.pid,
       stll_federated_query_redacted.query,
       stll_federated_query_redacted.sourcetype,
       stll_federated_query_redacted.database,
       stll_federated_query_redacted.segment,
       stll_federated_query_redacted.node,
       stll_federated_query_redacted.slice,
       stll_federated_query_redacted.recordtime,
       stll_federated_query_redacted.querytext_redacted,
       stll_federated_query_redacted.num_rows,
       stll_federated_query_redacted.num_bytes,
       stll_federated_query_redacted.duration
FROM stll_federated_query_redacted

Home 3D Друк Blog Bring-Up Times Consultancy Cross-Region Benchmarks Email Forums IRC Mailing Lists Reddit Redshift Price Tracker Redshift Version Tracker Redshift Workbench System Table Tracker The Known Universe Twitter White Papers