public inbox for [email protected]
help / color / mirror / Atom feedFrom: Khushboo Vashi <[email protected]>
To: Sahil Harpal <[email protected]>
Cc: [email protected]
Cc: Dave Page <[email protected]>
Cc: Aditya Toshniwal <[email protected]>
Cc: Akshay Joshi <[email protected]>
Cc: Ashesh Vashi <[email protected]>
Subject: Re: Pgadmin4 System Stats Extension Design
Date: Wed, 23 Aug 2023 11:51:13 +0530
Message-ID: <CAFOhELeBxSfF8PUk556R-cBoyvNrLkU3NDWhzbFbD1OQfp+xwA@mail.gmail.com> (raw)
In-Reply-To: <CAKi=nncpnEObc29MmGBAq58QKuFAdXrV7EDtf4Sp0QBuHV0Z4Q@mail.gmail.com>
References: <CAKi=nnc6Ze8QWBmSHe9YBYciWeDzMf=-rw9BgyNocFSokrpi6w@mail.gmail.com>
<CAKi=nneuTPLMppZaAm-Y1X=4mY3UnbkbJAMCHF=Fu-2+kateRg@mail.gmail.com>
<CAFOhELdhcYr9NBNrkEAWt_cwP77U2ANRK4xonqKA1p6WpMBdMA@mail.gmail.com>
<CAKi=nnfSoagHGwa4To7ND39Sb0qcUVBsL2HZB0X4d_4qAus2Nw@mail.gmail.com>
<CAKi=nndD92uV-RifeDJqs_3YV+ABWiN1_iMLUi7Zf1AaHzwM0w@mail.gmail.com>
<CAFOhELeVGiCarA9-AK_Wi9EpNxKrF4Ev7VNNQCD=LZy9OM0aqg@mail.gmail.com>
<CAKi=nncs=LaytGKL8muxfP--nXjdW4P+cdZW=RRprd4UZ3mMZQ@mail.gmail.com>
<CAKi=nncpnEObc29MmGBAq58QKuFAdXrV7EDtf4Sp0QBuHV0Z4Q@mail.gmail.com>
On Wed, Aug 23, 2023 at 12:44 AM Sahil Harpal <[email protected]>
wrote:
> Also. what should I use for labeling: mount_point or drive_letter? It's
> possible that the query might not return either of these values on some
> systems.
> For instance, in my case, it's returning values for drive_letter but null
> for mount_point. However, in the example provided (here
> <https://pgsnake.blogspot.com/2020/06/systemstats-extension-for-postgresql.html;),
> it's returning paths for mount_point and null for drive_letter.
>
Give first priority to Mount Point then drive letters (in most of the case
either of them will have value) and ignore if both are null.
>
> On Tue, 22 Aug 2023 at 23:34, Sahil Harpal <[email protected]>
> wrote:
>
>> On Mon, 21 Aug 2023 at 09:59, Khushboo Vashi <
>> [email protected]> wrote:
>>
>>> On Sat, Aug 19, 2023 at 4:21 PM Sahil Harpal <[email protected]>
>>> wrote:
>>>
>>>> On Thu, 10 Aug 2023 at 00:37, Sahil Harpal <[email protected]>
>>>> wrote:
>>>>
>>>>> 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.
>>>>>
>>>>> This may happen on Windows, can you try to fetch these details
>>> separately (not combining with other charts) only for Windows?
>>>
>>
>> I tried this, but it didn't work. I even created a separate endpoint to
>> fetch the data; however, it's still not working as expected. I believe it's
>> more of a server-side problem. I'm not entirely certain, but I think we're
>> executing the queries sequentially (Single threaded). This could be
>> preventing the updating of other graphs and tables.
>> Since the deadline is approaching, I'll first try to resolve other issues
>> and after that I'll look into this.
>>
>>>
>>>>> 1. Disk information -
>>>>> - Issue: The pg_sys_disk_info() query returns NULL value for
>>>>> some of the drive letters.
>>>>>
>>>>> If it returns NULL then do not show anything for that field for
>>> particular Disk.
>>>
>> For disk statistics, we have decided to use pie and bar charts, and we
>> need drive letters for labeling. I just observed that the query is now
>> returning drive letters for both SSD and HDD partitions, which were failing
>> earlier. Maybe it was my system's fault. However, there are still some
>> entries for which the drive letter is missing.
>> [image: image.png]
>> But as @Dave Page <[email protected]> suggested:
>> On Mon, 24 Jul 2023 at 15:34, Dave Page <[email protected]> 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).
>>>
>> Can I omit the rows with null values?
>>
>
Attachments:
[image/png] image.png (55.4K, 3-image.png)
download | view image
view thread (106+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: Pgadmin4 System Stats Extension Design
In-Reply-To: <CAFOhELeBxSfF8PUk556R-cBoyvNrLkU3NDWhzbFbD1OQfp+xwA@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox