Redshift Observatory

System Table Tracker

System view pg_catalog.stl_serial_safety_net version 1.0.41465 / 2022-09-10

schema name column data type
pg_catalog stl_serial_safety_net cstamp timestamp
pg_catalog stl_serial_safety_net endtime timestamp
pg_catalog stl_serial_safety_net is_commit int4
pg_catalog stl_serial_safety_net max_snapshot_time timestamp
pg_catalog stl_serial_safety_net ro_pstamp timestamp
pg_catalog stl_serial_safety_net ro_pstamp_oid int4
pg_catalog stl_serial_safety_net ro_pstamp_xid int8
pg_catalog stl_serial_safety_net ssn_serializer int4
pg_catalog stl_serial_safety_net sstamp timestamp
pg_catalog stl_serial_safety_net sstamp_oid int4
pg_catalog stl_serial_safety_net sstamp_xid int8
pg_catalog stl_serial_safety_net starttime timestamp
pg_catalog stl_serial_safety_net write_pstamp timestamp
pg_catalog stl_serial_safety_net write_pstamp_oid int4
pg_catalog stl_serial_safety_net write_pstamp_updated_by_read int4
pg_catalog stl_serial_safety_net write_pstamp_xid int8
pg_catalog stl_serial_safety_net xid int8

View Text

SELECT stll_serial_safety_net.xid,
       stll_serial_safety_net.starttime,
       stll_serial_safety_net.endtime,
       stll_serial_safety_net.write_pstamp,
       stll_serial_safety_net.sstamp,
       stll_serial_safety_net.is_commit,
       stll_serial_safety_net.ssn_serializer,
       stll_serial_safety_net.cstamp,
       stll_serial_safety_net.write_pstamp_oid,
       stll_serial_safety_net.write_pstamp_updated_by_read,
       stll_serial_safety_net.sstamp_oid,
       stll_serial_safety_net.write_pstamp_xid,
       stll_serial_safety_net.sstamp_xid,
       stll_serial_safety_net.ro_pstamp,
       stll_serial_safety_net.max_snapshot_time,
       stll_serial_safety_net.ro_pstamp_oid,
       stll_serial_safety_net.ro_pstamp_xid
FROM stll_serial_safety_net


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