Redshift Observatory

System Table Tracker

System view pg_catalog.stl_federated_query version 1.0.69451 / 2024-06-27

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

View Text

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

Home 3D Друк Blog Bring-Up Times Cross-Region Benchmarks Email Forums Mailing Lists Redshift Price Tracker Redshift Version Tracker Replacement System Tables Reserved Instances Marketplace Slack System Table Tracker The Known Universe White Papers