Redshift Observatory

System Table Tracker

System view pg_catalog.svl_internal_query_result_cache_miss_reason version 1.0.58558 / 2023-10-25

View Text

SELECT stl_internal_query_details.query,
       stl_internal_query_details.xid,
       stl_internal_query_details.result_cache_miss_reason,
       CASE
         WHEN stl_internal_query_details.result_cache_miss_reason = -1
           THEN CAST('No result cache miss event.' AS text)
         WHEN stl_internal_query_details.result_cache_miss_reason = 0
           THEN CAST('Not eligible because commit level is XEN_COMMIT_DISK.' AS text)
         WHEN stl_internal_query_details.result_cache_miss_reason = 1
           THEN CAST('Not eligible because a temp table is queried and commit level is XEN_COMMIT_IN_MEMORY.' AS text)
         WHEN stl_internal_query_details.result_cache_miss_reason = 2
           THEN CAST('Not eligible because protocol version is lower than 3.' AS text)
         WHEN stl_internal_query_details.result_cache_miss_reason = 3
           THEN CAST('Not eligible because system table is queried.' AS text)
         WHEN stl_internal_query_details.result_cache_miss_reason = 4
           THEN CAST('Not eligible because PG executor is used.' AS text)
         WHEN stl_internal_query_details.result_cache_miss_reason = 5
           THEN CAST('Not eligible because non immutable function is used.' AS text)
         WHEN stl_internal_query_details.result_cache_miss_reason = 6
           THEN CAST('Not eligible because external table is queried.' AS text)
         WHEN stl_internal_query_details.result_cache_miss_reason = 7
           THEN CAST('Not eligible because python UDF is used.' AS text)
         WHEN stl_internal_query_details.result_cache_miss_reason = 8
           THEN CAST('Not eligible because external function is used.' AS text)
         WHEN stl_internal_query_details.result_cache_miss_reason = 9
           THEN CAST('Not hit because cache entry is after current transaction.' AS text)
         WHEN stl_internal_query_details.result_cache_miss_reason = 10
           THEN CAST('Not hit because cursor limit is reached.' AS text)
         WHEN stl_internal_query_details.result_cache_miss_reason = 11
           THEN CAST('Not hit because parse/plan targetlist is different.' AS text)
         WHEN stl_internal_query_details.result_cache_miss_reason = 12
           THEN CAST('Not hit because permission check failed.' AS text)
         WHEN stl_internal_query_details.result_cache_miss_reason = 13
           THEN CAST('Not hit because parameters are different.' AS text)
         WHEN stl_internal_query_details.result_cache_miss_reason = 14
           THEN CAST('Not populate because parse/plan targetlist is different.' AS text)
         WHEN stl_internal_query_details.result_cache_miss_reason = 15
           THEN CAST('Not populate because there is concurrent modification to tables.' AS text)
         WHEN stl_internal_query_details.result_cache_miss_reason = 16
           THEN CAST('Not populate because there is concurrent population of the same signature.' AS text)
         WHEN stl_internal_query_details.result_cache_miss_reason = 17
           THEN CAST('Not populate because entry exceeds the single-entry limit.' AS text)
         WHEN stl_internal_query_details.result_cache_miss_reason = 23
           THEN CAST('Not populate because local key id is smaller than key id in cache map.' AS text)
         ELSE CAST('Untracked result cache event.' AS text)
       END AS result_cache_miss_reason_txt
FROM stl_internal_query_details

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