How to check table creation time in Greenplum

posted Apr 28, 2017, 12:07 PM by Sachchida Ojha
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)
Comments