Pg_stat_raybet雷竞技竞猜在线官网monitor和pg_stat_statements视图比较¶
的pg_stat_raybet雷竞技竞猜在线官网monitor扩展是在此基础上开发的pg_stat_statements作为其更先进的替代品。
因此,pg_stat_raybet雷竞技竞猜在线官网monitor中可用的列pg_stat_statementsPlus提供额外的。
请注意,pg_stat_raybet雷竞技竞猜在线官网monitor而且pg_stat_statements不同处理统计数据．由于这些差异，当两个扩展一起使用时，内存块和WAL(预写日志)相关的统计数据显示不一致。
命令中运行以下命令，查看所有可用列psql终端:
postgres= #＼dpg_stat_raybet雷竞技竞猜在线官网monitor；下表比较了pg_stat_raybet雷竞技竞猜在线官网monitor的观点pg_stat_statements．
请注意，列名取决于您正在运行的PostgreSQL版本。
| PostgreSQL 15及以上 | PostgreSQL 13 - 14 | PostgreSQL 11 - 12 | pg_stat_raybet雷竞技竞猜在线官网monitor | pg_stat_statements |
|---|---|---|---|---|
| 桶 | 桶 | 桶 |  |
 |
| bucket_start_time | bucket_start_time | bucket_start_time | |
|
| bucket_done | bucket_done | bucket_done | |
|
| 用户标识 | 用户标识 | 用户标识 | |
|
| 用户 | |
|
||
| dbid | |
|
||
| datname | datname | datname | |
|
| 最高级的 | 最高级的1 | |
|
|
| client_ip | client_ip | client_ip | |
|
| pgsm_query_id | pgsm_query_id | pgsm_query_id | |
|
| queryid | queryid | queryid | |
|
| planid | planid | planid | |
|
| query_plan | query_plan | query_plan | |
|
| top_query | top_query | top_query | |
|
| top_queryid | top_queryid | top_queryid | |
|
| 查询 | 查询 | 查询 | |
|
| application_name | application_name | application_name | |
|
| 关系 | 关系 | 关系 | |
|
| cmd_type | cmd_type | cmd_type | |
|
| cmd_type_text | cmd_type_text | cmd_type_text | |
|
| elevel | elevel | elevel | |
|
| sqlcode | sqlcode | sqlcode | |
|
| 消息 | 消息 | 消息 | |
|
| 计划 | plans_calls | plans_calls | |
|
| total_plan_time | total_plan_time | |
|
|
| min_plan_time | min_plan_time | |
|
|
| max_plan_time | max_plan_time | |
|
|
| mean_plan_time | mean_plan_time | |
|
|
| stddev_plan_time | stddev_plan_time | |
|
|
| 调用 | 调用 | 调用 | |
|
| total_exec_time | total_exec_time | total_time | |
|
| min_exec_time | min_exec_time | min_time | |
|
| max_exec_time | max_exec_time | max_time | |
|
| mean_exec_time | mean_exec_time | mean_time | |
|
| stddev_exec_time | stddev_exec_time | stddev_time | |
|
| 行 | rows_retrieved | rows_retrieved | |
|
| shared_blks_hit | shared_blks_hit | shared_blks_hit | |
|
| shared_blks_read | shared_blks_read | shared_blks_read | |
|
| shared_blks_dirtied | shared_blks_dirtied | shared_blks_dirtied | |
|
| shared_blks_written | shared_blks_written | shared_blks_written | |
|
| local_blks_hit | local_blks_hit | local_blks_hit | |
|
| local_blks_read | local_blks_read | local_blks_read | |
|
| local_blks_dirtied | local_blks_dirtied | local_blks_dirtied | |
|
| local_blks_written | local_blks_written | local_blks_written | |
|
| temp_blks_read | temp_blks_read | temp_blks_read | |
|
| temp_blks_written | temp_blks_written | temp_blks_written | |
|
| blk_read_time | blk_read_time | blk_read_time | |
|
| blk_write_time | blk_write_time | blk_write_time | |
|
| temp_blk_read_time | |
|
||
| temp_blk_write_time | |
|
||
| resp_calls | resp_calls | resp_calls | |
|
| cpu_user_time | cpu_user_time | cpu_user_time | |
|
| cpu_sys_time | cpu_sys_time | cpu_sys_time | |
|
| wal_records | wal_records | wal_records | |
|
| wal_fpi | wal_fpi | wal_fpi | |
|
| wal_bytes | wal_bytes | wal_bytes | |
|
| 评论 | 评论 | 评论 | |
|
| jit_functions | |
|
||
| jit_generation_time | |
|
||
| jit_inlining_count | |
|
||
| jit_inlining_time | |
|
||
| jit_optimization_count | |
|
||
| jit_optimization_time | |
|
||
| jit_emission_count | |
|
||
| jit_emission_time | |
|
以了解更多有关的功能pg_stat_raybet雷竞技竞猜在线官网monitor，详情请参阅用户指南．
更多阅读:pg_stat_statements
从PostgreSQL 14及以上版本开始可用↩
最后更新:2023年3月29日
创建:2023年3月29日
创建:2023年3月29日
