On Wed, May 23, 2018 at 07:03:18AM -0700, pavan95 wrote: > Please find the explain plan which got increased again vastly. Is this > because of the increase in rows? > > Link : https://explain.depesz.com/s/Ifr <http://> That's explain without "analyze", so not very useful. There's handful of questions: On Wed, May 23, 2018 at 08:43:22AM -0500, Justin Pryzby wrote: > - postgres parameters: what are shared_buffers, work_mem, effective_cache_size ? > + https://wiki.postgresql.org/wiki/Server_Configuration > - are there other DBs/applications running on the server/VM ? > - kernel tuning (readahead, VM parameters, write cache, scheduler, THP, etc) > - server hardware (what OS? storage? RAM? filesystem?) > - how does the storage perform outside of postgres? > + something like this: /usr/sbin/bonnie++ -f -n0 -x4 -d /var/lib/pgsql Justin
