The pg_stat_last_shoperation table contains metadata tracking information about global objects (roles, tablespaces, etc.).

    columntypereferencesdescription
    classidoidpg_class.oidOID of the system catalog containing the object.
    objidoidany OID columnOID of the object within its system catalog.
    staactionnamename The action that was taken on the object.
    stasysidoid  
    stausenamename The name of the role that performed the operation on this object.
    stasubtypetext The type of object operated on or the subclass of operation performed.
    statimetimestamp with timezone The timestamp of the operation. This is the same timestamp that is written to the Greenplum 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