pg_stat_operations

The pg_stat_operations view 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 Description

Column	Type	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. `pg_tablespace` — tablespaces. `pg_resqueue` — resource queues.
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 that 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 whose definition 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 Greengage DB server log files in case you need to look up more detailed information about the operation in the logs

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.
pg_tablespace — tablespaces.
pg_resqueue — resource queues.

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 that 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 whose definition 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 Greengage DB server log files in case you need to look up more detailed information about the operation in the logs

pg_stat_all_tables

pg_stat_partition_operations