Re: [GENERAL] No caching sql query

2013-08-21 Thread Nik Tek
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

[GENERAL] Find all the the SELECT statements that occured

2013-05-23 Thread Nik Tek
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