Greenplum System DBA quick command reference

1. Finding  object creation date

select * from pg_stat_operations where actionname='CREATE' and subtype='TABLE' and objname='<tablename>' and schemaname='<schemanane>';

Note: Above query can be used to find many other actions based on actionname and subtype.

sachi=# select distinct subtype from  pg_stat_operations;

  subtype  

-----------

 ROLE

 GRANT

 PASSWORD

 INHERIT

 SET

 TABLE

 SUPERUSER

 DATABASE

 RENAME

 REVOKE

 SCHEMA

 VIEW

(13 rows)

sachi=#  select distinct actionname from  pg_stat_operations;

 actionname 

------------

 ALTER

 PRIVILEGE

 ANALYZE

 CREATE

(4 rows)

sachi=#