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

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

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

[转到页底]

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


数据库总体概况

● YMatrix集群配置信息

● 按照实例排列
dbid content role preferred_role mode status port hostname address datadir
1 -1 p p n u 5432 lhrmatrixdb lhrmatrixdb /mxdata_20230406130924/master/mxseg-1
2 0 p p n u 6000 lhrmatrixdb lhrmatrixdb /mxdata_20230406130924/primary/mxseg0
3 1 p p n u 6001 lhrmatrixdb lhrmatrixdb /mxdata_20230406130924/primary/mxseg1
4 2 p p n u 6002 lhrmatrixdb lhrmatrixdb /mxdata_20230406130924/primary/mxseg2
5 3 p p n u 6003 lhrmatrixdb lhrmatrixdb /mxdata_20230406130924/primary/mxseg3

● 按照主机排列
dbid content role preferred_role mode status port hostname address datadir
1 -1 p p n u 5432 lhrmatrixdb lhrmatrixdb /mxdata_20230406130924/master/mxseg-1
2 0 p p n u 6000 lhrmatrixdb lhrmatrixdb /mxdata_20230406130924/primary/mxseg0
3 1 p p n u 6001 lhrmatrixdb lhrmatrixdb /mxdata_20230406130924/primary/mxseg1
4 2 p p n u 6002 lhrmatrixdb lhrmatrixdb /mxdata_20230406130924/primary/mxseg2
5 3 p p n u 6003 lhrmatrixdb lhrmatrixdb /mxdata_20230406130924/primary/mxseg3

● YMatrix基本信息
pg_start_time run_time config_file_load_time server_ip server_port client_ip client_port server_version primary_or_standby now_date all_db_hit
2023-04-06 13:10:56.035926+08 1420.408722 2023-04-06 13:21:46.812219+08 172.71.0.2 5432 192.168.27.52 58775 PostgreSQL 12 (MatrixDB 5.0.0+community) (Greenplum Database 7.0.0+dev.20476.g346be35d90 build commit:346be35d90d3b69877dc6262b163f68bd08b902c) on x86_64-pc-linux-gnu, compiled by gcc (GCC) 11.2.1 20220127 (Red Hat 11.2.1-9), 64-bit compiled on Mar 31 2023 08:22:55 primary 2023-04-06 13:34:36.444648+08 99.57%

● 数据库基本信息（数据库大小）
Name Owner Encoding Collate Ctype Access privileges Size Tablespace Description
matrixmgr mxadmin UTF8 en_US.utf8 en_US.utf8   111 MB pg_default  
postgres mxadmin UTF8 en_US.utf8 en_US.utf8   96 MB pg_default default administrative connection database
template0 mxadmin UTF8 en_US.utf8 en_US.utf8 =c/mxadmin
mxadmin=CTc/mxadmin		 93 MB pg_default unmodifiable empty database
template1 mxadmin UTF8 en_US.utf8 en_US.utf8 =c/mxadmin
mxadmin=CTc/mxadmin		 93 MB pg_default default template for new databases
总计           393 MB    

● 查看各数据库数据创建时间
datname size access modification change creation isdir
postgres 3 2023-04-06 13:10:55+08 2023-04-06 13:10:52+08 2023-04-06 13:10:54+08   f
template1 3 2023-04-06 13:10:59+08 2023-04-06 13:10:51+08 2023-04-06 13:10:54+08   f
template0 3 2023-04-06 13:10:52+08 2023-04-06 13:10:52+08 2023-04-06 13:10:54+08   f
matrixmgr 3 2023-04-06 13:10:59+08 2023-04-06 13:10:59+08 2023-04-06 13:10:59+08   f

● 所有表空间
oid Name Owner Location Access privileges Options Size Description
1663 pg_default mxadmin       393 MB  
1664 pg_global mxadmin       22 MB  

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

● 当前库的前50张大表
db schemaname relname rowcount table_size indexes_size total_size
postgres matrixmgr_internal mxgate_catalog 0 160 kB 0 bytes 160 kB

● 当前库的所有数据库对象
schemaname objecttype cnt
matrixmgr_internal SEQUENCE 1
matrixmgr_internal TABLE 1

● 查看当前库的所有schema占用的磁盘空间
sosdnsp schema_tb_size_mb schema_idx_size_mb
matrixmgr_internal 0.16 0.00
public 0.00 0.00

● 磁盘剩余空间查询

● segment剩余空间查询
address free_disk_gb

● 磁盘剩余空间查询

● 详情
dfsegment dfhostname address dfdevice datadir free_disk_gb

● 没有统计信息且可能需要ANALYZE的表
smischema smitable smisize smicols smirecs
matrixmgr_internal mxgate_catalog f 15 0

[回到目录]

锁情况

● 所有进程

● 总计
最大连接数 当前连接数 剩余连接数
300 10 290

● 用户统计
usename cnt
  3
mxadmin 7

● 状态统计
state cnt
  5
active 1
idle 4

● 详情
datid datname pid sess_id 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 rsgid rsgname
13376 postgres 8060 205 10 mxadmin psql 192.168.27.52   58775 2023-04-06 13:34:36.161506+08 2023-04-06 13:34:37.475795+08 2023-04-06 13:34:37.475795+08 2023-04-06 13:34:37.475801+08     active   532 select a.* from pg_stat_activity a order by a.state,query_start limit 100; client backend 0 unknown
16384 matrixmgr 4349 19 10 mxadmin       -1 2023-04-06 13:15:00.713157+08   2023-04-06 13:30:00.974534+08 2023-04-06 13:30:00.977471+08 Client ClientRead idle    
INSERT INTO matrixmgr_internal.mx_query_usage_history
SELECT -1 AS seg, * FROM matrixmgr_internal._mxstat_usage_harvest_reset(ts)
UNION ALL
SELECT gp_segment_id, (matrixmgr_internal._mxstat_usage_harvest_reset(ts)).* FROM gp_dist_random('gp_id');
 client backend 0 unknown
13376 postgres 7918 203 10 mxadmin mxui 172.71.0.2   55950 2023-04-06 13:33:58.350556+08   2023-04-06 13:34:32.936393+08 2023-04-06 13:34:32.937876+08 Client ClientRead idle     SELECT name
, COALESCE(setting, '') AS setting
, COALESCE(short_desc, '') AS short_desc
, COALESCE(extra_desc, '') AS extra_desc
, COALESCE(context, '') AS context
, COALESCE(min_val, '') AS min_val
, COALESCE(max_val, '') AS max_val
, pending_restart
FROM
pg_settings
WHERE
name in ($1)
 client backend 0 unknown
13376 postgres 8079 205 10 mxadmin       -1 2023-04-06 13:34:37.104416+08   2023-04-06 13:34:37.215282+08 2023-04-06 13:34:37.216408+08 Client ClientRead idle     select dfsegment,dfhostname,sc.address,dfdevice,sc.datadir,round(dfspace/1024/1024,2) as free_disk_GB
from gp_toolkit.gp_disk_free df , gp_segment_configuration sc
where df.dfsegment= sc.content and role='p'
ORDER BY address,dfsegment ;		 client backend 0 unknown
16384 matrixmgr 3149 19 10 mxadmin         2023-04-06 13:11:00.49485+08     2023-04-06 13:30:01.117485+08 Timeout BaseBackupThrottle idle       mxstat reaper 0 unknown
    2958 -1             2023-04-06 13:10:56.057165+08       Activity WalWriterMain         walwriter 0 unknown
13376 postgres 2970 5 10 mxadmin         2023-04-06 13:10:56.096517+08       Timeout BaseBackupThrottle         monitor 0 unknown
    2957 -1             2023-04-06 13:10:56.056545+08       Activity BgWriterHibernate         background writer 0 unknown
    2956 -1             2023-04-06 13:10:56.05591+08       Activity CheckpointerMain         checkpointer 0 unknown
    2977 3 10 mxadmin         2023-04-06 13:10:56.099352+08       Activity LogicalLauncherMain         logical replication launcher 0 unknown

● 锁
locktype database relation page tuple virtualxid transactionid classid objid objsubid virtualtransaction pid mode granted fastpath mppsessionid mppiswriter gp_segment_id
relation 13376 12664               6/145 8060 AccessShareLock t t 205 t -1
virtualxid         6/145         6/145 8060 ExclusiveLock t t 205 t -1
virtualxid         3/284         3/284 8062 ExclusiveLock t t 205 t 0
virtualxid         3/284         3/284 8063 ExclusiveLock t t 205 t 1
virtualxid         3/284         3/284 8064 ExclusiveLock t t 205 t 2
virtualxid         3/284         3/284 8065 ExclusiveLock t t 205 t 3

● 锁2
lorlocktype lordatabase lorrelname lorrelation lortransaction lorpid lormode lorgranted lorcurrentquery
relation 13376 gp_locks_on_relation 13278   8060 AccessShareLock t select * from gp_toolkit.gp_locks_on_relation ;
relation 0 pg_authid 1260   8060 AccessShareLock t select * from gp_toolkit.gp_locks_on_relation ;
relation 0 pg_authid_oid_index 2677   8060 AccessShareLock t select * from gp_toolkit.gp_locks_on_relation ;
relation 0 pg_authid_rolname_index 2676   8060 AccessShareLock t select * from gp_toolkit.gp_locks_on_relation ;
relation 0 pg_authid_rolresgroup_index 6440   8060 AccessShareLock t select * from gp_toolkit.gp_locks_on_relation ;
relation 0 pg_authid_rolresqueue_index 6029   8060 AccessShareLock t select * from gp_toolkit.gp_locks_on_relation ;
relation 13376 pg_class 1259   8060 AccessShareLock t select * from gp_toolkit.gp_locks_on_relation ;
relation 13376 pg_class_oid_index 2662   8060 AccessShareLock t select * from gp_toolkit.gp_locks_on_relation ;
relation 13376 pg_class_relname_nsp_index 2663   8060 AccessShareLock t select * from gp_toolkit.gp_locks_on_relation ;
relation 13376 pg_class_tblspc_relfilenode_index 3455   8060 AccessShareLock t select * from gp_toolkit.gp_locks_on_relation ;
relation 0 pg_database 1262   8060 AccessShareLock t select * from gp_toolkit.gp_locks_on_relation ;
relation 0 pg_database_datname_index 2671   8060 AccessShareLock t select * from gp_toolkit.gp_locks_on_relation ;
relation 0 pg_database_oid_index 2672   8060 AccessShareLock t select * from gp_toolkit.gp_locks_on_relation ;
relation 13376 pg_locks 12664   8060 AccessShareLock t select * from gp_toolkit.gp_locks_on_relation ;
relation 13376 pg_stat_activity 12767   8060 AccessShareLock t select * from gp_toolkit.gp_locks_on_relation ;

● 锁详情
pid transaction_id db_name schemaname object_name lock_type lock_mode lock_satus query_start query_text

● state_change字段长时间没有更新过的连接信息
datid datname pid sess_id 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 rsgid rsgname
16384 matrixmgr 4349 19 10 mxadmin       -1 2023-04-06 13:15:00.713157+08   2023-04-06 13:30:00.974534+08 2023-04-06 13:30:00.977471+08 Client ClientRead idle    
INSERT INTO matrixmgr_internal.mx_query_usage_history
SELECT -1 AS seg, * FROM matrixmgr_internal._mxstat_usage_harvest_reset(ts)
UNION ALL
SELECT gp_segment_id, (matrixmgr_internal._mxstat_usage_harvest_reset(ts)).* FROM gp_dist_random('gp_id');
 client backend 0 unknown
16384 matrixmgr 3149 19 10 mxadmin         2023-04-06 13:11:00.49485+08     2023-04-06 13:30:01.117485+08 Timeout BaseBackupThrottle idle       mxstat reaper 0 unknown
13376 postgres 7918 203 10 mxadmin mxui 172.71.0.2   55950 2023-04-06 13:33:58.350556+08   2023-04-06 13:34:32.936393+08 2023-04-06 13:34:32.937876+08 Client ClientRead idle     SELECT name
, COALESCE(setting, '') AS setting
, COALESCE(short_desc, '') AS short_desc
, COALESCE(extra_desc, '') AS extra_desc
, COALESCE(context, '') AS context
, COALESCE(min_val, '') AS min_val
, COALESCE(max_val, '') AS max_val
, pending_restart
FROM
pg_settings
WHERE
name in ($1)
 client backend 0 unknown
13376 postgres 8079 205 10 mxadmin       -1 2023-04-06 13:34:37.104416+08   2023-04-06 13:34:37.215282+08 2023-04-06 13:34:37.216408+08 Client ClientRead idle     select dfsegment,dfhostname,sc.address,dfdevice,sc.datadir,round(dfspace/1024/1024,2) as free_disk_GB
from gp_toolkit.gp_disk_free df , gp_segment_configuration sc
where df.dfsegment= sc.content and role='p'
ORDER BY address,dfsegment ;		 client backend 0 unknown

[回到目录]

SQL情况

● 慢查询SQL
pid sess_id client_port datname usename rsqname client_addr application_name state backend_start xact_start state_change query_start xact_stay query_stay query yc_filesize_gb yc_numfiles kill1 kill2
8060 205 58775 postgres mxadmin pg_default 192.168.27.52 psql active 2023-04-06 13:34:36.161506+08 2023-04-06 13:34:37.748179+08 2023-04-06 13:34:37.748185+08 2023-04-06 13:34:37.748179+08 0 0 SELECT pgsa.pid, pgsa.sess_id, pgsa.client_port, pgsa.datname AS datname, pgsa.usename AS usename, (SELECT nb.rrrsqname from gp_toolkit.gp_resq_role nb where nb.rrrolname=pgsa.usename) rsqname, pgsa.client_addr client_addr, pgsa.application_name AS application_name, pgsa.state AS state, pgsa.backend_start AS backend_start, pgsa.xact_start AS xact_start, state_change, pgsa.query_start AS query_start, TRUNC(EXTRACT( epoch FROM (NOW() - pgsa.xact_start) )) AS xact_stay, trunc(EXTRACT( epoch FROM (NOW() - pgsa.query_start) )) AS query_stay, REPLACE(pgsa.QUERY, chr(10), ' ') AS QUERY, yc_filesize_GB, yc_numfiles, 'select pg_terminate_backend('||pgsa.pid||');' kill1, 'select pg_cancel_backend('||pgsa.pid||');' kill2 FROM pg_stat_activity AS pgsa LEFT JOIN (select pid,trunc(sum(size)/1024/1024/1024) as yc_filesize_GB,sum(numfiles) as yc_numfiles from gp     select pg_terminate_backend(8060); select pg_cancel_backend(8060);

[回到目录]

高可用情况

● 主从流复制情况

● 主库查看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 reply_time

● 从库查看wal日志接收状态

● 主从流复制冲突统计
datid datname confl_tablespace confl_lock confl_snapshot confl_bufferpin confl_deadlock
13376 postgres 0 0 0 0 0
1 template1 0 0 0 0 0
13375 template0 0 0 0 0 0
16384 matrixmgr 0 0 0 0 0

[回到目录]

数据库性能

● 相关参数 ● 重要参数
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
listen_addresses *   Connections and Authentication / Connection Settings Sets the host name or IP address(es) to listen to.   postmaster string command line       localhost *     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 default       on on     f
log_min_duration_statement 500 ms Reporting and Logging / When to Log Sets the minimum execution time above which statements will be logged. Zero prints all queries, subject to log_statement_sample_rate. -1 turns this feature off. superuser integer configuration file -1 2147483647   -1 500 /mxdata_20230406130924/master/mxseg-1/postgresql.conf 821 f
log_statement ddl   Reporting and Logging / What to Log Sets the type of statements logged.   superuser enum configuration file     {none,ddl,mod,all} none ddl /mxdata_20230406130924/master/mxseg-1/postgresql.conf 820 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 300   Connections and Authentication / Connection Settings Sets the maximum number of concurrent connections.   postmaster integer configuration file 10 262143   200 300 /mxdata_20230406130924/master/mxseg-1/postgresql.conf 74 f
port 5432   Connections and Authentication / Connection Settings Sets the TCP port the server listens on.   postmaster integer command line 1 65535   5432 5432     f

● 后台写进程统计信息
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
4 3 32226 26 335 0 0 244 0 740 2023-04-06 13:10:55.158823+08

● 查看当前库的表膨胀信息
table_name table_size n_dead_tup n_live_tup dead_tup_ratio

● gp_toolkit.gp_bloat_diag

表oid 模式名 表名 期望页数 实际页数 real_size all_size 表大小 膨胀状态

● 缓存命中率和事务提交率
datname blks_read blks_hit xact_commit xact_rollback cache_hit commit_hit stats_reset
matrixmgr 427 96095 272 0 99.55% 100.00% 2023-04-06 13:10:59.158843+08
postgres 282 98677 577 14 99.71% 97.63% 2023-04-06 13:10:55.172618+08
------         99.63% 98.37%  

● 数据库统计详情
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 checksum_failures checksum_last_failure blk_read_time blk_write_time stats_reset
0   0 0 0 57 5699 3338 1563 21 19 0 0 0 0 0 0   0 0 2023-04-06 13:10:55.172721+08
13376 postgres 4 577 14 282 98677 111934 60371 304 24 0 0 0 0 0 0   0 0 2023-04-06 13:10:55.172618+08
1 template1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0   0 0  
13375 template0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0   0 0  
16384 matrixmgr 2 272 0 427 96095 80616 53924 26942 2971 88 0 0 0 0 0   0 0 2023-04-06 13:10:59.158843+08

[回到目录]

日志

● master库近7天的错误日志
logtime loguser logdatabase logpid logthread loghost logport logsessiontime logtransaction logsession logcmdcount logsegment logslice logdistxact loglocalxact logsubxact logseverity logstate logmessage logdetail loghint logquery logquerypos logcontext logdebug logcursorpos logfunction logfile logline logstack
2023-04-07 03:33:50.103452+08 root postgres p7907 th-404948864 [local]   2023-04-07 03:33:50+08 0 con202   seg-1       sx1 FATAL 28000 no pg_hba.conf entry for host "[local]", user "root", database "postgres", SSL off             0   auth.c 656  
2023-04-07 03:33:50.091226+08 root root p7904 th-404948864 [local]   2023-04-07 03:33:50+08 0 con201   seg-1       sx1 FATAL 28000 no pg_hba.conf entry for host "[local]", user "root", database "root", SSL off             0   auth.c 656  
2023-04-07 03:32:53.803446+08 mxadmin mxadmin p7764 th-404948864 [local]   2023-04-07 03:32:53+08 0 con197   seg-1       sx1 FATAL 3D000 database "mxadmin" does not exist             0   postinit.c 1022  
2023-04-07 03:30:02.426229+08 mxadmin postgres p6480 th-404948864 127.0.0.1 11474 2023-04-07 03:26:17+08 0 con159 cmd19 seg-1       sx1 ERROR 38000 external table gp_disk_free command ended with error. Traceback (most recent call last):
File "<string>", line 1, in <module>
ModuleNotFoundError: No module named 'gppylib' (seg1 slice1 172.71.0.2:6001 pid=7226)		 Command: execute:python3 -c "from gppylib.commands import unix; df=unix.DiskFree.get_disk_free_info_local('token','$GP_SEG_DATADIR'); print('%s, %s, %s, %s' % ('$GP_SEGMENT_ID', unix.getLocalHostname(), df[0], df[3]))"         select *
from gp_toolkit.gp_disk_free
ORDER BY dfsegment ;		 0   url_execute.c 349  
2023-04-07 03:29:16.973495+08 mxadmin postgres p6480 th-404948864 127.0.0.1 11474 2023-04-07 03:26:17+08 0 con159 cmd15 seg-1       sx1 ERROR 38000 external table gp_disk_free command ended with error. Traceback (most recent call last):
File "<string>", line 1, in <module>
ModuleNotFoundError: No module named 'gppylib' (seg0 slice1 172.71.0.2:6000 pid=6968)		 Command: execute:python3 -c "from gppylib.commands import unix; df=unix.DiskFree.get_disk_free_info_local('token','$GP_SEG_DATADIR'); print('%s, %s, %s, %s' % ('$GP_SEGMENT_ID', unix.getLocalHostname(), df[0], df[3]))"         select dfsegment,dfhostname,dfdevice,round(dfspace/1024/1024,2) as free_disk_GB
from gp_toolkit.gp_disk_free
ORDER BY dfsegment ;		 0   url_execute.c 349  
2023-04-07 03:28:42.077476+08 mxadmin postgres p6851 th-404948864 192.168.27.52 63981 2023-04-07 03:28:40+08 0 con166 cmd31 seg-1       sx1 ERROR 38000 external table gp_disk_free command ended with error. Traceback (most recent call last):
File "<string>", line 1, in <module>
ModuleNotFoundError: No module named 'gppylib' (seg1 slice1 172.71.0.2:6001 pid=6854)		 Command: execute:python3 -c "from gppylib.commands import unix; df=unix.DiskFree.get_disk_free_info_local('token','$GP_SEG_DATADIR'); print('%s, %s, %s, %s' % ('$GP_SEGMENT_ID', unix.getLocalHostname(), df[0], df[3]))"         select dfsegment,dfhostname,dfdevice,round(dfspace/1024/1024,2) as free_disk_GB
from gp_toolkit.gp_disk_free
ORDER BY dfsegment ;		 0   url_execute.c 349  
2023-04-07 03:28:28.482902+08 mxadmin postgres p6480 th-404948864 127.0.0.1 11474 2023-04-07 03:26:17+08 0 con159 cmd11 seg-1       sx1 ERROR 42P01 relation "session_state.session_level_memory_consumption" does not exist           SELECT *
FROM session_state.session_level_memory_consumption d ;		 16   parse_relation.c 1223  
2023-04-07 03:28:17.12319+08 mxadmin postgres p6480 th-404948864 127.0.0.1 11474 2023-04-07 03:26:17+08 0 con159 cmd10 seg-1       sx1 ERROR 42601 syntax error at or near "FROMsession_state"           SELECT *
FROMsession_state.session_level_memory_consumption d;		 11   scan.l 1146  
2023-04-07 03:28:04.770112+08 mxadmin postgres p6480 th-404948864 127.0.0.1 11474 2023-04-07 03:26:17+08 0 con159 cmd9 seg-1       sx1 ERROR 42601 syntax error at or near "FROMsession_state"           SELECT *
FROMsession_state.session_level_memory_consumption d
WHEREd.datname IS NOT NULL
ORDER BY
d.vmem_mb DESC,
d.sess_id,
d.segid
LIMIT 20;		 11   scan.l 1146  
2023-04-07 03:27:37.221243+08 mxadmin postgres p6480 th-404948864 127.0.0.1 11474 2023-04-07 03:26:17+08 0 con159 cmd6 seg-1       sx1 ERROR 42703 column pgsa.waiting_reason does not exist           SELECT pgsa.pid,
pgsa.sess_id,
pgsa.client_port,
pgsa.datname AS datname,
pgsa.usename AS usename,
(SELECT nb.rrrsqname from gp_toolkit.gp_resq_role nb where nb.rrrolname=pgsa.usename) rsqname,
pgsa.client_addr client_addr,
pgsa.application_name AS application_name,
pgsa.state AS state,
pgsa.waiting_reason,
pgsa.backend_start AS backend_start,
pgsa.xact_start AS xact_start,
state_change,
pgsa.query_start AS query_start,
TRUNC(EXTRACT( epoch FROM (NOW() - pgsa.xact_start) )) AS xact_stay,
trunc(EXTRACT( epoch FROM (NOW() - pgsa.query_start) )) AS query_stay,
REPLACE(pgsa.QUERY, chr(10), ' ') AS QUERY,
yc_filesize_GB,
yc_numfiles,
'select pg_terminate_backend('||pgsa.pid||');' kill1,
'select pg_cancel_backend('||pgsa.pid||');' kill2
FROM pg_stat_activity AS pgsa

LEFT JOIN (select pid,trunc(sum(size)/1024/1024/1024) as yc_filesize_GB,sum(numfiles) as yc_numfiles from gp_toolkit.gp_workfile_usage_per_query nb group by pid) as d
ON pgsa.pid=d.pid
WHERE pgsa.state not in ( 'idle' ,'idle in transaction (aborted)' )
ORDER BY query_stay DESC,xact_stay DESC
LIMIT 100;		 348   parse_relation.c 3677  
2023-04-07 03:27:10.615617+08 mxadmin postgres p6480 th-404948864 127.0.0.1 11474 2023-04-07 03:26:17+08 0 con159 cmd5 seg-1       sx1 ERROR 42703 column pgsa.waiting does not exist           SELECT pgsa.pid,
pgsa.sess_id,
pgsa.client_port,
pgsa.datname AS datname,
pgsa.usename AS usename,
(SELECT nb.rrrsqname from gp_toolkit.gp_resq_role nb where nb.rrrolname=pgsa.usename) rsqname,
pgsa.client_addr client_addr,
pgsa.application_name AS application_name,
pgsa.state AS state,
pgsa.waiting,
pgsa.waiting_reason,
pgsa.backend_start AS backend_start,
pgsa.xact_start AS xact_start,
state_change,
pgsa.query_start AS query_start,
TRUNC(EXTRACT( epoch FROM (NOW() - pgsa.xact_start) )) AS xact_stay,
trunc(EXTRACT( epoch FROM (NOW() - pgsa.query_start) )) AS query_stay,
REPLACE(pgsa.QUERY, chr(10), ' ') AS QUERY,
yc_filesize_GB,
yc_numfiles,
'select pg_terminate_backend('||pgsa.pid||');' kill1,
'select pg_cancel_backend('||pgsa.pid||');' kill2
FROM pg_stat_activity AS pgsa

LEFT JOIN (select pid,trunc(sum(size)/1024/1024/1024) as yc_filesize_GB,sum(numfiles) as yc_numfiles from gp_toolkit.gp_workfile_usage_per_query nb group by pid) as d
ON pgsa.pid=d.pid
WHERE pgsa.state not in ( 'idle' ,'idle in transaction (aborted)' )
ORDER BY query_stay DESC,xact_stay DESC
LIMIT 100;		 349   parse_relation.c 3677  
2023-04-07 03:26:35.954825+08 mxadmin postgres p6480 th-404948864 127.0.0.1 11474 2023-04-07 03:26:17+08 0 con159 cmd2 seg-1       sx1 ERROR 42601 syntax error at or near "END"           SELECT pg_locks.pid as pid,
transactionid as transaction_id,
pd.datname db_name,
nspname as schemaname,
relname as object_name,
locktype as lock_type,
mode lock_mode,
CASE
WHEN granted = 'f' THEN
'get_lock'
WHEN granted = 't' THEN
'wait_lock'
END lock_satus,
END waitting_satus,
least(query_start, xact_start) AS query_start,
substr(query, 1, 25) AS query_text
FROM pg_locks
left join pg_database pd
on (pg_locks.database=pd.oid)
LEFT OUTER JOIN pg_class
ON (pg_locks.relation = pg_class.oid)
LEFT OUTER JOIN pg_namespace
ON (pg_namespace.oid = pg_class.relnamespace), pg_stat_activity
WHERE NOT pg_locks.pid = pg_backend_pid()
AND pg_locks.pid = pg_stat_activity.pid
ORDER BY query_start;		 357   scan.l 1146  
2023-04-07 03:26:18.585189+08 mxadmin postgres p6480 th-404948864 127.0.0.1 11474 2023-04-07 03:26:17+08 0 con159 cmd1 seg-1       sx1 ERROR 42703 column "waiting" does not exist           SELECT pg_locks.pid as pid,
transactionid as transaction_id,
pd.datname db_name,
nspname as schemaname,
relname as object_name,
locktype as lock_type,
mode lock_mode,
CASE
WHEN granted = 'f' THEN
'get_lock'
WHEN granted = 't' THEN
'wait_lock'
END lock_satus,
CASE
WHEN waiting = 'false' THEN
'already get lock,sql executing'
WHEN waiting = 'true' THEN
'waiting get lock,sql waiting execute'
END waitting_satus,
least(query_start, xact_start) AS query_start,
substr(query, 1, 25) AS query_text
FROM pg_locks
left join pg_database pd
on (pg_locks.database=pd.oid)
LEFT OUTER JOIN pg_class
ON (pg_locks.relation = pg_class.oid)
LEFT OUTER JOIN pg_namespace
ON (pg_namespace.oid = pg_class.relnamespace), pg_stat_activity
WHERE NOT pg_locks.pid = pg_backend_pid()
AND pg_locks.pid = pg_stat_activity.pid
ORDER BY query_start;		 375   parse_relation.c 3677  
2023-04-07 03:25:09.009296+08 mxadmin postgres p6282 th-404948864 192.168.27.52 61781 2023-04-07 03:25:06+08 0 con154 cmd121 seg-1       sx1 ERROR 42P01 relation "session_state.session_level_memory_consumption" does not exist           SELECT *
FROM session_state.session_level_memory_consumption d
WHERE d.datname IS NOT NULL
ORDER BY
d.vmem_mb DESC,
d.sess_id,
d.segid
LIMIT 20;		 17   parse_relation.c 1223  
2023-04-07 03:25:08.547357+08 mxadmin postgres p6282 th-404948864 192.168.27.52 61781 2023-04-07 03:25:06+08 0 con154 cmd51 seg-1       sx1 ERROR 42703 column pgsa.waiting does not exist           SELECT pgsa.pid,
pgsa.sess_id,
pgsa.client_port,
pgsa.datname AS datname,
pgsa.usename AS usename,
(SELECT nb.rrrsqname from gp_toolkit.gp_resq_role nb where nb.rrrolname=pgsa.usename) rsqname,
pgsa.client_addr client_addr,
pgsa.application_name AS application_name,
pgsa.state AS state,
pgsa.waiting,
pgsa.waiting_reason,
pgsa.backend_start AS backend_start,
pgsa.xact_start AS xact_start,
state_change,
pgsa.query_start AS query_start,
TRUNC(EXTRACT( epoch FROM (NOW() - pgsa.xact_start) )) AS xact_stay,
trunc(EXTRACT( epoch FROM (NOW() - pgsa.query_start) )) AS query_stay,
REPLACE(pgsa.QUERY, chr(10), ' ') AS QUERY,
yc_filesize_GB,
yc_numfiles,
'select pg_terminate_backend('||pgsa.pid||');' kill1,
'select pg_cancel_backend('||pgsa.pid||');' kill2
FROM pg_stat_activity AS pgsa

LEFT JOIN (select pid,trunc(sum(size)/1024/1024/1024) as yc_filesize_GB,sum(numfiles) as yc_numfiles from gp_toolkit.gp_workfile_usage_per_query nb group by pid) as d
ON pgsa.pid=d.pid
WHERE pgsa.state not in ( 'idle' ,'idle in transaction (aborted)' )
ORDER BY query_stay DESC,xact_stay DESC
LIMIT 100;		 358   parse_relation.c 3677  
2023-04-07 03:25:08.44615+08 mxadmin postgres p6282 th-404948864 192.168.27.52 61781 2023-04-07 03:25:06+08 0 con154 cmd48 seg-1       sx1 ERROR 42703 column "waiting" does not exist           SELECT pg_locks.pid as pid,
transactionid as transaction_id,
pd.datname db_name,
nspname as schemaname,
relname as object_name,
locktype as lock_type,
mode lock_mode,
CASE
WHEN granted = 'f' THEN
'get_lock'
WHEN granted = 't' THEN
'wait_lock'
END lock_satus,
CASE
WHEN waiting = 'false' THEN
'already get lock,sql executing'
WHEN waiting = 'true' THEN
'waiting get lock,sql waiting execute'
END waitting_satus,
least(query_start, xact_start) AS query_start,
substr(query, 1, 25) AS query_text
FROM pg_locks
left join pg_database pd
on (pg_locks.database=pd.oid)
LEFT OUTER JOIN pg_class
ON (pg_locks.relation = pg_class.oid)
LEFT OUTER JOIN pg_namespace
ON (pg_namespace.oid = pg_class.relnamespace), pg_stat_activity
WHERE NOT pg_locks.pid = pg_backend_pid()
AND pg_locks.pid = pg_stat_activity.pid
ORDER BY query_start;		 392   parse_relation.c 3677  
2023-04-07 03:25:07.920419+08 mxadmin postgres p6282 th-404948864 192.168.27.52 61781 2023-04-07 03:25:06+08 0 con154 cmd31 seg-1       sx1 ERROR 38000 external table gp_disk_free command ended with error. Traceback (most recent call last):
File "<string>", line 1, in <module>
ModuleNotFoundError: No module named 'gppylib' (seg0 slice1 172.71.0.2:6000 pid=6284)		 Command: execute:python3 -c "from gppylib.commands import unix; df=unix.DiskFree.get_disk_free_info_local('token','$GP_SEG_DATADIR'); print('%s, %s, %s, %s' % ('$GP_SEGMENT_ID', unix.getLocalHostname(), df[0], df[3]))"         select dfsegment,dfhostname,dfdevice,round(dfspace/1024/1024,2) as free_disk_GB
from gp_toolkit.gp_disk_free
ORDER BY dfsegment ;		 0   url_execute.c 349  
2023-04-07 03:23:10.744+08 mxadmin mxadmin p5864 th-404948864 [local]   2023-04-07 03:23:10+08 0 con126   seg-1       sx1 FATAL 3D000 database "mxadmin" does not exist             0   postinit.c 1022  
2023-04-07 03:23:10.722701+08 mxadmin mxadmin p5865 th-404948864 [local]   2023-04-07 03:23:10+08 0 con122   seg-1       sx1 FATAL 3D000 database "mxadmin" does not exist             0   postinit.c 1022  
2023-04-07 03:23:10.719483+08 mxadmin mxadmin p5863 th-404948864 [local]   2023-04-07 03:23:10+08 0 con121   seg-1       sx1 FATAL 3D000 database "mxadmin" does not exist             0   postinit.c 1022  
2023-04-07 03:23:10.716957+08 mxadmin mxadmin p5861 th-404948864 [local]   2023-04-07 03:23:10+08 0 con120   seg-1       sx1 FATAL 3D000 database "mxadmin" does not exist             0   postinit.c 1022  
2023-04-07 03:23:10.698854+08 mxadmin mxadmin p5819 th-404948864 [local]   2023-04-07 03:23:10+08 0 con118   seg-1       sx1 FATAL 3D000 database "mxadmin" does not exist             0   postinit.c 1022  
2023-04-07 03:21:46.813639+08     p2978 th-404948864       0     seg-1         WARNING 01000 ic-proxy-server: received signal 1             0   ic_proxy_main.c 379  
2023-04-07 03:15:40.559701+08 mxadmin mxadmin p4444 th-404948864 [local]   2023-04-07 03:15:40+08 0 con72   seg-1       sx1 FATAL 3D000 database "mxadmin" does not exist             0   postinit.c 1022  
2023-04-07 03:15:20.046528+08 mxadmin mxdb p4396 th-404948864 127.0.0.1 63504 2023-04-07 03:15:20+08 0 con68   seg-1       sx1 FATAL 3D000 database "mxdb" does not exist             0   postinit.c 1022  
2023-04-07 03:14:47.756753+08 mxadmin mxadmin p4315 th-404948864 [local]   2023-04-07 03:14:47+08 0 con65   seg-1       sx1 FATAL 3D000 database "mxadmin" does not exist             0   postinit.c 1022  
2023-04-07 03:10:59.745585+08 mxadmin matrixmgr p3119 th-404948864 172.71.0.2 48764 2023-04-07 03:10:59+08 502 con18 cmd4 seg-1   dx4 x502 sx1 WARNING 42P16 referential integrity (FOREIGN KEY) constraints are not supported in Greenplum Database, will not be enforced         SQL statement "CREATE TABLE matrixts_internal.apm_rel_policy_action (
reloid oid NOT NULL
, class_id int NOT NULL
, action name NOT NULL
, disabled bool DEFAULT NULL
, check_func regproc DEFAULT NULL -- If not NULL, override apm_policy_action
, check_args jsonb DEFAULT NULL
, act_func regproc DEFAULT NULL
, act_args jsonb DEFAULT NULL
, term_func regproc DEFAULT NULL
, term_args jsonb DEFAULT NULL
, version name DEFAULT NULL
, PRIMARY KEY (reloid, class_id, action)
, FOREIGN KEY (reloid, class_id) REFERENCES matrixts_internal.apm_rel_policy (reloid, class_id)
, FOREIGN KEY (class_id, action) REFERENCES matrixts_internal.apm_policy_action (class_id, action)
) DISTRIBUTED MASTERONLY"
PL/pgSQL function inline_code_block line 73 at SQL statement		 CREATE EXTENSION IF NOT EXISTS matrixts WITH SCHEMA public CASCADE 0   tablecmds.c 12102  
2023-04-07 03:10:59.745085+08 mxadmin matrixmgr p3119 th-404948864 172.71.0.2 48764 2023-04-07 03:10:59+08 502 con18 cmd4 seg-1   dx4 x502 sx1 WARNING 42P16 referential integrity (FOREIGN KEY) constraints are not supported in Greenplum Database, will not be enforced         SQL statement "CREATE TABLE matrixts_internal.apm_rel_policy_action (
reloid oid NOT NULL
, class_id int NOT NULL
, action name NOT NULL
, disabled bool DEFAULT NULL
, check_func regproc DEFAULT NULL -- If not NULL, override apm_policy_action
, check_args jsonb DEFAULT NULL
, act_func regproc DEFAULT NULL
, act_args jsonb DEFAULT NULL
, term_func regproc DEFAULT NULL
, term_args jsonb DEFAULT NULL
, version name DEFAULT NULL
, PRIMARY KEY (reloid, class_id, action)
, FOREIGN KEY (reloid, class_id) REFERENCES matrixts_internal.apm_rel_policy (reloid, class_id)
, FOREIGN KEY (class_id, action) REFERENCES matrixts_internal.apm_policy_action (class_id, action)
) DISTRIBUTED MASTERONLY"
PL/pgSQL function inline_code_block line 73 at SQL statement		 CREATE EXTENSION IF NOT EXISTS matrixts WITH SCHEMA public CASCADE 0   tablecmds.c 12102  
2023-04-07 03:10:59.68101+08 mxadmin matrixmgr p3119 th-404948864 172.71.0.2 48764 2023-04-07 03:10:59+08 502 con18 cmd4 seg-1   dx4 x502 sx1 WARNING 42P16 referential integrity (FOREIGN KEY) constraints are not supported in Greenplum Database, will not be enforced         SQL statement "CREATE TABLE matrixts_internal.apm_rel_policy (
reloid oid NOT NULL
, class_id int NOT NULL
, list_func regproc DEFAULT NULL
, list_args jsonb DEFAULT NULL
, version name DEFAULT NULL
, PRIMARY KEY (reloid, class_id)
, FOREIGN KEY (class_id) REFERENCES matrixts_internal.apm_policy_class (class_id)
) DISTRIBUTED MASTERONLY"
PL/pgSQL function inline_code_block line 49 at SQL statement		 CREATE EXTENSION IF NOT EXISTS matrixts WITH SCHEMA public CASCADE 0   tablecmds.c 12102  
2023-04-07 03:10:59.630559+08 mxadmin matrixmgr p3119 th-404948864 172.71.0.2 48764 2023-04-07 03:10:59+08 502 con18 cmd4 seg-1   dx4 x502 sx1 WARNING 42P16 referential integrity (FOREIGN KEY) constraints are not supported in Greenplum Database, will not be enforced         SQL statement "CREATE TABLE matrixts_internal.apm_policy_action (
class_id int NOT NULL
, action name NOT NULL
, seq int NOT NULL
, default_disabled bool NOT NULL DEFAULT FALSE
, default_check_func regproc NOT NULL
, default_check_args jsonb NOT NULL DEFAULT '{}'
, default_act_func regproc NOT NULL
, default_act_args jsonb NOT NULL DEFAULT '{}'
, default_term_func regproc DEFAULT NULL
, default_term_args jsonb DEFAULT NULL
, set_func regproc NOT NULL
, version name NOT NULL
, PRIMARY KEY (class_id, action)
, UNIQUE (class_id, seq)
, FOREIGN KEY (class_id) REFERENCES matrixts_internal.apm_policy_class (class_id)
) DISTRIBUTED MASTERONLY"
PL/pgSQL function inline_code_block line 10 at SQL statement		 CREATE EXTENSION IF NOT EXISTS matrixts WITH SCHEMA public CASCADE 0   tablecmds.c 12102  
2023-04-07 03:10:55.210655+08     p2877 th-1423910784       0     seg-1         WARNING 01000 ic-proxy-server: received signal 15             0   ic_proxy_main.c 379  
2023-04-07 03:10:55.210643+08     p2878 th-1423910784       0     seg-1         FATAL 57P01 terminating background worker "sweeper process" due to administrator command             0   bgworker.c 716  

● segment库近7天的错误日志
logtime loguser logdatabase logpid logthread loghost logport logsessiontime logtransaction logsession logcmdcount logsegment logslice logdistxact loglocalxact logsubxact logseverity logstate logmessage logdetail loghint logquery logquerypos logcontext logdebug logcursorpos logfunction logfile logline logstack
2023-04-07 03:30:02.420367+08 mxadmin postgres p7227 th1462286464 172.71.0.2 50318 2023-04-07 03:30:02+08 0 con159 cmd19 seg2 slice1     sx1 ERROR 25M01 canceling MPP operation           select *
from gp_toolkit.gp_disk_free
ORDER BY dfsegment ;		 0   postgres.c 4015  
2023-04-07 03:30:02.418947+08 mxadmin postgres p7228 th1396811904 172.71.0.2 17982 2023-04-07 03:30:02+08 0 con159 cmd19 seg3 slice1     sx1 ERROR 38000 external table gp_disk_free command ended with error. Traceback (most recent call last):
File "<string>", line 1, in <module>
ModuleNotFoundError: No module named 'gppylib'		 Command: execute:python3 -c "from gppylib.commands import unix; df=unix.DiskFree.get_disk_free_info_local('token','$GP_SEG_DATADIR'); print('%s, %s, %s, %s' % ('$GP_SEGMENT_ID', unix.getLocalHostname(), df[0], df[3]))"         select *
from gp_toolkit.gp_disk_free
ORDER BY dfsegment ;		 0   url_execute.c 349  
2023-04-07 03:30:02.412383+08 mxadmin postgres p7225 th-1306040192 172.71.0.2 59810 2023-04-07 03:30:02+08 0 con159 cmd19 seg0 slice1     sx1 ERROR 38000 external table gp_disk_free command ended with error. Traceback (most recent call last):
File "<string>", line 1, in <module>
ModuleNotFoundError: No module named 'gppylib'		 Command: execute:python3 -c "from gppylib.commands import unix; df=unix.DiskFree.get_disk_free_info_local('token','$GP_SEG_DATADIR'); print('%s, %s, %s, %s' % ('$GP_SEGMENT_ID', unix.getLocalHostname(), df[0], df[3]))"         select *
from gp_toolkit.gp_disk_free
ORDER BY dfsegment ;		 0   url_execute.c 349  
2023-04-07 03:30:02.410918+08 mxadmin postgres p7226 th-777443200 172.71.0.2 22474 2023-04-07 03:30:02+08 0 con159 cmd19 seg1 slice1     sx1 ERROR 38000 external table gp_disk_free command ended with error. Traceback (most recent call last):
File "<string>", line 1, in <module>
ModuleNotFoundError: No module named 'gppylib'		 Command: execute:python3 -c "from gppylib.commands import unix; df=unix.DiskFree.get_disk_free_info_local('token','$GP_SEG_DATADIR'); print('%s, %s, %s, %s' % ('$GP_SEGMENT_ID', unix.getLocalHostname(), df[0], df[3]))"         select *
from gp_toolkit.gp_disk_free
ORDER BY dfsegment ;		 0   url_execute.c 349  
2023-04-07 03:29:16.959678+08 mxadmin postgres p6969 th1396811904 172.71.0.2 17628 2023-04-07 03:29:09+08 0 con159 cmd15 seg3 slice1     sx1 ERROR 38000 external table gp_disk_free command ended with error. Traceback (most recent call last):
File "<string>", line 1, in <module>
ModuleNotFoundError: No module named 'gppylib'		 Command: execute:python3 -c "from gppylib.commands import unix; df=unix.DiskFree.get_disk_free_info_local('token','$GP_SEG_DATADIR'); print('%s, %s, %s, %s' % ('$GP_SEGMENT_ID', unix.getLocalHostname(), df[0], df[3]))"         select dfsegment,dfhostname,dfdevice,round(dfspace/1024/1024,2) as free_disk_GB
from gp_toolkit.gp_disk_free
ORDER BY dfsegment ;		 0   url_execute.c 349  
2023-04-07 03:29:16.949949+08 mxadmin postgres p6971 th-777443200 172.71.0.2 22120 2023-04-07 03:29:09+08 0 con159 cmd15 seg1 slice1     sx1 ERROR 25M01 canceling MPP operation           select dfsegment,dfhostname,dfdevice,round(dfspace/1024/1024,2) as free_disk_GB
from gp_toolkit.gp_disk_free
ORDER BY dfsegment ;		 0   postgres.c 4015  
2023-04-07 03:29:16.94706+08 mxadmin postgres p6970 th1462286464 172.71.0.2 49964 2023-04-07 03:29:09+08 0 con159 cmd15 seg2 slice1     sx1 ERROR 38000 external table gp_disk_free command ended with error. Traceback (most recent call last):
File "<string>", line 1, in <module>
ModuleNotFoundError: No module named 'gppylib'		 Command: execute:python3 -c "from gppylib.commands import unix; df=unix.DiskFree.get_disk_free_info_local('token','$GP_SEG_DATADIR'); print('%s, %s, %s, %s' % ('$GP_SEGMENT_ID', unix.getLocalHostname(), df[0], df[3]))"         select dfsegment,dfhostname,dfdevice,round(dfspace/1024/1024,2) as free_disk_GB
from gp_toolkit.gp_disk_free
ORDER BY dfsegment ;		 0   url_execute.c 349  
2023-04-07 03:29:16.941406+08 mxadmin postgres p6968 th-1306040192 172.71.0.2 59456 2023-04-07 03:29:09+08 0 con159 cmd15 seg0 slice1     sx1 ERROR 38000 external table gp_disk_free command ended with error. Traceback (most recent call last):
File "<string>", line 1, in <module>
ModuleNotFoundError: No module named 'gppylib'		 Command: execute:python3 -c "from gppylib.commands import unix; df=unix.DiskFree.get_disk_free_info_local('token','$GP_SEG_DATADIR'); print('%s, %s, %s, %s' % ('$GP_SEGMENT_ID', unix.getLocalHostname(), df[0], df[3]))"         select dfsegment,dfhostname,dfdevice,round(dfspace/1024/1024,2) as free_disk_GB
from gp_toolkit.gp_disk_free
ORDER BY dfsegment ;		 0   url_execute.c 349  
2023-04-07 03:28:42.063883+08 mxadmin postgres p6856 th1462286464 172.71.0.2 49834 2023-04-07 03:28:41+08 0 con166 cmd31 seg2 slice1     sx1 ERROR 38000 external table gp_disk_free command ended with error. Traceback (most recent call last):
File "<string>", line 1, in <module>
ModuleNotFoundError: No module named 'gppylib'		 Command: execute:python3 -c "from gppylib.commands import unix; df=unix.DiskFree.get_disk_free_info_local('token','$GP_SEG_DATADIR'); print('%s, %s, %s, %s' % ('$GP_SEGMENT_ID', unix.getLocalHostname(), df[0], df[3]))"         select dfsegment,dfhostname,dfdevice,round(dfspace/1024/1024,2) as free_disk_GB
from gp_toolkit.gp_disk_free
ORDER BY dfsegment ;		 0   url_execute.c 349  
2023-04-07 03:28:42.062049+08 mxadmin postgres p6855 th1396811904 172.71.0.2 17498 2023-04-07 03:28:41+08 0 con166 cmd31 seg3 slice1     sx1 ERROR 38000 external table gp_disk_free command ended with error. Traceback (most recent call last):
File "<string>", line 1, in <module>
ModuleNotFoundError: No module named 'gppylib'		 Command: execute:python3 -c "from gppylib.commands import unix; df=unix.DiskFree.get_disk_free_info_local('token','$GP_SEG_DATADIR'); print('%s, %s, %s, %s' % ('$GP_SEGMENT_ID', unix.getLocalHostname(), df[0], df[3]))"         select dfsegment,dfhostname,dfdevice,round(dfspace/1024/1024,2) as free_disk_GB
from gp_toolkit.gp_disk_free
ORDER BY dfsegment ;		 0   url_execute.c 349  
2023-04-07 03:28:42.062033+08 mxadmin postgres p6853 th-1306040192 172.71.0.2 59326 2023-04-07 03:28:41+08 0 con166 cmd31 seg0 slice1     sx1 ERROR 38000 external table gp_disk_free command ended with error. Traceback (most recent call last):
File "<string>", line 1, in <module>
ModuleNotFoundError: No module named 'gppylib'		 Command: execute:python3 -c "from gppylib.commands import unix; df=unix.DiskFree.get_disk_free_info_local('token','$GP_SEG_DATADIR'); print('%s, %s, %s, %s' % ('$GP_SEGMENT_ID', unix.getLocalHostname(), df[0], df[3]))"         select dfsegment,dfhostname,dfdevice,round(dfspace/1024/1024,2) as free_disk_GB
from gp_toolkit.gp_disk_free
ORDER BY dfsegment ;		 0   url_execute.c 349  
2023-04-07 03:28:42.061825+08 mxadmin postgres p6854 th-777443200 172.71.0.2 21990 2023-04-07 03:28:41+08 0 con166 cmd31 seg1 slice1     sx1 ERROR 38000 external table gp_disk_free command ended with error. Traceback (most recent call last):
File "<string>", line 1, in <module>
ModuleNotFoundError: No module named 'gppylib'		 Command: execute:python3 -c "from gppylib.commands import unix; df=unix.DiskFree.get_disk_free_info_local('token','$GP_SEG_DATADIR'); print('%s, %s, %s, %s' % ('$GP_SEGMENT_ID', unix.getLocalHostname(), df[0], df[3]))"         select dfsegment,dfhostname,dfdevice,round(dfspace/1024/1024,2) as free_disk_GB
from gp_toolkit.gp_disk_free
ORDER BY dfsegment ;		 0   url_execute.c 349  
2023-04-07 03:25:07.910439+08 mxadmin postgres p6285 th1462286464 172.71.0.2 48816 2023-04-07 03:25:06+08 0 con154 cmd31 seg2 slice1     sx1 ERROR 38000 external table gp_disk_free command ended with error. Traceback (most recent call last):
File "<string>", line 1, in <module>
ModuleNotFoundError: No module named 'gppylib'		 Command: execute:python3 -c "from gppylib.commands import unix; df=unix.DiskFree.get_disk_free_info_local('token','$GP_SEG_DATADIR'); print('%s, %s, %s, %s' % ('$GP_SEGMENT_ID', unix.getLocalHostname(), df[0], df[3]))"         select dfsegment,dfhostname,dfdevice,round(dfspace/1024/1024,2) as free_disk_GB
from gp_toolkit.gp_disk_free
ORDER BY dfsegment ;		 0   url_execute.c 349  
2023-04-07 03:25:07.90569+08 mxadmin postgres p6287 th-777443200 172.71.0.2 20972 2023-04-07 03:25:06+08 0 con154 cmd31 seg1 slice1     sx1 ERROR 25M01 canceling MPP operation           select dfsegment,dfhostname,dfdevice,round(dfspace/1024/1024,2) as free_disk_GB
from gp_toolkit.gp_disk_free
ORDER BY dfsegment ;		 0   postgres.c 4015  
2023-04-07 03:25:07.902163+08 mxadmin postgres p6286 th1396811904 172.71.0.2 16480 2023-04-07 03:25:06+08 0 con154 cmd31 seg3 slice1     sx1 ERROR 38000 external table gp_disk_free command ended with error. Traceback (most recent call last):
File "<string>", line 1, in <module>
ModuleNotFoundError: No module named 'gppylib'		 Command: execute:python3 -c "from gppylib.commands import unix; df=unix.DiskFree.get_disk_free_info_local('token','$GP_SEG_DATADIR'); print('%s, %s, %s, %s' % ('$GP_SEGMENT_ID', unix.getLocalHostname(), df[0], df[3]))"         select dfsegment,dfhostname,dfdevice,round(dfspace/1024/1024,2) as free_disk_GB
from gp_toolkit.gp_disk_free
ORDER BY dfsegment ;		 0   url_execute.c 349  
2023-04-07 03:25:07.898065+08 mxadmin postgres p6284 th-1306040192 172.71.0.2 58308 2023-04-07 03:25:06+08 0 con154 cmd31 seg0 slice1     sx1 ERROR 38000 external table gp_disk_free command ended with error. Traceback (most recent call last):
File "<string>", line 1, in <module>
ModuleNotFoundError: No module named 'gppylib'		 Command: execute:python3 -c "from gppylib.commands import unix; df=unix.DiskFree.get_disk_free_info_local('token','$GP_SEG_DATADIR'); print('%s, %s, %s, %s' % ('$GP_SEGMENT_ID', unix.getLocalHostname(), df[0], df[3]))"         select dfsegment,dfhostname,dfdevice,round(dfspace/1024/1024,2) as free_disk_GB
from gp_toolkit.gp_disk_free
ORDER BY dfsegment ;		 0   url_execute.c 349  
2023-04-07 03:21:46.800634+08     p2942 th1396811904       0     seg3         WARNING 01000 ic-proxy-server: received signal 1             0   ic_proxy_main.c 379  
2023-04-07 03:21:46.799492+08     p2921 th-777443200       0     seg1         WARNING 01000 ic-proxy-server: received signal 1             0   ic_proxy_main.c 379  
2023-04-07 03:21:46.798279+08     p2928 th-1306040192       0     seg0         WARNING 01000 ic-proxy-server: received signal 1             0   ic_proxy_main.c 379  
2023-04-07 03:21:46.796151+08     p2935 th1462286464       0     seg2         WARNING 01000 ic-proxy-server: received signal 1             0   ic_proxy_main.c 379  

[回到目录]

其它

● 所有角色(用户)
rolname rolsuper rolinherit rolcreaterole rolcreatedb rolcanlogin rolreplication rolconnlimit rolpassword rolvaliduntil rolbypassrls rolconfig rolresqueue oid rolcreaterextgpfd rolcreaterexthttp rolcreatewextgpfd rolresgroup
pg_monitor f t f f f f -1 ********   f   6055 3373 f f f 6438
pg_read_all_settings f t f f f f -1 ********   f   6055 3374 f f f 6438
pg_read_all_stats f t f f f f -1 ********   f   6055 3375 f f f 6438
pg_stat_scan_tables f t f f f f -1 ********   f   6055 3377 f f f 6438
pg_read_server_files f t f f f f -1 ********   f   6055 4569 f f f 6438
pg_write_server_files f t f f f f -1 ********   f   6055 4570 f f f 6438
pg_execute_server_program f t f f f f -1 ********   f   6055 4571 f f f 6438
pg_signal_backend f t f f f f -1 ********   f   6055 4200 f f f 6438
mxadmin t t t t t t -1 ********   t   6055 10 f f f 6438

● pg_user

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

● pg_shadow

usename usesysid usecreatedb usesuper userepl usebypassrls passwd valuntil useconfig
mxadmin 10 t t t t md575d960357dee6ec1f4da429e7906b8e9    

● 授权信息
raroleid rarolename ramemberid ramembername
3374 pg_read_all_settings 3373 pg_monitor
3375 pg_read_all_stats 3373 pg_monitor
3377 pg_stat_scan_tables 3373 pg_monitor

● 当前库的所有schema
catalog_name schema_name schema_owner default_character_set_catalog default_character_set_schema default_character_set_name sql_path
postgres matrixmgr_internal mxadmin        
postgres gp_toolkit mxadmin        
postgres information_schema mxadmin        
postgres public mxadmin        
postgres pg_catalog mxadmin        
postgres pg_toast_temp_01 mxadmin        
postgres pg_temp_01 mxadmin        
postgres pg_bitmapindex mxadmin        
postgres pg_aoseg mxadmin        
postgres pg_toast mxadmin        

● 所有语言
oid lanname lanowner lanispl lanpltrusted lanplcallfoid laninline lanvalidator lanacl
12 internal 10 f f 0 0 2246  
13 c 10 f f 0 0 2247  
14 sql 10 f t 0 0 2248  
13162 plpgsql 10 t t 13159 13160 13161  

● 所有可用插件

● 所有插件（已编译）
name default_version installed_version comment
citext 1.6   data type for case-insensitive character strings
dblink 1.2   connect to other PostgreSQL databases from within a database
file_fdw 1.0   foreign-data wrapper for flat file access
matrixts 2.13   matrixdb time series extension
hstore 1.6   data type for storing sets of (key, value) pairs
mxprofile 1.0   ymatrix profile extension
fuzzystrmatch 1.1   determine similarities and distance between strings
gp_debug_numsegments 1.0   get / set default numsegments when creating tables
gp_distribution_policy 1.0   check distribution policy in a GPDB cluster
gp_exttable_fdw 1.0 1.0 External Table Foreign Data Wrapper for Greenplum
mxvector 0.1   MatrixDB Vectorized Execution Engine
gp_inject_fault 1.0   simulate various faults for testing purposes
gp_internal_tools 1.0.0   Different internal tools for Greenplum
gp_replica_check 0.0.1    
gp_sparse_vector 1.0.0   SParse vector implementation for GreenPlum
pageinspect 1.7   inspect the contents of database pages at a low level
matrixmgr 5.0   matrixdb monitor and management extension
orafce 3.13   Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS
pg_hint_plan 1.3.7    
plperl 1.0   PL/Perl procedural language
plperlu 1.0   PL/PerlU untrusted procedural language
plpgsql 1.0 1.0 PL/pgSQL procedural language
plpython3u 1.0   PL/Python3U untrusted procedural language
pxf_fdw 1.0   PXF Foreign Data Wrapper for Greenplum
sslinfo 1.2   information about SSL certificates

● 已安装的插件
Name Version Schema Description
gp_exttable_fdw 1.0 pg_catalog External Table Foreign Data Wrapper for Greenplum
plpgsql 1.0 pg_catalog PL/pgSQL procedural language

[回到目录]