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 1qJXQO-0003Nl-4F for pgadmin-hackers@arkaria.postgresql.org; Wed, 12 Jul 2023 10:50:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qJXQM-0007HP-0H for pgadmin-hackers@arkaria.postgresql.org; Wed, 12 Jul 2023 10:50:22 +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 1qJXQL-0007HG-LC for pgadmin-hackers@lists.postgresql.org; Wed, 12 Jul 2023 10:50:21 +0000 Received: from mail-pg1-x530.google.com ([2607:f8b0:4864:20::530]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qJXQI-003ek4-Lp for pgadmin-hackers@postgresql.org; Wed, 12 Jul 2023 10:50:21 +0000 Received: by mail-pg1-x530.google.com with SMTP id 41be03b00d2f7-55b83ae9be2so4893125a12.2 for ; Wed, 12 Jul 2023 03:50:18 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1689159015; x=1691751015; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=Abp6OlV9bA1LvX9jQg/21UbQsNop7orkp/a1G9ddkFo=; b=Yoi68Zshyd6kmSiNvFU4ulzZjA+Z9xzRIB/QNGsZT2p+Pz1IpxMRAYbr8mIoMP++Xn MYCK7N46At+HYM4WojjyB30rft/3Pusfl/URU0JPxcPYrFll/mI1mFJNKqvY6aUwu68M Uu3/LGCfcxNS3gEEL7rb7m3lGD4T1wlUhwNjEe9RdT/jc1OHXGtFJnwAQt5GTEaLDdz2 MhbaWuE3bBRjQDc7TbEsExy3wZkiBAaDhTkuRNDULt8b+xqZb1kSoWtdiUYXXpwu8ABf TCKfqOr5LBOZqbTQzpWW1j/pdWI0AWBpJ/DH2BFecgfNwkpiFZ/Tb9H87RjJQS0SF33N 9zOg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1689159015; x=1691751015; 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=Abp6OlV9bA1LvX9jQg/21UbQsNop7orkp/a1G9ddkFo=; b=h7b0VhWbxkbpoHaszGVGd6SOXuxTBqdIArpQ5sk4o0mWuIlXuOKuZ+rsZDTRRyHgcW YSGZAnWyJMXE5lrUgcdgE/PHKxXGtK3pszqc3Ql+GSIdrFFkcBpSCesABnEX0O8SrCGB +cfH45dEGlW6+GgACRVlmqvO5lBaI4LpmEU4ZOG8BIbHkqd+8BfC/u+8KQZFT+dJe+r/ MIE7tiS+vQ1AIO7fhFetXSTaBwdwaHYAZTF5P3cIGFwW2aRfuDMdtkyFJFjYpVU/EbYr /HgqXbV8rrij8l2xM+CT0tcHUZV0oszbcJXL96+RG1kfrNZ6yJpVY2jOxlECqOJnrkRN vrDg== X-Gm-Message-State: ABy/qLai5kopk5866B9oZy8eHm+TOrcBwNmFq4TrkhYNumlHUSAYSUpO h8yf052m3wgTfHtEIA+Jud23kqZlM6tLu5RM1NM= X-Google-Smtp-Source: APBJJlEu8Dle9SJZ8KOGiGDtJS8bNeZrqDrs04oMChmGa4X17KJ7x2AnA0ZSrzp/sIMN8gEHk4TBkWxpMSlFqU1vE6w= X-Received: by 2002:a17:90a:a182:b0:263:6e10:7cdd with SMTP id t2-20020a17090aa18200b002636e107cddmr18639355pjp.38.1689159015179; Wed, 12 Jul 2023 03:50:15 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Sahil Harpal Date: Wed, 12 Jul 2023 16:19:53 +0530 Message-ID: Subject: Re: Pgadmin4 System Stats Extension Design To: Ashesh Vashi Cc: Aditya Toshniwal , Dave Page , Akshay Joshi , Khushboo Vashi , pgadmin-hackers@postgresql.org Content-Type: multipart/alternative; boundary="00000000000011a9cc060047fbe9" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000011a9cc060047fbe9 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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. --00000000000011a9cc060047fbe9 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Wed, 12 Jul 2023 at 10:26, Ashesh Vash= i <as= hesh.vashi@enterprisedb.com> wrote:
3D""
On Tue, Jul 11, 2023 at 8:45=E2=80=AFPM Sahil Harpal <sahilharpal1234@= gmail.com> wrote:
3D""
On Tue, Jul= 11, 2023 at 2:29=E2=80=AFPM Sahil Harpal <sahilharpal1234@gmail.com> wrote:<= br>
On Tue, 11 Jul 2023 at 12:04, Ashesh Vashi <ashesh.vashi@enter= prisedb.com> wrote:
3D""
Try preloading the extension in the PostgreSQL server.
e.g.= =C2=A0 Add this extension in the 'shared_preload_libraries' in post= gresql.conf.

Reference:=C2=A0https://pgped= ia.info/s/shared_preload_libraries.html
<= div>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.=C2=A0
Did you restart the database server?
<= /div>
Yep.=C2=A0
--00000000000011a9cc060047fbe9--