Redshift Observatory

System Table Tracker

System view pg_catalog.stl_unload_history_base version 1.0.70890 / 2024-07-14

schema name column data type
pg_catalog stl_unload_history_base child_query_id int4
pg_catalog stl_unload_history_base child_query_sequence int4
pg_catalog stl_unload_history_base compression_type char(64)
pg_catalog stl_unload_history_base db char(64)
pg_catalog stl_unload_history_base error_message char(128)
pg_catalog stl_unload_history_base event_time timestamp
pg_catalog stl_unload_history_base file_format char(32)
pg_catalog stl_unload_history_base files_count_produced int4
pg_catalog stl_unload_history_base files_size_produced int8
pg_catalog stl_unload_history_base pid int4
pg_catalog stl_unload_history_base query_id int8
pg_catalog stl_unload_history_base rows_produced int8
pg_catalog stl_unload_history_base slice int4
pg_catalog stl_unload_history_base status int4
pg_catalog stl_unload_history_base unloaded_location char(256)
pg_catalog stl_unload_history_base user_id int4
pg_catalog stl_unload_history_base xid int8

View Text

SELECT stll_unload_history_base.user_id,
       stll_unload_history_base.db,
       stll_unload_history_base.xid,
       stll_unload_history_base.pid,
       stll_unload_history_base.query_id,
       stll_unload_history_base.child_query_sequence,
       stll_unload_history_base.child_query_id,
       stll_unload_history_base.status,
       stll_unload_history_base.event_time,
       stll_unload_history_base.slice,
       stll_unload_history_base.files_count_produced,
       stll_unload_history_base.files_size_produced,
       stll_unload_history_base.rows_produced,
       stll_unload_history_base.file_format,
       stll_unload_history_base.compression_type,
       stll_unload_history_base.unloaded_location,
       stll_unload_history_base.error_message
FROM stll_unload_history_base


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