#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;
1.85s | #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;
1.82s | #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;
1.81s | #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;
3
37ms
1
Day
Time
Count
Av. Duration
Apr 15
9am
1
36.70
36.70
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;
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;
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;
4.09s | 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;
2.44s | 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
6ms
27
Day
Time
Count
Av. Duration
Apr 15
9am
27
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;
0.29s | #011 update rhnPushClient#011 set state_id = 2#011 where state_id = 1#011 and last_ping_time is not null#011 and current_timestamp > next_action_time#011;
0.27s | #011 update rhnPushClient#011 set state_id = 2#011 where state_id = 1#011 and last_ping_time is not null#011 and current_timestamp > next_action_time#011;
0.26s | #011 update rhnPushClient#011 set state_id = 2#011 where state_id = 1#011 and last_ping_time is not null#011 and current_timestamp > next_action_time#011;
14
4ms
27
Day
Time
Count
Av. Duration
Apr 15
9am
27
0.16
0.16
INSERT#0 INTO rhnSet (user_id, label, element)#0 VALUES (0, '', 0);
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 >= $1#011 or rsn.modified >= $2#011 or si.checkin >= $3#011 or rr.modified >= $4#011 or sl.modified >= $5#011 or dmi.modified >= $6;
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;
#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;
0.15s | #011 select id, name, shared_key, jabber_id#011 from rhnPushClient#011 where state_id = 1#011 and last_ping_time is not null#011 and next_action_time is null#011 and jabber_id is not null#011;
0.13s | #011 select id, name, shared_key, jabber_id#011 from rhnPushClient#011 where state_id = 1#011 and last_ping_time is not null#011 and next_action_time is null#011 and jabber_id is not null#011;
0.12s | #011 select id, name, shared_key, jabber_id#011 from rhnPushClient#011 where state_id = 1#011 and last_ping_time is not null#011 and next_action_time is null#011 and jabber_id is not null#011;
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
18.75
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
7.76
SELECT id from rhnDevice;
4
7.37
select*from logging.clear_log_id()as result;
5
7.34
select*from rhn_synch_probe_state()as result;
6
6.66
select*from logging.clear_log_id()as result;
7
4.65
select*from logging.clear_log_id()as result;
8
4.20
select*from logging.clear_log_id()as result;
9
4.09
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;
10
3.81
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 >= $1#011 or rsn.modified >= $2#011 or si.checkin >= $3#011 or rr.modified >= $4#011 or sl.modified >= $5#011 or dmi.modified >= $6;
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;
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
2.08
COMMIT;
18
2.02
COMMIT;
19
1.85
#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;
20
1.82
#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;
DELETEFROM QRTZ_FIRED_TRIGGERS WHERE ENTRY_ID ='';
0.11s | DELETEFROM QRTZ_FIRED_TRIGGERS WHERE ENTRY_ID ='NON_CLUSTERED1397542197501';
0.08s | DELETEFROM QRTZ_FIRED_TRIGGERS WHERE ENTRY_ID ='NON_CLUSTERED1397542197507';
0.08s | DELETEFROM QRTZ_FIRED_TRIGGERS WHERE ENTRY_ID ='NON_CLUSTERED1397542197501';
8
27
Day
Time
Count
Av. Duration
Apr 15
9am
27
1.40
38ms
1.40
#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;
1.85s | #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;
1.82s | #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;
1.81s | #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;
9
27
Day
Time
Count
Av. Duration
Apr 15
9am
27
0.23
6ms
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;
0.29s | #011 update rhnPushClient#011 set state_id = 2#011 where state_id = 1#011 and last_ping_time is not null#011 and current_timestamp > next_action_time#011;
0.27s | #011 update rhnPushClient#011 set state_id = 2#011 where state_id = 1#011 and last_ping_time is not null#011 and current_timestamp > next_action_time#011;
0.26s | #011 update rhnPushClient#011 set state_id = 2#011 where state_id = 1#011 and last_ping_time is not null#011 and current_timestamp > next_action_time#011;
10
27
Day
Time
Count
Av. Duration
Apr 15
9am
27
0.16
4ms
0.16
INSERT#0 INTO rhnSet (user_id, label, element)#0 VALUES (0, '', 0);
#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;
0.15s | #011 select id, name, shared_key, jabber_id#011 from rhnPushClient#011 where state_id = 1#011 and last_ping_time is not null#011 and next_action_time is null#011 and jabber_id is not null#011;
0.13s | #011 select id, name, shared_key, jabber_id#011 from rhnPushClient#011 where state_id = 1#011 and last_ping_time is not null#011 and next_action_time is null#011 and jabber_id is not null#011;
0.12s | #011 select id, name, shared_key, jabber_id#011 from rhnPushClient#011 where state_id = 1#011 and last_ping_time is not null#011 and next_action_time is null#011 and jabber_id is not null#011;
12
27
Day
Time
Count
Av. Duration
Apr 15
9am
27
0.06
2ms
0.06
SELECT TRIGGER_NAME, TRIGGER_GROUP, NEXT_FIRE_TIME, PRIORITY FROM QRTZ_TRIGGERS WHERE TRIGGER_STATE =''AND NEXT_FIRE_TIME <0AND(NEXT_FIRE_TIME >=0)ORDERBY NEXT_FIRE_TIME ASC, PRIORITY DESC;
0.15s | SELECT TRIGGER_NAME, TRIGGER_GROUP, NEXT_FIRE_TIME, PRIORITY FROM QRTZ_TRIGGERS WHERE TRIGGER_STATE ='WAITING'AND NEXT_FIRE_TIME <1397546544484AND(NEXT_FIRE_TIME >=1397546454484)ORDERBY NEXT_FIRE_TIME ASC, PRIORITY DESC;
0.15s | SELECT TRIGGER_NAME, TRIGGER_GROUP, NEXT_FIRE_TIME, PRIORITY FROM QRTZ_TRIGGERS WHERE TRIGGER_STATE ='WAITING'AND NEXT_FIRE_TIME <1397546358670AND(NEXT_FIRE_TIME >=1397546268670)ORDERBY NEXT_FIRE_TIME ASC, PRIORITY DESC;
0.09s | SELECT TRIGGER_NAME, TRIGGER_GROUP, NEXT_FIRE_TIME, PRIORITY FROM QRTZ_TRIGGERS WHERE TRIGGER_STATE ='WAITING'AND NEXT_FIRE_TIME <1397546370010AND(NEXT_FIRE_TIME >=1397546280011)ORDERBY NEXT_FIRE_TIME ASC, PRIORITY DESC;
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_.dataas data2_, taskosched0_.created as created2_, taskosched0_.modified as modified2_ from rhnTaskoSchedule taskosched0_ where taskosched0_.id=0;
0.07s | 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_.dataas data2_, taskosched0_.created as created2_, taskosched0_.modified as modified2_ from rhnTaskoSchedule taskosched0_ where taskosched0_.id=4;
0.05s | 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_.dataas data2_, taskosched0_.created as created2_, taskosched0_.modified as modified2_ from rhnTaskoSchedule taskosched0_ where taskosched0_.id=4;
0.04s | 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_.dataas data2_, taskosched0_.created as created2_, taskosched0_.modified as modified2_ from rhnTaskoSchedule taskosched0_ where taskosched0_.id=2;
17
20
Day
Time
Count
Av. Duration
Apr 15
9am
20
0.03
1ms
0.03
select templates0_.bunch_id as bunch2_1_, templates0_.id as id1_, templates0_.ordering as ordering1_, templates0_.id as id4_0_, templates0_.bunch_id as bunch2_4_0_, templates0_.task_id as task3_4_0_, templates0_.ordering as ordering4_0_, templates0_.start_if as start5_4_0_, templates0_.created as created4_0_, templates0_.modified as modified4_0_ from rhnTaskoTemplate templates0_ where templates0_.bunch_id=0;
0.08s | select templates0_.bunch_id as bunch2_1_, templates0_.id as id1_, templates0_.ordering as ordering1_, templates0_.id as id4_0_, templates0_.bunch_id as bunch2_4_0_, templates0_.task_id as task3_4_0_, templates0_.ordering as ordering4_0_, templates0_.start_if as start5_4_0_, templates0_.created as created4_0_, templates0_.modified as modified4_0_ from rhnTaskoTemplate templates0_ where templates0_.bunch_id=15;
0.05s | select templates0_.bunch_id as bunch2_1_, templates0_.id as id1_, templates0_.ordering as ordering1_, templates0_.id as id4_0_, templates0_.bunch_id as bunch2_4_0_, templates0_.task_id as task3_4_0_, templates0_.ordering as ordering4_0_, templates0_.start_if as start5_4_0_, templates0_.created as created4_0_, templates0_.modified as modified4_0_ from rhnTaskoTemplate templates0_ where templates0_.bunch_id=6;
0.04s | select templates0_.bunch_id as bunch2_1_, templates0_.id as id1_, templates0_.ordering as ordering1_, templates0_.id as id4_0_, templates0_.bunch_id as bunch2_4_0_, templates0_.task_id as task3_4_0_, templates0_.ordering as ordering4_0_, templates0_.start_if as start5_4_0_, templates0_.created as created4_0_, templates0_.modified as modified4_0_ from rhnTaskoTemplate templates0_ where templates0_.bunch_id=15;
18
20
Day
Time
Count
Av. Duration
Apr 15
9am
20
0.03
1ms
0.03
select taskobunch0_.id as id0_0_, taskobunch0_.name as name0_0_, taskobunch0_.description as descript3_0_0_, taskobunch0_.org_bunch as org4_0_0_, taskobunch0_.created as created0_0_, taskobunch0_.modified as modified0_0_ from rhnTaskoBunch taskobunch0_ where taskobunch0_.id=0;
0.08s | select taskobunch0_.id as id0_0_, taskobunch0_.name as name0_0_, taskobunch0_.description as descript3_0_0_, taskobunch0_.org_bunch as org4_0_0_, taskobunch0_.created as created0_0_, taskobunch0_.modified as modified0_0_ from rhnTaskoBunch taskobunch0_ where taskobunch0_.id=13;
0.06s | select taskobunch0_.id as id0_0_, taskobunch0_.name as name0_0_, taskobunch0_.description as descript3_0_0_, taskobunch0_.org_bunch as org4_0_0_, taskobunch0_.created as created0_0_, taskobunch0_.modified as modified0_0_ from rhnTaskoBunch taskobunch0_ where taskobunch0_.id=6;
0.06s | select taskobunch0_.id as id0_0_, taskobunch0_.name as name0_0_, taskobunch0_.description as descript3_0_0_, taskobunch0_.org_bunch as org4_0_0_, taskobunch0_.created as created0_0_, taskobunch0_.modified as modified0_0_ from rhnTaskoBunch taskobunch0_ where taskobunch0_.id=15;
19
20
Day
Time
Count
Av. Duration
Apr 15
9am
20
0.03
1ms
0.03
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;
0.08s | 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=6;
0.04s | 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=10;
0.04s | 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=7;
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
18.75
1
Day
Time
Count
Av. Duration
Apr 15
9am
1
18.75
19ms
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
7.76
1
Day
Time
Count
Av. Duration
Apr 15
9am
1
7.76
8ms
SELECT id from rhnDevice;
4
3.81
1
Day
Time
Count
Av. Duration
Apr 15
9am
1
3.81
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 >= $1#011 or rsn.modified >= $2#011 or si.checkin >= $3#011 or rr.modified >= $4#011 or sl.modified >= $5#011 or dmi.modified >= $6;
5
3.44
1
Day
Time
Count
Av. Duration
Apr 15
9am
1
3.44
3ms
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;
6
3.26
2
Day
Time
Count
Av. Duration
Apr 15
9am
2
3.26
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;
4.09s | 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;
2.44s | 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;
7
1.96
12
Day
Time
Count
Av. Duration
Apr 15
9am
12
1.96
23ms
select*from logging.clear_log_id()as result;
8
1.93
4
Day
Time
Count
Av. Duration
Apr 15
9am
4
1.93
8ms
select*from rhn_synch_probe_state()as result;
9
1.40
27
Day
Time
Count
Av. Duration
Apr 15
9am
27
1.40
38ms
#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;
1.85s | #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;
1.82s | #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;
1.81s | #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;
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_ innerjoin WEB_CUSTOMER org2_ on this_.org_id=org2_.id leftouterjoin rhnRegTokenOrgDefault org2_1_ on org2_.id=org2_1_.org_id leftouterjoin rhnOrgConfiguration orgconfig3_ on org2_.id=orgconfig3_.org_id leftouterjoin rhnOrgEntitlements entitlemen4_ on org2_.id=entitlemen4_.org_id leftouterjoin RHNORGENTITLEMENTTYPE orgentitle5_ on entitlemen4_.entitlement_id=orgentitle5_.id leftouterjoin rhnTrustedOrgs trustedorg6_ on org2_.id=trustedorg6_.org_id leftouterjoin WEB_CUSTOMER org7_ on trustedorg6_.org_trust_id=org7_.id leftouterjoin rhnRegTokenOrgDefault org7_1_ on org7_.id=org7_1_.org_id leftouterjoin rhnkickstartdefaults kickstartd8_ on this_.id=kickstartd8_.kickstart_id;
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_ innerjoin WEB_USER_PERSONAL_INFO personalin1_ on userimpl0_.id=personalin1_.web_user_id innerjoin WEB_CUSTOMER org2_ on userimpl0_.org_id=org2_.id leftouterjoin rhnRegTokenOrgDefault org2_1_ on org2_.id=org2_1_.org_id leftouterjoin rhnOrgConfiguration orgconfig3_ on org2_.id=orgconfig3_.org_id leftouterjoin rhnOrgEntitlements entitlemen4_ on org2_.id=entitlemen4_.org_id leftouterjoin RHNORGENTITLEMENTTYPE orgentitle5_ on entitlemen4_.entitlement_id=orgentitle5_.id leftouterjoin rhnTrustedOrgs trustedorg6_ on org2_.id=trustedorg6_.org_id leftouterjoin WEB_CUSTOMER org7_ on trustedorg6_.org_trust_id=org7_.id leftouterjoin rhnRegTokenOrgDefault org7_1_ on org7_.id=org7_1_.org_id where userimpl0_.id=0;
0.32s | select userimpl0_.id as id269_5_, userimpl0_.login as login269_5_, userimpl0_.login_uc as login3_269_5_, userimpl0_.password as password269_5_, userimpl0_.created as created269_5_, userimpl0_.modified as modified269_5_, userimpl0_.org_id as org7_269_5_, personalin1_.web_user_id as web1_267_0_, personalin1_.prefix as prefix267_0_, personalin1_.first_names as first3_267_0_, personalin1_.last_name as last4_267_0_, personalin1_.company as company267_0_, personalin1_.title as title267_0_, personalin1_.phone as phone267_0_, personalin1_.fax as fax267_0_, personalin1_.email as email267_0_, personalin1_.created as created267_0_, personalin1_.modified as modified267_0_, org2_.id as id159_1_, org2_.name as name159_1_, org2_.created as created159_1_, org2_.modified as modified159_1_, org2_1_.reg_token_id as reg2_162_1_, orgconfig3_.org_id as org1_163_2_, orgconfig3_.staging_content_enabled as staging2_163_2_, orgconfig3_.crash_reporting_enabled as crash3_163_2_, orgconfig3_.crashfile_upload_enabled as crashfile4_163_2_, orgconfig3_.crash_file_sizelimit as crash5_163_2_, orgconfig3_.scapfile_upload_enabled as scapfile6_163_2_, orgconfig3_.scap_file_sizelimit as scap7_163_2_, orgconfig3_.scap_retention_period_days as scap8_163_2_, entitlemen4_.org_id as org1_7_, orgentitle5_.id as entitlem2_7_, orgentitle5_.id as id164_3_, orgentitle5_.label as label164_3_, orgentitle5_.name as name164_3_, orgentitle5_.created as created164_3_, orgentitle5_.modified as modified164_3_, trustedorg6_.org_id as org1_8_, org7_.id as org2_8_, org7_.id as id159_4_, org7_.name as name159_4_, org7_.created as created159_4_, org7_.modified as modified159_4_, org7_1_.reg_token_id as reg2_162_4_ from WEB_CONTACT userimpl0_ innerjoin WEB_USER_PERSONAL_INFO personalin1_ on userimpl0_.id=personalin1_.web_user_id innerjoin WEB_CUSTOMER org2_ on userimpl0_.org_id=org2_.id leftouterjoin rhnRegTokenOrgDefault org2_1_ on org2_.id=org2_1_.org_id leftouterjoin rhnOrgConfiguration orgconfig3_ on org2_.id=orgconfig3_.org_id leftouterjoin rhnOrgEntitlements entitlemen4_ on org2_.id=entitlemen4_.org_id leftouterjoin RHNORGENTITLEMENTTYPE orgentitle5_ on entitlemen4_.entitlement_id=orgentitle5_.id leftouterjoin rhnTrustedOrgs trustedorg6_ on org2_.id=trustedorg6_.org_id leftouterjoin WEB_CUSTOMER org7_ on trustedorg6_.org_trust_id=org7_.id leftouterjoin rhnRegTokenOrgDefault org7_1_ on org7_.id=org7_1_.org_id where userimpl0_.id=3;
0.31s | select userimpl0_.id as id269_5_, userimpl0_.login as login269_5_, userimpl0_.login_uc as login3_269_5_, userimpl0_.password as password269_5_, userimpl0_.created as created269_5_, userimpl0_.modified as modified269_5_, userimpl0_.org_id as org7_269_5_, personalin1_.web_user_id as web1_267_0_, personalin1_.prefix as prefix267_0_, personalin1_.first_names as first3_267_0_, personalin1_.last_name as last4_267_0_, personalin1_.company as company267_0_, personalin1_.title as title267_0_, personalin1_.phone as phone267_0_, personalin1_.fax as fax267_0_, personalin1_.email as email267_0_, personalin1_.created as created267_0_, personalin1_.modified as modified267_0_, org2_.id as id159_1_, org2_.name as name159_1_, org2_.created as created159_1_, org2_.modified as modified159_1_, org2_1_.reg_token_id as reg2_162_1_, orgconfig3_.org_id as org1_163_2_, orgconfig3_.staging_content_enabled as staging2_163_2_, orgconfig3_.crash_reporting_enabled as crash3_163_2_, orgconfig3_.crashfile_upload_enabled as crashfile4_163_2_, orgconfig3_.crash_file_sizelimit as crash5_163_2_, orgconfig3_.scapfile_upload_enabled as scapfile6_163_2_, orgconfig3_.scap_file_sizelimit as scap7_163_2_, orgconfig3_.scap_retention_period_days as scap8_163_2_, entitlemen4_.org_id as org1_7_, orgentitle5_.id as entitlem2_7_, orgentitle5_.id as id164_3_, orgentitle5_.label as label164_3_, orgentitle5_.name as name164_3_, orgentitle5_.created as created164_3_, orgentitle5_.modified as modified164_3_, trustedorg6_.org_id as org1_8_, org7_.id as org2_8_, org7_.id as id159_4_, org7_.name as name159_4_, org7_.created as created159_4_, org7_.modified as modified159_4_, org7_1_.reg_token_id as reg2_162_4_ from WEB_CONTACT userimpl0_ innerjoin WEB_USER_PERSONAL_INFO personalin1_ on userimpl0_.id=personalin1_.web_user_id innerjoin WEB_CUSTOMER org2_ on userimpl0_.org_id=org2_.id leftouterjoin rhnRegTokenOrgDefault org2_1_ on org2_.id=org2_1_.org_id leftouterjoin rhnOrgConfiguration orgconfig3_ on org2_.id=orgconfig3_.org_id leftouterjoin rhnOrgEntitlements entitlemen4_ on org2_.id=entitlemen4_.org_id leftouterjoin RHNORGENTITLEMENTTYPE orgentitle5_ on entitlemen4_.entitlement_id=orgentitle5_.id leftouterjoin rhnTrustedOrgs trustedorg6_ on org2_.id=trustedorg6_.org_id leftouterjoin WEB_CUSTOMER org7_ on trustedorg6_.org_trust_id=org7_.id leftouterjoin rhnRegTokenOrgDefault org7_1_ on org7_.id=org7_1_.org_id where userimpl0_.id=3;
0.31s | select userimpl0_.id as id269_5_, userimpl0_.login as login269_5_, userimpl0_.login_uc as login3_269_5_, userimpl0_.password as password269_5_, userimpl0_.created as created269_5_, userimpl0_.modified as modified269_5_, userimpl0_.org_id as org7_269_5_, personalin1_.web_user_id as web1_267_0_, personalin1_.prefix as prefix267_0_, personalin1_.first_names as first3_267_0_, personalin1_.last_name as last4_267_0_, personalin1_.company as company267_0_, personalin1_.title as title267_0_, personalin1_.phone as phone267_0_, personalin1_.fax as fax267_0_, personalin1_.email as email267_0_, personalin1_.created as created267_0_, personalin1_.modified as modified267_0_, org2_.id as id159_1_, org2_.name as name159_1_, org2_.created as created159_1_, org2_.modified as modified159_1_, org2_1_.reg_token_id as reg2_162_1_, orgconfig3_.org_id as org1_163_2_, orgconfig3_.staging_content_enabled as staging2_163_2_, orgconfig3_.crash_reporting_enabled as crash3_163_2_, orgconfig3_.crashfile_upload_enabled as crashfile4_163_2_, orgconfig3_.crash_file_sizelimit as crash5_163_2_, orgconfig3_.scapfile_upload_enabled as scapfile6_163_2_, orgconfig3_.scap_file_sizelimit as scap7_163_2_, orgconfig3_.scap_retention_period_days as scap8_163_2_, entitlemen4_.org_id as org1_7_, orgentitle5_.id as entitlem2_7_, orgentitle5_.id as id164_3_, orgentitle5_.label as label164_3_, orgentitle5_.name as name164_3_, orgentitle5_.created as created164_3_, orgentitle5_.modified as modified164_3_, trustedorg6_.org_id as org1_8_, org7_.id as org2_8_, org7_.id as id159_4_, org7_.name as name159_4_, org7_.created as created159_4_, org7_.modified as modified159_4_, org7_1_.reg_token_id as reg2_162_4_ from WEB_CONTACT userimpl0_ innerjoin WEB_USER_PERSONAL_INFO personalin1_ on userimpl0_.id=personalin1_.web_user_id innerjoin WEB_CUSTOMER org2_ on userimpl0_.org_id=org2_.id leftouterjoin rhnRegTokenOrgDefault org2_1_ on org2_.id=org2_1_.org_id leftouterjoin rhnOrgConfiguration orgconfig3_ on org2_.id=orgconfig3_.org_id leftouterjoin rhnOrgEntitlements entitlemen4_ on org2_.id=entitlemen4_.org_id leftouterjoin RHNORGENTITLEMENTTYPE orgentitle5_ on entitlemen4_.entitlement_id=orgentitle5_.id leftouterjoin rhnTrustedOrgs trustedorg6_ on org2_.id=trustedorg6_.org_id leftouterjoin WEB_CUSTOMER org7_ on trustedorg6_.org_trust_id=org7_.id leftouterjoin rhnRegTokenOrgDefault org7_1_ on org7_.id=org7_1_.org_id where userimpl0_.id=3;
#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.29s | #011 update rhnPushClient#011 set state_id = 2#011 where state_id = 1#011 and last_ping_time is not null#011 and current_timestamp > next_action_time#011;
0.27s | #011 update rhnPushClient#011 set state_id = 2#011 where state_id = 1#011 and last_ping_time is not null#011 and current_timestamp > next_action_time#011;
0.26s | #011 update rhnPushClient#011 set state_id = 2#011 where state_id = 1#011 and last_ping_time is not null#011 and current_timestamp > next_action_time#011;