PostgreSQL make CPU Usage 100%?

Question

I'm using PostgreSQL in my WPF Application.

Sometime the PostgreSQL makes CPU Usage up-to 100%.

I have encountered this issue many time, but I don't know the reason.

The snapshot image in Task Manager is below

Note that, When this bug occurs, I kill my application exe, and wait for during 5 minutes after that, but the status in task manager still not change. CPU still 100%

I see that, it usually happens after Window Update. And I must restart the computer to by pass this.

I'm using PostgreSQL 9.3.

Anyone can show me the way to fix this.

Thank you :)

Yes, my app is running query frequently, so i think that at this time is not an exception. — TTGroup
– TTGroup, Commented Jan 16, 2019 at 3:56

Mike · Accepted Answer · 2019-01-16 04:53:28Z

6

If you are able to still access postgres, one thing I'd look at is do you have any queries that might be hung up

SELECT
  pid,
  now() - pg_stat_activity.xact_start AS duration,
  query,
  state
FROM pg_stat_activity
WHERE (now() - pg_stat_activity.query_start) > interval '4 minutes';

if there is indeed a query that has been alive longer than it should be, you can delete like so:

SELECT pg_cancel_backend(<pid>);

This might not be the problem, but it will at least reduce the number of possibilities.

answered Jan 16, 2019 at 4:53

Mike

6174 silver badges6 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

TTGroup Over a year ago

Thank you, I wil try and will let you know the result :)

Mahdi · Accepted Answer · 2019-11-04 16:35:23Z

1

most the time the problem appears if you do not use indexing in the database, use indexing for fields that are used frequently especially if you use "order by" or aggregation (such as sum and count)

answered Nov 4, 2019 at 16:35

Mahdi

8358 silver badges6 bronze badges

Collectives™ on Stack Overflow

PostgreSQL make CPU Usage 100%?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related