Thread: Find all the the SELECT statements that occured
Hi,
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?
Thank you
Nik
On 05/23/2013 02:37 PM, Nik Tek wrote: > Hi, > > 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. If you are looking for statistical information you should probably look at PgBadger. You can see the by-hour counts of select, update, delete, etc. as well as long-running queries, queries that are run most frequently, queries that consume the most overall time and much more. Cheers, Steve
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