如下:select relname as 表名, reltuples as 记录数 from pg_class where relkind = 'r' and relnamespace = (select oid from pg_namespace where nspname='xxxxx') order by 记录数 desc;
如下:SELECT procpid, START, now() - START AS lap, current_query FROM ( SELECT backendid, pg_stat_get_backend_pid (S.backendid) AS procpid, ...
首先安装对应版本的包:yum install https://download.postgresql.org/pub/repos/yum/13/redhat/rhel-7-x86_64/pgdg-centos10-10-2.noarch.rpm -y yum list | grep postgresql yum install centos-release-scl yum install...