sumodirjo/postgresql-queries.md

## postgresql-queries.md

      
    Raw
  

              postgresql-queries.md
            
          
    Show tables using pg_catalog schema
SELECT
   *
FROM
   pg_catalog.pg_tables
WHERE
   schemaname != 'pg_catalog'
AND schemaname != 'information_schema';

SELECT schemaname, relid, relname, n_live_tup, n_dead_tup, 
	trunc(100*n_dead_tup/(n_live_tup+1))::float "ratio%", 
	to_char(last_autovacuum, 'YYYY-MM-DD HH24:MI:SS') as autovacuum_date, 
	to_char(last_autoanalyze, 'YYYY-MM-DD HH24:MI:SS') as autoanalyze_date 
FROM pg_stat_all_tables WHERE relname !~ '^pg_'
ORDER BY n_dead_tup desc;

view all pgstat
\dv pg_stat*    

\d pg_stat_all_tables 

select * from pg_stat_all_tables where relname='test1';