Postgres Pro
Downloads
Home   >   mailing lists

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

From Ashesh Vashi
Subject Re: Pgadmin4 System Stats Extension Design
Date
Msg-id CAG7mmow-bPFycSZeY_-=JbhmdH7qHud2GHiiZTfcNPhnsruQaA@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
Tree view
On Tue, Jul 11, 2023 at 11:58 AM Sahil Harpal <sahilharpal1234@gmail.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.

pgadmin-hackers by date:

Previous
From: Sahil Harpal
Date:
Subject: Re: Pgadmin4 System Stats Extension Design
Next
From: Sahil Harpal
Date:
Subject: Re: Pgadmin4 System Stats Extension Design