Re: Pgadmin4 System Stats Extension Design

On Mon, 24 Jul 2023 at 10:30, Sahil Harpal <sahilharpal1234(at)gmail(dot)com>
wrote:

> On Mon, 24 Jul 2023 at 10:57, Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com>
> wrote:
>
>> Please share the exact output of the query to get any suggestions.
>>
> The following is the output returned by the query:
>
> mount_point | file_system | drive_letter | drive_type | file_system_type
>> | total_space | used_space | free_space | total_inodes | used_inodes |
>> free_inodes
>> -------------+-------------+--------------+------------+------------------+--------------+--------------+--------------+--------------+-------------+-------------
>>
>> | NTFS | C: | 3 |
>> | 499350761472 | 86123380736 | 413227380736 | | |
>> | NTFS | | 3 |
>> | 633335808 | 543641600 | 89694208 | | |
>> | NTFS | | 3 |
>> | 500913139712 | 106947141632 | 393965998080 | | |
>> | NTFS | | 3 |
>> | 499288895488 | 237867192320 | 261421703168 | | |
>> | FAT32 | | 3 |
>> | 100663296 | 52180992 | 48482304 | | |
>> (5 rows)
>
>
>
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).

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

EDB: https://www.enterprisedb.com