Redshift Observatory

System Table Tracker

System view pg_catalog.stl_analyze version 1.0.54239 / 2023-08-04

schema name column data type
pg_catalog stl_analyze auto_analyze_phase char(100)
pg_catalog stl_analyze database char(30)
pg_catalog stl_analyze endtime timestamp
pg_catalog stl_analyze is_auto char(1)
pg_catalog stl_analyze is_background char(1)
pg_catalog stl_analyze modified_rows float8
pg_catalog stl_analyze num_new_predicate_cols int4
pg_catalog stl_analyze num_predicate_cols int4
pg_catalog stl_analyze prevtime timestamp
pg_catalog stl_analyze rows float8
pg_catalog stl_analyze starttime timestamp
pg_catalog stl_analyze status char(15)
pg_catalog stl_analyze table_id int4
pg_catalog stl_analyze threshold_percent float8
pg_catalog stl_analyze userid int4
pg_catalog stl_analyze xid int8

View Text

SELECT stll_analyze.userid,
       stll_analyze.xid,
       stll_analyze.database,
       stll_analyze.table_id,
       stll_analyze.status,
       stll_analyze.rows,
       stll_analyze.modified_rows,
       stll_analyze.threshold_percent,
       stll_analyze.is_auto,
       stll_analyze.starttime,
       stll_analyze.endtime,
       stll_analyze.prevtime,
       stll_analyze.num_predicate_cols,
       stll_analyze.num_new_predicate_cols,
       stll_analyze.is_background,
       stll_analyze.auto_analyze_phase
FROM stll_analyze


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