Spacewalk 2.1 Cfg Deploy 400 Systems ProxyTimeout 600

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 1,950 48.5
INSERT 633 15.7
UPDATE 221 5.5
DELETE 136 3.4

Queries that took up the most time (N) ^

Rank Total duration Times executed Av. duration (ms) Query
1 142.6s
74
Day Time Count Av. Duration
Apr 15 9am 74 1.93
1.93
#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;
2 133.8s
491
Day Time Count Av. Duration
Apr 15 9am 491 0.27
0.27
COMMIT;
3 72ms
297
Day Time Count Av. Duration
Apr 15 9am 297 0.24
0.24
select * from rhn_config_channel.get_user_revision_access('',0, 0) as result;
4 53ms
417
Day Time Count Av. Duration
Apr 15 9am 417 0.13
0.13
insert into rhnActionConfigRevision (action_id, failure_id, created, modified, server_id, config_revision_id, id) values (0, NULL, '', '', 0, 0, 0);
5 42ms
1
Day Time Count Av. Duration
Apr 15 9am 1 41.60
41.60
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;
6 40ms
1
Day Time Count Av. Duration
Apr 15 9am 1 40.18
40.18
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;
7 26ms
2
Day Time Count Av. Duration
Apr 15 9am 2 12.95
12.95
SELECT id from rhnDevice;
8 19ms
43
Day Time Count Av. Duration
Apr 15 9am 43 0.43
0.43
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);
9 17ms
74
Day Time Count Av. Duration
Apr 15 9am 74 0.24
0.24
#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;
10 14ms
9
Day Time Count Av. Duration
Apr 15 9am 9 1.57
1.57
select * from rhn_synch_probe_state() as result;
11 10ms
45
Day Time Count Av. Duration
Apr 15 9am 45 0.22
0.22
UPDATE QRTZ_TRIGGERS SET TRIGGER_STATE = '' WHERE TRIGGER_NAME = '' AND TRIGGER_GROUP = '' AND TRIGGER_STATE = '';
12 9ms
45
Day Time Count Av. Duration
Apr 15 9am 45 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, '', NULL, NULL, '', '', 0);
13 9ms
74
Day Time Count Av. Duration
Apr 15 9am 74 0.12
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;
14 8ms
1
Day Time Count Av. Duration
Apr 15 9am 1 8.26
8.26
SELECT#011 s.id as id,#011 s.name as name,#011 s.description as description,;
15 8ms
43
Day Time Count Av. Duration
Apr 15 9am 43 0.19
0.19
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 = '';
16 8ms
43
Day Time Count Av. Duration
Apr 15 9am 43 0.19
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);
17 8ms
34
Day Time Count Av. Duration
Apr 15 9am 34 0.23
0.23
insert into rhnAction (name, earliest_action, version, archived, prerequisite, scheduler, action_type, org_id, id) values ('', '', 0, 0, NULL, 0, 0, 0, 0);
18 6ms
34
Day Time Count Av. Duration
Apr 15 9am 34 0.18
0.18
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);
19 5ms
475
Day Time Count Av. Duration
Apr 15 9am 475 0.01
0.01
select nextval ('');
20 5ms
9
Day Time Count Av. Duration
Apr 15 9am 9 0.58
0.58
select * from logging.clear_log_id() as result;

Slowest queries ^

Rank Duration (ms) Query
1 41.60
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;
2 40.18
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 14.28
SELECT id from rhnDevice;
4 11.63
SELECT id from rhnDevice;
5 8.26
SELECT#011 s.id as id,#011 s.name as name,#011 s.description as description,;
6 7.48
insert into rhnTaskoRun (org_id, template_id, schedule_id, start_time, end_time, std_output_path, std_error_path, status, id) values (NULL, 15, 4, NULL, NULL, NULL, NULL, 'READY', 938169);
7 4.97
COMMIT;
8 4.67
select * from logging.clear_log_id() as result;
9 4.32
select * from rhn_synch_probe_state() as result;
10 4.08
#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;
11 3.88
COMMIT;
12 3.87
select * from rhn_synch_probe_state() as result;
13 3.23
#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;
14 3.14
COMMIT;
15 3.08
select this_.id as id108_5_, this_.org_id as org3_108_5_, this_.label as label108_5_, this_.ks_type as ks2_108_5_, this_.comments as comments108_5_, this_.active as active108_5_, this_.postLog as postLog108_5_, this_.preLog as preLog108_5_, this_.kscfg as kscfg108_5_, this_.created as created108_5_, this_.modified as modified108_5_, this_.is_org_default as is12_108_5_, this_.kernel_params as kernel13_108_5_, this_.nonchrootpost as nonchro14_108_5_, this_.no_base as no15_108_5_, this_.ignore_missing as ignore16_108_5_, this_.verboseup2date as verboseup17_108_5_, this_.partition_data as partition18_108_5_, this_.cobbler_id as cobbler19_108_5_, this_.update_type as update20_108_5_, org2_.id as id159_0_, org2_.name as name159_0_, org2_.created as created159_0_, org2_.modified as modified159_0_, org2_1_.reg_token_id as reg2_162_0_, orgconfig3_.org_id as org1_163_1_, orgconfig3_.staging_content_enabled as staging2_163_1_, orgconfig3_.crash_reporting_enabled as crash3_163_1_, orgconfig3_.crashfile_upload_enabled as crashfile4_163_1_, orgconfig3_.crash_file_sizelimit as crash5_163_1_, orgconfig3_.scapfile_upload_enabled as scapfile6_163_1_, orgconfig3_.scap_file_sizelimit as scap7_163_1_, orgconfig3_.scap_retention_period_days as scap8_163_1_, entitlemen4_.org_id as org1_7_, orgentitle5_.id as entitlem2_7_, orgentitle5_.id as id164_2_, orgentitle5_.label as label164_2_, orgentitle5_.name as name164_2_, orgentitle5_.created as created164_2_, orgentitle5_.modified as modified164_2_, trustedorg6_.org_id as org1_8_, org7_.id as org2_8_, org7_.id as id159_3_, org7_.name as name159_3_, org7_.created as created159_3_, org7_.modified as modified159_3_, org7_1_.reg_token_id as reg2_162_3_, kickstartd8_.kickstart_id as kickstart1_114_4_, kickstartd8_.kstree_id as kstree2_114_4_, kickstartd8_.server_profile_id as server3_114_4_, kickstartd8_.virtualization_type as virtuali4_114_4_, kickstartd8_.cfg_management_flag as cfg5_114_4_, kickstartd8_.remote_command_flag as remote6_114_4_, kickstartd8_.created as created114_4_, kickstartd8_.modified as modified114_4_ from RHNKSDATA this_ inner join WEB_CUSTOMER org2_ on this_.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 left outer join rhnkickstartdefaults kickstartd8_ on this_.id=kickstartd8_.kickstart_id;
16 3.03
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;
17 3.02
#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;
18 2.93
#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;
19 2.79
COMMIT;
20 2.69
COMMIT;

Most frequent queries (N) ^

Rank Times executed Total duration Av. duration (ms) Query
1
491
Day Time Count Av. Duration
Apr 15 9am 491 0.27
133.8s 0.27
COMMIT;
2
475
Day Time Count Av. Duration
Apr 15 9am 475 0.01
5ms 0.01
select nextval ('');
3
417
Day Time Count Av. Duration
Apr 15 9am 417 0.13
53ms 0.13
insert into rhnActionConfigRevision (action_id, failure_id, created, modified, server_id, config_revision_id, id) values (0, NULL, '', '', 0, 0, 0);
4
357
Day Time Count Av. Duration
Apr 15 9am 357 0.01
2ms 0.01
BEGIN;
5
297
Day Time Count Av. Duration
Apr 15 9am 297 0.24
72ms 0.24
select * from rhn_config_channel.get_user_revision_access('',0, 0) as result;
6
213
Day Time Count Av. Duration
Apr 15 9am 213 0.01
3ms 0.01
select '' from dual;
7
86
Day Time Count Av. Duration
Apr 15 9am 86 0.05
4ms 0.05
DELETE FROM QRTZ_FIRED_TRIGGERS WHERE ENTRY_ID = '';
8
74
Day Time Count Av. Duration
Apr 15 9am 74 1.93
142.6s 1.93
#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
74
Day Time Count Av. Duration
Apr 15 9am 74 0.24
17ms 0.24
#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;
10
74
Day Time Count Av. Duration
Apr 15 9am 74 0.12
9ms 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;
11
64
Day Time Count Av. Duration
Apr 15 9am 64 0.05
3ms 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;
12
54
Day Time Count Av. Duration
Apr 15 9am 54 0.08
5ms 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;
13
45
Day Time Count Av. Duration
Apr 15 9am 45 0.22
10ms 0.22
UPDATE QRTZ_TRIGGERS SET TRIGGER_STATE = '' WHERE TRIGGER_NAME = '' AND TRIGGER_GROUP = '' AND TRIGGER_STATE = '';
14
45
Day Time Count Av. Duration
Apr 15 9am 45 0.21
9ms 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, '', NULL, NULL, '', '', 0);
15
45
Day Time Count Av. Duration
Apr 15 9am 45 0.03
1ms 0.03
SELECT * FROM QRTZ_TRIGGERS WHERE TRIGGER_NAME = '' AND TRIGGER_GROUP = '';
16
45
Day Time Count Av. Duration
Apr 15 9am 45 0.02
1ms 0.02
SELECT * FROM QRTZ_CRON_TRIGGERS WHERE TRIGGER_NAME = '' AND TRIGGER_GROUP = '';
17
45
Day Time Count Av. Duration
Apr 15 9am 45 0.01
1ms 0.01
SELECT TRIGGER_LISTENER FROM QRTZ_TRIGGER_LISTENERS WHERE TRIGGER_NAME = '' AND TRIGGER_GROUP = '';
18
44
Day Time Count Av. Duration
Apr 15 9am 44 0.03
1ms 0.03
SELECT TRIGGER_STATE FROM QRTZ_TRIGGERS WHERE TRIGGER_NAME = '' AND TRIGGER_GROUP = '';
19
43
Day Time Count Av. Duration
Apr 15 9am 43 0.43
19ms 0.43
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);
20
43
Day Time Count Av. Duration
Apr 15 9am 43 0.19
8ms 0.19
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
1 41.60
1
Day Time Count Av. Duration
Apr 15 9am 1 41.60
42ms
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;
2 40.18
1
Day Time Count Av. Duration
Apr 15 9am 1 40.18
40ms
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 12.95
2
Day Time Count Av. Duration
Apr 15 9am 2 12.95
26ms
SELECT id from rhnDevice;
4 8.26
1
Day Time Count Av. Duration
Apr 15 9am 1 8.26
8ms
SELECT#011 s.id as id,#011 s.name as name,#011 s.description as description,;
5 3.08
1
Day Time Count Av. Duration
Apr 15 9am 1 3.08
3ms
select this_.id as id108_5_, this_.org_id as org3_108_5_, this_.label as label108_5_, this_.ks_type as ks2_108_5_, this_.comments as comments108_5_, this_.active as active108_5_, this_.postLog as postLog108_5_, this_.preLog as preLog108_5_, this_.kscfg as kscfg108_5_, this_.created as created108_5_, this_.modified as modified108_5_, this_.is_org_default as is12_108_5_, this_.kernel_params as kernel13_108_5_, this_.nonchrootpost as nonchro14_108_5_, this_.no_base as no15_108_5_, this_.ignore_missing as ignore16_108_5_, this_.verboseup2date as verboseup17_108_5_, this_.partition_data as partition18_108_5_, this_.cobbler_id as cobbler19_108_5_, this_.update_type as update20_108_5_, org2_.id as id159_0_, org2_.name as name159_0_, org2_.created as created159_0_, org2_.modified as modified159_0_, org2_1_.reg_token_id as reg2_162_0_, orgconfig3_.org_id as org1_163_1_, orgconfig3_.staging_content_enabled as staging2_163_1_, orgconfig3_.crash_reporting_enabled as crash3_163_1_, orgconfig3_.crashfile_upload_enabled as crashfile4_163_1_, orgconfig3_.crash_file_sizelimit as crash5_163_1_, orgconfig3_.scapfile_upload_enabled as scapfile6_163_1_, orgconfig3_.scap_file_sizelimit as scap7_163_1_, orgconfig3_.scap_retention_period_days as scap8_163_1_, entitlemen4_.org_id as org1_7_, orgentitle5_.id as entitlem2_7_, orgentitle5_.id as id164_2_, orgentitle5_.label as label164_2_, orgentitle5_.name as name164_2_, orgentitle5_.created as created164_2_, orgentitle5_.modified as modified164_2_, trustedorg6_.org_id as org1_8_, org7_.id as org2_8_, org7_.id as id159_3_, org7_.name as name159_3_, org7_.created as created159_3_, org7_.modified as modified159_3_, org7_1_.reg_token_id as reg2_162_3_, kickstartd8_.kickstart_id as kickstart1_114_4_, kickstartd8_.kstree_id as kstree2_114_4_, kickstartd8_.server_profile_id as server3_114_4_, kickstartd8_.virtualization_type as virtuali4_114_4_, kickstartd8_.cfg_management_flag as cfg5_114_4_, kickstartd8_.remote_command_flag as remote6_114_4_, kickstartd8_.created as created114_4_, kickstartd8_.modified as modified114_4_ from RHNKSDATA this_ inner join WEB_CUSTOMER org2_ on this_.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 left outer join rhnkickstartdefaults kickstartd8_ on this_.id=kickstartd8_.kickstart_id;
6 2.54
2
Day Time Count Av. Duration
Apr 15 9am 2 2.54
5ms
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 1.93
74
Day Time Count Av. Duration
Apr 15 9am 74 1.93
142.6s
#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;
8 1.57
9
Day Time Count Av. Duration
Apr 15 9am 9 1.57
14ms
select * from rhn_synch_probe_state() as result;
9 1.51
1
Day Time Count Av. Duration
Apr 15 9am 1 1.51
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;
10 0.69
1
Day Time Count Av. Duration
Apr 15 9am 1 0.69
1ms
select * from pxt_session_cleanup(1397540700, 100, 50000, '') as result;
11 0.60
7
Day Time Count Av. Duration
Apr 15 9am 7 0.60
4ms
select * from rhn_config_channel.get_user_chan_access('',0, 0) as result;
12 0.58
9
Day Time Count Av. Duration
Apr 15 9am 9 0.58
5ms
select * from logging.clear_log_id() as result;
13 0.43
43
Day Time Count Av. Duration
Apr 15 9am 43 0.43
19ms
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);
14 0.30
1
Day Time Count Av. Duration
Apr 15 9am 1 0.30
0ms
SELECT id from rhnServer;
15 0.27
491
Day Time Count Av. Duration
Apr 15 9am 491 0.27
133.8s
COMMIT;
16 0.24
297
Day Time Count Av. Duration
Apr 15 9am 297 0.24
72ms
select * from rhn_config_channel.get_user_revision_access('',0, 0) as result;
17 0.24
74
Day Time Count Av. Duration
Apr 15 9am 74 0.24
17ms
#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;
18 0.23
34
Day Time Count Av. Duration
Apr 15 9am 34 0.23
8ms
insert into rhnAction (name, earliest_action, version, archived, prerequisite, scheduler, action_type, org_id, id) values ('', '', 0, 0, NULL, 0, 0, 0, 0);
19 0.23
1
Day Time Count Av. Duration
Apr 15 9am 1 0.23
0ms
select * from rhn_config_channel.get_user_revision_access($1,$2, $3) as result;
20 0.22
45
Day Time Count Av. Duration
Apr 15 9am 45 0.22
10ms
UPDATE QRTZ_TRIGGERS SET TRIGGER_STATE = '' WHERE TRIGGER_NAME = '' AND TRIGGER_GROUP = '' AND TRIGGER_STATE = '';
Report generated by pgFouine 1.2. pgFouine is free software.
Table of contents