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

From Sahil Harpal
Subject Re: Pgadmin4 System Stats Extension Design
Date
Msg-id CAKi=nnfeEf6dQYcDyUExJK+1Xo5NgCHrpgfZPjS56B2rrUmd=w@mail.gmail.com
Whole thread Raw
In response to Re: Pgadmin4 System Stats Extension Design  (Ashesh Vashi <ashesh.vashi@enterprisedb.com>)
Responses Re: Pgadmin4 System Stats Extension Design
List pgadmin-hackers
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.
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.   
Attachment

pgadmin-hackers by date:

Previous
From: Ashesh Vashi
Date:
Subject: Re: Pgadmin4 System Stats Extension Design
Next
From: Aditya Toshniwal
Date:
Subject: Re: Pgadmin4 System Stats Extension Design