|
|
|
|
|
|
VT_DISK_STORAGE monitors the amount of disk storage used by the database on each node.
Column Name |
Description |
TIMESTAMP |
a VARCHAR value containing the Linux system time of query execution in a format that can be used as a Date/Time Expression. |
NODE |
a VARCHAR value containing the name of the |
DISK_BLK_SIZE |
an INTEGER value containing the block size of the disk |
USED_BLKS |
an INTEGER value containing the number of disk blocks in use |
MB_USED |
an INTEGER value containing the number of megabytes of disk storage in use |
FREE_BLKS |
an INTEGER value containing the number of free disk blocks available |
MB_FREE |
an INTEGER value containing the number of megabytes of free storage available |
PERCENTAGE_FREE |
an INTEGER value containing the percentage of free disk space remaining |
Example
=> \pset expanded
=> SELECT * FROM VT_DISK_STORAGE;
-[ RECORD 1 ]---+--------------------
timestamp | 2007-12-05 23:15:45
node | site01
disk_blk_size | 4096
used_blks | 245869291
mb_used | 960426
free_blks | 77953370
mb_free | 304505
percentage_free | 31%
-[ RECORD 2 ]---+--------------------
timestamp | 2007-12-05 23:15:45
node | site02
disk_blk_size | 4096
used_blks | 245869291
mb_used | 960426
free_blks | 159819606
mb_free | 624295
percentage_free | 65%
-[ RECORD 3 ]---+--------------------
timestamp | 2007-12-05 23:15:45
node | site03
disk_blk_size | 4096
used_blks | 245869291
mb_used | 960426
free_blks | 163915783
mb_free | 640296
percentage_free | 66%
-[ RECORD 4 ]---+--------------------
timestamp | 2007-12-05 23:15:45
node | site04
disk_blk_size | 4096
used_blks | 245869291
mb_used | 960426
free_blks | 162976758
mb_free | 636627
percentage_free | 66%
node