On Fri, Nov 24, 2017 at 6:54 AM, hmidi slim <hmidi.slim2@xxxxxxxxx> wrote:
I'm trying to analyze some queries using the explain instructions and the option analyze and buffers. I realized that the query refers to the cache memory to return the results. Is there any solution to clear the cache in postgresql inorder to get execution time of the query when it get data from disk and not from cache memory?
If you are on a (non-production) *nix server you can use:
sync && echo 3 > /proc/sys/vm/drop_caches
