I have a production system which run more than 100K messages on a particular day however when i try to list all completed queries using the system:completed_requests, it shows only 5 records. What could be the reason for this?
Thanks Raju for the reply. I went through the URL you shared but my question was the select statement was returning only 5 records however I know for the fact that my application does more than 100K transactions per day. so the count 5 is definitely not correct.
Does this system bucket store only certain statements for e.g. all requested completed within certain seconds? I believe, Yes, I am checking further on this.