查看表、索引等创建日志

snippet.sql
test=# SELECT * FROM pg_stat_last_operation;
 classid | objid | staactionname | stasysid | stausename | stasubtype |            statime            
---------+-------+---------------+----------+----------------+------------+-------------------------------
    1259 | 24677 | CREATE        |       10 |  gpadmin   | TABLE      | 2019-09-08 11:14:29.446554+08
    1259 | 24684 | CREATE        |       10 |  gpadmin   | TABLE      | 2019-09-08 11:14:29.467163+08
    1259 |  5007 | VACUUM        |       10 |  gpadmin   | REINDEX    | 2019-09-09 10:06:26.302672+08