论坛 › postgresql › postgresql常用查询

admin 发表于 2020-4-26 14:30:20

postgresql常用查询

admin 发表于 2020-4-26 14:31:45

select version();

admin 发表于 2020-4-26 14:35:05

SELECT
    datname ,
    a.rolname ,
    pg_encoding_to_char(encoding) ,
    datcollate ,
    datctype ,
    pg_size_pretty(pg_database_size(datname))
FROM
    pg_database d ,
    pg_authid a
WHERE
    d.datdba = a.oid
    AND datname NOT IN ('template0' ,'template1' ,'postgres' )
ORDER BY
    pg_database_size(datname) DESC;

admin 发表于 2020-4-26 14:37:48

SELECT
      s.setting "可用连接数"       ,
      a.used_session "已使用连接数" ,
      s.setting::bigint - a.used_session "剩余连接数"
FROM
      pg_settings s,
      (
                SELECT
                        COUNT(*) AS used_session
                FROM
                        pg_stat_activity) a
WHERE
      s.name='max_connections';

admin 发表于 2020-4-26 14:44:09

select current_timestamp-pg_postmaster_start_time() as uptime;

admin 发表于 2020-4-26 18:55:38

select name,setting,unitfrom pg_settings;

admin 发表于 2020-4-26 18:59:01

admin 发表于 2020-4-26 18:55


select current_database();

查看完整版本: postgresql常用查询