Re: query issue

On Wed, 16 Jun 2021 at 18:29, Atul Kumar wrote: > QUERY PLAN > Limit (cost=0.43..5529.03 rows=10 width=37) (actual > time=0.974..12911.087 rows=10 loops=1) > Output: items._id > Buffers: shared hit=4838 read=3701 > -> Subquery Scan on items (cost=0.43..1622646.30 rows=2935 > width=37) (ac

Re: query issue

Hi, Please find below the details you asked for: Relation size 1986 MB table count - 1407721 We have removed few indexes. Query - QUERY PLAN Limit (cost=0.43..5529.03 rows=10 width=37) (actual time=0.974..12911.087 rows=10 loops=1) Output: items._id Buffers: shared hit=4838 read=3701

Re: query issue

On Tue, 15 Jun 2021 19:16:41 +0530 Atul Kumar wrote: > hi, > > I have an RDS instance with 2GB of RAM, 1 CPU, instance class - t2.small. > > If you need any more info please let me know. > > and as you shared I need to tweak > random_page_cost/seq_page_cost/effective_cache_size So please sugge

Re: query issue

hi, I have an RDS instance with 2GB of RAM, 1 CPU, instance class - t2.small. If you need any more info please let me know. and as you shared I need to tweak random_page_cost/seq_page_cost/effective_cache_size So please suggest which parameter value I need to increase or decrease as I am known w

Re: query issue

On Tue, 15 Jun 2021 16:12:11 +0530 Atul Kumar wrote: > Hi, > > I have postgres 10 running on RDS instance. > > I have query below: [...] > > So my doubt is initially when I run this query it takes around 42 > seconds to complete but later after few minutes it completes in 2-3 > seconds. > > I

query issue

Hi, I have postgres 10 running on RDS instance. I have query below: select * from "op_KFDaBAZDSXc4YYts9"."UserFeedItems" where (("itemType" not in ('WELCOME_POST', 'UPLOAD_CONTACTS', 'BROADCAST_POST')) and ("userId" = '5d230d67bd99c5001b1ae757' and "is_deleted" in (true, false))) order by "score