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 1qJRuD-0002qS-4r for pgadmin-hackers@arkaria.postgresql.org; Wed, 12 Jul 2023 04:56:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qJRuB-0005kB-6m for pgadmin-hackers@arkaria.postgresql.org; Wed, 12 Jul 2023 04:56:47 +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 1qJRuA-0005dW-RO for pgadmin-hackers@lists.postgresql.org; Wed, 12 Jul 2023 04:56:47 +0000 Received: from mail-qt1-x82f.google.com ([2607:f8b0:4864:20::82f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qJRu7-003ODe-Ia for pgadmin-hackers@postgresql.org; Wed, 12 Jul 2023 04:56:44 +0000 Received: by mail-qt1-x82f.google.com with SMTP id d75a77b69052e-4039a2b71c1so32066951cf.0 for ; Tue, 11 Jul 2023 21:56:43 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; t=1689137802; x=1691729802; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=NXWQo3YZ5waoIYaiSNfc/xbrzJRmtM8qVgnIzTkEtOw=; b=Gq9nhgeNGsVK9FVETTxadN5MwQQaqXekzx3ZM75qqAAimjY0fiLW9sFf93cPW3uJTm hZh8z568XOOwhdvo0EUnpKPiojUFDMFyVYx26PuGzH88QckAfe/07ocwcoaq77w6FoKg 5LCzSckTbhCSyKHv9nGFyeUcx/qxxLvHqlDrwcFXwpyhdc64txlR3PPg/7TP2snR57rv SrGtxlyPOoRqPkjJamf6nwLaPA/VD+PcAN92RAmbWFcorGoGgHyeUh/WY1wrPGjanptR DcsJ/Ik42jLHIo4a5/JTRjQzJP/uHYEeu1nKwBEhRsfsznjFK7yJLC+yV4SgvRKZm3j9 rKlQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1689137802; x=1691729802; 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=NXWQo3YZ5waoIYaiSNfc/xbrzJRmtM8qVgnIzTkEtOw=; b=FoJOuO3fhC/Is90ECUyPUsMxBlOKNxGWbQUAWH0tuiMCEm7Qt/tALKyFHUuq4Wze21 Vq39kQAoBdyjpTONr98RAiqflchi2gB99gJGX/QrVhgFBClr09QWDcheHwpQ0RZhlSb7 jLGmKI9yXdJimQCXyTaWgbIuXp3d8IeQYPdHorOGmkwrQAZ63168itvQCCJod7DXeMeG mh6V7OjKJFC090hNoPn2qCNcclbVhQT9qt3UCWi1Uir5PFnuuh3HBZBQSSzVPuUKtepu yNvKEcQHe5tiVcHo/J5Ah6LDhe35tqY8uzCOc23mqpnOfK42MXOzMj9O+Wmzi5N4Njey OXZg== X-Gm-Message-State: ABy/qLZ8MS7ivYZb7YfukpUWZo6mMy5EO3hSmw2VRakKCoQX9HmidxL2 pywse23FqX50hh4wXf9Xg+xdP+6BEq6bHUmyscRIWw== X-Google-Smtp-Source: APBJJlFyy8at53YGJjZ9VYFN2kkzNt9PYcFZce/TlpldQVwALuESIUcfWMI7dKKO6HOyStz0cOpNv6D9Q6k3NTfQXBc= X-Received: by 2002:a05:622a:1b91:b0:401:65d0:d9dc with SMTP id bp17-20020a05622a1b9100b0040165d0d9dcmr18447505qtb.40.1689137802690; Tue, 11 Jul 2023 21:56:42 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Ashesh Vashi Date: Wed, 12 Jul 2023 10:26:31 +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="000000000000b4d81c0600430a82" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000b4d81c0600430a82 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. > Did you restart the database server? -- Ashesh > > 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 > > > Thanks, > Sahil > --000000000000b4d81c0600430a82 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
= 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:
On= Tue, 11 Jul 2023 at 12:04, Ashesh Vashi <ashesh.vashi@enterprisedb.com> = wrote:
3D""
Try preloading the = extension in the PostgreSQL server.
e.g.=C2=A0 Add this extension in the= 'shared_preload_libraries' in postgresql.conf.

Reference:= =C2=A0https://pgpedia.info/s/shared_preload_librar= ies.html
Thank you, Ashesh! I will t= ry this and provide you with an update.
I tried adding 'system_stats' in the 'shared_preload_libr= aries', but it doesn't work.=C2=A0
Did you restart the database server?

-- Ashesh=C2= =A0

On Tue, 11 Jul 2023 at 14:38, Aditya Toshniwal <aditya.tosh= niwal@enterprisedb.com> wrote:
Disk info do= esn't need to be updated live. You can update it once on every tab chan= ge.=C2=A0I feel process info should be a bar chart. The categories are f= ixed in number and we can use StreamingChart for bar chart.
=C2=A0Okay sure.

Please= ignore the previous WIP.patch file. I missed to include few untracked chan= ges.
I have attached the new patch file. Sorry for the inconvenie= nce.

New patch consist:
  • Single d= ashboard with option to toggle between General and System Statistics
    • Summary tab (except process info details).=C2=A0
  • CPU Details
    • =
  • Memory Details

Thanks,
Sahil
--000000000000b4d81c0600430a82--