Just validate your environment once via the below states ...
-top -p $(pgrep -d',' postgres)
-Review the PostgreSQL logs (typically located in /var/log/postgresql/ or
/var/lib/pgsql/data/pg_log/)
-- check if any long running active query running via below query
SELECT pid, query, state, start_ti
On 2/4/25 09:11, KK CHN wrote:
List,
Could someone point out how can I trace what causes the edb-postgres
process with %CPU usage reaching 73 to 80.1 percentage in this box.
What's wrong with the server VM..
What version of EDB database are you using?
If it is not their install of the
List,
Could someone point out how can I trace what causes the edb-postgres
process with %CPU usage reaching 73 to 80.1 percentage in this box.
What's wrong with the server VM..
The clients connecting the databases experience slow responses ..
The top out put of the DB server is pasted below
ertan.kucuko...@1nar.com.tr schrieb am 20.10.2022 um 21:59:
Hello,
I am using PostgreSQL v14.5 on Linux Debian 11.5. I recently observe very
high CPU usage on my Linux system as below
PID USER PR NIVIRTRESSHR S %CPU %MEM TIME+
COMMAND
2357756 postgres 20 0
On 10/20/22 12:59, ertan.kucuko...@1nar.com.tr wrote:
Hello,
I am using PostgreSQL v14.5 on Linux Debian 11.5. I recently observe very
high CPU usage on my Linux system as below
PID USER PR NIVIRTRESSHR S %CPU %MEM TIME+
COMMAND
2357756 postgres 20 0 2441032
On 2022-10-20 15:59, ertan.kucuko...@1nar.com.tr wrote:
Hello,
I am using PostgreSQL v14.5 on Linux Debian 11.5. I recently observe very
high CPU usage on my Linux system as below
PID USER PR NIVIRTRESSHR S %CPU %MEM TIME+
COMMAND
2357756 postgres 20 0 2441032
Hello,
I am using PostgreSQL v14.5 on Linux Debian 11.5. I recently observe very
high CPU usage on my Linux system as below
PID USER PR NIVIRTRESSHR S %CPU %MEM TIME+
COMMAND
2357756 postgres 20 0 2441032 2,3g 4 S 298,7 67,9 2114:58
Tspjzj2Z
I could not
resolved. sorry for not posting the resolution earlier.
it was a good puzzler. turns out the postgresql server used
network-attached disks. and the updated table had no index for the
updated columns. so, the update required a serial scan of the table over
the network. thus, the high cpu usage
Kevin Wilkinson wrote:
> on 10.2, we're seeing very high cpu usage when doing an update statement
> on a relatively small table (1GB). one of the updated columns is text,
> about 1k bytes. there are four threads doing similar updates
> concurrently to the same table (but diff
On 4/5/19 5:45 PM, Kevin Wilkinson wrote:
on 10.2, we're seeing very high cpu usage when doing an update statement
on a relatively small table (1GB). one of the updated columns is text,
about 1k bytes. there are four threads doing similar updates concurrently
to the same table (but diff
on 10.2, we're seeing very high cpu usage when doing an update statement
on a relatively small table (1GB). one of the updated columns is text,
about 1k bytes. there are four threads doing similar updates
concurrently to the same table (but different rows). each thread does an
update
On Mon, Dec 25, 2017 at 06:12:05PM -0500, Melvin Davidson wrote:
> On Mon, Dec 25, 2017 at 1:28 PM, nikhil raj wrote:
>> Hi guys ,
>> when check the task manager I see these many postgres.exe are running. How
>> to identify which pid is running for which process please any one can help
>> me out.
On Mon, Dec 25, 2017 at 1:28 PM, nikhil raj wrote:
>
>
>
> Hi guys ,
> when check the task manager I see these many postgres.exe are running. How
> to identify which pid is running for which process please any one can help
> me out.
> or Why these many postgres.exe are running on the server
>
>
Hi guys ,
when check the task manager I see these many postgres.exe are running. How
to identify which pid is running for which process please any one can help
me out.
or Why these many postgres.exe are running on the server
[image: Inline image 1]
Thanks ,
Nikhil
14 matches
Mail list logo
