Re: Pgadmin4 System Stats Extension Design

From: Sahil Harpal <sahilharpal1234(at)gmail(dot)com>
To: Dave Page <dpage(at)pgadmin(dot)org>
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: Re: Pgadmin4 System Stats Extension Design
Date: 2023-06-19 14:29:58
Message-ID: CAKi=nnethJYSReJ3BB6M+jjkb=9qo-g4uOT5BkhcoDzRA1RjpA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

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?

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
>>
>>

In response to

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Dave Page 2023-06-19 14:33:17 Re: Pgadmin4 System Stats Extension Design
Previous Message Nikhil Mohite 2023-06-19 14:07:22 [pgadmin-org/pgadmin4] 4746fb: Fixed an issue where View/Edit data is throwing an...