Postgres Pro
Downloads
Home   >   mailing lists

Re: Needs Suggestion - Mailing list pgsql-general

From raghu ram
Subject Re: Needs Suggestion
Date
Msg-id BANLkTinB8kaCQYuZeAk7Sxkha9FHRfBTGQ@mail.gmail.com
Whole thread Raw
In response to Needs Suggestion  (SUBHAM ROY <subham.iem@gmail.com>)
Responses Re: Needs Suggestion
List pgsql-general
Tree view


On Wed, Apr 20, 2011 at 10:41 PM, SUBHAM ROY <subham.iem@gmail.com> wrote:
By doing \timing in psql, we enable the timing and then when we type the query we are able to see its execution time.
Similarly, is there any way to view the number I/Os and memory usage by a particular query.

PGsnap module will describes tables,Indexes,Sequences I/O statistics and URL as follows


pg_buffercache module will shows memory usage on particular tables.


--Raghu Ram



 
And also the timing result that gets displayed, in which log file does it get recorded?

--
Thank You,
Subham Roy,
CSE IIT Bombay.


pgsql-general by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: Help - corruption issue?
Next
From: Frank van Vugt
Date:
Subject: Re: REASSIGN OWNED doesn't for all objects, ALTER FUNCTION seems to fix it