postgres 环境下的ora (更新中)

[root@redhatos ~]# pgdba

  Help verbose       
    pluge            plugeinfo 
    object           objects 
    active           active sessions 
    mvcc             mvcc infos 
    setting          file setting
    datatype         support datatype
    loginfo          lsn info
[root@redhatos ~]# pgdba active
  locktype  | relation |      mode       | granted |  pid   | vxid | xid | vxid2 
------------+----------+-----------------+---------+--------+------+-----+-------
 relation   | pg_locks | AccessShareLock | t       | 184823 |      |     | 10/2
 virtualxid |          | ExclusiveLock   | t       | 184823 | 10/2 |     | 10/2
(2 rows)

 进程号 | 登录用户 | 所在数据库 |    客户端ip    | 当前状态 | 已执行_秒数 | 等待类型 | 等待事件 |            正在执行的sql            
--------+----------+------------+----------------+----------+-------------+----------+----------+-------------------------------------
 184823 | itdba    | postgres   | 192.168.56.131 | active   |    0.000000 |          |          | SELECT                             +
        |          |            |                |          |             |          |          |       pid              AS 进程号,  +
        |          |            |                |          |             |          |          |       usename          AS 登录用户,+
        |          |            |                |          |             |          |          |       datname          AS 所在数
(1 row)

 被阻塞pid | 被阻塞sql | 凶手pid | 凶手sql | 锁定的表 | 锁类型 | 等待的锁模式 
-----------+-----------+---------+---------+----------+--------+--------------
(0 rows)

[root@redhatos ~]# pgdba  pluge
                                         List of installed extensions
    Name     | Version | Default version |   Schema   |                      Description                      
-------------+---------+-----------------+------------+-------------------------------------------------------
 pageinspect | 1.13    | 1.13            | public     | inspect the contents of database pages at a low level
 plpgsql     | 1.0     | 1.0             | pg_catalog | PL/pgSQL procedural language
(2 rows)

      插件名称      | 默认版本 | 已安装版本 
--------------------+----------+------------
 amcheck            | 1.5      | 
 autoinc            | 1.0      | 
 bloom              | 1.0      | 
 btree_gin          | 1.3      | 
 btree_gist         | 1.8      | 
 citext             | 1.8      | 
 cube               | 1.5      | 
 dblink             | 1.2      | 
 dict_int           | 1.0      | 
 dict_xsyn          | 1.0      | 
 earthdistance      | 1.2      | 
 file_fdw           | 1.0      | 
 fuzzystrmatch      | 1.2      |