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
Post a Comment