indexing - How can i check in Postgresql if specific index is loaded to memory? -


is there way check if index loaded memory?

check contrib module pg_buffercache

after installation can use query see if table , index in buffercache:

select     distinct     relname     pg_buffercache         join pg_class using (relfilenode)     relname in('your_tablename','your_index_name');  

Comments

Popular posts from this blog

forms - Secure PHP File Upload Script -

java - How do I override the spring framework version in Spring Batch? -

.net - Amazon EC2 API and Windows instances - any way to get drive letter assignment? -