| From: | Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com> |
|---|---|
| To: | Sahil Harpal <sahilharpal1234(at)gmail(dot)com> |
| Cc: | Dave Page <dpage(at)pgadmin(dot)org>, Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com>, Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com>, Khushboo Vashi <khushboo(dot)vashi(at)enterprisedb(dot)com>, pgadmin-hackers(at)postgresql(dot)org |
| Subject: | Re: Pgadmin4 System Stats Extension Design |
| Date: | 2023-07-11 06:34:35 |
| Message-ID: | CAG7mmow-bPFycSZeY_-=JbhmdH7qHud2GHiiZTfcNPhnsruQaA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-hackers |
On Tue, Jul 11, 2023 at 11:58 AM Sahil Harpal <sahilharpal1234(at)gmail(dot)com>
wrote:
> Hi,
>
> I have written code for the Summary and CPU tabs and would like to post it
> here for review.
>
> I'm currently displaying the static values in the process info pie chart
> because of a minor bug. The pg_sys_process_info() query takes much longer
> (around 2 mins) to execute and prevents the updation of other graphs and
> tables. I tried adding it in separate useInterval with larger pollDelay,
> but it didn't work. In the patch, I commented out that snippet (In
> Summary.jsx).
>
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
-- Ashesh
>
> I'm attaching the *WIP.patch* file which contains the latest changes and
> also the SS of the Summary and CPU tabs.
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sahil Harpal | 2023-07-11 08:59:08 | Re: Pgadmin4 System Stats Extension Design |
| Previous Message | Sahil Harpal | 2023-07-11 06:28:29 | Re: Pgadmin4 System Stats Extension Design |