devbox
小小林熬夜学编程
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

PostgreSQL pg 的SQL优化相关工具和方法_pg数据库优化的命令

作者：小小林熬夜学编程 | 2024-02-23 09:19:03

赞

踩

pg数据库优化的命令

SQL优化通常是较为复杂的工作，需要很多SQL语法知识和优化器相关知识。但是，相关分析诊断工具也非常重要。掌握了这些工具，也非常有助于提升SQL优化器相关技术知识。

SQL优化的主要工具通常是访问计划、统计信息和调试信息。下面是pg相关工具的官方文档。

pg的EXPLAIN命令说明文档：
https://www.postgresql.org/docs/9.3/sql-explain.html

pg的ANALYZE命令说明文档
https://www.postgresql.org/docs/9.3/sql-analyze.html

pg日志打开调试日志，可以看到优化器的诊断信息，官方文档：
https://www.postgresql.org/docs/9.3/runtime-config-logging.html

下面内容简要展示这些工具的使用方法。

查看当前所有连接状态，含正在执行的SQL：

test=# select * from pg_stat_activity;
 datid | datname |  pid  | usesysid | usename  | application_name | client_addr | client_hostname | client_port |        backend_start         |          xact_start   
       |         query_start          |         state_change          | waiting | state  |              query              
-------+---------+-------+----------+----------+------------------+-------------+-----------------+-------------+------------------------------+-----------------------
-------+------------------------------+-------------------------------+---------+--------+---------------------------------
 16384 | test    | 49723 |       10 | sdbadmin | psql             |             |                 |          -1 | 2020-01-08 19:26:38.72099+08 | 2020-01-08 22:28:42.02
633+08 | 2020-01-08 22:28:42.02633+08 | 2020-01-08 22:28:42.026334+08 | f       | active | select * from pg_stat_activity;
(1 row)

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8

只生成访问计划：

test=#  EXPLAIN (ANALYZE FALSE, VERBOSE TRUE, COSTS TRUE, BUFFERS FALSE, TIMING FALSE, FORMAT TEXT) select * from accounts where  account_id='A11111';
                             QUERY PLAN                             
--------------------------------------------------------------------
 Foreign Scan on public.accounts  (cost=0.00..0.06 rows=1 width=18)
   Output: account_id, cust_id, balance
   Filter: (accounts.account_id = 'A11111'::text)
   Foreign Namespace: test_db.accounts
     Filter: ({ "account_id": { "$et": "A11111" } })
(5 rows)

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9

收集统计信息、执行并生成访问计划：

test=# EXPLAIN (ANALYZE TRUE, VERBOSE TRUE, COSTS TRUE, BUFFERS TRUE, TIMING TRUE, FORMAT TEXT) select * from accounts where  account_id='A11111';
                                                  QUERY PLAN                                                  
--------------------------------------------------------------------------------------------------------------
 Foreign Scan on public.accounts  (cost=0.00..0.06 rows=1 width=18) (actual time=7.288..7.290 rows=1 loops=1)
   Output: account_id, cust_id, balance
   Filter: (accounts.account_id = 'A11111'::text)
   Foreign Namespace: test_db.accounts
     Filter: ({ "account_id": { "$et": "A11111" } })
 Total runtime: 8.675 ms
(6 rows)

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10

生成统计信息：

test=# analyze verbose accounts;
INFO:  analyzing "public.accounts"
INFO:  "accounts": collection contains 1 rows; 1 rows in sample
ANALYZE

  • 1
  • 2
  • 3
  • 4

查看统计信息：

test=# select * from pg_class where relname='accounts';
 relname  | relnamespace | reltype | reloftype | relowner | relam | relfilenode | reltablespace | relpages | reltuples | relallvisible | reltoastrelid | reltoastidxid 
| relhasindex | relisshared | relpersistence | relkind | relnatts | relchecks | relhasoids | relhaspkey | relhasrules | relhastriggers | relhassubclass | relispopulate
d | relfrozenxid | relminmxid | relacl | reloptions 
----------+--------------+---------+-----------+----------+-------+-------------+---------------+----------+-----------+---------------+---------------+---------------
+-------------+-------------+----------------+---------+----------+-----------+------------+------------+-------------+----------------+----------------+--------------
--+--------------+------------+--------+------------
 accounts |         2200 |   49163 |         0 |       10 |     0 |       49161 |             0 |        0 |         1 |             0 |             0 |             0 
| f           | f           | p              | f       |        3 |         0 | f          | f          | f           | f              | f              | t            
  |            0 |          0 |        | 
(1 row)

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11

注： reltuples 是记录数。

查看数值分布：

test=# select * from pg_stats where tablename='accounts';
 schemaname | tablename |  attname   | inherited | null_frac | avg_width | n_distinct | most_common_vals | most_common_freqs | histogram_bounds | correlation | most_co
mmon_elems | most_common_elem_freqs | elem_count_histogram 
------------+-----------+------------+-----------+-----------+-----------+------------+------------------+-------------------+------------------+-------------+--------
-----------+------------------------+----------------------
 public     | accounts  | account_id | f         |         0 |         7 |         -1 |                  |                   |                  |             |        
           |                        | 
 public     | accounts  | cust_id    | f         |         0 |         6 |         -1 |                  |                   |                  |             |        
           |                        | 
 public     | accounts  | balance    | f         |         0 |         5 |         -1 |                  |                   |                  |             |        
           |                        | 
(3 rows)

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12

修改pg配置参数，然后生效，以便于打开调试模式：

test=# SET log_min_messages=debug5;
SET
test=# SET debug_print_parse=on;
SET
test=# SET debug_print_rewritten=on;
SET
test=# SET debug_print_plan=on;
SET
test=# SET debug_pretty_print=on;
SET
test=# SELECT pg_reload_conf();
 pg_reload_conf 
----------------
 t
(1 row)

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15

注释：debug5这个日志级别会造成大量日志记录，分析诊断完成之后，记得将这些值修改回原来值。

debug5模式下，日志记录的示例内容：
下面是执行 explain select * from accounts where account_id=‘A11111’; 时的日志记录：

2020-01-08 23:21:32.990 CST 25843 [local]DEBUG:  StartTransactionCommand
2020-01-08 23:21:32.990 CST 25843 [local]DEBUG:  StartTransaction
2020-01-08 23:21:32.990 CST 25843 [local]DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children: 
2020-01-08 23:21:32.991 CST 25843 [local]LOG:  parse tree:
2020-01-08 23:21:32.991 CST 25843 [local]DETAIL:     {QUERY 
	   :commandType 5 
	   :querySource 0 
	   :canSetTag true 
	   :utilityStmt ? 
	   :resultRelation 0 
	   :hasAggs false 
	   :hasWindowFuncs false 
	   :hasSubLinks false 
	   :hasDistinctOn false 
	   :hasRecursive false 
	   :hasModifyingCTE false 
	   :hasForUpdate false 
	   :cteList <> 
	   :rtable <> 
	   :jointree <> 
	   :targetList <> 
	   :returningList <> 
	   :groupClause <> 
	   :havingQual <> 
	   :windowClause <> 
	   :distinctClause <> 
	   :sortClause <> 
	   :limitOffset <> 
	   :limitCount <> 
	   :rowMarks <> 
	   :setOperations <> 
	   :constraintDeps <>
	   }
	
2020-01-08 23:21:32.991 CST 25843 [local]STATEMENT:  explain select * from accounts where account_id='A11111';
2020-01-08 23:21:32.991 CST 25843 [local]LOG:  rewritten parse tree:
2020-01-08 23:21:32.991 CST 25843 [local]DETAIL:  (
	   {QUERY 
	   :commandType 5 
	   :querySource 0 
	   :canSetTag true 
	   :utilityStmt ? 
	   :resultRelation 0 
	   :hasAggs false 
	   :hasWindowFuncs false 
	   :hasSubLinks false 
	   :hasDistinctOn false 
	   :hasRecursive false 
	   :hasModifyingCTE false 
	   :hasForUpdate false 
	   :cteList <> 
	   :rtable <> 
	   :jointree <> 
	   :targetList <> 
	   :returningList <> 
	   :groupClause <> 
	   :havingQual <> 
	   :windowClause <> 
	   :distinctClause <> 
	   :sortClause <> 
	   :limitOffset <> 
	   :limitCount <> 
	   :rowMarks <> 
	   :setOperations <> 
	   :constraintDeps <>
	   }
	)
	
2020-01-08 23:21:32.991 CST 25843 [local]STATEMENT:  explain select * from accounts where account_id='A11111';
2020-01-08 23:21:32.991 CST 25843 [local]DEBUG:  ProcessUtility
2020-01-08 23:21:32.992 CST 25843 [local]DEBUG:  hostName=c1:11810,c2:11810,c3:11810,service=0
2020-01-08 23:21:32.992 CST 25843 [local]DEBUG:  foreign table:49161, handle found:0
2020-01-08 23:21:32.992 CST 25843 [local]DEBUG:  hostName=c1:11810,c2:11810,c3:11810,service=0
2020-01-08 23:21:32.993 CST 25843 [local]DEBUG:  hostName=c1:11810,c2:11810,c3:11810,service=0
2020-01-08 23:21:32.993 CST 25843 [local]DEBUG:  connecting :list=c1:11810:c2:11810:c3:11810:::,num=3
2020-01-08 23:21:33.006 CST 25843 [local]DEBUG:  bson value={ "PreferedInstance": "a", "Source": "pg-25843" },label[display session attr]
2020-01-08 23:21:33.006 CST 25843 [local]DEBUG:  setting session attr
2020-01-08 23:21:33.040 CST 25843 [local]DEBUG:  var info:foreign_table_id=49161, varattno=1, valevelsup=0
2020-01-08 23:21:33.040 CST 25843 [local]DEBUG:  isSortCanPushDown:empty pathkeys
2020-01-08 23:21:33.040 CST 25843 [local]DEBUG:  foreign table:49161, handle found:1
2020-01-08 23:21:33.040 CST 25843 [local]DEBUG:  get index from db
2020-01-08 23:21:33.048 CST 25843 [local]DEBUG:  SdbGetForeignPaths:foreignPath={FOREIGNPATH :pathtype 120 :parent_relids (b 1) :required_outer (b) :rows 1 :startup_cost 0.00 :total_cost 0.06 :pathkeys <> :fdw_private <>}
2020-01-08 23:21:33.048 CST 25843 [local]DEBUG:  foreign table:49161, handle found:1
2020-01-08 23:21:33.048 CST 25843 [local]DEBUG:  SdbGetForeignPlan:bestPath={FOREIGNPATH :pathtype 120 :parent_relids (b 1) :required_outer (b) :rows 1 :startup_cost 0.00 :total_cost 0.06 :pathkeys <> :fdw_private <>}
2020-01-08 23:21:33.049 CST 25843 [local]DEBUG:  var info:foreign_table_id=49161, varattno=1, valevelsup=0
2020-01-08 23:21:33.049 CST 25843 [local]DEBUG:  bson value={ "account_id": { "$et": "A11111" } },label[SdbGetForeignPlan query]
2020-01-08 23:21:33.049 CST 25843 [local]DEBUG:  reset parse's limit and offset
2020-01-08 23:21:33.049 CST 25843 [local]DEBUG:  SdbAllocRecord:usedCount=1,index=0
2020-01-08 23:21:33.051 CST 25843 [local]LOG:  plan:
2020-01-08 23:21:33.051 CST 25843 [local]DETAIL:     {PLANNEDSTMT 
	   :commandType 1 
	   :queryId 0 
	   :hasReturning false 
	   :hasModifyingCTE false 
	   :canSetTag true 
	   :transientPlan false 
	   :planTree 
	      {FOREIGNSCAN 
	      :startup_cost 0.00 
	      :total_cost 0.06 
	      :plan_rows 1 
	      :plan_width 18 
	      :targetlist (
	         {TARGETENTRY 
	         :expr 
	            {VAR 
	            :varno 1 
	            :varattno 1 
	            :vartype 25 
	            :vartypmod -1 
	            :varcollid 100 
	            :varlevelsup 0 
	            :varnoold 1 
	            :varoattno 1 
	            :location 15
	            }
	         :resno 1 
	         :resname account_id 
	         :ressortgroupref 0 
	         :resorigtbl 49161 
	         :resorigcol 1 
	         :resjunk false
	         }
	         {TARGETENTRY 
	         :expr 
	            {VAR 
	            :varno 1 
	            :varattno 2 
	            :vartype 25 
	            :vartypmod -1 
	            :varcollid 100 
	            :varlevelsup 0 
	            :varnoold 1 
	            :varoattno 2 
	            :location 15
	            }
	         :resno 2 
	         :resname cust_id 
	         :ressortgroupref 0 
	         :resorigtbl 49161 
	         :resorigcol 2 
	         :resjunk false
	         }
	         {TARGETENTRY 
	         :expr 
	            {VAR 
	            :varno 1 
	            :varattno 3 
	            :vartype 1700 
	            :vartypmod 1310730 
	            :varcollid 0 
	            :varlevelsup 0 
	            :varnoold 1 
	            :varoattno 3 
	            :location 15
	            }
	         :resno 3 
	         :resname balance 
	         :ressortgroupref 0 
	         :resorigtbl 49161 
	         :resorigcol 3 
	         :resjunk false
	         }
	      )
	      :qual (
	         {OPEXPR 
	         :opno 98 
	         :opfuncid 67 
	         :opresulttype 16 
	         :opretset false 
	         :opcollid 0 
	         :inputcollid 100 
	         :args (
	            {VAR 
	            :varno 1 
	            :varattno 1 
	            :vartype 25 
	            :vartypmod -1 
	            :varcollid 100 
	            :varlevelsup 0 
	            :varnoold 1 
	            :varoattno 1 
	            :location 37
	            }
	            {CONST 
	            :consttype 25 
	            :consttypmod -1 
	            :constcollid 100 
	            :constlen -1 
	            :constbyval false 
	            :constisnull false 
	            :location 48 
	            :constvalue 10 [ 40 0 0 0 65 49 49 49 49 49 ]
	            }
	         )
	         :location 47
	         }
	      )
	      :lefttree <> 
	      :righttree <> 
	      :initPlan <> 
	      :extParam (b)
	      :allParam (b)
	      :scanrelid 1 
	      :fdw_exprs <> 
	      :fdw_private ((
	         {CONST 
	         :consttype 23 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen 4 
	         :constbyval true 
	         :constisnull false 
	         :location -1 
	         :constvalue 4 [ 3 0 0 0 0 0 0 0 ]
	         }
	         {CONST 
	         :consttype 25 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen -1 
	         :constbyval false 
	         :constisnull false 
	         :location -1 
	         :constvalue 12 [ 48 0 0 0 99 49 58 49 49 56 49 48 ]
	         }
	         {CONST 
	         :consttype 25 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen -1 
	         :constbyval false 
	         :constisnull false 
	         :location -1 
	         :constvalue 12 [ 48 0 0 0 99 50 58 49 49 56 49 48 ]
	         }
	         {CONST 
	         :consttype 25 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen -1 
	         :constbyval false 
	         :constisnull false 
	         :location -1 
	         :constvalue 12 [ 48 0 0 0 99 51 58 49 49 56 49 48 ]
	         }
	         {CONST 
	         :consttype 25 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen -1 
	         :constbyval false 
	         :constisnull false 
	         :location -1 
	         :constvalue 4 [ 16 0 0 0 ]
	         }
	         {CONST 
	         :consttype 25 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen -1 
	         :constbyval false 
	         :constisnull false 
	         :location -1 
	         :constvalue 4 [ 16 0 0 0 ]
	         }
	         {CONST 
	         :consttype 25 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen -1 
	         :constbyval false 
	         :constisnull true 
	         :location -1 
	         :constvalue <>
	         }
	         {CONST 
	         :consttype 23 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen 4 
	         :constbyval true 
	         :constisnull false 
	         :location -1 
	         :constvalue 4 [ 0 0 0 0 0 0 0 0 ]
	         }
	         {CONST 
	         :consttype 25 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen -1 
	         :constbyval false 
	         :constisnull true 
	         :location -1 
	         :constvalue <>
	         }
	         {CONST 
	         :consttype 25 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen -1 
	         :constbyval false 
	         :constisnull false 
	         :location -1 
	         :constvalue 5 [ 20 0 0 0 97 ]
	         }
	         {CONST 
	         :consttype 25 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen -1 
	         :constbyval false 
	         :constisnull false 
	         :location -1 
	         :constvalue 4 [ 16 0 0 0 ]
	         }
	         {CONST 
	         :consttype 23 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen 4 
	         :constbyval true 
	         :constisnull false 
	         :location -1 
	         :constvalue 4 [ -1 -1 -1 -1 0 0 0 0 ]
	         }
	         {CONST 
	         :consttype 25 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen -1 
	         :constbyval false 
	         :constisnull false 
	         :location -1 
	         :constvalue 7 [ 28 0 0 0 79 70 70 ]
	         }
	         {CONST 
	         :consttype 25 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen -1 
	         :constbyval false 
	         :constisnull false 
	         :location -1 
	         :constvalue 11 [ 44 0 0 0 116 101 115 116 95 100 98 ]
	         }
	         {CONST 
	         :consttype 25 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen -1 
	         :constbyval false 
	         :constisnull false 
	         :location -1 
	         :constvalue 12 [ 48 0 0 0 97 99 99 111 117 110 116 115 ]
	         }
	         {CONST 
	         :consttype 25 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen -1 
	         :constbyval false 
	         :constisnull false 
	         :location -1 
	         :constvalue 12 [ 48 0 0 0 97 99 99 111 117 110 116 115 ]
	         }
	         {CONST 
	         :consttype 23 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen 4 
	         :constbyval true 
	         :constisnull false 
	         :location -1 
	         :constvalue 4 [ 3 0 0 0 0 0 0 0 ]
	         }
	         {CONST 
	         :consttype 25 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen -1 
	         :constbyval false 
	         :constisnull false 
	         :location -1 
	         :constvalue 14 [ 56 0 0 0 97 99 99 111 117 110 116 95 105 100 ]
	         }
	         {CONST 
	         :consttype 23 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen 4 
	         :constbyval true 
	         :constisnull false 
	         :location -1 
	         :constvalue 4 [ 1 0 0 0 0 0 0 0 ]
	         }
	         {CONST 
	         :consttype 26 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen 4 
	         :constbyval true 
	         :constisnull false 
	         :location -1 
	         :constvalue 4 [ 25 0 0 0 0 0 0 0 ]
	         }
	         {CONST 
	         :consttype 23 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen 4 
	         :constbyval true 
	         :constisnull false 
	         :location -1 
	         :constvalue 4 [ -1 -1 -1 -1 0 0 0 0 ]
	         }
	         {CONST 
	         :consttype 25 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen -1 
	         :constbyval false 
	         :constisnull false 
	         :location -1 
	         :constvalue 11 [ 44 0 0 0 99 117 115 116 95 105 100 ]
	         }
	         {CONST 
	         :consttype 23 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen 4 
	         :constbyval true 
	         :constisnull false 
	         :location -1 
	         :constvalue 4 [ 2 0 0 0 0 0 0 0 ]
	         }
	         {CONST 
	         :consttype 26 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen 4 
	         :constbyval true 
	         :constisnull false 
	         :location -1 
	         :constvalue 4 [ 25 0 0 0 0 0 0 0 ]
	         }
	         {CONST 
	         :consttype 23 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen 4 
	         :constbyval true 
	         :constisnull false 
	         :location -1 
	         :constvalue 4 [ -1 -1 -1 -1 0 0 0 0 ]
	         }
	         {CONST 
	         :consttype 25 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen -1 
	         :constbyval false 
	         :constisnull false 
	         :location -1 
	         :constvalue 11 [ 44 0 0 0 98 97 108 97 110 99 101 ]
	         }
	         {CONST 
	         :consttype 23 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen 4 
	         :constbyval true 
	         :constisnull false 
	         :location -1 
	         :constvalue 4 [ 3 0 0 0 0 0 0 0 ]
	         }
	         {CONST 
	         :consttype 26 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen 4 
	         :constbyval true 
	         :constisnull false 
	         :location -1 
	         :constvalue 4 [ -92 6 0 0 0 0 0 0 ]
	         }
	         {CONST 
	         :consttype 23 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen 4 
	         :constbyval true 
	         :constisnull false 
	         :location -1 
	         :constvalue 4 [ 10 0 20 0 0 0 0 0 ]
	         }
	         {CONST 
	         :consttype 2275 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen 39 
	         :constbyval false 
	         :constisnull false 
	         :location -1 
	         :constvalue 39 [ 38 0 0 0 3 97 99 99 111 117 110 116 95 105 100 0 21 
	         0 0 0 2 36 101 116 0 7 0 0 0 65 49 49 49 49 49 0 0 0 0 ]
	         }
	         {CONST 
	         :consttype 2275 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen 6 
	         :constbyval false 
	         :constisnull false 
	         :location -1 
	         :constvalue 6 [ 5 0 0 0 0 127 ]
	         }
	         {CONST 
	         :consttype 23 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen 8 
	         :constbyval false 
	         :constisnull true 
	         :location -1 
	         :constvalue <>
	         }
	         {CONST 
	         :consttype 23 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen 8 
	         :constbyval false 
	         :constisnull true 
	         :location -1 
	         :constvalue <>
	         }
	         {CONST 
	         :consttype 23 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen 4 
	         :constbyval true 
	         :constisnull false 
	         :location -1 
	         :constvalue 4 [ 1 0 0 0 0 0 0 0 ]
	         }
	         {CONST 
	         :consttype 23 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen 4 
	         :constbyval true 
	         :constisnull false 
	         :location -1 
	         :constvalue 4 [ 1 0 0 0 0 0 0 0 ]
	         }
	         {CONST 
	         :consttype 23 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen 8 
	         :constbyval false 
	         :constisnull true 
	         :location -1 
	         :constvalue <>
	         }
	         {CONST 
	         :consttype 23 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen 4 
	         :constbyval true 
	         :constisnull false 
	         :location -1 
	         :constvalue 4 [ 1 0 0 0 0 0 0 0 ]
	         }
	         {CONST 
	         :consttype 26 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen 4 
	         :constbyval true 
	         :constisnull false 
	         :location -1 
	         :constvalue 4 [ 9 -64 0 0 0 0 0 0 ]
	         }
	         {CONST 
	         :consttype 23 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen 4 
	         :constbyval true 
	         :constisnull false 
	         :location -1 
	         :constvalue 4 [ 1 0 0 0 0 0 0 0 ]
	         }
	         {CONST 
	         :consttype 23 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen 4 
	         :constbyval true 
	         :constisnull false 
	         :location -1 
	         :constvalue 4 [ 2 0 0 0 0 0 0 0 ]
	         }
	         {CONST 
	         :consttype 25 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen -1 
	         :constbyval false 
	         :constisnull false 
	         :location -1 
	         :constvalue 7 [ 28 0 0 0 95 105 100 ]
	         }
	         {CONST 
	         :consttype 25 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen -1 
	         :constbyval false 
	         :constisnull false 
	         :location -1 
	         :constvalue 14 [ 56 0 0 0 97 99 99 111 117 110 116 95 105 100 ]
	         }
	      )
	      (
	         {VAR 
	         :varno 1 
	         :varattno 1 
	         :vartype 25 
	         :vartypmod -1 
	         :varcollid 100 
	         :varlevelsup 0 
	         :varnoold 1 
	         :varoattno 1 
	         :location 15
	         }
	         {VAR 
	         :varno 1 
	         :varattno 2 
	         :vartype 25 
	         :vartypmod -1 
	         :varcollid 100 
	         :varlevelsup 0 
	         :varnoold 1 
	         :varoattno 2 
	         :location 15
	         }
	         {VAR 
	         :varno 1 
	         :varattno 3 
	         :vartype 1700 
	         :vartypmod 1310730 
	         :varcollid 0 
	         :varlevelsup 0 
	         :varnoold 1 
	         :varoattno 3 
	         :location 15
	         }
	      ))
	      :fsSystemCol false
	      }
	   :rtable (
	      {RTE 
	      :alias <> 
	      :eref 
	         {ALIAS 
	         :aliasname accounts 
	         :colnames ("account_id" "cust_id" "balance")
	         }
	      :rtekind 0 
	      :relid 49161 
	      :relkind f 
	      :lateral false 
	      :inh false 
	      :inFromCl true 
	      :requiredPerms 2 
	      :checkAsUser 0 
	      :selectedCols (b 9 10 11)
	      :modifiedCols (b)
	      }
	   )
	   :resultRelations <> 
	   :utilityStmt <> 
	   :subplans <> 
	   :rewindPlanIDs (b)
	   :rowMarks <> 
	   :relationOids (o 49161)
	   :invalItems <> 
	   :nParamExec 0
	   }
	
2020-01-08 23:21:33.051 CST 25843 [local]STATEMENT:  explain select * from accounts where account_id='A11111';
2020-01-08 23:21:33.051 CST 25843 [local]DEBUG:  hostName=c1:11810,c2:11810,c3:11810,service=0
2020-01-08 23:21:33.051 CST 25843 [local]DEBUG:  CommitTransactionCommand
2020-01-08 23:21:33.051 CST 25843 [local]DEBUG:  CommitTransaction
2020-01-08 23:21:33.051 CST 25843 [local]DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children: 


  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
  • 138
  • 139
  • 140
  • 141
  • 142
  • 143
  • 144
  • 145
  • 146
  • 147
  • 148
  • 149
  • 150
  • 151
  • 152
  • 153
  • 154
  • 155
  • 156
  • 157
  • 158
  • 159
  • 160
  • 161
  • 162
  • 163
  • 164
  • 165
  • 166
  • 167
  • 168
  • 169
  • 170
  • 171
  • 172
  • 173
  • 174
  • 175
  • 176
  • 177
  • 178
  • 179
  • 180
  • 181
  • 182
  • 183
  • 184
  • 185
  • 186
  • 187
  • 188
  • 189
  • 190
  • 191
  • 192
  • 193
  • 194
  • 195
  • 196
  • 197
  • 198
  • 199
  • 200
  • 201
  • 202
  • 203
  • 204
  • 205
  • 206
  • 207
  • 208
  • 209
  • 210
  • 211
  • 212
  • 213
  • 214
  • 215
  • 216
  • 217
  • 218
  • 219
  • 220
  • 221
  • 222
  • 223
  • 224
  • 225
  • 226
  • 227
  • 228
  • 229
  • 230
  • 231
  • 232
  • 233
  • 234
  • 235
  • 236
  • 237
  • 238
  • 239
  • 240
  • 241
  • 242
  • 243
  • 244
  • 245
  • 246
  • 247
  • 248
  • 249
  • 250
  • 251
  • 252
  • 253
  • 254
  • 255
  • 256
  • 257
  • 258
  • 259
  • 260
  • 261
  • 262
  • 263
  • 264
  • 265
  • 266
  • 267
  • 268
  • 269
  • 270
  • 271
  • 272
  • 273
  • 274
  • 275
  • 276
  • 277
  • 278
  • 279
  • 280
  • 281
  • 282
  • 283
  • 284
  • 285
  • 286
  • 287
  • 288
  • 289
  • 290
  • 291
  • 292
  • 293
  • 294
  • 295
  • 296
  • 297
  • 298
  • 299
  • 300
  • 301
  • 302
  • 303
  • 304
  • 305
  • 306
  • 307
  • 308
  • 309
  • 310
  • 311
  • 312
  • 313
  • 314
  • 315
  • 316
  • 317
  • 318
  • 319
  • 320
  • 321
  • 322
  • 323
  • 324
  • 325
  • 326
  • 327
  • 328
  • 329
  • 330
  • 331
  • 332
  • 333
  • 334
  • 335
  • 336
  • 337
  • 338
  • 339
  • 340
  • 341
  • 342
  • 343
  • 344
  • 345
  • 346
  • 347
  • 348
  • 349
  • 350
  • 351
  • 352
  • 353
  • 354
  • 355
  • 356
  • 357
  • 358
  • 359
  • 360
  • 361
  • 362
  • 363
  • 364
  • 365
  • 366
  • 367
  • 368
  • 369
  • 370
  • 371
  • 372
  • 373
  • 374
  • 375
  • 376
  • 377
  • 378
  • 379
  • 380
  • 381
  • 382
  • 383
  • 384
  • 385
  • 386
  • 387
  • 388
  • 389
  • 390
  • 391
  • 392
  • 393
  • 394
  • 395
  • 396
  • 397
  • 398
  • 399
  • 400
  • 401
  • 402
  • 403
  • 404
  • 405
  • 406
  • 407
  • 408
  • 409
  • 410
  • 411
  • 412
  • 413
  • 414
  • 415
  • 416
  • 417
  • 418
  • 419
  • 420
  • 421
  • 422
  • 423
  • 424
  • 425
  • 426
  • 427
  • 428
  • 429
  • 430
  • 431
  • 432
  • 433
  • 434
  • 435
  • 436
  • 437
  • 438
  • 439
  • 440
  • 441
  • 442
  • 443
  • 444
  • 445
  • 446
  • 447
  • 448
  • 449
  • 450
  • 451
  • 452
  • 453
  • 454
  • 455
  • 456
  • 457
  • 458
  • 459
  • 460
  • 461
  • 462
  • 463
  • 464
  • 465
  • 466
  • 467
  • 468
  • 469
  • 470
  • 471
  • 472
  • 473
  • 474
  • 475
  • 476
  • 477
  • 478
  • 479
  • 480
  • 481
  • 482
  • 483
  • 484
  • 485
  • 486
  • 487
  • 488
  • 489
  • 490
  • 491
  • 492
  • 493
  • 494
  • 495
  • 496
  • 497
  • 498
  • 499
  • 500
  • 501
  • 502
  • 503
  • 504
  • 505
  • 506
  • 507
  • 508
  • 509
  • 510
  • 511
  • 512
  • 513
  • 514
  • 515
  • 516
  • 517
  • 518
  • 519
  • 520
  • 521
  • 522
  • 523
  • 524
  • 525
  • 526
  • 527
  • 528
  • 529
  • 530
  • 531
  • 532
  • 533
  • 534
  • 535
  • 536
  • 537
  • 538
  • 539
  • 540
  • 541
  • 542
  • 543
  • 544
  • 545
  • 546
  • 547
  • 548
  • 549
  • 550
  • 551
  • 552
  • 553
  • 554
  • 555
  • 556
  • 557
  • 558
  • 559
  • 560
  • 561
  • 562
  • 563
  • 564
  • 565
  • 566
  • 567
  • 568
  • 569
  • 570
  • 571
  • 572
  • 573
  • 574
  • 575
  • 576
  • 577
  • 578
  • 579
  • 580
  • 581
  • 582
  • 583
  • 584
  • 585
  • 586
  • 587
  • 588
  • 589
  • 590
  • 591
  • 592
  • 593
  • 594
  • 595
  • 596
  • 597
  • 598
  • 599
  • 600
  • 601
  • 602
  • 603
  • 604
  • 605
  • 606
  • 607
  • 608
  • 609
  • 610
  • 611
  • 612
  • 613
  • 614
  • 615
  • 616
  • 617
  • 618
  • 619
  • 620
  • 621
  • 622
  • 623
  • 624
  • 625
  • 626
  • 627
  • 628
  • 629
  • 630
  • 631
  • 632
  • 633
  • 634
  • 635
  • 636
  • 637
  • 638
  • 639
  • 640
  • 641
  • 642
  • 643
  • 644
  • 645
  • 646
  • 647
  • 648
  • 649
  • 650
  • 651
  • 652
  • 653
  • 654
  • 655
  • 656
  • 657
  • 658
  • 659
  • 660
  • 661
  • 662
  • 663
  • 664
  • 665
  • 666
  • 667
  • 668
  • 669
  • 670
  • 671
  • 672
  • 673
  • 674
  • 675
  • 676
  • 677
  • 678
  • 679
  • 680
  • 681
  • 682
  • 683
  • 684
  • 685
  • 686
  • 687
  • 688
  • 689
  • 690
  • 691
  • 692
  • 693
  • 694
  • 695
  • 696
  • 697
  • 698
  • 699
  • 700
  • 701

下面是执行 select * from accounts where account_id=‘A11111’; 的日志记录：

2020-01-08 23:23:50.994 CST 25843 [local]DEBUG:  StartTransactionCommand
2020-01-08 23:23:50.994 CST 25843 [local]DEBUG:  StartTransaction
2020-01-08 23:23:50.994 CST 25843 [local]DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children: 
2020-01-08 23:23:50.995 CST 25843 [local]LOG:  parse tree:
2020-01-08 23:23:50.995 CST 25843 [local]DETAIL:     {QUERY 
	   :commandType 1 
	   :querySource 0 
	   :canSetTag true 
	   :utilityStmt <> 
	   :resultRelation 0 
	   :hasAggs false 
	   :hasWindowFuncs false 
	   :hasSubLinks false 
	   :hasDistinctOn false 
	   :hasRecursive false 
	   :hasModifyingCTE false 
	   :hasForUpdate false 
	   :cteList <> 
	   :rtable (
	      {RTE 
	      :alias <> 
	      :eref 
	         {ALIAS 
	         :aliasname accounts 
	         :colnames ("account_id" "cust_id" "balance")
	         }
	      :rtekind 0 
	      :relid 49161 
	      :relkind f 
	      :lateral false 
	      :inh true 
	      :inFromCl true 
	      :requiredPerms 2 
	      :checkAsUser 0 
	      :selectedCols (b 9 10 11)
	      :modifiedCols (b)
	      }
	   )
	   :jointree 
	      {FROMEXPR 
	      :fromlist (
	         {RANGETBLREF 
	         :rtindex 1
	         }
	      )
	      :quals 
	         {OPEXPR 
	         :opno 98 
	         :opfuncid 67 
	         :opresulttype 16 
	         :opretset false 
	         :opcollid 0 
	         :inputcollid 100 
	         :args (
	            {VAR 
	            :varno 1 
	            :varattno 1 
	            :vartype 25 
	            :vartypmod -1 
	            :varcollid 100 
	            :varlevelsup 0 
	            :varnoold 1 
	            :varoattno 1 
	            :location 29
	            }
	            {CONST 
	            :consttype 25 
	            :consttypmod -1 
	            :constcollid 100 
	            :constlen -1 
	            :constbyval false 
	            :constisnull false 
	            :location 40 
	            :constvalue 10 [ 40 0 0 0 65 49 49 49 49 49 ]
	            }
	         )
	         :location 39
	         }
	      }
	   :targetList (
	      {TARGETENTRY 
	      :expr 
	         {VAR 
	         :varno 1 
	         :varattno 1 
	         :vartype 25 
	         :vartypmod -1 
	         :varcollid 100 
	         :varlevelsup 0 
	         :varnoold 1 
	         :varoattno 1 
	         :location 7
	         }
	      :resno 1 
	      :resname account_id 
	      :ressortgroupref 0 
	      :resorigtbl 49161 
	      :resorigcol 1 
	      :resjunk false
	      }
	      {TARGETENTRY 
	      :expr 
	         {VAR 
	         :varno 1 
	         :varattno 2 
	         :vartype 25 
	         :vartypmod -1 
	         :varcollid 100 
	         :varlevelsup 0 
	         :varnoold 1 
	         :varoattno 2 
	         :location 7
	         }
	      :resno 2 
	      :resname cust_id 
	      :ressortgroupref 0 
	      :resorigtbl 49161 
	      :resorigcol 2 
	      :resjunk false
	      }
	      {TARGETENTRY 
	      :expr 
	         {VAR 
	         :varno 1 
	         :varattno 3 
	         :vartype 1700 
	         :vartypmod 1310730 
	         :varcollid 0 
	         :varlevelsup 0 
	         :varnoold 1 
	         :varoattno 3 
	         :location 7
	         }
	      :resno 3 
	      :resname balance 
	      :ressortgroupref 0 
	      :resorigtbl 49161 
	      :resorigcol 3 
	      :resjunk false
	      }
	   )
	   :returningList <> 
	   :groupClause <> 
	   :havingQual <> 
	   :windowClause <> 
	   :distinctClause <> 
	   :sortClause <> 
	   :limitOffset <> 
	   :limitCount <> 
	   :rowMarks <> 
	   :setOperations <> 
	   :constraintDeps <>
	   }
	
2020-01-08 23:23:50.995 CST 25843 [local]STATEMENT:  select * from accounts where account_id='A11111';
2020-01-08 23:23:50.995 CST 25843 [local]LOG:  rewritten parse tree:
2020-01-08 23:23:50.995 CST 25843 [local]DETAIL:  (
	   {QUERY 
	   :commandType 1 
	   :querySource 0 
	   :canSetTag true 
	   :utilityStmt <> 
	   :resultRelation 0 
	   :hasAggs false 
	   :hasWindowFuncs false 
	   :hasSubLinks false 
	   :hasDistinctOn false 
	   :hasRecursive false 
	   :hasModifyingCTE false 
	   :hasForUpdate false 
	   :cteList <> 
	   :rtable (
	      {RTE 
	      :alias <> 
	      :eref 
	         {ALIAS 
	         :aliasname accounts 
	         :colnames ("account_id" "cust_id" "balance")
	         }
	      :rtekind 0 
	      :relid 49161 
	      :relkind f 
	      :lateral false 
	      :inh true 
	      :inFromCl true 
	      :requiredPerms 2 
	      :checkAsUser 0 
	      :selectedCols (b 9 10 11)
	      :modifiedCols (b)
	      }
	   )
	   :jointree 
	      {FROMEXPR 
	      :fromlist (
	         {RANGETBLREF 
	         :rtindex 1
	         }
	      )
	      :quals 
	         {OPEXPR 
	         :opno 98 
	         :opfuncid 67 
	         :opresulttype 16 
	         :opretset false 
	         :opcollid 0 
	         :inputcollid 100 
	         :args (
	            {VAR 
	            :varno 1 
	            :varattno 1 
	            :vartype 25 
	            :vartypmod -1 
	            :varcollid 100 
	            :varlevelsup 0 
	            :varnoold 1 
	            :varoattno 1 
	            :location 29
	            }
	            {CONST 
	            :consttype 25 
	            :consttypmod -1 
	            :constcollid 100 
	            :constlen -1 
	            :constbyval false 
	            :constisnull false 
	            :location 40 
	            :constvalue 10 [ 40 0 0 0 65 49 49 49 49 49 ]
	            }
	         )
	         :location 39
	         }
	      }
	   :targetList (
	      {TARGETENTRY 
	      :expr 
	         {VAR 
	         :varno 1 
	         :varattno 1 
	         :vartype 25 
	         :vartypmod -1 
	         :varcollid 100 
	         :varlevelsup 0 
	         :varnoold 1 
	         :varoattno 1 
	         :location 7
	         }
	      :resno 1 
	      :resname account_id 
	      :ressortgroupref 0 
	      :resorigtbl 49161 
	      :resorigcol 1 
	      :resjunk false
	      }
	      {TARGETENTRY 
	      :expr 
	         {VAR 
	         :varno 1 
	         :varattno 2 
	         :vartype 25 
	         :vartypmod -1 
	         :varcollid 100 
	         :varlevelsup 0 
	         :varnoold 1 
	         :varoattno 2 
	         :location 7
	         }
	      :resno 2 
	      :resname cust_id 
	      :ressortgroupref 0 
	      :resorigtbl 49161 
	      :resorigcol 2 
	      :resjunk false
	      }
	      {TARGETENTRY 
	      :expr 
	         {VAR 
	         :varno 1 
	         :varattno 3 
	         :vartype 1700 
	         :vartypmod 1310730 
	         :varcollid 0 
	         :varlevelsup 0 
	         :varnoold 1 
	         :varoattno 3 
	         :location 7
	         }
	      :resno 3 
	      :resname balance 
	      :ressortgroupref 0 
	      :resorigtbl 49161 
	      :resorigcol 3 
	      :resjunk false
	      }
	   )
	   :returningList <> 
	   :groupClause <> 
	   :havingQual <> 
	   :windowClause <> 
	   :distinctClause <> 
	   :sortClause <> 
	   :limitOffset <> 
	   :limitCount <> 
	   :rowMarks <> 
	   :setOperations <> 
	   :constraintDeps <>
	   }
	)
	
2020-01-08 23:23:50.995 CST 25843 [local]STATEMENT:  select * from accounts where account_id='A11111';
2020-01-08 23:23:50.995 CST 25843 [local]DEBUG:  hostName=c1:11810,c2:11810,c3:11810,service=0
2020-01-08 23:23:50.995 CST 25843 [local]DEBUG:  foreign table:49161, handle found:1
2020-01-08 23:23:50.995 CST 25843 [local]DEBUG:  var info:foreign_table_id=49161, varattno=1, valevelsup=0
2020-01-08 23:23:50.995 CST 25843 [local]DEBUG:  isSortCanPushDown:empty pathkeys
2020-01-08 23:23:50.995 CST 25843 [local]DEBUG:  foreign table:49161, handle found:1
2020-01-08 23:23:50.995 CST 25843 [local]DEBUG:  get index from cache
2020-01-08 23:23:50.995 CST 25843 [local]DEBUG:  i=0,keynum=1,key[0]=account_id
2020-01-08 23:23:50.995 CST 25843 [local]DEBUG:  SdbGetForeignPaths:foreignPath={FOREIGNPATH :pathtype 120 :parent_relids (b 1) :required_outer (b) :rows 1 :startup_cost 0.00 :total_cost 0.06 :pathkeys <> :fdw_private <>}
2020-01-08 23:23:50.995 CST 25843 [local]DEBUG:  foreign table:49161, handle found:1
2020-01-08 23:23:50.995 CST 25843 [local]DEBUG:  SdbGetForeignPlan:bestPath={FOREIGNPATH :pathtype 120 :parent_relids (b 1) :required_outer (b) :rows 1 :startup_cost 0.00 :total_cost 0.06 :pathkeys <> :fdw_private <>}
2020-01-08 23:23:50.995 CST 25843 [local]DEBUG:  var info:foreign_table_id=49161, varattno=1, valevelsup=0
2020-01-08 23:23:50.995 CST 25843 [local]DEBUG:  bson value={ "account_id": { "$et": "A11111" } },label[SdbGetForeignPlan query]
2020-01-08 23:23:50.995 CST 25843 [local]DEBUG:  reset parse's limit and offset
2020-01-08 23:23:50.995 CST 25843 [local]DEBUG:  SdbAllocRecord:usedCount=1,index=0
2020-01-08 23:23:50.996 CST 25843 [local]LOG:  plan:
2020-01-08 23:23:50.997 CST 25843 [local]DETAIL:     {PLANNEDSTMT 
	   :commandType 1 
	   :queryId 0 
	   :hasReturning false 
	   :hasModifyingCTE false 
	   :canSetTag true 
	   :transientPlan false 
	   :planTree 
	      {FOREIGNSCAN 
	      :startup_cost 0.00 
	      :total_cost 0.06 
	      :plan_rows 1 
	      :plan_width 18 
	      :targetlist (
	         {TARGETENTRY 
	         :expr 
	            {VAR 
	            :varno 1 
	            :varattno 1 
	            :vartype 25 
	            :vartypmod -1 
	            :varcollid 100 
	            :varlevelsup 0 
	            :varnoold 1 
	            :varoattno 1 
	            :location 7
	            }
	         :resno 1 
	         :resname account_id 
	         :ressortgroupref 0 
	         :resorigtbl 49161 
	         :resorigcol 1 
	         :resjunk false
	         }
	         {TARGETENTRY 
	         :expr 
	            {VAR 
	            :varno 1 
	            :varattno 2 
	            :vartype 25 
	            :vartypmod -1 
	            :varcollid 100 
	            :varlevelsup 0 
	            :varnoold 1 
	            :varoattno 2 
	            :location 7
	            }
	         :resno 2 
	         :resname cust_id 
	         :ressortgroupref 0 
	         :resorigtbl 49161 
	         :resorigcol 2 
	         :resjunk false
	         }
	         {TARGETENTRY 
	         :expr 
	            {VAR 
	            :varno 1 
	            :varattno 3 
	            :vartype 1700 
	            :vartypmod 1310730 
	            :varcollid 0 
	            :varlevelsup 0 
	            :varnoold 1 
	            :varoattno 3 
	            :location 7
	            }
	         :resno 3 
	         :resname balance 
	         :ressortgroupref 0 
	         :resorigtbl 49161 
	         :resorigcol 3 
	         :resjunk false
	         }
	      )
	      :qual (
	         {OPEXPR 
	         :opno 98 
	         :opfuncid 67 
	         :opresulttype 16 
	         :opretset false 
	         :opcollid 0 
	         :inputcollid 100 
	         :args (
	            {VAR 
	            :varno 1 
	            :varattno 1 
	            :vartype 25 
	            :vartypmod -1 
	            :varcollid 100 
	            :varlevelsup 0 
	            :varnoold 1 
	            :varoattno 1 
	            :location 29
	            }
	            {CONST 
	            :consttype 25 
	            :consttypmod -1 
	            :constcollid 100 
	            :constlen -1 
	            :constbyval false 
	            :constisnull false 
	            :location 40 
	            :constvalue 10 [ 40 0 0 0 65 49 49 49 49 49 ]
	            }
	         )
	         :location 39
	         }
	      )
	      :lefttree <> 
	      :righttree <> 
	      :initPlan <> 
	      :extParam (b)
	      :allParam (b)
	      :scanrelid 1 
	      :fdw_exprs <> 
	      :fdw_private ((
	         {CONST 
	         :consttype 23 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen 4 
	         :constbyval true 
	         :constisnull false 
	         :location -1 
	         :constvalue 4 [ 3 0 0 0 0 0 0 0 ]
	         }
	         {CONST 
	         :consttype 25 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen -1 
	         :constbyval false 
	         :constisnull false 
	         :location -1 
	         :constvalue 12 [ 48 0 0 0 99 49 58 49 49 56 49 48 ]
	         }
	         {CONST 
	         :consttype 25 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen -1 
	         :constbyval false 
	         :constisnull false 
	         :location -1 
	         :constvalue 12 [ 48 0 0 0 99 50 58 49 49 56 49 48 ]
	         }
	         {CONST 
	         :consttype 25 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen -1 
	         :constbyval false 
	         :constisnull false 
	         :location -1 
	         :constvalue 12 [ 48 0 0 0 99 51 58 49 49 56 49 48 ]
	         }
	         {CONST 
	         :consttype 25 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen -1 
	         :constbyval false 
	         :constisnull false 
	         :location -1 
	         :constvalue 4 [ 16 0 0 0 ]
	         }
	         {CONST 
	         :consttype 25 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen -1 
	         :constbyval false 
	         :constisnull false 
	         :location -1 
	         :constvalue 4 [ 16 0 0 0 ]
	         }
	         {CONST 
	         :consttype 25 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen -1 
	         :constbyval false 
	         :constisnull true 
	         :location -1 
	         :constvalue <>
	         }
	         {CONST 
	         :consttype 23 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen 4 
	         :constbyval true 
	         :constisnull false 
	         :location -1 
	         :constvalue 4 [ 0 0 0 0 0 0 0 0 ]
	         }
	         {CONST 
	         :consttype 25 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen -1 
	         :constbyval false 
	         :constisnull true 
	         :location -1 
	         :constvalue <>
	         }
	         {CONST 
	         :consttype 25 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen -1 
	         :constbyval false 
	         :constisnull false 
	         :location -1 
	         :constvalue 5 [ 20 0 0 0 97 ]
	         }
	         {CONST 
	         :consttype 25 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen -1 
	         :constbyval false 
	         :constisnull false 
	         :location -1 
	         :constvalue 4 [ 16 0 0 0 ]
	         }
	         {CONST 
	         :consttype 23 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen 4 
	         :constbyval true 
	         :constisnull false 
	         :location -1 
	         :constvalue 4 [ -1 -1 -1 -1 0 0 0 0 ]
	         }
	         {CONST 
	         :consttype 25 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen -1 
	         :constbyval false 
	         :constisnull false 
	         :location -1 
	         :constvalue 7 [ 28 0 0 0 79 70 70 ]
	         }
	         {CONST 
	         :consttype 25 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen -1 
	         :constbyval false 
	         :constisnull false 
	         :location -1 
	         :constvalue 11 [ 44 0 0 0 116 101 115 116 95 100 98 ]
	         }
	         {CONST 
	         :consttype 25 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen -1 
	         :constbyval false 
	         :constisnull false 
	         :location -1 
	         :constvalue 12 [ 48 0 0 0 97 99 99 111 117 110 116 115 ]
	         }
	         {CONST 
	         :consttype 25 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen -1 
	         :constbyval false 
	         :constisnull false 
	         :location -1 
	         :constvalue 12 [ 48 0 0 0 97 99 99 111 117 110 116 115 ]
	         }
	         {CONST 
	         :consttype 23 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen 4 
	         :constbyval true 
	         :constisnull false 
	         :location -1 
	         :constvalue 4 [ 3 0 0 0 0 0 0 0 ]
	         }
	         {CONST 
	         :consttype 25 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen -1 
	         :constbyval false 
	         :constisnull false 
	         :location -1 
	         :constvalue 14 [ 56 0 0 0 97 99 99 111 117 110 116 95 105 100 ]
	         }
	         {CONST 
	         :consttype 23 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen 4 
	         :constbyval true 
	         :constisnull false 
	         :location -1 
	         :constvalue 4 [ 1 0 0 0 0 0 0 0 ]
	         }
	         {CONST 
	         :consttype 26 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen 4 
	         :constbyval true 
	         :constisnull false 
	         :location -1 
	         :constvalue 4 [ 25 0 0 0 0 0 0 0 ]
	         }
	         {CONST 
	         :consttype 23 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen 4 
	         :constbyval true 
	         :constisnull false 
	         :location -1 
	         :constvalue 4 [ -1 -1 -1 -1 0 0 0 0 ]
	         }
	         {CONST 
	         :consttype 25 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen -1 
	         :constbyval false 
	         :constisnull false 
	         :location -1 
	         :constvalue 11 [ 44 0 0 0 99 117 115 116 95 105 100 ]
	         }
	         {CONST 
	         :consttype 23 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen 4 
	         :constbyval true 
	         :constisnull false 
	         :location -1 
	         :constvalue 4 [ 2 0 0 0 0 0 0 0 ]
	         }
	         {CONST 
	         :consttype 26 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen 4 
	         :constbyval true 
	         :constisnull false 
	         :location -1 
	         :constvalue 4 [ 25 0 0 0 0 0 0 0 ]
	         }
	         {CONST 
	         :consttype 23 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen 4 
	         :constbyval true 
	         :constisnull false 
	         :location -1 
	         :constvalue 4 [ -1 -1 -1 -1 0 0 0 0 ]
	         }
	         {CONST 
	         :consttype 25 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen -1 
	         :constbyval false 
	         :constisnull false 
	         :location -1 
	         :constvalue 11 [ 44 0 0 0 98 97 108 97 110 99 101 ]
	         }
	         {CONST 
	         :consttype 23 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen 4 
	         :constbyval true 
	         :constisnull false 
	         :location -1 
	         :constvalue 4 [ 3 0 0 0 0 0 0 0 ]
	         }
	         {CONST 
	         :consttype 26 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen 4 
	         :constbyval true 
	         :constisnull false 
	         :location -1 
	         :constvalue 4 [ -92 6 0 0 0 0 0 0 ]
	         }
	         {CONST 
	         :consttype 23 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen 4 
	         :constbyval true 
	         :constisnull false 
	         :location -1 
	         :constvalue 4 [ 10 0 20 0 0 0 0 0 ]
	         }
	         {CONST 
	         :consttype 2275 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen 39 
	         :constbyval false 
	         :constisnull false 
	         :location -1 
	         :constvalue 39 [ 38 0 0 0 3 97 99 99 111 117 110 116 95 105 100 0 21 
	         0 0 0 2 36 101 116 0 7 0 0 0 65 49 49 49 49 49 0 0 0 0 ]
	         }
	         {CONST 
	         :consttype 2275 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen 6 
	         :constbyval false 
	         :constisnull false 
	         :location -1 
	         :constvalue 6 [ 5 0 0 0 0 127 ]
	         }
	         {CONST 
	         :consttype 23 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen 8 
	         :constbyval false 
	         :constisnull true 
	         :location -1 
	         :constvalue <>
	         }
	         {CONST 
	         :consttype 23 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen 8 
	         :constbyval false 
	         :constisnull true 
	         :location -1 
	         :constvalue <>
	         }
	         {CONST 
	         :consttype 23 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen 4 
	         :constbyval true 
	         :constisnull false 
	         :location -1 
	         :constvalue 4 [ 1 0 0 0 0 0 0 0 ]
	         }
	         {CONST 
	         :consttype 23 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen 4 
	         :constbyval true 
	         :constisnull false 
	         :location -1 
	         :constvalue 4 [ 1 0 0 0 0 0 0 0 ]
	         }
	         {CONST 
	         :consttype 23 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen 8 
	         :constbyval false 
	         :constisnull true 
	         :location -1 
	         :constvalue <>
	         }
	         {CONST 
	         :consttype 23 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen 4 
	         :constbyval true 
	         :constisnull false 
	         :location -1 
	         :constvalue 4 [ 1 0 0 0 0 0 0 0 ]
	         }
	         {CONST 
	         :consttype 26 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen 4 
	         :constbyval true 
	         :constisnull false 
	         :location -1 
	         :constvalue 4 [ 9 -64 0 0 0 0 0 0 ]
	         }
	         {CONST 
	         :consttype 23 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen 4 
	         :constbyval true 
	         :constisnull false 
	         :location -1 
	         :constvalue 4 [ 1 0 0 0 0 0 0 0 ]
	         }
	         {CONST 
	         :consttype 23 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen 4 
	         :constbyval true 
	         :constisnull false 
	         :location -1 
	         :constvalue 4 [ 2 0 0 0 0 0 0 0 ]
	         }
	         {CONST 
	         :consttype 25 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen -1 
	         :constbyval false 
	         :constisnull false 
	         :location -1 
	         :constvalue 7 [ 28 0 0 0 95 105 100 ]
	         }
	         {CONST 
	         :consttype 25 
	         :consttypmod -1 
	         :constcollid 0 
	         :constlen -1 
	         :constbyval false 
	         :constisnull false 
	         :location -1 
	         :constvalue 14 [ 56 0 0 0 97 99 99 111 117 110 116 95 105 100 ]
	         }
	      )
	      (
	         {VAR 
	         :varno 1 
	         :varattno 1 
	         :vartype 25 
	         :vartypmod -1 
	         :varcollid 100 
	         :varlevelsup 0 
	         :varnoold 1 
	         :varoattno 1 
	         :location 7
	         }
	         {VAR 
	         :varno 1 
	         :varattno 2 
	         :vartype 25 
	         :vartypmod -1 
	         :varcollid 100 
	         :varlevelsup 0 
	         :varnoold 1 
	         :varoattno 2 
	         :location 7
	         }
	         {VAR 
	         :varno 1 
	         :varattno 3 
	         :vartype 1700 
	         :vartypmod 1310730 
	         :varcollid 0 
	         :varlevelsup 0 
	         :varnoold 1 
	         :varoattno 3 
	         :location 7
	         }
	      ))
	      :fsSystemCol false
	      }
	   :rtable (
	      {RTE 
	      :alias <> 
	      :eref 
	         {ALIAS 
	         :aliasname accounts 
	         :colnames ("account_id" "cust_id" "balance")
	         }
	      :rtekind 0 
	      :relid 49161 
	      :relkind f 
	      :lateral false 
	      :inh false 
	      :inFromCl true 
	      :requiredPerms 2 
	      :checkAsUser 0 
	      :selectedCols (b 9 10 11)
	      :modifiedCols (b)
	      }
	   )
	   :resultRelations <> 
	   :utilityStmt <> 
	   :subplans <> 
	   :rewindPlanIDs (b)
	   :rowMarks <> 
	   :relationOids (o 49161)
	   :invalItems <> 
	   :nParamExec 0
	   }
	
2020-01-08 23:23:50.997 CST 25843 [local]STATEMENT:  select * from accounts where account_id='A11111';
2020-01-08 23:23:50.997 CST 25843 [local]DEBUG:  foreign table:49161, handle found:1
2020-01-08 23:23:51.012 CST 25843 [local]DEBUG:  CommitTransactionCommand
2020-01-08 23:23:51.013 CST 25843 [local]DEBUG:  CommitTransaction
2020-01-08 23:23:51.013 CST 25843 [local]DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children: 
2020-01-08 23:23:52.244 CST 25149 DEBUG:  StartTransaction
2020-01-08 23:23:52.244 CST 25149 DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children: 
2020-01-08 23:23:52.244 CST 25149 DEBUG:  CommitTransaction
2020-01-08 23:23:52.244 CST 25149 DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children: 
2020-01-08 23:23:52.244 CST 25150 DEBUG:  received inquiry for 0
2020-01-08 23:23:52.244 CST 25150 DEBUG:  writing statsfile 'pg_stat_tmp/global.stat'
2020-01-08 23:23:52.244 CST 25150 DEBUG:  writing statsfile 'pg_stat_tmp/db_0.stat'
2020-01-08 23:23:52.255 CST 29807 DEBUG:  InitPostgres
2020-01-08 23:23:52.255 CST 29807 DEBUG:  my backend ID is 3
2020-01-08 23:23:52.255 CST 29807 DEBUG:  StartTransaction
2020-01-08 23:23:52.255 CST 29807 DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children: 
2020-01-08 23:23:52.256 CST 29807 DEBUG:  CommitTransaction
2020-01-08 23:23:52.256 CST 29807 DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children: 
2020-01-08 23:23:52.256 CST 29807 DEBUG:  autovacuum: processing database "postgres"
2020-01-08 23:23:52.256 CST 25150 DEBUG:  received inquiry for 12949
2020-01-08 23:23:52.256 CST 25150 DEBUG:  writing statsfile 'pg_stat_tmp/global.stat'
2020-01-08 23:23:52.256 CST 25150 DEBUG:  writing statsfile 'pg_stat_tmp/db_12949.stat'
2020-01-08 23:23:52.268 CST 29807 DEBUG:  StartTransaction
2020-01-08 23:23:52.268 CST 29807 DEBUG:  name: unnamed; blockState:       DEFAULT; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children: 
2020-01-08 23:23:52.268 CST 29807 DEBUG:  pg_statistic: vac: 0 (threshold 128), anl: 0 (threshold 89)
2020-01-08 23:23:52.268 CST 29807 DEBUG:  pg_type: vac: 0 (threshold 117), anl: 0 (threshold 83)
2020-01-08 23:23:52.268 CST 29807 DEBUG:  pg_authid: vac: 0 (threshold 50), anl: 0 (threshold 50)
2020-01-08 23:23:52.268 CST 29807 DEBUG:  pg_attribute: vac: 0 (threshold 505), anl: 0 (threshold 277)
2020-01-08 23:23:52.268 CST 29807 DEBUG:  pg_proc: vac: 0 (threshold 556), anl: 0 (threshold 303)
2020-01-08 23:23:52.268 CST 29807 DEBUG:  pg_class: vac: 0 (threshold 108), anl: 0 (threshold 79)
2020-01-08 23:23:52.268 CST 29807 DEBUG:  pg_index: vac: 0 (threshold 72), anl: 0 (threshold 61)
2020-01-08 23:23:52.268 CST 29807 DEBUG:  pg_opclass: vac: 0 (threshold 74), anl: 0 (threshold 62)
2020-01-08 23:23:52.268 CST 29807 DEBUG:  pg_am: vac: 0 (threshold 51), anl: 0 (threshold 50)
2020-01-08 23:23:52.268 CST 29807 DEBUG:  pg_amop: vac: 0 (threshold 131), anl: 0 (threshold 90)
2020-01-08 23:23:52.268 CST 29807 DEBUG:  pg_amproc: vac: 0 (threshold 108), anl: 0 (threshold 79)
2020-01-08 23:23:52.268 CST 29807 DEBUG:  pg_database: vac: 0 (threshold 50), anl: 0 (threshold 50)
2020-01-08 23:23:52.268 CST 29807 DEBUG:  pg_cast: vac: 0 (threshold 89), anl: 0 (threshold 70)
2020-01-08 23:23:52.268 CST 29807 DEBUG:  pg_namespace: vac: 0 (threshold 51), anl: 0 (threshold 51)
2020-01-08 23:23:52.268 CST 29807 DEBUG:  pg_tablespace: vac: 0 (threshold 50), anl: 0 (threshold 50)
2020-01-08 23:23:52.268 CST 29807 DEBUG:  CommitTransaction
2020-01-08 23:23:52.268 CST 29807 DEBUG:  name: unnamed; blockState:       STARTED; state: INPROGR, xid/subid/cid: 0/1/0, nestlvl: 1, children: 
2020-01-08 23:23:52.268 CST 29807 DEBUG:  shmem_exit(0): 8 callbacks to make
2020-01-08 23:23:52.268 CST 29807 DEBUG:  proc_exit(0): 2 callbacks to make
2020-01-08 23:23:52.268 CST 29807 DEBUG:  exit(0)
2020-01-08 23:23:52.268 CST 29807 DEBUG:  shmem_exit(-1): 0 callbacks to make
2020-01-08 23:23:52.268 CST 29807 DEBUG:  proc_exit(-1): 0 callbacks to make
2020-01-08 23:23:52.269 CST 25124 DEBUG:  reaping dead processes
2020-01-08 23:23:52.269 CST 25124 DEBUG:  server process (PID 29807) exited with exit code 0


  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
  • 138
  • 139
  • 140
  • 141
  • 142
  • 143
  • 144
  • 145
  • 146
  • 147
  • 148
  • 149
  • 150
  • 151
  • 152
  • 153
  • 154
  • 155
  • 156
  • 157
  • 158
  • 159
  • 160
  • 161
  • 162
  • 163
  • 164
  • 165
  • 166
  • 167
  • 168
  • 169
  • 170
  • 171
  • 172
  • 173
  • 174
  • 175
  • 176
  • 177
  • 178
  • 179
  • 180
  • 181
  • 182
  • 183
  • 184
  • 185
  • 186
  • 187
  • 188
  • 189
  • 190
  • 191
  • 192
  • 193
  • 194
  • 195
  • 196
  • 197
  • 198
  • 199
  • 200
  • 201
  • 202
  • 203
  • 204
  • 205
  • 206
  • 207
  • 208
  • 209
  • 210
  • 211
  • 212
  • 213
  • 214
  • 215
  • 216
  • 217
  • 218
  • 219
  • 220
  • 221
  • 222
  • 223
  • 224
  • 225
  • 226
  • 227
  • 228
  • 229
  • 230
  • 231
  • 232
  • 233
  • 234
  • 235
  • 236
  • 237
  • 238
  • 239
  • 240
  • 241
  • 242
  • 243
  • 244
  • 245
  • 246
  • 247
  • 248
  • 249
  • 250
  • 251
  • 252
  • 253
  • 254
  • 255
  • 256
  • 257
  • 258
  • 259
  • 260
  • 261
  • 262
  • 263
  • 264
  • 265
  • 266
  • 267
  • 268
  • 269
  • 270
  • 271
  • 272
  • 273
  • 274
  • 275
  • 276
  • 277
  • 278
  • 279
  • 280
  • 281
  • 282
  • 283
  • 284
  • 285
  • 286
  • 287
  • 288
  • 289
  • 290
  • 291
  • 292
  • 293
  • 294
  • 295
  • 296
  • 297
  • 298
  • 299
  • 300
  • 301
  • 302
  • 303
  • 304
  • 305
  • 306
  • 307
  • 308
  • 309
  • 310
  • 311
  • 312
  • 313
  • 314
  • 315
  • 316
  • 317
  • 318
  • 319
  • 320
  • 321
  • 322
  • 323
  • 324
  • 325
  • 326
  • 327
  • 328
  • 329
  • 330
  • 331
  • 332
  • 333
  • 334
  • 335
  • 336
  • 337
  • 338
  • 339
  • 340
  • 341
  • 342
  • 343
  • 344
  • 345
  • 346
  • 347
  • 348
  • 349
  • 350
  • 351
  • 352
  • 353
  • 354
  • 355
  • 356
  • 357
  • 358
  • 359
  • 360
  • 361
  • 362
  • 363
  • 364
  • 365
  • 366
  • 367
  • 368
  • 369
  • 370
  • 371
  • 372
  • 373
  • 374
  • 375
  • 376
  • 377
  • 378
  • 379
  • 380
  • 381
  • 382
  • 383
  • 384
  • 385
  • 386
  • 387
  • 388
  • 389
  • 390
  • 391
  • 392
  • 393
  • 394
  • 395
  • 396
  • 397
  • 398
  • 399
  • 400
  • 401
  • 402
  • 403
  • 404
  • 405
  • 406
  • 407
  • 408
  • 409
  • 410
  • 411
  • 412
  • 413
  • 414
  • 415
  • 416
  • 417
  • 418
  • 419
  • 420
  • 421
  • 422
  • 423
  • 424
  • 425
  • 426
  • 427
  • 428
  • 429
  • 430
  • 431
  • 432
  • 433
  • 434
  • 435
  • 436
  • 437
  • 438
  • 439
  • 440
  • 441
  • 442
  • 443
  • 444
  • 445
  • 446
  • 447
  • 448
  • 449
  • 450
  • 451
  • 452
  • 453
  • 454
  • 455
  • 456
  • 457
  • 458
  • 459
  • 460
  • 461
  • 462
  • 463
  • 464
  • 465
  • 466
  • 467
  • 468
  • 469
  • 470
  • 471
  • 472
  • 473
  • 474
  • 475
  • 476
  • 477
  • 478
  • 479
  • 480
  • 481
  • 482
  • 483
  • 484
  • 485
  • 486
  • 487
  • 488
  • 489
  • 490
  • 491
  • 492
  • 493
  • 494
  • 495
  • 496
  • 497
  • 498
  • 499
  • 500
  • 501
  • 502
  • 503
  • 504
  • 505
  • 506
  • 507
  • 508
  • 509
  • 510
  • 511
  • 512
  • 513
  • 514
  • 515
  • 516
  • 517
  • 518
  • 519
  • 520
  • 521
  • 522
  • 523
  • 524
  • 525
  • 526
  • 527
  • 528
  • 529
  • 530
  • 531
  • 532
  • 533
  • 534
  • 535
  • 536
  • 537
  • 538
  • 539
  • 540
  • 541
  • 542
  • 543
  • 544
  • 545
  • 546
  • 547
  • 548
  • 549
  • 550
  • 551
  • 552
  • 553
  • 554
  • 555
  • 556
  • 557
  • 558
  • 559
  • 560
  • 561
  • 562
  • 563
  • 564
  • 565
  • 566
  • 567
  • 568
  • 569
  • 570
  • 571
  • 572
  • 573
  • 574
  • 575
  • 576
  • 577
  • 578
  • 579
  • 580
  • 581
  • 582
  • 583
  • 584
  • 585
  • 586
  • 587
  • 588
  • 589
  • 590
  • 591
  • 592
  • 593
  • 594
  • 595
  • 596
  • 597
  • 598
  • 599
  • 600
  • 601
  • 602
  • 603
  • 604
  • 605
  • 606
  • 607
  • 608
  • 609
  • 610
  • 611
  • 612
  • 613
  • 614
  • 615
  • 616
  • 617
  • 618
  • 619
  • 620
  • 621
  • 622
  • 623
  • 624
  • 625
  • 626
  • 627
  • 628
  • 629
  • 630
  • 631
  • 632
  • 633
  • 634
  • 635
  • 636
  • 637
  • 638
  • 639
  • 640
  • 641
  • 642
  • 643
  • 644
  • 645
  • 646
  • 647
  • 648
  • 649
  • 650
  • 651
  • 652
  • 653
  • 654
  • 655
  • 656
  • 657
  • 658
  • 659
  • 660
  • 661
  • 662
  • 663
  • 664
  • 665
  • 666
  • 667
  • 668
  • 669
  • 670
  • 671
  • 672
  • 673
  • 674
  • 675
  • 676
  • 677
  • 678
  • 679
  • 680
  • 681
  • 682
  • 683
  • 684
  • 685
  • 686
  • 687
  • 688
  • 689
  • 690
  • 691
  • 692
  • 693
  • 694
  • 695
  • 696
  • 697
  • 698
  • 699
  • 700
  • 701
  • 702
  • 703
  • 704
  • 705
  • 706
  • 707
  • 708
  • 709
  • 710
  • 711
  • 712
  • 713
  • 714
  • 715
  • 716
  • 717
  • 718
  • 719
  • 720
  • 721
  • 722
  • 723
  • 724
  • 725
  • 726
  • 727
  • 728
  • 729
  • 730
  • 731
  • 732
  • 733
  • 734
  • 735
  • 736
  • 737
  • 738
  • 739
  • 740
  • 741
  • 742
  • 743
  • 744
  • 745
  • 746
  • 747
  • 748
  • 749
  • 750
  • 751
  • 752
  • 753
  • 754
  • 755
  • 756
  • 757
  • 758
  • 759
  • 760
  • 761
  • 762
  • 763
  • 764
  • 765
  • 766
  • 767
  • 768
  • 769
  • 770
  • 771
  • 772
  • 773
  • 774
  • 775
  • 776
  • 777
  • 778
  • 779
  • 780
  • 781
  • 782
  • 783
  • 784
  • 785
  • 786
  • 787
  • 788
  • 789
  • 790
  • 791
  • 792
  • 793
  • 794
  • 795
  • 796
  • 797
  • 798
  • 799
  • 800
  • 801
  • 802
  • 803
  • 804
  • 805
  • 806
  • 807
  • 808
  • 809
  • 810
  • 811
  • 812
  • 813
  • 814
  • 815
  • 816
  • 817
  • 818
  • 819
  • 820
  • 821
  • 822
  • 823
  • 824
  • 825
  • 826
  • 827
  • 828
  • 829
  • 830
  • 831
  • 832
  • 833
  • 834
  • 835
  • 836
  • 837
  • 838
  • 839
  • 840
  • 841
  • 842
  • 843
  • 844
  • 845
  • 846
  • 847
  • 848
  • 849
  • 850
  • 851
  • 852
  • 853
  • 854
  • 855
  • 856
  • 857
  • 858
  • 859
  • 860
  • 861
  • 862
  • 863
  • 864
  • 865
  • 866
  • 867
  • 868
  • 869
  • 870
  • 871
  • 872
  • 873
  • 874
  • 875
  • 876
  • 877
  • 878
  • 879
  • 880
  • 881
  • 882
  • 883
  • 884
  • 885
  • 886
  • 887
  • 888
  • 889
  • 890
  • 891
  • 892
  • 893
  • 894
  • 895
  • 896
  • 897
  • 898
  • 899
  • 900
  • 901
  • 902
  • 903
  • 904
  • 905
  • 906
  • 907
  • 908
  • 909
  • 910
  • 911
  • 912
  • 913
  • 914
  • 915
  • 916
  • 917
  • 918
  • 919
  • 920
  • 921
  • 922
  • 923
  • 924
  • 925
  • 926
  • 927
  • 928
  • 929
  • 930
  • 931
  • 932
  • 933
  • 934
  • 935
  • 936
  • 937
  • 938
  • 939
  • 940
  • 941
  • 942
  • 943
  • 944
  • 945
  • 946
  • 947
  • 948
  • 949
  • 950
  • 951
  • 952
  • 953
  • 954
  • 955
  • 956
  • 957
  • 958
  • 959
  • 960
  • 961
  • 962
  • 963
  • 964
  • 965
  • 966
  • 967
  • 968
  • 969
  • 970
  • 971
  • 972
  • 973
  • 974
  • 975
  • 976
  • 977
  • 978
  • 979
声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/小小林熬夜学编程/article/detail/135300
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号