public inbox for [email protected]
help / color / mirror / Atom feedFrom: Sahil Harpal <[email protected]>
To: Khushboo Vashi <[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: Tue, 22 Aug 2023 23:34:55 +0530
Message-ID: <CAKi=nncs=LaytGKL8muxfP--nXjdW4P+cdZW=RRprd4UZ3mMZQ@mail.gmail.com> (raw)
In-Reply-To: <CAFOhELeVGiCarA9-AK_Wi9EpNxKrF4Ev7VNNQCD=LZy9OM0aqg@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>
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=nncs=LaytGKL8muxfP--nXjdW4P+cdZW=RRprd4UZ3mMZQ@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