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 1qJXdR-00043A-8O for pgadmin-hackers@arkaria.postgresql.org; Wed, 12 Jul 2023 11:03:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qJXdP-0004lj-C8 for pgadmin-hackers@arkaria.postgresql.org; Wed, 12 Jul 2023 11:03:51 +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 1qJXdP-0004la-2y for pgadmin-hackers@lists.postgresql.org; Wed, 12 Jul 2023 11:03:51 +0000 Received: from mail-qt1-x834.google.com ([2607:f8b0:4864:20::834]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qJXdK-003eqj-Rx for pgadmin-hackers@postgresql.org; Wed, 12 Jul 2023 11:03:49 +0000 Received: by mail-qt1-x834.google.com with SMTP id d75a77b69052e-403a3df88a8so34805931cf.3 for ; Wed, 12 Jul 2023 04:03:46 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; t=1689159824; x=1691751824; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=I7sAYUy5p/wL9Akt/nBAsYf4ToDdchHAqaYjrdGPIRE=; b=WS1EwE84pDgdq+sMmDsKi8wRPZ6+7UINGMNneVl7uKSqlx7PdSJ4WUgL+xCxZvhkNX 5Q3TGSCsPejyRjkE0HlithPCFkj+CLVXxyvqatBMzmvddo2bsPpj9A7jNiYepGxTCnsm 9cgnT0GoIVhrxCQB9xf7SOS/CIE+/IPoHO87BIn3Sqa8InA/CDdTbM9d5nnXnNr9PV86 Pb2w3OeXWpdfYii3Yhf7oIrs/9zYZcu6+a+aJw3Ak5sZBZ9pXrn26GaYAS4sIamwXKM+ HZVlpMd26NAq3CKtta3ZnR88ElIHYc8CDztA1CZa01ilA93tpHk67bwUnjJ0/WRhKVoG xt1w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1689159824; x=1691751824; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=I7sAYUy5p/wL9Akt/nBAsYf4ToDdchHAqaYjrdGPIRE=; b=GLKM+UpKbPSf5h6zVPCHx8XCu2w6PrkM9n9/7aeVRQXaNmrJTB+fO9/SG4h9741XmR uc74PpncyMue8DU1vSCzaCRxHt36qOi8NdO5IGfX6Mk1utD6MM0dcUvCwhfa4xUoS+4F xTflw2MiSk+BQP2DVolygjaebs9bqbAFwWeM9J1bUKK+n8qBs3bnW3If5wGz76vIvgVq UK0kdwugpAw+9WRG4zvf87Ix036HprCIu7rvbps8PUuEBEvMVpI0MfST5khknB0GGZy3 lOG91HRWOg6DgoxZZS4tLiPctRIafDgiDbF9gRFVfdlJ8LJJzhE0md1teq4zpznNteTB nBSA== X-Gm-Message-State: ABy/qLZyhVI5g9IWlhO69SGY7hd+mF/PLoyb10RaugDxF4BnfFspjAxE DdfkSpXO1l9CixONie8s4Ce68NkaxbcHrJ1+ngkDYw== X-Google-Smtp-Source: APBJJlGvj6RgJZN2zyMjvDMv28z7rECTl48BNAE6zm5NnxfcFOKTzgPuz4YIWVVy1JU/w6+rNhKDMnjv66BBNXXMJhw= X-Received: by 2002:a05:622a:11d2:b0:403:b23f:9aab with SMTP id n18-20020a05622a11d200b00403b23f9aabmr8997569qtk.7.1689159824591; Wed, 12 Jul 2023 04:03:44 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Ashesh Vashi Date: Wed, 12 Jul 2023 16:33:33 +0530 Message-ID: Subject: Re: Pgadmin4 System Stats Extension Design To: Sahil Harpal Cc: Aditya Toshniwal , Dave Page , Akshay Joshi , Khushboo Vashi , pgadmin-hackers@postgresql.org Content-Type: multipart/alternative; boundary="0000000000005067d40600482be8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000005067d40600482be8 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wed, Jul 12, 2023 at 4:20=E2=80=AFPM Sahil Harpal wrote: > On Wed, 12 Jul 2023 at 10:26, Ashesh Vashi > wrote: > >> On Tue, Jul 11, 2023 at 8:45=E2=80=AFPM Sahil Harpal >> wrote: >> >>> On Tue, Jul 11, 2023 at 2:29=E2=80=AFPM Sahil Harpal >>> wrote: >>> >>>> On Tue, 11 Jul 2023 at 12:04, Ashesh Vashi < >>>> ashesh.vashi@enterprisedb.com> wrote: >>>> >>>>> Try preloading the extension in the PostgreSQL server. >>>>> e.g. Add this extension in the 'shared_preload_libraries' in >>>>> postgresql.conf. >>>>> >>>>> Reference: https://pgpedia.info/s/shared_preload_libraries.html >>>>> >>>> Thank you, Ashesh! I will try this and provide you with an update. >>>> >>> I tried adding 'system_stats' in the 'shared_preload_libraries', but it >>> doesn't work. >>> >> Did you restart the database server? >> > Yep. > If it is an extension issue, you may want to create an issue in its github repo with reproduction steps, current & expected behaviour. -- Ashesh --0000000000005067d40600482be8 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Wed, Jul 12, 2023 at 4:20=E2=80=AFPM S= ahil Harpal <sahilharpal123= 4@gmail.com> wrote:
On = Wed, 12 Jul 2023 at 10:26, Ashesh Vashi <ashesh.vashi@enterprisedb.com> w= rote:
3D""
On Tue, Jul 11, 2023 at 8:45=E2=80=AFPM Sahil H= arpal <sa= hilharpal1234@gmail.com> wrote:
3D""
On Tue, J= ul 11, 2023 at 2:29=E2=80=AFPM Sahil Harpal <sahilharpal1234@gmail.com> wrote= :
On Tue, 11 Jul 2023 at 12:04, Ashesh Vashi <ashesh.vashi@en= terprisedb.com> wrote:
3D=
<= div>Try preloading the extension in the PostgreSQL server.
e.g.=C2=A0 Ad= d this extension in the 'shared_preload_libraries' in postgresql.co= nf.

Reference:=C2=A0h= ttps://pgpedia.info/s/shared_preload_libraries.html
Thank you, Ashesh! I will try this and provide you with an = update.
I tried adding 'system= _stats' in the 'shared_preload_libraries', but it doesn't w= ork.=C2=A0
Did you restart the database se= rver?
Yep.=C2=A0
If it is an extension issue, you may want to create an issue in= its github repo with reproduction steps, current & expected behaviour.=

-- Ashesh=C2=A0=C2=A0
--0000000000005067d40600482be8--