查询postgres各表的大小
如下：select relname as 表名, reltuples as 记录数 from pg_class where relkind = 'r' and relnamespace = (select oid from pg_namespace where nspname='xxxxx') order by 记录数 desc;
基础运维
2022-05-27 AM
查看postgres正在执行的sql｜关闭指定查询进程
如下：SELECT procpid, START, now() - START AS lap, current_query FROM ( SELECT backendid, pg_stat_get_backend_pid (S.backendid) AS procpid, ...
基础运维
2022-05-27 AM
centos 安装postgres
首先安装对应版本的包：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...
基础运维
2018-05-15 AM