pg_stat_last_shoperation
The pg_stat_last_shoperation table contains metadata tracking information about global objects (roles, tablespaces, and so on).
| Column | Type | References | Description |
|---|---|---|---|
classid |
oid |
pg_class.oid |
OID of the system catalog containing the object |
objid |
oid |
any OID column |
OID of the object within its system catalog |
staactionname |
name |
— |
The action that was taken on the object |
stasysid |
oid |
pg_authid.oid |
A foreign key to |
stausename |
name |
— |
The name of the role that performed the operation on this object |
stasubtype |
text |
— |
The type of object operated on or the subclass of operation performed |
statime |
timestamp with time zone |
— |
The timestamp of the operation. This is the same timestamp that is written to the Greengage DB server log files in case you need to look up more detailed information about the operation in the logs |