diff options
| author | Bruce Momjian <bruce@momjian.us> | 2007-04-07 16:09:14 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2007-04-07 16:09:14 +0000 |
| commit | b0194ab1100be48c69311e84636ffd58062b0582 (patch) | |
| tree | c4683da502611065b323a50795a3d7c7c56fb888 /contrib/pg_buffercache/pg_buffercache.sql.in | |
| parent | 5695f38f74ddc5a925dca3764b0b861ce618c1f6 (diff) | |
| download | postgresql-b0194ab1100be48c69311e84636ffd58062b0582.tar.gz | |
Add the usage count statistics to the information available in
contrib/pgbuffercache.
Greg Smith
Diffstat (limited to 'contrib/pg_buffercache/pg_buffercache.sql.in')
| -rw-r--r-- | contrib/pg_buffercache/pg_buffercache.sql.in | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/contrib/pg_buffercache/pg_buffercache.sql.in b/contrib/pg_buffercache/pg_buffercache.sql.in index ea63234f6b..a96b5d91f6 100644 --- a/contrib/pg_buffercache/pg_buffercache.sql.in +++ b/contrib/pg_buffercache/pg_buffercache.sql.in @@ -12,7 +12,7 @@ LANGUAGE C; CREATE VIEW pg_buffercache AS SELECT P.* FROM pg_buffercache_pages() AS P (bufferid integer, relfilenode oid, reltablespace oid, reldatabase oid, - relblocknumber int8, isdirty bool); + relblocknumber int8, isdirty bool, usagecount int2); -- Don't want these to be available at public. REVOKE ALL ON FUNCTION pg_buffercache_pages() FROM PUBLIC; |