On Fri, Nov 24, 2017 at 6:54 AM, hmidi slim 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