Sha256: 80e6a2652b965f2ebb1474ff4c0c925671217c6e09e19d2280b95640d4de3265
Contents?: true
Size: 324 Bytes
Versions: 57
Compression:
Stored size: 324 Bytes
Contents
/* Calculate how many blocks from which table are currently cached */
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 %{limit};
Version data entries
57 entries across 57 versions & 1 rubygems