PG_OBJECT records the user creation, creation time, last modification time, and last analyzing time of objects of specified types (types existing in object_type).
Name |
Type |
Description |
---|---|---|
object_oid |
oid |
Object identifier. |
object_type |
"char" |
Object type:
|
creator |
oid |
ID of the creator. |
ctime |
timestamp with time zone |
Object creation time. |
mtime |
timestamp with time zone |
Time when the object was last modified. By default, the ALTER, COMMENT, GRANT, REVOKE, and TRUNCATE operations are recorded. If light_object_mtime is configured for behavior_compat_options, the GRANT, REVOKE, and TRUNCATE operations are not recorded. |
last_analyze_time |
timestamp with time zone |
Time when an object is analyzed for the last time. |