Re: Pgadmin4 System Stats Extension Design

From: Dave Page <dpage(at)pgadmin(dot)org>
To: Sahil Harpal <sahilharpal1234(at)gmail(dot)com>
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: Re: Pgadmin4 System Stats Extension Design
Date: 2023-06-19 14:33:17
Message-ID: CA+OCxoxdKvn+6Qr3GxQuV8fhAkzmo72+G+jbQqN+qYUT0dYQOg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

On Mon, 19 Jun 2023 at 15:30, Sahil Harpal <sahilharpal1234(at)gmail(dot)com>
wrote:

> On Fri, 16 Jun 2023 at 14:15, Sahil Harpal <sahilharpal1234(at)gmail(dot)com>
> wrote:
>
>> [image: image.gif]
>>
>>> I think combining R/W is fine, as long as it uses two scales in case the
>>> values are wildly different (which is likely).
>>
>>
>> So should I combine all the parameters (Total read/write operations,
>> Total Bytes read/write, and time spent) in a single graph for one disk or
>> just the total number of read/write operations?
>>
>
> Could you please also clarify this?
>

Don't combine ops/time/bytes etc, but you can combine read/write,
input/output etc. as we do on the existing graphs.

>
>
> On Fri, 16 Jun 2023 at 14:15, Sahil Harpal <sahilharpal1234(at)gmail(dot)com>
> wrote:
>
>> I think combining R/W is fine, as long as it uses two scales in case the
>>> values are wildly different (which is likely).
>>
>>
>> So should I combine all the parameters (Total read/write operations,
>> Total Bytes read/write, and time spent) in a single graph for one disk or
>> just the total number of read/write operations?
>> [image: Mailtrack]
>> <https://mailtrack.io?utm_source=gmail&utm_medium=signature&utm_campaign=signaturevirality11&> Sender
>> notified by
>> Mailtrack
>> <https://mailtrack.io?utm_source=gmail&utm_medium=signature&utm_campaign=signaturevirality11&> 16/06/23,
>> 14:14:28
>>
>> On Thu, 15 Jun 2023 at 16:27, Dave Page <dpage(at)pgadmin(dot)org> wrote:
>>
>>>
>>>
>>> On Thu, 15 Jun 2023 at 11:07, Khushboo Vashi <
>>> khushboo(dot)vashi(at)enterprisedb(dot)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 PM Dave Page <dpage(at)pgadmin(dot)org> wrote:
>>>>
>>>>>
>>>>>
>>>>> On Thu, 15 Jun 2023 at 09:55, Sahil Harpal <sahilharpal1234(at)gmail(dot)com>
>>>>> 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
>>>>> want 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(dot)toshniwal(at)enterprisedb(dot)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 AM Akshay Joshi <
>>>>>>> akshay(dot)joshi(at)enterprisedb(dot)com> wrote:
>>>>>>>
>>>>>>>> Hi Sahil
>>>>>>>>
>>>>>>>> On Thu, Jun 15, 2023 at 1:42 AM Sahil Harpal <
>>>>>>>> sahilharpal1234(at)gmail(dot)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 them.
>>>>>>>>>
>>>>>>>>> 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 "System
>>>>>>>> Statistics".
>>>>>>>>
>>>>>>>>>
>>>>>>>>> Thanks,
>>>>>>>>> Sahil
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> On Wed, 14 Jun 2023 at 10:12, Akshay Joshi <
>>>>>>>>> akshay(dot)joshi(at)enterprisedb(dot)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 PM Sahil Harpal <
>>>>>>>>>> sahilharpal1234(at)gmail(dot)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 wireframe 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*
>>>>>>> <https://www.enterprisedb.com/>
>>>>>>> "Don't Complain about Heat, Plant a TREE"
>>>>>>>
>>>>>>
>>>>>
>>>>> --
>>>>> 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
>>>
>>>

--
Dave Page
Blog: https://pgsnake.blogspot.com
Twitter: @pgsnake

EDB: https://www.enterprisedb.com

In response to

Browse pgadmin-hackers by date

  From Date Subject
Next Message Sahil Harpal 2023-06-19 15:11:23 Re: Pgadmin4 System Stats Extension Design
Previous Message Sahil Harpal 2023-06-19 14:29:58 Re: Pgadmin4 System Stats Extension Design