You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
It'd be nice to be able to limit cache clearing to a particular entity only in a particular schema.
Supporting query that includes schemas:
-- Cache, ordered by the number of buffersSELECTpn.nspnameAS schema, pc.relname, count(1) AS buffers, sum(pb.isdirty :: INT) AS dirty_pages
FROM pg_buffercache pb
JOIN pg_class pc ONpb.relfilenode= pg_relation_filenode(pc.oid) --ANDpb.reldatabaseIN(0,
(SELECToidFROM pg_database
WHERE datname = current_database()))
JOIN pg_namespace pn ONpn.oid=pc.relnamespaceGROUP BYpc.relname, pn.nspnameORDER BY buffers DESC;
The text was updated successfully, but these errors were encountered:
It'd be nice to be able to limit cache clearing to a particular entity only in a particular schema.
Supporting query that includes schemas:
The text was updated successfully, but these errors were encountered: