pg_stat_partition_operations

The pg_stat_partition_operations view shows details about the last operation performed on a partitioned table.

Table 1. pg_catalog.pg_stat_partition_operations

column	type	description
`classname`	text	The name of the system table in the `pg_catalog` schema where the record about this object is stored (always `pg_class` for tables and partitions).
`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 its 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`	timestamp with time zone	The timestamp of the operation. This is the same timestamp that is written to the HAWQ server log files in case you need to look up more detailed information about the operation in the logs.
`partitionlevel`	smallint	The level of this partition in the hierarchy.
`parenttablename`	name	The relation name of the parent table one level up from this partition.
`parentschemaname`	name	The name of the schema where the parent table resides.
`parent_relid`	oid	The OID of the parent table one level up from this partition.