filerep_*
The filerep*
tables store high-availability file replication process information for a Greenplum Database instance. There are three filerep tables, all having the same columns:
-
filerep_now
is an external table whose data files are stored in$MASTER_DATA_DIRECTORY/gpperfmon/data
. Current file replication data is stored infilerep_now
during the period between data collection from the Command Center agents and automatic commitment to thefilerep_history
table. -
filerep_tail
is an external table whose data files are stored in$MASTER_DATA_DIRECTORY/gpperfmon/data
. This is a transitional table for file replication data that has been cleared fromfilerep_now
but has not yet been committed tofilerep_history
. It typically only contains a few minutes worth of data. -
filerep_history
is a regular table that stores historical database-wide file replication data. It is pre-partitioned into monthly partitions. Partitions are automatically added in two month increments as needed. Administrators must drop old partitions for the months that are no longer needed.
Column | Type | Description |
---|---|---|
ctime |
timestamp | Time this row was created. |
primary_measurement_microsec |
bigint | The length of time over which primary metrics (contained in UDP messages) were gathered. |
mirror_measurement_microsec |
bigint | The length of time over which mirror metrics (contained in UDP messages) were gathered. |
primary_hostname |
varchar(64) | The name of the primary host. |
primary_port |
int | The port number of the primary host. |
mirror_hostname |
varchar(64) | The name of the mirror host. |
mirror_port |
int | The port number of the mirror host. |
primary_write_syscall_bytes_avg |
bigint | The average amount of data written to disk on the primary for write system calls per interval. |
primary_write_syscall_byte_max |
bigint | The maximum amount of data written to disk on the primary for write system calls per interval. |
primary_write_syscall_microsecs_avg |
bigint | The average time required for a write system call to write data to disk on the primary per interval. |
primary_write_syscall_microsecs_max |
bigint | The maximum time required for a write system call to write data to disk on the primary per interval. |
primary_write_syscall_per_sec |
double precision | The number of write system calls on the primary per second. It reflects only the time to queue the write to disk in memory. |
primary_fsync_syscall_microsec_avg |
bigint | The average amount of time required for a file sync system call to write data to disk on the primary per interval. |
primary_fsync_syscall_microsec_max |
bigint | The maximum amount of time required for a file sync system call to write data to disk on the primary per interval. |
primary_fsync_syscall_per_sec |
double precision | The number of file sync system calls on the primary per second. Unlike write system calls which return immediately after the data is posted/queued, file sync system calls wait for all outstanding writes to be written to disk. File sync system call values in this column reflect actual disk access times for potentially large amounts of data. |
primary_write_shmem_bytes_avg |
bigint | The average amount of data written to shared memory on the primary per interval. |
primary_write_shmem_bytes_max |
bigint | The maximum amount of data written to shared memory on the primary per interval. |
primary_write_shmem_microsec_avg |
bigint | The average amount of time required to write data to shared memory on the primary per interval. |
primary_write_shmem_microsec_max |
bigint | The maximum amount of time required to write data to shared memory on the primary per interval. |
primary_write_shmem_per_sec |
double precision | The number of writes to shared memory on the primary per second. |
primary_fsync_shmem_microsec_avg |
bigint | The average amount of time required by the file sync system call to write data to shared memory on the primary per interval. |
primary_fsync_shmem_microsec_max |
bigint | The maximum amount of time required by the file sync system call to write data to shared memory on the primary per interval. |
primary_fsync_shmem_per_sec |
double precision | The number of file sync calls to shared memory on the primary per second. File sync system call values in this column reflect actual disk access times for potentially large amounts of data. |
primary_write_shmem_per_sec |
double precision | The number of writes to shared memory on the primary per second. |
primary_fsync_shmem_microsec_avg |
bigint | The average amount of time required by the file sync system call to write data to shared memory on the primary per interval. |
primary_fsync_shmem_microsec_max |
bigint | The maximum amount of time required by the file sync system call to write data to shared memory on the primary per interval. |
primary_fsync_shmem_per_sec |
double precision | The number of file sync calls to shared memory on the primary per second. File sync system call values in this column reflect actual disk access times for potentially large amounts of data. |
primary_roundtrip_fsync_msg_microsec_avg |
bigint | The average amount of time required for a roundtrip file sync between the primary and the mirror per interval. This includes:
|
primary_roundtrip_fsync_msg_microsec_max |
bigint | The maximum amount of time required for a roundtrip file sync between the primary and the mirror per interval. This includes:
|
primary_roundtrip_fsync_msg_per_sec |
double precision | The number of roundtrip file syncs per second. |
primary_roundtrip_test_msg_microsec_avg |
bigint | The average amount of time required for a roundtrip test message between the primary and the mirror to complete per interval. This is similar to |
primary_roundtrip_test_msg_microsec_max |
bigint | The maximum amount of time required for a roundtrip test message between the primary and the mirror to complete per interval. This is similar to |
primary_roundtrip_test_msg_per_sec |
double precision | The number of roundtrip file syncs per second. This is similar to Note that test messages typically occur once per minute, so it is common to see a value of “0” for time periods not containing a test message. |
mirror_write_syscall_size_avg |
bigint | The average amount of data written to disk on the mirror for write system calls per interval. |
mirror_write_syscall_size_max |
bigint | The maximum amount of data written to disk on the mirror for write system calls per interval. |
mirror_write_syscall_microsec_avg |
bigint | The average time required for a write system call to write data to disk on the mirror per interval. |
mirror_write_syscall_microsec_max |
bigint | The maximum time required for a write system call to write data to disk on the mirror per interval. |
primary_roundtrip_test_msg_per_sec |
double precision | The number of roundtrip file syncs per second. This is similar to Note that test messages typically occur once per minute, so it is common to see a value of “0” for time periods not containing a test message. |
mirror_write_syscall_size_avg |
bigint | The average amount of data written to disk on the mirror for write system calls per interval. |
mirror_write_syscall_size_max |
bigint | The maximum amount of data written to disk on the mirror for write system calls per interval. |
mirror_write_syscall_microsec_avg |
bigint | The average time required for a write system call to write data to disk on the mirror per interval. |