Spacewalk 2.1 Cfg Deploy 100 Systems

Overall statistics | Queries by type | Queries that took up the most time (N) | Slowest queries | Most frequent queries (N) | Slowest queries (N)

Normalized reports are marked with a "(N)".

Overall statistics ^

Queries by type ^

Type Count Percentage
SELECT 490 40.6
INSERT 73 6.0
UPDATE 100 8.3
DELETE 61 5.1

Queries that took up the most time (N) ^

Rank Total duration Times executed Av. duration (ms) Query
1 85ms
2
Day Time Count Av. Duration
Apr 15 9am 2 42.35
42.35
SELECT S.ID, S.NAME#0#0#0 FROM rhnServer S,#0#0#0 rhnServerConfigChannel SCC,#0 #0 rhnUserServerPerms USP#0#0#0 WHERE rhn_config_channel.get_user_chan_access(0, 0) = 0#0#0#0 AND SCC.config_channel_id = 0#0#0#0 AND S.id = SCC.server_id#0 #0#0 AND USP.server_id = S.id#0#0#0 AND USP.user_id = 0#0#0#0 ORDER BY S.NAME;
2 77ms
214
Day Time Count Av. Duration
Apr 15 9am 214 0.36
0.36
COMMIT;
3 49ms
32
Day Time Count Av. Duration
Apr 15 9am 32 1.54
1.54
#0 select a.id, sa.server_id, pc.jabber_id,#0 date_diff_in_days(current_timestamp, earliest_action) * 0 delta#0 from#0 rhnServerAction sa,#0 rhnAction a,#0 rhnPushClient pc#0 where pc.server_id = sa.server_id#0 and sa.action_id = a.id#0 and sa.status in (...) -- Queued or picked up#0 and not exists (#0 -- This is like saying 'this action has no#0 -- prerequisite or has a prerequisite that has completed#0 -- (status = 0)#0 select 0#0 from rhnServerAction sap#0 where sap.server_id = sa.server_id#0 and sap.action_id = a.prerequisite#0 and sap.status != 0#0 )#0 order by earliest_action#0;
4 12ms
1
Day Time Count Av. Duration
Apr 15 9am 1 11.67
11.67
SELECT S.ID, S.NAME#011#011#011 FROM rhnServer S,#011#011#011#011 rhnSet ST,#011#011#011 rhnServerConfigChannel SCC,#011 #011 rhnUserServerPerms USP#011#011#011 WHERE rhn_config_channel.get_user_chan_access(1, 3) = 1#011#011#011 AND SCC.config_channel_id = 1#011#011#011 AND S.id = SCC.server_id#011#011#011 AND ST.user_id = 3#011 #011#011 AND ST.label = 'config_channel_deploy_systems'#011#011#011 AND ST.element = S.id#011 #011#011 AND USP.server_id = S.id#011#011#011 AND USP.user_id = 3#011#011 ORDER BY S.NAME;
5 10ms
20
Day Time Count Av. Duration
Apr 15 9am 20 0.51
0.51
insert into rhnTaskoRun (org_id, template_id, schedule_id, start_time, end_time, std_output_path, std_error_path, status, id) values (NULL, 0, 0, NULL, NULL, NULL, NULL, '', 0);
6 9ms
1
Day Time Count Av. Duration
Apr 15 9am 1 8.79
8.79
SELECT id from rhnDevice;
7 8ms
32
Day Time Count Av. Duration
Apr 15 9am 32 0.23
0.23
#0 update rhnPushClient#0 set state_id = 0#0 where state_id = 0#0 and last_ping_time is not null#0 and current_timestamp > next_action_time#0;
8 7ms
2
Day Time Count Av. Duration
Apr 15 9am 2 3.29
3.29
SELECT CF.id,#0#0 CF.latest_config_revision_id,#0 CFN.path,#0 CR.revision AS latest_config_revision,#0 coalesce(CCon.modified, CR.modified) as modified,#0#0 CFT.label as type#0 FROM rhnConfigFileName CFN,#0 rhnConfigFile CF,#0 rhnConfigRevision CR LEFT OUTER JOIN rhnConfigContent CCon#0 ON CR.config_content_id = CCon.id,#0#0 rhnSet ST,#0#0 rhnConfigFileType CFT#0 WHERE rhn_config_channel.get_user_chan_access(0, 0) = 0#0 AND ST.user_id = 0#0 AND ST.label = ''#0 AND ST.element = CF.id#0 AND CF.config_channel_id = 0#0 AND CFN.id = CF.config_file_name_id#0 AND CR.config_file_id = CF.id#0 AND CF.latest_config_revision_id = CR.id#0 AND CFT.id = CR.config_file_type_id#0ORDER BY CFN.path;
9 6ms
1
Day Time Count Av. Duration
Apr 15 9am 1 5.78
5.78
SELECT S.ID,#011 COALESCE((#011#011#011#011#011SELECT COUNT(DISTINCT CFN2.id)#011#011#011#011#011FROM rhnConfigChannel CC2, rhnConfigChannelType CCT2, rhnServerConfigChannel SCC2,#011#011#011#011#011#011 rhnConfigFile cf2, rhnConfigFileName cfn2,#011#011#011#011#011#011 rhnConfigChannel CC, rhnServerConfigChannel SCC,#011#011#011#011#011#011 rhnConfigFile cf, rhnConfigFileName cfn#011#011#011#011#011WHERE SCC2.server_id = S.ID#011#011#011#011#011 AND scc.server_id = S.ID#011#011#011#011#011 AND cc.id = $1#011#011#011#011#011 AND cf.config_channel_id = cc.id#011#011#011#011#011 AND cfn.id = cf.config_file_name_id#011#011#011#011#011 AND CC2.id = SCC2.config_channel_id#011#011#011#011#011 AND CC2.confchan_type_id = CCT2.id#011#011#011#011#011 AND CCT2.label = 'local_override'#011#011#011#011#011 AND CF2.config_channel_Id = CC2.id#011#011#011#011#011 AND CFN2.id = CF2.config_file_name_id#011#011#011#011#011 AND cfn.id = cfn2.id#011#011#011#011 ), 0) overridden_count,#011#011#011#011COALESCE((#011#011#011#011#011SELECT COUNT(DISTINCT CFN.id)#011#011#011#011#011 FROM rhnConfigChannel CC,#011#011#011#011#011#011 rhnConfigFile cf,#011#011#011#011 #011#011 rhnConfigFileName cfn,#011 rhnServerConfigChannel SCC,#011#011#011#011#011#011 rhnConfigChannel CC2,#011 rhnServerConfigChannel SCC2,;
10 5ms
4
Day Time Count Av. Duration
Apr 15 9am 4 1.22
1.22
select * from rhn_synch_probe_state() as result;
11 5ms
8
Day Time Count Av. Duration
Apr 15 9am 8 0.61
0.61
select * from rhn_config_channel.get_user_chan_access('',0, 0) as result;
12 5ms
19
Day Time Count Av. Duration
Apr 15 9am 19 0.25
0.25
INSERT INTO QRTZ_FIRED_TRIGGERS (ENTRY_ID, TRIGGER_NAME, TRIGGER_GROUP, IS_VOLATILE, INSTANCE_NAME, FIRED_TIME, STATE, JOB_NAME, JOB_GROUP, IS_STATEFUL, REQUESTS_RECOVERY, PRIORITY) VALUES('', '', '', '', '', 0, '', NULL, NULL, '', '', 0);
13 4ms
19
Day Time Count Av. Duration
Apr 15 9am 19 0.24
0.24
UPDATE QRTZ_TRIGGERS SET TRIGGER_STATE = '' WHERE TRIGGER_NAME = '' AND TRIGGER_GROUP = '' AND TRIGGER_STATE = '';
14 4ms
19
Day Time Count Av. Duration
Apr 15 9am 19 0.21
0.21
INSERT INTO QRTZ_FIRED_TRIGGERS (ENTRY_ID, TRIGGER_NAME, TRIGGER_GROUP, IS_VOLATILE, INSTANCE_NAME, FIRED_TIME, STATE, JOB_NAME, JOB_GROUP, IS_STATEFUL, REQUESTS_RECOVERY, PRIORITY) VALUES('', '', '', '', '', 0, '', '', '', '', '', 0);
15 4ms
1
Day Time Count Av. Duration
Apr 15 9am 1 3.85
3.85
SELECT#011 s.id as id,#011 s.name as name,#011 s.description as description,#011 s.info as info,#011 s.created as registered,#011 s.running_kernel as runningKernel,#011 sl.machine as machine,#011 sl.rack as rack,#011 sl.room as room,#011 sl.building as building,#011 sl.address1 as address1,#011 sl.address2 as address2,#011 sl.city as city,#011 sl.state as state,#011 sl.country as country,#011 rsn.hostname as hostname,#011 rsn.ipaddr as ipaddr,#011 rsn.ip6addr as ip6addr,#011 dmi.vendor as dmiVendor,#011 dmi.system as dmiSystem,#011 dmi.product as dmiProduct,#011 dmi.bios_vendor as dmiBiosVendor,#011 dmi.bios_version as dmiBiosVersion,#011 dmi.bios_release as dmiBiosRelease,#011 dmi.asset as dmiAsset,#011 dmi.board as dmiBoard,#011 cpu.bogomips as cpuBogoMIPS,#011 cpu.cache as cpuCache,#011 cpu.family as cpuFamily,#011 cpu.mhz as cpuMHz,#011 cpu.stepping as cpuStepping,#011 cpu.flags as cpuFlags,#011 cpu.model as cpuModel,#011 cpu.version as cpuVersion,#011 cpu.vendor as cpuVendor,#011 cpu.nrcpu as cpuNumberOfCpus,#011 cpu.acpiversion as cpuAcpiVersion,#011 cpu.apic as cpuApic,#011 cpu.apmversion as cpuApmVersion,#011 cpu.chipset as cpuChipset,#011 si.checkin as checkin,#011 rr.ram as ram,#011 rr.swap as swap,#011 vi.uuid as uuid#011 FROM rhnServer s#011 LEFT OUTER JOIN rhnServerNetwork rsn ON s.id = rsn.server_id#011 LEFT OUTER JOIN rhnServerInfo si on s.id = si.server_id#011 LEFT OUTER JOIN rhnRam rr on s.id = rr.server_id#011 LEFT OUTER JOIN rhnServerLocation sl ON s.id = sl.server_id#011 LEFT OUTER JOIN rhnServerDmi dmi ON s.id = dmi.server_id#011 LEFT OUTER JOIN rhnCPU cpu on s.id = cpu.server_id#011 LEFT OUTER JOIN rhnVirtualInstance vi on s.id = vi.virtual_system_id#011 WHERE s.modified >= '2014-04-10 17:04:11.848+02'#011 or rsn.modified >= '2014-04-10 17:04:11.848+02'#011 or si.checkin >= '2014-04-10 17:04:11.848+02'#011 or rr.modified >= '2014-04-10 17:04:11.848+02'#011 or sl.modified >= '2014-04-10 17:04:11.848+02'#011 or dmi.modified >= '2014-04-10 17:04:11.848+02'#011 or cpu.modified >= '2014-04-10 17:04:11.848+02'#011 or s.id > 1000010433#011 ORDER by s.id ASC;
16 4ms
19
Day Time Count Av. Duration
Apr 15 9am 19 0.20
0.20
UPDATE QRTZ_TRIGGERS SET JOB_NAME = '', JOB_GROUP = '', IS_VOLATILE = '', DESCRIPTION = NULL, NEXT_FIRE_TIME = 0, PREV_FIRE_TIME = 0, TRIGGER_STATE = '', TRIGGER_TYPE = '', START_TIME = 0, END_TIME = 0, CALENDAR_NAME = NULL, MISFIRE_INSTR = 0, PRIORITY = 0 WHERE TRIGGER_NAME = '' AND TRIGGER_GROUP = '';
17 4ms
32
Day Time Count Av. Duration
Apr 15 9am 32 0.11
0.11
#0 select id, name, shared_key, jabber_id#0 from rhnPushClient#0 where state_id = 0#0 and last_ping_time is not null#0 and next_action_time is null#0 and jabber_id is not null#0;
18 3ms
20
Day Time Count Av. Duration
Apr 15 9am 20 0.13
0.13
update rhnTaskoRun set org_id=NULL, template_id=0, schedule_id=0, start_time='', end_time=NULL, std_output_path='', std_error_path='', status='' where id=0;
19 2ms
14
Day Time Count Av. Duration
Apr 15 9am 14 0.17
0.17
INSERT#0 INTO rhnSet (user_id, label, element)#0 VALUES (0, '', 0);
20 2ms
19
Day Time Count Av. Duration
Apr 15 9am 19 0.13
0.13
update rhnTaskoRun set org_id=NULL, template_id=0, schedule_id=0, start_time='', end_time='', std_output_path=NULL, std_error_path=NULL, status='' where id=0;

Slowest queries ^

Rank Duration (ms) Query
1 43.64
SELECT S.ID, S.NAME#011#011#011 FROM rhnServer S,#011#011#011 rhnServerConfigChannel SCC,#011 #011 rhnUserServerPerms USP#011#011#011 WHERE rhn_config_channel.get_user_chan_access(1, 3) = 1#011#011#011 AND SCC.config_channel_id = 1#011#011#011 AND S.id = SCC.server_id#011 #011#011 AND USP.server_id = S.id#011#011#011 AND USP.user_id = 3#011#011#011 ORDER BY S.NAME;
2 41.06
SELECT S.ID, S.NAME#011#011#011 FROM rhnServer S,#011#011#011 rhnServerConfigChannel SCC,#011 #011 rhnUserServerPerms USP#011#011#011 WHERE rhn_config_channel.get_user_chan_access(1, 3) = 1#011#011#011 AND SCC.config_channel_id = 1#011#011#011 AND S.id = SCC.server_id#011 #011#011 AND USP.server_id = S.id#011#011#011 AND USP.user_id = 3#011#011#011 ORDER BY S.NAME;
3 11.67
SELECT S.ID, S.NAME#011#011#011 FROM rhnServer S,#011#011#011#011 rhnSet ST,#011#011#011 rhnServerConfigChannel SCC,#011 #011 rhnUserServerPerms USP#011#011#011 WHERE rhn_config_channel.get_user_chan_access(1, 3) = 1#011#011#011 AND SCC.config_channel_id = 1#011#011#011 AND S.id = SCC.server_id#011#011#011 AND ST.user_id = 3#011 #011#011 AND ST.label = 'config_channel_deploy_systems'#011#011#011 AND ST.element = S.id#011 #011#011 AND USP.server_id = S.id#011#011#011 AND USP.user_id = 3#011#011 ORDER BY S.NAME;
4 8.79
SELECT id from rhnDevice;
5 5.78
SELECT S.ID,#011 COALESCE((#011#011#011#011#011SELECT COUNT(DISTINCT CFN2.id)#011#011#011#011#011FROM rhnConfigChannel CC2, rhnConfigChannelType CCT2, rhnServerConfigChannel SCC2,#011#011#011#011#011#011 rhnConfigFile cf2, rhnConfigFileName cfn2,#011#011#011#011#011#011 rhnConfigChannel CC, rhnServerConfigChannel SCC,#011#011#011#011#011#011 rhnConfigFile cf, rhnConfigFileName cfn#011#011#011#011#011WHERE SCC2.server_id = S.ID#011#011#011#011#011 AND scc.server_id = S.ID#011#011#011#011#011 AND cc.id = $1#011#011#011#011#011 AND cf.config_channel_id = cc.id#011#011#011#011#011 AND cfn.id = cf.config_file_name_id#011#011#011#011#011 AND CC2.id = SCC2.config_channel_id#011#011#011#011#011 AND CC2.confchan_type_id = CCT2.id#011#011#011#011#011 AND CCT2.label = 'local_override'#011#011#011#011#011 AND CF2.config_channel_Id = CC2.id#011#011#011#011#011 AND CFN2.id = CF2.config_file_name_id#011#011#011#011#011 AND cfn.id = cfn2.id#011#011#011#011 ), 0) overridden_count,#011#011#011#011COALESCE((#011#011#011#011#011SELECT COUNT(DISTINCT CFN.id)#011#011#011#011#011 FROM rhnConfigChannel CC,#011#011#011#011#011#011 rhnConfigFile cf,#011#011#011#011 #011#011 rhnConfigFileName cfn,#011 rhnServerConfigChannel SCC,#011#011#011#011#011#011 rhnConfigChannel CC2,#011 rhnServerConfigChannel SCC2,;
6 5.16
COMMIT;
7 4.69
COMMIT;
8 4.40
select * from rhn_synch_probe_state() as result;
9 4.20
insert into rhnTaskoRun (org_id, template_id, schedule_id, start_time, end_time, std_output_path, std_error_path, status, id) values (NULL, 7, 1, NULL, NULL, NULL, NULL, 'READY', 937996);
10 3.85
SELECT#011 s.id as id,#011 s.name as name,#011 s.description as description,#011 s.info as info,#011 s.created as registered,#011 s.running_kernel as runningKernel,#011 sl.machine as machine,#011 sl.rack as rack,#011 sl.room as room,#011 sl.building as building,#011 sl.address1 as address1,#011 sl.address2 as address2,#011 sl.city as city,#011 sl.state as state,#011 sl.country as country,#011 rsn.hostname as hostname,#011 rsn.ipaddr as ipaddr,#011 rsn.ip6addr as ip6addr,#011 dmi.vendor as dmiVendor,#011 dmi.system as dmiSystem,#011 dmi.product as dmiProduct,#011 dmi.bios_vendor as dmiBiosVendor,#011 dmi.bios_version as dmiBiosVersion,#011 dmi.bios_release as dmiBiosRelease,#011 dmi.asset as dmiAsset,#011 dmi.board as dmiBoard,#011 cpu.bogomips as cpuBogoMIPS,#011 cpu.cache as cpuCache,#011 cpu.family as cpuFamily,#011 cpu.mhz as cpuMHz,#011 cpu.stepping as cpuStepping,#011 cpu.flags as cpuFlags,#011 cpu.model as cpuModel,#011 cpu.version as cpuVersion,#011 cpu.vendor as cpuVendor,#011 cpu.nrcpu as cpuNumberOfCpus,#011 cpu.acpiversion as cpuAcpiVersion,#011 cpu.apic as cpuApic,#011 cpu.apmversion as cpuApmVersion,#011 cpu.chipset as cpuChipset,#011 si.checkin as checkin,#011 rr.ram as ram,#011 rr.swap as swap,#011 vi.uuid as uuid#011 FROM rhnServer s#011 LEFT OUTER JOIN rhnServerNetwork rsn ON s.id = rsn.server_id#011 LEFT OUTER JOIN rhnServerInfo si on s.id = si.server_id#011 LEFT OUTER JOIN rhnRam rr on s.id = rr.server_id#011 LEFT OUTER JOIN rhnServerLocation sl ON s.id = sl.server_id#011 LEFT OUTER JOIN rhnServerDmi dmi ON s.id = dmi.server_id#011 LEFT OUTER JOIN rhnCPU cpu on s.id = cpu.server_id#011 LEFT OUTER JOIN rhnVirtualInstance vi on s.id = vi.virtual_system_id#011 WHERE s.modified >= '2014-04-10 17:04:11.848+02'#011 or rsn.modified >= '2014-04-10 17:04:11.848+02'#011 or si.checkin >= '2014-04-10 17:04:11.848+02'#011 or rr.modified >= '2014-04-10 17:04:11.848+02'#011 or sl.modified >= '2014-04-10 17:04:11.848+02'#011 or dmi.modified >= '2014-04-10 17:04:11.848+02'#011 or cpu.modified >= '2014-04-10 17:04:11.848+02'#011 or s.id > 1000010433#011 ORDER by s.id ASC;
11 3.48
COMMIT;
12 3.34
SELECT CF.id,#011#011 CF.latest_config_revision_id,#011 CFN.path,#011 CR.revision AS latest_config_revision,#011 coalesce(CCon.modified, CR.modified) as modified,#011#011 CFT.label as type#011 FROM rhnConfigFileName CFN,#011 rhnConfigFile CF,#011 rhnConfigRevision CR LEFT OUTER JOIN rhnConfigContent CCon#011 ON CR.config_content_id = CCon.id,#011#011 rhnSet ST,#011#011 rhnConfigFileType CFT#011 WHERE rhn_config_channel.get_user_chan_access(1, 3) = 1#011 AND ST.user_id = 3#011 AND ST.label = 'config_channel_deploy_revisions'#011 AND ST.element = CF.id#011 AND CF.config_channel_id = 1#011 AND CFN.id = CF.config_file_name_id#011 AND CR.config_file_id = CF.id#011 AND CF.latest_config_revision_id = CR.id#011 AND CFT.id = CR.config_file_type_id#011ORDER BY CFN.path;
13 3.32
select * from rhn_config_channel.get_user_chan_access('',1, 3) as result;
14 3.24
SELECT CF.id,#011#011 CF.latest_config_revision_id,#011 CFN.path,#011 CR.revision AS latest_config_revision,#011 coalesce(CCon.modified, CR.modified) as modified,#011#011 CFT.label as type#011 FROM rhnConfigFileName CFN,#011 rhnConfigFile CF,#011 rhnConfigRevision CR LEFT OUTER JOIN rhnConfigContent CCon#011 ON CR.config_content_id = CCon.id,#011#011 rhnSet ST,#011#011 rhnConfigFileType CFT#011 WHERE rhn_config_channel.get_user_chan_access(1, 3) = 1#011 AND ST.user_id = 3#011 AND ST.label = 'config_channel_deploy_revisions'#011 AND ST.element = CF.id#011 AND CF.config_channel_id = 1#011 AND CFN.id = CF.config_file_name_id#011 AND CR.config_file_id = CF.id#011 AND CF.latest_config_revision_id = CR.id#011 AND CFT.id = CR.config_file_type_id#011ORDER BY CFN.path;
15 2.68
COMMIT;
16 2.34
COMMIT;
17 2.23
COMMIT;
18 2.17
SELECT CF.id,#011#011 CF.latest_config_revision_id,#011 CFN.path,#011#011 CR.revision AS latest_config_revision,#011 coalesce(CCon.modified, CR.modified) as modified,#011 CFT.label as type#011 FROM rhnConfigFileName CFN,#011 rhnConfigFile CF,#011 rhnConfigRevision CR LEFT OUTER JOIN rhnConfigContent CCon#011 ON CR.config_content_id = CCon.id,#011 rhnConfigFileType CFT#011 WHERE rhn_config_channel.get_user_chan_access(1, 3) = 1#011 AND CF.config_channel_id = 1#011 AND CFN.id = CF.config_file_name_id#011 AND CR.config_file_id = CF.id#011 AND CF.latest_config_revision_id = CR.id#011 AND CR.config_file_type_id = CFT.id#011ORDER BY CFN.path;
19 2.13
COMMIT;
20 2.05
#011 select a.id, sa.server_id, pc.jabber_id,#011 date_diff_in_days(current_timestamp, earliest_action) * 86400 delta#011 from#011 rhnServerAction sa,#011 rhnAction a,#011 rhnPushClient pc#011 where pc.server_id = sa.server_id#011 and sa.action_id = a.id#011 and sa.status in (0, 1) -- Queued or picked up#011 and not exists (#011 -- This is like saying 'this action has no#011 -- prerequisite or has a prerequisite that has completed#011 -- (status = 2)#011 select 1#011 from rhnServerAction sap#011 where sap.server_id = sa.server_id#011 and sap.action_id = a.prerequisite#011 and sap.status != 2#011 )#011 order by earliest_action#011;

Most frequent queries (N) ^

Rank Times executed Total duration Av. duration (ms) Query
1
214
Day Time Count Av. Duration
Apr 15 9am 214 0.36
77ms 0.36
COMMIT;
2
164
Day Time Count Av. Duration
Apr 15 9am 164 0.01
1ms 0.01
BEGIN;
3
104
Day Time Count Av. Duration
Apr 15 9am 104 0.02
2ms 0.02
select '' from dual;
4
35
Day Time Count Av. Duration
Apr 15 9am 35 0.05
2ms 0.05
DELETE FROM QRTZ_FIRED_TRIGGERS WHERE ENTRY_ID = '';
5
32
Day Time Count Av. Duration
Apr 15 9am 32 1.54
49ms 1.54
#0 select a.id, sa.server_id, pc.jabber_id,#0 date_diff_in_days(current_timestamp, earliest_action) * 0 delta#0 from#0 rhnServerAction sa,#0 rhnAction a,#0 rhnPushClient pc#0 where pc.server_id = sa.server_id#0 and sa.action_id = a.id#0 and sa.status in (...) -- Queued or picked up#0 and not exists (#0 -- This is like saying 'this action has no#0 -- prerequisite or has a prerequisite that has completed#0 -- (status = 0)#0 select 0#0 from rhnServerAction sap#0 where sap.server_id = sa.server_id#0 and sap.action_id = a.prerequisite#0 and sap.status != 0#0 )#0 order by earliest_action#0;
6
32
Day Time Count Av. Duration
Apr 15 9am 32 0.23
8ms 0.23
#0 update rhnPushClient#0 set state_id = 0#0 where state_id = 0#0 and last_ping_time is not null#0 and current_timestamp > next_action_time#0;
7
32
Day Time Count Av. Duration
Apr 15 9am 32 0.11
4ms 0.11
#0 select id, name, shared_key, jabber_id#0 from rhnPushClient#0 where state_id = 0#0 and last_ping_time is not null#0 and next_action_time is null#0 and jabber_id is not null#0;
8
26
Day Time Count Av. Duration
Apr 15 9am 26 0.06
1ms 0.06
SELECT TRIGGER_NAME, TRIGGER_GROUP, NEXT_FIRE_TIME, PRIORITY FROM QRTZ_TRIGGERS WHERE TRIGGER_STATE = '' AND NEXT_FIRE_TIME < 0 AND (NEXT_FIRE_TIME >= 0) ORDER BY NEXT_FIRE_TIME ASC, PRIORITY DESC;
9
20
Day Time Count Av. Duration
Apr 15 9am 20 0.51
10ms 0.51
insert into rhnTaskoRun (org_id, template_id, schedule_id, start_time, end_time, std_output_path, std_error_path, status, id) values (NULL, 0, 0, NULL, NULL, NULL, NULL, '', 0);
10
20
Day Time Count Av. Duration
Apr 15 9am 20 0.13
3ms 0.13
update rhnTaskoRun set org_id=NULL, template_id=0, schedule_id=0, start_time='', end_time=NULL, std_output_path='', std_error_path='', status='' where id=0;
11
20
Day Time Count Av. Duration
Apr 15 9am 20 0.06
1ms 0.06
select taskosched0_.id as id2_, taskosched0_.job_label as job2_2_, taskosched0_.bunch_id as bunch3_2_, taskosched0_.org_id as org4_2_, taskosched0_.active_from as active5_2_, taskosched0_.active_till as active6_2_, taskosched0_.cron_expr as cron7_2_, taskosched0_.data as data2_, taskosched0_.created as created2_, taskosched0_.modified as modified2_ from rhnTaskoSchedule taskosched0_ where taskosched0_.id=0;
12
20
Day Time Count Av. Duration
Apr 15 9am 20 0.04
1ms 0.04
select taskotask0_.id as id3_0_, taskotask0_.name as name3_0_, taskotask0_.class as class3_0_, taskotask0_.created as created3_0_, taskotask0_.modified as modified3_0_ from rhnTaskoTask taskotask0_ where taskotask0_.id=0;
13
20
Day Time Count Av. Duration
Apr 15 9am 20 0.03
1ms 0.03
SELECT TRIGGER_STATE FROM QRTZ_TRIGGERS WHERE TRIGGER_NAME = '' AND TRIGGER_GROUP = '';
14
20
Day Time Count Av. Duration
Apr 15 9am 20 0.03
1ms 0.03
select nextval ('');
15
20
Day Time Count Av. Duration
Apr 15 9am 20 0.02
0ms 0.02
SELECT * FROM QRTZ_JOB_DETAILS WHERE JOB_NAME = '' AND JOB_GROUP = '';
16
19
Day Time Count Av. Duration
Apr 15 9am 19 0.25
5ms 0.25
INSERT INTO QRTZ_FIRED_TRIGGERS (ENTRY_ID, TRIGGER_NAME, TRIGGER_GROUP, IS_VOLATILE, INSTANCE_NAME, FIRED_TIME, STATE, JOB_NAME, JOB_GROUP, IS_STATEFUL, REQUESTS_RECOVERY, PRIORITY) VALUES('', '', '', '', '', 0, '', NULL, NULL, '', '', 0);
17
19
Day Time Count Av. Duration
Apr 15 9am 19 0.24
4ms 0.24
UPDATE QRTZ_TRIGGERS SET TRIGGER_STATE = '' WHERE TRIGGER_NAME = '' AND TRIGGER_GROUP = '' AND TRIGGER_STATE = '';
18
19
Day Time Count Av. Duration
Apr 15 9am 19 0.21
4ms 0.21
INSERT INTO QRTZ_FIRED_TRIGGERS (ENTRY_ID, TRIGGER_NAME, TRIGGER_GROUP, IS_VOLATILE, INSTANCE_NAME, FIRED_TIME, STATE, JOB_NAME, JOB_GROUP, IS_STATEFUL, REQUESTS_RECOVERY, PRIORITY) VALUES('', '', '', '', '', 0, '', '', '', '', '', 0);
19
19
Day Time Count Av. Duration
Apr 15 9am 19 0.20
4ms 0.20
UPDATE QRTZ_TRIGGERS SET JOB_NAME = '', JOB_GROUP = '', IS_VOLATILE = '', DESCRIPTION = NULL, NEXT_FIRE_TIME = 0, PREV_FIRE_TIME = 0, TRIGGER_STATE = '', TRIGGER_TYPE = '', START_TIME = 0, END_TIME = 0, CALENDAR_NAME = NULL, MISFIRE_INSTR = 0, PRIORITY = 0 WHERE TRIGGER_NAME = '' AND TRIGGER_GROUP = '';
20
19
Day Time Count Av. Duration
Apr 15 9am 19 0.13
2ms 0.13
update rhnTaskoRun set org_id=NULL, template_id=0, schedule_id=0, start_time='', end_time='', std_output_path=NULL, std_error_path=NULL, status='' where id=0;

Slowest queries (N) ^

Rank Av. duration (ms) Times executed Total duration Query
1 42.35
2
Day Time Count Av. Duration
Apr 15 9am 2 42.35
85ms
SELECT S.ID, S.NAME#0#0#0 FROM rhnServer S,#0#0#0 rhnServerConfigChannel SCC,#0 #0 rhnUserServerPerms USP#0#0#0 WHERE rhn_config_channel.get_user_chan_access(0, 0) = 0#0#0#0 AND SCC.config_channel_id = 0#0#0#0 AND S.id = SCC.server_id#0 #0#0 AND USP.server_id = S.id#0#0#0 AND USP.user_id = 0#0#0#0 ORDER BY S.NAME;
2 11.67
1
Day Time Count Av. Duration
Apr 15 9am 1 11.67
12ms
SELECT S.ID, S.NAME#011#011#011 FROM rhnServer S,#011#011#011#011 rhnSet ST,#011#011#011 rhnServerConfigChannel SCC,#011 #011 rhnUserServerPerms USP#011#011#011 WHERE rhn_config_channel.get_user_chan_access(1, 3) = 1#011#011#011 AND SCC.config_channel_id = 1#011#011#011 AND S.id = SCC.server_id#011#011#011 AND ST.user_id = 3#011 #011#011 AND ST.label = 'config_channel_deploy_systems'#011#011#011 AND ST.element = S.id#011 #011#011 AND USP.server_id = S.id#011#011#011 AND USP.user_id = 3#011#011 ORDER BY S.NAME;
3 8.79
1
Day Time Count Av. Duration
Apr 15 9am 1 8.79
9ms
SELECT id from rhnDevice;
4 5.78
1
Day Time Count Av. Duration
Apr 15 9am 1 5.78
6ms
SELECT S.ID,#011 COALESCE((#011#011#011#011#011SELECT COUNT(DISTINCT CFN2.id)#011#011#011#011#011FROM rhnConfigChannel CC2, rhnConfigChannelType CCT2, rhnServerConfigChannel SCC2,#011#011#011#011#011#011 rhnConfigFile cf2, rhnConfigFileName cfn2,#011#011#011#011#011#011 rhnConfigChannel CC, rhnServerConfigChannel SCC,#011#011#011#011#011#011 rhnConfigFile cf, rhnConfigFileName cfn#011#011#011#011#011WHERE SCC2.server_id = S.ID#011#011#011#011#011 AND scc.server_id = S.ID#011#011#011#011#011 AND cc.id = $1#011#011#011#011#011 AND cf.config_channel_id = cc.id#011#011#011#011#011 AND cfn.id = cf.config_file_name_id#011#011#011#011#011 AND CC2.id = SCC2.config_channel_id#011#011#011#011#011 AND CC2.confchan_type_id = CCT2.id#011#011#011#011#011 AND CCT2.label = 'local_override'#011#011#011#011#011 AND CF2.config_channel_Id = CC2.id#011#011#011#011#011 AND CFN2.id = CF2.config_file_name_id#011#011#011#011#011 AND cfn.id = cfn2.id#011#011#011#011 ), 0) overridden_count,#011#011#011#011COALESCE((#011#011#011#011#011SELECT COUNT(DISTINCT CFN.id)#011#011#011#011#011 FROM rhnConfigChannel CC,#011#011#011#011#011#011 rhnConfigFile cf,#011#011#011#011 #011#011 rhnConfigFileName cfn,#011 rhnServerConfigChannel SCC,#011#011#011#011#011#011 rhnConfigChannel CC2,#011 rhnServerConfigChannel SCC2,;
5 3.85
1
Day Time Count Av. Duration
Apr 15 9am 1 3.85
4ms
SELECT#011 s.id as id,#011 s.name as name,#011 s.description as description,#011 s.info as info,#011 s.created as registered,#011 s.running_kernel as runningKernel,#011 sl.machine as machine,#011 sl.rack as rack,#011 sl.room as room,#011 sl.building as building,#011 sl.address1 as address1,#011 sl.address2 as address2,#011 sl.city as city,#011 sl.state as state,#011 sl.country as country,#011 rsn.hostname as hostname,#011 rsn.ipaddr as ipaddr,#011 rsn.ip6addr as ip6addr,#011 dmi.vendor as dmiVendor,#011 dmi.system as dmiSystem,#011 dmi.product as dmiProduct,#011 dmi.bios_vendor as dmiBiosVendor,#011 dmi.bios_version as dmiBiosVersion,#011 dmi.bios_release as dmiBiosRelease,#011 dmi.asset as dmiAsset,#011 dmi.board as dmiBoard,#011 cpu.bogomips as cpuBogoMIPS,#011 cpu.cache as cpuCache,#011 cpu.family as cpuFamily,#011 cpu.mhz as cpuMHz,#011 cpu.stepping as cpuStepping,#011 cpu.flags as cpuFlags,#011 cpu.model as cpuModel,#011 cpu.version as cpuVersion,#011 cpu.vendor as cpuVendor,#011 cpu.nrcpu as cpuNumberOfCpus,#011 cpu.acpiversion as cpuAcpiVersion,#011 cpu.apic as cpuApic,#011 cpu.apmversion as cpuApmVersion,#011 cpu.chipset as cpuChipset,#011 si.checkin as checkin,#011 rr.ram as ram,#011 rr.swap as swap,#011 vi.uuid as uuid#011 FROM rhnServer s#011 LEFT OUTER JOIN rhnServerNetwork rsn ON s.id = rsn.server_id#011 LEFT OUTER JOIN rhnServerInfo si on s.id = si.server_id#011 LEFT OUTER JOIN rhnRam rr on s.id = rr.server_id#011 LEFT OUTER JOIN rhnServerLocation sl ON s.id = sl.server_id#011 LEFT OUTER JOIN rhnServerDmi dmi ON s.id = dmi.server_id#011 LEFT OUTER JOIN rhnCPU cpu on s.id = cpu.server_id#011 LEFT OUTER JOIN rhnVirtualInstance vi on s.id = vi.virtual_system_id#011 WHERE s.modified >= '2014-04-10 17:04:11.848+02'#011 or rsn.modified >= '2014-04-10 17:04:11.848+02'#011 or si.checkin >= '2014-04-10 17:04:11.848+02'#011 or rr.modified >= '2014-04-10 17:04:11.848+02'#011 or sl.modified >= '2014-04-10 17:04:11.848+02'#011 or dmi.modified >= '2014-04-10 17:04:11.848+02'#011 or cpu.modified >= '2014-04-10 17:04:11.848+02'#011 or s.id > 1000010433#011 ORDER by s.id ASC;
6 3.29
2
Day Time Count Av. Duration
Apr 15 9am 2 3.29
7ms
SELECT CF.id,#0#0 CF.latest_config_revision_id,#0 CFN.path,#0 CR.revision AS latest_config_revision,#0 coalesce(CCon.modified, CR.modified) as modified,#0#0 CFT.label as type#0 FROM rhnConfigFileName CFN,#0 rhnConfigFile CF,#0 rhnConfigRevision CR LEFT OUTER JOIN rhnConfigContent CCon#0 ON CR.config_content_id = CCon.id,#0#0 rhnSet ST,#0#0 rhnConfigFileType CFT#0 WHERE rhn_config_channel.get_user_chan_access(0, 0) = 0#0 AND ST.user_id = 0#0 AND ST.label = ''#0 AND ST.element = CF.id#0 AND CF.config_channel_id = 0#0 AND CFN.id = CF.config_file_name_id#0 AND CR.config_file_id = CF.id#0 AND CF.latest_config_revision_id = CR.id#0 AND CFT.id = CR.config_file_type_id#0ORDER BY CFN.path;
7 2.17
1
Day Time Count Av. Duration
Apr 15 9am 1 2.17
2ms
SELECT CF.id,#011#011 CF.latest_config_revision_id,#011 CFN.path,#011#011 CR.revision AS latest_config_revision,#011 coalesce(CCon.modified, CR.modified) as modified,#011 CFT.label as type#011 FROM rhnConfigFileName CFN,#011 rhnConfigFile CF,#011 rhnConfigRevision CR LEFT OUTER JOIN rhnConfigContent CCon#011 ON CR.config_content_id = CCon.id,#011 rhnConfigFileType CFT#011 WHERE rhn_config_channel.get_user_chan_access(1, 3) = 1#011 AND CF.config_channel_id = 1#011 AND CFN.id = CF.config_file_name_id#011 AND CR.config_file_id = CF.id#011 AND CF.latest_config_revision_id = CR.id#011 AND CR.config_file_type_id = CFT.id#011ORDER BY CFN.path;
8 1.54
32
Day Time Count Av. Duration
Apr 15 9am 32 1.54
49ms
#0 select a.id, sa.server_id, pc.jabber_id,#0 date_diff_in_days(current_timestamp, earliest_action) * 0 delta#0 from#0 rhnServerAction sa,#0 rhnAction a,#0 rhnPushClient pc#0 where pc.server_id = sa.server_id#0 and sa.action_id = a.id#0 and sa.status in (...) -- Queued or picked up#0 and not exists (#0 -- This is like saying 'this action has no#0 -- prerequisite or has a prerequisite that has completed#0 -- (status = 0)#0 select 0#0 from rhnServerAction sap#0 where sap.server_id = sa.server_id#0 and sap.action_id = a.prerequisite#0 and sap.status != 0#0 )#0 order by earliest_action#0;
9 1.22
4
Day Time Count Av. Duration
Apr 15 9am 4 1.22
5ms
select * from rhn_synch_probe_state() as result;
10 0.61
8
Day Time Count Av. Duration
Apr 15 9am 8 0.61
5ms
select * from rhn_config_channel.get_user_chan_access('',0, 0) as result;
11 0.51
20
Day Time Count Av. Duration
Apr 15 9am 20 0.51
10ms
insert into rhnTaskoRun (org_id, template_id, schedule_id, start_time, end_time, std_output_path, std_error_path, status, id) values (NULL, 0, 0, NULL, NULL, NULL, NULL, '', 0);
12 0.36
214
Day Time Count Av. Duration
Apr 15 9am 214 0.36
77ms
COMMIT;
13 0.25
19
Day Time Count Av. Duration
Apr 15 9am 19 0.25
5ms
INSERT INTO QRTZ_FIRED_TRIGGERS (ENTRY_ID, TRIGGER_NAME, TRIGGER_GROUP, IS_VOLATILE, INSTANCE_NAME, FIRED_TIME, STATE, JOB_NAME, JOB_GROUP, IS_STATEFUL, REQUESTS_RECOVERY, PRIORITY) VALUES('', '', '', '', '', 0, '', NULL, NULL, '', '', 0);
14 0.24
6
Day Time Count Av. Duration
Apr 15 9am 6 0.24
1ms
select * from logging.set_log_auth(0) as result;
15 0.24
19
Day Time Count Av. Duration
Apr 15 9am 19 0.24
4ms
UPDATE QRTZ_TRIGGERS SET TRIGGER_STATE = '' WHERE TRIGGER_NAME = '' AND TRIGGER_GROUP = '' AND TRIGGER_STATE = '';
16 0.23
32
Day Time Count Av. Duration
Apr 15 9am 32 0.23
8ms
#0 update rhnPushClient#0 set state_id = 0#0 where state_id = 0#0 and last_ping_time is not null#0 and current_timestamp > next_action_time#0;
17 0.21
19
Day Time Count Av. Duration
Apr 15 9am 19 0.21
4ms
INSERT INTO QRTZ_FIRED_TRIGGERS (ENTRY_ID, TRIGGER_NAME, TRIGGER_GROUP, IS_VOLATILE, INSTANCE_NAME, FIRED_TIME, STATE, JOB_NAME, JOB_GROUP, IS_STATEFUL, REQUESTS_RECOVERY, PRIORITY) VALUES('', '', '', '', '', 0, '', '', '', '', '', 0);
18 0.20
7
Day Time Count Av. Duration
Apr 15 9am 7 0.20
1ms
select userimpl0_.id as id20_5_, userimpl0_.login as login20_5_, userimpl0_.login_uc as login3_20_5_, userimpl0_.password as password20_5_, userimpl0_.created as created20_5_, userimpl0_.modified as modified20_5_, userimpl0_.org_id as org7_20_5_, personalin1_.web_user_id as web1_20_0_, personalin1_.prefix as prefix20_0_, personalin1_.first_names as first3_20_0_, personalin1_.last_name as last4_20_0_, personalin1_.company as company20_0_, personalin1_.title as title20_0_, personalin1_.phone as phone20_0_, personalin1_.fax as fax20_0_, personalin1_.email as email20_0_, personalin1_.created as created20_0_, personalin1_.modified as modified20_0_, org2_.id as id10_1_, org2_.name as name10_1_, org2_.created as created10_1_, org2_.modified as modified10_1_, org2_1_.reg_token_id as reg2_10_1_, orgconfig3_.org_id as org1_10_2_, orgconfig3_.staging_content_enabled as staging2_10_2_, orgconfig3_.crash_reporting_enabled as crash3_10_2_, orgconfig3_.crashfile_upload_enabled as crashfile4_10_2_, orgconfig3_.crash_file_sizelimit as crash5_10_2_, orgconfig3_.scapfile_upload_enabled as scapfile6_10_2_, orgconfig3_.scap_file_sizelimit as scap7_10_2_, orgconfig3_.scap_retention_period_days as scap8_10_2_, entitlemen4_.org_id as org1_7_, orgentitle5_.id as entitlem2_7_, orgentitle5_.id as id10_3_, orgentitle5_.label as label10_3_, orgentitle5_.name as name10_3_, orgentitle5_.created as created10_3_, orgentitle5_.modified as modified10_3_, trustedorg6_.org_id as org1_8_, org7_.id as org2_8_, org7_.id as id10_4_, org7_.name as name10_4_, org7_.created as created10_4_, org7_.modified as modified10_4_, org7_1_.reg_token_id as reg2_10_4_ from WEB_CONTACT userimpl0_ inner join WEB_USER_PERSONAL_INFO personalin1_ on userimpl0_.id=personalin1_.web_user_id inner join WEB_CUSTOMER org2_ on userimpl0_.org_id=org2_.id left outer join rhnRegTokenOrgDefault org2_1_ on org2_.id=org2_1_.org_id left outer join rhnOrgConfiguration orgconfig3_ on org2_.id=orgconfig3_.org_id left outer join rhnOrgEntitlements entitlemen4_ on org2_.id=entitlemen4_.org_id left outer join RHNORGENTITLEMENTTYPE orgentitle5_ on entitlemen4_.entitlement_id=orgentitle5_.id left outer join rhnTrustedOrgs trustedorg6_ on org2_.id=trustedorg6_.org_id left outer join WEB_CUSTOMER org7_ on trustedorg6_.org_trust_id=org7_.id left outer join rhnRegTokenOrgDefault org7_1_ on org7_.id=org7_1_.org_id where userimpl0_.id=0;
19 0.20
19
Day Time Count Av. Duration
Apr 15 9am 19 0.20
4ms
UPDATE QRTZ_TRIGGERS SET JOB_NAME = '', JOB_GROUP = '', IS_VOLATILE = '', DESCRIPTION = NULL, NEXT_FIRE_TIME = 0, PREV_FIRE_TIME = 0, TRIGGER_STATE = '', TRIGGER_TYPE = '', START_TIME = 0, END_TIME = 0, CALENDAR_NAME = NULL, MISFIRE_INSTR = 0, PRIORITY = 0 WHERE TRIGGER_NAME = '' AND TRIGGER_GROUP = '';
20 0.17
14
Day Time Count Av. Duration
Apr 15 9am 14 0.17
2ms
INSERT#0 INTO rhnSet (user_id, label, element)#0 VALUES (0, '', 0);
Report generated by pgFouine 1.2. pgFouine is free software.
Table of contents