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 1q9kfk-000777-0F for pgadmin-hackers@arkaria.postgresql.org; Thu, 15 Jun 2023 10:57:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1q9kfi-0008K6-M4 for pgadmin-hackers@arkaria.postgresql.org; Thu, 15 Jun 2023 10:57:46 +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 1q9kfi-0008Iy-Cu for pgadmin-hackers@lists.postgresql.org; Thu, 15 Jun 2023 10:57:46 +0000 Received: from mail-ed1-x533.google.com ([2a00:1450:4864:20::533]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1q9kff-002W2G-17 for pgadmin-hackers@postgresql.org; Thu, 15 Jun 2023 10:57:45 +0000 Received: by mail-ed1-x533.google.com with SMTP id 4fb4d7f45d1cf-51a20138617so1244692a12.2 for ; Thu, 15 Jun 2023 03:57:43 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=pgadmin.org; s=google; t=1686826662; x=1689418662; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=9y7el0cpivTY0zEa6G0yj9FPMY8Ynzh9ABSFRePnf+A=; b=l4kgzq1u5iZdRQhB47JewBb2ifC5U2UPsgNcCjiUv2e2pun2efuMB4rOM9oUfxP8uE Mtwu1QTAuF5tnYBDJFotyxRVWm4cRr1yRmeF4IHttxgNWGD5XcBpiZU3B3ap3Vl17if0 C5dH6cx8HfYPSqP0kuGG/WPazxqCj61GaoogU3+loQlBR8TdAACx51zfXfrD2jGdtJd5 FeEFcx03qeDmF9a+tYBo5kDPfmh1yOtroTxbCmwKwtLN5rA+XyYvqpKRgfBqhzPmHAHW TxaGFQx0svB5eJcfDNIp1sCaE0GG3qi0PTNfIhi9oiaN3MEfF7dxJW9SjIJfaJsojcOg 1P2Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1686826662; x=1689418662; 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=9y7el0cpivTY0zEa6G0yj9FPMY8Ynzh9ABSFRePnf+A=; b=HaiuZ1ZjyQf7g1GguWqIogaMbHrIkWi6XK1vy2NgESVTq6YjqoKJl8C1S9UsLtdB3Z DDrUnsEdg8HXEn+VU/Ga2Twxy0lczlDJLV3Mz8ZsJdvqZ7sQWyzdRatZZeeQ6q4v6s69 zYDbiYpU72rfcTb29j7qxaC6DdAfnZR2wR2aDlIdoJaGFyfWhOsjNoPjsIqnBPtVX1jR P7uO7fq0f4vZNuouWJzJ1rxsReiIL9rwfQpQSmd2fRMqCTkJ9pJR9m4j+6DuWD/q23jk enWyut+H+R0sTTQktl85seSov2L7U2AV67rhR95tf4VFzi6lcmRMRPQ5OvUFWxYLgiKf Q6Iw== X-Gm-Message-State: AC+VfDwhToi4JqzDLL60rc/Xghr8/TBy6F17ByDvyFwUj0mUEelAvvl2 GRr34OyiClBiPcNLZwXPGcMiHTOYcQ32RDElZ7jOCA== X-Google-Smtp-Source: ACHHUZ6rCmsWp+1Vx9i0Zu7cdvgKEMXZkOFQjuxVaRok1oxYwb9dB0UNCjENGbK/mRiQTH414kRrzOSzCm6QWVKH3Ec= X-Received: by 2002:a17:906:fd8d:b0:974:5124:497b with SMTP id xa13-20020a170906fd8d00b009745124497bmr19247823ejb.34.1686826662226; Thu, 15 Jun 2023 03:57:42 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Dave Page Date: Thu, 15 Jun 2023 11:57:30 +0100 Message-ID: Subject: Re: Pgadmin4 System Stats Extension Design To: Khushboo Vashi Cc: Sahil Harpal , Aditya Toshniwal , Akshay Joshi , pgadmin-hackers@postgresql.org Content-Type: multipart/alternative; boundary="00000000000000014d05fe28f033" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000000014d05fe28f033 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Thu, 15 Jun 2023 at 11:07, Khushboo Vashi < khushboo.vashi@enterprisedb.com> wrote: > Regarding I/O analysis, what would be more beneficial, combining total > read/total write etc., per disk OR Sahil doing a different graph for each > parameter for all the disks? > I think combining R/W is fine, as long as it uses two scales in case the values are wildly different (which is likely). > > On Thu, Jun 15, 2023 at 3:22=E2=80=AFPM Dave Page wro= te: > >> >> >> On Thu, 15 Jun 2023 at 09:55, Sahil Harpal >> wrote: >> >>> Hi Aditya, >>> >>> Thank you for pointing this out. It would also be more convenient for >>> users to navigate to specific statistics easily. >>> >>> So, can we finalise the following design? >>> - Single dashboard with buttons to toggle between General (existing >>> graphs/stats) and System Statistics. >>> >> >> Why use buttons and not tabs? Tabs are far more flexible as they can be >> re-arranged, docked differently etc. >> >> >>> - Clubbing OS, CPU, Process, Disk and I/O in tabbed control. >>> >> >> I think the current design has too much on one big page, so yes, I'd wan= t >> to see those split up onto different tabs. Not sure about the grouping >> though. Maybe: >> >> Summary (OS info, system specs etc) >> CPU >> Memory >> Storage (including I/O) >> >> Process info would be included on each tab as related to that tab's >> content - e.g. CPU per process on the CPU tab, memory per process on the >> memory tab, etc..) >> >> >>> Thanks, >>> Sahil >>> >>> >>> On Thu, 15 Jun 2023 at 11:21, Aditya Toshniwal < >>> aditya.toshniwal@enterprisedb.com> wrote: >>> >>>> Hi Sahil, >>>> >>>> I would suggest club OS, CPU, Process, Disk and I/O in a tabbed >>>> control. (Taking inspiration from the task manager). >>>> It will reduce the network calls, cluttering and improve DOM >>>> performance. >>>> >>>> >>>> On Thu, Jun 15, 2023 at 11:08=E2=80=AFAM Akshay Joshi < >>>> akshay.joshi@enterprisedb.com> wrote: >>>> >>>>> Hi Sahil >>>>> >>>>> On Thu, Jun 15, 2023 at 1:42=E2=80=AFAM Sahil Harpal < >>>>> sahilharpal1234@gmail.com> wrote: >>>>> >>>>>> Thank you, Akshay, for your feedback. >>>>>> Here are a few more designs that I have created based on the >>>>>> discussion with my mentors. I would love to know your thoughts on th= em. >>>>>> >>>>>> Design 1 - Using an additional new tab for system statistics >>>>>> Design 2 - Added buttons to toggle between existing dashboard data >>>>>> and system statistics. >>>>>> >>>>> >>>>> I personally like Design 2 as we have only one main tab >>>>> "Dashboard" and then two sub-tabs "General"(Can be changed) and "Syst= em >>>>> Statistics". >>>>> >>>>>> >>>>>> Thanks, >>>>>> Sahil >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> On Wed, 14 Jun 2023 at 10:12, Akshay Joshi < >>>>>> akshay.joshi@enterprisedb.com> wrote: >>>>>> >>>>>>> Hi Sahil >>>>>>> >>>>>>> At first glance, it looks good to me. Seems you have created a new >>>>>>> tab System Statistics instead of using the existing dashboard. >>>>>>> >>>>>>> On Tue, Jun 13, 2023 at 4:27=E2=80=AFPM Sahil Harpal < >>>>>>> sahilharpal1234@gmail.com> wrote: >>>>>>> >>>>>>>> Dear all, >>>>>>>> >>>>>>>> I am working on pgadmin4 to let users see their system-level >>>>>>>> statistics on the dashboard. In this mail, I've attached the wiref= rame to >>>>>>>> display system stats on the existing dashboard. >>>>>>>> >>>>>>>> I am open to hearing your thoughts and suggestions on the design. >>>>>>>> >>>>>>>> Thanks, >>>>>>>> Sahil >>>>>>>> >>>>>>> >>>> >>>> -- >>>> Thanks, >>>> Aditya Toshniwal >>>> pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com* >>>> >>>> "Don't Complain about Heat, Plant a TREE" >>>> >>> >> >> -- >> Dave Page >> Blog: https://pgsnake.blogspot.com >> Twitter: @pgsnake >> >> EDB: https://www.enterprisedb.com >> >> --=20 Dave Page Blog: https://pgsnake.blogspot.com Twitter: @pgsnake EDB: https://www.enterprisedb.com --00000000000000014d05fe28f033 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


=
On Thu, 15 Jun 2023 at 11:07, Khushbo= o Vashi <khushboo.vas= hi@enterprisedb.com> wrote:
Regarding I/O analysis, what would be more beneficial, combining total r= ead/total write etc., per disk OR Sahil doing a different graph for each pa= rameter=C2=A0for all the disks?

I thi= nk combining R/W is fine, as long as it uses two scales in case the values = are wildly different (which is likely).
=C2=A0

On= Thu, Jun 15, 2023 at 3:22=E2=80=AFPM Dave Page <dpage@pgadmin.org> wrote:
<= blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-l= eft-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);pa= dding-left:1ex">


On Thu, 15 Jun 2023 = at 09:55, Sahil Harpal <sahilharpal1234@gmail.com> wrote:
Hi Aditya,

Than= k you for pointing this out. It would also be more convenient for users to = navigate to specific statistics easily.

So, can we finalise the foll= owing design?
- Single dashboard with buttons to toggle between General = (existing graphs/stats) and System Statistics.

Why use buttons and not tabs? Tabs are far more f= lexible as they can be re-arranged, docked differently etc.
=C2= =A0
- Clubbing= OS, CPU, Process, Disk and I/O in tabbed control.

I think the current design has too much on one bi= g page, so yes, I'd want to see those split up onto different tabs. Not= sure about the grouping though. Maybe:

Summary (O= S info, system specs etc)
CPU
Memory
Storage = (including I/O)

Process info would be included on = each tab as related to that tab's content - e.g. CPU per process on the= CPU tab, memory per process on the memory tab, etc..)

=

Than= ks,
Sahil


On Thu, 15 Jun 2023 at 11:21, A= ditya Toshniwal <aditya.toshniwal@enterprisedb.com> wrote:
<= blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-l= eft-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);pa= dding-left:1ex">
Hi Sahil,

=
I would suggest club OS, CPU,= Process, Disk and I/O in a tabbed control. (Taking inspiration from the ta= sk manager).
It will red= uce the network calls, cluttering and improve DOM performance.


On Thu, Jun 15, 2023 at 11= :08=E2=80=AFAM Akshay Joshi <akshay.joshi@enterprisedb.com> wrote:
Hi=C2=A0Sahil
On Thu, = Jun 15, 2023 at 1:42=E2=80=AFAM Sahil Harpal <sahilharpal1234@gmail.com> wrot= e:
Thank y= ou, Akshay, for your feedback.=C2=A0
Here are a few more designs = that I have created based on the discussion with my mentors. I would love t= o know your thoughts=C2=A0on them.=C2=A0

Design 1 - Using= an additional new tab for system statistics
Design 2 - Added buttons to= toggle between existing dashboard data and system statistics.

=C2=A0 =C2=A0 I personally like D= esign 2 as we have only one main tab "Dashboard" and then two sub= -tabs "General"(Can be changed) and "System Statistics"= .=C2=A0=C2=A0
=
Thanks,
Sahil




3D""
=
On Wed, 14 Jun 2023 at 10:12, Akshay = Joshi <akshay.joshi@enterprisedb.com> wrote:
=
Hi=C2=A0Sahil

At first glance, it looks= good=C2=A0to me. Seems you have created a new tab System Statistics instea= d of using the existing dashboard.=C2=A0

On Tue, Jun 13, 2023 at 4:27= =E2=80=AFPM Sahil Harpal <sahilharpal1234@gmail.com> wrote:
Dear all,

I am working on pgad= min4 to let users see their system-level statistics on the dashboard. In th= is mail, I've attached the wireframe to display system stats on the exi= sting dashboard.

I am open to hearing your thoughts and s= uggestions on the design.

Thanks,
Sa= hil
3D""

--
Thanks,
Aditya Toshniwal
pgAdmin Hacker=C2=A0| Sr. Software Architect=C2=A0| enterprisedb.com

--
Dave Page
Blog: https://pgsnake.blogspot.com
Twitter: @pgsnake
=
EDB: https:/= /www.enterprisedb.com



--
Dave Page
Blog: https://pgsnake.blogspot.com
Twitter: @pgsnake
=
EDB: https:/= /www.enterprisedb.com

--00000000000000014d05fe28f033--