On 10. des. 2015 07:54, Silvio Moioli wrote:
<snip>
Thanks for taking time to look at this
Could you please share the results of the following queries:
EXPLAIN ANALYZE SELECT E.id, E.update_date, E.synopsis AS ADVISORY_SYNOPSIS
FROM rhnErrata E,
(SELECT SNEC.errata_id
FROM rhnServerNeededCache SNEC
WHERE SNEC.server_id IN (SELECT server_id FROM
rhnUserServerPerms USP WHERE USP.user_id = 13)
AND errata_id IS NOT NULL
GROUP BY SNEC.errata_id) X
WHERE E.id = X.errata_id
ORDER BY E.update_date DESC, E.id
I saved the output from this query here:
http://flipp.net/spacewalk.out1.txt
SELECT relname, relkind, reltuples, relpages FROM pg_class WHERE relname
LIKE 'rhn%' ORDER BY relname;
Output here: http://flipp.net/spacewalk.out2.txt
SELECT COUNT(*) FROM rhnErrata;
SELECT COUNT(*) FROM rhnServerNeededCache;
SELECT COUNT(*) FROM rhnUserServerPerms;
Output here: http://flipp.net/spacewalk.out3.txt
with regards,
--
Morten A. Middelthon
Development and Systems Administration
Last Friday
+47 907 83 708
[email protected]
_______________________________________________
Spacewalk-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-list
