beli-sk/pgsql_cheat_sheet.rst

## pgsql_cheat_sheet.rst

      
    Raw
  

              pgsql_cheat_sheet.rst
            
          
    Show process list:
SELECT * FROM pg_stat_activity;

Show running processes:
SELECT pid,datname,query_start,state,query
FROM pg_stat_activity WHERE state <> 'idle';

Reload config:
SELECT pg_reload_conf();

List child tables:
SELECT p.relname parent, c.relname child
 FROM pg_inherits
  JOIN pg_class c ON (inhrelid=c.oid)
  JOIN pg_class p ON (inhparent=p.oid)
 ORDER BY parent, child;

List indexes:
SELECT schemaname, tablename, indexname
 FROM pg_indexes
 WHERE schemaname != 'pg_catalog'
 ORDER BY schemaname, tablename, indexname;