Redshift Observatory

System Table Tracker

System view pg_catalog.stl_federated_query version 1.0.52931 / 2023-07-07

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 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