MIME-Version: 1.0
References: 
 <CAKi=nneJvdbFyeDKnuQTVEnhNK0Zjdx5TWSwGUUSZO9YTC5E7Q@mail.gmail.com>
 <CANxoLDfO4BE0xvGLA3EBYyAzt3hCmuRcMY_pR3Zci9nPbL7P1Q@mail.gmail.com>
 <CAKi=nndnvAwgXVC=i=x3sSxNS9UCfks+EQWEjx8n5=u9CCP8og@mail.gmail.com>
 <CANxoLDeNzZkxYEnLdkFMkugvk7_k+BDSt6AoH83aaMkP+VZirQ@mail.gmail.com>
 <CAM9w-_mC2JKvxKKRwF7xCzoggoo0_XqBgUyqWDxXqSRQs_a0eg@mail.gmail.com>
 <CAKi=nncQ+OqkJ2PfvNNs40h5PfkO57YKTMEXdYeOpxUXhTzj5A@mail.gmail.com>
 <CA+OCxowriuEED8BC7DRZKwCM3dOfNaDWhf+vhJsH2PWq88yc7w@mail.gmail.com>
 <CAKi=nncY7wdMyqT2tKRAVWDaFSsgUS_qnOz0aifd-BorScUNSw@mail.gmail.com>
 <CA+OCxoyog3cqhZcEQ1xenmHUFMLM+VS8j91GM_RnU3VK8bGjaQ@mail.gmail.com>
 <CAKi=nncGiLTK36jQWnGL-0DToo4qTqojf+iLbDvRTfk2z_48Uw@mail.gmail.com>
 <CA+OCxowEmnWJHRa=QnuZpn42Cn594XZVduMPJuOg5MbdeQx0aw@mail.gmail.com>
 <CAKi=nnfMHZSGP3G+gS9JSLNp2C=BHF2ztsz6W0mpBREc4y=hiQ@mail.gmail.com>
 <CA+OCxowt2XSCEOxZ+Mz1CzMGQv5MCNV+GZO2b3E5PtZj1YgYOA@mail.gmail.com>
 <CAKi=nndoS4g8MmOBD6wZKCtGotpmxDa17rq8-obv3B9MaSbYjg@mail.gmail.com>
 <CA+OCxozjkCkVOFabHbMP+1sZ+hKftXA6Z8q00c+A2=mYHKbcuQ@mail.gmail.com>
 <CAKi=nncko8TQVyGtEn_89DtZoztdhOA_e2-wSe8wROjZADgbXg@mail.gmail.com>
 <CAKi=nnfj2OcTBkUoWwMZ5YifExgrxs9Pbt42-2W1+n32LEmgvQ@mail.gmail.com>
 <CAG7mmow-bPFycSZeY_-=JbhmdH7qHud2GHiiZTfcNPhnsruQaA@mail.gmail.com>
 <CAKi=nnfeEf6dQYcDyUExJK+1Xo5NgCHrpgfZPjS56B2rrUmd=w@mail.gmail.com>
 <CAM9w-_=-jmhjh9Mp98pvwBxp_DDoeMexnR2Y23+=-wR+tsDOiQ@mail.gmail.com>
 <CAKi=nneNLFiOUPQ16ZzO1RM8K8V=qoqa=AtmewkRzLjnjJhyUA@mail.gmail.com>
 <CAFOhELe-EAiVN6YjmAo1VjW-b+Bw3yPC6Ghxy=X6P-y4EF_EgA@mail.gmail.com>
 <CAKi=nndAi2iBN1P5y+XWdTa9EnL5b_FzhK4AG_9duUKxZE5=fw@mail.gmail.com>
 <CAKi=nndU8oESoER=MF7yaaUKiNd1fV7GDECGgLv_jumxs8EmTQ@mail.gmail.com>
 <CAFOhELdpnz1o-CYCmH=3x2u6XMWDXd6gbiWejL3dMq+LSu8QDQ@mail.gmail.com>
 <CAFOhELdT30L7OYj3MbQtkaHLHaRuMP3inV4t_wHkiJBOiJ=8TA@mail.gmail.com>
 <CAKi=nncg3M=ZE9JTzVYb-ox83quNO8i_=C3_34AhX1wckk0mbA@mail.gmail.com>
 <CAM9w-_=5Dnu4Dn9tg77GtAtaV7=vgyeSqkq0uLkt_c_K1Om2rg@mail.gmail.com>
 <CAKi=nncNHn9D8L-R3HmBPGN+zcBsbg_ceXE3O-XoASwMq-pzKg@mail.gmail.com>
 <CAM9w-_=KM9+onud=Co54voWNZXymOzzCkmMxfCjkU_-sNOOViQ@mail.gmail.com>
 <CAKi=nncRPLHwHZ+53vFuF7sB87tTLYXEbD4FPVnAbt8qhLonug@mail.gmail.com>
 <CAM9w-_nJWCnnQvXozGgrXVwhJwQ3hfeFZfKe+mKJHM5nox2AhA@mail.gmail.com>
 <CAKi=nndLpXnk8i+4XX=8UV_0Fc+VBCLtYbcE9QKsfOs+0ix-VA@mail.gmail.com>
In-Reply-To: 
 <CAKi=nndLpXnk8i+4XX=8UV_0Fc+VBCLtYbcE9QKsfOs+0ix-VA@mail.gmail.com>
From: Sahil Harpal <sahilharpal1234@gmail.com>
Date: Wed, 16 Aug 2023 08:29:58 +0530
Message-ID: 
 <CAKi=nnfe=LtOy8yTXZ6hdCW6buaxOCtOGB7+rWWCzOa9c+YdHg@mail.gmail.com>
Subject: Re: Pgadmin4 System Stats Extension Design
To: pgadmin-hackers@postgresql.org
Cc: Khushboo Vashi <khushboo.vashi@enterprisedb.com>,
	Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>,
	Ashesh Vashi <ashesh.vashi@enterprisedb.com>, Dave Page <dpage@pgadmin.org>,
	Akshay Joshi <akshay.joshi@enterprisedb.com>
Content-Type: multipart/alternative; boundary="00000000000059dab20603017e2b"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKi%3Dnnfe%3DLtOy8yTXZ6hdCW6buaxOCtOGB7%2BrWWCzOa9c%2BYdHg%40mail.gmail.com>
Precedence: bulk

--00000000000059dab20603017e2b
Content-Type: text/plain; charset="UTF-8"

Hi,
This email is regarding the recent patch I shared with you. Have you
encountered any issues or identified areas for improvement? Additionally,
could you assist me in resolving the challenges I'm currently facing and
provide suggestions for chart titles?

Thanks,
Sahil

On Thu, 10 Aug 2023 at 00:37, Sahil Harpal <sahilharpal1234@gmail.com>
wrote:

> Hi all,
>
> I have attached the updated patch with recent changes.
>
> New changes:
>
>    1. Displayed the appropriate message If the System Stat extension does
>    not exist.
>    2. Provided option to configure refresh rates for the API calls
>    (Preferences settings > Dashboards > Refresh rates).
>    3. Added I/O analysis of block devices under the storage tab.
>    4. Fixed PEP-8 errors.
>    5. Fixed the linter errors.
>    6. Moved all the system stats related .jsx files under a
>    seperate folder "dashboard/static/js/SystemStats".
>    7. Added formatter to convert disk sizes (in bytes) to human readable
>    format.
>
> Pending Work:
>
>    1. Process information -
>       - Issue: The pg_sys_process_info() query takes much longer (more
>       than 2 mins) to execute and prevents the updation of other graphs and
>       tables.
>    2. Disk information -
>       - Issue: The pg_sys_disk_info() query returns NULL value for some
>       of the drive letters.
>    3. StreamingChart -
>       - Issue: Graph shifting glitch. For the first time, graphs start
>       from the opposite side, and after the following API call or a few seconds
>       later, those get adjusted.
>
> I need suggestions for labels for different tables and charts. Also, could
> you please clarify the use of the counterData variable, which is used for
> some of the charts (tps_stats, ti_stats, to_stats, and bio_stats)?
>
> Thank you,
> Sahil
>
>

--00000000000059dab20603017e2b
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">Hi,<div>This email is regarding the recen=
t patch I shared with you. Have you encountered any issues or identified ar=
eas for improvement? Additionally, could you assist me in resolving the cha=
llenges I&#39;m currently facing and provide suggestions for chart titles?<=
/div><div><br></div><div>Thanks,</div><div>Sahil</div></div><br><img width=
=3D"0" height=3D"0" class=3D"mailtrack-img" alt=3D"" style=3D"display:flex"=
 src=3D"https://mailtrack.io/trace/mail/8d0e53f6d3b1b1bf7780351b95137242d8c=
13d67.png?u=3D8832852"><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D=
"gmail_attr">On Thu, 10 Aug 2023 at 00:37, Sahil Harpal &lt;<a href=3D"mail=
to:sahilharpal1234@gmail.com">sahilharpal1234@gmail.com</a>&gt; wrote:<br><=
/div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;bo=
rder-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr">Hi =
all,<div><br></div><div>I have attached the updated patch with recent=C2=A0=
changes.</div><div><br></div><div>New changes:</div><div><ol><li>Displayed =
the appropriate message If the System Stat extension does not exist.</li><l=
i>Provided option to configure refresh rates for the API calls (Preferences=
 settings &gt; Dashboards &gt; Refresh rates).</li><li>Added I/O analysis o=
f block devices under the storage tab.</li><li>Fixed PEP-8 errors.</li><li>=
Fixed the linter errors.</li><li>Moved all the system stats related .jsx fi=
les under a seperate=C2=A0folder &quot;dashboard/static/js/SystemStats&quot=
;.</li><li><span style=3D"font-family:verdana,sans-serif">Added formatter=
=C2=A0to convert disk sizes (in bytes) to human readable format.</span></li=
></ol></div>Pending Work:<div><ol><li>Process information -</li><ul><li>Iss=
ue: The pg_sys_process_info() query takes much longer (more than 2 mins) to=
 execute and prevents the updation of other graphs and tables.=C2=A0</li></=
ul><li>Disk information -</li><ul><li>Issue: The=C2=A0pg_sys_disk_info() qu=
ery returns NULL value for some of the drive letters.</li></ul><li>Streamin=
gChart -=C2=A0</li><ul><li>Issue: Graph shifting=C2=A0<span style=3D"font-f=
amily:verdana,sans-serif">glitch.</span>=C2=A0For the first time, graphs st=
art from the opposite side, and after the following API call or a few secon=
ds later, those get adjusted.</li></ul></ol><div>I need suggestions for lab=
els for different tables and charts. Also, could you please clarify the use=
 of the counterData variable, which is used for some of the charts (tps_sta=
ts, ti_stats, to_stats, and bio_stats)?<br></div></div><div><br></div><div>=
Thank you,</div><div>Sahil</div><br><img width=3D"0" height=3D"0" alt=3D"" =
style=3D"display: flex;" src=3D"data:image/gif;base64,R0lGODlhAQABAIAAAAAAA=
P///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7"></div>
</blockquote></div></div>

--00000000000059dab20603017e2b--