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 1qJSE7-0003ko-Fx for pgadmin-hackers@arkaria.postgresql.org; Wed, 12 Jul 2023 05:17:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qJSE5-0005vo-8u for pgadmin-hackers@arkaria.postgresql.org; Wed, 12 Jul 2023 05:17:21 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qJSE4-0005vf-PP for pgadmin-hackers@lists.postgresql.org; Wed, 12 Jul 2023 05:17:20 +0000 Received: from mail-yw1-x112b.google.com ([2607:f8b0:4864:20::112b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qJSE1-003OLf-Aq for pgadmin-hackers@postgresql.org; Wed, 12 Jul 2023 05:17:18 +0000 Received: by mail-yw1-x112b.google.com with SMTP id 00721157ae682-579e212668fso5608097b3.1 for ; Tue, 11 Jul 2023 22:17:17 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; t=1689139036; x=1691731036; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=zApkTwT/RYW+NijSYRwH2UQNe6Mi1B8PAi4tkvf+kWc=; b=RovX1WXXbPmBwcknpevsr9vcsDoguCdRKtJ6+LXoSHg+Y1HjKMEV8EtdIk7z21gbvX fdwQUEWnJPD5985ph1xMMcJi3xVm+R5F4WldsnoTIEwydlMkbHHJ2jT4r/XBvijKnd7+ 0u8atZItSkMygK/orL4D0fVtsmQsVNA2ub+1EifitLCJeWdrWSnnozuAwKz+JedEHvug 5abGWHaX/U/rI3a4KGirCo8vlr93hZg/0XhR8Xp/+NwdIaHMDdAFNgF/XoPemDXU/vIw qDnqaXT2Jx45olGcV0Lm5P2qlSkHL3DmqlB1vpo4aZ7GjN9u+xB/Fk0B/Eme83qFGklw hJbQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1689139036; x=1691731036; 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=zApkTwT/RYW+NijSYRwH2UQNe6Mi1B8PAi4tkvf+kWc=; b=P1p5No1cyGSNhUg+c1mX6iLIL8azM28s1k/RwIX6HRV2Iyweocp1wpPMe3d7UQFHsr iTRGSgdEGcfHLHu6dzMjSgdGpSa2SyvlR3qrE7pDHunPfZCh2KLwuYacETdAyzBtzp0l vNrKXApwyYChHiMr6kcuFx96hpDfzEG4orrxmWSQWuv782gamWJucKG5i6DqSlOcYuu4 mDIJwrQD+eQGnPcuw/dB/djvfVp/nc6p78lGlkcm06CtOxGuCTFMTiRVcj1T9g6kTqW4 bPX9b71l6YBjD8H84GFwXXaveTI3YXZIA1/ToZbdgvai+y8B0VZUkkwlueRCSRG3/IMQ 2Z0g== X-Gm-Message-State: ABy/qLbD0dxjhmVhhwy6Ml0AMrJPzUHSc+JVCelCCUzPji4jLeJXMR3G jYTzwJJDFgv4D7VUOCf5nT6HMnrAEw9BSzzvuThjHA== X-Google-Smtp-Source: APBJJlFtvGL86g2skLCNT3qoedcEgIl9cPGetZeAM94SSxwVz2Y1L3HTrMRhoLKzNJnbACvihaSAl/n/5GZZMvu12yo= X-Received: by 2002:a0d:cc0d:0:b0:56c:ffe4:4ca5 with SMTP id o13-20020a0dcc0d000000b0056cffe44ca5mr1088724ywd.10.1689139036438; Tue, 11 Jul 2023 22:17:16 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Khushboo Vashi Date: Wed, 12 Jul 2023 10:47:05 +0530 Message-ID: Subject: Re: Pgadmin4 System Stats Extension Design To: Sahil Harpal Cc: Aditya Toshniwal , Ashesh Vashi , Dave Page , Akshay Joshi , pgadmin-hackers@postgresql.org Content-Type: multipart/alternative; boundary="0000000000003e5a8c06004354f6" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000003e5a8c06004354f6 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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 >> 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. > > On Tue, 11 Jul 2023 at 14:38, Aditya Toshniwal < > aditya.toshniwal@enterprisedb.com> wrote: > >> Disk info doesn't need to be updated live. You can update it once on >> every tab change. I feel process info should be a bar chart. The >> categories are fixed in number and we can use StreamingChart for bar cha= rt. >> > Okay sure. > > Please ignore the previous WIP.patch file. I missed to include few > untracked changes. > I have attached the new patch file. Sorry for the inconvenience. > > New patch consist: > > - Single dashboard with option to toggle between General and System > Statistics > - Summary tab (except process info details). > - CPU Details > - Memory Details > > > It fails while applying. Can you please rebase your patch and send it? Thanks, > Sahil > --0000000000003e5a8c06004354f6 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


=
On Tue, Jul 11, 2023 at 8:45=E2=80=AF= PM Sahil Harpal <sahilharpa= l1234@gmail.com> wrote:
3D""
On Tue, Jul 11, 2023 at 2:29=E2=80=AFPM Sahil Harpal= <sahilha= rpal1234@gmail.com> wrote:
On Tue, 11 Jul 2023 at = 12:04, Ashesh Vashi <ashesh.vashi@enterprisedb.com> wrote:
3D""
Try preloading the extension in the Post= greSQL server.
e.g.=C2=A0 Add this extension in the 'shared_preload_= libraries' in postgresql.conf.

Reference:=C2=A0https://pgpedia.info/s/shared_preload_libraries.html
Thank you, Ashesh! I will try this and provide y= ou with an update.
I tried adding = 'system_stats' in the 'shared_preload_libraries', but it do= esn't work.=C2=A0

On Tue, 11 Jul 2023 at 14:38, Aditya To= shniwal <aditya.toshniwal@enterprisedb.com> wrote:
Disk info doesn't need to be updated live. You can update it onc= e on every tab change.=C2=A0I feel process info should be a bar chart. T= he categories are fixed in number and we can use StreamingChart for bar cha= rt.
=C2=A0Okay sure.
Please ignore the previous WIP.patch file. I missed to include= few untracked changes.
I have attached the new patch file. Sorry= for the inconvenience.

New patch consist:
  • Single dashboard with option to toggle between General and Syste= m Statistics
  • Summary tab (except process info details).=C2=A0
    • <= li>CPU Details
  • Memory Details

<= /div>
=C2=A0It fails while applying. Can you please rebase= your patch and send it?=C2=A0

=
Thanks,
Sahil
--0000000000003e5a8c06004354f6--