Re: Pgadmin4 System Stats Extension Design - Mailing list pgadmin-hackers

From Aditya Toshniwal
Subject Re: Pgadmin4 System Stats Extension Design
Date
Msg-id CAM9w-_=-jmhjh9Mp98pvwBxp_DDoeMexnR2Y23+=-wR+tsDOiQ@mail.gmail.com
Whole thread Raw
In response to Re: Pgadmin4 System Stats Extension Design  (Sahil Harpal <sahilharpal1234@gmail.com>)
Responses Re: Pgadmin4 System Stats Extension Design
List pgadmin-hackers
Hi Sahil,

On Tue, Jul 11, 2023 at 2:29 PM Sahil Harpal <sahilharpal1234@gmail.com> wrote:
On Tue, 11 Jul 2023 at 12:04, Ashesh Vashi <ashesh.vashi@enterprisedb.com> 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.

On Tue, 11 Jul 2023 at 12:39, Aditya Toshniwal <aditya.toshniwal@enterprisedb.com> wrote:
Hi Sahil, 

Just to mention, make sure you're not using any chart component other than StreamingChart if the data is frequently updated.
We have faced performance issues for continuously updating charts with Chart.js.

Also, as Aditya has mentioned, yeah, it will definitely affect the performance, as re-rendering the charts would be costly. So, would love to know suggestions for Disk info and Process info, as we have decided to use pie and bar charts over there.
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 chart.
Either we can reload the charts only when the tab changes, or we can use StreamingChart for them too?

Also, currently, StreamingChart is not formatting the axis values and takes much space in case of larger values eg. memory_usage, handle_count etc. Can we add a custom formatter for y-axis values? I have attached the images for the same.   
Sure, you can tweak StreamingChart. 


--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Sr. Software Architect | enterprisedb.com
"Don't Complain about Heat, Plant a TREE"

pgadmin-hackers by date:

Previous
From: Sahil Harpal
Date:
Subject: Re: Pgadmin4 System Stats Extension Design
Next
From: Khushboo Vashi
Date:
Subject: [pgadmin-org/pgadmin4] 20ad30: Return to the old version 1.26.* of urllib3 as bot...