【openGauss】openGauss快速查text字段长度及大小并排序-pg_column_size函数

---

一、openGauss快速查text字段长度及大小并排序-pg_column_size函数

使用 pg_column_size()这个系统函数会很快

WITH t1 AS
 (SELECT pg_size_pretty(pg_column_size(request_json)::int8) AS s1
        ,pg_column_size(request_json) AS s2
        ,api_log_id
    FROM tzq_api_log_t
   ORDER BY s2 DESC NULLS LAST LIMIT 1000)
SELECT length(request_json) AS l1
      ,pg_size_pretty(pg_column_size(request_json)::int8) AS s1
      ,pg_column_size(request_json) AS s2
      ,api_log_id
  FROM tzq_api_log_t
 WHERE api_log_id IN (SELECT t1.api_log_id FROM t1)
 ORDER BY s2 DESC NULLS LAST;