Redshift Observatory

System Table Tracker

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

schema name column data type
pg_catalog stl_user_query_history compile_time int8
pg_catalog stl_user_query_history compute_type char(32)
pg_catalog stl_user_query_history database_name char(128)
pg_catalog stl_user_query_history end_time timestamp
pg_catalog stl_user_query_history error_message char(512)
pg_catalog stl_user_query_history execution_time int8
pg_catalog stl_user_query_history internal_query char(1)
pg_catalog stl_user_query_history label char(320)
pg_catalog stl_user_query_history lock_wait_time int8
pg_catalog stl_user_query_history pid int4
pg_catalog stl_user_query_history planning_time int8
pg_catalog stl_user_query_history pure_planning_time int8
pg_catalog stl_user_query_history query_id int8
pg_catalog stl_user_query_history query_text char(4000)
pg_catalog stl_user_query_history query_type char(32)
pg_catalog stl_user_query_history queue_time int8
pg_catalog stl_user_query_history redshift_version char(32)
pg_catalog stl_user_query_history result_cache_source_query int8
pg_catalog stl_user_query_history returned_bytes int8
pg_catalog stl_user_query_history returned_rows int8
pg_catalog stl_user_query_history start_time timestamp
pg_catalog stl_user_query_history status char(10)
pg_catalog stl_user_query_history usage_limit char(150)
pg_catalog stl_user_query_history user_id int4
pg_catalog stl_user_query_history xid int8

View Text

SELECT stll_user_query_history.user_id,
       stll_user_query_history.query_id,
       stll_user_query_history.label,
       stll_user_query_history.xid,
       stll_user_query_history.pid,
       stll_user_query_history.database_name,
       stll_user_query_history.query_type,
       stll_user_query_history.status,
       stll_user_query_history.result_cache_source_query,
       stll_user_query_history.start_time,
       stll_user_query_history.end_time,
       stll_user_query_history.queue_time,
       stll_user_query_history.execution_time,
       stll_user_query_history.error_message,
       stll_user_query_history.returned_rows,
       stll_user_query_history.returned_bytes,
       stll_user_query_history.redshift_version,
       stll_user_query_history.usage_limit,
       stll_user_query_history.internal_query,
       stll_user_query_history.query_text,
       stll_user_query_history.compute_type,
       stll_user_query_history.compile_time,
       stll_user_query_history.planning_time,
       stll_user_query_history.pure_planning_time,
       stll_user_query_history.lock_wait_time
FROM stll_user_query_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