Log file: /root/postgresql.log

• SELECT (29)
• INSERT (6)
• UPDATE (5)
• DELETE (2)
• BEGIN (1)
• COMMIT (1)

Query System Impact : SELECT

Log activity from 2011-10-26 14:49:26 to 2011-10-26 14:49:26

SELECT description, status
 FROM triggers
 WHERE triggerid = ?

SELECT conditiontype, operator, value
 FROM opconditions
 WHERE operationid = ?
 ORDER BY conditiontype

SELECT DISTINCT i.hostid
 FROM items i, functions f
 WHERE i.itemid=f.itemid AND f.triggerid = ?

SELECT itemid, status, lastclock, prevorgvalue, delta, multiplier, formula, history, trends, 
   error
 FROM items
 WHERE (itemid IN (?+) OR itemid IN (?+))
 ORDER BY itemid

SELECT mediatypeid, sendto, severity, period
 FROM media
 WHERE active = ? AND userid = ?

SELECT type
 FROM users
 WHERE userid = ?

SELECT hostid
 FROM hosts
 WHERE host = ? AND status IN (?+) AND hostid BETWEEN ? AND ?

SELECT description, expression, priority, type
 FROM triggers
 WHERE triggerid = ?

SELECT conditionid, conditiontype, operator, value
 FROM conditions
 WHERE actionid = ?
 ORDER BY conditiontype

SELECT t.triggerid, t.value
 FROM trigger_depends d, triggers t
 WHERE d.triggerid_down = ? AND d.triggerid_up=t.triggerid

SELECT i.itemid, i.value_type, i.valuemapid, i.units, i.lastvalue
 FROM items i, functions f
 WHERE i.itemid=f.itemid AND f.functionid = ?

SELECT eventid, value
 FROM events
 WHERE source = ? AND object = ? AND objectid = ? AND value IN (?+)
 ORDER BY object DESC, objectid DESC, eventid DESC
 LIMIT ?

SELECT autoreg_hostid
 FROM autoreg_host
 WHERE proxy_hostid = ? AND host = ? AND autoreg_hostid BETWEEN ? AND ?

SELECT eventid, source, object, objectid, clock, value, acknowledged
 FROM events
 WHERE eventid = ?

SELECT h.host
 FROM hosts h, items i, functions f, triggers t
 WHERE t.triggerid = ? AND t.triggerid=f.triggerid AND f.itemid=i.itemid AND i.hostid=h.hostid 
   AND h.status = ?

SELECT actionid, evaltype
 FROM actions
 WHERE status = ? AND eventsource = ? AND actionid BETWEEN ? AND ?

SELECT description, expression, priority, comments, url
 FROM triggers
 WHERE triggerid = ?

SELECT i.itemid, i.key_, h.host, h.port, i.delay, i.description, i.type, h.useip, h.ip, i.history, 
   i.lastvalue, i.prevvalue, i.hostid, i.value_type, i.delta, i.prevorgvalue, i.lastclock, 
   i.units, i.multiplier, i.formula, i.status, i.valuemapid, h.dns, i.trends, i.lastlogsize, 
   i.data_type, i.mtime
 FROM hosts h, items i
 WHERE h.hostid=i.hostid AND h.status = ? AND i.status = ? AND ((h.host = ? AND i.key_ = ?) OR (h.host = ? 
   AND i.key_ = ?)) AND h.hostid BETWEEN ? AND ?

SELECT source
 FROM events
 WHERE eventid = ?

SELECT i.description
 FROM items i, functions f, triggers t
 WHERE t.triggerid = ? AND f.triggerid=t.triggerid AND i.itemid=f.itemid AND i.status = ?

SELECT mediatypeid
 FROM opmediatypes
 WHERE operationid = ?

SELECT expression
 FROM triggers
 WHERE triggerid = ?

SELECT hostid
 FROM hosts
 WHERE proxy_hostid = ? AND host = ? AND hostid BETWEEN ? AND ?

SELECT serviceid
 FROM services
 WHERE triggerid = ?

SELECT operationid, operationtype, object, objectid, default_msg, shortdata, longdata, esc_period, 
   evaltype
 FROM operations
 WHERE actionid = ? AND operationtype IN (?+)

SELECT COUNT(*)
 FROM usrgrp g, users_groups ug
 WHERE ug.userid = ? AND g.usrgrpid = ug.usrgrpid AND g.users_status = ?

SELECT DISTINCT i.itemid, i.key_, h.host, h.port, i.delay, i.description, i.type, h.useip, 
   h.ip, i.history, i.lastvalue, i.prevvalue, i.hostid, i.value_type, i.delta, i.prevorgvalue, 
   i.lastclock, i.units, i.multiplier, i.formula, i.status, i.valuemapid, h.dns, i.trends, 
   i.lastlogsize, i.data_type, i.mtime, f.function, f.parameter, h.status
 FROM hosts h, items i, functions f
 WHERE i.hostid=h.hostid AND i.itemid=f.itemid AND f.functionid = ?

SELECT nextid
 FROM ids
 WHERE nodeid = ? AND table_name = ? AND field_name = ?

SELECT actionid, eventsource, esc_period, def_shortdata, def_longdata, recovery_msg, status, 
   name
 FROM actions
 WHERE actionid = ?

Query System Impact : INSERT

Log activity from 2011-10-26 14:49:26 to 2011-10-26 14:49:26

INSERT INTO alerts (alertid, actionid, eventid, userid, clock, mediatypeid, sendto, subject, 
   message, status, alerttype, esc_step)
 VALUES (?, ?, ?, ?, ?, ?, ?, ?, 'mass.test[?]_warn: ok

INSERT INTO alerts (alertid, actionid, eventid, userid, clock, mediatypeid, sendto, subject, 
   message, status, alerttype, esc_step)
 VALUES (?, ?, ?, ?, ?, ?, ?, ?, 'mass.test[?]_warn: problem

INSERT INTO events (eventid, source, object, objectid, clock, value)
 VALUES (?, ?, ?, ?, ?, ?)

INSERT INTO alerts (alertid, actionid, eventid, userid, clock, mediatypeid, sendto, subject, 
   message, status, alerttype, esc_step)
 VALUES (?, ?, ?, ?, ?, ?, ?, ?, 'mass.test[?]_crit: problem

INSERT INTO alerts (alertid, actionid, eventid, userid, clock, mediatypeid, sendto, subject, 
   message, status, alerttype, esc_step)
 VALUES (?, ?, ?, ?, ?, ?, ?, ?, 'mass.test[?]_crit: ok

INSERT INTO escalations (escalationid, actionid, triggerid, eventid, status)
 VALUES (?, ?, ?, ?, ?)

Query System Impact : UPDATE

Log activity from 2011-10-26 14:49:26 to 2011-10-26 14:49:26

UPDATE items
 SET lastclock = ?, prevvalue=lastvalue, lastvalue = ?
 WHERE itemid = ?

UPDATE ids
 SET nextid=nextid+?
 WHERE nodeid = ? AND table_name = ? AND field_name = ?

UPDATE alerts
 SET retries = ?, error = ?
 WHERE alertid = ?

UPDATE escalations
 SET status = ?
 WHERE actionid = ? AND triggerid = ? AND esc_step = ? AND status = ?

UPDATE triggers
 SET value = ?, lastchange = ?, error = ?
 WHERE triggerid = ?

Query System Impact : DELETE

Log activity from 2011-10-26 14:49:26 to 2011-10-26 14:49:26

DELETE FROM escalations
 WHERE escalationid = ?

DELETE FROM escalations
 WHERE actionid = ? AND triggerid = ? AND status NOT IN (?+) AND (esc_step<> ? OR status<> ?)

Query System Impact : BEGIN

Log activity from 2011-10-26 14:49:26 to 2011-10-26 14:49:26

BEGIN

Query System Impact : COMMIT

Log activity from 2011-10-26 14:49:26 to 2011-10-26 14:49:26

COMMIT