public inbox for [email protected]
help / color / mirror / Atom feedFrom: Sahil Harpal <[email protected]>
To: [email protected]
Cc: Dave Page <[email protected]>
Cc: Aditya Toshniwal <[email protected]>
Cc: Akshay Joshi <[email protected]>
Cc: Ashesh Vashi <[email protected]>
Cc: Khushboo Vashi <[email protected]>
Subject: Re: Pgadmin4 System Stats Extension Design
Date: Wed, 23 Aug 2023 00:43:44 +0530
Message-ID: <CAKi=nncpnEObc29MmGBAq58QKuFAdXrV7EDtf4Sp0QBuHV0Z4Q@mail.gmail.com> (raw)
In-Reply-To: <CAKi=nncs=LaytGKL8muxfP--nXjdW4P+cdZW=RRprd4UZ3mMZQ@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>
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.
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: <CAKi=nncpnEObc29MmGBAq58QKuFAdXrV7EDtf4Sp0QBuHV0Z4Q@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