On 11/02/18 00:20, Robert Klemme wrote:
On Mon, Feb 5, 2018 at 5:22 PM, Andrew Kerber wrote:
Have them check the memory and CPU allocation of the hypervisor, make sure
its not overallocated. Make sure the partitions for stroage are aligned (see
here:
https://blogs.vmware.com/vsphere/2011/08/g
+1 for atop. Be sure to adjust the sampling interval so it suits your
needs. It'll tell you what caused the spike.
Alternatively you could probably use sysdig, but I expect that'd result in
a fair performance hit if your system is already struggling.
Micky
On 14 February 2018 at 08:15, Gunnar "N
Am 06.02.2018 um 15:31 schrieb Thomas Güttler:
>
>
> Am 05.02.2018 um 14:26 schrieb Andreas Kretschmer:
>>
>>
>> Am 05.02.2018 um 14:14 schrieb Thomas Güttler:
>>> What do you suggest to get some reliable figures?
>>
>> sar is often recommended, see
>> https://blog.2ndquadrant.com/in-the-defense
Hello:
EXPLAIN (ANALYZE, BUFFERS)
select * from (
SELECT posts.id, users.name, posts.content
FROM posts JOIN users ON posts.user_id = users.id
WHERE posts.user_id IN (SELECT friend_user_id FROM friends WHERE user_id =
1)
ORDER BY posts.id DESC
) as a
ORDER BY a.id DESC
LIMIT 10;
--
EXPLAI
Hello,
I have the following schema:
CREATE TABLE users ( id BIGSERIAL PRIMARY KEY, name TEXT
NOT NULL UNIQUE ); CREATE TABLE friends ( user_id
BIGINT NOT NULL REFERENCES users, friend_user_id BIGINT NOT NULL
REFERENCES users, UNIQUE
