Re: [GENERAL] Find all the the SELECT statements that occured
On Thu, May 23, 2013 at 2:37 PM, Nik Tek 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...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] Find all the the SELECT statements that occured
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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] 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
