How to find if a SELECT is reading from buffer or disk ? - Mailing list pgsql-admin

From Balkrishna Sharma
Subject How to find if a SELECT is reading from buffer or disk ?
Date
Msg-id BAY149-w19CB46743B9D1EC9D68760F0E80@phx.gbl
Whole thread Raw
Responses Re: How to find if a SELECT is reading from buffer or disk ?  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Re: How to find if a SELECT is reading from buffer or disk ?  (Chirag Dave <cdave@ca.afilias.info>)
List pgsql-admin
Hi,

I am increasing the shared_buffer size in postgresql.conf and want to measure its effect on READ. In essence I want to know if the SELECT queries I am firing repeatedly is reading from the buffer or going directly to the disk.

I am expecting the first SELECT to go to disk and the subsequent call of the same SELECT to read from buffer .

Right now I am just looking at execution time of the SELECTs and trying to conclude. But there should be a direct way to see where the SELECT reads from.

How can I accomplish this ?

Thanks
Bala


The New Busy think 9 to 5 is a cute idea. Combine multiple calendars with Hotmail. Get busy.

pgsql-admin by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: transaction_timestamp()
Next
From: "Kevin Grittner"
Date:
Subject: Re: How to find if a SELECT is reading from buffer or disk ?