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=nne6k2kX7dCzB7W+i=ujerEpjMz-OXqWQiDTfw45n_97Sw@mail.gmail.com>
 <CAKi=nnd_PmMYZcUc-w=WonKVRUS8_Nahb7NWXt6seASYOq-YrA@mail.gmail.com>
 <CAG7mmoxS3G8ug+fk9TYW66NepPUkiD8WTsLPrvegnqjh4sa8nw@mail.gmail.com>
 <CAKi=nnf2et4hT9vaov0fW4BD5=4PCvx1kiJhE4L58b4hGJcNEA@mail.gmail.com>
 <CA+OCxozmepfMAj0FZw3cqkv7AoP7iQ0C5fs0RNnzR3ExfkB4uw@mail.gmail.com>
 <CAKi=nndte7KfnnP4YATDekf9aDFWiDwq3VLC-Gf_1F9vg6zORg@mail.gmail.com>
In-Reply-To: 
 <CAKi=nndte7KfnnP4YATDekf9aDFWiDwq3VLC-Gf_1F9vg6zORg@mail.gmail.com>
From: Dave Page <dpage@pgadmin.org>
Date: Mon, 24 Jul 2023 12:09:01 +0100
Message-ID: 
 <CA+OCxowLQo=JASFaNsjTw+EQjVQGJ9T-GVnVh0_Jgn2poWZ_Qw@mail.gmail.com>
Subject: Re: Pgadmin4 System Stats Extension Design
To: Sahil Harpal <sahilharpal1234@gmail.com>
Cc: Ashesh Vashi <ashesh.vashi@enterprisedb.com>,
 pgadmin-hackers@postgresql.org,
	Khushboo Vashi <khushboo.vashi@enterprisedb.com>,
	Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>,
	Akshay Joshi <akshay.joshi@enterprisedb.com>
Content-Type: multipart/alternative; boundary="000000000000fe4f99060139a471"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2BOCxowLQo%3DJASFaNsjTw%2BEQjVQGJ9T-GVnVh0_Jgn2poWZ_Qw%40mail.gmail.com>
Precedence: bulk

--000000000000fe4f99060139a471
Content-Type: text/plain; charset="UTF-8"

On Mon, 24 Jul 2023 at 11:47, Sahil Harpal <sahilharpal1234@gmail.com>
wrote:

> On Mon, 24 Jul 2023 at 15:34, Dave Page <dpage@pgadmin.org> wrote:
>
>> On your system, what are the volumes without letters etc? If they're
>> things like swap/pagefile, recovery partition etc, then they can probably
>> be omitted (e.g. SELECT ... WHERE mount_point IS NOT NULL OR drive_letter
>> IS NOT NULL).
>>
>
>  On my system, the SSD is assigned the letter C, and I have partitioned my
> HDD into two partitions with the letters F and G.
>

OK, so F and G are not being shown in the query results (or more correctly,
they are there, but the drive letter is showing as NULL?). If so, that
seems like a bug in the extension.

-- 
Dave Page
Blog: https://pgsnake.blogspot.com
Twitter: @pgsnake

EDB: https://www.enterprisedb.com

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

<div dir=3D"ltr"><div dir=3D"ltr"><br></div><br><div class=3D"gmail_quote">=
<div dir=3D"ltr" class=3D"gmail_attr">On Mon, 24 Jul 2023 at 11:47, Sahil H=
arpal &lt;<a href=3D"mailto:sahilharpal1234@gmail.com">sahilharpal1234@gmai=
l.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"ma=
rgin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border=
-left-color:rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div dir=3D=
"ltr">On Mon, 24 Jul 2023 at 15:34, Dave Page &lt;<a href=3D"mailto:dpage@p=
gadmin.org" target=3D"_blank">dpage@pgadmin.org</a>&gt; wrote:<br></div><im=
g width=3D"0" height=3D"0" alt=3D"" style=3D"display: flex;" src=3D"https:/=
/mailtrack.io/trace/mail/cf8856bdb4bb07c55716e4bd5b166e45a0f3061d.png?u=3D8=
832852"><div class=3D"gmail_quote"><blockquote class=3D"gmail_quote" style=
=3D"margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;=
border-left-color:rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div>=
On your system, what are the volumes without letters etc? If they&#39;re th=
ings like swap/pagefile, recovery partition etc, then they can probably be =
omitted (e.g. SELECT ... WHERE mount_point IS NOT NULL OR drive_letter IS N=
OT NULL).</div></div></blockquote><div><br></div><div>=C2=A0On my system, t=
he SSD is assigned the letter C, and I have partitioned my HDD into two par=
titions with the letters F and G.<br></div></div></div>
</blockquote></div><br clear=3D"all"><div>OK, so F and G are not being show=
n in the query results (or more correctly, they are there, but the drive le=
tter is showing as NULL?). If so, that seems like a bug in the extension.</=
div><div><br></div><span class=3D"gmail_signature_prefix">-- </span><br><di=
v dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr">Dave Page<br>Blog:=
 <a href=3D"https://pgsnake.blogspot.com" target=3D"_blank">https://pgsnake=
.blogspot.com</a><br>Twitter: @pgsnake<br><br>EDB: <a href=3D"https://www.e=
nterprisedb.com" target=3D"_blank">https://www.enterprisedb.com</a><br><br>=
</div></div></div>

--000000000000fe4f99060139a471--