Purpose
gv$partition_audit displays the partition-level performance statistics.
Fields
| Field | Type | Nullable? | Description |
|---|---|---|---|
| svr_ip | varchar(32) | NO | The IP address of the server. |
| svr_port | bigint(20) | NO | The port number of the OBServer node. |
| tenant_id | bigint(20) | NO | The ID of the tenant. |
| table_id | bigint(20) | NO | The ID of the table. |
| partition_id | bigint(20) | NO | The ID of the partition. |
| partition_status | bigint(20) | NO | The status of the partition. |
| base_row_count | bigint(20) | NO | The number of rows in the baseline data. This field is unavailable at present. |
| insert_row_count | bigint(20) | NO | The number of rows that have been inserted into the table or partition. |
| delete_row_count | bigint(20) | NO | The number of rows that have been deleted from the table or partition. |
| update_row_count | bigint(20) | NO | The number of rows that have been updated in the table or partition. |
| query_row_count | bigint(20) | NO | The number of rows that have been queried in the table or partition. This field is unavailable at present. |
| insert_sql_count | bigint(20) | NO | The number of INSERT statements that have been executed on the table or partition. |
| delete_sql_count | bigint(20) | NO | The number of DELETE statements that have been executed on the table or partition. |
| update_sql_count | bigint(20) | NO | The number of UPDATE statements that have been executed on the table or partition. |
| query_sql_count | bigint(20) | NO | The number of QUERY statements that have been executed on the table or partition. This field is unavailable at present. |
| trans_count | bigint(20) | NO | The number of times that transactions have been executed on the table or partition. |
| sql_count | bigint(20) | NO | The total number of SQL statements that have been executed on the table or partition. |
| rollback_insert_row_count | bigint(20) | NO | The number of rows that have been rolled back from INSERT operations on the table or partition. This field is unavailable at present. |
| rollback_delete_row_count | bigint(20) | NO | The number of rows that have been rolled back from DELETE operations on the table or partition. This field is unavailable at present. |
| rollback_update_row_count | bigint(20) | NO | The number of rows that have been rolled back from UPDATE operations on the table or partition. This field is unavailable at present. |
| rollback_insert_sql_count | bigint(20) | NO | The number of times that INSERT operations on the table or partition have been rolled back. This field is unavailable at present. |
| rollback_delete_sql_count | bigint(20) | NO | The number of times that DELETE operations on the table or partition have been rolled back. This field is unavailable at present. |
| rollback_update_sql_count | bigint(20) | NO | The number of times that UPDATE operations on the table or partition have been rolled back. This field is unavailable at present. |
| rollback_trans_count | bigint(20) | NO | The number of times that transactions on the table or partition have been rolled back. This field is unavailable at present. |
| rollback_sql_count | bigint(20) | NO | The number of times that SQL statements executed on the table or partition have been rolled back. This field is unavailable at present. |