巡检人:小麦苗　QQ:646634621　微信公众号：DB宝　提供OCP、OCM、高可用（rac+dg）、PostgreSQL和MySQL培训　BLOG地址: https://www.dbaup.com 若需要脚本可私聊我
GBase8c数据库巡检报告

Copyright (c) 2015-2100 (https://www.dbaup.com) dbaup. All rights reserved.

巡 检 人：小麦苗([QQ：646634621] [微信公众号：DB宝] [提供OCP、OCM、高可用、MySQL和PostgreSQL最实用的培训])
版 本 号：v7.0.0
修改日期：2023-3-18

[转到页底]

目录
总体概况 实例信息数据库实例信息 数据库基本信息数据库的总体概况、版本、主机情况、数据库负载情况、数据库属性等 所有表空间所有表空间 当前客户端连接信息当前客户端连接信息 前几张大表前几张大表
当前库的所有数据库对象当前库的所有数据库对象
锁情况 所有进程
SQL部分 总执行时间最长的SQL 最耗IO的SQL 最耗共享内存
索引部分
高可用情况 主从流复制情况主从流复制情况 逻辑复制PG逻辑复制情况
数据库性能 参数配置 后台写进程统计信息
其它 用户和角色 所有插件


数据库总体概况

● 实例信息
pg_start_time server_ip server_port client_ip client_port server_version primary_or_standby now_date
2024-11-15 10:16:53.219944+08 127.0.0.1 5432 127.0.0.1 44184 PostgreSQL 9.2.4 (multiple_nodes GBase8cV5 3.0.0B76 build 47948f99) compiled at 2023-02-27 16:04:20 commit 0 last mr 1232 on x86_64-unknown-linux-gnu, compiled by g++ (GCC) 7.3.0, 64-bit primary 2024-11-15 10:24:27.245982+08

● 数据库基本信息
Name Owner Encoding Collate Ctype Access privileges Size Tablespace Description
lhrdb gbase UTF8 C C   30 MB pg_default  
postgres gbase UTF8 C C   30 MB pg_default default administrative connection database
template0 gbase UTF8 C C =c/gbase
gbase=CTc/gbase		 30 MB pg_default default template for new databases
template1 gbase UTF8 C C =c/gbase
gbase=CTc/gbase		 30 MB pg_default unmodifiable empty database
testdb gbase UTF8 C C   30 MB pg_default  

● 所有表空间
oid Name Owner Location Access privileges Options Size Description
1663 pg_default gbase       150 MB  
1664 pg_global gbase       1026 MB  

● 当前客户端连接信息
current_user current_database pg_backend_pid
gbase postgres 140712353986304

● 前几张大表（当前库）
db schemaname relname rowcount table_size indexes_size total_size

● 当前库的所有数据库对象
schemaname objecttype cnt
dbe_perf VIEW 187
oracle VIEW 11
compat_tools VIEW 139
dbms_pipe VIEW 1
public VIEW 1
public func 73

● 当前操作系统运行的状态信息
id name value comments cumulative
0 NUM_CPUS 32 Number of CPUs or processors available f
1 NUM_CPU_CORES 32 Number of CPU cores available (includes subcores of multicore CPUs as well as single-core CPUs) f
2 NUM_CPU_SOCKETS 4 Number of CPU sockets available (represents an absolute count of CPU chips on the system, regardless of multithreading or multi-core architectures) f
3 IDLE_TIME 26271855698 Number of hundredths of a second that a processor has been idle, totalled over all processors t
4 BUSY_TIME 953287724 Number of hundredths of a second that a processor has been busy executing user or kernel code, totalled over all processors t
5 USER_TIME 475650901 Number of hundredths of a second that a processor has been busy executing user code, totalled over all processors t
6 SYS_TIME 477636823 Number of hundredths of a second that a processor has been busy executing kernel code, totalled over all processors t
7 IOWAIT_TIME 36878288 Number of hundredths of a second that a processor has been waiting for I/O to complete, totalled over all processors t
8 NICE_TIME 139365953 Number of hundredths of a second that a processor has been busy executing low-priority user code, totalled over all processors t
9 AVG_IDLE_TIME 820995490 Number of hundredths of a second that a processor has been idle, averaged over all processors t
10 AVG_BUSY_TIME 29790241 Number of hundredths of a second that a processor has been busy executing user or kernel code, averaged over all processors t
11 AVG_USER_TIME 14864090 Number of hundredths of a second that a processor has been busy executing user code, averaged over all processors t
12 AVG_SYS_TIME 14926150 Number of hundredths of a second that a processor has been busy executing kernel code, averaged over all processors t
13 AVG_IOWAIT_TIME 1152446 Number of hundredths of a second that a processor has been waiting for I/O to complete, averaged over all processors t
14 AVG_NICE_TIME 4355186 Number of hundredths of a second that a processor has been busy executing low-priority user code, averaged over all processors t
15 VM_PAGE_IN_BYTES 83255070720 Total number of bytes of data that have been paged in due to virtual memory paging t
16 VM_PAGE_OUT_BYTES 240943087616 Total number of bytes of data that have been paged out due to virtual memory paging t
17 LOAD 1.51 Current number of processes that are either running or in the ready state, waiting to be selected by the operating-system scheduler to run. On many platforms, this statistic reflects the average load over the past minute. f
18 PHYSICAL_MEMORY_BYTES 67382296576 Total number of bytes of physical memory f

● 节点的进程信息
node_name pid lwpid thread_name creation_time
cn1 140713595434752 1451 GtmProxyWorker  
cn1 140713111045888 1556 PageWriter 2024-11-15 10:16:55.600714+08
cn1 140713094264576 1557 PageWriter 2024-11-15 10:16:55.601922+08
cn1 140713127827200 1555 PageWriter 2024-11-15 10:16:55.599808+08
cn1 140713264080640 1553 PageWriter 2024-11-15 10:16:55.598783+08
cn1 140713144608512 1554 PageWriter 2024-11-15 10:16:55.59879+08
cn1 140712577332992 1575 undo recycler 2024-11-15 10:16:55.630821+08
cn1 140712778659584 1571 LWLock Monitor 2024-11-15 10:16:55.62423+08
cn1 140713060701952 1559 Wal Writer Auxiliary 2024-11-15 10:16:55.604321+08
cn1 140713077483264 1558 Wal Writer 2024-11-15 10:16:55.604238+08
cn1 140713562994432 1551 CheckPointer 2024-11-15 10:16:55.597876+08
cn1 140713280861952 1552 InvalidBufferBgWriter 2024-11-15 10:16:55.598433+08
cn1 140712394880768 2059 cn1##gc_clean 2024-11-15 10:17:56.456109+08
cn1 140712464086784 2054 cn1##gc_clean 2024-11-15 10:17:55.953045+08
cn1 140712428435200 2051 cn1##gc_clean 2024-11-15 10:17:55.801969+08
cn1 140712510748416 1583   2024-11-15 10:16:57.366761+08
cn1 140712671704832 1573 CsnminSync 2024-11-15 10:16:55.671988+08
cn1 140712353986304 5097 gsql 2024-11-15 10:24:27.215889+08
cn1 140712884631296 1567 PercentileJob 2024-11-15 10:16:55.671925+08
cn1 140712931424000 1565 ApplyLauncher  
cn1 140712858351360 1568 Asp 2024-11-15 10:16:55.671771+08
cn1 140712838887168 1569 statement flush thread 2024-11-15 10:16:55.671766+08
cn1 140712816277248 1570 TwoPhase Cleaner 2024-11-15 10:16:55.615586+08
cn1 140713027139328 1561 JobScheduler 2024-11-15 10:16:55.671473+08

[回到目录]

锁情况

● 所有进程

● 总计
最大连接数 当前连接数 剩余连接数
3000 12 2988

● 详情
datid datname pid sessionid usesysid usename application_name client_addr client_hostname client_port backend_start xact_start query_start state_change waiting enqueue state resource_pool query_id query connection_info unique_sql_id trace_id
16401 lhrdb 140712394880768 140712394880768 10 gbase cn1##gc_clean 127.0.0.1   46968 2024-11-15 10:17:56.456109+08   2024-11-15 10:23:57.765117+08 2024-11-15 10:23:57.765278+08 f   idle default_pool 0 SET SESSION AUTHORIZATION DEFAULT;RESET ALL;   0  
16395 testdb 140712464086784 140712464086784 10 gbase cn1##gc_clean 127.0.0.1   46944 2024-11-15 10:17:55.953045+08   2024-11-15 10:23:57.750049+08 2024-11-15 10:23:57.750179+08 f   idle default_pool 0 SET SESSION AUTHORIZATION DEFAULT;RESET ALL;   0  
16041 postgres 140712428435200 140712428435200 10 gbase cn1##gc_clean 127.0.0.1   46938 2024-11-15 10:17:55.801969+08   2024-11-15 10:23:57.735575+08 2024-11-15 10:23:57.735767+08 f   idle default_pool 0 SET SESSION AUTHORIZATION DEFAULT;RESET ALL;   0  
16041 postgres 140712510748416 140712510748416 10 gbase       -1 2024-11-15 10:16:57.366761+08   2024-11-15 10:24:25.510798+08 2024-11-15 10:24:25.511571+08 f   idle default_pool 0 SELECT node_name, node_host, node_port, nodeis_central FROM pgxc_node   0  
16041 postgres 140712671704832 140712671704832 10 gbase CsnminSync       2024-11-15 10:16:55.671988+08     2024-11-15 10:24:26.708013+08 f   idle default_pool 0     0  
16041 postgres 140712353986304 140712353986304 10 gbase gsql 127.0.0.1   44184 2024-11-15 10:24:27.215889+08 2024-11-15 10:24:27.40873+08 2024-11-15 10:24:27.40873+08 2024-11-15 10:24:27.408733+08 f   active default_pool 72902018968060690 select a.* from pg_stat_activity a ; {"driver_name":"libpq","driver_version":"(multiple_nodes GBase8cV5 3.0.0B76 build 47948f99) compiled at 2023-02-27 16:04:20 commit 0 last mr 1232 "} 2326038844  
16041 postgres 140712884631296 140712884631296 10 gbase PercentileJob       2024-11-15 10:16:55.671925+08     2024-11-15 10:24:26.140688+08 f   active default_pool 0     0  
16041 postgres 140712931424000 140712931424000 10 gbase ApplyLauncher       2024-11-15 10:16:55.624763+08       f     default_pool 0     0  
16041 postgres 140712858351360 140712858351360 10 gbase Asp       2024-11-15 10:16:55.671771+08     2024-11-15 10:24:27.128519+08 f   active default_pool 0     0  
16041 postgres 140712838887168 140712838887168 10 gbase statement flush thread       2024-11-15 10:16:55.671766+08     2024-11-15 10:16:55.671892+08 f   idle default_pool 0     0  
16041 postgres 140712816277248 140712816277248 10 gbase TwoPhase Cleaner       2024-11-15 10:16:55.615586+08     2024-11-15 10:24:17.779174+08 f   idle default_pool 0     0  
16041 postgres 140713027139328 140713027139328 10 gbase JobScheduler       2024-11-15 10:16:55.671473+08     2024-11-15 10:24:27.128504+08 f   active default_pool 0     0  

● 锁
locktype database relation page tuple bucket virtualxid transactionid classid objid objsubid virtualtransaction pid sessionid mode granted fastpath locktag global_sessionid
relation 16041 12014                 9/650 140712353986304 140712353986304 AccessShareLock t t 3ea9:2eee:0:0:0:0 0:193#0
virtualxid           9/650         9/650 140712353986304 140712353986304 ExclusiveLock t t 9:28a:0:0:0:7 0:193#0

● 查询等待锁的线程状态信息
node_name db_name thread_name query_id tid sessionid lwtid psessionid tlevel smpid wait_status wait_event locktag lockmode block_sessionid global_sessionid

● 查询当前使用内存最多的会话信息
sessid threadid contextname level parent totalsize freesize usedsize

● state_change字段长时间没有更新过的连接信息
datid datname pid sessionid usesysid usename application_name client_addr client_hostname client_port backend_start xact_start query_start state_change waiting enqueue state resource_pool query_id query connection_info unique_sql_id trace_id
16041 postgres 140712838887168 140712838887168 10 gbase statement flush thread       2024-11-15 10:16:55.671766+08     2024-11-15 10:16:55.671892+08 f   idle default_pool 0     0  
16041 postgres 140712428435200 140712428435200 10 gbase cn1##gc_clean 127.0.0.1   46938 2024-11-15 10:17:55.801969+08   2024-11-15 10:23:57.735575+08 2024-11-15 10:23:57.735767+08 f   idle default_pool 0 SET SESSION AUTHORIZATION DEFAULT;RESET ALL;   0  
16395 testdb 140712464086784 140712464086784 10 gbase cn1##gc_clean 127.0.0.1   46944 2024-11-15 10:17:55.953045+08   2024-11-15 10:23:57.750049+08 2024-11-15 10:23:57.750179+08 f   idle default_pool 0 SET SESSION AUTHORIZATION DEFAULT;RESET ALL;   0  
16401 lhrdb 140712394880768 140712394880768 10 gbase cn1##gc_clean 127.0.0.1   46968 2024-11-15 10:17:56.456109+08   2024-11-15 10:23:57.765117+08 2024-11-15 10:23:57.765278+08 f   idle default_pool 0 SET SESSION AUTHORIZATION DEFAULT;RESET ALL;   0  
16041 postgres 140712816277248 140712816277248 10 gbase TwoPhase Cleaner       2024-11-15 10:16:55.615586+08     2024-11-15 10:24:17.779174+08 f   idle default_pool 0     0  
16041 postgres 140712510748416 140712510748416 10 gbase       -1 2024-11-15 10:16:57.366761+08   2024-11-15 10:24:25.510798+08 2024-11-15 10:24:25.511571+08 f   idle default_pool 0 SELECT node_name, node_host, node_port, nodeis_central FROM pgxc_node   0  
16041 postgres 140712671704832 140712671704832 10 gbase CsnminSync       2024-11-15 10:16:55.671988+08     2024-11-15 10:24:26.708013+08 f   idle default_pool 0     0  

[回到目录]

SQL情况

● 慢SQL查询
node_name db_name schema_name origin_node user_name application_name client_addr client_port unique_query_id debug_query_id query start_time finish_time slow_sql_threshold transaction_id thread_id session_id n_soft_parse n_hard_parse query_plan n_returned_rows n_tuples_fetched n_tuples_returned n_tuples_inserted n_tuples_updated n_tuples_deleted n_blocks_fetched n_blocks_hit db_time cpu_time execution_time parse_time plan_time rewrite_time pl_execution_time pl_compilation_time data_io_time net_send_info net_recv_info net_stream_send_info net_stream_recv_info lock_count lock_time lock_wait_count lock_wait_time lock_max_count lwlock_count lwlock_wait_count lwlock_time lwlock_wait_time details is_slow_sql trace_id

● 最耗IO的SQL

[回到目录]

高可用情况

● 主从流复制情况

● 主库查看wal日志发送状态
pid usesysid usename application_name client_addr client_hostname client_port backend_start state sender_sent_location receiver_write_location receiver_flush_location receiver_replay_location sync_priority sync_state

● 主从流复制冲突统计
datid datname confl_tablespace confl_lock confl_snapshot confl_bufferpin confl_deadlock
1 template1 0 0 0 0 0
16036 template0 0 0 0 0 0
16041 postgres 0 0 0 0 0
16395 testdb 0 0 0 0 0
16401 lhrdb 0 0 0 0 0

[回到目录]

● 逻辑复制

● 查看复制槽
slot_name plugin slot_type datoid database active xmin catalog_xmin restart_lsn dummy_standby

[回到目录]

数据库性能

● 相关参数

● 重要参数
name setting unit category short_desc extra_desc context vartype source min_val max_val enumvals boot_val reset_val sourcefile sourceline
archive_mode off   Write-Ahead Log / Archiving Allows archiving of WAL files using archive_command.   sighup bool default       off off    
client_encoding UTF8   Client Connection Defaults / Locale and Formatting Sets the client's character set encoding.   user string default       SQL_ASCII UTF8    
config_file /home/gbase/data/coord/cn1/postgresql.conf   File Locations Sets the server's main configuration file.   postmaster string override         /home/gbase/data/coord/cn1/postgresql.conf    
connection_info {"driver_name":"libpq","driver_version":"(multiple_nodes GBase8cV5 3.0.0B76 build 47948f99) compiled at 2023-02-27 16:04:20 commit 0 last mr 1232 "}   Reporting and Logging / What to Log Sets the connection info to be reported in statistics and logs.   user string session              
data_directory /home/gbase/data/coord/cn1   File Locations Sets the server's data directory.   postmaster string override         /home/gbase/data/coord/cn1    
hba_file /home/gbase/data/coord/cn1/pg_hba.conf   File Locations Sets the server's "hba" configuration file.   postmaster string override         /home/gbase/data/coord/cn1/pg_hba.conf    
ident_file /home/gbase/data/coord/cn1/pg_ident.conf   File Locations Sets the server's "ident" configuration file.   postmaster string override         /home/gbase/data/coord/cn1/pg_ident.conf    
listen_addresses *   Connections and Authentication / Connection Settings Sets the host name or IP address(es) to listen to.   postmaster string configuration file       localhost * /home/gbase/data/coord/cn1/postgresql.conf 880
log_directory /home/gbase/gbase_db/log/pg_log/cn1   Reporting and Logging / Where to Log Sets the destination directory for log files. Can be specified as relative to the data directory or as absolute path. sighup string configuration file       pg_log /home/gbase/gbase_db/log/pg_log/cn1 /home/gbase/data/coord/cn1/postgresql.conf 400
log_filename postgresql-%Y-%m-%d_%H%M%S.log   Reporting and Logging / Where to Log Sets the file name pattern for log files.   sighup string configuration file       postgresql-%Y-%m-%d_%H%M%S.log postgresql-%Y-%m-%d_%H%M%S.log /home/gbase/data/coord/cn1/postgresql.conf 402
log_min_duration_statement 1800000 ms Reporting and Logging / When to Log Sets the minimum execution time above which statements will be logged. Zero prints all queries. -1 turns this feature off. superuser integer configuration file -1 2147483647   -1 1800000 /home/gbase/data/coord/cn1/postgresql.conf 457
log_statement none   Reporting and Logging / What to Log Sets the type of statements logged.   superuser enum default     {none,ddl,mod,all} none none    
log_truncate_on_rotation off   Reporting and Logging / Where to Log Truncates existing log files of same name during log rotation.   sighup bool default       off off    
logging_collector on   Reporting and Logging / Where to Log Starts a subprocess to capture stderr output and/or csvlogs into log files.   postmaster bool configuration file       off on /home/gbase/data/coord/cn1/postgresql.conf 394
max_connections 3000   Connections and Authentication / Connection Settings Sets the maximum number of concurrent connections for clients.   postmaster integer configuration file 10 262143   200 3000 /home/gbase/data/coord/cn1/postgresql.conf 74
port 5432   Connections and Authentication / Connection Settings Sets the TCP port the server listens on.   postmaster integer configuration file 1 65535   5432 5432 /home/gbase/data/coord/cn1/postgresql.conf 73

● 数据库内存
nodename memorytype memorymbytes
cn1 max_process_memory 12288
cn1 process_used_memory 1335
cn1 max_dynamic_memory 6554
cn1 dynamic_used_memory 567
cn1 dynamic_peak_memory 574
cn1 dynamic_used_shrctx 234
cn1 dynamic_peak_shrctx 234
cn1 max_backend_memory 660
cn1 backend_used_memory 1
cn1 max_shared_memory 4049
cn1 shared_used_memory 820
cn1 max_cstore_memory 1024
cn1 cstore_used_memory 0
cn1 max_sctpcomm_memory 0
cn1 sctpcomm_used_memory 0
cn1 sctpcomm_peak_memory 0
cn1 other_used_memory 0
cn1 gpu_max_dynamic_memory 0
cn1 gpu_dynamic_used_memory 0
cn1 gpu_dynamic_peak_memory 0
cn1 pooler_conn_memory 0
cn1 pooler_freeconn_memory 0
cn1 storage_compress_memory 0
cn1 udf_reserved_memory 0

● 后台写进程统计信息
checkpoints_timed checkpoints_req checkpoint_write_time checkpoint_sync_time buffers_checkpoint buffers_clean maxwritten_clean buffers_backend buffers_backend_fsync buffers_alloc stats_reset
18 9 24 4839 0 0 0 0 0 0 2023-03-20 10:35:55.110018+08

● SQL统计信息
node_name user_name select_count update_count insert_count delete_count mergeinto_count ddl_count dml_count dcl_count total_select_elapse avg_select_elapse max_select_elapse min_select_elapse total_update_elapse avg_update_elapse max_update_elapse min_update_elapse total_insert_elapse avg_insert_elapse max_insert_elapse min_insert_elapse total_delete_elapse avg_delete_elapse max_delete_elapse min_delete_elapse
cn1 gs_role_copy_files 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
cn1 gs_role_signal_backend 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
cn1 gs_role_tablespace 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
cn1 gs_role_replication 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
cn1 gs_role_account_lock 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
cn1 gs_role_pldebugger 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
cn1 gs_role_directory_create 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
cn1 gs_role_directory_drop 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
cn1 gbase 710 0 0 0 0 7 710 0 1895274 2669 464587 158 0 0 0 0 0 0 0 0 0 0 0 0
cn1 gha 44 0 0 0 0 0 44 0 341519 7761 125943 379 0 0 0 0 0 0 0 0 0 0 0 0
cn1 lhr 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

● 时间消耗信息统计
stat_id stat_name value
0 DB_TIME 2352089
1 CPU_TIME 897456
2 EXECUTION_TIME 1539163
3 PARSE_TIME 24034
4 PLAN_TIME 196929
5 REWRITE_TIME 6607
6 PL_EXECUTION_TIME 2630
7 PL_COMPILATION_TIME 666
8 NET_SEND_TIME 7942
9 DATA_IO_TIME 8312

● 数据文件IO信息统计（物理读最多的10个文件）
filenum dbid spcid phyrds phywrts phyblkrd phyblkwrt readtim writetim avgiotim lstiotim miniotim maxiowtm
15520 16041 1663 277 66 277 66 2560 231 8 3 2 86
15504 16041 1663 186 9 186 9 14206 38 73 3 2 6623
15500 16041 1663 152 0 152 0 1366 0 8 7 4 29
15511 16041 1663 61 8 61 8 11547 36 167 3 3 4106
15559 16041 1663 37 0 37 0 7776 0 210 5 4 2654
15503 16041 1663 34 0 34 0 8966 0 263 6 5 2950
15523 16041 1663 30 2 30 2 8857 17 277 3 3 2884
15575 16041 1663 27 0 27 0 6378 0 236 16 5 2332
15597 16041 1663 21 0 21 0 21951 0 1045 5 5 7898
15522 16041 1663 21 0 21 0 6755 0 321 11 5 2393

[回到目录]

其它

● 当前库的所有schema
catalog_name schema_name schema_owner default_character_set_catalog default_character_set_schema default_character_set_name sql_path
postgres pg_toast gbase        
postgres cstore gbase        
postgres pkg_service gbase        
postgres dbe_perf gbase        
postgres snapshot gbase        
postgres blockchain gbase        
postgres db4ai gbase        
postgres pg_catalog gbase        
postgres public gbase        
postgres sqladvisor gbase        
postgres dbe_pldebugger gbase        
postgres dbe_pldeveloper gbase        
postgres information_schema gbase        
postgres dbms_output gbase        
postgres dbms_utility gbase        
postgres utl_file gbase        
postgres dbms_random gbase        
postgres oracle gbase        
postgres dbms_pipe gbase        
postgres dbms_alert gbase        
postgres plvdate gbase        
postgres plvstr gbase        
postgres plvchr gbase        
postgres plvsubst gbase        
postgres plunit gbase        
postgres plvlex gbase        
postgres dbms_assert gbase        
postgres orafce gbase        
postgres compat_tools gbase        
postgres dbms_metadata gbase        
postgres dbms_job gbase        
postgres dbms_lock gbase        
postgres dbms_application_info gbase        
postgres dbms_obfuscation_toolkit gbase        
postgres utl_url gbase        
postgres utl_encode gbase        
postgres utl_raw gbase        
postgres dbms_lob gbase        
postgres wmsys gbase        
postgres gha gha        
postgres lhr lhr        

● 当前库的所有角色(用户)
rolname rolsuper rolinherit rolcreaterole rolcreatedb rolcatupdate rolcanlogin rolreplication rolauditadmin rolsystemadmin rolconnlimit rolpassword rolvalidbegin rolvaliduntil rolrespool rolparentid roltabspace rolconfig oid roluseft rolkind nodegroup roltempspace rolspillspace rolmonitoradmin roloperatoradmin rolpolicyadmin
gbase t t t t t t t t t -1 ********     default_pool 0     10 t n       t t t
gs_role_directory_drop f t f f f f f f f -1 ********     default_pool 0     1059 f n       f f f
gs_role_directory_create f t f f f f f f f -1 ********     default_pool 0     1056 f n       f f f
gs_role_pldebugger f t f f f f f f f -1 ********     default_pool 0     1055 f n       f f f
gs_role_account_lock f t f f f f f f f -1 ********     default_pool 0     1048 f n       f f f
gs_role_replication f t f f f f f f f -1 ********     default_pool 0     1047 f n       f f f
gs_role_tablespace f t f f f f f f f -1 ********     default_pool 0     1046 f n       f f f
gs_role_signal_backend f t f f f f f f f -1 ********     default_pool 0     1045 f n       f f f
gs_role_copy_files f t f f f f f f f -1 ********     default_pool 0     1044 f n       f f f
lhr f t f f f t f f t -1 ********     default_pool 0     16402 f n       f f f
gha f t f f f t f f t -1 ********     default_pool 0     16390 f n       f f f

usename usesysid usecreatedb usesuper usecatupd userepl passwd valbegin valuntil respool parent spacelimit useconfig nodegroup tempspacelimit spillspacelimit usemonitoradmin useoperatoradmin usepolicyadmin
gbase 10 t t t t ********     default_pool 0           t t t
gha 16390 f f f f ********     default_pool 0           f f f
lhr 16402 f f f f ********     default_pool 0           f f f

● 所有语言
lanname lanowner lanispl lanpltrusted lanplcallfoid laninline lanvalidator lanacl
internal 10 f f 0 0 2246  
c 10 f f 0 0 2247  
sql 10 f t 0 0 2248  
java 10 f f 0 0 0  
plpgsql 10 t t 11925 11926 11927  

● 所有可用插件

● 所有插件（已编译）
name default_version installed_version comment
dblink 1.0   connect to other PostgreSQL databases from within a database
dist_fdw 1.0 1.0 foreign-data wrapper for distfs access
file_fdw 1.0 1.0 foreign-data wrapper for flat file access
fuzzystrmatch 1.0   determine similarities and distance between strings
gsredistribute 1.0 1.0 function for table redistribution
hdfs_fdw 1.0 1.0 foreign-data wrapper for flat file access
hstore 1.1 1.1 data type for storing sets of (key, value) pairs
log_fdw 1.0 1.0 Foreign Data Wrapper for accessing logging data
mapgis3d_pg 1.1   support mapgis3d type.
mot_fdw 1.0 1.0 foreign-data wrapper for MOT access
mysql_fdw 1.1   Foreign data wrapper for querying a MySQL server
oracle_fdw 1.1   foreign data wrapper for Oracle access
orafce 3.17 3.17 Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS
pg_trgm 1.0   text similarity measurement and index searching based on trigrams
pgcrypto 1.0   cryptographic functions
plpgsql 1.0 1.0 PL/pgSQL procedural language
postgis 3.2.1   PostGIS geometry and geography spatial types and functions
postgis_raster 3.2.1   PostGIS raster types and functions
postgis_sfcgal 3.2.1   PostGIS SFCGAL functions
postgres_fdw 1.0   foreign-data wrapper for remote PostgreSQL servers
security_plugin 1.0 1.0 provides security functionality
uuid-ossp 1.1   generate universally unique identifiers (UUIDs)
yukon_geogridcoder 1.0.1   yukon geogridcoder extension
yukon_geomodel 1.0.1   yukon geomodel extension
zhparser 2.2   a parser for full-text search of Chinese

● 已安装的插件
Name Version Schema Description
dist_fdw 1.0 pg_catalog foreign-data wrapper for distfs access
file_fdw 1.0 pg_catalog foreign-data wrapper for flat file access
gsredistribute 1.0 pg_catalog function for table redistribution
hdfs_fdw 1.0 pg_catalog foreign-data wrapper for flat file access
hstore 1.1 pg_catalog data type for storing sets of (key, value) pairs
log_fdw 1.0 pg_catalog Foreign Data Wrapper for accessing logging data
mot_fdw 1.0 pg_catalog foreign-data wrapper for MOT access
orafce 3.17 public Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS
plpgsql 1.0 pg_catalog PL/pgSQL procedural language
security_plugin 1.0 pg_catalog provides security functionality

[回到目录]

total time: 228 ms