diff options
Diffstat (limited to 'pgsnmpd.yaml')
| -rw-r--r-- | pgsnmpd.yaml | 148 |
1 files changed, 148 insertions, 0 deletions
diff --git a/pgsnmpd.yaml b/pgsnmpd.yaml new file mode 100644 index 0000000..c891dbc --- /dev/null +++ b/pgsnmpd.yaml @@ -0,0 +1,148 @@ +queries: + - + name: pgsqlPgAggregateTable + query: SELECT aggfnoid::integer, aggtransfn, aggfinalfn, aggsortop, aggtranstype, agginitval FROM pg_aggregate + oid: 1.3.6.1.4.1.27645.1.2.1 + indexes: 1 + min_column: 1 + - + name: pgsqlPgAmTable + query: SELECT oid, * from pg_am + oid: 1.3.6.1.4.1.27645.1.2.2 + indexes: 1 + min_column: 1 + +## - +## name: rdbmsDbTable +## query: SELECT oid, '1.3.6.1.4.1', 'PostgreSQL', datname, 'josh@pgsnmpd' FROM pg_database +## oid: 1.3.6.1.2.1.39.1.1 +## indexes: 1 +## min_column: 1 +## - +## name: rdbmsDbInfoTable +## query: SELECT oid, version(), pg_database_size(datname) FROM pg_database +## oid: 1.3.6.1.2.1.39.1.2 +## indexes: 1 +## min_column: 1 +## - +## name: rdbmsDbParamTable +## query: SELECT oid, datname, datconfig FROM pg_database +## oid: 1.3.6.1.2.1.39.1.3 +## indexes: 1 +## min_column: 1 +## - +## name: pg_database +## query: SELECT oid, encoding, datdba, * FROM pg_database +## oid: 1.3.6.1.4.1.27645.1.3.1 +## indexes: 1 +## min_column: 1 +## types: +## - +## colnum: 1 +## type: oid +# - +## colnum: 2 +## type: string +# - +# name: random +# query: SELECT 1, '1.3.6.1.3.11', 2, floor(100 * random()) union select 2, '1.3.6.1.2.1', floor(random() * 10), 5 +# oid: 1.3.6.1.4.1.27645.1.3.2 +# indexes: 1 +# min_column: 1 +# types: +# - +# 1: ASN_INTEGER +# #2: ASN_OBJECT_ID +# 2: ASN_OCTET_STR +# 3: ASN_INTEGER +# - +# name: pg_class +# query: SELECT oid, reltuples, reltoastrelid, 'test string', * FROM pg_class +# oid: 1.3.6.1.4.1.27645.1.3.3 +# indexes: 1 +# min_column: 1 +# - +# name: test +# query: SELECT 'test', 't'::boolean, 14 +# oid: 1.3.6.1.4.1.27646.1.1 +# indexes: 1 +# min_column: 1 +# - +# name: easytest +# query: SELECT 1, 'test', 't'::boolean, random() UNION SELECT 2, 'test2', 'f'::boolean, random() +# oid: 1.3.6.1.4.1.27646.1.2 +# indexes: 1 +# min_column: 1 +## - +## name: pgsqlPgAmopTable +## query: SELECT oid, amopfamily, amoplefttype, amoprighttype , amopstrategy , amopreqcheck , amopopr, amopmethod FROM pg_amop LIMIT 4 +## oid: 1.3.6.1.4.1.27645.1.2.3 +## indexes: 1 +## min_column: 1 +## - +## name: rdbmsDbTable +## query: SELECT oid, '1.3.6.1.4.1', 'PostgreSQL', datname, 'josh@pgsnmpd' FROM pg_database +## oid: 1.3.6.1.2.1.39.1.1 +## indexes: 1 +## min_column: 1 +## - +## name: rdbmsDbInfoTable +## query: SELECT oid, version(), pg_database_size(datname) FROM pg_database +## oid: 1.3.6.1.2.1.39.1.2 +## indexes: 1 +## min_column: 1 +## - +## name: rdbmsDbParamTable +## query: SELECT oid, datname, datconfig FROM pg_database +## oid: 1.3.6.1.2.1.39.1.3 +## indexes: 1 +## min_column: 1 +## - +## name: pg_database +## query: SELECT oid, encoding, datdba, * FROM pg_database +## oid: 1.3.6.1.4.1.27645.1.3.1 +## indexes: 1 +## min_column: 1 +## types: +## - +## colnum: 1 +## type: oid +# - +## colnum: 2 +## type: string +# - +# name: random +# query: SELECT 1, '1.3.6.1.3.11', 2, floor(100 * random()) union select 2, '1.3.6.1.2.1', floor(random() * 10), 5 +# oid: 1.3.6.1.4.1.27645.1.3.2 +# indexes: 1 +# min_column: 1 +# types: +# - +# 1: ASN_INTEGER +# #2: ASN_OBJECT_ID +# 2: ASN_OCTET_STR +# 3: ASN_INTEGER +# - +# name: pg_class +# query: SELECT oid, reltuples, reltoastrelid, 'test string', * FROM pg_class +# oid: 1.3.6.1.4.1.27645.1.3.3 +# indexes: 1 +# min_column: 1 +# - +# name: test +# query: SELECT 'test', 't'::boolean, 14 +# oid: 1.3.6.1.4.1.27646.1.1 +# indexes: 1 +# min_column: 1 +# - +# name: easytest +# query: SELECT 1, 'test', 't'::boolean, random() UNION SELECT 2, 'test2', 'f'::boolean, random() +# oid: 1.3.6.1.4.1.27646.1.2 +# indexes: 1 +# min_column: 1 +## - +## name: pgsqlPgAmopTable +## query: SELECT oid, amopfamily, amoplefttype, amoprighttype , amopstrategy , amopreqcheck , amopopr, amopmethod FROM pg_amop LIMIT 4 +## oid: 1.3.6.1.4.1.27645.1.2.3 +## indexes: 1 +## min_column: 1 |