复制SELECT c.relname,想学 count(*) AS buffers FROM pg_class c JOIN pg_buffercache b ON b.relfilenode=c.relfilenode INNERJOIN pg_database d ON (b.reldatabase=d.oid AND d.datname=current_database()) WHERE c.relname NOTLIKEpg%GROUPBY c.relname ORDERBY 2 DES 1.2.3.4.5.6.7.8.9.