Módulos generados por el plugin
El plugin crearácreará un agente con el nombre que le hayamos puesto con el paráparámetro "--agent_name" si no se usa este paráparámetro se quedara con "PostgreSQL" por defecto:
En este agente se crearácrearán un mómódulo por cada consulta personalizada especificada en pandora_postgresql.conf, con el nombre que le hayamos asignado a cada una de estas.
Por ejemplo el siguiente conf:
number_connections:SELECT count(*) FROM pg_stat_activity;:generic_data:Number of Connections or running backend
connections_waiting_in_locks:SELECT count(*) FROM pg_stat_activity WHERE wait_event = 'Lock';:generic_data:Number of connections/backends waiting on locks
connections_idle_in_transaction:SELECT count(*) FROM pg_stat_activity WHERE wait_event = 'idle in transaction';:generic_data:Number of backends in a transaction, but are currently not doing anything and could be waiting for an input from the end user.generic_data
number_users:SELECT COUNT(usename) FROM pg_stat_activity;:generic_data:Number users conected in postgreSQLgeneric_data
number_roles:SELECT count(*) FROM pg_roles;:generic_data:A role can be thought of as either a database user, or a group of database users, depending on how the role is set up.generic_data
psql_version:SELECT version();:generic_data_string:PostgrSQL versiongeneric_data_string
num_blocks:SELECT COUNT(*) FROM pg_locks;:generic_data:Ageneric_data
highpsql_diskspace:SELECT numberROUND(SUM(pg_database_size(oid))/1024/1024) ofFROM deadlocks indicates that there is a higher probability that two or more processes will attempt to access the same resource.pg_database;:generic_data
number_commits:SELECT sum(xact_commit) FROM (pg_database AS db JOIN pg_stat_database sdb ON db.datname=sdb.datname) WHERE db.datname = _database_;'postgres';:generic_data:Number of commits the current transaction. All changes made by the transaction become visible to others and are guaranteed to be durable if a crash occurs.generic_data
number_rollbacks:SELECT sum(xact_rollback) FROM (pg_database AS db JOIN pg_stat_database sdb ON db.datname=sdb.datname) WHERE db.datname = _database_;'postgres';:generic_data:This metric represents the number of times, per transaction during the sample period, that users manually issue the ROLLBACK statement or an error occurred during a user's transactions.generic_data
tuples_returned:SELECT sum(tup_returned) FROM (pg_database AS db JOIN pg_stat_database sdb ON db.datname=sdb.datname) WHERE db.datname = _database_;'postgres';:generic_data:Number of rows returned by queries in this databasegeneric_data
tuples_searched:SELECT sum(tup_fetched) FROM (pg_database AS db JOIN pg_stat_database sdb ON db.datname=sdb.datname )WHERE db.datname = _database_;'postgres';:generic_data:Number of tuples searchedgeneric_data
tuples_inserted:SELECT sum(tup_inserted) FROM (pg_database AS db JOIN pg_stat_database sdb ON db.datname=sdb.datname) WHERE db.datname = _database_;'postgres';:generic_data:Number of rows inserted into tablegeneric_data
tuples_updated:SELECT sum(tup_updated) FROM (pg_database AS db JOIN pg_stat_database sdb ON db.datname=sdb.datname) WHERE db.datname = _database_;'postgres';:generic_data:Number of tuples updatedgeneric_data
tuples_removed:SELECT sum(tup_deleted) FROM (pg_database AS db JOIN pg_stat_database sdb ON db.datname=sdb.datname) WHERE db.datname = _database_;'postgres';:generic_data:Number of tuples removedgeneric_data
state:SELECT state FROM pg_stat_activity WHERE datname = _database_;:generic_data_string:Database status
number_databases_list:select * from pg_database;'postgres';:generic_data_stringCrearáCreará los siguientes mómódulos:
a