Re: Cache hit ratio

From: "Luke Lonergan" <llonergan(at)greenplum(dot)com>
To: "Jean Arnaud" <Jean(dot)Arnaud(at)inrialpes(dot)fr>, "PostgreSQL Performance" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Cache hit ratio
Date: 2007-04-03 16:17:47
Message-ID: C237CC3B.2B619%llonergan@greenplum.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Set log_executor_stats=true;

Then look in the log after running statements (or tail -f logfile).

- Luke

On 4/3/07 7:12 AM, "Jean Arnaud" <Jean(dot)Arnaud(at)inrialpes(dot)fr> wrote:

> Hi
>
> Is there a way to get the cache hit ratio in PostGreSQL ?
>
> Cheers

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Josh Berkus 2007-04-03 16:26:02 Re: Shared buffers, db transactions commited, and write IO on Solaris
Previous Message Guillaume Cottenceau 2007-04-03 14:53:39 Re: Cache hit ratio