Redshift Observatory

System Table Tracker

System view pg_catalog.svl_statementtext version 1.0.71912 / 2024-08-02

View Text

(SELECT stl_ddltext.userid,
        stl_ddltext.xid,
        stl_ddltext.pid,
        stl_ddltext.label,
        stl_ddltext.starttime,
        stl_ddltext.endtime,
        stl_ddltext.sequence,
        CAST(CAST('DDL' AS varchar) AS varchar(10)) AS type,
        CAST(CASE
               WHEN rtrim(CAST(stl_ddltext.text AS text)) = CAST(0 AS text)
                 THEN CAST(stl_ddltext.text AS text)
               ELSE rtrim(CAST(stl_ddltext.text AS text))
             END AS varchar) AS text
 FROM stl_ddltext

 UNION ALL

 SELECT stl_utilitytext.userid,
        stl_utilitytext.xid,
        stl_utilitytext.pid,
        stl_utilitytext.label,
        stl_utilitytext.starttime,
        stl_utilitytext.endtime,
        stl_utilitytext.sequence,
        CAST(CAST('UTILITY' AS varchar) AS varchar(10)) AS type,
        CAST(CASE
               WHEN rtrim(CAST(stl_utilitytext.text AS text)) = CAST(0 AS text)
                 THEN CAST(stl_utilitytext.text AS text)
               ELSE rtrim(CAST(stl_utilitytext.text AS text))
             END AS varchar) AS text
 FROM stl_utilitytext)

UNION ALL

SELECT stl_query.userid,
       stl_query.xid,
       stl_query.pid,
       stl_query.label,
       stl_query.starttime,
       stl_query.endtime,
       stl_querytext.sequence,
       CAST(CAST('QUERY' AS varchar) AS varchar(10)) AS type,
       CAST(CASE
              WHEN rtrim(CAST(stl_querytext.text AS text)) = CAST(0 AS text)
                THEN CAST(stl_querytext.text AS text)
              ELSE rtrim(CAST(stl_querytext.text AS text))
            END AS varchar) AS text
FROM stl_query, stl_querytext
WHERE stl_query.query = stl_querytext.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