Redshift Observatory

System Table Tracker

System view pg_catalog.svcs_scan version 1.0.67699 / 2024-05-26

schema name column data type
pg_catalog svcs_scan bytes int8
pg_catalog svcs_scan checksum int8
pg_catalog svcs_scan consumed_scan_ranges int8
pg_catalog svcs_scan endtime timestamp
pg_catalog svcs_scan fetches int8
pg_catalog svcs_scan is_delayed_scan char(1)
pg_catalog svcs_scan is_rlf_scan char(1)
pg_catalog svcs_scan is_rlf_scan_reason int4
pg_catalog svcs_scan is_rrscan char(1)
pg_catalog svcs_scan is_vectorized_scan char(1)
pg_catalog svcs_scan is_vectorized_scan_reason int4
pg_catalog svcs_scan num_em_blocks int4
pg_catalog svcs_scan perm_table_name char(136)
pg_catalog svcs_scan query int4
pg_catalog svcs_scan row_fetcher_state int4
pg_catalog svcs_scan rows int8
pg_catalog svcs_scan rows_pre_filter int8
pg_catalog svcs_scan rows_pre_user_filter int8
pg_catalog svcs_scan segment int4
pg_catalog svcs_scan slice int4
pg_catalog svcs_scan starttime timestamp
pg_catalog svcs_scan step int4
pg_catalog svcs_scan tasknum int4
pg_catalog svcs_scan tbl int4
pg_catalog svcs_scan type int4
pg_catalog svcs_scan userid int4

View Text

SELECT stcs.userid,
       map.primary_query AS query,
       stcs.slice,
       stcs.segment,
       stcs.step,
       CAST('1970-01-01 00:00:00' AS timestamp) + (CAST((CAST(stcs.starttime AS numeric) / (1000.0 * 1000.0)) + 946684800.0 AS double precision) * CAST('00:00:01' AS interval)) AS starttime,
       CAST('1970-01-01 00:00:00' AS timestamp) + (CAST((CAST(stcs.endtime AS numeric) / (1000.0 * 1000.0)) + 946684800.0 AS double precision) * CAST('00:00:01' AS interval)) AS endtime,
       stcs.tasknum,
       stcs.rows,
       stcs.bytes,
       stcs.fetches,
       stcs.type,
       stcs.tbl,
       stcs.is_rrscan,
       stcs.is_delayed_scan,
       stcs.rows_pre_filter,
       stcs.rows_pre_user_filter,
       stcs.perm_table_name,
       stcs.is_rlf_scan,
       stcs.is_rlf_scan_reason,
       stcs.num_em_blocks,
       stcs.checksum,
       stcs.row_fetcher_state,
       stcs.consumed_scan_ranges,
       stcs.is_vectorized_scan,
       stcs.is_vectorized_scan_reason
FROM stcs_scan AS stcs
     INNER JOIN stcs_concurrency_scaling_query_mapping AS map ON map.concurrency_scaling_query = stcs.query
WHERE stcs.__cluster_type = CAST('cs' AS bpchar)
  AND to_date(CAST(stcs.__log_generated_date AS text),
              CAST('YYYYMMDD' AS text)) > (getdate() - CAST('7 days' AS interval))
  AND to_date(CAST(map.__log_generated_date AS text),
              CAST('YYYYMMDD' AS text)) > (getdate() - CAST('7 days' AS interval))
  AND CAST(map.concurrency_scaling_cluster AS text) = split_part(CAST(stcs.__path AS text),
                                                                 CAST('/' AS text),
                                                                 10)


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