Re: Find all the the SELECT statements that occured

From: Sergey Konoplev <gray(dot)ru(at)gmail(dot)com>
To: Nik Tek <niktek2005(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Find all the the SELECT statements that occured
Date: 2013-05-23 23:49:57
Message-ID: CAL_0b1sx8kLFfr9m+Dfc+UQJ91OH=MDM3ULPSgiq9ywCJfn1iQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, May 23, 2013 at 2:37 PM, Nik Tek <niktek2005(at)gmail(dot)com> wrote:
> I have a question on how to find all the SELECT statements that have
> occurred in the database. I don't want any DML(Insert/Update/Delete)
> statements to be captured. This is for knowing how many selects statements
> occur within the database in an 1 hour interval or on a average.
>
> Would this simple or possible in postgres?

Take a look at the pg_stat_statements module.

http://www.postgresql.org/docs/9.2/static/pgstatstatements.html

--
Kind regards,
Sergey Konoplev
PostgreSQL Consultant and DBA

Profile: http://www.linkedin.com/in/grayhemp
Phone: USA +1 (415) 867-9984, Russia +7 (901) 903-0499, +7 (988) 888-1979
Skype: gray-hemp
Jabber: gray(dot)ru(at)gmail(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2013-05-24 01:29:02 Re: New role, no database
Previous Message Jaime Casanova 2013-05-23 23:34:33 Re: [PERFORM] Very slow inner join query Unacceptable latency.