# 项目

开源项目：[PostgreSQL DBA最常用SQL](https://github.com/lovebetterworld/postgres/blob/master/3.PostgreSQL%20%E7%AC%94%E8%AE%B0/PostgreSQL%20%E7%B3%BB%E5%88%97/PostgreSQL%20DBA%E6%9C%80%E5%B8%B8%E7%94%A8SQL.md)

注意：适用于PostgreSQL。有些功能在Greenplum Database中不可用。

# TPS

TPS（Transaction Per Second，每秒事务数）：

```sql
create or replace procedure tps() as $$
declare
  v1 int8;
  v2 int8;
begin
  select txid_snapshot_xmax(txid_current_snapshot()) into v1;
  commit;
  perform pg_sleep(1);
  select txid_snapshot_xmax(txid_current_snapshot()) into v2;
  commit;
  raise notice 'tps: %', v2-v1;
end;
$$ language plpgsql ;
```

# QPS

QPS（Query Per Second，每秒请求数）：

```sql
create view qps as with
a as (select sum(calls) s from pg_stat_statements),
b as (select sum(calls) s from pg_stat_statements , pg_sleep(1))
select 
b.s-a.s
from a,b;
```

# 附件

![项目文件](../../../../../ff_internal_upload/archive/2022/PostgreSQL DBA最常用SQL.zip)