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

Question

Is there any way to check if index is loaded to memory?

Answer 1

Check the contrib module pg_buffercache

After installation you can use this query to see if the table and index are in the buffercache:

SELECT
    DISTINCT
    relname
FROM
    pg_buffercache
        JOIN pg_class USING (relfilenode)
WHERE
    relname IN('your_tablename','your_index_name');