How to find timestamp of table when it was created in Greenplum
Note: You can look OID of the table from pg_class and the do ls -l in the greenplum data directory to find table creation date.
sachi=# select oid,* from pg_class where relname ='abctest';
oid | relname | relnamespace | reltype | relowner | relam | relfilenode | reltablespace | relpages | reltuples | reltoastrelid | reltoastidxid | relaoseg
relid | relaosegidxid | relhasindex | relisshared | relkind | relstorage | relnatts | relchecks | reltriggers | relukeys | relfkeys | relrefs | relhasoids |
relhaspkey | relhasrules | relhassubclass | relfrozenxid | relacl | reloptions
--------+---------+--------------+---------+----------+-------+-------------+---------------+----------+-----------+---------------+---------------+---------
------+---------------+-------------+-------------+---------+------------+----------+-----------+-------------+----------+----------+---------+------------+-
-----------+-------------+----------------+--------------+--------+------------
113641 | abctest | 2200 | 113642 | 10 | 0 | 113641 | 0 | 1 | 3 | 0 | 0 |
0 | 0 | f | f | r | h | 1 | 0 | 0 | 0 | 0 | 0 | f |
f | f | f | 619248 | |
(1 row)
sachi=#
[gpadmin@sachi base]$ find . -name 113641
./16993/113641
[gpadmin@sachi base]$ ls -l ./16993/113641
-rw-------. 1 gpadmin gpadmin 32768 Nov 10 13:32 ./16993/113641
[gpadmin@sachi base]$
sachi=# select * from pg_stat_operations where actionname='CREATE' and subtype='TABLE' and objname='abctest' and schemaname='public';
classname | objname | objid | schemaname | usestatus | usename | actionname | subtype | statime
-----------+---------+--------+------------+-----------+---------+------------+---------+------------------------------
pg_class | abctest | 113641 | public | CURRENT | gpadmin | CREATE | TABLE | 2014-11-10 12:40:32.64053-05
(1 row)
sachi=#