On Mon, 24 Jul 2023 at 10:30, Sahil Harpal <sahilharpal1...@gmail.com> wrote:
> On Mon, 24 Jul 2023 at 10:57, Ashesh Vashi <ashesh.va...@enterprisedb.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
