Greenplum系统表命令
查看表、索引等创建日志
- 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
打赏作者以资鼓励：
 |  |