liux操作pg数据库

1.登录pg数据库

切换pg用户

su - postgres

用psql登录

psql

或者指定登录

psql -h localhost -p 5432 -U postgres

常用命令：

退出: \q

查看表： \d

切换数据库：\c 数据库

切换表模式：set search_path to test_schema

查询表占用大小：select pg_size_pretty(pg_relation_size('alarm_raw_alarms'))

清理delete删除后的标记碎片：vacuum full tableName

查询pid进程
select pid, state, usename, query, query_start
from pg_stat_activity
where pid in (
    select pid from pg_locks l
                        join pg_class t on l.relation = t.oid
        and t.relkind = 'r'

);
杀pid
SELECT pg_terminate_backend(pid);