Redshift Observatory

System Table Tracker

System view pg_catalog.svl_federated_query version 1.0.45698 / 2023-01-27

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

View Text

SELECT stl_federated_query.userid,
       stl_federated_query.xid,
       stl_federated_query.pid,
       stl_federated_query.query,
       stl_federated_query.sourcetype,
       stl_federated_query.recordtime,
       stl_federated_query.querytext,
       stl_federated_query.num_rows,
       stl_federated_query.num_bytes,
       stl_federated_query.duration
FROM stl_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