| From: | Steve Crawford <scrawford(at)pinpointresearch(dot)com> |
|---|---|
| To: | Nik Tek <niktek2005(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Find all the the SELECT statements that occured |
| Date: | 2013-05-23 21:46:01 |
| Message-ID: | 519E8E19.7060908@pinpointresearch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Crawford | 2013-05-23 21:51:13 | Re: Success stories of PostgreSQL implementations in different companies |
| Previous Message | Melvin Call | 2013-05-23 21:38:28 | Re: New role, no database |