Spacewalk 2.1 Cfg Deploy 300 Systems

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

Generated on 2014-04-15 10:00
Parsed /home/stephand/i/dass/work/redhat/spacewalk/cfg_depl_ISE/spacewalk21_cfg_depl_ISE_300sys_pgsql.log (13,457 lines) in 1,000s
Log from 2014-04-15 09:23:19 to 2014-04-15 09:28:26
Executed on t420.fw.b4.mad

Overall statistics ^

Number of unique normalized queries: 100
Number of queries: 2,172
Total query duration: 514.0s
First query: 2014-04-15 09:23:19
Last query: 2014-04-15 09:28:26
Query peak: 168 queries/s at 2014-04-15 09:24:00

Queries by type ^

Type	Count	Percentage
SELECT	1,089	50.1
INSERT	379	17.4
UPDATE	106	4.9
DELETE	65	3.0

Queries that took up the most time (N) ^

Rank

Total duration

Times executed

Av. duration (ms)

Query

117.3s

39.10

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;

77ms

240

0.32

COMMIT;

58ms

1.52

#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;

45ms

181

0.25

select * from rhn_config_channel.get_user_revision_access('',0, 0) as result;

35ms

271

0.13

insert into rhnActionConfigRevision (action_id, failure_id, created, modified, server_id, config_revision_id, id) values (0, NULL, '', '', 0, 0, 0);

31ms

31.29

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;

31ms

30.61

SELECT id from rhnDevice;

11ms

5.55

SELECT S.ID,#0 COALESCE((#0#0#0#0#0SELECT COUNT(DISTINCT CFN2.id)#0#0#0#0#0FROM rhnConfigChannel CC2, rhnConfigChannelType CCT2, rhnServerConfigChannel SCC2,#0#0#0#0#0#0 rhnConfigFile cf2, rhnConfigFileName cfn2,#0#0#0#0#0#0 rhnConfigChannel CC, rhnServerConfigChannel SCC,#0#0#0#0#0#0 rhnConfigFile cf, rhnConfigFileName cfn#0#0#0#0#0WHERE SCC2.server_id = S.ID#0#0#0#0#0 AND scc.server_id = S.ID#0#0#0#0#0 AND cc.id = $1;

8ms

0.22

#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;

8ms

1.54

select * from rhn_synch_probe_state() as result;

6ms

3.24

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;

6ms

0.32

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);

6ms

0.54

select * from rhn_config_channel.get_user_chan_access('',0, 0) as result;

5ms

0.61

select * from logging.clear_log_id() as result;

5ms

0.22

insert into rhnAction (name, earliest_action, version, archived, prerequisite, scheduler, action_type, org_id, id) values ('', '', 0, 0, NULL, 0, 0, 0, 0);

4ms

0.12

#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;

4ms

0.21

UPDATE QRTZ_TRIGGERS SET TRIGGER_STATE = '' WHERE TRIGGER_NAME = '' AND TRIGGER_GROUP = '' AND TRIGGER_STATE = '';

4ms

3.88

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,;

4ms

0.19

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);

4ms

0.17

insert into rhnServerAction (result_code, result_msg, pickup_time, completion_time, remaining_tries, status, server_id, action_id) values (NULL, NULL, NULL, NULL, 0, 0, 0, 0);

Slowest queries ^

Rank	Duration (ms)	Query
1	40.88	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	38.50	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	37.90	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;
4	31.29	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	30.61	SELECT id from rhnDevice;
6	5.74	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;
7	5.36	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;
8	5.17	COMMIT;
9	4.41	COMMIT;
10	4.34	select * from logging.clear_log_id() as result;
11	3.88	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,;
12	3.86	COMMIT;
13	3.81	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;
14	3.74	select * from rhn_synch_probe_state() as result;
15	3.73	COMMIT;
16	3.53	select * from rhn_synch_probe_state() as result;
17	2.81	COMMIT;
18	2.70	COMMIT;
19	2.67	select * from rhn_config_channel.get_user_chan_access('',1, 3) as result;
20	2.67	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;

Most frequent queries (N) ^

Rank

Times executed

Total duration

Av. duration (ms)

Query

306

3ms

0.01

select nextval ('');

271

35ms

0.13

insert into rhnActionConfigRevision (action_id, failure_id, created, modified, server_id, config_revision_id, id) values (0, NULL, '', '', 0, 0, 0);

240

77ms

0.32

COMMIT;

181

45ms

0.25

select * from rhn_config_channel.get_user_revision_access('',0, 0) as result;

172

1ms

0.01

BEGIN;

103

2ms

0.01

select '' from dual;

2ms

0.05

DELETE FROM QRTZ_FIRED_TRIGGERS WHERE ENTRY_ID = '';

58ms

1.52

8ms

0.22

#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;

4ms

0.12

#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;

1ms

0.05

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;

2ms

0.08

SELECT COALESCE( ( SELECT CR.id#0 FROM rhnConfigChannel CC, rhnConfigChannelType CCT,#0 rhnConfigRevision CR, rhnServerConfigChannel SCC, rhnConfigFile CF#0 WHERE SCC.server_id = 0#0 AND CF.config_channel_id = SCC.config_channel_id#0 AND CF.config_file_name_id = 0#0 AND SCC.config_channel_id = CC.id#0 AND CC.confchan_type_id = CCT.id#0 AND CCT.label = ''#0 AND CF.latest_config_revision_id = CR.id) ,#0 ( SELECT CR.id#0 FROM rhnConfigRevision CR, rhnServerConfigChannel SCC, rhnConfigFile CF#0 WHERE CF.latest_config_revision_id = CR.id#0 AND CF.config_file_name_id = 0#0 AND CF.config_channel_id = SCC.config_channel_id#0 AND SCC.server_id = 0#0 AND SCC.position = ( SELECT min(SCC.position)#0 FROM rhnServerConfigChannel SCC, rhnConfigFile CF#0 WHERE SCC.server_id = 0#0 AND CF.config_channel_id = SCC.config_channel_id#0 AND CF.config_file_name_id = 0 ) ) ) AS id#0 FROM dual;

0.11s | SELECT COALESCE( ( SELECT CR.id#011 FROM rhnConfigChannel CC, rhnConfigChannelType CCT,#011 rhnConfigRevision CR, rhnServerConfigChannel SCC, rhnConfigFile CF#011 WHERE SCC.server_id = 1000010142#011 AND CF.config_channel_id = SCC.config_channel_id#011 AND CF.config_file_name_id = 14#011 AND SCC.config_channel_id = CC.id#011 AND CC.confchan_type_id = CCT.id#011 AND CCT.label = 'local_override'#011 AND CF.latest_config_revision_id = CR.id) ,#011 ( SELECT CR.id#011 FROM rhnConfigRevision CR, rhnServerConfigChannel SCC, rhnConfigFile CF#011 WHERE CF.latest_config_revision_id = CR.id#011 AND CF.config_file_name_id = 14#011 AND CF.config_channel_id = SCC.config_channel_id#011 AND SCC.server_id = 1000010142#011 AND SCC.position = ( SELECT min(SCC.position)#011 FROM rhnServerConfigChannel SCC, rhnConfigFile CF#011 WHERE SCC.server_id = 1000010142#011 AND CF.config_channel_id = SCC.config_channel_id#011 AND CF.config_file_name_id = 14 ) ) ) AS id#011 FROM dual;

0.09s | SELECT COALESCE( ( SELECT CR.id#011 FROM rhnConfigChannel CC, rhnConfigChannelType CCT,#011 rhnConfigRevision CR, rhnServerConfigChannel SCC, rhnConfigFile CF#011 WHERE SCC.server_id = 1000010198#011 AND CF.config_channel_id = SCC.config_channel_id#011 AND CF.config_file_name_id = 15#011 AND SCC.config_channel_id = CC.id#011 AND CC.confchan_type_id = CCT.id#011 AND CCT.label = 'local_override'#011 AND CF.latest_config_revision_id = CR.id) ,#011 ( SELECT CR.id#011 FROM rhnConfigRevision CR, rhnServerConfigChannel SCC, rhnConfigFile CF#011 WHERE CF.latest_config_revision_id = CR.id#011 AND CF.config_file_name_id = 15#011 AND CF.config_channel_id = SCC.config_channel_id#011 AND SCC.server_id = 1000010198#011 AND SCC.position = ( SELECT min(SCC.position)#011 FROM rhnServerConfigChannel SCC, rhnConfigFile CF#011 WHERE SCC.server_id = 1000010198#011 AND CF.config_channel_id = SCC.config_channel_id#011 AND CF.config_file_name_id = 15 ) ) ) AS id#011 FROM dual;

0.08s | SELECT COALESCE( ( SELECT CR.id#011 FROM rhnConfigChannel CC, rhnConfigChannelType CCT,#011 rhnConfigRevision CR, rhnServerConfigChannel SCC, rhnConfigFile CF#011 WHERE SCC.server_id = 1000010142#011 AND CF.config_channel_id = SCC.config_channel_id#011 AND CF.config_file_name_id = 13#011 AND SCC.config_channel_id = CC.id#011 AND CC.confchan_type_id = CCT.id#011 AND CCT.label = 'local_override'#011 AND CF.latest_config_revision_id = CR.id) ,#011 ( SELECT CR.id#011 FROM rhnConfigRevision CR, rhnServerConfigChannel SCC, rhnConfigFile CF#011 WHERE CF.latest_config_revision_id = CR.id#011 AND CF.config_file_name_id = 13#011 AND CF.config_channel_id = SCC.config_channel_id#011 AND SCC.server_id = 1000010142#011 AND SCC.position = ( SELECT min(SCC.position)#011 FROM rhnServerConfigChannel SCC, rhnConfigFile CF#011 WHERE SCC.server_id = 1000010142#011 AND CF.config_channel_id = SCC.config_channel_id#011 AND CF.config_file_name_id = 13 ) ) ) AS id#011 FROM dual;

5ms

0.22

insert into rhnAction (name, earliest_action, version, archived, prerequisite, scheduler, action_type, org_id, id) values ('', '', 0, 0, NULL, 0, 0, 0, 0);

4ms

0.17

insert into rhnServerAction (result_code, result_msg, pickup_time, completion_time, remaining_tries, status, server_id, action_id) values (NULL, NULL, NULL, NULL, 0, 0, 0, 0);

0ms

0.01

select serveracti_.server_id, serveracti_.action_id, serveracti_.result_code as result3_30_, serveracti_.result_msg as result4_30_, serveracti_.pickup_time as pickup5_30_, serveracti_.completion_time as completion6_30_, serveracti_.remaining_tries as remaining9_30_, serveracti_.status as status30_ from rhnServerAction serveracti_ where serveracti_.server_id=0 and serveracti_.action_id=0;

6ms

0.32

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);

4ms

0.21

UPDATE QRTZ_TRIGGERS SET TRIGGER_STATE = '' WHERE TRIGGER_NAME = '' AND TRIGGER_GROUP = '' AND TRIGGER_STATE = '';

4ms

0.19

4ms

0.19

4ms

0.18

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 = '';

Slowest queries (N) ^

Rank

Av. duration (ms)

Times executed

Total duration

Query

39.10

117.3s

31.29

31ms

30.61

31ms

SELECT id from rhnDevice;

5.55

11ms

3.88

4ms

3.24

6ms

2.01

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;

1.54

8ms

select * from rhn_synch_probe_state() as result;

1.52

58ms

0.61

5ms

select * from logging.clear_log_id() as result;

0.54

6ms

select * from rhn_config_channel.get_user_chan_access('',0, 0) as result;

0.38

0ms

INSERT#011 INTO rhnSet (user_id, label, element)#011 VALUES (3, 'config_channel_deploy_revisions', 22);

0.32

240

77ms

COMMIT;

0.32

6ms

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);

0.25

181

45ms

select * from rhn_config_channel.get_user_revision_access('',0, 0) as result;

0.22

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;

0.22

5ms

insert into rhnAction (name, earliest_action, version, archived, prerequisite, scheduler, action_type, org_id, id) values ('', '', 0, 0, NULL, 0, 0, 0, 0);

0.21

4ms

UPDATE QRTZ_TRIGGERS SET TRIGGER_STATE = '' WHERE TRIGGER_NAME = '' AND TRIGGER_GROUP = '' AND TRIGGER_STATE = '';

0.19

4ms

0.19

4ms