pg_stat_operations

A newer version of this documentation is available. Click here to view the most up-to-date release of the Greenplum 4.x documentation.

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).

Table 1. pg_catalog.pg_stat_operations

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

timestampz

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.