Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!!

From: pavan95 <pavan(dot)postgresdba(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!!
Date: 2018-05-23 14:03:18
Message-ID: 1527084198212-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi Justin,

>How big is the table ? And curract_state_isfinal_app_idx ?
>Have these been reindexed (or pg_repacked) recently?

The size of the table 'tms_workflow_history' is 7600Kb(which is pretty
small). Yes those indexes were dropped and recreated.

>It looks like you resolved the bad estimate on the users table?
Yeah, even I think the same.

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://>

The above is the explain plan taken from production server. And this is the
main plan to tune.

Please let me know the where I'm going wrong. Thank you in Advance.!!

Regards,
Pavan

--
Sent from: http://www.postgresql-archive.org/PostgreSQL-performance-f2050081.html

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Sand Stone 2018-05-23 14:06:41 Re: dsa_allocate() faliure
Previous Message Justin Pryzby 2018-05-23 13:43:22 Re: Help me in reducing the CPU cost for the high cost query below, as it is hitting production seriously!!