pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Justin Pryzby <pryzby@telsasoft.com>
To: pavan95 <pavan.postgresdba@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!!
Date: Wed, 23 May 2018 15:01:32 -0500
Message-ID: <20180523200132.GL30060@telsasoft.com> (raw)
In-Reply-To: <1527084198212-0.post@n3.nabble.com>
References: <1526883356469-0.post@n3.nabble.com>
	<1526917693149-0.post@n3.nabble.com>
	<1526985179479-0.post@n3.nabble.com>
	<20180522103906.GF30060@telsasoft.com>
	<1526986304012-0.post@n3.nabble.com>
	<20180522182307.GA9330@telsasoft.com>
	<CACh9nsb_voDr57vRrwvhFsCGuT1SzRMWvbQz1wnU5miK1sdWbQ@mail.gmail.com>
	<1527058866609-0.post@n3.nabble.com>
	<20180523134322.GK30060@telsasoft.com>
	<1527084198212-0.post@n3.nabble.com>

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




view thread (25+ messages)  latest in thread

Message-ID: <20180523200132.GL30060@telsasoft.com>
Permalink:  ../20180523200132.GL30060@telsasoft.com/
Also on:    postgresql.org/message-id/20180523200132.GL30060@telsasoft.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: pryzby@telsasoft.com, pavan.postgresdba@gmail.com
  Subject: Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!!
  In-Reply-To: <20180523200132.GL30060@telsasoft.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox