deeejay

psql - Database IO, Cache and Statistics

Dec 16th, 2015
291
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. For IO:
  2. pg_statio_all_tables
  3.  
  4. Test IO using "timer" utility in psql:
  5. timer "SELECT * FROM some_table" some_table;
  6.  
  7. View PostgreSQL cache in shared memory segments:
  8. ipcs -m
  9.  
  10. Statistics Tables: pg_class and pg_statistic
Advertisement
Add Comment
Please, Sign In to add comment