postgresql中隐秘的sql

在postgresql中有许多好玩的sql,作用非常大，下面列出几条：

--看看目前的情况：
select * from pg_stat_activity;

--搜索杂项功能：
select * from pg_proc WHERE proname ~* '^pg_.*'

--查找数据库大小：
select pg_database_size('postgres');
select pg_size_pretty(pg_database_size('postgres'));

--查找所有数据库的大小：
select datname, pg_size_pretty(pg_database_size(datname)) as size  from pg_database;

--查找表和索引的大小：
select pg_size_pretty(pg_relation_size('public.test'));

--或者，列出所有表和索引(可能更容易看出这一点)：
select schemaname, relname,
    pg_size_pretty(pg_relation_size(schemaname || '.' || relname)) as size
  from (select schemaname, relname, 'table' as type
          from pg_stat_user_tables
        union all
        select schemaname, relname, 'index' as type
          from pg_stat_user_indexes) x;