Advertisement
Guest User

Untitled

a guest
Nov 15th, 2019
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.28 KB | None | 0 0
  1. select sum(a.mb) from (select c.relname, isdirty, count(*)*8/1024.0 as mb
  2. from pg_class c inner join pg_buffercache b on (b.relfilenode = c.relfilenode)
  3. inner join pg_database d on (b.reldatabase=d.oid and d.datname = current_database())
  4. group by c.relname, isdirty order by 3 desc) a
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement