Redshift Observatory

System Table Tracker

System view pg_catalog.svl_qlog version 1.0.41881 / 2022-09-30

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