Redshift Observatory

System Table Tracker

System view pg_catalog.svl_compile version 1.0.47470 / 2023-03-11

schema	name	column	data type
pg_catalog	svl_compile	compile	int4
pg_catalog	svl_compile	endtime	timestamp
pg_catalog	svl_compile	locus	int4
pg_catalog	svl_compile	pid	int4
pg_catalog	svl_compile	query	int4
pg_catalog	svl_compile	segment	int4
pg_catalog	svl_compile	starttime	timestamp
pg_catalog	svl_compile	userid	int4
pg_catalog	svl_compile	xid	int8

View Text

SELECT stl_compile_info.userid,
       stl_compile_info.xid,
       stl_compile_info.pid,
       stl_compile_info.query,
       stl_compile_info.segment,
       stl_compile_info.locus,
       stl_compile_info.starttime,
       stl_compile_info.endtime,
       stl_compile_info.compile
FROM stl_compile_info

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