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;















(13 rows)

sachi=#  select distinct actionname from  pg_stat_operations;







(4 rows)