V$MYSTAT is a dynamic performance view in PolarDB for PostgreSQL (Compatible with Oracle) that returns performance and resource usage statistics for the current session.
Columns
| Column | Type | Description |
|---|---|---|
| SID | numeric | The unique ID of the current session. |
| STATISTIC# | numeric | The number of the statistic. |
| VALUE | numeric | The accumulated value of a specific statistical metric since the start of the session. |
Usage notes
Session scope:
V$MYSTATreturns data only for the current connected session. Statistics accumulate from the moment the session starts.Oracle compatibility: This view exposes three columns:
SID,STATISTIC#, andVALUE.