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

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

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

[转到页底]

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


数据库总体概况

● 实例信息
pg_start_time server_ip server_port client_ip client_port server_version primary_or_standby now_date
2022-04-21 10:19:41.438015+08 172.17.0.5 5432 192.168.66.64 32444 PostgreSQL 11.9 (POLARDB 11.9) primary 2022-04-21 10:37:28.10469+08

● 数据库基本信息
Name Owner Encoding Collate Ctype Access privileges Size Tablespace Description
polardb_admin postgres UTF8 en_US.UTF-8 en_US.UTF-8 =T/postgres
postgres=CTc/postgres		 7513 kB pg_default default administrative connection database
postgres postgres UTF8 en_US.UTF-8 en_US.UTF-8   7521 kB pg_default default administrative connection database
template0 postgres UTF8 en_US.UTF-8 en_US.UTF-8 =c/postgres
postgres=CTc/postgres		 7513 kB pg_default unmodifiable empty database
template1 postgres UTF8 en_US.UTF-8 en_US.UTF-8 =c/postgres
postgres=CTc/postgres		 7513 kB pg_default default template for new databases
● 查看各数据库数据创建时间
datname size access modification change creation isdir
postgres 3 2022-04-21 10:19:38+08 2022-04-21 10:19:33+08 2022-04-21 10:19:33+08   f
template1 3 2022-04-21 10:19:32+08 2022-04-21 10:19:31+08 2022-04-21 10:19:31+08   f
template0 3 2022-04-21 10:19:38+08 2022-04-21 10:19:33+08 2022-04-21 10:19:33+08   f
polardb_admin 3 2022-04-21 10:19:38+08 2022-04-21 10:19:33+08 2022-04-21 10:19:33+08   f

● 所有表空间
oid Name Owner Location Access privileges Options Size Description
1663 pg_default postgres       29 MB  
1664 pg_global postgres       553 kB  

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

● 前几张大表
db schemaname relname rowcount table_size indexes_size total_size

● 当前库的所有数据库对象
schemaname objecttype cnt
public VIEW 1
public func 2

[回到目录]

锁情况

● 所有进程

● 总计
最大连接数 当前连接数 剩余连接数
100 17 83

● 详情
datid datname pid usesysid usename application_name client_addr client_hostname client_port backend_start xact_start query_start state_change wait_event_type wait_event state backend_xid backend_xmin query backend_type
    41753 10 postgres         2022-04-21 10:19:41.529176+08                   polar worker process
    41764             2022-04-21 10:19:46.856566+08       Activity AutoVacuumMain         autovacuum launcher
    41766 10 postgres         2022-04-21 10:19:46.865263+08       Activity LogicalLauncherMain         logical replication launcher
    41767 10 postgres         2022-04-21 10:19:46.864433+08                   polar parallel bgwriter
    41768 10 postgres         2022-04-21 10:19:46.864982+08                   polar parallel bgwriter
    41769 10 postgres         2022-04-21 10:19:46.865832+08                   polar parallel bgwriter
    41770 10 postgres         2022-04-21 10:19:46.86662+08                   polar parallel bgwriter
    41771 10 postgres         2022-04-21 10:19:46.867407+08                   polar parallel bgwriter
12967 postgres 42635 10 postgres psql 127.0.0.1   50652 2022-04-21 10:33:51.34915+08   2022-04-21 10:33:52.595787+08 2022-04-21 10:33:52.76845+08 Client ClientRead idle     create extension pg_stat_statements; client backend
12967 postgres 42812 10 postgres psql 192.168.66.64   32444 2022-04-21 10:37:27.993318+08 2022-04-21 10:37:28.694423+08 2022-04-21 10:37:28.694423+08 2022-04-21 10:37:28.694425+08     active   571 select a.* from pg_stat_activity a ; client backend
    41761             2022-04-21 10:19:46.829759+08       Activity BgWriterHibernate         background writer
    41760             2022-04-21 10:19:46.828935+08       Activity CheckpointerMain         checkpointer
    41762             2022-04-21 10:19:46.830475+08       Activity WalWriterMain         walwriter
    41758             2022-04-21 10:19:46.827275+08                   polar wal pipeliner
    41763             2022-04-21 10:19:46.831336+08       Activity LogIndexBgMain         background logindex writer
    41750             2022-04-21 10:19:41.526499+08       Activity FlashbackLogInsertBgMain         background flashback log inserter
    41751             2022-04-21 10:19:41.527097+08       Activity FlashbackLogWriteBgMain         background flashback log writer

● 锁
locktype database relation page tuple virtualxid transactionid classid objid objsubid virtualtransaction pid mode granted fastpath
relation 12967 11645               10/133 42812 AccessShareLock t t
virtualxid         10/133         10/133 42812 ExclusiveLock t t

● state_change字段长时间没有更新过的连接信息
datid datname pid usesysid usename application_name client_addr client_hostname client_port backend_start xact_start query_start state_change wait_event_type wait_event state backend_xid backend_xmin query backend_type
12967 postgres 42635 10 postgres psql 127.0.0.1   50652 2022-04-21 10:33:51.34915+08   2022-04-21 10:33:52.595787+08 2022-04-21 10:33:52.76845+08 Client ClientRead idle     create extension pg_stat_statements; client backend

[回到目录]

SQL情况

● 最耗共享内存 SQL
userid dbid queryid query calls total_time min_time max_time mean_time stddev_time rows shared_blks_hit shared_blks_read shared_blks_dirtied shared_blks_written local_blks_hit local_blks_read local_blks_dirtied local_blks_written temp_blks_read temp_blks_written blk_read_time blk_write_time

[回到目录]

高可用情况

● 主从流复制情况

● 主库查看wal日志发送状态
pid usesysid usename application_name client_addr client_hostname client_port backend_start backend_xmin state sent_lsn write_lsn flush_lsn replay_lsn write_lag flush_lag replay_lag sync_priority sync_state

● 从库查看wal日志接收状态
pid status receive_start_lsn receive_start_tli received_lsn received_tli last_msg_send_time last_msg_receipt_time latest_end_lsn latest_end_time slot_name sender_host sender_port conninfo

● 主从库延迟数据（单位MB）
slave_latency_mb

● 主从流复制冲突统计
datid datname confl_tablespace confl_lock confl_snapshot confl_bufferpin confl_deadlock
12967 postgres 0 0 0 0 0
1 template1 0 0 0 0 0
12966 template0 0 0 0 0 0
12968 polardb_admin 0 0 0 0 0

● 数据库统计（是否有坏块）
datid datname numbackends xact_commit xact_rollback blks_read blks_hit tup_returned tup_fetched tup_inserted tup_updated tup_deleted conflicts temp_files temp_bytes deadlocks blk_read_time blk_write_time stats_reset
12967 postgres 2 177 8 361 96201 59820 38891 45 9 0 0 0 0 0 0 0 2022-04-21 10:23:06.225041+08
1 template1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0  
12966 template0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0  
12968 polardb_admin 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0  

[回到目录]

● 逻辑复制

● 查看发布
pubname pubowner puballtables pubinsert pubupdate pubdelete pubtruncate

● 查看发布的表
pubname schemaname tablename

● 查看所有的订阅者
pid usesysid usename application_name client_addr client_hostname client_port backend_start backend_xmin state sent_lsn write_lsn flush_lsn replay_lsn write_lag flush_lag replay_lag sync_priority sync_state

● 复制进度
subid subname pid relid received_lsn last_msg_send_time last_msg_receipt_time latest_end_lsn latest_end_time

● 查看订阅
subdbid subname subowner subenabled subconninfo subslotname subsynccommit subpublications

● 查看订阅的表
srsubid srrelid srsubstate srsublsn srrelid

● 查看复制槽
slot_name plugin slot_type datoid database temporary active active_pid xmin catalog_xmin restart_lsn confirmed_flush_lsn

[回到目录]

数据库性能

● 相关参数

● 参数文件记录的参数
sourcefile sourceline seqno name setting applied error
/home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf 64 1 max_connections 100 f  
/home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf 117 2 shared_buffers 128MB f  
/home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf 130 3 dynamic_shared_memory_type posix t  
/home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf 214 4 max_wal_size 64GB f  
/home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf 215 5 min_wal_size 5GB f  
/home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf 483 6 log_timezone Asia/Shanghai t  
/home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf 597 7 datestyle iso, mdy t  
/home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf 599 8 timezone Asia/Shanghai t  
/home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf 612 9 lc_messages en_US.UTF-8 t  
/home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf 614 10 lc_monetary en_US.UTF-8 t  
/home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf 615 11 lc_numeric en_US.UTF-8 t  
/home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf 616 12 lc_time en_US.UTF-8 t  
/home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf 619 13 default_text_search_config pg_catalog.english t  
/home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf 714 14 polar_enable_shared_storage_mode on f  
/home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf 715 15 polar_hostid 1 f  
/home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf 716 16 max_connections 100 t  
/home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf 717 17 polar_wal_pipeline_enable true t  
/home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf 718 18 polar_create_table_with_full_replica_identity off t  
/home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf 719 19 logging_collector on t  
/home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf 720 20 log_directory pg_log t  
/home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf 722 21 unix_socket_directories . t  
/home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf 723 22 shared_buffers 128MB t  
/home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf 724 23 synchronous_commit on t  
/home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf 725 24 full_page_writes off f  
/home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf 727 25 autovacuum_naptime 10min t  
/home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf 728 26 max_worker_processes 32 t  
/home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf 729 27 polar_use_statistical_relpages off t  
/home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf 730 28 polar_enable_persisted_buffer_pool off t  
/home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf 731 29 polar_nblocks_cache_mode all t  
/home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf 732 30 polar_enable_replica_use_smgr_cache on t  
/home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf 733 31 polar_enable_standby_use_smgr_cache on t  
/home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf 734 32 polar_enable_flashback_log on t  
/home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf 735 33 max_wal_size 16GB t  
/home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf 736 34 min_wal_size 4GB t  
/home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf 737 35 polar_vfs.localfs_mode true t  
/home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf 738 36 polar_enable_localfs_test_mode on t  
/home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf 739 37 polar_enable_shared_storage_mode on t  
/home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf 740 38 listen_addresses * t  
/home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf 741 39 polar_disk_name home t  
/home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf 742 40 polar_datadir file-dio:///home/postgres/tmp_datadir_polardb_pg_1100_bld t  
/home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf 743 41 shared_preload_libraries $libdir/polar_px,$libdir/polar_vfs,$libdir/polar_worker,$libdir/pg_stat_statements,$libdir/auth_delay,$libdir/auto_explain,$libdir/polar_monitor_preload,$libdir/polar_stat_sql t  
/home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf 744 42 port 5432 t  
/home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf 745 43 polar_hostid 100 t  
/home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf 746 44 full_page_writes off t  
/home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf 747 45 polar_cluster_map   t  
● 重要参数
name setting unit category short_desc extra_desc context vartype source min_val max_val enumvals boot_val reset_val sourcefile sourceline pending_restart
archive_mode off   Write-Ahead Log / Archiving Allows archiving of WAL files using archive_command.   postmaster enum default     {always,on,off} off off     f
client_encoding UTF8   Client Connection Defaults / Locale and Formatting Sets the client's character set encoding.   user string default       SQL_ASCII UTF8     f
config_file /home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf   File Locations Sets the server's main configuration file.   postmaster string override         /home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf     f
data_directory /home/postgres/tmp_master_dir_polardb_pg_1100_bld   File Locations Sets the server's data directory.   postmaster string override         /home/postgres/tmp_master_dir_polardb_pg_1100_bld     f
hba_file /home/postgres/tmp_master_dir_polardb_pg_1100_bld/pg_hba.conf   File Locations Sets the server's "hba" configuration file.   postmaster string override         /home/postgres/tmp_master_dir_polardb_pg_1100_bld/pg_hba.conf     f
ident_file /home/postgres/tmp_master_dir_polardb_pg_1100_bld/pg_ident.conf   File Locations Sets the server's "ident" configuration file.   postmaster string override         /home/postgres/tmp_master_dir_polardb_pg_1100_bld/pg_ident.conf     f
listen_addresses *   Connections and Authentication / Connection Settings Sets the host name or IP address(es) to listen to.   postmaster string configuration file       localhost * /home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf 740 f
log_directory pg_log   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       log pg_log /home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf 720 f
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 default       postgresql-%Y-%m-%d_%H%M%S.log postgresql-%Y-%m-%d_%H%M%S.log     f
logging_collector on   Reporting and Logging / Where to Log Start a subprocess to capture stderr output and/or csvlogs into log files.   postmaster bool configuration file       off on /home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf 719 f
log_min_duration_statement -1 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 default -1 2147483647   -1 -1     f
log_statement none   Reporting and Logging / What to Log Sets the type of statements logged.   superuser enum default     {none,ddl,mod,all} none none     f
log_truncate_on_rotation off   Reporting and Logging / Where to Log Truncate existing log files of same name during log rotation.   sighup bool default       off off     f
max_connections 100   Connections and Authentication / Connection Settings Sets the maximum number of concurrent connections.   postmaster integer configuration file 1 262143   100 100 /home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf 716 f
port 5432   Connections and Authentication / Connection Settings Sets the TCP port the server listens on.   postmaster integer configuration file 1 65535   5432 5432 /home/postgres/tmp_master_dir_polardb_pg_1100_bld/postgresql.conf 744 f

● pg_hba.conf配置文件信息（PG10新增）
line_number type database user_name address netmask auth_method options error
84 local {all} {all}     trust    
86 host {all} {all} 127.0.0.1 255.255.255.255 trust    
88 host {all} {all} ::1 ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff trust    
91 local {replication} {all}     trust    
92 host {replication} {all} 127.0.0.1 255.255.255.255 trust    
93 host {replication} {all} ::1 ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff trust    
94 host {all} {all} 0.0.0.0 0.0.0.0 trust    

● 后台写进程统计信息
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
3 0 1348 19 12 239 0 1 0 435 2022-04-21 10:19:46.832815+08

● 查看表膨胀信息
table_name table_size n_dead_tup n_live_tup dead_tup_ratio

[回到目录]

其它

● 当前库的所有schema
catalog_name schema_name schema_owner default_character_set_catalog default_character_set_schema default_character_set_name sql_path
postgres information_schema postgres        
postgres public postgres        
postgres pg_catalog postgres        
postgres pg_toast_temp_1 postgres        
postgres pg_temp_1 postgres        
postgres pg_toast postgres        

● 当前库的所有角色(用户)
rolname rolsuper rolinherit rolcreaterole rolcreatedb rolcanlogin rolreplication rolconnlimit rolpassword rolvaliduntil rolbypassrls rolconfig oid
pg_signal_backend f t f f f f -1 ********   f   4200
pg_read_server_files f t f f f f -1 ********   f   4569
postgres t t t t t t -1 ********   t   10
pg_polar_superuser f t t t f t -1 ********   t   5500
pg_write_server_files f t f f f f -1 ********   f   4570
pg_execute_server_program f t f f f f -1 ********   f   4571
pg_read_all_stats f t f f f f -1 ********   f   3375
pg_monitor f t f f f f -1 ********   f   3373
pg_read_all_settings f t f f f f -1 ********   f   3374
pg_stat_scan_tables f t f f f f -1 ********   f   3377

usename usesysid usecreatedb usesuper userepl usebypassrls passwd valuntil useconfig
postgres 10 t t t t ********    

● 所有语言
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  
plpgsql 10 t t 12954 12955 12956  

● 所有可用插件

● 所有插件（已编译）
name default_version installed_version comment
refint 1.0   functions for implementing referential integrity (obsolete)
xml2 1.1   XPath querying and XSLT
plpgsql 1.0 1.0 PL/pgSQL procedural language
jsonb_plperlu 1.0   transform between jsonb and plperlu
polar_vfs 1.0   polar_vfs
cube 1.4   data type for multidimensional cubes
intarray 1.2   functions, operators, and index support for 1-D arrays of integers
plpython2u 1.0   PL/Python2U untrusted procedural language
hstore 1.5   data type for storing sets of (key, value) pairs
uuid-ossp 1.1   generate universally unique identifiers (UUIDs)
sslinfo 1.2   information about SSL certificates
pgrowlocks 1.2   show row-level locking information
dict_int 1.0   text search dictionary template for integers
jsonb_plpython2u 1.0   transform between jsonb and plpython2u
hstore_plperlu 1.0   transform between hstore and plperlu
polar_csn 1.0   polar_csn
plperlu 1.0   PL/PerlU untrusted procedural language
hstore_plpython3u 1.0   transform between hstore and plpython3u
btree_gist 1.5   support for indexing common datatypes in GiST
bloom 1.0   bloom access method - signature file based index
pg_trgm 1.4   text similarity measurement and index searching based on trigrams
hstore_plperl 1.0   transform between hstore and plperl
hstore_plpython2u 1.0   transform between hstore and plpython2u
dict_xsyn 1.0   text search dictionary template for extended synonym processing
polar_tde_utils 1.0   Internal extension for TDE
lo 1.1   Large Object maintenance
btree_gin 1.3   support for indexing common datatypes in GIN
moddatetime 1.0   functions for tracking last modification time
plperl 1.0   PL/Perl procedural language
pg_buffercache 1.3   examine the shared buffer cache
unaccent 1.1   text search dictionary that removes accents
pltclu 1.0   PL/TclU untrusted procedural language
polar_parameter_check 1.0   kernel extension for parameter validation
ltree_plpythonu 1.0   transform between ltree and plpythonu
polar_monitor_preload 1.1   examine the polardb information
pg_freespacemap 1.2   examine the free space map (FSM)
jsonb_plpythonu 1.0   transform between jsonb and plpythonu
pgstattuple 1.5   show tuple-level statistics
polar_px 1.0   Parallel Execution extension
pltcl 1.0   PL/Tcl procedural language
citext 1.5   data type for case-insensitive character strings
ltree_plpython2u 1.0   transform between ltree and plpython2u
pgcrypto 1.3   cryptographic functions
tcn 1.0   Triggered change notifications
pg_visibility 1.2   examine the visibility map (VM) and page-level visibility info
ltree_plpython3u 1.0   transform between ltree and plpython3u
adminpack 2.0   administrative functions for PostgreSQL
plpythonu 1.0   PL/PythonU untrusted procedural language
pg_prewarm 1.2   prewarm relation data
tablefunc 1.0   functions that manipulate whole tables, including crosstab
amcheck 1.1   functions for verifying relation integrity
ltree 1.1   data type for hierarchical tree-like structures
tsm_system_rows 1.0   TABLESAMPLE method which accepts number of rows as a limit
hstore_plpythonu 1.0   transform between hstore and plpythonu
isn 1.2   data types for international product numbering standards
autoinc 1.0   functions for autoincrementing fields
dblink 1.2   connect to other PostgreSQL databases from within a database
fuzzystrmatch 1.1   determine similarities and distance between strings
polar_worker 1.0   polar_worker
jsonb_plperl 1.0   transform between jsonb and plperl
tsm_system_time 1.0   TABLESAMPLE method which accepts time in milliseconds as a limit
file_fdw 1.0   foreign-data wrapper for flat file access
timetravel 1.0   functions for implementing time travel
jsonb_plpython3u 1.0   transform between jsonb and plpython3u
earthdistance 1.1   calculate great-circle distances on the surface of the Earth
intagg 1.1   integer aggregator and enumerator (obsolete)
pg_stat_statements 1.6 1.6 track execution statistics of all SQL statements executed
pageinspect 1.7   inspect the contents of database pages at a low level
postgres_fdw 1.0   foreign-data wrapper for remote PostgreSQL servers
seg 1.3   data type for representing line segments or floating-point intervals
polar_monitor 1.2   examine the polardb information
insert_username 1.0   functions for tracking who changed a table
polar_stat_sql 1.3   Kernel statistics gathering, and sql plan nodes information gathering

● 已安装的插件
Name Version Schema Description
pg_stat_statements 1.6 public track execution statistics of all SQL statements executed
plpgsql 1.0 pg_catalog PL/pgSQL procedural language

● 获取已安装的PostgreSQL的信息
name setting
BINDIR /home/postgres/tmp_basedir_polardb_pg_1100_bld/bin
DOCDIR /home/postgres/tmp_basedir_polardb_pg_1100_bld/share/doc
HTMLDIR /home/postgres/tmp_basedir_polardb_pg_1100_bld/share/doc
INCLUDEDIR /home/postgres/tmp_basedir_polardb_pg_1100_bld/include
PKGINCLUDEDIR /home/postgres/tmp_basedir_polardb_pg_1100_bld/include
INCLUDEDIR-SERVER /home/postgres/tmp_basedir_polardb_pg_1100_bld/include/server
LIBDIR /home/postgres/tmp_basedir_polardb_pg_1100_bld/lib
PKGLIBDIR /home/postgres/tmp_basedir_polardb_pg_1100_bld/lib
LOCALEDIR /home/postgres/tmp_basedir_polardb_pg_1100_bld/share/locale
MANDIR /home/postgres/tmp_basedir_polardb_pg_1100_bld/share/man
SHAREDIR /home/postgres/tmp_basedir_polardb_pg_1100_bld/share
SYSCONFDIR /home/postgres/tmp_basedir_polardb_pg_1100_bld/etc
PGXS /home/postgres/tmp_basedir_polardb_pg_1100_bld/lib/pgxs/src/makefiles/pgxs.mk
CONFIGURE '--prefix=/home/postgres/tmp_basedir_polardb_pg_1100_bld' '--with-pgport=5432' '--with-openssl' '--with-libxml' '--with-perl' '--with-python' '--with-tcl' '--with-pam' '--with-gssapi' '--enable-nls' '--with-libxslt' '--with-ldap' '--with-uuid=e2fs' '--with-icu' '--with-llvm' 'CFLAGS= -g -pipe -Wall -grecord-gcc-switches -I/usr/include/et -O3' 'LDFLAGS=-Wl,-rpath,'''/../lib'''' 'CXXFLAGS=-g -pipe -Wall -grecord-gcc-switches -I/usr/include/et -O3' 'PKG_CONFIG_PATH=/opt/rh/llvm-toolset-7.0/root/usr/lib64/pkgconfig:/opt/rh/devtoolset-9/root/usr/lib64/pkgconfig'
CC gcc
CPPFLAGS -D_GNU_SOURCE -I/usr/include/libxml2
CFLAGS -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -Wno-format-truncation -Wno-stringop-truncation -g -pipe -Wall -grecord-gcc-switches -I/usr/include/et -O3
CFLAGS_SL -fPIC
LDFLAGS -L ../../src/backend/polar_dma/libconsensus/polar_wrapper/lib -Wl,-rpath,'/../lib' -L/opt/rh/llvm-toolset-7.0/root/usr/lib64 -Wl,--as-needed -Wl,-rpath,'/home/postgres/tmp_basedir_polardb_pg_1100_bld/lib',--enable-new-dtags
LDFLAGS_EX  
LDFLAGS_SL  
LIBS -lpgcommon -lpgport -lpthread -lxslt -lxml2 -lpam -lssl -lcrypto -lgssapi_krb5 -lz -lreadline -lrt -lcrypt -ldl -lm
VERSION PostgreSQL 11.9
PX_VERSION_STR PolarDB PX version 1.1

[回到目录]