Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qNsQb-006Dga-ED for pgadmin-hackers@arkaria.postgresql.org; Mon, 24 Jul 2023 10:04:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qNsQZ-009G7u-Jl for pgadmin-hackers@arkaria.postgresql.org; Mon, 24 Jul 2023 10:04:31 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qNsQY-009G7l-Jw for pgadmin-hackers@lists.postgresql.org; Mon, 24 Jul 2023 10:04:31 +0000 Received: from mail-ej1-x630.google.com ([2a00:1450:4864:20::630]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qNsQQ-001C0s-KB for pgadmin-hackers@postgresql.org; Mon, 24 Jul 2023 10:04:28 +0000 Received: by mail-ej1-x630.google.com with SMTP id a640c23a62f3a-977e0fbd742so672630266b.2 for ; Mon, 24 Jul 2023 03:04:22 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=pgadmin.org; s=google; t=1690193060; x=1690797860; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=jf+KMJOjaRFhctXeQpKEjxq86wxYGL5OyKVkXLlivGA=; b=GCZrGnbMj/1VIRUHjydty++OZq8TqF635BcyARjaQ+V1LQsYIPbSd+KV+jKW44aDn1 IenTfkzJHcfYimf7w2yz1uyDvzLhL7CuCVkhmJZXdc2b2CBjjU1Wujf56O6qK03tDSo9 FeTUw+5iPhJ0LVFjHLup2fSLkP4qUGrawtJb4WkDQb1p9PKpOTyF/ulrDkNwhemsZQUL bkDcyNOGIANFHD7qBb0WB97QYEVuu8hn3ZqFZMYFZHG3mkGNNIakqw31Ee0xBLvbOTEf iQD+Ss1Kt2TLQin089axh8eJC48rm9UXVlfgnYzMEGdiKCjyz4QPztwyEoI8QZkaHtH+ JCjA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1690193060; x=1690797860; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=jf+KMJOjaRFhctXeQpKEjxq86wxYGL5OyKVkXLlivGA=; b=aXxCEnpHuwX0eBA5f+T2MsZ5CH8I1AuA9u/Y4i5EwHLIw2BnlNSetBAKTbF55FtcPA G3krLFUiBp+WuvvZqd4BWK85LJklfE9QLCzfQ56lQEs8DggOE6/L2XbK8/y0sElj+fFG FCilBUA+UxJyB3kQAvJtS9vV2zYixdstghxPdgXlJW0foTbbnEiJ31Q8SYYhpGlY5DZu FOezBvGy08CPKBJ4pFqGWzMaaHkxJhTr8J3Ha/p6eMwcOkN9+JS5rifeUgDLnf65Gul+ +kl4HPmeVF9KrrdTomRgrtAX9DVDafogRn8oLAr50nIeSI5SB7mNtUc7JOGCwy9HpKWo lrEg== X-Gm-Message-State: ABy/qLY3osU3+wj1QQ8Qb91aYuUTSSGAvmKxmsDUGDPup9xVESgAoGMK rU7tDJSCSeS/oueslXnlx0K0DExFoFNTozxR5HzdFw== X-Google-Smtp-Source: APBJJlEMZFKQVmCKdsDe+yTE5zoFBtbHC+tmxgRaBROm+t0YSmLU1h2jyxuK7oA6XQvleFB93GrvGeiI96XnJ62jiKs= X-Received: by 2002:a17:907:2713:b0:993:fe68:569d with SMTP id w19-20020a170907271300b00993fe68569dmr7908352ejk.17.1690193060288; Mon, 24 Jul 2023 03:04:20 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Dave Page Date: Mon, 24 Jul 2023 11:04:09 +0100 Message-ID: Subject: Re: Pgadmin4 System Stats Extension Design To: Sahil Harpal Cc: Ashesh Vashi , pgadmin-hackers@postgresql.org, Khushboo Vashi , Aditya Toshniwal , Akshay Joshi Content-Type: multipart/alternative; boundary="000000000000f5eee1060138bc36" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000f5eee1060138bc36 Content-Type: text/plain; charset="UTF-8" On Mon, 24 Jul 2023 at 10:30, Sahil Harpal wrote: > On Mon, 24 Jul 2023 at 10:57, Ashesh Vashi > 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 --000000000000f5eee1060138bc36 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


=
On Mon, 24 Jul 2023 at 10:30, Sahil H= arpal <sahilharpal1234@gmai= l.com> wrote:
On Mon, 24 Jul 2023 at 10:57, Ashesh Vashi <ashesh.vashi@enterprisedb.com<= /a>> wrote:
3D""
Please share the exact output of the query to get any suggestions.
The following is the= output returned by the query:

=C2= =A0mount_point | file_system | drive_letter | drive_type | file_system_type= | total_space =C2=A0| =C2=A0used_space =C2=A0| =C2=A0free_space =C2=A0| to= tal_inodes | used_inodes | free_inodes =C2=A0 =C2=A0
-------------+-----= --------+--------------+------------+------------------+--------------+----= ----------+--------------+--------------+-------------+------------- =C2=A0=
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| NTFS =C2=A0 =C2=A0 = =C2=A0 =C2=A0| C: =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A03 | =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0| 499350761472 | =C2=A086123380736 | 413227380736 | =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = |
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| NTFS =C2=A0 =C2=A0 = =C2=A0 =C2=A0| =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A03 | =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0| =C2=A0 =C2=A0633335808 | =C2=A0 =C2=A0543641600 | =C2=A0= =C2=A0 89694208 | =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 |
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0| NTFS =C2=A0 =C2=A0 =C2=A0 =C2=A0| =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0| =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A03 | =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| 500913139712 | 106947= 141632 | 393965998080 | =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 |
=C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0| NTFS =C2=A0 =C2=A0 =C2=A0 =C2=A0| =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A03 | =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| 499288895488 |= 237867192320 | 261421703168 | =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0| =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 |
=C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0| FAT32 =C2=A0 =C2=A0 =C2=A0 | =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A03 | = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| =C2=A0 =C2= =A0100663296 | =C2=A0 =C2=A0 52180992 | =C2=A0 =C2=A0 48482304 | =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 |
(5 rows)

=

On your system, what are the volu= mes without letters etc? If they're things like swap/pagefile, recovery= partition etc, then they can probably be omitted (e.g. SELECT ... WHERE mo= unt_point IS NOT NULL OR drive_letter IS NOT NULL).

--
--000000000000f5eee1060138bc36--