How to check table creation time in Greenplum

Post date: Sep 19, 2014 3:4:49 PM

sachi=# create table sachi3(abc text);

NOTICE:  Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'abc' as the Greenplum Database data distribution key for this table.

HINT:  The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew.

CREATE TABLE

sachi=# select * from pg_stat_last_operation where objid = 'sachi3' ::regclass order by statime;

 classid | objid | staactionname | stasysid | stausename | stasubtype |            statime            

---------+-------+---------------+----------+------------+------------+-------------------------------

    1259 | 52386 | CREATE        |       10 | gpadmin    | TABLE      | 2014-09-19 10:54:58.753318-04

(1 row)