Redshift Observatory

System Table Tracker

System view pg_catalog.svl_qlog version 1.0.43551 / 2022-11-08

schema name column data type
pg_catalog svl_qlog aborted int4
pg_catalog svl_qlog concurrency_scaling_status_txt text
pg_catalog svl_qlog elapsed int8
pg_catalog svl_qlog endtime timestamp
pg_catalog svl_qlog from_sp_call int4
pg_catalog svl_qlog label char(320)
pg_catalog svl_qlog pid int4
pg_catalog svl_qlog query int4
pg_catalog svl_qlog source_query int4
pg_catalog svl_qlog starttime timestamp
pg_catalog svl_qlog substring text
pg_catalog svl_qlog userid int4
pg_catalog svl_qlog xid int8

View Text

SELECT sq.userid,
       sq.query,
       sq.xid,
       sq.pid,
       sq.starttime,
       sq.endtime,
       date_diff(CAST('microseconds' AS text),
                 sq.starttime,
                 sq.endtime) AS elapsed,
       sq.aborted,
       sq.label,
       substring(CAST(sq.querytxt AS text),
                 1,
                 60) AS substring,
       sr.source_query,
       CASE
         WHEN sq.concurrency_scaling_status = 1
           THEN CAST('1 - Ran on a Concurrency Scaling cluster' AS text)
         ELSE CAST('0 - Ran on the main cluster' AS text)
       END AS concurrency_scaling_status_txt,
       ss.from_sp_call
FROM stl_query AS sq
     LEFT JOIN stl_result_cache_history AS sr ON sq.query = sr.cache_hit_query
     LEFT JOIN stl_wlm_query AS sw ON sq.query = sw.query
                                  AND sq.userid = sw.userid
                                  AND sq.xid = sw.xid
     LEFT JOIN stl_stored_proc_call_map AS ss ON sq.query = ss.query


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