Redshift Observatory

System Table Tracker

System view pg_catalog.stl_truncate_history version 1.0.52931 / 2023-07-07

schema name column data type
pg_catalog stl_truncate_history is_extended_protocol int4
pg_catalog stl_truncate_history is_safe int4
pg_catalog stl_truncate_history is_temp int4
pg_catalog stl_truncate_history is_user int4
pg_catalog stl_truncate_history logtime timestamp
pg_catalog stl_truncate_history query_text char(256)
pg_catalog stl_truncate_history table_id int4
pg_catalog stl_truncate_history table_name char(128)
pg_catalog stl_truncate_history xid int8

View Text

SELECT stll_truncate_history.logtime,
       stll_truncate_history.xid,
       stll_truncate_history.table_id,
       stll_truncate_history.table_name,
       stll_truncate_history.is_temp,
       stll_truncate_history.is_safe,
       stll_truncate_history.is_extended_protocol,
       stll_truncate_history.is_user,
       stll_truncate_history.query_text
FROM stll_truncate_history


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