Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ojeW2-0005PK-To for pgsql-performance@arkaria.postgresql.org; Sat, 15 Oct 2022 10:35:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ojeVz-0005LB-Qn for pgsql-performance@arkaria.postgresql.org; Sat, 15 Oct 2022 10:35:35 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ojeVz-0005L1-Fc for pgsql-performance@lists.postgresql.org; Sat, 15 Oct 2022 10:35:35 +0000 Received: from mail-pg1-x52c.google.com ([2607:f8b0:4864:20::52c]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ojeVt-0008Hl-ST for pgsql-performance@postgresql.org; Sat, 15 Oct 2022 10:35:35 +0000 Received: by mail-pg1-x52c.google.com with SMTP id s196so5130906pgs.3 for ; Sat, 15 Oct 2022 03:35:29 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=qaY17KmcJOL6zwj1VNtsxbk525U3olEehVugJ58Dr94=; b=NwFfO8YZcYSUY6J5sw4PYv757CQumZFErItH2na/oTAR1tL8LKSx/E0EZ4yLaAbcSM rc1UICsH2N3Wf7SuAI4Y5M9LsC3ZVwU7zlCSZr72WaN6nI7Re3dCKLQFMiRq8b2RkcDa p0pRgbK+RI8nHmVDLetauEn1B29tI9l27V1l8tryUF2He6P+nxIsK7M/fI7kZKVx68YN WGchYWWJG5T/MsUz4LxFRdSOSAPq7cmeUjnE6ZVt2CUNGNqz9F1+n1UROAxEBtK5qJBW lDj27OxwuJE+rTMUeGWIjroazeDMC2S6WoIfyapn5HaY2YAwJ6Zn51aUKmJ/1FSma3ar HWWA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=qaY17KmcJOL6zwj1VNtsxbk525U3olEehVugJ58Dr94=; b=IETYMUrkb0xJCfSv4++zbdCdGWRpV/7xaQiNIHhVrwXfga21xWRBeHuGuVYftWgpeh iSA7LVuv4ZxjGawmE4KkJg9hg0TUmFrS5KANHlzfwOjE6A4q2ac5rxCzVWWfQ+ZjV601 es15igOCPbWfokyk2bNeBKEq0ZLtLpPkmQ49FWdzc9SlAhyaJIBmyrCrDuDj/bIumo1G pq4dDWC9OrrslKQDu11V7SLlcXwzDvk39Toh/yUd8qOq9CV7Ni9KwaHTBTfEM2LX3G1q oJrOUrG8IYQ/9Us65x+5SQ5hetvsngr9f2+N1qV5pfoyMlgvkrsOaoC+rk171vHx1CVG IgQA== X-Gm-Message-State: ACrzQf3hqGIO+Ej/Zs4yn6WUxD9nKbgR6PUsJHzorWeEXSwyfI01zbHZ TdUWqET1bfP45hXcQxdEfAc= X-Google-Smtp-Source: AMsMyM4j97IotoeWPJn+gpGeCIQkQGgkPGQ5Z9h6K4QzTIINN6n+UJuX0Gwk8tmn9uNaWbDMVVcqfQ== X-Received: by 2002:a05:6a02:104:b0:430:93ec:776f with SMTP id bg4-20020a056a02010400b0043093ec776fmr2031751pgb.544.1665830127821; Sat, 15 Oct 2022 03:35:27 -0700 (PDT) Received: from jrouhaud (2001-b011-1006-fb32-552a-362d-7d17-0f36.dynamic-ip6.hinet.net. [2001:b011:1006:fb32:552a:362d:7d17:f36]) by smtp.gmail.com with ESMTPSA id 6-20020a170902c10600b001728ac8af94sm3085869pli.248.2022.10.15.03.35.25 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Sat, 15 Oct 2022 03:35:27 -0700 (PDT) Date: Sat, 15 Oct 2022 18:35:22 +0800 From: Julien Rouhaud To: Sengottaiyan T Cc: depesz@depesz.com, MichaelDBA , pgsql-performance@postgresql.org Subject: Re: Identify root-cause for intermittent spikes Message-ID: <20221015103522.f4dpskwjgb6xkilx@jrouhaud> References: <0e34d222-d3b8-02fc-f60a-0487212e0cd4@sqlexec.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Oct 14, 2022 at 10:57:00PM +0530, Sengottaiyan T wrote: > > Please suggest: Is there any open-source tool available for capturing such > information? Most of the open-source tools won't work as you won't be able to install them on RDS. As far as I know the "Performance Insights" provides detailed information, not only cumulated metrics, so that's probably your best option.