Spacewalk 2.1 Cfg Deploy 400 Systems

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

Generated on 2014-04-15 10:02
Parsed /home/stephand/i/dass/work/redhat/spacewalk/cfg_depl_ISE/spacewalk21_cfg_depl_ISE_400sys_pgsql.log (25,563 lines) in 2,000s
Log from 2014-04-15 09:30:38 to 2014-04-15 09:39:03
Executed on t420.fw.b4.mad

Overall statistics ^

Number of unique normalized queries: 124
Number of queries: 3,837
Total query duration: 10,210.6s
First query: 2014-04-15 09:30:38
Last query: 2014-04-15 09:39:03
Query peak: 175 queries/s at 2014-04-15 09:38:00

Queries by type ^

Type	Count	Percentage
SELECT	2,011	52.4
INSERT	551	14.4
UPDATE	187	4.9
DELETE	117	3.0

Queries that took up the most time (N) ^

Rank

Total duration

Times executed

Av. duration (ms)

Query

7,965.9s

885.10

update PXTSessions set value='', web_user_id=0, expires=0 where id=0;

1,131.6s

565.82

SELECT DISTINCT UAO.id AS ID,#0 UAO.earliest_action AS EARLIEST,#0 A.prerequisite AS PREREQUISITE,#0 UAO.type_name,#0 (CASE UAO.action_name WHEN NULL THEN UAO.type_name ELSE UAO.action_name END) AS ACTION_NAME,#0 UAO.scheduler,#0 WC.login AS SCHEDULER_NAME,#0 (SELECT COUNT(server_id) FROM rhnServerAction WHERE action_id = UAO.id AND status IN (...)) AS "IN_PROGRESS_SYSTEMS",#0 (SELECT COUNT(server_id) FROM rhnServerAction WHERE action_id = UAO.id AND status = 0) AS "COMPLETED_SYSTEMS",#0 (SELECT COUNT(server_id) FROM rhnServerAction WHERE action_id = UAO.id AND status = 0) AS "FAILED_SYSTEMS"#0 FROM rhnUserActionOverview UAO left join#0 web_contact WC on UAO.scheduler = WC.id,#0 rhnAction A#0 WHERE UAO.org_id = 0#0 AND UAO.user_id = 0#0 AND UAO.action_status_id IN (...)#0 AND UAO.archived = 0#0 AND UAO.id = A.id#0ORDER BY EARLIEST DESC;

243.0s

243.04

SELECT DISTINCT UAO.id AS ID,#011 UAO.earliest_action AS EARLIEST,#011 A.prerequisite AS PREREQUISITE,#011 UAO.type_name,#011 (CASE UAO.action_name WHEN NULL THEN UAO.type_name ELSE UAO.action_name END) AS ACTION_NAME,#011 UAO.scheduler,#011 (SELECT COUNT(server_id) FROM rhnServerAction WHERE action_id = UAO.id AND status IN (0,1)) AS "IN_PROGRESS_SYSTEMS",#011 (SELECT COUNT(server_id) FROM rhnServerAction WHERE action_id = UAO.id AND status = 2) AS "COMPLETED_SYSTEMS",#011 (SELECT COUNT(server_id) FROM rhnServerAction WHERE action_id = UAO.id AND status = 3) AS "FAILED_SYSTEMS"#011 FROM rhnUserActionOverview UAO, rhnAction A, rhnSet ST#011 WHERE UAO.org_id = 1#011 AND UAO.user_id = 3#011 AND UAO.action_status_id IN (0,1)#011 AND UAO.archived = 0#011 AND UAO.id = A.id#011 AND ST.user_id = 3#011 AND ST.label = 'pending_action_list'#011 AND ST.element = A.id#011ORDER BY EARLIEST DESC;

107.7s

1.71

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

102.5s

429

0.24

COMMIT;

65ms

21.68

SELECT ACR.server_id AS ID, count(*) AS config_files_with_differences#0 FROM#0 (SELECT rSA.server_id, MAX(rA.id)#0 FROM rhnAction rA#0 JOIN rhnServerAction rSA#0 ON rSA.action_id = rA.id#0 JOIN rhnActionStatus rAS#0 ON rAS.id = rSA.status#0 JOIN rhnActionType rAT#0 ON rAT.id = rA.action_type#0 WHERE RSA.server_id in (...)#0 AND rAS.name in (...)#0 AND rAT.label = ''#0 GROUP BY rSA.server_id#0 ) X#0 JOIN rhnActionConfigRevision ACR#0 ON X.server_id = ACR.server_id#0 JOIN rhnActionConfigRevisionResult ACRR#0 ON ACR.id = ACRR.action_config_revision_id#0 WHERE ACR.failure_id is null#0 AND ACRR.result is not null#0GROUP BY ACR.server_id;

34.99s | SELECT ACR.server_id AS ID, count(*) AS config_files_with_differences#011 FROM#011 (SELECT rSA.server_id, MAX(rA.id)#011 FROM rhnAction rA#011 JOIN rhnServerAction rSA#011 ON rSA.action_id = rA.id#011 JOIN rhnActionStatus rAS#011 ON rAS.id = rSA.status#011 JOIN rhnActionType rAT#011 ON rAT.id = rA.action_type#011 WHERE RSA.server_id in (1000010433, 1000010432, 1000010431, 1000010430, 1000010429)#011 AND rAS.name in ('Completed', 'Failed')#011 AND rAT.label = 'configfiles.diff'#011 GROUP BY rSA.server_id#011 ) X#011 JOIN rhnActionConfigRevision ACR#011 ON X.server_id = ACR.server_id#011 JOIN rhnActionConfigRevisionResult ACRR#011 ON ACR.id = ACRR.action_config_revision_id#011 WHERE ACR.failure_id is null#011 AND ACRR.result is not null#011GROUP BY ACR.server_id;

29.44s | SELECT ACR.server_id AS ID, count(*) AS config_files_with_differences#011 FROM#011 (SELECT rSA.server_id, MAX(rA.id)#011 FROM rhnAction rA#011 JOIN rhnServerAction rSA#011 ON rSA.action_id = rA.id#011 JOIN rhnActionStatus rAS#011 ON rAS.id = rSA.status#011 JOIN rhnActionType rAT#011 ON rAT.id = rA.action_type#011 WHERE RSA.server_id in (1000010433, 1000010432, 1000010431, 1000010430, 1000010429)#011 AND rAS.name in ('Completed', 'Failed')#011 AND rAT.label = 'configfiles.diff'#011 GROUP BY rSA.server_id#011 ) X#011 JOIN rhnActionConfigRevision ACR#011 ON X.server_id = ACR.server_id#011 JOIN rhnActionConfigRevisionResult ACRR#011 ON ACR.id = ACRR.action_config_revision_id#011 WHERE ACR.failure_id is null#011 AND ACRR.result is not null#011GROUP BY ACR.server_id;

0.60s | SELECT ACR.server_id AS ID, count(*) AS config_files_with_differences#011 FROM#011 (SELECT rSA.server_id, MAX(rA.id)#011 FROM rhnAction rA#011 JOIN rhnServerAction rSA#011 ON rSA.action_id = rA.id#011 JOIN rhnActionStatus rAS#011 ON rAS.id = rSA.status#011 JOIN rhnActionType rAT#011 ON rAT.id = rA.action_type#011 WHERE RSA.server_id in (1000010025, 1000010027)#011 AND rAS.name in ('Completed', 'Failed')#011 AND rAT.label = 'configfiles.diff'#011 GROUP BY rSA.server_id#011 ) X#011 JOIN rhnActionConfigRevision ACR#011 ON X.server_id = ACR.server_id#011 JOIN rhnActionConfigRevisionResult ACRR#011 ON ACR.id = ACRR.action_config_revision_id#011 WHERE ACR.failure_id is null#011 AND ACRR.result is not null#011GROUP BY ACR.server_id;

65ms

1.80

select * from logging.clear_log_id() as result;

64ms

275

0.23

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

48ms

48.10

SELECT S.id, S.NAME,#011 (SELECT 1#011 FROM rhnServerFeaturesView SFV#011 WHERE SFV.server_id = S.id#011 AND SFV.label = 'ftr_system_grouping') AS selectable#011 FROM rhnServerInfo SI,#011 rhnServer S#011 WHERE S.org_id = 1#011 AND EXISTS (SELECT 1 FROM rhnUserServerPerms USP WHERE USP.user_id = 3 AND USP.server_id = S.id)#011 AND SI.server_id = S.id#011 AND SI.checkin < current_timestamp - numtodsinterval(1 * 86400, 'second')#011ORDER BY SI.checkin DESC;

47ms

46.71

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;

45ms

358

0.13

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

41ms

41.23

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;

28ms

13.84

SELECT id from rhnDevice;

20ms

0.57

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

20ms

19.81

SELECT S.id, S.NAME, S.info, S.created,#011 (SELECT 1#011 FROM rhnServerFeaturesView SFV#011 WHERE SFV.server_id = S.id#011 AND SFV.label = 'ftr_system_grouping') AS selectable,#011#011#011(select C.name#011#011#011#011from rhnChannel C#011#011#011#011inner join rhnServerChannel SC on SC.channel_id = C.id#011 #011#011#011where SC.server_id = S.id#011#011#011#011and C.parent_channel IS NULL) AS CHANNEL_LABELS,#011 (SELECT wc.login#011 FROM web_contact wc#011 WHERE wc.id = s.creator_id) as creator_name#011 FROM rhnServer S#011 WHERE S.org_id = 1#011 AND EXISTS (SELECT 1 FROM rhnUserServerPerms USP WHERE USP.user_id = 3 AND USP.server_id = S.id)#011 AND S.created > current_timestamp - numtodsinterval(30 * 86400, 'second')#011ORDER BY S.created DESC;

15ms

7.60

SELECT UAO.id,#0 UAO.action_status,#0 UAO.tally#0 FROM rhnUserActionOverview UAO#0 WHERE UAO.org_id = 0#0 AND UAO.user_id = 0#0 AND UAO.id IN (...);

7.68s | SELECT UAO.id,#011 UAO.action_status,#011 UAO.tally#011 FROM rhnUserActionOverview UAO#011 WHERE UAO.org_id = 1#011 AND UAO.user_id = 3#011 AND UAO.id IN (10964, 10965, 10966, 10967, 10968, 10969, 10970, 10971, 10972, 10973, 10974, 10975, 10976, 10977, 10978, 10979, 10980, 10981, 10982, 10983, 10984, 10985, 10986, 10987, 10988, 10989, 10990, 10991, 10992, 10993, 10994, 10995, 10996, 10997, 10998, 10999, 11000, 11001, 11002, 11003, 11004, 11005, 11006, 11007, 11008, 11009, 11010, 11011, 11012, 11013, 11014, 11015, 11016, 11017, 11018, 11019, 11020, 11021, 11022, 11023, 11024, 11025, 11026, 11027, 11028, 11029, 11030, 11031, 11032, 11033, 11034, 11035, 11036, 11037, 11038, 11039, 11040, 11041, 11042, 11043, 11044, 11045, 11046, 11047, 11048, 11049, 11050, 11051, 11052, 11053, 11054, 11055, 11056, 11057, 11058, 11059, 11060, 11061, 11062, 11063, 11064, 11065, 11066, 11067, 11068, 11069, 11070, 11071, 11072, 11073, 11074, 11075, 11076, 11077, 11078, 11079, 11080, 11081, 11082, 11083, 11084, 11085, 11086, 11087, 11088, 11089, 11090, 11091, 11092, 11093, 11094, 11095, 11096, 11097, 11098, 11099, 11100, 11101, 11102, 11103, 11104, 11105, 11106, 11107, 11108, 11109, 11110, 11111, 11112, 11113, 11114, 11115, 11116, 11117, 11118, 11119, 11120, 11121, 11122, 11123, 11124, 11125, 11126, 11127, 11128, 11129, 11130, 11131, 11132, 11133, 11134, 11135, 11136, 11137, 11138, 11139, 11140, 11141, 11142, 11143, 11144, 11145, 11146, 11147, 11148, 11149, 11150, 11151, 11152, 11153, 11154, 11155, 11156, 11157, 11158, 11159, 11160, 11161, 11162, 11163, 11164, 11165, 11166, 11167, 11168, 11169, 11170, 11171, 11172, 11173, 11174, 11175, 11176, 11177, 11178, 11179, 11180, 11181, 11182, 11183, 11184, 11185, 11186, 11187, 11188, 11189, 11190, 11191, 11192, 11193, 11194, 11195, 11196, 11197, 11198, 11199, 11200, 11201, 11202, 11203, 11204, 11205, 11206, 11207, 11208, 11209, 11210, 11211, 11212, 11213, 11214, 11215, 11216, 11217, 11218, 11219, 11220, 11221, 11222, 11223, 11224, 11225, 11226, 11227, 11228, 11229, 11230, 11231, 11232, 11233, 11234, 11235, 11236, 11237, 11238, 11239, 11240, 11241, 11242, 11243, 11244, 11245, 11246, 11247, 11248, 11249, 11250, 11251, 11252, 11253, 11254, 11255, 11256, 11257, 11258, 11259, 11260, 11261, 11262, 11263, 11264, 11265, 11266, 11267, 11268, 11269, 11270, 11271, 11272, 11273, 11274, 11275, 11276, 11277, 11278, 11279, 11280, 11281, 11282, 11283, 11284, 11285, 11286, 11287, 11288, 11289, 11290, 11291, 11292, 11293, 11294, 11295, 11296, 11297, 11298, 11299, 11300, 11301, 11302, 11303, 11304, 11305, 11306, 11307, 11308, 11309, 11310, 11311, 11312, 11313, 11314, 11315, 11316, 11317, 11318, 11319, 11320, 11321, 11322, 11323, 11324, 11325, 11326, 11327, 11328, 11329, 11330, 11331, 11332, 11333, 11334, 11335, 11336, 11337, 11338, 11339, 11340, 11341, 11342, 11343, 11344, 11345, 11346, 11347, 11348, 11349, 11350, 11351, 11352, 11353, 11354, 11355, 11356, 11357, 11358, 11359, 11360, 11361, 11362, 11363);

7.52s | SELECT UAO.id,#011 UAO.action_status,#011 UAO.tally#011 FROM rhnUserActionOverview UAO#011 WHERE UAO.org_id = 1#011 AND UAO.user_id = 3#011 AND UAO.id IN (10964, 10965, 10966, 10967, 10968, 10969, 10970, 10971, 10972, 10973, 10974, 10975, 10976, 10977, 10978, 10979, 10980, 10981, 10982, 10983, 10984, 10985, 10986, 10987, 10988, 10989, 10990, 10991, 10992, 10993, 10994, 10995, 10996, 10997, 10998, 10999, 11000, 11001, 11002, 11003, 11004, 11005, 11006, 11007, 11008, 11009, 11010, 11011, 11012, 11013, 11014, 11015, 11016, 11017, 11018, 11019, 11020, 11021, 11022, 11023, 11024, 11025, 11026, 11027, 11028, 11029, 11030, 11031, 11032, 11033, 11034, 11035, 11036, 11037, 11038, 11039, 11040, 11041, 11042, 11043, 11044, 11045, 11046, 11047, 11048, 11049, 11050, 11051, 11052, 11053, 11054, 11055, 11056, 11057, 11058, 11059, 11060, 11061, 11062, 11063, 11064, 11065, 11066, 11067, 11068, 11069, 11070, 11071, 11072, 11073, 11074, 11075, 11076, 11077, 11078, 11079, 11080, 11081, 11082, 11083, 11084, 11085, 11086, 11087, 11088, 11089, 11090, 11091, 11092, 11093, 11094, 11095, 11096, 11097, 11098, 11099, 11100, 11101, 11102, 11103, 11104, 11105, 11106, 11107, 11108, 11109, 11110, 11111, 11112, 11113, 11114, 11115, 11116, 11117, 11118, 11119, 11120, 11121, 11122, 11123, 11124, 11125, 11126, 11127, 11128, 11129, 11130, 11131, 11132, 11133, 11134, 11135, 11136, 11137, 11138, 11139, 11140, 11141, 11142, 11143, 11144, 11145, 11146, 11147, 11148, 11149, 11150, 11151, 11152, 11153, 11154, 11155, 11156, 11157, 11158, 11159, 11160, 11161, 11162, 11163, 11164, 11165, 11166, 11167, 11168, 11169, 11170, 11171, 11172, 11173, 11174, 11175, 11176, 11177, 11178, 11179, 11180, 11181, 11182, 11183, 11184, 11185, 11186, 11187, 11188, 11189, 11190, 11191, 11192, 11193, 11194, 11195, 11196, 11197, 11198, 11199, 11200, 11201, 11202, 11203, 11204, 11205, 11206, 11207, 11208, 11209, 11210, 11211, 11212, 11213, 11214, 11215, 11216, 11217, 11218, 11219, 11220, 11221, 11222, 11223, 11224, 11225, 11226, 11227, 11228, 11229, 11230, 11231, 11232, 11233, 11234, 11235, 11236, 11237, 11238, 11239, 11240, 11241, 11242, 11243, 11244, 11245, 11246, 11247, 11248, 11249, 11250, 11251, 11252, 11253, 11254, 11255, 11256, 11257, 11258, 11259, 11260, 11261, 11262, 11263, 11264, 11265, 11266, 11267, 11268, 11269, 11270, 11271, 11272, 11273, 11274, 11275, 11276, 11277, 11278, 11279, 11280, 11281, 11282, 11283, 11284, 11285, 11286, 11287, 11288, 11289, 11290, 11291, 11292, 11293, 11294, 11295, 11296, 11297, 11298, 11299, 11300, 11301, 11302, 11303, 11304, 11305, 11306, 11307, 11308, 11309, 11310, 11311, 11312, 11313, 11314, 11315, 11316, 11317, 11318, 11319, 11320, 11321, 11322, 11323, 11324, 11325, 11326, 11327, 11328, 11329, 11330, 11331, 11332, 11333, 11334, 11335, 11336, 11337, 11338, 11339, 11340, 11341, 11342, 11343, 11344, 11345, 11346, 11347, 11348, 11349, 11350, 11351, 11352, 11353, 11354, 11355, 11356, 11357, 11358, 11359, 11360, 11361, 11362, 11363);

15ms

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;

14ms

7.10

SELECT E.id, E.update_date, E.synopsis as advisory_synopsis#0 FROM rhnErrata E,#0 (SELECT SNEC.errata_id, COUNT(SNEC.server_id) C#0 FROM rhnServerNeededPackageCache SNEC#0 WHERE SNEC.server_id IN (SELECT server_id FROM rhnUserServerPerms USP WHERE USP.user_id = 0)#0 AND errata_id IS NOT NULL#0 GROUP BY SNEC.errata_id) X#0 WHERE E.id = X.errata_id#0 AND E.advisory_type = ''#0ORDER BY E.update_date DESC, E.id;

9ms

9.23

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;

9ms

0.94

select * from rhn_synch_probe_state() as result;

Slowest queries ^

Rank	Duration (ms)	Query
1	7,964.92	update PXTSessions set value=' ', web_user_id=3, expires=1397551059 where id=36304;
2	1,042.14	SELECT DISTINCT UAO.id AS ID,#011 UAO.earliest_action AS EARLIEST,#011 A.prerequisite AS PREREQUISITE,#011 UAO.type_name,#011 (CASE UAO.action_name WHEN NULL THEN UAO.type_name ELSE UAO.action_name END) AS ACTION_NAME,#011 UAO.scheduler,#011 WC.login AS SCHEDULER_NAME,#011 (SELECT COUNT(server_id) FROM rhnServerAction WHERE action_id = UAO.id AND status IN (0,1)) AS "IN_PROGRESS_SYSTEMS",#011 (SELECT COUNT(server_id) FROM rhnServerAction WHERE action_id = UAO.id AND status = 2) AS "COMPLETED_SYSTEMS",#011 (SELECT COUNT(server_id) FROM rhnServerAction WHERE action_id = UAO.id AND status = 3) AS "FAILED_SYSTEMS"#011 FROM rhnUserActionOverview UAO left join#011 web_contact WC on UAO.scheduler = WC.id,#011 rhnAction A#011 WHERE UAO.org_id = 1#011 AND UAO.user_id = 3#011 AND UAO.action_status_id IN (0,1)#011 AND UAO.archived = 0#011 AND UAO.id = A.id#011ORDER BY EARLIEST DESC;
3	243.04	SELECT DISTINCT UAO.id AS ID,#011 UAO.earliest_action AS EARLIEST,#011 A.prerequisite AS PREREQUISITE,#011 UAO.type_name,#011 (CASE UAO.action_name WHEN NULL THEN UAO.type_name ELSE UAO.action_name END) AS ACTION_NAME,#011 UAO.scheduler,#011 (SELECT COUNT(server_id) FROM rhnServerAction WHERE action_id = UAO.id AND status IN (0,1)) AS "IN_PROGRESS_SYSTEMS",#011 (SELECT COUNT(server_id) FROM rhnServerAction WHERE action_id = UAO.id AND status = 2) AS "COMPLETED_SYSTEMS",#011 (SELECT COUNT(server_id) FROM rhnServerAction WHERE action_id = UAO.id AND status = 3) AS "FAILED_SYSTEMS"#011 FROM rhnUserActionOverview UAO, rhnAction A, rhnSet ST#011 WHERE UAO.org_id = 1#011 AND UAO.user_id = 3#011 AND UAO.action_status_id IN (0,1)#011 AND UAO.archived = 0#011 AND UAO.id = A.id#011 AND ST.user_id = 3#011 AND ST.label = 'pending_action_list'#011 AND ST.element = A.id#011ORDER BY EARLIEST DESC;
4	89.50	SELECT DISTINCT UAO.id AS ID,#011 UAO.earliest_action AS EARLIEST,#011 A.prerequisite AS PREREQUISITE,#011 UAO.type_name,#011 (CASE UAO.action_name WHEN NULL THEN UAO.type_name ELSE UAO.action_name END) AS ACTION_NAME,#011 UAO.scheduler,#011 WC.login AS SCHEDULER_NAME,#011 (SELECT COUNT(server_id) FROM rhnServerAction WHERE action_id = UAO.id AND status IN (0,1)) AS "IN_PROGRESS_SYSTEMS",#011 (SELECT COUNT(server_id) FROM rhnServerAction WHERE action_id = UAO.id AND status = 2) AS "COMPLETED_SYSTEMS",#011 (SELECT COUNT(server_id) FROM rhnServerAction WHERE action_id = UAO.id AND status = 3) AS "FAILED_SYSTEMS"#011 FROM rhnUserActionOverview UAO left join#011 web_contact WC on UAO.scheduler = WC.id,#011 rhnAction A#011 WHERE UAO.org_id = 1#011 AND UAO.user_id = 3#011 AND UAO.action_status_id IN (0,1)#011 AND UAO.archived = 0#011 AND UAO.id = A.id#011ORDER BY EARLIEST DESC;
5	48.10	SELECT S.id, S.NAME,#011 (SELECT 1#011 FROM rhnServerFeaturesView SFV#011 WHERE SFV.server_id = S.id#011 AND SFV.label = 'ftr_system_grouping') AS selectable#011 FROM rhnServerInfo SI,#011 rhnServer S#011 WHERE S.org_id = 1#011 AND EXISTS (SELECT 1 FROM rhnUserServerPerms USP WHERE USP.user_id = 3 AND USP.server_id = S.id)#011 AND SI.server_id = S.id#011 AND SI.checkin < current_timestamp - numtodsinterval(1 * 86400, 'second')#011ORDER BY SI.checkin DESC;
6	46.71	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	41.23	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;
8	34.99	SELECT ACR.server_id AS ID, count(*) AS config_files_with_differences#011 FROM#011 (SELECT rSA.server_id, MAX(rA.id)#011 FROM rhnAction rA#011 JOIN rhnServerAction rSA#011 ON rSA.action_id = rA.id#011 JOIN rhnActionStatus rAS#011 ON rAS.id = rSA.status#011 JOIN rhnActionType rAT#011 ON rAT.id = rA.action_type#011 WHERE RSA.server_id in (1000010433, 1000010432, 1000010431, 1000010430, 1000010429)#011 AND rAS.name in ('Completed', 'Failed')#011 AND rAT.label = 'configfiles.diff'#011 GROUP BY rSA.server_id#011 ) X#011 JOIN rhnActionConfigRevision ACR#011 ON X.server_id = ACR.server_id#011 JOIN rhnActionConfigRevisionResult ACRR#011 ON ACR.id = ACRR.action_config_revision_id#011 WHERE ACR.failure_id is null#011 AND ACRR.result is not null#011GROUP BY ACR.server_id;
9	29.44	SELECT ACR.server_id AS ID, count(*) AS config_files_with_differences#011 FROM#011 (SELECT rSA.server_id, MAX(rA.id)#011 FROM rhnAction rA#011 JOIN rhnServerAction rSA#011 ON rSA.action_id = rA.id#011 JOIN rhnActionStatus rAS#011 ON rAS.id = rSA.status#011 JOIN rhnActionType rAT#011 ON rAT.id = rA.action_type#011 WHERE RSA.server_id in (1000010433, 1000010432, 1000010431, 1000010430, 1000010429)#011 AND rAS.name in ('Completed', 'Failed')#011 AND rAT.label = 'configfiles.diff'#011 GROUP BY rSA.server_id#011 ) X#011 JOIN rhnActionConfigRevision ACR#011 ON X.server_id = ACR.server_id#011 JOIN rhnActionConfigRevisionResult ACRR#011 ON ACR.id = ACRR.action_config_revision_id#011 WHERE ACR.failure_id is null#011 AND ACRR.result is not null#011GROUP BY ACR.server_id;
10	20.26	SELECT id from rhnDevice;
11	19.81	SELECT S.id, S.NAME, S.info, S.created,#011 (SELECT 1#011 FROM rhnServerFeaturesView SFV#011 WHERE SFV.server_id = S.id#011 AND SFV.label = 'ftr_system_grouping') AS selectable,#011#011#011(select C.name#011#011#011#011from rhnChannel C#011#011#011#011inner join rhnServerChannel SC on SC.channel_id = C.id#011 #011#011#011where SC.server_id = S.id#011#011#011#011and C.parent_channel IS NULL) AS CHANNEL_LABELS,#011 (SELECT wc.login#011 FROM web_contact wc#011 WHERE wc.id = s.creator_id) as creator_name#011 FROM rhnServer S#011 WHERE S.org_id = 1#011 AND EXISTS (SELECT 1 FROM rhnUserServerPerms USP WHERE USP.user_id = 3 AND USP.server_id = S.id)#011 AND S.created > current_timestamp - numtodsinterval(30 * 86400, 'second')#011ORDER BY S.created DESC;
12	13.30	select * from logging.clear_log_id() as result;
13	11.90	select * from logging.clear_log_id() as result;
14	11.87	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', 938123);
15	10.31	SELECT E.id, E.update_date, E.synopsis as advisory_synopsis#011 FROM rhnErrata E,#011 (SELECT SNEC.errata_id, COUNT(SNEC.server_id) C#011 FROM rhnServerNeededPackageCache SNEC#011 WHERE SNEC.server_id IN (SELECT server_id FROM rhnUserServerPerms USP WHERE USP.user_id = 3)#011 AND errata_id IS NOT NULL#011 GROUP BY SNEC.errata_id) X#011 WHERE E.id = X.errata_id#011 AND E.advisory_type = 'Security Advisory'#011ORDER BY E.update_date DESC, E.id;
16	9.23	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;
17	8.64	select * from logging.clear_log_id() as result;
18	8.57	select * from logging.clear_log_id() as result;
19	8.39	select * from logging.clear_log_id() as result;
20	8.20	SELECT DISTINCT S.id,#011 S.name,#011 SI.server_id AS IS_RHN_SATELLITE,#011 PI.server_id AS IS_RHN_PROXY,#011 TO_CHAR(Sinfo.checkin, 'YYYY-MM-DD HH24:MI:SS') AS LAST_CHECKIN,#011 (SELECT 1#011 FROM rhnServerFeaturesView SFV#011 WHERE SFV.server_id = S.id#011 AND SFV.label = 'ftr_system_grouping') AS selectable#011 FROM rhnServerInfo SInfo, rhnUserServerPerms USP, rhnServer S#011 LEFT OUTER JOIN rhnSatelliteInfo SI ON S.id = SI.server_id#011 LEFT OUTER JOIN rhnProxyInfo PI ON S.id = PI.server_id#011 WHERE USP.user_id = 3#011 AND S.id = USP.server_id#011 AND Sinfo.server_id = S.id#011 AND ((SELECT count (*) FROM rhnServerErrataTypeView setv WHERE setv.server_id = s.id) > 0);

Most frequent queries (N) ^

Rank

Times executed

Total duration

Av. duration (ms)

Query

451

5ms

0.01

select nextval ('');

429

102.5s

0.24

COMMIT;

358

45ms

0.13

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

331

2ms

0.00

BEGIN;

275

64ms

0.23

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

203

3ms

0.01

select '' from dual;

3ms

0.04

DELETE FROM QRTZ_FIRED_TRIGGERS WHERE ENTRY_ID = '';

107.7s

1.71

15ms

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;

8ms

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;

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;

0.19s | SELECT COALESCE( ( SELECT CR.id#011 FROM rhnConfigChannel CC, rhnConfigChannelType CCT,#011 rhnConfigRevision CR, rhnServerConfigChannel SCC, rhnConfigFile CF#011 WHERE SCC.server_id = 1000010080#011 AND CF.config_channel_id = SCC.config_channel_id#011 AND CF.config_file_name_id = 8#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 = 8#011 AND CF.config_channel_id = SCC.config_channel_id#011 AND SCC.server_id = 1000010080#011 AND SCC.position = ( SELECT min(SCC.position)#011 FROM rhnServerConfigChannel SCC, rhnConfigFile CF#011 WHERE SCC.server_id = 1000010080#011 AND CF.config_channel_id = SCC.config_channel_id#011 AND CF.config_file_name_id = 8 ) ) ) AS id#011 FROM dual;

0.12s | SELECT COALESCE( ( SELECT CR.id#011 FROM rhnConfigChannel CC, rhnConfigChannelType CCT,#011 rhnConfigRevision CR, rhnServerConfigChannel SCC, rhnConfigFile CF#011 WHERE SCC.server_id = 1000010178#011 AND CF.config_channel_id = SCC.config_channel_id#011 AND CF.config_file_name_id = 17#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 = 17#011 AND CF.config_channel_id = SCC.config_channel_id#011 AND SCC.server_id = 1000010178#011 AND SCC.position = ( SELECT min(SCC.position)#011 FROM rhnServerConfigChannel SCC, rhnConfigFile CF#011 WHERE SCC.server_id = 1000010178#011 AND CF.config_channel_id = SCC.config_channel_id#011 AND CF.config_file_name_id = 17 ) ) ) AS id#011 FROM dual;

0.12s | SELECT COALESCE( ( SELECT CR.id#011 FROM rhnConfigChannel CC, rhnConfigChannelType CCT,#011 rhnConfigRevision CR, rhnServerConfigChannel SCC, rhnConfigFile CF#011 WHERE SCC.server_id = 1000010376#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 = 1000010376#011 AND SCC.position = ( SELECT min(SCC.position)#011 FROM rhnServerConfigChannel SCC, rhnConfigFile CF#011 WHERE SCC.server_id = 1000010376#011 AND CF.config_channel_id = SCC.config_channel_id#011 AND CF.config_file_name_id = 14 ) ) ) AS id#011 FROM dual;

2ms

0.04

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;

65ms

1.80

select * from logging.clear_log_id() as result;

7ms

0.20

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

7ms

0.20

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

7ms

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

6ms

0.16

3ms

0.08

UPDATE QRTZ_CRON_TRIGGERS SET CRON_EXPRESSION = '' WHERE TRIGGER_NAME = '' AND TRIGGER_GROUP = '';

1ms

0.03

select taskosched0_.id as id2_, taskosched0_.job_label as job2_2_, taskosched0_.bunch_id as bunch3_2_, taskosched0_.org_id as org4_2_, taskosched0_.active_from as active5_2_, taskosched0_.active_till as active6_2_, taskosched0_.cron_expr as cron7_2_, taskosched0_.data as data2_, taskosched0_.created as created2_, taskosched0_.modified as modified2_ from rhnTaskoSchedule taskosched0_ where taskosched0_.id=0;

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;

Slowest queries (N) ^

Rank

Av. duration (ms)

Times executed

Total duration

Query

885.10

7,965.9s

update PXTSessions set value='', web_user_id=0, expires=0 where id=0;

565.82

1,131.6s

243.04

243.0s

48.10

48ms

46.71

47ms

41.23

41ms

21.68

65ms

19.81

20ms

13.84

28ms

SELECT id from rhnDevice;

9.23

9ms

8.20

8ms

SELECT DISTINCT S.id,#011 S.name,#011 SI.server_id AS IS_RHN_SATELLITE,#011 PI.server_id AS IS_RHN_PROXY,#011 TO_CHAR(Sinfo.checkin, 'YYYY-MM-DD HH24:MI:SS') AS LAST_CHECKIN,#011 (SELECT 1#011 FROM rhnServerFeaturesView SFV#011 WHERE SFV.server_id = S.id#011 AND SFV.label = 'ftr_system_grouping') AS selectable#011 FROM rhnServerInfo SInfo, rhnUserServerPerms USP, rhnServer S#011 LEFT OUTER JOIN rhnSatelliteInfo SI ON S.id = SI.server_id#011 LEFT OUTER JOIN rhnProxyInfo PI ON S.id = PI.server_id#011 WHERE USP.user_id = 3#011 AND S.id = USP.server_id#011 AND Sinfo.server_id = S.id#011 AND ((SELECT count (*) FROM rhnServerErrataTypeView setv WHERE setv.server_id = s.id) > 0);

7.60

15ms

SELECT UAO.id,#0 UAO.action_status,#0 UAO.tally#0 FROM rhnUserActionOverview UAO#0 WHERE UAO.org_id = 0#0 AND UAO.user_id = 0#0 AND UAO.id IN (...);

7.10

14ms

4.17

4ms

3.00

3ms

SELECT#011 G.ID AS ID, G.NAME AS NAME,#011#011#011 (SELECT COUNT(*) FROM rhnUserManagedServerGroups UMSG WHERE UMSG.server_group_id = G.id)#011 AS GROUP_ADMINS,#011#011#011#011(SELECT COUNT(*) FROM rhnServerGroupMembers SGM WHERE SGM.server_group_id = G.id#011 AND EXISTS ( SELECT 1#011 FROM rhnServerFeaturesView SFV#011 WHERE SFV.server_id = SGM.server_id#011 AND SFV.label = 'ftr_system_grouping')) AS SERVER_COUNT,#011 (SELECT CASE MAX(CASE PS.state#011 WHEN 'OK' THEN 1#011 WHEN 'PENDING' THEN 2#011 WHEN 'UNKNOWN' THEN 3#011 WHEN 'WARNING' THEN 4#011 WHEN 'CRITICAL' THEN 5 END)#011 WHEN 1 THEN 'OK'#011 WHEN 2 THEN 'PENDING';

2.99

3ms

SELECT SERVER_ID AS ID, SECURITY_ERRATA, BUG_ERRATA, ENHANCEMENT_ERRATA, OUTDATED_PACKAGES, SERVER_NAME,#011 SERVER_ADMINS, GROUP_COUNT, MODIFIED, CHANNEL_LABELS, HISTORY_COUNT,#011 LAST_CHECKIN_DAYS_AGO, PENDING_UPDATES, OS, RELEASE, SERVER_ARCH_NAME, LAST_CHECKIN, LOCKED#011 FROM rhnServerOverview#011 WHERE server_id IN (1000010025, 1000010027)#011ORDER BY SECURITY_ERRATA DESC, BUG_ERRATA DESC, ENHANCEMENT_ERRATA DESC;

2.31

7ms

SELECT COUNT(CF.id) AS num_files#0 FROM rhnconfigfile CF,#0#0 rhnconfigrevision CR,#0#0 rhnconfigfiletype CFT#0 WHERE CF.config_channel_id = 0#0 AND CF.latest_config_revision_id = CR.id#0 AND CR.config_file_type_id = CFT.id#0 AND CFT.label = ''#0 AND rhn_config_channel.get_user_file_access(CF.id, 0) = 0;

1.92

4ms

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;

1.85

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.80

65ms

select * from logging.clear_log_id() as result;