Redshift Observatory

System Table Tracker

System view pg_catalog.stl_aggr version 1.0.43720 / 2022-11-13

schema	name	column	data type
pg_catalog	stl_aggr	bytes	int8
pg_catalog	stl_aggr	endtime	timestamp
pg_catalog	stl_aggr	flushable	int4
pg_catalog	stl_aggr	is_diskbased	char(1)
pg_catalog	stl_aggr	maxlength	int4
pg_catalog	stl_aggr	occupied	int4
pg_catalog	stl_aggr	query	int4
pg_catalog	stl_aggr	resizes	int4
pg_catalog	stl_aggr	rows	int8
pg_catalog	stl_aggr	segment	int4
pg_catalog	stl_aggr	slice	int4
pg_catalog	stl_aggr	slots	int4
pg_catalog	stl_aggr	starttime	timestamp
pg_catalog	stl_aggr	step	int4
pg_catalog	stl_aggr	tasknum	int4
pg_catalog	stl_aggr	tbl	int4
pg_catalog	stl_aggr	type	char(6)
pg_catalog	stl_aggr	used_agg_prefetching	char(1)
pg_catalog	stl_aggr	used_mega_block	char(1)
pg_catalog	stl_aggr	userid	int4
pg_catalog	stl_aggr	varagg_opt_bitmap	int8
pg_catalog	stl_aggr	varchar_agg_opt	char(1)
pg_catalog	stl_aggr	workmem	int8

View Text

SELECT stll_aggr.userid,
       stll_aggr.query,
       stll_aggr.slice,
       stll_aggr.segment,
       stll_aggr.step,
       stll_aggr.starttime,
       stll_aggr.endtime,
       stll_aggr.tasknum,
       stll_aggr.rows,
       stll_aggr.bytes,
       stll_aggr.slots,
       stll_aggr.occupied,
       stll_aggr.maxlength,
       stll_aggr.tbl,
       stll_aggr.is_diskbased,
       stll_aggr.workmem,
       stll_aggr.type,
       stll_aggr.resizes,
       stll_aggr.flushable,
       stll_aggr.varchar_agg_opt,
       stll_aggr.varagg_opt_bitmap,
       stll_aggr.used_agg_prefetching,
       stll_aggr.used_mega_block
FROM stll_aggr

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