pg_stat_operations
The view pg_stat_operations shows details about the last operation performed on a database object (such as a table, index, view or database) or a global object (such as a role).
| column | type | references | description |
|---|---|---|---|
classname |
text | The name of the system table in the pg_catalog schema where the record about this object is stored (pg_class=relations, pg_database=databases,pg_namespace=schemas, pg_authid=roles) |
|
objname |
name | The name of the object. | |
objid |
oid | The OID of the object. | |
schemaname |
name | The name of the schema where the object resides. | |
usestatus |
text | The status of the role who performed the last operation on the object (CURRENT=a currently active role in the system, DROPPED=a role that no longer exists in the system, CHANGED=a role name that exists in the system, but has changed since the last operation was performed). |
|
usename |
name | The name of the role that performed the operation on this object. | |
actionname |
name | The action that was taken on the object. | |
subtype |
text | The type of object operated on or the subclass of operation performed. | |
statime |
timestamptz | The timestamp of the operation. This is the same timestamp that is written to the LightDB-A Database server log files in case you need to look up more detailed information about the operation in the logs. |
Parent topic: System Catalogs Definitions