[Spacewalk-list] PostgreSQL performance problems

[Morten A. Middelthon]

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
mm at lastfriday.com