Prabhjot,
You could clear the cache at the disk level, not at the db level.
Follow the link: http://linux-mm.org/Drop_Caches
You can look into the cache by using pg_buffercache, if you want to.
Hope it helps
Nik
On Wed, Aug 21, 2013 at 1:31 PM, Prabhjot Sheena <
prabhjot.she...@rivalwatch.com
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 simp