On Thu, May 23, 2013 at 2:37 PM, Nik Tek <niktek2005@gmail.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.ru@gmail.com