maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ot_ro_tps(integer)
Parameters
Name
Type
Mode
interval_seconds
integer
IN
Definition
DECLARE before int; after int; BEGIN SELECT xact_commit+xact_rollback INTO before FROM pg_stat_database WHERE datname = 'maya'; PERFORM pg_sleep(interval_seconds); PERFORM pg_stat_clear_snapshot(); SELECT xact_commit+xact_rollback INTO after FROM pg_stat_database WHERE datname = 'maya'; RETURN (after - before)/interval_seconds; END;