Greenplum System DBA quick command reference

The gadget spec URL could not be found
The gadget spec URL could not be found
1. Finding  object creation date

select * from pg_stat_operations where actionname='CREATE' and subtype='TABLE' and objname='<tablename>' and schemaname='<schemanane>';

Note: Above query can be used to find many other actions based on actionname and subtype.

sachi=# select distinct subtype from  pg_stat_operations;
  subtype  
-----------
 ROLE
 GRANT
 PASSWORD
 INHERIT
 SET
 TABLE
 SUPERUSER
 DATABASE
 RENAME
 REVOKE
 SCHEMA
 VIEW
(13 rows)
The gadget spec URL could not be found
sachi=#  select distinct actionname from  pg_stat_operations;
 actionname 
------------
 ALTER
 PRIVILEGE
 ANALYZE
 CREATE
(4 rows)

sachi=# 
The gadget spec URL could not be found

The gadget spec URL could not be found

The gadget spec URL could not be found

Comments