This page provides information about the history of a table.
This consists of when the table was created, then all inserts, deletes, vacuums and analyzes.
The page currently does not show skipped vacuum operations, or aborted vacuum operations.
| Name | Type |
|---|---|
| event | varchar |
| notes | varchar |
| timestamp | timestamp |
| rows | int8 |
| user_id | int4 |
| user | varchar |
| xid | int8 |
| qid | int4 |
| related pages | varchar |
| Event | Description |
|---|---|
| create | The time the table was created. |
| delete | The DELETE command. |
| insert | The INSERT command. |
Notes about the event.
The time of the event.
Number of rows processed in the event.
The user ID. This column is emitted in CSV exports only.
The user name.
The transaction ID.
The query ID. This is really the WLM query ID; leader node queries have no query ID, at least, not that you see in the system tables. They do really have query IDs, of course, but they’re on the leader node only and they never show up in the system tables. All we see from the leader node are transaction IDs and process IDs.