I have PostgreSQL superuser called "admin" which can connect to a PostgreSQL database.
I am not managing the database server. I have no root-access to this machine.
Sometimes the performance is not good.
Up to now I have no numbers, but I would like to have some.
Is there a (common) way to do small benchmarks on the production db to see how it performs?
I have something like this on my mind: Every ten minutes some magic sql commands get execute which give me some numbers. I would like to see CPU/MEM/IO usage/performance.
The same queries lead to different performance. I guess the hypervisor hosting the PostgreSQL VM is overloaded from time to time
The current situation is not nice for me, since the customer sees the slow application, and blames me. But it is not me, it is the slow DB.
How can I proof that the DB is slow, and not the application?
(I guess this situation is common. How to do handle this?)