Skip to content

Instantly share code, notes, and snippets.

@Madusudanan

Madusudanan/pg_buffercache.sql

Created May 16, 2016 14:13
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Madusudanan/f02ebba386164b500e5c9cb15cd7f8a6 to your computer and use it in GitHub Desktop.
Save Madusudanan/f02ebba386164b500e5c9cb15cd7f8a6 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
pg_buffercache.sql
SELECT c.relname,count(*) AS buffers
FROM pg_class c INNER JOIN pg_buffercache b
ON b.relfilenode=c.relfilenode INNER JOIN pg_database d
ON (b.reldatabase=d.oid AND d.datname=current_database())
GROUP BY c.relname
ORDER BY 2 DESC LIMIT 100;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment