Re: Pgadmin4 System Stats Extension Design

Hi Sahil,

On Tue, Jul 11, 2023 at 2:29 PM Sahil Harpal <sahilharpal1234(at)gmail(dot)com>
wrote:

> On Tue, 11 Jul 2023 at 12:04, Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)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(dot)toshniwal(at)enterprisedb(dot)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*
<https://www.enterprisedb.com/>
"Don't Complain about Heat, Plant a TREE"