Redshift Observatory

System Table Tracker

System view pg_catalog.stl_internal_analyze_query version 1.0.105373 / 2025-01-09

schema	name	column	data type
pg_catalog	stl_internal_analyze_query	analyze_kind	int4
pg_catalog	stl_internal_analyze_query	delta_finished_xids_min	int8
pg_catalog	stl_internal_analyze_query	delta_finished_xids_size	int8
pg_catalog	stl_internal_analyze_query	delta_start_xid	int8
pg_catalog	stl_internal_analyze_query	group_attnums	char(160)
pg_catalog	stl_internal_analyze_query	group_size	int4
pg_catalog	stl_internal_analyze_query	query	int4
pg_catalog	stl_internal_analyze_query	rows_scanned	int8
pg_catalog	stl_internal_analyze_query	table_id	int4
pg_catalog	stl_internal_analyze_query	xid	int8

View Text

SELECT stll_internal_analyze_query.query,
       stll_internal_analyze_query.xid,
       stll_internal_analyze_query.table_id,
       stll_internal_analyze_query.analyze_kind,
       stll_internal_analyze_query.group_size,
       stll_internal_analyze_query.group_attnums,
       stll_internal_analyze_query.rows_scanned,
       stll_internal_analyze_query.delta_start_xid,
       stll_internal_analyze_query.delta_finished_xids_min,
       stll_internal_analyze_query.delta_finished_xids_size
FROM stll_internal_analyze_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 System Table Tracker The Known Universe White Papers