deeejay icon

psql - Database IO, Cache and Statistics

deeejay | PRO | 12/16/15 05:02:36 PM UTC | 0 ⭐ | 247 👁️ | Never ⏰ | []
PostgreSQL |

220 B

|

None

|

0 👍

/

0 👎

Raw Download Clone Embed Print View 
For IO:
pg_statio_all_tables
 
Test IO using "timer" utility in psql:
timer "SELECT * FROM some_table" some_table;
 
View PostgreSQL cache in shared memory segments:
ipcs -m
 
Statistics Tables: pg_class and pg_statistic

Comments