Postgres Pro
Downloads
Home   >   mailing lists

Find all the the SELECT statements that occured - Mailing list pgsql-general

From Nik Tek
Subject Find all the the SELECT statements that occured
Date
Msg-id CAHySzWXpRwvU+JLRR4UG1ENzHJZvtpx-oxRtOFEy692EUQcTMg@mail.gmail.com
Whole thread Raw
Responses Re: Find all the the SELECT statements that occured  (Steve Crawford <scrawford@pinpointresearch.com>)
Re: Find all the the SELECT statements that occured  (Sergey Konoplev <gray.ru@gmail.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Oscar Calderon
Date:
Subject: Success stories of PostgreSQL implementations in different companies
Next
From: Melvin Call
Date:
Subject: Re: New role, no database